销售订单,发货通知单,退货通知单,销售出库单:表头增加字段:项目编号(HProjectID),界面显示项目编码和项目名称
可选择工程项目为基础资料
表头和表体增加仓库字段(HWHID)
选择表头仓库后,表体仓库为空的也自动填充
| | |
| | | ",HInnerBillNo = '" + omodel.HInnerBillNo + "'" + |
| | | ",HCarriage = " + omodel.HCarriage + "" + |
| | | ",HCheckStatusMan = '" + omodel.HCheckStatusMan + "'" + |
| | | ",HProjectID = '" + omodel.HProjectID.ToString() + "'" + |
| | | ",HGroupID = '" + omodel.HGroupID.ToString() + "'" + |
| | | ",HPriceType = '" + omodel.HPriceType + "'" + |
| | | " where HInterID = " + lngBillKey; |
| | | //æ´æ°ä¸»è¡¨ |
| | | oCn.RunProc(mainSql); |
| | |
| | | ",HDeptID,HManagerID,HEmpID,HSupID,HSecManagerID,HKeeperID,HWHID,HSCWHID,HCurID,HExRate,HSellSID,HLinkMan,HLinkPhone" + |
| | | ",HSeOrderBillNo" + |
| | | ",HConveyCompID,HConveyTypeID,HConveyMoney" + |
| | | ",HExplanation,HInnerBillNo,HRedBlueFlag,HCarriage,HCheckStatusMan" + |
| | | ",HExplanation,HInnerBillNo,HRedBlueFlag,HCarriage,HCheckStatusMan,HProjectID,HGroupID,HPriceType" + |
| | | ") " + |
| | | "values(" + |
| | | "" + omodel.HInterID.ToString() + "" + |
| | |
| | | "," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + "" + |
| | | "," + omodel.HCarriage + "" + |
| | | ",'" + omodel.HCheckStatusMan + "'" + |
| | | ",'" + omodel.HProjectID.ToString() + "'" + |
| | | ",'" + omodel.HGroupID.ToString() + "'" + |
| | | ",'" + omodel.HPriceType + "'" + |
| | | ") "; |
| | | |
| | | oCn.RunProc(mainSql); |
| | |
| | | "','" + oSub.HCusMaterNumber + |
| | | "','" + oSub.HCusModel + |
| | | "','" + oSub.HCusMaterName + |
| | | "','" + oSub.HWhID + |
| | | "'," + (oSub.HisStockGoods?1:0) + |
| | | ")"; |
| | | ",'" + oSub.HWhID + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | |
| | | "','" + oSub.HCusMaterNumber + |
| | | "','" + oSub.HCusModel + |
| | | "','" + oSub.HCusMaterName + |
| | | "','" + oSub.HWhID + |
| | | "'," + (oSub.HisStockGoods?1:0) + |
| | | ")"; |
| | | ",'" + oSub.HWhID + |
| | | "')"; |
| | | oCn.RunProc(subSql); |
| | | } |
| | | |
| | |
| | | ",HAddress='" + omodel.HAddress + "'" + |
| | | ",HExplanation='" + omodel.HExplanation + "'" + |
| | | ",HInnerBillNo='" + omodel.HInnerBillNo + "'" + |
| | | ",HProjectID='" + omodel.HProjectID + "'" + |
| | | " where HInterID=" + lngBillKey.ToString()); |
| | | //å é¤å
³è |
| | | //DeleteRelation(ref sReturn, lngBillKey); |
| | |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HAddress,HSSID,HCusID,HWHID,HCurID,HExRate" + |
| | | ",HEmpID,HManagerID,HDeptID,HExplanation,HInnerBillNo" + |
| | | ",HEmpID,HManagerID,HDeptID,HExplanation,HInnerBillNo,HProjectID" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + |
| | | ",'" + omodel.HAddress + "'," + omodel.HSSID.ToString() + "," + omodel.HCusID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HCurID.ToString() + "," + omodel.HExRate.ToString() + |
| | | ", " + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'"+ |
| | | ", " + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "','"+omodel.HProjectID.ToString()+"'"+ |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsXs_SeOutStockBackBillSub oSub in DetailColl) |
| | |
| | | public string HCheckStatusMan; //æ ¸é人 |
| | | public double HExRate; //æ±ç |
| | | |
| | | public Int64 HProjectID; //å·¥ç¨é¡¹ç® |
| | | public Int64 HGroupID; //çç» |
| | | public string HPriceType; //varchar(20) --åä»·ç±»åï¼ææ¬ä»·ï¼ç»ç®ä»·ï¼ |
| | | |
| | | public Int64 HOrgID; //ç»ç» |
| | | } |
| | | } |
| | |
| | | public Int64 HWHID;// |
| | | public string HExplanation;// varchar(200) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public Int64 HProjectID; //å·¥ç¨é¡¹ç® |
| | | } |
| | | } |
| | |
| | | public Int64 HCurID;// int --å¸å« (Gy_Currency) |
| | | public Single HExRate;// money --æ±ç (éæ©å®å¸å«å¸¦åº) |
| | | public Int64 HWHID;// ä»åº |
| | | public Int64 HProjectID; // gå·¥ç¨é¡¹ç® |
| | | public string HExplanation;// varchar(200) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public Int64 HConveyTypeID;// è¿è¾æ¹å¼ |
| | |
| | | long HConveyCompID = mainList[0].HConveyCompID;//è¿è¾å
¬å¸ |
| | | long HConveyMoney = (long)mainList[0].HConveyMoney;//è¿è´¹ |
| | | long HDFflag = Convert.ToInt32(mainList[0].HDFflag); //æ¯å¦å«ä» |
| | | |
| | | long HProjectID = mainList[0].HProjectID;//å·¥ç¨é¡¹ç® |
| | | |
| | | string HBillType = mainList[0].HBillType; |
| | | string HBillSubType = mainList[0].HBillSubType; |
| | |
| | | ,HAddress,HSSID,HCurID,HWHID,HExRate,HEmpID,HExplanation,HInnerBillNo,HSeOrderBillNo_M |
| | | ,HConveyTypeID,HConveyCompID,HConveyMoney,HLinkMan,HLinkPhone |
| | | ,HSALEORGID,HDELIVERYORGID,HOWNERID,HOWNERTYPEID |
| | | ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag) |
| | | ,HChecker,HCheckDate,HCloseMan,HCloseDate,HERPInterID,HERPBillType,HDFflag,HProjectID) |
| | | values(" + HInterID + "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + 1402 + "','" + |
| | | 1402 + "','" + HDate + "','" + HBillNo + "'," + HBillStatus + "," + HCusID + |
| | | "," + HManagerID + "," + HDeptID + ",'" + HRemark + "','" + HMaker + "','" + HMakeDate + |
| | | "','" + HAddress + "'," + HSSID + "," + HCurID + "," + HWHID + "," + HExRate + "," + HEmpID + ",'" + |
| | | HExplanation + "','" + HInnerBillNo + "','" + HSeOrderBillNo_M + "','" + HConveyTypeID + "','" + HConveyCompID + "','" + HConveyMoney + "','" + HLinkMan + "','" + HLinkPhone + "'," + HSALEORGID + "," + HDELIVERYORGID + "," + HOWNERID + ",'" |
| | | + HOWNERTYPEID + "','" + HChecker + "','" + HCheckDate + "','" + HCloseMan + "','" + HCloseDate + "'," + HERPInterID + |
| | | ",'" + HERPBillType + "'," + HDFflag + ")"; |
| | | ",'" + HERPBillType + "'," + HDFflag + ",'"+ HProjectID + "')"; |
| | | |
| | | oCN.RunProc(sql); |
| | | |
| | |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ",HCusID='" + HCusID + "', HCurID='" + HCurID + "', HWHID = '" + HWHID |
| | | + "',HExRate='" + HExRate + "',HEmpID='" + HEmpID + "',HSeOrderBillNo_M='" + HSeOrderBillNo_M + "',HManagerID='" + HManagerID + "',HDeptID='" + HDeptID + "',HOWNERID='" + HOWNERID |
| | | + "',HAddress='" + HAddress + "' where HInterID=" + HInterID; |
| | | + "',HAddress='" + HAddress + "',HProjectID='"+ HProjectID + "' where HInterID=" + HInterID; |
| | | oCN.RunProc(sql); |
| | | |
| | | //å é¤å表 |