public int InsertFix(FixModel fix)
{
SqlParameter[] param = { new SqlParameter("@FixID", SqlDbType.VarChar, 18), new SqlParameter("@Name", SqlDbType.VarChar, 20),
new SqlParameter("@Amount",SqlDbType.Int),new SqlParameter("@Factory",SqlDbType.VarChar,20),
new SqlParameter("@FactoryDate",SqlDbType.DateTime,10)
};
param[0].Value = fix.FixID;
param[1].Value = fix.Name;
param[2].Value = fix.Amount;
param[3].Value = fix.Factory;
param[4].Value = fix.FactoryDate;
int result = SqlHelp.ExecuteNonQuery("prc_InsertFix", CommandType.StoredProcedure, param);
return result;
}
public List<FixModel> GetAllFix()
{
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllFix", CommandType.StoredProcedure);
List<FixModel> list = new List<FixModel>();
while (dr.Read())
{
FixModel fix = new FixModel();
fix.FixID = dr[0].ToString();
fix.Name = dr[1].ToString();
fix.Amount = Convert.ToInt32(dr[2]);
fix.Factory = dr[3].ToString();
fix.FactoryDate = Convert.ToDateTime(dr[4]);
list.Add(fix);
}
dr.Close();
return list;
}
protected void Add_Click(object sender, EventArgs e)
{
FixModel fix = new FixModel();
fix.FixID = lbID.Text;
fix.Name = txtFixName.Text.Trim();
fix.Amount = Convert.ToInt32(txtFixAmount.Text.Trim());
fix.Factory = txtFixFactory.Text.Trim();
fix.FactoryDate = Convert.ToDateTime(txtFixFactoryDate.Value);
bool flag = bll.InsertFix(fix);
if (flag)
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加成功');location.href='FixInfo.aspx';</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "OnSubmit", "<script>alert('添加失败');</script>");
}
}
public List<FixModel> GetFixByCondition(string condition)
{
SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255);
param.Value = condition;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixByCondition", CommandType.StoredProcedure,param);
List<FixModel> list = new List<FixModel>();
while (dr.Read())
{
FixModel fix = new FixModel();
fix.FixID = dr[0].ToString();
fix.Name = dr[1].ToString();
fix.Amount = Convert.ToInt32(dr[2]);
fix.Factory = dr[3].ToString();
fix.FactoryDate = Convert.ToDateTime(dr[4]);
list.Add(fix);
}
dr.Close();
return list;
}
public FixModel GetFixByID(string fixID)
{
SqlParameter param = new SqlParameter("@FixID", SqlDbType.VarChar, 18);
param.Value = fixID;
SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixByID", CommandType.StoredProcedure, param);
List<FixModel> list = new List<FixModel>();
dr.Read();
FixModel fix = new FixModel();
if (dr.HasRows)
{
fix.FixID = dr[0].ToString();
fix.Name = dr[1].ToString();
fix.Amount = Convert.ToInt32(dr[2]);
fix.Factory = dr[3].ToString();
fix.FactoryDate = Convert.ToDateTime(dr[4]);
}
dr.Close();
return fix;
}
public bool InsertFix(FixModel fix)
{
int result = dal.InsertFix(fix);
return result == 0 ? false : true;
}
public bool UpdateFix(FixModel fix)
{
int result = dal.UpdateFix(fix);
return result == 0 ? false : true;
}
