public static bool Insert(Model.RolePowers model)
{
string sb = "insert into RolePowers(RType,CID,IFVerify) values (@RType,@CID,@IFVerify);";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RType", SqlDbType.VarChar, 10),
new SqlParameter("@CID", SqlDbType.VarChar, 10),
new SqlParameter("@IFVerify", SqlDbType.Bit, 1)
};
para[0].Value = model.RType;
para[1].Value = model.CID;
para[2].Value = model.IFVerify;
return(DbHelperSQL.ExecuteSql(sb, para) > 0);
}
protected List<Model.RolePowers> rolePowersList()
{
List<Model.RolePowers> list = new List<Model.RolePowers>();
string roleList = Request.Form["chkAuth"];
if (!string.IsNullOrEmpty(roleList))
{
string[] array = roleList.Split(',');
foreach (string str in array)
{
Model.RolePowers obj = new Model.RolePowers();
obj.CID = menu.CID;
obj.IFVerify = true;
obj.RType = str;
list.Add(obj);
}
}
return list;
}
private static Model.RolePowers TranEntity(DataRow dr)
{
Model.RolePowers model = new Model.RolePowers();
if (dr["RType"].ToString() != "")
{
model.RType = dr["RType"].ToString();
}
if (dr["CID"].ToString() != "")
{
model.CID = dr["CID"].ToString();
model.Content = DAL.Contents.List.Single(emp => emp.CID == model.CID);
}
if (dr["IFVerify"].ToString() != "")
{
model.IFVerify = bool.Parse(dr["IFVerify"].ToString());
}
if (dr["RID"].ToString() != "")
{
model.RID = int.Parse(dr["RID"].ToString());
}
return(model);
}
public static bool Update(Model.RolePowers model)
{
StringBuilder sb = new StringBuilder("update RolePowers set ");
sb.Append("IFVerify=@IFVerify,");
sb.Append("RType=@RType,");
sb.Append("CID=@CID");
sb.Append(" where ");
sb.Append("RID=@RID");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@RType", SqlDbType.VarChar, 20),
new SqlParameter("@CID", SqlDbType.VarChar, 20),
new SqlParameter("@IFVerify", SqlDbType.Bit, 1),
new SqlParameter("@RID", SqlDbType.Int, 4)
};
para[0].Value = model.RType;
para[1].Value = model.CID;
para[2].Value = model.IFVerify;
para[3].Value = model.RID;
return(DbHelperSQL.ExecuteSql(sb.ToString(), para) > 0);
}
public static bool Update(Model.RolePowers model)
{
return(DAL.RolePowers.Update(model));
}
public static bool Insert(Model.RolePowers model)
{
return(DAL.RolePowers.Insert(model));
}