/// <summary> /// 编辑现金推算表 /// </summary> /// <param name="model"></param> /// <returns></returns> public int EditKey(ListKeyEntity model) { SqlParameter[] parameters = { new SqlParameter("vIdSave", SqlDbType.VarChar, 300), new SqlParameter("vcYear_ActualSalesPlanSave", SqlDbType.VarChar, 300), // new SqlParameter("vcYear_ActualSalesRealSave", SqlDbType.VarChar,300), new SqlParameter("vcYear_PlanSalesPlanSave", SqlDbType.VarChar, 300), // new SqlParameter("vcYear_PlanSalesRealSave", SqlDbType.VarChar,300), // new SqlParameter("vcYear_CompletionRatioPlanSave", SqlDbType.VarChar,300), // new SqlParameter("vcYear_CompletionRatioRealSave", SqlDbType.VarChar,300), new SqlParameter("vSketchSave", SqlDbType.VarChar, 5000), new SqlParameter("vcYear_targetSave", SqlDbType.VarChar, 300) }; parameters[0].Value = model.IdSave; parameters[1].Value = model.cYear_ActualSalesPlanSave; // parameters[2].Value = model.cYear_ActualSalesRealSave; parameters[2].Value = model.cYear_PlanSalesPlanSave; // parameters[4].Value = model.cYear_PlanSalesRealSave; // parameters[5].Value = model.cYear_CompletionRatioPlanSave; // parameters[6].Value = model.cYear_CompletionRatioRealSave; parameters[3].Value = model.SketchSave; parameters[4].Value = model.cYear_targetSave; string commandText = "proc_EditKey"; 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 EditKey(ListKeyEntity model) { return(dalKey.EditKey(model)); }