/// <summary> /// 编辑现金推算表 /// </summary> /// <param name="model"></param> /// <returns></returns> public int EditCash(ListCashEntity 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_EditCash"; 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 EditCash(ListCashEntity model) { return(dalCash.EditCash(model)); }