/// <summary>
/// 保存按钮点击事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSubmit_Click(object sender, EventArgs e)
{
DiBao_Type DiBaoType = new DiBao_Type();
DiBaoType.Name = txtName.Text;
DiBaoType.TypeLevel = drpTypeLevel.SelectedItem.Text;
DiBaoType.CheckCyc = decimal.Parse(txtCheckCyc.Text);
if (hdId.Value == "0")
{
if (Ctrl_Ass_DiBao.AddDiBao_Type(DiBaoType) > 0)
MessageBox.ShowAndRedirect(this, "添加成功!", "DiBao_Type_List.aspx");
else
MessageBox.ShowAndRedirect(this, "添加失败!", "DiBao_Type_List.aspx");
}
else
{
DiBaoType.Id = int.Parse(hdId.Value);
if (Ctrl_Ass_DiBao.UpdateDiBao_Type(DiBaoType))
MessageBox.ShowAndRedirect(this, "修改成功!", "DiBao_Type_List.aspx");
else
MessageBox.ShowAndRedirect(this, "修改失败!", "DiBao_Type_List.aspx");
}
}
/// <summary>
/// 根据Id获取低保类别信息
/// </summary>
/// <param name="Id">低保类别Id</param>
/// <returns>低保类别信息实体</returns>
public static DiBao_Type GetDiBao_TypeInfoById(int Id)
{
DiBao_Type DiBaoType = new DiBao_Type();
DataSet ds = new DataSet();
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select *");
strSql.Append(" from DiBao_Type");
strSql.Append(" where Id=" + Id);
ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
DiBaoType.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
if (ds.Tables[0].Rows[0]["Name"] != null && ds.Tables[0].Rows[0]["Name"].ToString() != "")
{
DiBaoType.Name = ds.Tables[0].Rows[0]["Name"].ToString();
}
if (ds.Tables[0].Rows[0]["TypeLevel"] != null && ds.Tables[0].Rows[0]["TypeLevel"].ToString() != "")
{
DiBaoType.TypeLevel = ds.Tables[0].Rows[0]["TypeLevel"].ToString();
}
if (ds.Tables[0].Rows[0]["CheckCyc"] != null && ds.Tables[0].Rows[0]["CheckCyc"].ToString() != "")
{
DiBaoType.CheckCyc = decimal.Parse(ds.Tables[0].Rows[0]["CheckCyc"].ToString());
}
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return DiBaoType;
}
/// <summary>
/// 添加低保类别
/// </summary>
/// <param name="DiBaoType">低保类别实体</param>
/// <returns>成功返回1 否则返回0</returns>
public static int AddDiBao_Type(DiBao_Type DiBaoType)
{
int iExecute = 0;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DiBao_Type (");
strSql.Append("Name,TypeLevel,CheckCyc");
strSql.Append(") values (");
strSql.Append("@Name,@TypeLevel,@CheckCyc");
strSql.Append(");select @@IDENTITY");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name",SqlDbType.NVarChar,50),
new SqlParameter("@TypeLevel",SqlDbType.NVarChar,50),
new SqlParameter("@CheckCyc",SqlDbType.Decimal,18)
};
para[0].Value = DiBaoType.Name;
para[1].Value = DiBaoType.TypeLevel;
para[2].Value = DiBaoType.CheckCyc;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), para);
if (obj != null)
{
iExecute = Convert.ToInt32(obj);
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return iExecute;
}
/// <summary>
/// 更新一条低保类别信息
/// </summary>
/// <param name="DiBaoType">低保类别实体</param>
/// <returns>成功返回ture 否则返回false</returns>
public static bool UpdateDiBao_Type(DiBao_Type DiBaoType)
{
bool bz = false;
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("Update DiBao_Type set ");
strSql.Append("Name=@Name,");
strSql.Append("TypeLevel=@TypeLevel,");
strSql.Append("CheckCyc=@CheckCyc");
strSql.Append(" where Id=@Id");
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@Name",SqlDbType.NVarChar,50),
new SqlParameter("@TypeLevel",SqlDbType.NVarChar,50),
new SqlParameter("@CheckCyc",SqlDbType.Decimal,18),
new SqlParameter("@Id",SqlDbType.Int)
};
para[0].Value = DiBaoType.Name;
para[1].Value = DiBaoType.TypeLevel;
para[2].Value = DiBaoType.CheckCyc;
para[3].Value = DiBaoType.Id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), para);
if (rows > 0)
{
bz = true;
}
}
catch (Exception e)
{
Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetPageUserInfoList" + e.Message);
}
return bz;
}
