public string UpdatePurchaseOrder(string random,
int type,
long PurchaseOrderNo,
EntityPurchaseOrderH entityH,
List<EntityPurchaseOrderD> entityD)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
try
{
companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]);
userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]);
sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]);
string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]));
if (_message != "")
{
return _message;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(認証処理)", ex);
return CLASS_NM + ".認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();
}
#endregion
#region Field
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = null;
string accountPeriod = "";
long id = 0;
long no = PurchaseOrderNo;
#endregion
#region Databese Open
try
{
db = new ExMySQLData(ExCast.zCStr(HttpContext.Current.Session[ExSession.DB_CONNECTION_STR]));
db.DbOpen();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(DbOpen)", ex);
return "UpdatePurchaseOrder(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Invoice Close Check
try
{
if (type <= 1)
{
// 掛仕入
if (entityH.business_division_id == 1)
{
//// 請求締切済チェック
//if (DataClose.IsInvoiceClose(companyId, db, entityH.invoice_id, entityH.sales_ymd))
//{
// db.DbClose();
// return "仕入日 : " + entityH.sales_ymd + " は請求締切済の為、計上できません。";
//}
}
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Payment Close Check)", ex);
return "UpdatePurchaseOrder(Payment Close Check) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region BeginTransaction
try
{
db.ExBeginTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(BeginTransaction)", ex);
return "UpdatePurchaseOrder(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Update or Insert
if (type <= 1)
{
#region Get Accout Period
try
{
accountPeriod = DataAccount.GetAccountPeriod(ExCast.zCStr(HttpContext.Current.Session[ExSession.ACCOUNT_BEGIN_PERIOD]), entityH.purchase_order_ymd);
if (accountPeriod == "")
{
return "会計年の取得に失敗しました。(期首月日 : " + ExCast.zCStr(HttpContext.Current.Session[ExSession.ACCOUNT_BEGIN_PERIOD]) +
" 仕入日 : " + entityH.purchase_order_ymd + ")";
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(GetAccountPeriod)", ex);
return "UpdatePurchaseOrder(GetAccountPeriod) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Get Slip No
try
{
DataSlipNo.GetSlipNo(companyId,
groupId,
db,
DataSlipNo.geSlipKbn.Purchase,
accountPeriod,
ref no,
out id,
ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]),
ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]));
if (no == 0 || id == 0)
{
db.ExRollbackTransaction();
return "伝票番号の取得に失敗しました。(会計年 : " + accountPeriod + ")";
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(GetSlipNo)", ex);
db.ExRollbackTransaction();
return "UpdatePurchaseOrder(GetSlipNo) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Head Insert
try
{
#region SQL
sb.Length = 0;
sb.Append("INSERT INTO T_PURCHASE_ORDER_H " + Environment.NewLine);
sb.Append(" ( COMPANY_ID" + Environment.NewLine);
sb.Append(" , GROUP_ID" + Environment.NewLine);
sb.Append(" , ID" + Environment.NewLine);
sb.Append(" , NO" + Environment.NewLine);
sb.Append(" , PURCHASE_ORDER_YMD" + Environment.NewLine);
sb.Append(" , PERSON_ID" + Environment.NewLine);
sb.Append(" , PURCHASE_ID" + Environment.NewLine);
sb.Append(" , TAX_CHANGE_ID" + Environment.NewLine);
sb.Append(" , BUSINESS_DIVISION_ID" + Environment.NewLine);
sb.Append(" , SEND_ID" + Environment.NewLine);
sb.Append(" , CUSTOMER_ID" + Environment.NewLine);
sb.Append(" , SUPPLIER_ID" + Environment.NewLine);
sb.Append(" , SUPPLY_YMD" + Environment.NewLine);
sb.Append(" , DELIVER_DIVISION_ID" + Environment.NewLine);
sb.Append(" , SUM_ENTER_NUMBER" + Environment.NewLine);
sb.Append(" , SUM_CASE_NUMBER" + Environment.NewLine);
sb.Append(" , SUM_NUMBER" + Environment.NewLine);
sb.Append(" , SUM_UNIT_PRICE" + Environment.NewLine);
sb.Append(" , SUM_TAX" + Environment.NewLine);
sb.Append(" , SUM_NO_TAX_PRICE" + Environment.NewLine);
sb.Append(" , SUM_PRICE" + Environment.NewLine);
sb.Append(" , MEMO" + Environment.NewLine);
sb.Append(" , UPDATE_FLG" + Environment.NewLine);
sb.Append(" , DELETE_FLG" + Environment.NewLine);
sb.Append(" , CREATE_PG_ID" + Environment.NewLine);
sb.Append(" , CREATE_ADRESS" + Environment.NewLine);
sb.Append(" , CREATE_USER_ID" + Environment.NewLine);
sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine);
sb.Append(" , CREATE_DATE" + Environment.NewLine);
sb.Append(" , CREATE_TIME" + Environment.NewLine);
sb.Append(" , UPDATE_PG_ID" + Environment.NewLine);
sb.Append(" , UPDATE_ADRESS" + Environment.NewLine);
sb.Append(" , UPDATE_USER_ID" + Environment.NewLine);
sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine);
sb.Append(" , UPDATE_DATE" + Environment.NewLine);
sb.Append(" , UPDATE_TIME" + Environment.NewLine);
sb.Append(")" + Environment.NewLine);
sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" ," + groupId + Environment.NewLine); // GROUP_ID
sb.Append(" ," + id.ToString() + Environment.NewLine); // ID
sb.Append(" ," + no.ToString() + Environment.NewLine); // NO
sb.Append(" ," + ExEscape.zRepStr(ExCast.zDateNullToDefault(entityH.purchase_order_ymd)) + Environment.NewLine); // PURCHASE_ORDER_YMD
sb.Append(" ," + entityH.update_person_id + Environment.NewLine); // PERSON_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(entityH.purchase_id)) + Environment.NewLine); // PURCHASE_ID
sb.Append(" ," + entityH.tax_change_id + Environment.NewLine); // TAX_CHANGE_ID
sb.Append(" ," + entityH.business_division_id + Environment.NewLine); // BUSINESS_DIVISION_ID
sb.Append(" ," + entityH.send_kbn_id + Environment.NewLine); // SEND_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(entityH.customer_id)) + Environment.NewLine); // CUSTOMER_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(entityH.supplier_id)) + Environment.NewLine); // SUPPLIER_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zTimeNullToDefault(entityH.supply_ymd)) + Environment.NewLine); // SUPPLY_YMD
sb.Append(" ,1" + Environment.NewLine); // DELIVER_DIVISION_ID
sb.Append(" ," + ExCast.zCDbl(entityH.sum_enter_number) + Environment.NewLine); // SUM_ENTER_NUMBER
sb.Append(" ," + ExCast.zCDbl(entityH.sum_case_number) + Environment.NewLine); // SUM_CASE_NUMBER
sb.Append(" ," + ExCast.zCDbl(entityH.sum_number) + Environment.NewLine); // SUM_NUMBER
sb.Append(" ," + ExCast.zCDbl(entityH.sum_unit_price) + Environment.NewLine); // SUM_UNIT_PRICE
sb.Append(" ," + ExCast.zCDbl(entityH.sum_tax) + Environment.NewLine); // SUM_TAX
sb.Append(" ," + ExCast.zCDbl(entityH.sum_no_tax_price) + Environment.NewLine); // SUM_NO_TAX_PRICE
sb.Append(" ," + ExCast.zCDbl(entityH.sum_price) + Environment.NewLine); // SUM_PRICE
sb.Append(" ," + ExEscape.zRepStr(entityH.memo) + Environment.NewLine); // MEMO
if (type == 0)
{
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Upd,
PG_NM,
"T_PURCHASE_ORDER_H",
entityH.update_person_id,
PurchaseOrderNo.ToString(),
ipAdress,
userId));
}
else
{
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins,
PG_NM,
"T_PURCHASE_ORDER_H",
entityH.update_person_id,
"0",
ipAdress,
userId));
}
#endregion
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Head Insert)", ex);
return "UpdatePurchaseOrder(Head Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Detail Insert
try
{
for (int i = 0; i <= entityD.Count - 1; i++)
{
#region SQL
sb.Length = 0;
sb.Append("INSERT INTO T_PURCHASE_ORDER_D " + Environment.NewLine);
sb.Append(" ( COMPANY_ID" + Environment.NewLine);
sb.Append(" , GROUP_ID" + Environment.NewLine);
sb.Append(" , PURCHASE_ORDER_ID" + Environment.NewLine);
sb.Append(" , REC_NO" + Environment.NewLine);
sb.Append(" , BREAKDOWN_ID" + Environment.NewLine);
sb.Append(" , DELIVER_DIVISION_ID" + Environment.NewLine);
sb.Append(" , COMMODITY_ID" + Environment.NewLine);
sb.Append(" , COMMODITY_NAME" + Environment.NewLine);
sb.Append(" , UNIT_ID" + Environment.NewLine);
sb.Append(" , ENTER_NUMBER" + Environment.NewLine);
sb.Append(" , CASE_NUMBER" + Environment.NewLine);
sb.Append(" , NUMBER" + Environment.NewLine);
sb.Append(" , UNIT_PRICE" + Environment.NewLine);
sb.Append(" , TAX" + Environment.NewLine);
sb.Append(" , NO_TAX_PRICE" + Environment.NewLine);
sb.Append(" , PRICE" + Environment.NewLine);
sb.Append(" , TAX_DIVISION_ID" + Environment.NewLine);
sb.Append(" , TAX_PERCENT" + Environment.NewLine);
sb.Append(" , MEMO" + Environment.NewLine);
sb.Append(" , UPDATE_FLG" + Environment.NewLine);
sb.Append(" , DELETE_FLG" + Environment.NewLine);
sb.Append(" , CREATE_PG_ID" + Environment.NewLine);
sb.Append(" , CREATE_ADRESS" + Environment.NewLine);
sb.Append(" , CREATE_USER_ID" + Environment.NewLine);
sb.Append(" , CREATE_PERSON_ID" + Environment.NewLine);
sb.Append(" , CREATE_DATE" + Environment.NewLine);
sb.Append(" , CREATE_TIME" + Environment.NewLine);
sb.Append(" , UPDATE_PG_ID" + Environment.NewLine);
sb.Append(" , UPDATE_ADRESS" + Environment.NewLine);
sb.Append(" , UPDATE_USER_ID" + Environment.NewLine);
sb.Append(" , UPDATE_PERSON_ID" + Environment.NewLine);
sb.Append(" , UPDATE_DATE" + Environment.NewLine);
sb.Append(" , UPDATE_TIME" + Environment.NewLine);
sb.Append(")" + Environment.NewLine);
sb.Append("SELECT " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" ," + groupId + Environment.NewLine); // GROUP_ID
sb.Append(" ," + id.ToString() + Environment.NewLine); // PURCHASE_ORDER_ID
sb.Append(" ," + entityD[i].rec_no + Environment.NewLine); // REC_NO
sb.Append(" ," + entityD[i].breakdown_id + Environment.NewLine); // BREAKDOWN_ID
sb.Append(" ," + entityD[i].deliver_division_id + Environment.NewLine); // DELIVER_DIVISION_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(entityD[i].commodity_id)) + Environment.NewLine); // COMMODITY_ID
sb.Append(" ," + ExEscape.zRepStr(entityD[i].commodity_name) + Environment.NewLine); // COMMODITY_NAME
sb.Append(" ," + entityD[i].unit_id + Environment.NewLine); // UNIT_ID
sb.Append(" ," + entityD[i].enter_number + Environment.NewLine); // ENTER_NUMBER
sb.Append(" ," + entityD[i].case_number + Environment.NewLine); // CASE_NUMBER
sb.Append(" ," + entityD[i].number + Environment.NewLine); // NUMBER
sb.Append(" ," + entityD[i].unit_price + Environment.NewLine); // UNIT_PRICE
sb.Append(" ," + entityD[i].tax + Environment.NewLine); // TAX
sb.Append(" ," + entityD[i].no_tax_price + Environment.NewLine); // NO_TAX_PRICE
sb.Append(" ," + entityD[i].price + Environment.NewLine); // PRICE
sb.Append(" ," + entityD[i].tax_division_id + Environment.NewLine); // TAX_DIVISION_ID
sb.Append(" ," + entityD[i].tax_percent + Environment.NewLine); // TAX_PERCENT
sb.Append(" ," + ExEscape.zRepStr(entityD[i].memo) + Environment.NewLine); // MEMO
if (type == 0)
{
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Upd,
PG_NM,
"T_PURCHASE_ORDER_D",
entityH.update_person_id,
ExCast.zCStr(entityH.id),
ipAdress,
userId));
}
else
{
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins,
PG_NM,
"T_PURCHASE_ORDER_D",
entityH.update_person_id,
"0",
ipAdress,
userId));
}
#endregion
if (entityD[i].breakdown_id <= 3 && string.IsNullOrEmpty(entityD[i].commodity_id))
{
// 摘要以外で商品未選択の場合、登録しない
}
else
{
db.ExecuteSQL(sb.ToString(), false);
}
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Detail Insert)", ex);
return "UpdatePurchaseOrder(Detail Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Head Update
if (type == 0)
{
try
{
sb.Length = 0;
sb.Append("UPDATE T_PURCHASE_ORDER_H " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
entityH.update_person_id,
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine); // GROUP_ID
sb.Append(" AND ID = " + entityH.id.ToString() + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Head Update)", ex);
return "UpdatePurchaseOrder(Head Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
}
#endregion
#region Detail Update
if (type == 0)
{
try
{
sb.Length = 0;
sb.Append("UPDATE T_PURCHASE_ORDER_D " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
entityH.update_person_id,
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND PURCHASE_ORDER_ID = " + entityH.id.ToString() + Environment.NewLine);
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Detail Update)", ex);
return "UpdatePurchaseOrder(Detail Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
}
#endregion
#region Update Slip No
try
{
if (type == 0)
{
DataSlipNo.UpdateSlipNo(companyId, groupId, db, DataSlipNo.geSlipKbn.Purchase, accountPeriod, 0, id);
}
else
{
DataSlipNo.UpdateSlipNo(companyId, groupId, db, DataSlipNo.geSlipKbn.Purchase, accountPeriod, no, id);
}
if (no == 0 || id == 0)
{
return "伝票番号の更新に失敗しました。(会計年 : " + accountPeriod + ")";
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(UpdateSlipNo)", ex);
return "UpdatePurchaseOrder(UpdateSlipNo) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
}
#endregion
#region Delete
if (type == 2)
{
#region Head Delete
try
{
sb.Length = 0;
sb.Append("UPDATE T_PURCHASE_ORDER_H " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
entityH.update_person_id,
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine); // GROUP_ID
sb.Append(" AND ID = " + entityH.id.ToString() + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Head Delete)", ex);
return "UpdatePurchaseOrder(Head Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Detail Delete
try
{
sb.Length = 0;
sb.Append("UPDATE T_PURCHASE_ORDER_D " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
entityH.update_person_id,
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND PURCHASE_ORDER_ID = " + entityH.id.ToString() + Environment.NewLine);
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Detail Delete)", ex);
return "UpdatePurchaseOrder(Detail Update) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
}
#endregion
#region CommitTransaction
try
{
db.ExCommitTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(CommitTransaction)", ex);
return "UpdatePurchaseOrder(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Database Close
try
{
db.DbClose();
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(DbClose)", ex);
return "UpdatePurchaseOrder(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
finally
{
db = null;
}
#endregion
#region Add Evidence
try
{
switch (type)
{
case 0:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
DataPgEvidence.PGName.PurchaseOrder.PurchaseOrderInp,
DataPgEvidence.geOperationType.Update,
"NO:" + no.ToString() + ",ID:" + id.ToString());
break;
case 1:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
DataPgEvidence.PGName.PurchaseOrder.PurchaseOrderInp,
DataPgEvidence.geOperationType.Insert,
"NO:" + no.ToString() + ",ID:" + id.ToString());
break;
case 2:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
DataPgEvidence.PGName.PurchaseOrder.PurchaseOrderInp,
DataPgEvidence.geOperationType.Delete,
"NO:" + no.ToString() + ",ID:" + id.ToString());
break;
default:
break;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdatePurchaseOrder(Add Evidence)", ex);
return "UpdatePurchaseOrder(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
}
#endregion
#region Return
if (type == 1 && PurchaseOrderNo == 0)
{
return "Auto Insert success : " + "仕入番号 : " + no.ToString().ToString() + "で登録しました。";
}
else
{
return "";
}
#endregion
}
public EntityPurchaseOrderH GetPurchaseOrderH(string random, long PurchaseOrderIDFrom, long PurchaseOrderIDTo)
{
EntityPurchaseOrderH entity = null;
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
int idFigurePurchase = 0;
int idFigureCustomer = 0;
int personId = 0;
try
{
companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]);
userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]);
sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]);
idFigureCustomer = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_CUSTOMER]);
idFigurePurchase = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_PURCHASE]);
personId = ExCast.zCInt(HttpContext.Current.Session[ExSession.PERSON_ID]);
string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]));
if (_message != "")
{
entity = new EntityPurchaseOrderH();
entity.message = _message;
return entity;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetPurchaseOrderH(認証処理)", ex);
entity = new EntityPurchaseOrderH();
entity.message = CLASS_NM + ".GetPurchaseOrderH : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();
return entity;
}
#endregion
StringBuilder sb;
DataTable dt;
ExMySQLData db;
try
{
db = ExSession.GetSessionDb(ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]),
ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]));
sb = new StringBuilder();
#region SQL
sb.Append("SELECT T.COMPANY_ID " + Environment.NewLine);
sb.Append(" ,T.GROUP_ID " + Environment.NewLine);
sb.Append(" ,T.ID " + Environment.NewLine);
sb.Append(" ,lpad(CAST(T.NO as char), 10, '0') AS NO" + Environment.NewLine);
sb.Append(" ,date_format(T.PURCHASE_ORDER_YMD , " + ExEscape.SQL_YMD + ") AS PURCHASE_ORDER_YMD" + Environment.NewLine);
sb.Append(" ,T.PERSON_ID " + Environment.NewLine);
sb.Append(" ,PS.NAME AS INPUT_PERSON_NM " + Environment.NewLine);
sb.Append(" ,T.PURCHASE_ID " + Environment.NewLine);
sb.Append(" ,PU.NAME AS PURCHASE_NAME " + Environment.NewLine);
sb.Append(" ,T.TAX_CHANGE_ID " + Environment.NewLine);
sb.Append(" ,NM1.DESCRIPTION AS TAX_CHANGE_NAME " + Environment.NewLine);
sb.Append(" ,T.BUSINESS_DIVISION_ID " + Environment.NewLine);
sb.Append(" ,NM2.DESCRIPTION AS BUSINESS_DIVISION_NAME " + Environment.NewLine);
sb.Append(" ,T.SEND_ID " + Environment.NewLine);
sb.Append(" ,NM3.DESCRIPTION AS SEND_NAME " + Environment.NewLine);
sb.Append(" ,T.CUSTOMER_ID " + Environment.NewLine);
sb.Append(" ,CS.NAME AS CUSTOMER_NAME " + Environment.NewLine);
sb.Append(" ,T.SUPPLIER_ID " + Environment.NewLine);
sb.Append(" ,SU.NAME AS SUPPLIER_NAME " + Environment.NewLine);
sb.Append(" ,date_format(T.SUPPLY_YMD , " + ExEscape.SQL_YMD + ") AS SUPPLY_YMD" + Environment.NewLine);
sb.Append(" ,T.SUM_ENTER_NUMBER " + Environment.NewLine);
sb.Append(" ,T.SUM_CASE_NUMBER " + Environment.NewLine);
sb.Append(" ,T.SUM_NUMBER " + Environment.NewLine);
sb.Append(" ,T.SUM_UNIT_PRICE " + Environment.NewLine);
sb.Append(" ,T.SUM_TAX " + Environment.NewLine);
sb.Append(" ,T.SUM_NO_TAX_PRICE " + Environment.NewLine);
sb.Append(" ,T.SUM_PRICE " + Environment.NewLine);
sb.Append(" ,PU.PAYMENT_CREDIT_PRICE " + Environment.NewLine);
sb.Append(" ,PU.PRICE_FRACTION_PROC_ID " + Environment.NewLine);
sb.Append(" ,PU.TAX_FRACTION_PROC_ID " + Environment.NewLine);
sb.Append(" ,PU.UNIT_KIND_ID " + Environment.NewLine);
sb.Append(" ,PU.CREDIT_RATE " + Environment.NewLine);
sb.Append(" ,T.MEMO " + Environment.NewLine);
sb.Append(" ,date_format(T.UPDATE_DATE , " + ExEscape.SQL_YMD + ") AS UPDATE_DATE" + Environment.NewLine);
sb.Append(" ,T.UPDATE_TIME " + Environment.NewLine);
sb.Append(" FROM T_PURCHASE_ORDER_H AS T" + Environment.NewLine);
#region Join
// 更新担当者
sb.Append(" LEFT JOIN M_PERSON AS PS" + Environment.NewLine);
sb.Append(" ON PS.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND PS.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND PS.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND PS.GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND PS.ID = T.PERSON_ID" + Environment.NewLine);
// 仕入先
sb.Append(" LEFT JOIN M_PURCHASE AS PU" + Environment.NewLine);
sb.Append(" ON PU.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND PU.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND PU.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND PU.ID = T.PURCHASE_ID" + Environment.NewLine);
// 得意先
sb.Append(" LEFT JOIN M_CUSTOMER AS CS" + Environment.NewLine);
sb.Append(" ON CS.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND CS.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND CS.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.CUSTOMER_ID = CS.ID" + Environment.NewLine);
// 納入先
sb.Append(" LEFT JOIN M_SUPPLIER AS SU" + Environment.NewLine);
sb.Append(" ON SU.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND SU.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND SU.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.CUSTOMER_ID = SU.CUSTOMER_ID" + Environment.NewLine);
sb.Append(" AND T.SUPPLIER_ID = SU.ID" + Environment.NewLine);
// 税転換
sb.Append(" LEFT JOIN SYS_M_NAME AS NM1" + Environment.NewLine);
sb.Append(" ON NM1.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM1.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM1.DIVISION_ID = " + (int)CommonUtl.geNameKbn.TAX_CHANGE_PU_ID + Environment.NewLine);
sb.Append(" AND T.TAX_CHANGE_ID = NM1.ID" + Environment.NewLine);
// 取引区分(仕入)
sb.Append(" LEFT JOIN SYS_M_NAME AS NM2" + Environment.NewLine);
sb.Append(" ON NM2.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM2.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM2.DIVISION_ID = " + (int)CommonUtl.geNameKbn.BUSINESS_DIVISION_PU_ID + Environment.NewLine);
sb.Append(" AND T.BUSINESS_DIVISION_ID = NM2.ID" + Environment.NewLine);
// 発送区分
sb.Append(" LEFT JOIN SYS_M_NAME AS NM3" + Environment.NewLine);
sb.Append(" ON NM3.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM3.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM3.DIVISION_ID = " + (int)CommonUtl.geNameKbn.SEND_KBN + Environment.NewLine);
sb.Append(" AND T.SEND_ID = NM3.ID" + Environment.NewLine);
#endregion
sb.Append(" WHERE T.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND T.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND T.NO >= " + PurchaseOrderIDFrom.ToString() + Environment.NewLine);
sb.Append(" AND T.NO <= " + PurchaseOrderIDTo.ToString() + Environment.NewLine);
sb.Append(" ORDER BY T.COMPANY_ID " + Environment.NewLine);
sb.Append(" ,T.GROUP_ID " + Environment.NewLine);
sb.Append(" ,T.PURCHASE_ORDER_YMD DESC " + Environment.NewLine);
sb.Append(" ,T.NO DESC " + Environment.NewLine);
sb.Append(" LIMIT 0, 1");
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
entity = new EntityPurchaseOrderH();
// 排他制御
DataPgLock.geLovkFlg lockFlg = DataPgLock.geLovkFlg.UnLock;
string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, groupId + "-" + ExCast.zNumZeroNothingFormat(PurchaseOrderIDFrom.ToString()), ipAdress, db, out lockFlg);
if (strErr != "")
{
entity.message = CLASS_NM + ".GetCommodity : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr;
}
#region Set Entity
entity.id = ExCast.zCLng(dt.DefaultView[0]["ID"]);
entity.no = ExCast.zCLng(dt.DefaultView[0]["NO"]);
entity.purchase_order_ymd = ExCast.zDateNullToDefault(dt.DefaultView[0]["PURCHASE_ORDER_YMD"]);
entity.update_person_id = ExCast.zCInt(dt.DefaultView[0]["PERSON_ID"]);
entity.update_person_nm = ExCast.zCStr(dt.DefaultView[0]["INPUT_PERSON_NM"]);
entity.purchase_id = ExCast.zFormatForID(dt.DefaultView[0]["PURCHASE_ID"], idFigurePurchase);
entity.purchase_name = ExCast.zCStr(dt.DefaultView[0]["PURCHASE_NAME"]);
entity.tax_change_id = ExCast.zCInt(dt.DefaultView[0]["TAX_CHANGE_ID"]);
entity.tax_change_name = ExCast.zCStr(dt.DefaultView[0]["TAX_CHANGE_NAME"]);
entity.business_division_id = ExCast.zCInt(dt.DefaultView[0]["BUSINESS_DIVISION_ID"]);
entity.business_division_name = ExCast.zCStr(dt.DefaultView[0]["BUSINESS_DIVISION_NAME"]);
entity.send_kbn_id = ExCast.zCInt(dt.DefaultView[0]["SEND_ID"]);
entity.send_kbn_nm = ExCast.zCStr(dt.DefaultView[0]["SEND_NAME"]);
entity.customer_id = ExCast.zFormatForID(dt.DefaultView[0]["CUSTOMER_ID"], idFigureCustomer);
entity.customer_name = ExCast.zCStr(dt.DefaultView[0]["CUSTOMER_NAME"]);
entity.supplier_id = ExCast.zFormatForID(dt.DefaultView[0]["SUPPLIER_ID"], idFigureCustomer);
entity.supplier_name = ExCast.zCStr(dt.DefaultView[0]["SUPPLIER_NAME"]);
entity.supply_ymd = ExCast.zDateNullToDefault(dt.DefaultView[0]["SUPPLY_YMD"]);
entity.sum_enter_number = ExCast.zCDbl(dt.DefaultView[0]["SUM_ENTER_NUMBER"]);
entity.sum_case_number = ExCast.zCDbl(dt.DefaultView[0]["SUM_CASE_NUMBER"]);
entity.sum_number = ExCast.zCDbl(dt.DefaultView[0]["SUM_NUMBER"]);
entity.sum_unit_price = ExCast.zCDbl(dt.DefaultView[0]["SUM_UNIT_PRICE"]);
entity.sum_tax = ExCast.zCDbl(dt.DefaultView[0]["SUM_TAX"]);
entity.sum_no_tax_price = ExCast.zCDbl(dt.DefaultView[0]["SUM_NO_TAX_PRICE"]);
entity.sum_price = ExCast.zCDbl(dt.DefaultView[0]["SUM_PRICE"]);
entity.payment_credit_price = ExCast.zCDbl(dt.DefaultView[0]["PAYMENT_CREDIT_PRICE"]);
entity.before_payment_credit_price = ExCast.zCDbl(dt.DefaultView[0]["PAYMENT_CREDIT_PRICE"]);
entity.unit_kind_id = ExCast.zCInt(dt.DefaultView[0]["UNIT_KIND_ID"]);
entity.price_fraction_proc_id = ExCast.zCInt(dt.DefaultView[0]["PRICE_FRACTION_PROC_ID"]);
entity.tax_fraction_proc_id = ExCast.zCInt(dt.DefaultView[0]["TAX_FRACTION_PROC_ID"]);
entity.credit_rate = ExCast.zCInt(dt.DefaultView[0]["CREDIT_RATE"]);
entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]);
entity.lock_flg = (int)lockFlg;
// 仕入計上済チェック
if (DataExists.IsExistData(db, companyId, groupId, "T_PURCHASE_H", "PURCHASE_ORDER_NO", entity.no.ToString(), CommonUtl.geStrOrNumKbn.Number))
{
entity.purchase_allocation_flg = 1;
}
#endregion
}
else
{
entity = null;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetPurchaseOrderH", ex);
entity = new EntityPurchaseOrderH();
entity.message = CLASS_NM + ".GetPurchaseOrderH : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();
}
finally
{
db = null;
}
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
DataPgEvidence.PGName.PurchaseOrder.PurchaseOrderInp,
DataPgEvidence.geOperationType.Select,
"NO:" + PurchaseOrderIDFrom.ToString() + ",NO:" + PurchaseOrderIDTo.ToString());
return entity;
}
