/// <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));
}
