| | |
|---|
| | | //======================================== |
|---|
| | | ",HDeptID='" + omodel.HDeptID.ToString() + |
|---|
| | | "',HPostID='" + omodel.HPostID.ToString() + |
|---|
| | | "',HMaterID='" + omodel.HMaterID.ToString() + |
|---|
| | | "',HProcID='" + omodel.HProcID.ToString() + |
|---|
| | | "',HOrgID='" + omodel.HOrgID.ToString() + "'" + |
|---|
| | | " where HInterID=" + lngBillKey.ToString()); |
|---|
| | | //鍒犻櫎鍏宠仈 |
|---|
| | |
|---|
| | | oCn.RunProc("Insert Into HR_PostSkillBillMain " + |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
|---|
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
|---|
| | | ",HDeptID,HPostID,HOrgID" + |
|---|
| | | ",HDeptID,HPostID,HOrgID,HMaterID,HProcID" + |
|---|
| | | |
|---|
| | | ") " + |
|---|
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
|---|
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
|---|
| | | ",'" + omodel.HDeptID.ToString() + "'," + omodel.HPostID.ToString() + "," + omodel.HOrgID.ToString() + |
|---|
| | | |
|---|
| | | ",'" + omodel.HDeptID.ToString() + "'," + omodel.HPostID.ToString() + "," + omodel.HOrgID.ToString() + "," + omodel.HMaterID.ToString() + "," + omodel.HProcID.ToString() + |
|---|
| | | ") "); |
|---|
| | | //鎻掑叆瀛愯〃 |
|---|
| | | foreach (Model.ClsHR_PostSkillBillSub oSub in DetailColl) |
|---|
