/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ColoPay.Model.SysManage.ConfigArea model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SA_Config_Area set ");
strSql.Append("Status=@Status");
strSql.Append(" where AreaName=@AreaName ");
SqlParameter[] parameters =
{
new SqlParameter("@Status", SqlDbType.SmallInt, 2),
new SqlParameter("@AreaName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.Status;
parameters[1].Value = model.AreaName;
int rows = DBHelper.DefaultDBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ColoPay.Model.SysManage.ConfigArea model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SA_Config_Area(");
strSql.Append("AreaName,Status)");
strSql.Append(" values (");
strSql.Append("@AreaName,@Status)");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 50),
new SqlParameter("@Status", SqlDbType.SmallInt, 2)
};
parameters[0].Value = model.AreaName;
parameters[1].Value = model.Status;
int rows = DBHelper.DefaultDBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
//新增系统指令
protected void btnSave_Click(object sender, EventArgs e)
{
ColoPay.Model.SysManage.ConfigArea areaModel = new ColoPay.Model.SysManage.ConfigArea();
if (String.IsNullOrWhiteSpace(tName.Text))
{
YSWL.Common.MessageBox.ShowFailTip(this, "请输入区域名称！");
return;
}
if (areaBll.Exists(tName.Text))
{
YSWL.Common.MessageBox.ShowFailTip(this, "该区域名称已存在！");
return;
}
areaModel.AreaName = this.tName.Text;
areaModel.Status = chkStatus.Checked ? 1 : 0;
if (areaBll.Add(areaModel))
{
YSWL.Common.MessageBox.ShowSuccessTip(this, "新增成功！");
gridView.OnBind();
}
else
{
YSWL.Common.MessageBox.ShowFailTip(this, "新增失败！");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ColoPay.Model.SysManage.ConfigArea DataRowToModel(DataRow row)
{
ColoPay.Model.SysManage.ConfigArea model = new ColoPay.Model.SysManage.ConfigArea();
if (row != null)
{
if (row["AreaName"] != null)
{
model.AreaName = row["AreaName"].ToString();
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ColoPay.Model.SysManage.ConfigArea GetModel(string AreaName)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 AreaName,Status from SA_Config_Area ");
strSql.Append(" where AreaName=@AreaName ");
SqlParameter[] parameters =
{
new SqlParameter("@AreaName", SqlDbType.NVarChar, 50)
};
parameters[0].Value = AreaName;
ColoPay.Model.SysManage.ConfigArea model = new ColoPay.Model.SysManage.ConfigArea();
DataSet ds = DBHelper.DefaultDBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
