/// <summary>
/// 更新账户信息
/// <param name="model">账户信息</param>
/// </summary>
public bool UpdateAccountData(Model.SYS.SYS_Account model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE SYS_Account SET ");
if (model.Name != null)
{
strSql.Append("Name='" + model.Name + "',");
}
if (model.RoleID != null)
{
strSql.Append("RoleID='" + model.RoleID + "',");
}
if (model.Email != null)
{
strSql.Append("Email='" + model.Email + "',");
}
if (model.Address != null)
{
strSql.Append("Address='" + model.Address + "',");
}
if (model.Mobile != null)
{
strSql.Append("Mobile='" + model.Mobile + "',");
}
if (model.Telphone != null)
{
strSql.Append("Telphone='" + model.Telphone + "',");
}
if (model.Status != null)
{
strSql.Append("Status='" + model.Status + "',");
}
if (model.SiteCode != null)
{
strSql.Append("SiteCode='" + model.SiteCode + "',");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" WHERE ID ='" + model.ID + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 添加账户信息
/// </summary>
/// <param name="model">账户信息</param>
///
public bool AddAccountData(Model.SYS.SYS_Account model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.ID != null)
{
strSql1.Append("ID,");
strSql2.Append("'" + model.ID + "',");
}
if (model.LoginName != null)
{
strSql1.Append("LoginName,");
strSql2.Append("'" + model.LoginName + "',");
}
if (model.Password != null)
{
strSql1.Append("Password,");
strSql2.Append("'" + model.Password + "',");
}
if (model.AgentID != null)
{
strSql1.Append("AgentID,");
strSql2.Append("'" + model.AgentID + "',");
}
if (model.Name != null)
{
strSql1.Append("Name,");
strSql2.Append("'" + model.Name + "',");
}
if (model.RoleID != null)
{
strSql1.Append("RoleID,");
strSql2.Append("'" + model.RoleID + "',");
}
if (model.Email != null)
{
strSql1.Append("Email,");
strSql2.Append("'" + model.Email + "',");
}
if (model.Address != null)
{
strSql1.Append("Address,");
strSql2.Append("'" + model.Address + "',");
}
if (model.Mobile != null)
{
strSql1.Append("Mobile,");
strSql2.Append("'" + model.Mobile + "',");
}
if (model.Telphone != null)
{
strSql1.Append("Telphone,");
strSql2.Append("'" + model.Telphone + "',");
}
if (model.Status != null)
{
strSql1.Append("Status,");
strSql2.Append("'" + model.Status + "',");
}
if (model.CreateTime != null)
{
strSql1.Append("CreateTime,");
strSql2.Append("'" + model.CreateTime + "',");
}
if (model.SiteCode != null)
{
strSql1.Append("SiteCode,");
strSql2.Append("'" + model.SiteCode + "',");
}
strSql.Append("INSERT INTO SYS_Account(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" VALUES (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(");");
strSql.Append(" UPDATE SYS_Account SET ID = '" + model.ID + "'");
strSql.Append(" WHERE ID ='" + model.ID + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
