public decimal UpDate(A03_Info pInfo)
{
try
{
OracleParameter paramReturn = new OracleParameter("p_return", OracleDbType.Decimal, ParameterDirection.Output);
OracleHelper.ExecuteNonQuery(Configuration.connectionString, CommandType.StoredProcedure, "PKG_A03.PROC_APP_DETAIL_A03_UPDATE",
paramReturn,
new OracleParameter("P_ID", OracleDbType.Decimal, pInfo.Id, ParameterDirection.Input),
new OracleParameter("P_CASE_CODE", OracleDbType.Varchar2, pInfo.Case_Code, ParameterDirection.Input),
new OracleParameter("P_APP_HEADER_ID", OracleDbType.Decimal, pInfo.App_Header_Id, ParameterDirection.Input),
new OracleParameter("P_LANGUAGE_CODE", OracleDbType.Varchar2, pInfo.Language_Code, ParameterDirection.Input),
new OracleParameter("P_REFAPPNO", OracleDbType.Varchar2, pInfo.Refappno, ParameterDirection.Input),
new OracleParameter("P_APP_SENTDATE", OracleDbType.Date, pInfo.App_Sentdate, ParameterDirection.Input),
new OracleParameter("P_INDUSTRY_DESIGN_NAME", OracleDbType.Varchar2, pInfo.Industry_Design_Name, ParameterDirection.Input),
new OracleParameter("P_KQTD_TYPE", OracleDbType.Decimal, pInfo.Kqtd_Type, ParameterDirection.Input),
new OracleParameter("P_KQTD_VALUE", OracleDbType.Decimal, pInfo.Kqtd_Value, ParameterDirection.Input),
new OracleParameter("P_PHANLOAI_TYPE", OracleDbType.Decimal, pInfo.Phanloai_Type, ParameterDirection.Input),
new OracleParameter("P_USED_SPECIAL", OracleDbType.Decimal, pInfo.USED_SPECIAL, ParameterDirection.Input),
new OracleParameter("P_CLASS_CONTENT", OracleDbType.Varchar2, pInfo.Class_Content, ParameterDirection.Input),
new OracleParameter("P_SOHINHPHATSINH", OracleDbType.Decimal, pInfo.SoHinhPhatSinh, ParameterDirection.Input),
new OracleParameter("P_SO_PA", OracleDbType.Decimal, pInfo.SO_PA, ParameterDirection.Input),
new OracleParameter("P_SO_HA", OracleDbType.Decimal, pInfo.SO_HA, ParameterDirection.Input)
);
var result = Convert.ToDecimal(paramReturn.Value.ToString());
return(result);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public decimal UpDate(A03_Info pInfo)
{
try
{
A03_DA _obj_da = new A03_DA();
return(_obj_da.UpDate(pInfo));
}
catch (Exception ex)
{
Logger.LogException(ex);
return(ErrorCode.Error);
}
}
public A03_Info GetByID(decimal p_app_header_id, string p_language_code,
ref ApplicationHeaderInfo applicationHeaderInfo,
ref List <AppDocumentInfo> appDocumentInfos, ref List <AppFeeFixInfo> appFeeFixInfos,
ref List <AuthorsInfo> pAppAuthorsInfo, ref List <Other_MasterInfo> pOther_MasterInfo,
ref List <AppClassDetailInfo> appClassDetailInfos, ref List <AppDocumentOthersInfo> pAppDocOtherInfo,
ref List <UTienInfo> pUTienInfo, ref List <AppDocumentOthersInfo> pAppDocDesign)
{
try
{
A03_DA _obj_da = new A03_DA();
DataSet dataSet = _obj_da.GetByID(p_app_header_id, p_language_code);
A03_Info _A03_Info = CBO <A03_Info> .FillObjectFromDataSet(dataSet);
if (dataSet != null && dataSet.Tables.Count == 10)
{
applicationHeaderInfo = CBO <ApplicationHeaderInfo> .FillObjectFromDataTable(dataSet.Tables[1]);
appDocumentInfos = CBO <AppDocumentInfo> .FillCollectionFromDataTable(dataSet.Tables[2]);
appFeeFixInfos = CBO <AppFeeFixInfo> .FillCollectionFromDataTable(dataSet.Tables[3]);
pOther_MasterInfo = CBO <Other_MasterInfo> .FillCollectionFromDataTable(dataSet.Tables[4]);
pAppAuthorsInfo = CBO <AuthorsInfo> .FillCollectionFromDataTable(dataSet.Tables[5]);
appClassDetailInfos = CBO <AppClassDetailInfo> .FillCollectionFromDataTable(dataSet.Tables[6]);
pAppDocOtherInfo = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[7]);
pUTienInfo = CBO <UTienInfo> .FillCollectionFromDataTable(dataSet.Tables[8]);
pAppDocDesign = CBO <AppDocumentOthersInfo> .FillCollectionFromDataTable(dataSet.Tables[9]);
}
return(_A03_Info);
}
catch (Exception ex)
{
Logger.LogException(ex);
return(new A03_Info());
}
}