/// <summary>
/// 编辑现金推算表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditWages(ListWagesEntity model)
{
SqlParameter[] parameters =
{
new SqlParameter("vIdSave", SqlDbType.VarChar, 300),
new SqlParameter("vJanPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vFebPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vMarPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vAprPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vMayPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vJunPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vJulPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vAugPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vSepPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vOctPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vNovPlanSave", SqlDbType.VarChar, 300),
new SqlParameter("vDecPlanSave", SqlDbType.VarChar, 300)
};
parameters[0].Value = model.IdSave;
parameters[1].Value = model.JanPlanSave;
parameters[2].Value = model.FebPlanSave;
parameters[3].Value = model.MarPlanSave;
parameters[4].Value = model.AprPlanSave;
parameters[5].Value = model.MayPlanSave;
parameters[6].Value = model.JunPlanSave;
parameters[7].Value = model.JulPlanSave;
parameters[8].Value = model.AugPlanSave;
parameters[9].Value = model.SepPlanSave;
parameters[10].Value = model.OctPlanSave;
parameters[11].Value = model.NovPlanSave;
parameters[12].Value = model.DecPlanSave;
string commandText = "proc_EditWages";
int result = 2;
try
{
db.Open();
db.ExecuteNonQuery(commandText, CommandType.StoredProcedure, parameters);
result = 1;
}
catch
{
result = 0;
}
finally
{
db.Close();
}
return(result);
}
/// <summary>
/// 编辑现金推算表
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int EditWages(ListWagesEntity model)
{
return(dalWages.EditWages(model));
}