public bool Update(PEIS.Model.SYSRight model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SYSRight set ");
strSql.Append("RightName=@RightName,");
strSql.Append("RightCode=@RightCode,");
strSql.Append("DispOrder=@DispOrder,");
strSql.Append("Is_Locked=@Is_Locked,");
strSql.Append("ParentID=@ParentID,");
strSql.Append("Remark=@Remark,");
strSql.Append("RightLevel=@RightLevel,");
strSql.Append("OperatorID=@OperatorID,");
strSql.Append("CreateDate=@CreateDate");
strSql.Append(" where RightID=@RightID ");
SqlParameter[] parameters =
{
new SqlParameter("@RightName", SqlDbType.VarChar, 50),
new SqlParameter("@RightCode", SqlDbType.VarChar, 80),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@Is_Locked", SqlDbType.Int, 4),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@RightLevel", SqlDbType.Int, 4),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime),
new SqlParameter("@RightID", SqlDbType.Int, 4)
};
parameters[0].Value = model.RightName;
parameters[1].Value = model.RightCode;
parameters[2].Value = model.DispOrder;
parameters[3].Value = model.Is_Locked;
parameters[4].Value = model.ParentID;
parameters[5].Value = model.Remark;
parameters[6].Value = model.RightLevel;
parameters[7].Value = model.OperatorID;
parameters[8].Value = model.CreateDate;
parameters[9].Value = model.RightID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public List <PEIS.Model.SYSRight> DataTableToList(DataTable dt)
{
List <PEIS.Model.SYSRight> list = new List <PEIS.Model.SYSRight>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
PEIS.Model.SYSRight sysRight = new PEIS.Model.SYSRight();
if (dt.Rows[i]["ID_Right"].ToString() != "")
{
sysRight.RightID = int.Parse(dt.Rows[i]["RightID"].ToString());
}
sysRight.RightName = dt.Rows[i]["RightName"].ToString();
sysRight.RightCode = dt.Rows[i]["RightCode"].ToString();
if (dt.Rows[i]["DispOrder"].ToString() != "")
{
sysRight.DispOrder = int.Parse(dt.Rows[i]["DispOrder"].ToString());
}
if (dt.Rows[i]["Is_Locked"].ToString() != "")
{
sysRight.Is_Locked = int.Parse(dt.Rows[i]["Is_Locked"].ToString());
}
if (dt.Rows[i]["ID_ParentRight"].ToString() != "")
{
sysRight.ParentID = new int?(int.Parse(dt.Rows[i]["ParentID"].ToString()));
}
sysRight.Remark = dt.Rows[i]["Remark"].ToString();
if (dt.Rows[i]["CreateDate"].ToString() != "")
{
sysRight.CreateDate = DateTime.Parse(dt.Rows[i]["CreateDate"].ToString());
}
if (dt.Rows[i]["OperatorID"].ToString() != "")
{
sysRight.OperatorID = new int?(int.Parse(dt.Rows[i]["OperatorID"].ToString()));
}
//if (dt.Rows[i]["LastSubItemCount"].ToString() != "")
//{
// sysRight.LastSubItemCount = new int?(int.Parse(dt.Rows[i]["LastSubItemCount"].ToString()));
//}
if (dt.Rows[i]["RightLevel"].ToString() != "")
{
sysRight.RightLevel = new int?(int.Parse(dt.Rows[i]["RightLevel"].ToString()));
}
list.Add(sysRight);
}
}
return(list);
}
public PEIS.Model.SYSRight DataRowToModel(DataRow row)
{
PEIS.Model.SYSRight model = new PEIS.Model.SYSRight();
if (row != null)
{
if (row["RightID"] != null && row["RightID"].ToString() != "")
{
model.RightID = int.Parse(row["RightID"].ToString());
}
if (row["RightName"] != null)
{
model.RightName = row["RightName"].ToString();
}
if (row["RightCode"] != null)
{
model.RightCode = row["RightCode"].ToString();
}
if (row["DispOrder"] != null && row["DispOrder"].ToString() != "")
{
model.DispOrder = int.Parse(row["DispOrder"].ToString());
}
if (row["Is_Locked"] != null && row["Is_Locked"].ToString() != "")
{
model.Is_Locked = int.Parse(row["Is_Locked"].ToString());
}
if (row["ParentID"] != null && row["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(row["ParentID"].ToString());
}
if (row["Remark"] != null)
{
model.Remark = row["Remark"].ToString();
}
if (row["RightLevel"] != null && row["RightLevel"].ToString() != "")
{
model.RightLevel = int.Parse(row["RightLevel"].ToString());
}
if (row["OperatorID"] != null && row["OperatorID"].ToString() != "")
{
model.OperatorID = int.Parse(row["OperatorID"].ToString());
}
if (row["CreateDate"] != null && row["CreateDate"].ToString() != "")
{
model.CreateDate = DateTime.Parse(row["CreateDate"].ToString());
}
}
return(model);
}
public int Add(PEIS.Model.SYSRight model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into SYSRight(");
stringBuilder.Append("RightID,RightName,RightCode,DispOrder,Is_Locked,ParentID,Remark,RightLevel,OperatorID,CreateDate)");
stringBuilder.Append(" values (");
stringBuilder.Append("@RightID,@RightName,@RightCode,@DispOrder,@Is_Locked,@ParentID,@Remark,@RightLevel,@OperatorID,@CreateDate)");
stringBuilder.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@RightID", SqlDbType.Int, 4),
new SqlParameter("@RightName", SqlDbType.VarChar, 50),
new SqlParameter("@RightCode", SqlDbType.VarChar, 80),
new SqlParameter("@DispOrder", SqlDbType.Int, 4),
new SqlParameter("@Is_Locked", SqlDbType.Int, 4),
new SqlParameter("@ParentID", SqlDbType.Int, 4),
new SqlParameter("@Remark", SqlDbType.VarChar, 200),
new SqlParameter("@RightLevel", SqlDbType.Int, 4),
new SqlParameter("@OperatorID", SqlDbType.Int, 4),
new SqlParameter("@CreateDate", SqlDbType.DateTime)
};
parameters[0].Value = model.RightID;
parameters[1].Value = model.RightName;
parameters[2].Value = model.RightCode;
parameters[3].Value = model.DispOrder;
parameters[4].Value = model.Is_Locked;
parameters[5].Value = model.ParentID;
parameters[6].Value = model.Remark;
parameters[7].Value = model.RightLevel;
parameters[8].Value = model.OperatorID;
parameters[9].Value = model.CreateDate;
object single = DbHelperSQL.GetSingle(stringBuilder.ToString(), parameters);
int result;
if (single == null)
{
result = 0;
}
else
{
result = Convert.ToInt32(single);
}
return(result);
}
public PEIS.Model.SYSRight GetModel(int RightID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 RightID,RightName,RightCode,DispOrder,Is_Locked,ParentID,Remark,RightLevel,OperatorID,CreateDate from SYSRight ");
strSql.Append(" where RightID=@RightID ");
SqlParameter[] parameters =
{
new SqlParameter("@RightID", SqlDbType.Int, 4)
};
parameters[0].Value = RightID;
PEIS.Model.SYSRight model = new PEIS.Model.SYSRight();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public void SaveRightNodeItem()
{
int num = 0;
int @int = base.GetInt("type", 0);
int num2 = base.GetInt("txtRightID", 0);
int num3 = base.GetInt("txtCurrentLevel", 0);
string @string = base.GetString("txtRightName");
string string2 = base.GetString("txtRightCode");
int value = base.GetInt("txtParentRightID", 0);
int int2 = base.GetInt("txtDispOrder", 0);
int int3 = base.GetInt("IsLockedRight", 0);
switch (@int)
{
case 1:
num3 = 1;
value = 0;
num2 = 0;
break;
case 2:
num3++;
value = num2;
num2 = 0;
break;
case 3:
break;
default:
num = -2;
break;
}
if (num >= 0)
{
PEIS.Model.SYSRight sysRight = new PEIS.Model.SYSRight();
sysRight.RightID = num2;
sysRight.RightLevel = new int?(num3);
sysRight.RightName = Input.URLDecode(@string);
sysRight.RightCode = Input.URLDecode(string2);
sysRight.DispOrder = int2;
sysRight.Is_Locked = int3;
sysRight.OperatorID = new int?(this.LoginUserModel.UserID);
sysRight.CreateDate = DateTime.Now;
sysRight.ParentID = new int?(value);
SqlConditionInfo[] conditions = new SqlConditionInfo[]
{
new SqlConditionInfo("@RightCode", sysRight.RightCode, TypeCode.String)
};
string querySqlCode = "QueryRightCodeInfo_Param";
try
{
DataSet dataSet = CommonRight.Instance.ExcuteQuerySql(querySqlCode, conditions);
int count = dataSet.Tables[0].Rows.Count;
switch (@int)
{
case 1:
case 2:
if (count > 0)
{
num = -1;
}
else
{
num = PEIS.BLL.SYSRight.Instance.Add(sysRight);
if (num > 0)
{
Log4J.Instance.Info(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",新增权限 权限名称：",
sysRight.RightName,
",ID:",
num,
",权限值:",
sysRight.RightCode
}));
}
else
{
Log4J.Instance.Error(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",新增权限失败 权限名称：",
sysRight.RightName,
",ID:",
num,
",权限值:",
sysRight.RightCode
}));
}
}
break;
case 3:
if (count > 0 && int.Parse(dataSet.Tables[0].Rows[0][0].ToString()) != sysRight.RightID)
{
num = -1;
}
else
{
num = (PEIS.BLL.SYSRight.Instance.Update(sysRight) ? 1 : 0);
if (num > 0)
{
Log4J.Instance.Info(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",修改权限 权限名称：",
sysRight.RightName,
",ID:",
sysRight.RightID,
",权限值:",
sysRight.RightCode
}));
}
else
{
Log4J.Instance.Error(string.Concat(new object[]
{
Public.GetClientIP(),
",",
this.LoginUserModel.UserName,
",修改权限失败 权限名称：",
sysRight.RightName,
",ID:",
sysRight.RightID,
",权限值:",
sysRight.RightCode
}));
}
}
break;
default:
num = -2;
break;
}
}
catch (Exception ex)
{
num = 0;
}
}
this.OutPutMessage(num.ToString());
}
public bool Update(PEIS.Model.SYSRight model)
{
return(this.dal.Update(model));
}
public int Add(PEIS.Model.SYSRight model)
{
return(this.dal.Add(model));
}
