/// <summary>
/// update
/// </summary>
/// <param name="AllInOne_UserPermissionView"></param>
/// <returns></returns>
public void Update(AllInOne_UserPermissionView model)
{
var str = GetUpdateStr(model);
var dict = GetParameters(model);
SqlHelper.Instance.ExcuteNon(str, dict);
}
/// <summary>
/// add
/// </summary>
/// <param name="AllInOne_UserPermissionView"></param>
/// <returns></returns>
public int Add(AllInOne_UserPermissionView model)
{
var str = GetInsertStr(model) + " select @@identity";
var dict = GetParameters(model);
return(Convert.ToInt32(SqlHelper.Instance.ExecuteScalar(str, dict)));
}
/// <summary>
/// 获取参数
/// </summary>
/// <param name="allinone_userpermissionview"></param>
/// <returns></returns>
public Dictionary <string, string> GetParameters(AllInOne_UserPermissionView allinone_userpermissionview)
{
Dictionary <string, string> dict = new Dictionary <string, string>();
if (allinone_userpermissionview.id != null)
{
dict.Add("@id", allinone_userpermissionview.id.ToString());
}
if (allinone_userpermissionview.name != null)
{
dict.Add("@name", allinone_userpermissionview.name.ToString());
}
if (allinone_userpermissionview.account != null)
{
dict.Add("@account", allinone_userpermissionview.account.ToString());
}
if (allinone_userpermissionview.pwd != null)
{
dict.Add("@pwd", allinone_userpermissionview.pwd.ToString());
}
if (allinone_userpermissionview.level != null)
{
dict.Add("@level", allinone_userpermissionview.level.ToString());
}
if (allinone_userpermissionview.jurisdiction != null)
{
dict.Add("@jurisdiction", allinone_userpermissionview.jurisdiction.ToString());
}
if (allinone_userpermissionview.isDeleted != null)
{
dict.Add("@isDeleted", allinone_userpermissionview.isDeleted.ToString());
}
if (allinone_userpermissionview.parentId != null)
{
dict.Add("@parentId", allinone_userpermissionview.parentId.ToString());
}
if (allinone_userpermissionview.isStaff != null)
{
dict.Add("@isStaff", allinone_userpermissionview.isStaff.ToString());
}
if (allinone_userpermissionview.areaId != null)
{
dict.Add("@areaId", allinone_userpermissionview.areaId.ToString());
}
if (allinone_userpermissionview.pername != null)
{
dict.Add("@pername", allinone_userpermissionview.pername.ToString());
}
if (allinone_userpermissionview.areaName != null)
{
dict.Add("@areaName", allinone_userpermissionview.areaName.ToString());
}
return(dict);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="allinone_userpermissionview"></param>
/// <returns>是否成功</returns>
public string GetUpdateStr(AllInOne_UserPermissionView allinone_userpermissionview)
{
StringBuilder part1 = new StringBuilder();
part1.Append("update allinone_userpermissionview set ");
if (allinone_userpermissionview.name != null)
{
part1.Append("name = @name,");
}
if (allinone_userpermissionview.account != null)
{
part1.Append("account = @account,");
}
if (allinone_userpermissionview.pwd != null)
{
part1.Append("pwd = @pwd,");
}
if (allinone_userpermissionview.level != null)
{
part1.Append("level = @level,");
}
if (allinone_userpermissionview.jurisdiction != null)
{
part1.Append("jurisdiction = @jurisdiction,");
}
if (allinone_userpermissionview.isDeleted != null)
{
part1.Append("isDeleted = @isDeleted,");
}
if (allinone_userpermissionview.parentId != null)
{
part1.Append("parentId = @parentId,");
}
if (allinone_userpermissionview.isStaff != null)
{
part1.Append("isStaff = @isStaff,");
}
if (allinone_userpermissionview.areaId != null)
{
part1.Append("areaId = @areaId,");
}
if (allinone_userpermissionview.pername != null)
{
part1.Append("pername = @pername,");
}
if (allinone_userpermissionview.areaName != null)
{
part1.Append("areaName = @areaName,");
}
int n = part1.ToString().LastIndexOf(",");
part1.Remove(n, 1);
part1.Append(" where id= @id ");
return(part1.ToString());
}
/// <summary>
/// 插入
/// </summary>
/// <param name="allinone_userpermissionview"></param>
/// <returns>是否成功</returns>
public string GetInsertStr(AllInOne_UserPermissionView allinone_userpermissionview)
{
StringBuilder part1 = new StringBuilder();
StringBuilder part2 = new StringBuilder();
if (allinone_userpermissionview.name != null)
{
part1.Append("name,");
part2.Append("@name,");
}
if (allinone_userpermissionview.account != null)
{
part1.Append("account,");
part2.Append("@account,");
}
if (allinone_userpermissionview.pwd != null)
{
part1.Append("pwd,");
part2.Append("@pwd,");
}
if (allinone_userpermissionview.level != null)
{
part1.Append("level,");
part2.Append("@level,");
}
if (allinone_userpermissionview.jurisdiction != null)
{
part1.Append("jurisdiction,");
part2.Append("@jurisdiction,");
}
if (allinone_userpermissionview.isDeleted != null)
{
part1.Append("isDeleted,");
part2.Append("@isDeleted,");
}
if (allinone_userpermissionview.parentId != null)
{
part1.Append("parentId,");
part2.Append("@parentId,");
}
if (allinone_userpermissionview.isStaff != null)
{
part1.Append("isStaff,");
part2.Append("@isStaff,");
}
if (allinone_userpermissionview.areaId != null)
{
part1.Append("areaId,");
part2.Append("@areaId,");
}
if (allinone_userpermissionview.pername != null)
{
part1.Append("pername,");
part2.Append("@pername,");
}
if (allinone_userpermissionview.areaName != null)
{
part1.Append("areaName,");
part2.Append("@areaName,");
}
StringBuilder sql = new StringBuilder();
sql.Append("insert into allinone_userpermissionview(").Append(part1.ToString().Remove(part1.Length - 1)).Append(") values (").Append(part2.ToString().Remove(part2.Length - 1)).Append(")");
return(sql.ToString());
}
