| | |
| | | throw (e); |
| | | } |
| | | } |
| | | |
| | | ////æ¡ç æ«æè®°å½,æ°å¢å°äº§åå
¥åº |
| | | //public bool AddBill_PDA(ref string sReturn) |
| | | //{ |
| | | // try |
| | | // { |
| | | // DataSet Ds; |
| | | // oCn.BeginTran(); |
| | | // //å é¤ä¸»è¡¨ |
| | | // oCn.RunProc("Delete From Sc_MouldStockBillMain where HInterID=" + omodel.HInterID.ToString()); |
| | | // //æå
¥å表 |
| | | // oCn.RunProc("EXEC h_p_Sc_MouldProdOutBillSub_Insert " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'"); |
| | | // //æå
¥ä¸»è¡¨ |
| | | // oCn.RunProc("Insert Into Sc_MouldStockBillMain " + |
| | | // "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | // ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | // ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + |
| | | // ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + |
| | | // ") " + |
| | | // " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "',convert(varchar(10),getdate(),120)" + |
| | | // ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | // ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + |
| | | // ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + |
| | | // ") "); |
| | | // sReturn = "æ°å¢åæ®æåï¼"; |
| | | // oCn.Commit(); |
| | | // return true; |
| | | // } |
| | | // catch (Exception e) |
| | | // { |
| | | // sReturn = e.Message; |
| | | // oCn.RollBack(); |
| | | // throw (e); |
| | | // } |
| | | //} |
| | | |
| | | //æ¾ç¤ºåæ® |
| | | public override bool ShowBill(Int64 lngBillKey, ref string sReturn) |
| | | { |