| | |
|---|
| | | ",HWhID,HWHName,HSupID,HSupName " + |
|---|
| | | ",HSCWHID,HSCWHName " + |
|---|
| | | ",HCloudUserName,HCloudUserPsd,HUSEORGID,HProcID" + |
|---|
| | | ",HGroupID,HSourceID,HCheckEmpID,HWorkCenterID,HICNumber) " + |
|---|
| | | ",HGroupID,HSourceID,HCheckEmpID,HWorkCenterID,HICNumber,HDingDingUserID) " + |
|---|
| | | "values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "',"+ lsmain[0].HK3UserID.ToString() + "" + |
|---|
| | | ","+ lsmain[0].HKeeperID.ToString() + ",'"+ lsmain[0].HKeeper.ToString() + "',"+ lsmain[0].HSecManagerID.ToString() + ",'"+ lsmain[0].HSecManager.ToString() + "'" + |
|---|
| | | "," + lsmain[0].HSellManID.ToString() + ",'" + lsmain[0].HSellMan.ToString() + "'," + lsmain[0].HDeptID.ToString() + ",'" + lsmain[0].HDept.ToString() + "'" + |
|---|
| | | "," + lsmain[0].HWhID.ToString() + ",'" + lsmain[0].HWHName.ToString() + "'," + lsmain[0].HSupID.ToString() + ",'" + lsmain[0].HSupName.ToString() + "'" + |
|---|
| | | "," + lsmain[0].HSCWHID.ToString() + ",'" + lsmain[0].HSCWHName.ToString() + "'" + |
|---|
| | | ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + "," + lsmain[0].HProcID.ToString() + "" + |
|---|
| | | ","+ lsmain[0].HGroupID.ToString() + ","+ lsmain[0].HSourceID.ToString() + "," + lsmain[0].HCheckEmpID.ToString() + "," + lsmain[0].HWorkCenterID.ToString() + ",'" + lsmain[0].HICNumber + "'" + ")"); |
|---|
| | | ","+ lsmain[0].HGroupID.ToString() + ","+ lsmain[0].HSourceID.ToString() + "," + lsmain[0].HCheckEmpID.ToString() + "," + lsmain[0].HWorkCenterID.ToString() + ",'" + lsmain[0].HICNumber + "','" + lsmain[0].HDingDingUserID + "'" + ")"); |
|---|
| | | |
|---|
| | | //新增后查询 确保数据添加成功 |
|---|
| | | ds = oCN.RunProcReturn("Select * from Gy_Czygl where Czybm='" + lsmain[0].Czybm.ToString() + "'", "Gy_Czygl"); |
|---|
| | |
|---|
| | | ",HCloudUserPsd='" + lsmain[0].HCloudUserPsd.ToString() + "'" + |
|---|
| | | ",HUSEORGID=" + lsmain[0].HOrgID.ToString() + |
|---|
| | | ",HICNumber='" + lsmain[0].HICNumber + "'" + |
|---|
| | | ",HDingDingUserID='" + lsmain[0].HDingDingUserID + "'" + |
|---|
| | | " where Czybm='" + lsmain[0].Czybm.ToString() + "'"); |
|---|
| | | } |
|---|
| | | else |
|---|
