/// <summary>
/// Update one record
/// </summary>
/// <param name="result"></param>
/// <param name="errorMsg"></param>
//Edit fix bug 66 HoaVV start
public DCW003ListReturnUpdate DCW003Update(DCW003Result result, out string errorMsg)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_UPDATE_DOC_CONTROL))
{
DbManager.Add(DWC003StoreName.PARAM_DOC_CONTROL_NO, result.DocControlNo);
DbManager.Add(DWC003StoreName.PARAM_URIAGE_SHUPPINN_TOROKUNO, result.UriageShuppinnTorokuNo);
DbManager.Add(DWC003StoreName.PARAM_MASSHO_FLG, result.MasshoFlg);
DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_FLG, result.JishameiFlg);
DbManager.Add(DWC003StoreName.PARAM_DOC_STATUS, result.DocStatus);
DbManager.Add(DWC003StoreName.PARAM_DOC_NYUKO_DATE, result.DocNyukoDate);
DbManager.Add(DWC003StoreName.PARAM_DOC_SHUKKO_DATE, result.DocShukkoDate);
DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_IRAI_SHUKKO_DATE, result.JishameiIraiShukkoDate);
DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_KANRYO_NYUKO_DATE, result.JishameiKanryoNyukoDate);
DbManager.Add(DWC003StoreName.PARAM_MASSHO_IRAI_SHUKKO_DATE, result.MasshoIraiShukkoDate);
DbManager.Add(DWC003StoreName.PARAM_MASSHO_KANRYO_NYUKO_DATE, result.MasshoKanryoNyukoDate);
DbManager.Add(DWC003StoreName.PARAM_MEMO, result.Memo);
DbManager.Add(DWC003StoreName.PARAM_SHORUI_LIMIT_DATE, result.ShoruiLimitDate);
DbManager.Add(DWC003StoreName.PARAM_SHAKEN_LIMIT_DATE, result.ShakenLimitDate);
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_ERROR_MSG, SqlDbType.VarChar, 5, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
DataTable tableResult = DbManager.GetDataTable();
// Output error message
errorMsg = DbManager.GetValueInString(DWC003StoreName.PARAM_ERROR_MSG);
return(Entities.EntityHelper <DCW003ListReturnUpdate> .GetListObject(tableResult)[0]);
}
}
/// <summary>
/// Update one record
/// </summary>
/// <param name="result"></param>
/// <param name="errorMsg"></param>
public void DCW003Update(DCW003Result result, out string errorMsg)
{
using (DBManager DbManager = new DBManager(DWC003StoreName.STP_DCW003_UPDATE_DOC_CONTROL))
{
DbManager.Add(DWC003StoreName.PARAM_DOC_CONTROL_NO, result.DocControlNo);
DbManager.Add(DWC003StoreName.PARAM_URIAGE_SHUPPINN_TOROKUNO, result.UriageShuppinnTorokuNo);
DbManager.Add(DWC003StoreName.PARAM_MASSHO_FLG, result.MasshoFlg);
DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_FLG, result.JishameiFlg);
DbManager.Add(DWC003StoreName.PARAM_DOC_STATUS, result.DocStatus);
DbManager.Add(DWC003StoreName.PARAM_DOC_NYUKO_DATE, result.DocNyukoDate);
DbManager.Add(DWC003StoreName.PARAM_DOC_SHUKKO_DATE, result.DocShukkoDate);
DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_IRAI_SHUKKO_DATE, result.JishameiIraiShukkoDate);
DbManager.Add(DWC003StoreName.PARAM_JISHAMEI_KANRYO_NYUKO_DATE, result.JishameiKanryoNyukoDate);
DbManager.Add(DWC003StoreName.PARAM_MASSHO_IRAI_SHUKKO_DATE, result.MasshoIraiShukkoDate);
DbManager.Add(DWC003StoreName.PARAM_MASSHO_KANRYO_NYUKO_DATE, result.MasshoKanryoNyukoDate);
DbManager.Add(DWC003StoreName.PARAM_MEMO, result.Memo);
DbManager.Add(DWC003StoreName.PARAM_USER, CmnEntityModel.UserName);
DbManager.Add(DWC003StoreName.PARAM_ERROR_MSG, SqlDbType.VarChar, 5, ParameterDirection.Output);
DbManager.ExecuteNonQuery();
// Output error message
errorMsg = DbManager.GetValueInString(DWC003StoreName.PARAM_ERROR_MSG);
}
}
public ActionResult DCW003Update(DCW003Result resultModel)
{
using (DCW003Services services = new DCW003Services())
{
services.DCW003Update(resultModel);
}
return(ReturnResult());
}
/// <summary>
/// Update one record
/// </summary>
/// <param name="result"></param>
public void DCW003Update(DCW003Result result)
{
string error = string.Empty;
da.DCW003Update(result, out error);
if (!string.IsNullOrEmpty(error))
{
base.CmnEntityModel.ErrorMsgCd = error;
}
}
/// <summary>
/// Update one record
/// </summary>
/// <param name="result"></param>
//Edit fix bug 66 HoaVV start
public DCW003ListReturnUpdate DCW003Update(DCW003Result result)
{
string error = string.Empty;
if (result.JishameiKanryoNyukoDate != null || result.MasshoKanryoNyukoDate != null)
{
result.ShoruiLimitDate = null;
}
DCW003ListReturnUpdate listReturnUpdate = da.DCW003Update(result, out error);
if (!string.IsNullOrEmpty(error))
{
base.CmnEntityModel.ErrorMsgCd = error;
}
return(listReturnUpdate);
}
