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;
}
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;
}
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 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;
}
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 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;
}
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 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;
}
