| | |
| | | oCN.RunProcReturn("delete from Gy_Employee_Post where HEmpID = " + HItemID, "Gy_Employee_Post"); |
| | | |
| | | string sql3 = ""; |
| | | foreach (ClsGy_EmployeeSub listOne in list1) |
| | | if (list1.Count >0) |
| | | { |
| | | sql3 += "insert into Gy_Employee_Post(HEmpID, HPostID, HRemark) Values(" |
| | | + HItemID + ",N'" + listOne.HPostID + "',N'" + listOne.HRemark + "');"; |
| | | foreach (ClsGy_EmployeeSub listOne in list1) |
| | | { |
| | | sql3 += "insert into Gy_Employee_Post(HEmpID, HPostID, HRemark) Values(" |
| | | + HItemID + ",N'" + listOne.HPostID + "',N'" + listOne.HRemark + "');"; |
| | | |
| | | } |
| | | oCN.RunProcReturn(sql3, "Gy_WorkCenterSub"); |
| | | } |
| | | oCN.RunProcReturn(sql3, "Gy_WorkCenterSub"); |
| | | |
| | | |
| | | } |
| | | oCN.Commit(); |