public void Save() { try { if (!string.IsNullOrWhiteSpace(Department.DepartName)) { Department.SID = CommonTools.GetNewID("BM", Account); StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("insert into Department ("); sqlstr.Append("SID, DepartName, Creator, CreatDate"); sqlstr.Append(") values ("); sqlstr.Append("'" + Department.SID + "',"); sqlstr.Append("'" + Department.DepartName + "',"); sqlstr.Append("'" + Department.Creator + "',"); sqlstr.Append("'" + Department.CreatDate + "')"); db.ExecVoid(sqlstr.ToString(), Account); Code = "0000"; Msg = "新增成功"; } else { Code = "0002"; Msg = "名称为空"; } } catch (Exception ex) { Code = "0001"; Msg = ex.ToString(); } }
public void Save() { try { if (!string.IsNullOrWhiteSpace(Client.ClientCode)) { Client.SID = CommonTools.GetNewID("KH", Account); StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("insert into Client ("); sqlstr.Append("SID, ClientCode, ClientName, ClientType, Address, Contact, Phone, WeChat, QQ, Email, Fax, Bank, Account, Remark, Creator, CreatDate, Status"); sqlstr.Append(") values ("); sqlstr.Append("'" + Client.SID + "',"); sqlstr.Append("'" + Client.ClientCode + "',"); sqlstr.Append("'" + Client.ClientName + "',"); sqlstr.Append("'" + Client.ClientType + "',"); sqlstr.Append("'" + Client.Address + "',"); sqlstr.Append("'" + Client.Contact + "',"); sqlstr.Append("'" + Client.Phone + "',"); sqlstr.Append("'" + Client.WeChat + "',"); sqlstr.Append("'" + Client.QQ + "',"); sqlstr.Append("'" + Client.Email + "',"); sqlstr.Append("'" + Client.Fax + "',"); sqlstr.Append("'" + Client.Bank + "',"); sqlstr.Append("'" + Client.Account + "',"); sqlstr.Append("'" + Client.Remark + "',"); sqlstr.Append("'" + Client.Creator + "',"); sqlstr.Append("'" + Client.CreatDate + "',"); sqlstr.Append("'" + Client.Status + "')"); db.ExecVoid(sqlstr.ToString(), Account); Code = "0000"; Msg = "保存成功"; } else { Code = "0001"; Msg = "没有可保存的信息"; } } catch (Exception ex) { Code = "0002"; Msg = ex.ToString(); } }
public void Save() { try { if (!string.IsNullOrWhiteSpace(UserInfo.UserName)) { UserInfo.SID = CommonTools.GetNewID("RY", Account); StringBuilder sqlstr = new StringBuilder(); sqlstr.Append("insert into UserInfo ("); sqlstr.Append("SID, LoginID, Password, UserName, Phone, Status,DepartID, Creator, CreatDate"); sqlstr.Append(") values ("); sqlstr.Append("'" + UserInfo.SID + "',"); sqlstr.Append("'" + UserInfo.LoginID + "',"); sqlstr.Append("'" + UserInfo.Password + "',"); sqlstr.Append("'" + UserInfo.UserName + "',"); sqlstr.Append("'" + UserInfo.Phone + "',"); sqlstr.Append("'" + UserInfo.Status + "',"); sqlstr.Append("'" + UserInfo.DepartID + "',"); sqlstr.Append("'" + UserInfo.Creator + "',"); sqlstr.Append("'" + UserInfo.CreatDate + "')"); db.ExecVoid(sqlstr.ToString(), Account); Code = "0000"; Msg = "新增成功"; } else { Code = "0001"; Msg = "无新增用户信息"; } } catch (Exception ex) { Code = "0002"; Msg = ex.ToString(); } }