public int InsertHomeRepair(HomeRepairModel homerepair)
{
SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@Code", SqlDbType.VarChar, 9),
new SqlParameter("@RepairText",SqlDbType.Text),new SqlParameter("@RepairMemo",SqlDbType.Text)
};
param[0].Value = homerepair.ID;
param[1].Value = homerepair.Code;
param[2].Value = homerepair.RepairText;
param[3].Value = homerepair.RepairMemo;
int result = SqlHelp.ExecuteNonQuery("prc_InsertHomeRepair", CommandType.StoredProcedure, param);
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
homerepair.ID = Request.QueryString["ID"].ToString();
user = (UserModel)Session["User"];
if (Session["User"] == null || Session["User"].ToString() == "" || user.UserType != 1)
Response.Redirect("../Login.aspx");
else
{
homerepair = bll.ShowHomeRepairByID(homerepair.ID);
lbRepairText.Text = homerepair.RepairText;
lbRepairDate.Text = homerepair.RepairDate.ToString("yyy年MM月dd日");
lbRepairMemo.Text = homerepair.RepairMemo;
}
}
protected void Add_Click(object sender, EventArgs e)
{
HomeRepairModel homerepair = new HomeRepairModel();
homerepair.ID = lbID.Text;
homerepair.Code = user.Code;
homerepair.RepairText = txtTitle.Text.Trim();
homerepair.RepairMemo = txtMemo.Text.Trim();
bool flag=bll.InsertHomeRepair(homerepair);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='MyHomeRepair.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request.QueryString["ID"].ToString();
user = (UserModel)Session["User"];
if (Session["User"] == null || Session["User"].ToString() == "" || user.UserType != 0)
Response.Redirect("../Login.aspx");
else
{
if (!IsPostBack)
{
homerepair = bll.ShowHomeRepairByID(id);
lbID.Text = homerepair.ID;
txtTitle.Text = homerepair.RepairText;
txtMemo.Text = homerepair.RepairMemo;
}
}
}
public List<HomeRepairModel> GetHomeRepair()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetHomeRepair", CommandType.StoredProcedure);
List<HomeRepairModel> list = new List<HomeRepairModel>();
while (dr.Read())
{
HomeRepairModel homerepair = new HomeRepairModel();
homerepair.ID = dr[0].ToString();
homerepair.Code = dr[1].ToString();
homerepair.RepairDate = Convert.ToDateTime(dr[2]);
homerepair.RepairText = dr[3].ToString();
homerepair.Sign = Convert.ToInt32(dr[4]);
homerepair.RoomID = dr[5].ToString();
list.Add(homerepair);
}
dr.Close();
return list;
}
public List<HomeRepairModel> ShowHomeRepairByCode(string code)
{
SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 20);
param.Value = code;
SqlDataReader dr= SqlHelp.ExecuteReader("prc_GetHomeRepairByCode", CommandType.StoredProcedure, param);
List<HomeRepairModel> list = new List<HomeRepairModel>();
while (dr.Read())
{
HomeRepairModel homerepair = new HomeRepairModel();
homerepair.ID = dr[0].ToString();
homerepair.Code = dr[1].ToString();
homerepair.RepairDate = Convert.ToDateTime(dr[2]);
homerepair.RepairText = dr[3].ToString();
homerepair.Sign = Convert.ToInt32(dr[4]);
list.Add(homerepair);
}
dr.Close();
return list;
}
public HomeRepairModel ShowHomeRepairByID(string id)
{
SqlParameter param = new SqlParameter("@ID", SqlDbType.VarChar, 18);
param.Value = id;
SqlDataReader dr= SqlHelp.ExecuteReader("prc_GetHomeRepairByID", CommandType.StoredProcedure, param);
HomeRepairModel homerepair= new HomeRepairModel();
dr.Read();
if (dr.HasRows)
{
homerepair.ID = dr[0].ToString();
homerepair.RepairText = dr[1].ToString();
homerepair.RepairMemo = dr[2].ToString();
homerepair.RepairDate = (DateTime)dr[3];
homerepair.Varperson = dr[4].ToString();
homerepair.VarText = dr[5].ToString();
homerepair.RepairUnit = dr[6].ToString();
homerepair.OwnerText = dr[7].ToString();
}
dr.Close();
return homerepair;
}
public int UpdateHomeRepairCheck(HomeRepairModel homerepair)
{
SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@OwnerText", SqlDbType.Text) };
param[0].Value = homerepair.ID;
param[1].Value = homerepair.OwnerText;
int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeRepairCheck", CommandType.StoredProcedure, param);
return result;
}
public int UpdateHomeRepairForProcess(HomeRepairModel homerepair)
{
SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@Varperson", SqlDbType.VarChar, 20),
new SqlParameter("@VarText",SqlDbType.Text),new SqlParameter("@RepairUnit",SqlDbType.VarChar,50)
};
param[0].Value = homerepair.ID;
param[1].Value = homerepair.Varperson;
param[2].Value = homerepair.VarText;
param[3].Value = homerepair.RepairUnit;
int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeRepairForProcess", CommandType.StoredProcedure, param);
return result;
}
public bool UpdateHomeRepairCheck(HomeRepairModel homerepair)
{
int result = dal.UpdateHomeRepairCheck(homerepair);
return result == 0 ? false : true;
}
public bool UpdateHomeRepairForProcess(HomeRepairModel homerepair)
{
int result = dal.UpdateHomeRepairForProcess(homerepair);
return result == 0 ? false : true;
}
public bool InsertHomeRepair(HomeRepairModel homerepair)
{
int result = dal.InsertHomeRepair(homerepair);
return result == 0 ? false : true;
}