| | |
|---|
| | | msg2 = msg2.Replace("\n", ""); //\n |
|---|
| | | lsmain = oListModels.getObjectByJson_Gy_Gy_User(msg2); |
|---|
| | | |
|---|
| | | oCN.BeginTran(); |
|---|
| | | //保存 |
|---|
| | | if (msg3=="Add") //新增 |
|---|
| | | { |
|---|
| | | oCN.RunProc("insert into Gy_Czygl (Czybm,Czymc,Czmm,Explain) values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString()+"')"); |
|---|
| | | oCN.RunProc("insert into Gy_Czygl (Czybm,Czymc,Czmm,Explain,HEmpID) values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "')"); |
|---|
| | | } |
|---|
| | | else //修改 |
|---|
| | | { |
|---|
| | | if (lsmain[0].Czyyz != "" && lsmain[0].Czmm == lsmain[0].Czyyz) //修改密码 |
|---|
| | | { |
|---|
| | | oCN.RunProc("update Gy_Czygl set Czymc='"+lsmain[0].Czymc.ToString()+ "',Czmm='"+ ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "',Explain='"+lsmain[0].Explain.ToString()+ "' where Czybm='"+lsmain[0].Czybm.ToString()+"'"); |
|---|
| | | oCN.RunProc("update Gy_Czygl set Czymc='"+lsmain[0].Czymc.ToString()+ "',Czmm='"+ ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "',Explain='" + lsmain[0].Explain.ToString() + "' ,HEmpID='" + lsmain[0].HEmpID.ToString() + "' where Czybm='" + lsmain[0].Czybm.ToString()+"'"); |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | oCN.RunProc("update Gy_Czygl set Czymc='" + lsmain[0].Czymc.ToString() + "',Explain='" + lsmain[0].Explain.ToString() + "' where Czybm='" + lsmain[0].Czybm.ToString() + "'"); |
|---|
| | | oCN.RunProc("update Gy_Czygl set Czymc='" + lsmain[0].Czymc.ToString() + "',Explain='" + lsmain[0].Explain.ToString() + "',HEmpID='" + lsmain[0].HEmpID.ToString() + "' where Czybm='" + lsmain[0].Czybm.ToString() + "'"); |
|---|
| | | } |
|---|
| | | } |
|---|
| | | oCN.Commit(); |
|---|
| | | |
|---|
| | | objJsonResult.code = "1"; |
|---|
| | | objJsonResult.count = 1; |
|---|
