public List <Imit1> Insert_Imit1(Imit request) { List <Imit1> Result = null; int intResult = -1; try { using (var db = DbConnectionFactory.OpenDbConnection("WMS")) { string strSql = "EXEC spi_Imit1 @CustomerCode,@Description1,@Description2,@GoodsTransferNoteNo,@RefNo,@TransferBy,@TransferDateTime,@TrxNo,@WorkStation,@CreateBy,@UpdateBy"; intResult = db.SqlScalar <int>(strSql, new { CustomerCode = "", Description1 = "", Description2 = "", GoodsTransferNoteNo = "", RefNo = "", TransferBy = request.UserID, TransferDateTime = DateTime.Now, TrxNo = "", WorkStation = "APP", CreateBy = request.UserID, UpdateBy = request.UserID }); if (intResult > -1) { strSql = "Select top 1 * From Imit1 Order By CreateDateTime Desc"; Result = db.Select <Imit1>(strSql); } } } catch { throw; } return(Result); }
public int Insert_Imit2(Imit request) { int Result = -1; //Result = Insert_Imit2Detail(int.Parse(request.Impm1TrxNo), int.Parse(request.TrxNo), int.Parse(request.LineItemNo), int.Parse(request.Qty), request.NewStoreNo, request.UpdateBy); return(Result); }
public int Confirm_Imit1(Imit request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection("WMS")) { string strSql = "EXEC spi_Imit_Confirm " + int.Parse(request.TrxNo) + ",'" + request.UpdateBy + "'"; Result = db.SqlScalar <int>(strSql); } } catch { throw; } return(Result); }
public int Confirm_Imit1(Imit request) { int Result = -1; Boolean blnSameCustomer = false; string OldCustomerCode = "", CustomerCode = "", CustomerName = ""; if (request.NewStoreNoList != null || request.NewStoreNoList != "") { string[] NewSotreNoDetail = request.NewStoreNoList.Split(','); string[] LineItemNoDetail = request.LineItemNoList.Split(','); string[] Impm1TrxNoDetail = request.Impm1TrxNoList.Split(','); string[] QtyDetail = request.QtyList.Split(','); for (int intI = 0; intI < NewSotreNoDetail.Length; intI++) { Result = Insert_Imit2Detail(int.Parse(Impm1TrxNoDetail[intI]), int.Parse(request.TrxNo), int.Parse(LineItemNoDetail[intI]), int.Parse(QtyDetail[intI]), NewSotreNoDetail[intI], request.UpdateBy, ref CustomerCode, ref CustomerName); if (OldCustomerCode == "" && CustomerCode != "") { OldCustomerCode = CustomerCode; blnSameCustomer = true; } else if (OldCustomerCode != CustomerCode) { blnSameCustomer = false; } } if (blnSameCustomer) { } } try { using (var db = DbConnectionFactory.OpenDbConnection("WMS")) { //string strSql = "EXEC spi_Imit_Confirm " + int.Parse(request.TrxNo) + ",'" + request.UpdateBy + "'"; 'yicong 20161019 string strCustoemrUpdate = ""; if (blnSameCustomer) { strCustoemrUpdate = ",CustomerCode = " + Modfunction.SQLSafeValue(CustomerCode); } string strSql = "Update Imit1 set StatusCode='EXE',UpdateBy='" + request.UpdateBy + "'" + strCustoemrUpdate + " where TrxNo='" + request.TrxNo + "' "; Result = db.SqlScalar <int>(strSql); } } catch { throw; } return(Result); }
public int Confirm_Imit1(Imit request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection("WMS")) { string strSql = "EXEC spi_Imit_Confirm @TrxNo,@UpdateBy"; Result = db.SqlScalar <int>(strSql, new { TrxNo = int.Parse(request.TrxNo), UpdateBy = request.UserID }); } } catch { throw; } return(Result); }
public int Insert_Imit2(Imit request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { string strSql = "Select Impm1.*,Impr1.PackingPackageSize,Impr1.WholePackageSize " + "From Impm1 Join Impr1 On Impm1.ProductTrxNo = Impr1.TrxNo " + "Where Impm1.TrxNo=" + int.Parse(request.Impm1TrxNo); List <Impm1> impm1s = db.Select <Impm1>(strSql); if (impm1s.Count > 0) { switch (impm1s[0].DimensionFlag) { case "1": db.Insert( new Imit2 { TrxNo = int.Parse(request.TrxNo), LineItemNo = int.Parse(request.LineItemNo), MovementTrxNo = int.Parse(request.Impm1TrxNo), NewStoreNo = request.NewStoreNo, NewWarehouseCode = impm1s[0].WarehouseCode, StoreNo = impm1s[0].StoreNo, WarehouseCode = impm1s[0].WarehouseCode, ProductTrxNo = impm1s[0].ProductTrxNo, PackingQty = int.Parse(request.Qty), WholeQty = int.Parse(request.Qty) * impm1s[0].PackingPackageSize, LooseQty = int.Parse(request.Qty) * impm1s[0].PackingPackageSize * impm1s[0].WholePackageSize, Volume = int.Parse(request.Qty) * impm1s[0].UnitVol, Weight = int.Parse(request.Qty) * impm1s[0].UnitWt, SpaceArea = impm1s[0].SpaceArea * int.Parse(request.Qty) / impm1s[0].BalancePackingQty, UpdateBy = request.UpdateBy } ); db.SqlScalar <int>("Update Impm1 set BalancePackingQty= BalancePackingQty - " + request.Qty.ToString() + ", BalanceWholeQty=BalanceWholeQty-" + (int.Parse(request.Qty) * impm1s[0].PackingPackageSize) + ", BalanceLooseQty=BalanceLooseQty-" + (int.Parse(request.Qty) * impm1s[0].PackingPackageSize * impm1s[0].WholePackageSize) + ", BalanceVolume = BalanceVolume - " + (int.Parse(request.Qty) * impm1s[0].UnitVol) + ", BalanceWeight = BalanceWeight - " + (int.Parse(request.Qty) * impm1s[0].UnitWt) + ", BalanceSpaceArea = BalanceSpaceArea - " + (impm1s[0].SpaceArea * int.Parse(request.Qty) / impm1s[0].BalancePackingQty) + ",UpdateDateTime=getdate(),UpdateBy='" + request.UpdateBy + "' Where TrxNo = " + int.Parse(request.Impm1TrxNo)); db.SqlScalar <int>("EXEC spi_Imit2_Impm " + int.Parse(request.TrxNo) + "," + int.Parse(request.LineItemNo) + ",'" + request.UpdateBy + "'"); break; case "2": db.Insert( new Imit2 { TrxNo = int.Parse(request.TrxNo), LineItemNo = int.Parse(request.LineItemNo), NewStoreNo = request.NewStoreNo, UpdateBy = request.UpdateBy, MovementTrxNo = int.Parse(request.Impm1TrxNo), NewWarehouseCode = impm1s[0].WarehouseCode, StoreNo = impm1s[0].StoreNo, WarehouseCode = impm1s[0].WarehouseCode, ProductTrxNo = impm1s[0].ProductTrxNo, WholeQty = int.Parse(request.Qty), LooseQty = int.Parse(request.Qty) * impm1s[0].WholePackageSize, Volume = int.Parse(request.Qty) * impm1s[0].UnitVol, Weight = int.Parse(request.Qty) * impm1s[0].UnitWt, SpaceArea = impm1s[0].SpaceArea * int.Parse(request.Qty) / impm1s[0].BalanceWholeQty, } ); db.SqlScalar <int>("Update Impm1 set BalanceWholeQty=BalanceWholeQty-" + int.Parse(request.Qty) + ", BalanceLooseQty=BalanceLooseQty-" + (int.Parse(request.Qty) * impm1s[0].WholePackageSize) + ", BalanceVolume = BalanceVolume - " + (int.Parse(request.Qty) * impm1s[0].UnitVol) + ", BalanceWeight = BalanceWeight - " + (int.Parse(request.Qty) * impm1s[0].UnitWt) + ", BalanceSpaceArea = BalanceSpaceArea - " + (impm1s[0].SpaceArea * int.Parse(request.Qty) / impm1s[0].BalanceWholeQty) + ",UpdateDateTime=getdate(),UpdateBy='" + request.UpdateBy + "' Where TrxNo = " + int.Parse(request.Impm1TrxNo)); db.SqlScalar <int>("EXEC spi_Imit2_Impm " + int.Parse(request.TrxNo) + "," + int.Parse(request.LineItemNo) + ",'" + request.UpdateBy + "'"); break; default: db.Insert( new Imit2 { TrxNo = int.Parse(request.TrxNo), LineItemNo = int.Parse(request.LineItemNo), NewStoreNo = request.NewStoreNo, UpdateBy = request.UpdateBy, MovementTrxNo = int.Parse(request.Impm1TrxNo), NewWarehouseCode = impm1s[0].WarehouseCode, StoreNo = impm1s[0].StoreNo, WarehouseCode = impm1s[0].WarehouseCode, ProductTrxNo = impm1s[0].ProductTrxNo, LooseQty = int.Parse(request.Qty), Volume = int.Parse(request.Qty) * impm1s[0].UnitVol, Weight = int.Parse(request.Qty) * impm1s[0].UnitWt, SpaceArea = impm1s[0].SpaceArea * int.Parse(request.Qty) / impm1s[0].BalanceLooseQty, } ); db.SqlScalar <int>("Update Impm1 set BalanceLooseQty=BalanceLooseQty-" + int.Parse(request.Qty) + ", BalanceVolume = BalanceVolume - " + (int.Parse(request.Qty) * impm1s[0].UnitVol) + ", BalanceWeight = BalanceWeight - " + (int.Parse(request.Qty) * impm1s[0].UnitWt) + ", BalanceSpaceArea = BalanceSpaceArea - " + (impm1s[0].SpaceArea * int.Parse(request.Qty) / impm1s[0].BalanceLooseQty) + ",UpdateDateTime=getdate(),UpdateBy='" + request.UpdateBy + "' Where TrxNo = " + int.Parse(request.Impm1TrxNo)); db.SqlScalar <int>("EXEC spi_Imit2_Impm " + int.Parse(request.TrxNo) + "," + int.Parse(request.LineItemNo) + ",'" + request.UpdateBy + "'"); break; } Result = 1; } } } catch { throw; } return(Result); }
public int Insert_Imit2(Imit request) { int Result = -1; try { using (var db = DbConnectionFactory.OpenDbConnection()) { string strSql = "Select Imgr2.* " + "From Imgr2 " + "Where Imgr2.TrxNo=" + int.Parse(request.Imgr2TrxNo) + " And Imgr2.LineItemNo=" + int.Parse(request.Imgr2LineItemNo); List <Imgr2> imgr2s = db.Select <Imgr2>(strSql); if (imgr2s.Count > 0) { switch (imgr2s[0].DimensionFlag) { case "1": db.Insert( new Imit2 { TrxNo = int.Parse(request.TrxNo), LineItemNo = int.Parse(request.LineItemNo), NewStoreNo = request.NewStoreNo, UpdateBy = request.UpdateBy, MovementTrxNo = imgr2s[0].MovementTrxNo, NewWarehouseCode = imgr2s[0].WarehouseCode, StoreNo = imgr2s[0].StoreNo, WarehouseCode = imgr2s[0].WarehouseCode, ProductTrxNo = imgr2s[0].ProductTrxNo, PackingQty = int.Parse(request.Qty), Volume = imgr2s[0].Volume, Weight = imgr2s[0].Weight, SpaceArea = imgr2s[0].SpaceArea } ); break; case "2": db.Insert( new Imit2 { TrxNo = int.Parse(request.TrxNo), LineItemNo = int.Parse(request.LineItemNo), NewStoreNo = request.NewStoreNo, UpdateBy = request.UpdateBy, MovementTrxNo = imgr2s[0].MovementTrxNo, NewWarehouseCode = imgr2s[0].WarehouseCode, StoreNo = imgr2s[0].StoreNo, WarehouseCode = imgr2s[0].WarehouseCode, ProductTrxNo = imgr2s[0].ProductTrxNo, WholeQty = int.Parse(request.Qty), Volume = imgr2s[0].Volume, Weight = imgr2s[0].Weight, SpaceArea = imgr2s[0].SpaceArea } ); break; default: db.Insert( new Imit2 { TrxNo = int.Parse(request.TrxNo), LineItemNo = int.Parse(request.LineItemNo), NewStoreNo = request.NewStoreNo, UpdateBy = request.UpdateBy, MovementTrxNo = imgr2s[0].MovementTrxNo, NewWarehouseCode = imgr2s[0].WarehouseCode, StoreNo = imgr2s[0].StoreNo, WarehouseCode = imgr2s[0].WarehouseCode, ProductTrxNo = imgr2s[0].ProductTrxNo, LooseQty = int.Parse(request.Qty), Volume = imgr2s[0].Volume, Weight = imgr2s[0].Weight, SpaceArea = imgr2s[0].SpaceArea } ); break; } Result = 1; } } } catch { throw; } return(Result); }