public void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtF_Power.Text.Trim().Length == 0)
{
strErr += "权限不能为空！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int F_RoleID = int.Parse(this.lblF_RoleID.Text);
bool F_IsUsed = this.chkF_IsUsed.Checked;
string F_Power = this.txtF_Power.Text;
WSS.Model.Roles model = new WSS.Model.Roles();
model.F_RoleID = F_RoleID;
model.F_IsUsed = F_IsUsed;
model.F_Power = F_Power;
WSS.BLL.Roles bll = new WSS.BLL.Roles();
bll.Update(model);
Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功！", "list.aspx");
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <WSS.Model.Roles> DataTableToList(DataTable dt)
{
List <WSS.Model.Roles> modelList = new List <WSS.Model.Roles>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
WSS.Model.Roles model;
for (int n = 0; n < rowsCount; n++)
{
model = new WSS.Model.Roles();
if (dt.Rows[n]["F_RoleID"].ToString() != "")
{
model.F_RoleID = int.Parse(dt.Rows[n]["F_RoleID"].ToString());
}
if (dt.Rows[n]["F_IsUsed"].ToString() != "")
{
if ((dt.Rows[n]["F_IsUsed"].ToString() == "1") || (dt.Rows[n]["F_IsUsed"].ToString().ToLower() == "true"))
{
model.F_IsUsed = true;
}
else
{
model.F_IsUsed = false;
}
}
model.F_Power = dt.Rows[n]["F_Power"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WSS.Model.Roles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Roles set ");
strSql.Append("F_IsUsed=@F_IsUsed,");
strSql.Append("F_Power=@F_Power");
strSql.Append(" where F_RoleID=@F_RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1),
new SqlParameter("@F_Power", SqlDbType.NChar, 300),
new SqlParameter("@F_RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = model.F_IsUsed;
parameters[1].Value = model.F_Power;
parameters[2].Value = model.F_RoleID;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WSS.Model.Roles model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Roles(");
strSql.Append("F_IsUsed,F_Power)");
strSql.Append(" values (");
strSql.Append("@F_IsUsed,@F_Power)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@F_IsUsed", SqlDbType.Bit, 1),
new SqlParameter("@F_Power", SqlDbType.NChar, 300)
};
parameters[0].Value = model.F_IsUsed;
parameters[1].Value = model.F_Power;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
private void ShowInfo(int F_RoleID)
{
WSS.BLL.Roles bll = new WSS.BLL.Roles();
WSS.Model.Roles model = bll.GetModel(F_RoleID);
this.lblF_RoleID.Text = model.F_RoleID.ToString();
this.chkF_IsUsed.Checked = model.F_IsUsed;
this.txtF_Power.Text = model.F_Power;
}
private void ShowInfo(int F_RoleID)
{
WSS.BLL.Roles bll = new WSS.BLL.Roles();
WSS.Model.Roles model = bll.GetModel(F_RoleID);
this.lblF_RoleID.Text = model.F_RoleID.ToString();
this.lblF_IsUsed.Text = model.F_IsUsed?"ÊÇ":"·ñ";
this.lblF_Power.Text = model.F_Power;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WSS.Model.Roles GetModel(int F_RoleID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 F_RoleID,F_IsUsed,F_Power from T_Roles ");
strSql.Append(" where F_RoleID=@F_RoleID");
SqlParameter[] parameters =
{
new SqlParameter("@F_RoleID", SqlDbType.Int, 4)
};
parameters[0].Value = F_RoleID;
WSS.Model.Roles model = new WSS.Model.Roles();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["F_RoleID"].ToString() != "")
{
model.F_RoleID = int.Parse(ds.Tables[0].Rows[0]["F_RoleID"].ToString());
}
if (ds.Tables[0].Rows[0]["F_IsUsed"].ToString() != "")
{
if ((ds.Tables[0].Rows[0]["F_IsUsed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsUsed"].ToString().ToLower() == "true"))
{
model.F_IsUsed = true;
}
else
{
model.F_IsUsed = false;
}
}
if (ds.Tables[0].Rows[0]["F_Power"] != null)
{
model.F_Power = ds.Tables[0].Rows[0]["F_Power"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WSS.Model.Roles model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WSS.Model.Roles model)
{
return(dal.Add(model));
}
