ZQHApi.git - Gitblit

			@@ -74,8 +74,7 @@
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select case when A.status='NEW' then '新订单' when A.status='CHECK' then '已审核' when A.status='CLOSED' then '已关闭' end as status,
			A.orderdate,A.ordercode,T.org_name as deptname,C.name as customername,A.saleorderCode,A.acceptdate,A.lm_user,A.lm_date,U.username as auditoruser,A.auditordate
			var sql = @"select A.status,A.orderdate,A.ordercode,T.org_name as deptname,C.name as customername,A.saleorderCode,A.acceptdate,A.lm_user,A.lm_date,U.username as auditoruser,A.auditordate
			from T_PurchaseOrder A
			left join TOrganization T on A.departmentcode=T.org_code
			left join TCustomer C on A.customercode=C.code
			@@ -106,13 +105,13 @@
			try
			{
			//获取采购订单物料信息
			sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,
			sql = @"select M.partcode,M.partname,M.partspec,T.name as uomname,A.quantity,A.countarrivalquantity,A.countInquantity,A.countreturnquantity,
			A.acceptdate,S.name as housename,M.is_incheck
			from T_PurchaseOrder_sub A
			left join TMateriel_Info M on A.materiel_code=M.partcode
			left join TUom T on M.uom_code=T.code
			left join T_Sec_Stck S on A.warehousecode=S.code
			where A.purchaesorder_code=@purodercode";
			where A.purchaseorder_code=@purodercode";
			dynamicParams.Add("@purodercode", purodercode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			@@ -232,8 +231,18 @@
			var dynamicParams = new DynamicParameters();
			try
			{
			//判断是否生成采购到货单

			//判断是否生成了采购到货单
			sql = @"select * from T_PurchaseArrivalOrder where hsourcebillno=@po";
			dynamicParams.Add("@po", po);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			if (data.Rows.Count > 0)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "当前采购订单已生成到货单!";
			mes.data = null;
			return mes;
			}
			//更新采购订单主表审核人、审核时间
			sql = @"update T_PurchaseOrder set auditorusercode=@username,auditordate=@lm_date where ordercode=@po";
			list.Add(new { str = sql, parm = new { username="",po = po, lm_date ="" } });
			@@ -264,5 +273,227 @@
			return mes;
			}
			#endregion

			#region[采购订单关闭]
			public static ToMessage ClosedPurchaseOrder(string po, string username)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			//更新采购订单状态
			sql = @"update T_PurchaseOrder set status='CLOSED' where ordercode=@po";
			list.Add(new { str = sql, parm = new { po = po} });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion



			#region[采购到货单查询]
			public static ToMessage PurchaseArrivalOrderSearch(string orderstatus, string mesordercode, string departmentcode, string customercode, string orderdateopendate, string orderdateclosedate, string sourceorder, string creatuser, string arrivalopendate, string arrivalclosedate, int startNum, int endNum, string prop, string order)
			{
			var dynamicParams = new DynamicParameters();
			string search = "";
			try
			{
			if (orderstatus != "" && orderstatus != null)
			{
			search += "and A.hbillstaus=@orderstatus ";
			dynamicParams.Add("@orderstatus", orderstatus);
			}
			if (mesordercode != "" && mesordercode != null)
			{
			search += "and A.hbillno like '%'+@mesordercode+'%' ";
			dynamicParams.Add("@mesordercode", mesordercode);
			}
			if (departmentcode != "" && departmentcode != null)
			{
			search += "and A.hdepartmentcode=@departmentcode ";
			dynamicParams.Add("@departmentcode", departmentcode);
			}
			if (customercode != "" && customercode != null)
			{
			search += "and A.hcustomercode=@customercode ";
			dynamicParams.Add("@customercode", customercode);
			}
			if (sourceorder != "" && sourceorder != null)
			{
			search += "and A.hsourcebillno like '%'+@sourceorder+'%' ";
			dynamicParams.Add("@sourceorder", sourceorder);
			}
			if (orderdateopendate != "" && orderdateopendate != null)
			{
			search += "and A.hdate between @orderdateopendate and @orderdateclosedate ";
			dynamicParams.Add("@orderdateopendate", orderdateopendate + " 00:00:00");
			dynamicParams.Add("@orderdateclosedate", orderdateclosedate + " 23:59:59");
			}
			if (creatuser != "" && creatuser != null)
			{
			search += "and A.lm_user like '%'+@creatuser+'%' ";
			dynamicParams.Add("@creatuser", creatuser);
			}
			if (arrivalopendate != "" && arrivalopendate != null)
			{
			search += "and A.hacceptdate between @arrivalopendate and @arrivalclosedate ";
			dynamicParams.Add("@arrivalopendate", arrivalopendate + " 00:00:00");
			dynamicParams.Add("@arrivalclosedate", arrivalclosedate + " 23:59:59");
			}
			if (search == "")
			{
			search = "and 1=1 ";
			}
			// --------------查询指定数据--------------
			var total = 0; //总条数
			var sql = @"select A.hbillstaus,A.hdate,A.hbillno,A.hdepartmentcode,T.org_name as hdepartmentname,A.hcustomercode,C.name as hcustomername,
			A.hsourcebillno,A.hacceptdate,A.lm_user as usercode,U.username
			from T_PurchaseArrivalOrder A
			left join TCustomer C on A.hcustomercode=C.code
			left join TOrganization T on A.hdepartmentcode=T.org_code
			left join TUser U on A.lm_user=U.usercode
			where 1=1 " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.count = total;
			mes.data = data.ToList();
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[采购到货单明细]
			public static ToMessage PurchaseArrivalOrderSubSearch(string arrivelodercode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取采购到货单物料信息
			sql = @"select S.hpartcode as partcode,M.partname,M.partspec,M.uom_code,T.name as uom_name,
			S.hqty,S.hinqty,S.hreturnqty,S.hacceptdate,S.hstorehousecode,K.name as hstorehousename,S.hcheckstaus
			from T_PurchaseArrivalOrder A
			left join T_PurchaseArrivalOrder_sub S on A.hbillno=S.hbillno
			left join TMateriel_Info M on S.hpartcode=M.partcode
			left join TUom T on M.uom_code=T.code
			left join T_Sec_Stck K on S.hstorehousecode=K.code
			where A.hbillno=@arrivelodercode";
			dynamicParams.Add("@arrivelodercode", arrivelodercode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[采购到货单关闭]
			public static ToMessage ClosedPurchaseArrivalOrder(string arrivelodercode, string username)
			{
			var sql = "";
			List<object> list = new List<object>();
			var dynamicParams = new DynamicParameters();
			try
			{
			//更新到货单状态
			sql = @"update T_PurchaseArrivalOrder set hbillstaus='CLOSED' where hbillno=@arrivelodercode";
			list.Add(new { str = sql, parm = new { arrivelodercode = arrivelodercode } });
			bool aa = DapperHelper.DoTransaction(list);
			if (aa)
			{
			mes.code = "200";
			mes.count = 0;
			mes.Message = "操作成功!";
			mes.data = null;
			}
			else
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = "操作失败!";
			mes.data = null;
			}
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion

			#region[采购到货单明细查看条码详情]
			public static ToMessage PurchaseArrivalOrderSubLabDetails(string sourceorder, string arrivelodercode, string partcode)
			{
			string sql = "";
			var dynamicParams = new DynamicParameters();
			try
			{
			//获取到货物料对应标签信息
			sql = @"select C.hbarcode,A.hbillno,A.hsourcebillno,C.qualitystatus,C.hqty,C.hbatchno
			from T_PurchaseArrivalOrder A
			inner join T_PurchaseArrivalOrder_sub B on A.hbillno=B.hbillno
			left join T_BarCodeBill C on A.hsourcebillno=C.hsourcebillno and A.hbillno=C.hbillno and B.hpartcode=C.hmaterialcode
			where A.hsourcebillno=@hsourcebillno and A.hbillno=@hbillno and B.hpartcode=@hpartcode";
			dynamicParams.Add("@hsourcebillno", sourceorder);
			dynamicParams.Add("@hbillno", arrivelodercode);
			dynamicParams.Add("@hpartcode", partcode);
			var data = DapperHelper.selectdata(sql, dynamicParams);
			mes.code = "200";
			mes.Message = "查询成功!";
			mes.data = data;
			}
			catch (Exception e)
			{
			mes.code = "300";
			mes.count = 0;
			mes.Message = e.Message;
			mes.data = null;
			}
			return mes;
			}
			#endregion
			}
			}