public int BaseInfo_UpdateProduct(MineProductModel model)
{
SqlParameter[] paras =
{
new SqlParameter("@SafeBeginTime",SqlDbType.DateTime),
new SqlParameter("@YearProduction",SqlDbType.Float),
new SqlParameter("@MonthProduction",SqlDbType.Float),
new SqlParameter("@DayProduction",SqlDbType.Float)
};
paras[0].Value = model.SafeBeginTime;
paras[1].Value = model.YearProduction;
paras[2].Value = model.MonthProduction;
paras[3].Value = model.DayProduction;
try
{
int iReturn;
DbHelperSQL.RunProcedure("Mine_BaseInfo_UpdateProduct", paras, out iReturn);
return iReturn;
}
catch
{
return -1;
}
}
public MineProductModel BaseInfo_GetProduct()
{
DataSet ds = BaseInfo_GetList("SafeBeginTime,YearProduction,MonthProduction,DayProduction", "1=1");
try
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
MineProductModel model = new MineProductModel();
model.SafeBeginTime = ds.Tables[0].Rows[0]["SafeBeginTime"].ToString().Equals("") ? DateTime.Now : DateTime.Parse(ds.Tables[0].Rows[0]["SafeBeginTime"].ToString());
model.YearProduction =ds.Tables[0].Rows[0]["YearProduction"].ToString().Equals("") ? 0:float.Parse(ds.Tables[0].Rows[0]["YearProduction"].ToString());
model.MonthProduction =ds.Tables[0].Rows[0]["MonthProduction"].ToString().Equals("") ?0: float.Parse(ds.Tables[0].Rows[0]["MonthProduction"].ToString());
model.DayProduction =ds.Tables[0].Rows[0]["DayProduction"].ToString().Equals("") ?0: float.Parse(ds.Tables[0].Rows[0]["DayProduction"].ToString());
return model;
}
return null;
}
catch
{
return null;
}
}
public int BaseInfo_UpdateProduct(MineProductModel model)
{
return dal.BaseInfo_UpdateProduct(model);
}