1

wtt

3 天以前 7141e956ca8488f6feb082828cd60653382b6c89

 WebAPI/Controllers/BaseSet/Gy_EmployeeController.cs

@@ -438,6 +438,7 @@
                string msg4 = sArray[2].ToString();
                //string msg4 = sArray[2].ToString();
                //string msg5 = sArray[3].ToString();

                oCN.BeginTran();
                //编辑权限
                if (!DBUtility.ClsPub.Security_Log_second("Gy_Employee_Edit", 1, false, msg3))
@@ -653,7 +654,6 @@
                        + itemID + "," + listOne.HPostID +",N'" + listOne.HRemark + "');";

                    }
                    LogService.Write(sql3);
                    oCN.RunProcReturn(sql3, "Gy_Employee_Post");
                    
                }
@@ -675,6 +675,7 @@
                        objJsonResult.data = null;
                        return objJsonResult;
                    }

                    oCN.RunProc("Update Gy_Employee set " +
                    " HNumber='" +  HNumber + "'" +
                    ",HName='" +  HName + "'" +
@@ -761,15 +762,17 @@
                    ",HAddress='" +  HAddress.ToString() + "'" +
                    ",HDeptID= '" +  HDeptID + "' Where HItemID=" + HItemID);

                   

                    oCN.RunProcReturn("delete from Gy_Employee_Post where HEmpID = " + HItemID, "Gy_Employee_Post");

                    string sql3 = "";
                    foreach (ClsGy_EmployeeSub listOne in list1)
                    {
                        sql3 += "insert into Gy_Employee_Post(HEmpID, HPostID, HRemark) Values("
                       + HItemID + "," + listOne.HPostID  + ",N'" + listOne.HRemark + "');";
                       + HItemID + ",N'" + listOne.HPostID  + "',N'" + listOne.HRemark + "');";
            
                    }
                    LogService.Write(sql3);
                    oCN.RunProcReturn(sql3, "Gy_WorkCenterSub");
                    
                }