public List <FixRepairModel> GetFixRepairByCondition(string condition)
{
SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255);
param.Value = condition;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixRepairByCondition", CommandType.StoredProcedure, param);
List <FixRepairModel> list = new List <FixRepairModel>();
while (dr.Read())
{
FixRepairModel fixRepair = new FixRepairModel();
fixRepair.ID = Convert.ToInt32(dr[0]);
fixRepair.FixID = dr[1].ToString();
fixRepair.FixName = dr[2].ToString();
fixRepair.RepairDate = Convert.ToDateTime(dr[3]);
fixRepair.EndDate = Convert.ToDateTime(dr[4]);
fixRepair.MainHead = dr[5].ToString();
fixRepair.ServiceFee = Convert.ToDouble(dr[6]);
fixRepair.MaterielFee = Convert.ToDouble(dr[7]);
fixRepair.RepairSum = Convert.ToDouble(dr[8]);
fixRepair.RepairMemo = dr[9].ToString();
fixRepair.Sign = Convert.ToInt32(dr[10]);
fixRepair.RepairUnit = dr[11].ToString();
list.Add(fixRepair);
}
dr.Close();
return(list);
}
protected void Add_Click(object sender, EventArgs e)
{
FixRepairModel fixRepair = new FixRepairModel();
fixRepair.FixID = DDLFixName.SelectedValue;
fixRepair.RepairDate = Convert.ToDateTime(txtRepairDate.Value.Trim());
fixRepair.EndDate = Convert.ToDateTime(txtEndDate.Value.Trim());
fixRepair.MainHead = txtMainHead.Text.Trim();
fixRepair.ServiceFee = Convert.ToDouble(txtServiceFee.Text.Trim());
fixRepair.MaterielFee = Convert.ToDouble(txtMaterielFee.Text.Trim());
fixRepair.RepairSum = Convert.ToDouble(txtSum.Text);
fixRepair.RepairMemo = ftbMemo.Text.Trim();
fixRepair.Sign = Convert.ToInt32(rblSign.SelectedValue.Trim());
fixRepair.RepairUnit = txtRepairUnit.Text.Trim();
bool flag = bll.InsertFixRepair(fixRepair);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='FixRepairInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
public FixRepairModel GetFixRepairByID(int id)
{
SqlParameter param = new SqlParameter("@ID", SqlDbType.Int);
param.Value = id;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixRepairByID", CommandType.StoredProcedure);
dr.Read();
FixRepairModel fixRepair = new FixRepairModel();
if (dr.HasRows)
{
fixRepair.ID = Convert.ToInt32(dr[0]);
fixRepair.FixID = dr[1].ToString();
fixRepair.FixName = dr[2].ToString();
fixRepair.RepairDate = Convert.ToDateTime(dr[3]);
fixRepair.EndDate = Convert.ToDateTime(dr[4]);
fixRepair.MainHead = dr[5].ToString();
fixRepair.ServiceFee = Convert.ToDouble(dr[6]);
fixRepair.MaterielFee = Convert.ToDouble(dr[7]);
fixRepair.RepairSum = Convert.ToDouble(dr[8]);
fixRepair.RepairMemo = dr[9].ToString();
fixRepair.Sign = Convert.ToInt32(dr[10]);
fixRepair.RepairUnit = dr[11].ToString();
}
dr.Close();
return(fixRepair);
}
public List <FixRepairModel> GetAllFixRepair()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllFixRepair", CommandType.StoredProcedure);
List <FixRepairModel> list = new List <FixRepairModel>();
while (dr.Read())
{
FixRepairModel fixRepair = new FixRepairModel();
fixRepair.ID = Convert.ToInt32(dr[0]);
fixRepair.FixID = dr[1].ToString();
fixRepair.FixName = dr[2].ToString();
fixRepair.RepairDate = Convert.ToDateTime(dr[3]);
fixRepair.EndDate = Convert.ToDateTime(dr[4]);
fixRepair.MainHead = dr[5].ToString();
fixRepair.ServiceFee = Convert.ToDouble(dr[6]);
fixRepair.MaterielFee = Convert.ToDouble(dr[7]);
fixRepair.RepairSum = Convert.ToDouble(dr[8]);
fixRepair.RepairMemo = dr[9].ToString();
fixRepair.Sign = Convert.ToInt32(dr[10]);
fixRepair.RepairUnit = dr[11].ToString();
list.Add(fixRepair);
}
dr.Close();
return(list);
}
public int UpdateFixRepairForSign(FixRepairModel fixRepair)
{
SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@Sign", SqlDbType.Int) };
param[0].Value = fixRepair.ID;
param[1].Value = fixRepair.Sign;
int result = SqlHelp.ExecuteNonQuery("prc_UpdateFixRepairForSign", CommandType.StoredProcedure, param);
return(result);
}
protected void FixRepairGridView_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
{
FixRepairModel fixRepair = new FixRepairModel();
fixRepair.ID = Convert.ToInt32(FixRepairGridView.DataKeys[e.NewSelectedIndex].Value);
fixRepair.Sign = 0;
bll.UpdateFixRepairForSign(fixRepair);
FixRepairGridView.DataSource = bll.GetAllFixRepair();
FixRepairGridView.DataBind();
}
public int UpdateFixRepair(FixRepairModel fixRepair)
{
SqlParameter[] param = { new SqlParameter("@FixID", SqlDbType.VarChar, 18), new SqlParameter("@RepairDate", SqlDbType.DateTime, 10),
new SqlParameter("@EndDate", SqlDbType.DateTime, 10), new SqlParameter("@MainHead", SqlDbType.VarChar, 20),
new SqlParameter("@ServiceFee", SqlDbType.Money), new SqlParameter("@MaterielFee", SqlDbType.Money),
new SqlParameter("@RepairSum", SqlDbType.Money), new SqlParameter("@RepairMemo", SqlDbType.Text),
new SqlParameter("@Sign", SqlDbType.Int), new SqlParameter("@RepairUnit", SqlDbType.VarChar, 50) };
param[0].Value = fixRepair.FixID;
param[1].Value = fixRepair.RepairDate;
param[2].Value = fixRepair.EndDate;
param[3].Value = fixRepair.MainHead;
param[4].Value = fixRepair.ServiceFee;
param[5].Value = fixRepair.MaterielFee;
param[6].Value = fixRepair.RepairSum;
param[7].Value = fixRepair.RepairMemo;
param[8].Value = fixRepair.Sign;
param[9].Value = fixRepair.RepairUnit;
int result = SqlHelp.ExecuteNonQuery("prc_UpdateFixRepair", CommandType.StoredProcedure, param);
return(result);
}
public bool InsertFixRepair(FixRepairModel fixRepair)
{
int result = dal.InsertFixRepair(fixRepair);
return(result == 0 ? false : true);
}
public bool UpdateFixRepairForSign(FixRepairModel fixRepair)
{
int result = dal.UpdateFixRepairForSign(fixRepair);
return(result == 0 ? false : true);
}
