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();
}
}
