public int UpdateHomeFreeForBargian(HomeFreeModel homeFree)
{
SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@FactPayMent", SqlDbType.Money),
new SqlParameter("@HandleName",SqlDbType.VarChar,20)
};
param[0].Value = homeFree.ID;
param[1].Value = homeFree.FactPayment;
param[2].Value = homeFree.HandleName;
int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeFreeForBargian", CommandType.StoredProcedure, param);
return result;
}
public int InsertHomeFree(HomeFreeModel homeFree)
{
SqlParameter[] param = { new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@TypeID", SqlDbType.Int),
new SqlParameter("@Number",SqlDbType.Float),new SqlParameter("@StartDate",SqlDbType.DateTime,10),
new SqlParameter("@PayDate",SqlDbType.DateTime,10),new SqlParameter("@AddName",SqlDbType.VarChar,20)
};
param[0].Value = homeFree.Code;
param[1].Value = homeFree.TypeID;
param[2].Value = homeFree.Number;
param[3].Value = homeFree.StartDate;
param[4].Value = homeFree.PayDate;
param[5].Value = homeFree.AddName;
int result = SqlHelp.ExecuteNonQuery("prc_InsertHomeChargeFee", CommandType.StoredProcedure, param);
return result;
}
protected void Add_Click(object sender, EventArgs e)
{
HomeFreeBLL bll = new HomeFreeBLL();
HomeFreeModel homeFree = new HomeFreeModel();
homeFree.Code = DDLRoomID.SelectedValue;
homeFree.TypeID = Convert.ToInt32(DDLType.SelectedValue);
homeFree.Number = Convert.ToDouble(txtNumber.Text.Trim());
homeFree.StartDate = Convert.ToDateTime(txtBuildDate.Value);
homeFree.PayDate = DateTime.Now;
homeFree.AddName = user.Name;
bool flag = bll.InsertHomeFree(homeFree);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='ChargeFeeInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
public List<HomeFreeModel> GetHomeFree()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetHomeFree", CommandType.StoredProcedure);
List<HomeFreeModel> list = new List<HomeFreeModel>();
while (dr.Read())
{
HomeFreeModel homefree = new HomeFreeModel();
homefree.ID = Convert.ToInt32(dr[0]);
homefree.TypeName = dr[1].ToString();
homefree.Payment = Convert.ToDouble(dr[2]);
homefree.NotPayment = Convert.ToDouble(dr[3]);
homefree.StartDate = Convert.ToDateTime(dr[4]);
homefree.AddName = dr[5].ToString();
homefree.HandleName = dr[6].ToString();
homefree.RoomID = dr[7].ToString();
list.Add(homefree);
}
dr.Close();
return list;
}
public List<HomeFreeModel> GetHomeFreeByCode(string code)
{
SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 20);
param.Value = code;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetHomeFreeByCode", CommandType.StoredProcedure, param);
List<HomeFreeModel> list = new List<HomeFreeModel>();
while (dr.Read())
{
HomeFreeModel homefree = new HomeFreeModel();
homefree.TypeName = dr[0].ToString();
homefree.Number = Convert.ToDouble(dr[1]);
homefree.Price = Convert.ToDouble(dr[2]);
homefree.Payment = Convert.ToDouble(dr[3]);
homefree.NotPayment = Convert.ToDouble(dr[4]);
homefree.StartDate = Convert.ToDateTime(dr[5]);
homefree.PayDate = Convert.ToDateTime(dr[6]);
homefree.AddName = dr[7].ToString();
list.Add(homefree);
}
dr.Close();
return list;
}
protected void HomeFreeGridView_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
HomeFreeModel homeFree = new HomeFreeModel();
homeFree.ID = Convert.ToInt32(HomeFreeGridView.DataKeys[e.NewSelectedIndex].Value);
homeFree.FactPayment = Convert.ToDouble(HomeFreeGridView.Rows[e.NewSelectedIndex].Cells[3].Text);
homeFree.HandleName = user.Name;
bool flag = bll.UpdateHomeFreeForBargian(homeFree);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改成功');</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('修改失败');</script>");
}
HomeFreeGridView.DataSource = bll.GetHomeFree();
HomeFreeGridView.DataBind();
}
public bool InsertHomeFree(HomeFreeModel homeFree)
{
int result = dal.InsertHomeFree(homeFree);
return result == 0 ? false : true;
}
public bool UpdateHomeFreeForBargian(HomeFreeModel homeFree)
{
int result = dal.UpdateHomeFreeForBargian(homeFree);
return result == 0 ? false : true;
}
