// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
// 棚卸日
string proc_ym = this.datYmd.Text.Trim();
// 商品
if (this.utlCommodity_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.ID >= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCommodity_F.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += "] [商品 " + this.utlCommodity_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [商品 未指定～";
}
if (this.utlCommodity_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.ID <= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCommodity_T.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += this.utlCommodity_T.txtID.Text.Trim();
}
else
{
strWhrerString1 += "未指定";
}
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
private void btnCustomerCopy_Click(object sender, RoutedEventArgs e)
{
object[] prm = new object[1];
prm[0] = ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim());
webService.objPerent = this;
webService.CallWebService(ExWebService.geWebServiceCallKbn.GetCustomer,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
private void GetMstData(string id)
{
object[] prm = new object[2];
prm[0] = ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim());
prm[1] = id;
webService.objPerent = this;
webService.CallWebService(_GetWebServiceCallKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
private void GetMstList(ExWebService.geDialogDisplayFlg flg)
{
object[] prm = new object[3];
prm[0] = this.txtCode.Text.Trim();
prm[1] = this.txtName.Text.Trim();
prm[2] = ExCast.zNumZeroNothingFormat(Dlg_MstSearch.this_id2);
webServiceMst.objPerent = this.utlDummy;
webServiceMst.CallWebServiceMst(ExWebServiceMst.geWebServiceMstNmCallKbn.GetCommodityList,
ExWebService.geDialogDisplayFlg.No,
ExWebService.geDialogCloseFlg.No,
prm);
}
private void utlID_LostFocus(object sender, RoutedEventArgs e)
{
if (this.utlID.txtID.Text.Trim() != "")
{
string _id = this.utlID.txtID.Text.Trim();
if (ExCast.IsNumeric(_id))
{
_id = ExCast.zCDbl(_id).ToString();
}
GetMstData(ExCast.zNumZeroNothingFormat(this.utlID.txtID.Text.Trim()));
}
}
/// <summary>
/// 買掛残高更新
/// </summary>
/// <param name="companyId"></param>
/// <param name="db"></param>
/// <param name="customerId"></param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void UpdPaymentCredit(string companyId,
string groupId,
ExMySQLData db,
string purchaseId,
double price,
string pg_nm,
int update_person_id,
string ipAdress,
string userId)
{
StringBuilder sb;
try
{
sb = new StringBuilder();
sb.Length = 0;
sb.Append("UPDATE M_PURCHASE " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,PAYMENT_CREDIT_PRICE = PAYMENT_CREDIT_PRICE + " + price.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(purchaseId)) + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
sb.Length = 0;
sb.Append("UPDATE M_PAYMENT_CREDIT_BALANCE " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,PAYMENT_CREDIT_PRICE = PAYMENT_CREDIT_PRICE + " + price.ToString() + Environment.NewLine);
sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(purchaseId)) + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdPaymentCredit", ex);
throw;
}
}
/// <summary>
/// 商品在庫更新
/// </summary>
/// <param name="companyId"></param>
/// <param name="db"></param>
/// <param name="customerId"></param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void UpdCommodityInventory(string companyId,
string groupId,
ExMySQLData db,
string customerId,
double number,
string pg_nm,
int update_person_id,
string ipAdress,
string userId)
{
StringBuilder sb;
try
{
sb = new StringBuilder();
sb.Length = 0;
sb.Append("UPDATE M_COMMODITY " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,INVENTORY_NUMBER = INVENTORY_NUMBER + " + number.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(customerId)) + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
sb.Length = 0;
sb.Append("UPDATE M_COMMODITY_INVENTORY " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(pg_nm,
update_person_id,
ipAdress,
userId,
0));
sb.Append(" ,INVENTORY_NUMBER = INVENTORY_NUMBER + " + number.ToString() + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(customerId)) + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdCommodityInventory", ex);
throw;
}
}
// データ追加・更新・削除
private void UpdateData(Common.geUpdateType upd)
{
object[] prm = new object[4];
prm[0] = (int)upd;
prm[1] = ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim());
prm[2] = ExCast.zNumZeroNothingFormat(this.utlID.txtID.Text.Trim());
prm[3] = _entity;
webService.objPerent = this;
webService.CallWebService(_UpdWebServiceCallKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
/// <summary>
/// 支払締チェック
/// </summary>
/// <param name="companyId"></param>
/// <param name="db"></param>
/// <param name="customerId"></param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static bool IsPaymentClose(string companyId,
ExMySQLData db,
string purchaseId,
string ymd)
{
StringBuilder sb = new StringBuilder();
DataTable dt;
if (ymd.Length != 10)
{
throw new Exception();
}
if (!ExCast.IsDate(ymd))
{
throw new Exception();
}
try
{
sb.Length = 0;
sb.Append("SELECT T.NO " + Environment.NewLine);
sb.Append(" FROM T_PAYMENT AS T" + Environment.NewLine);
sb.Append(" WHERE T.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND T.PAYMENT_KBN = 0 " + Environment.NewLine); // 支払区分:締処理
sb.Append(" AND T.PAYMENT_YYYYMMDD >= " + ExEscape.zRepStr(ymd) + Environment.NewLine);
if (purchaseId != "")
{
sb.Append(" AND T.PURCHASE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(purchaseId)) + Environment.NewLine);
}
sb.Append(" LIMIT 0, 1");
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".IsPaymentClose", ex);
throw;
}
}
private void btnInventory_Click(object sender, RoutedEventArgs e)
{
if (ExCast.zCStr(utlID.txtID.Text.Trim()) != "")
{
}
else
{
ExMessageBox.Show("商品を選択して下さい。");
return;
}
Dlg_MstSearch searchDlg = new Dlg_MstSearch(MstData.geMDataKbn.Inventory);
searchDlg.MstKbn = Class.Data.MstData.geMDataKbn.Inventory;
searchDlg.MstGroupKbn = Class.Data.MstData.geMGroupKbn.None;
searchDlg.txtCode.Text = ExCast.zNumZeroNothingFormat(ExCast.zCStr(utlID.txtID.Text.Trim()));
searchDlg.Show();
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
// 請求区分
strWhrer += " AND T.INVOICE_KBN = 0 " + Environment.NewLine;
// 対象年月
string proc_ym = this.datYm.Text.Trim();
DateTime this_ym_from = ExCast.zConvertToDate(proc_ym + "/01");
DateTime this_ym_to = this_ym_from.AddMonths(1).AddDays(-1);
strWhrerString1 += "[対象年月 " + this_ym_from.ToString("yyyy/MM");
strWhrer += " AND T.INVOICE_YYYYMMDD >= " + ExEscape.zRepStr(this_ym_from.ToString("yyyy/MM/dd")) + Environment.NewLine;
strWhrer += " AND T.INVOICE_YYYYMMDD <= " + ExEscape.zRepStr(this_ym_to.ToString("yyyy/MM/dd")) + Environment.NewLine;
// 請求先
if (this.utlInvoice_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.INVOICE_ID >= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlInvoice_F.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += "] [請求先 " + this.utlInvoice_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [請求先 未指定～";
}
if (this.utlInvoice_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.INVOICE_ID <= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlInvoice_T.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += this.utlInvoice_T.txtID.Text.Trim() + "]";
}
else
{
strWhrerString1 += "未指定]";
}
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
// 受注日
if (this.datOrderYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.ORDER_YMD >= " + ExEscape.zRepStr(this.datOrderYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[受注日 " + ExEscape.zRepStrNoQuota(this.datOrderYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[受注日 未指定～";
}
if (this.datOrderYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.ORDER_YMD <= " + ExEscape.zRepStr(this.datOrderYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datOrderYmd_T.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
// 受注番号
if (this.utlOrderNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO >= " + ExCast.zCLng(this.utlOrderNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [受注番号 " + this.utlOrderNo_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [受注番号 未指定～";
}
if (this.utlOrderNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO <= " + ExCast.zCLng(this.utlOrderNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += this.utlOrderNo_T.txtID.Text.Trim();
}
else
{
strWhrerString1 += "未指定";
}
// 納入指定日
if (this.datNokiYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.SUPPLY_YMD >= " + ExEscape.zRepStr(this.datNokiYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [納入指定日 " + ExEscape.zRepStrNoQuota(this.datNokiYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [納入指定日 未指定～";
}
if (this.datNokiYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.SUPPLY_YMD <= " + ExEscape.zRepStr(this.datNokiYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datNokiYmd_T.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
// 見積番号
if (this.utlEstimateNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.ESTIMATENO >= " + ExCast.zCLng(this.utlEstimateNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [見積番号 " + this.utlEstimateNo_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [見積番号 未指定～";
}
if (this.utlEstimateNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.ESTIMATENO <= " + ExCast.zCLng(this.utlEstimateNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += this.utlEstimateNo_T.txtID.Text.Trim() + "]";
}
else
{
strWhrerString1 += "未指定]";
}
// 入力担当者
if (this.utlPerson_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID >= " + ExCast.zCLng(this.utlPerson_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "[入力担当者 " + this.utlPerson_F.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString2 += "[入力担当者 未指定～";
}
if (this.utlPerson_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID <= " + ExCast.zCLng(this.utlPerson_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += this.utlPerson_T.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_T.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "未指定";
}
// 得意先
if (this.utlCustomer.txtID.Text.Trim() != "")
{
strWhrer += " AND T.CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [得意先 " + ExEscape.zRepStrNoQuota(this.utlCustomer.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCustomer.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [得意先 未指定";
}
// 納入先
if (this.utlSupply.txtID.Text.Trim() != "")
{
strWhrer += " AND T.SUPPLIER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlSupply.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [納入先 " + ExEscape.zRepStrNoQuota(this.utlSupply.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlSupply.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [納入先 未指定";
}
// 商品コード
if (this.utlCommodity.txtID.Text.Trim() != "")
{
strWhrer += " AND EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.COMMODITY_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCommodity.txtID.Text.Trim())) + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
strWhrerString2 += "] [商品コード " + ExEscape.zRepStrNoQuota(this.utlCommodity.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCommodity.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString2 += "] [商品コード 未指定" + "]";
}
// 取引区分
string _buf = "";
if (this.chkKake.IsChecked == true)
{
// 掛売上
strWhrer += " AND (T.BUSINESS_DIVISION_ID = 1";
_buf += " [取引区分 掛売上";
}
if (this.chkCash.IsChecked == true)
{
// 現金
if (_buf == "")
{
strWhrer += " AND (T.BUSINESS_DIVISION_ID = 2";
_buf += " [取引区分 現金";
}
else
{
strWhrer += " OR T.BUSINESS_DIVISION_ID = 2";
_buf += " 現金";
}
}
if (_buf == "")
{
_buf += " [取引区分 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
_buf = "";
// 完納区分
if (this.chkUnDelivary.IsChecked == true)
{
// 未納
strWhrer += " AND (EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 1 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " [完納区分 未納";
}
if (this.chkPartDelivary.IsChecked == true)
{
// 一部納品
if (_buf == "")
{
strWhrer += " AND (EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 2 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " [完納区分 分納";
}
else
{
strWhrer += "OR EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 2 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " 分納";
}
}
if (this.chkFullDelivary.IsChecked == true)
{
// 完納
if (_buf == "")
{
strWhrer += " AND (EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 3 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " [完納区分 完納";
}
else
{
strWhrer += "OR EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 3 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " 完納";
}
}
if (this.chkTorikeshi.IsChecked == true)
{
// 取消
if (_buf == "")
{
strWhrer += " AND (EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 4 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " [完納区分 取消";
}
else
{
strWhrer += "OR EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_ORDER_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.ORDER_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.DELIVER_DIVISION_ID = 4 " + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
_buf += " 取消";
}
}
if (_buf == "")
{
_buf += " [完納区分 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
_buf = "";
// 注文請書発行
if (this.borPrint.Visibility == System.Windows.Visibility.Visible)
{
if (this.chkPrintNo.IsChecked == true)
{
strWhrer += " AND (T.ORDER_PRINT_FLG = 0";
_buf += " [注文請書発行 発行未";
}
if (this.chkPrintYes.IsChecked == true)
{
if (_buf == "")
{
strWhrer += " AND (T.ORDER_PRINT_FLG = 1";
_buf += " [注文請書発行 発行済";
}
else
{
strWhrer += " OR T.ORDER_PRINT_FLG = 1";
_buf += " 発行済";
}
}
if (_buf == "")
{
_buf += " [注文請書発行 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
_buf = "";
}
UpdPrintNo = "";
if (this.ProcKbn == eProcKbn.Report)
{
strWhrer = "";
strWhrerString1 = "";
strWhrerString2 = "";
string _no = "";
for (int i = 0; i <= lst.Count - 1; i++)
{
if (lst[i].exec_flg == true)
{
if (string.IsNullOrEmpty(_no))
{
_no += ExCast.zCLng(this.lst[i].no).ToString();
}
else
{
_no += "<<@escape_comma@>>" + ExCast.zCLng(this.lst[i].no).ToString();
}
}
}
if (!string.IsNullOrEmpty(_no))
{
UpdPrintNo = _no;
strWhrer += " AND T.NO IN (" + _no + ")" + Environment.NewLine;
}
}
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
#region 出金番号
if (this.utlPaymentCashNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO >= " + ExCast.zCLng(this.utlPaymentCashNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[出金番号 " + ExEscape.zRepStrNoQuota(this.utlPaymentCashNo_F.txtID.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[出金番号 未指定～";
}
if (this.utlPaymentCashNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO <= " + ExCast.zCLng(this.utlPaymentCashNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.utlPaymentCashNo_T.txtID.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
#endregion
#region 出金日
if (Common.gWinType == Common.geWinType.ListPaymentCashMonth)
{
if (this.datPaymentCashYmd_F.Text.Trim() != "")
{
strWhrer += " AND replace(date_format(T.PAYMENT_CASH_YMD , " + ExEscape.SQL_YM + "), '0000/00', '') >= " + ExEscape.zRepStr(this.datPaymentCashYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [出金日 " + ExEscape.zRepStrNoQuota(this.datPaymentCashYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [出金日 未指定～";
}
if (this.datPaymentCashYmd_T.Text.Trim() != "")
{
strWhrer += " AND replace(date_format(T.PAYMENT_CASH_YMD , " + ExEscape.SQL_YM + "), '0000/00', '') <= " + ExEscape.zRepStr(this.datPaymentCashYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datPaymentCashYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
}
else
{
if (this.datPaymentCashYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.PAYMENT_CASH_YMD >= " + ExEscape.zRepStr(this.datPaymentCashYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [出金日 " + ExEscape.zRepStrNoQuota(this.datPaymentCashYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [出金日 未指定～";
}
if (this.datPaymentCashYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.PAYMENT_CASH_YMD <= " + ExEscape.zRepStr(this.datPaymentCashYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datPaymentCashYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
}
#endregion
#region 入力担当者
if (this.utlPerson_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID >= " + ExCast.zCLng(this.utlPerson_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "[入力担当者 " + this.utlPerson_F.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString2 += "[入力担当者 未指定～";
}
if (this.utlPerson_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID <= " + ExCast.zCLng(this.utlPerson_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += this.utlPerson_T.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_T.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "未指定";
}
#endregion
#region 仕入先
if (this.utlPurchase.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PURCHASE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlPurchase.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [仕入先 " + ExEscape.zRepStrNoQuota(this.utlPurchase.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlPurchase.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString2 += "] [仕入先 未指定]";
}
#endregion
if (Common.gWinType == Common.geWinType.ListPaymentCashDay)
{
strWhrer += "<group kbn>1";
}
else if (Common.gWinType == Common.geWinType.ListPaymentCashMonth)
{
strWhrer += "<group kbn>2";
}
strWhrer = strWhrer.Replace(",", "<<@escape_comma@>>");
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
public string UpdateInvoiceBalance(string random, int type, List <EntityInvoiceBalance> entity)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
string personId = "";
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]);
personId = ExCast.zCStr(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 != "")
{
return(_message);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(認証処理)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString());
}
#endregion
#region Field
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = null;
string _Id = "";
int _classKbn = 0;
#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 + ".UpdateInvoiceBalance(DbOpen)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region BeginTransaction
try
{
db.ExBeginTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(BeginTransaction)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Update
if (type == 0)
{
try
{
for (int i = 0; i <= entity.Count - 1; i++)
{
if (entity[i].exec_flg == true)
{
double upd_balance = entity[i].before_invoice_price_upd - entity[i].before_invoice_price;
#region Update Invoice Balance
try
{
sb.Length = 0;
sb.Append("UPDATE T_INVOICE " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
0));
sb.Append(" ,BEFORE_INVOICE_PRICE = BEFORE_INVOICE_PRICE + " + upd_balance + Environment.NewLine);
sb.Append(" ,TRANSFER_PRICE = TRANSFER_PRICE + " + upd_balance + Environment.NewLine);
sb.Append(" ,INVOICE_PRICE = INVOICE_PRICE + " + upd_balance + Environment.NewLine);
sb.Append(" WHERE DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND INVOICE_KBN = 0 " + Environment.NewLine);
sb.Append(" AND INVOICE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(entity[i].invoice_id)) + Environment.NewLine);
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(Update Invoice Balance)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(Update Invoice Balance) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
}
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(Insert)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region PG排他制御
//try
//{
// DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db);
//}
//catch (Exception ex)
//{
// db.ExRollbackTransaction();
// CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(DelLockPg)", ex);
// return CLASS_NM + ".UpdateInvoiceBalance(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
//}
#endregion
#region CommitTransaction
try
{
db.ExCommitTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(CommitTransaction)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Database Close
try
{
db.DbClose();
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(DbClose)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
finally
{
db = null;
}
#endregion
#region Add Evidence
try
{
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.DeleteAndInsert,
"");
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateInvoiceBalance(Add Evidence)", ex);
return(CLASS_NM + ".UpdateInvoiceBalance(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
return("");
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
// 見積番号
if (this.utlEstimateNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO >= " + ExCast.zCLng(this.utlEstimateNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[見積番号 " + this.utlEstimateNo_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "[見積番号 未指定～";
}
if (this.utlEstimateNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO <= " + ExCast.zCLng(this.utlEstimateNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += this.utlEstimateNo_T.txtID.Text.Trim();
}
else
{
strWhrerString1 += "未指定";
}
// 見積日
if (this.datEstimateYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.ESTIMATE_YMD >= " + ExEscape.zRepStr(this.datEstimateYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [見積日 " + ExEscape.zRepStrNoQuota(this.datEstimateYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [見積日 未指定～";
}
if (this.datEstimateYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.ESTIMATE_YMD <= " + ExEscape.zRepStr(this.datEstimateYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datEstimateYmd_T.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
// 納入指定日
if (this.datNokiYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.SUPPLY_YMD >= " + ExEscape.zRepStr(this.datNokiYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [納入指定日 " + ExEscape.zRepStrNoQuota(this.datNokiYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [納入指定日 未指定～";
}
if (this.datNokiYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.SUPPLY_YMD <= " + ExEscape.zRepStr(this.datNokiYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datNokiYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
// 入力担当者
if (this.utlPerson_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID >= " + ExCast.zCLng(this.utlPerson_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "[入力担当者 " + this.utlPerson_F.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString2 += "[入力担当者 未指定～";
}
if (this.utlPerson_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID <= " + ExCast.zCLng(this.utlPerson_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += this.utlPerson_T.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_T.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "未指定";
}
// 得意先
if (this.utlCustomer.txtID.Text.Trim() != "")
{
strWhrer += " AND T.CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [得意先 " + ExEscape.zRepStrNoQuota(this.utlCustomer.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCustomer.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [得意先 未指定";
}
// 納入先
if (this.utlSupply.txtID.Text.Trim() != "")
{
strWhrer += " AND T.SUPPLIER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlSupply.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [納入先 " + ExEscape.zRepStrNoQuota(this.utlSupply.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlSupply.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [納入先 未指定";
}
// 商品コード
if (this.utlCommodity.txtID.Text.Trim() != "")
{
strWhrer += " AND OD.COMMODITY_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCommodity.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [商品コード " + ExEscape.zRepStrNoQuota(this.utlCommodity.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCommodity.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString2 += "] [商品コード 未指定" + "]";
}
// 取引区分
string _buf = "";
if (this.chkKake.IsChecked == true)
{
// 掛売上
strWhrer += " AND (T.BUSINESS_DIVISION_ID = 1";
_buf += " [取引区分 掛売上";
}
if (this.chkCash.IsChecked == true)
{
// 現金
if (_buf == "")
{
strWhrer += " AND (T.BUSINESS_DIVISION_ID = 2";
_buf += " [取引区分 現金";
}
else
{
strWhrer += " OR T.BUSINESS_DIVISION_ID = 2";
_buf += " 現金";
}
}
if (_buf == "")
{
_buf += " [取引区分 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
_buf = "";
// 承認状態
if (Common.gintEstimateApprovalFlg == 1)
{
if (this.chkStillApproval.IsChecked == true)
{
// 未承認
strWhrer += " AND (T.STATE = 0";
_buf += " [承認状態 未承認";
}
if (this.chkApproval.IsChecked == true)
{
// 承認
if (_buf == "")
{
strWhrer += " AND (T.STATE = 1";
_buf += " [承認状態 承認";
}
else
{
strWhrer += " OR T.STATE = 1";
_buf += " 承認";
}
}
if (this.chkResevation.IsChecked == true)
{
// 保留
if (_buf == "")
{
strWhrer += " AND (T.STATE = 2";
_buf += " [承認状態 保留";
}
else
{
strWhrer += " OR T.STATE = 2";
_buf += " 保留";
}
}
if (this.chkRejetion.IsChecked == true)
{
// 取消
if (_buf == "")
{
strWhrer += " AND (T.STATE = 3";
_buf += " [承認状態 取消";
}
else
{
strWhrer += " OR T.STATE = 3";
_buf += " 取消";
}
}
if (_buf == "")
{
_buf += " [承認状態 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
}
_buf = "";
// 見積書発行
if (this.borPrint.Visibility == System.Windows.Visibility.Visible)
{
if (this.chkPrintNo.IsChecked == true)
{
strWhrer += " AND (T.ESTIMATE_PRINT_FLG = 0";
_buf += " [見積書発行 発行未";
}
if (this.chkPrintYes.IsChecked == true)
{
if (_buf == "")
{
strWhrer += " AND (T.ESTIMATE_PRINT_FLG = 1";
_buf += " [見積書発行 発行済";
}
else
{
strWhrer += " OR T.ESTIMATE_PRINT_FLG = 1";
_buf += " 発行済";
}
}
if (_buf == "")
{
_buf += " [見積書発行 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
_buf = "";
}
UpdPrintNo = "";
if (this.ProcKbn == eProcKbn.Report)
{
strWhrer = "";
strWhrerString1 = "";
strWhrerString2 = "";
string _no = "";
for (int i = 0; i <= lst.Count - 1; i++)
{
if (lst[i].exec_flg == true)
{
if (string.IsNullOrEmpty(_no))
{
_no += ExCast.zCLng(this.lst[i].no).ToString();
}
else
{
_no += "<<@escape_comma@>>" + ExCast.zCLng(this.lst[i].no).ToString();
}
}
}
if (!string.IsNullOrEmpty(_no))
{
UpdPrintNo = _no;
strWhrer += " AND T.NO IN (" + _no + ")" + Environment.NewLine;
}
}
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
if (Common.gWinGroupType == Common.geWinGroupType.InpList)
{
strWhrer += " AND T.IN_OUT_DELIVERY_PROC_KBN = 1 " + Environment.NewLine;
}
// 入出庫日
if (this.datInOutDeliveryYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.IN_OUT_DELIVERY_YMD >= " + ExEscape.zRepStr(this.datInOutDeliveryYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[入出庫日 " + ExEscape.zRepStrNoQuota(this.datInOutDeliveryYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[入出庫日 未指定～";
}
if (this.datInOutDeliveryYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.IN_OUT_DELIVERY_YMD <= " + ExEscape.zRepStr(this.datInOutDeliveryYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datInOutDeliveryYmd_T.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
// 入出庫番号
if (this.utlNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO >= " + ExCast.zCLng(this.utlNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [入出庫番号 " + this.utlNo_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [入出庫番号 未指定～";
}
if (this.utlNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO <= " + ExCast.zCLng(this.utlNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += this.utlNo_T.txtID.Text.Trim();
}
else
{
strWhrerString1 += "未指定";
}
if (Common.gWinGroupType != Common.geWinGroupType.InpList)
{
// 元伝票番号
if (this.utlCauseNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.CAUSE_NO >= " + ExCast.zCLng(this.utlCauseNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [元伝票番号 " + this.utlCauseNo_F.txtID.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [元伝票番号 未指定～";
}
if (this.utlCauseNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.CAUSE_NO <= " + ExCast.zCLng(this.utlCauseNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += this.utlCauseNo_T.txtID.Text.Trim() + "]";
}
else
{
strWhrerString1 += "未指定]";
}
}
// 入力担当者
if (this.utlPerson_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID >= " + ExCast.zCLng(this.utlPerson_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "[入力担当者 " + this.utlPerson_F.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString2 += "[入力担当者 未指定～";
}
if (this.utlPerson_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID <= " + ExCast.zCLng(this.utlPerson_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += this.utlPerson_T.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_T.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "未指定";
}
// 入出庫区分
if (this.utlInOutDeliveryKbn.txtID.Text.Trim() != "")
{
strWhrer += " AND T.IN_OUT_DELIVERY_KBN = " + ExCast.zCLng(this.utlInOutDeliveryKbn.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "] [入出庫区分 " + ExCast.zCLng(this.utlInOutDeliveryKbn.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlInOutDeliveryKbn.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [入出庫区分 未指定";
}
// 入出庫先区分
if (this.utlInOutDeliveryToKbn.txtID.Text.Trim() != "")
{
strWhrerString2 += "] [入出庫先区分 " + ExCast.zCLng(this.utlInOutDeliveryToKbn.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlInOutDeliveryToKbn.txtNm.Text.Trim());
}
// 会社グループ
if (this.utlCompanyGroup.txtID.Text.Trim() != "")
{
strWhrer += " AND T.GROUP_ID_TO = " + ExCast.zCLng(this.utlCompanyGroup.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "] [会社グループ " + ExCast.zCLng(this.utlCompanyGroup.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCompanyGroup.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [会社グループ 未指定";
}
// 得意先
if (this.utlCustomer.txtID.Text.Trim() != "")
{
strWhrer += " AND T.CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [得意先 " + ExEscape.zRepStrNoQuota(this.utlCustomer.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCustomer.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [得意先 未指定";
}
// 仕入先
if (this.utlPurchase.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PURCHASE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlPurchase.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [仕入先 " + ExEscape.zRepStrNoQuota(this.utlPurchase.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlPurchase.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [仕入先 未指定";
}
// 商品コード
if (this.utlCommodity.txtID.Text.Trim() != "")
{
strWhrer += " AND EXISTS (SELECT 1 " + Environment.NewLine;
strWhrer += " FROM T_IN_OUT_DELIVERY_D AS OOD " + Environment.NewLine;
strWhrer += " WHERE OOD.COMPANY_ID = T.COMPANY_ID " + Environment.NewLine;
strWhrer += " AND OOD.GROUP_ID = T.GROUP_ID " + Environment.NewLine;
strWhrer += " AND OOD.IN_OUT_DELIVERY_ID = T.ID " + Environment.NewLine;
strWhrer += " AND OOD.COMMODITY_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlCommodity.txtID.Text.Trim())) + Environment.NewLine;
strWhrer += " ) " + Environment.NewLine;
strWhrerString2 += "] [商品コード " + ExEscape.zRepStrNoQuota(this.utlCommodity.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlCommodity.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString2 += "] [商品コード 未指定" + "]";
}
string _buf = "";
if (Common.gWinGroupType != Common.geWinGroupType.InpList)
{
// 入出庫処理区分
if (this.chkInOutDelivery.IsChecked == true)
{
// 入出庫
strWhrer += " AND (T.IN_OUT_DELIVERY_PROC_KBN = 1";
_buf += " [入出庫処理区分 入出庫";
}
if (this.chkSales.IsChecked == true)
{
// 売上
if (_buf == "")
{
strWhrer += " AND (T.IN_OUT_DELIVERY_PROC_KBN = 2";
_buf += " [入出庫処理区分 売上";
}
else
{
strWhrer += " OR T.IN_OUT_DELIVERY_PROC_KBN = 2";
_buf += " 売上";
}
}
if (this.chkPurchase.IsChecked == true)
{
// 仕入
if (_buf == "")
{
strWhrer += " AND (T.IN_OUT_DELIVERY_PROC_KBN = 3";
_buf += " [入出庫処理区分 仕入";
}
else
{
strWhrer += " OR T.IN_OUT_DELIVERY_PROC_KBN = 3";
_buf += " 仕入";
}
}
if (_buf == "")
{
_buf += " [入出庫処理区分 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
}
_buf = "";
UpdPrintNo = "";
if (this.ProcKbn == eProcKbn.Report)
{
strWhrer = "";
strWhrerString1 = "";
strWhrerString2 = "";
string _no = "";
for (int i = 0; i <= lst.Count - 1; i++)
{
if (lst[i].exec_flg == true)
{
if (string.IsNullOrEmpty(_no))
{
_no += ExCast.zCLng(this.lst[i].no).ToString();
}
else
{
_no += "<<@escape_comma@>>" + ExCast.zCLng(this.lst[i].no).ToString();
}
}
}
if (!string.IsNullOrEmpty(_no))
{
UpdPrintNo = _no;
strWhrer += " AND T.NO IN (" + _no + ")" + Environment.NewLine;
}
}
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
public EntityCommodity GetCommodity(string random, string Id)
{
EntityCommodity entity;
#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 != "")
{
entity = new EntityCommodity();
entity.MESSAGE = _message;
return(entity);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetCommodity(認証処理)", ex);
entity = new EntityCommodity();
entity.MESSAGE = CLASS_NM + ".GetCommodity : 認証処理に失敗しました。" + 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 MT.* " + Environment.NewLine);
sb.Append(" ,PU.NAME AS MAIN_PURCHASE_NAME " + Environment.NewLine);
sb.Append(" ,NM1.DESCRIPTION AS UNIT_NAME " + Environment.NewLine);
sb.Append(" ,NM2.DESCRIPTION AS TAXATION_DIVISION_NAME " + Environment.NewLine);
sb.Append(" ,NM3.DESCRIPTION AS INVENTORY_MANAGEMENT_DIVISION_NAME " + Environment.NewLine);
sb.Append(" ,NM4.DESCRIPTION AS INVENTORY_EVALUATION_NAME " + Environment.NewLine);
sb.Append(" ,CL1.NAME AS GROUP1_NAME " + Environment.NewLine);
sb.Append(" ,CL2.NAME AS GROUP2_NAME " + Environment.NewLine);
sb.Append(" ,CL3.NAME AS GROUP3_NAME " + Environment.NewLine);
sb.Append(" ,NM.DESCRIPTION AS DISPLAY_DIVISION_NAME " + Environment.NewLine);
sb.Append(" FROM M_COMMODITY AS MT" + Environment.NewLine);
#region Join
// 仕入先
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 = MT.COMPANY_ID" + Environment.NewLine);
sb.Append(" AND PU.ID = MT.MAIN_PURCHASE_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.UNIT_ID + Environment.NewLine);
sb.Append(" AND NM1.ID = MT.UNIT_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.TAX_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM2.ID = MT.TAXATION_DIVISION_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.INVENTORY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM3.ID = MT.INVENTORY_MANAGEMENT_DIVISION_ID" + Environment.NewLine);
// 在庫評価
sb.Append(" LEFT JOIN SYS_M_NAME AS NM4" + Environment.NewLine);
sb.Append(" ON NM4.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM4.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM4.DIVISION_ID = " + (int)CommonUtl.geNameKbn.INVENTORY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM4.ID = MT.INVENTORY_EVALUATION_ID" + Environment.NewLine);
// 商品分類1
sb.Append(" LEFT JOIN M_CLASS AS CL1" + Environment.NewLine);
sb.Append(" ON CL1.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND CL1.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND CL1.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine);
sb.Append(" AND CL1.CLASS_DIVISION_ID = " + (int)CommonUtl.geMGroupKbn.CommodityGrouop1 + Environment.NewLine);
sb.Append(" AND CL1.ID = MT.GROUP1_ID" + Environment.NewLine);
// 商品分類2
sb.Append(" LEFT JOIN M_CLASS AS CL2" + Environment.NewLine);
sb.Append(" ON CL2.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND CL2.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND CL2.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine);
sb.Append(" AND CL2.CLASS_DIVISION_ID = " + (int)CommonUtl.geMGroupKbn.CommodityGrouop2 + Environment.NewLine);
sb.Append(" AND CL2.ID = MT.GROUP2_ID" + Environment.NewLine);
// 商品分類3
sb.Append(" LEFT JOIN M_CLASS AS CL3" + Environment.NewLine);
sb.Append(" ON CL3.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND CL3.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND CL3.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine);
sb.Append(" AND CL3.CLASS_DIVISION_ID = " + (int)CommonUtl.geMGroupKbn.CommodityGrouop3 + Environment.NewLine);
sb.Append(" AND CL3.ID = MT.GROUP3_ID" + Environment.NewLine);
// 表示区分
sb.Append(" LEFT JOIN SYS_M_NAME AS NM" + Environment.NewLine);
sb.Append(" ON NM.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM.ID = MT.DISPLAY_FLG" + Environment.NewLine);
#endregion
sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND MT.SET_COMMODITY_FLG = 0 " + Environment.NewLine);
sb.Append(" AND MT.ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine);
sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine);
sb.Append(" ,MT.ID " + Environment.NewLine);
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
entity = new EntityCommodity();
// 排他制御
DataPgLock.geLovkFlg lockFlg;
string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, ExCast.zNumZeroNothingFormat(Id), ipAdress, db, out lockFlg);
if (strErr != "")
{
entity.MESSAGE = CLASS_NM + ".GetCommodity : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr;
}
#region Set Entity
entity.id = ExCast.zCStr(dt.DefaultView[0]["ID"]);
entity.name = ExCast.zCStr(dt.DefaultView[0]["NAME"]);
entity.kana = ExCast.zCStr(dt.DefaultView[0]["KANA"]);
entity.unit_id = ExCast.zCInt(dt.DefaultView[0]["UNIT_ID"]);
entity.unit_nm = ExCast.zCStr(dt.DefaultView[0]["UNIT_NAME"]);
entity.enter_number = ExCast.zCDbl(dt.DefaultView[0]["ENTER_NUMBER"]);
entity.number_decimal_digit = ExCast.zCInt(dt.DefaultView[0]["NUMBER_DECIMAL_DIGIT"]);
entity.unit_decimal_digit = ExCast.zCInt(dt.DefaultView[0]["UNIT_DECIMAL_DIGIT"]);
entity.taxation_divition_id = ExCast.zCInt(dt.DefaultView[0]["TAXATION_DIVISION_ID"]);
entity.taxation_divition_nm = ExCast.zCStr(dt.DefaultView[0]["TAXATION_DIVISION_NAME"]);
entity.inventory_management_division_id = ExCast.zCInt(dt.DefaultView[0]["INVENTORY_MANAGEMENT_DIVISION_ID"]);
entity.inventory_management_division_nm = ExCast.zCStr(dt.DefaultView[0]["INVENTORY_MANAGEMENT_DIVISION_NAME"]);
entity.purchase_lot = ExCast.zCDbl(dt.DefaultView[0]["PURCHASE_LOT"]);
entity.lead_time = ExCast.zCInt(dt.DefaultView[0]["LEAD_TIME"]);
entity.just_inventory_number = ExCast.zCDbl(dt.DefaultView[0]["JUST_INVENTORY_NUMBER"]);
entity.inventory_number = ExCast.zCDbl(dt.DefaultView[0]["INVENTORY_NUMBER"]);
entity.inventory_evaluation_id = ExCast.zCInt(dt.DefaultView[0]["INVENTORY_EVALUATION_ID"]);
entity.inventory_evaluation_nm = ExCast.zCStr(dt.DefaultView[0]["INVENTORY_EVALUATION_NAME"]);
entity.main_purchase_id = ExCast.zCStr(dt.DefaultView[0]["MAIN_PURCHASE_ID"]);
entity.main_purchase_nm = ExCast.zCStr(dt.DefaultView[0]["MAIN_PURCHASE_NAME"]);
entity.retail_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["RETAIL_PRICE_SKIP_TAX"]);
entity.retail_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["RETAIL_PRICE_BEFORE_TAX"]);
entity.sales_unit_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_UNIT_PRICE_SKIP_TAX"]);
entity.sales_unit_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_UNIT_PRICE_BEFORE_TAX"]);
entity.sales_cost_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_COST_PRICE_SKIP_TAX"]);
entity.sales_cost_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["SALES_COST_PRICE_BEFORE_TAX"]);
entity.purchase_unit_price_skip_tax = ExCast.zCDbl(dt.DefaultView[0]["PURCHASE_UNIT_PRICE_SKIP_TAX"]);
entity.purchase_unit_price_before_tax = ExCast.zCDbl(dt.DefaultView[0]["PURCHASE_UNIT_PRICE_BEFORE_TAX"]);
entity.group1_id = ExCast.zCStr(dt.DefaultView[0]["GROUP1_ID"]);
entity.group1_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP1_NAME"]);
entity.group2_id = ExCast.zCStr(dt.DefaultView[0]["GROUP2_ID"]);
entity.group2_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP2_NAME"]);
entity.group3_id = ExCast.zCStr(dt.DefaultView[0]["GROUP3_ID"]);
entity.group3_nm = ExCast.zCStr(dt.DefaultView[0]["GROUP3_NAME"]);
entity.display_division_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]);
entity.display_division_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]);
entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]);
entity.lock_flg = (int)lockFlg;
#endregion
}
else
{
entity = null;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetCommodity", ex);
entity = new EntityCommodity();
entity.MESSAGE = CLASS_NM + ".GetCommodity : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();
}
finally
{
db = null;
}
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Select,
"ID:" + Id.ToString());
return(entity);
}
public EntityCopying CopyCheck(string random, string tblName, string Id)
{
EntityCopying entity;
#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 != "")
{
entity = new EntityCopying();
entity.MESSAGE = _message;
return(entity);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".CopyCheck(認証処理)", ex);
entity = new EntityCopying();
entity.MESSAGE = CLASS_NM + ".CopyCheck : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();;
return(entity);
}
#endregion
#region Field
ExMySQLData db = ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString);
DataPgLock.geLovkFlg lockFlg;
entity = new EntityCopying();
entity.is_exists_data = false;
entity.is_lock_success = false;
entity.ret = false;
string get_col1Value = "";
string get_col2Value = "";
string get_col3Value = "";
string get_col4Value = "";
string get_col5Value = "";
string lock_check_pg_id = "";
string lock_check_id = "";
#endregion
try
{
// 複写時存在チェック
switch (tblName)
{
#region マスタ系
case "SYS_M_COMPANY_GROUP":
lock_check_id = Id;
lock_check_pg_id = DataPgEvidence.PGName.Mst.CompanyGroup;
entity.is_exists_data = DataExists.IsExistData(db, companyId, "", tblName, "ID", Id, CommonUtl.geStrOrNumKbn.String);
break;
case "M_CUSTOMER":
lock_check_id = Id;
lock_check_pg_id = DataPgEvidence.PGName.Mst.Customer;
entity.is_exists_data = DataExists.IsExistData(db, companyId, "", tblName, "ID", Id, CommonUtl.geStrOrNumKbn.String);
break;
case "M_PERSON":
lock_check_id = Id;
lock_check_pg_id = DataPgEvidence.PGName.Mst.Person;
entity.is_exists_data = DataExists.IsExistData(db, companyId, "", tblName, "ID", Id, CommonUtl.geStrOrNumKbn.Number);
break;
case "M_COMMODITY":
lock_check_id = Id;
lock_check_pg_id = DataPgEvidence.PGName.Mst.Commodity;
entity.is_exists_data = DataExists.IsExistData(db, companyId, "", tblName, "ID", Id, CommonUtl.geStrOrNumKbn.String);
break;
#endregion
#region 伝票入力系
#region 売上入力系
case "T_ESTIMATE_H":
lock_check_id = groupId + "-" + Id;
lock_check_pg_id = DataPgEvidence.PGName.Estimate.EstimateInp;
entity.is_exists_data = DataExists.IsExistData(db, companyId, groupId, tblName, "NO", Id, CommonUtl.geStrOrNumKbn.Number);
if (entity.is_exists_data)
{
// 受注計上済チェック
if (DataExists.IsExistData(db, companyId, groupId, "T_ORDER_H", "ESTIMATENO", Id, CommonUtl.geStrOrNumKbn.Number))
{
entity.MESSAGE = "複写先ID : " + Id + " は受注計上済の為、複写できません。";
return(entity);
}
// 売上計上済チェック
if (DataExists.IsExistData(db, companyId, groupId, "T_SALES_H", "ESTIMATENO", Id, CommonUtl.geStrOrNumKbn.Number))
{
entity.MESSAGE = "複写先ID : " + Id + " は売上計上済の為、複写できません。";
return(entity);
}
}
break;
case "T_ORDER_H":
lock_check_id = groupId + "-" + Id;
lock_check_pg_id = DataPgEvidence.PGName.Order.OrderInp;
entity.is_exists_data = DataExists.IsExistData(db, companyId, groupId, tblName, "NO", Id, CommonUtl.geStrOrNumKbn.Number);
if (entity.is_exists_data)
{
// 売上計上済チェック
if (DataExists.IsExistData(db, companyId, groupId, "T_SALES_H", "ORDER_NO", Id, CommonUtl.geStrOrNumKbn.Number))
{
entity.MESSAGE = "複写先ID : " + Id + " は売上計上済の為、複写できません。";
return(entity);
}
}
break;
case "T_SALES_H":
lock_check_id = groupId + "-" + Id;
lock_check_pg_id = DataPgEvidence.PGName.Sales.SalesInp;
entity.is_exists_data = DataExists.IsExistData(db, companyId, groupId, tblName, "NO", Id, CommonUtl.geStrOrNumKbn.Number);
if (entity.is_exists_data)
{
DataExists.GetData(db,
companyId,
groupId,
tblName,
"NO",
Id,
CommonUtl.geStrOrNumKbn.Number,
"TBL.INVOICE_ID",
"TBL.INVOICE_NO",
"TBL.RECEIPT_NO",
"TBL.BUSINESS_DIVISION_ID",
"date_format(TBL.SALES_YMD , " + ExEscape.SQL_YMD + ") AS SALES_YMD",
"INVOICE_ID",
"INVOICE_NO",
"RECEIPT_NO",
"BUSINESS_DIVISION_ID",
"SALES_YMD",
ref get_col1Value,
ref get_col2Value,
ref get_col3Value,
ref get_col4Value,
ref get_col5Value
);
// 掛売上
if (ExCast.zCInt(get_col4Value) == 1)
{
// 請求締切済チェック
if (DataClose.IsInvoiceClose(companyId, db, ExCast.zNumZeroNothingFormat(get_col1Value), ExCast.zDateNullToDefault(get_col5Value)))
{
entity.is_lock_success = false;
entity.ret = false;
entity.MESSAGE = "複写先ID : " + Id + " は請求締切済の為、複写できません。";
return(entity);
}
}
// 請求済チェック
// 都度請求分も請求番号が設定されている為、不許可とする
if (ExCast.zCLng(get_col2Value) != 0)
{
entity.MESSAGE = "複写先ID : " + Id + " は請求済の為、複写できません。";
return(entity);
}
// 入金済チェック
if (ExCast.zCLng(get_col2Value) != 0)
{
if (DataExists.IsExistData(db, companyId, groupId, "T_RECEIPT_H", "INVOICE_NO", ExCast.zCLng(get_col2Value).ToString(), CommonUtl.geStrOrNumKbn.Number))
{
entity.MESSAGE = "複写先ID : " + Id + " は入金計上済の為、複写できません。";
return(entity);
}
}
}
break;
case "T_RECEIPT_H":
lock_check_id = groupId + "-" + Id;
lock_check_pg_id = DataPgEvidence.PGName.Receipt.ReceiptInp;
entity.is_exists_data = DataExists.IsExistData(db, companyId, groupId, tblName, "NO", Id, CommonUtl.geStrOrNumKbn.Number);
break;
#endregion
#region 在庫入力系
case "T_IN_OUT_DELIVERY_H":
lock_check_id = groupId + "-" + Id;
lock_check_pg_id = DataPgEvidence.PGName.InOutDeliver.InOutDeliverInp;
entity.is_exists_data = DataExists.IsExistData(db, companyId, groupId, tblName, "NO", Id, CommonUtl.geStrOrNumKbn.Number);
if (entity.is_exists_data)
{
// 売上計上分チェック
if (DataExists.IsExistDataDouble(db, companyId, groupId, "T_IN_OUT_DELIVERY_H", "NO", Id, "IN_OUT_DELIVERY_PROC_KBN", "2", CommonUtl.geStrOrNumKbn.Number))
{
entity.MESSAGE = "複写先ID : " + Id + " は売上計上分の為、複写できません。";
return(entity);
}
// 仕入計上分チェック
if (DataExists.IsExistDataDouble(db, companyId, groupId, "T_IN_OUT_DELIVERY_H", "NO", Id, "IN_OUT_DELIVERY_PROC_KBN", "3", CommonUtl.geStrOrNumKbn.Number))
{
entity.MESSAGE = "複写先ID : " + Id + " は仕入計上分の為、複写できません。";
return(entity);
}
}
break;
#endregion
#endregion
default:
entity.is_exists_data = false;
break;
}
// 排他制御
string strErr = DataPgLock.SetLockPg(companyId, userId, lock_check_pg_id, lock_check_id, ipAdress, db, out lockFlg);
if (strErr != "")
{
entity.MESSAGE = CLASS_NM + ".CopyCheck : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr;
entity.is_lock_success = false;
entity.ret = false;
}
else
{
if (lockFlg == DataPgLock.geLovkFlg.Lock)
{
entity.is_lock_success = false;
entity.ret = false;
entity.MESSAGE = "複写先ID : " + Id + " は他ユーザーにて現在更新中の為、複写できません。";
}
else
{
entity.is_lock_success = true;
entity.ret = true;
}
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".CopyCheck", ex);
entity = new EntityCopying();
entity.MESSAGE = CLASS_NM + ".CopyCheck : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();;
}
return(entity);
}
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
case _GetWebServiceCallKbn:
// 更新
if (objList != null)
{
_entity = (EntitySupplier)objList;
if (_entity.message != "" && _entity.message != null)
{
this.utlID.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlID, 10);
return;
}
else
{
ExVisualTreeHelper.SetEnabled(this.MainDetail, true);
// バインド反映
SetBinding();
if (_entity._lock_flg == 0)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Sel;
}
}
}
// 新規
else
{
_entity = new EntitySupplier();
ExVisualTreeHelper.SetEnabled(this.MainDetail, true);
SetBinding();
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
}
this.utlID.txtID_IsReadOnly = true;
this.utlCustomer.txtID_IsReadOnly = true;
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
break;
case ExWebService.geWebServiceCallKbn.GetCustomer:
// 更新
if (objList != null)
{
EntityCustomer entityCustomer = (EntityCustomer)objList;
if (string.IsNullOrEmpty(entityCustomer.message))
{
string _Id = ExCast.zNumZeroNothingFormat(this.utlID.txtID.Text.Trim());
string _Nm = this.utlID.txtNm.Text.Trim();
string _customerId = ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim());
string _customerNm = this.utlCustomer.txtNm.Text.Trim();
_entity = new EntitySupplier();
_entity._id = _Id;
_entity._customer_id = _customerId;
_entity._customer_nm = _customerNm;
_entity._name = entityCustomer._name;
_entity._kana = entityCustomer._kana;
_entity._about_name = entityCustomer._about_name;
//_entity._zip_code = entityCustomer._zip_code;
_entity._adress_city = entityCustomer._adress_city;
_entity._adress_town = entityCustomer._adress_town;
_entity._adress1 = entityCustomer._adress1;
_entity._adress2 = entityCustomer._adress2;
_entity._station_name = entityCustomer._station_name;
_entity._post_name = entityCustomer._post_name;
_entity._person_name = entityCustomer._person_name;
_entity._title_id = entityCustomer._title_id;
_entity._title_name = entityCustomer._title_name;
_entity._tel = entityCustomer._tel;
_entity._fax = entityCustomer._fax;
_entity._mail_adress = entityCustomer._mail_adress;
_entity._mobile_tel = entityCustomer._mobile_tel;
_entity._mobile_adress = entityCustomer._mobile_adress;
_entity._url = entityCustomer._url;
SetBinding();
return;
}
}
break;
default:
break;
}
}
private void GetMstList(ExWebService.geDialogDisplayFlg flg)
{
object[] prm = new object[4];
prm[0] = this.txtCode.Text.Trim();
prm[1] = this.txtName.Text.Trim();
if (this.stpKana.Visibility == System.Windows.Visibility.Visible)
{
prm[2] = this.txtKana.Text.Trim();
}
else
{
prm[2] = "";
}
prm[3] = "";
if (objClassList != null)
{
for (int i = 0; i <= objClassList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbGroup1.SelectedValue) == objClassList[i].name)
{
prm[3] = objClassList[i].id;
}
}
}
if (this.MstKbn == MstData.geMDataKbn.Supplier)
{
prm[4] = ExCast.zNumZeroNothingFormat(Dlg_MstSearchGroup.this_id2);
}
webServiceMst.objPerent = this.utlDummy;
ExWebServiceMst.geWebServiceMstNmCallKbn callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCustomerList;
switch (this.MstKbn)
{
case MstData.geMDataKbn.Customer:
case MstData.geMDataKbn.Customer_F:
case MstData.geMDataKbn.Customer_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCustomerList;
break;
case MstData.geMDataKbn.Supplier:
case MstData.geMDataKbn.Supplier_F:
case MstData.geMDataKbn.Supplier_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetSupplierList;
break;
case MstData.geMDataKbn.Person:
case MstData.geMDataKbn.Person_F:
case MstData.geMDataKbn.Person_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetPersonList;
break;
case MstData.geMDataKbn.Commodity:
case MstData.geMDataKbn.Commodity_F:
case MstData.geMDataKbn.Commodity_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCommodityList;
break;
case MstData.geMDataKbn.CompanyGroup:
case MstData.geMDataKbn.CompanyGroup_F:
case MstData.geMDataKbn.CompanyGroup_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCompanyGroupList;
break;
case MstData.geMDataKbn.Zip:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetZipList;
break;
case MstData.geMDataKbn.Condition:
case MstData.geMDataKbn.Condition_F:
case MstData.geMDataKbn.Condition_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetConditionList;
break;
case MstData.geMDataKbn.RecieptDivision:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetRecieptDivisionList;
break;
case MstData.geMDataKbn.Group:
case MstData.geMDataKbn.Group_F:
case MstData.geMDataKbn.Group_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetGroupList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
case MstData.geMDataKbn.Purchase:
case MstData.geMDataKbn.Purchase_F:
case MstData.geMDataKbn.Purchase_T:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetPurchaseList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
case MstData.geMDataKbn.Inventory:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetInventoryList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
case MstData.geMDataKbn.SalesBalance:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetSalesBalanceList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
case MstData.geMDataKbn.PaymentBalance:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetPaymentBalanceList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
}
if (flg == ExWebService.geDialogDisplayFlg.Yes)
{
webServiceMst.CallWebServiceMst(callKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
else
{
webServiceMst.CallWebServiceMst(callKbn,
ExWebService.geDialogDisplayFlg.No,
ExWebService.geDialogCloseFlg.No,
prm);
}
}
private void GetMstList(ExWebService.geDialogDisplayFlg flg)
{
object[] prm = new object[3];
prm[0] = this.txtCode.Text.Trim();
prm[1] = this.txtName.Text.Trim();
if (this.MstKbn == MstData.geMDataKbn.Supplier)
{
prm[2] = ExCast.zNumZeroNothingFormat(this.Id2);
}
webServiceMst.objPerent = this;
ExWebServiceMst.geWebServiceMstNmCallKbn callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCustomerList;
switch (this.MstKbn)
{
case MstData.geMDataKbn.Customer:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCustomerList;
break;
case MstData.geMDataKbn.Supplier:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetSupplierList;
break;
case MstData.geMDataKbn.Person:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetPersonList;
break;
case MstData.geMDataKbn.Commodity:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCommodityList;
break;
case MstData.geMDataKbn.CompanyGroup:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetCompanyGroupList;
break;
case MstData.geMDataKbn.Zip:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetZipList;
break;
case MstData.geMDataKbn.Condition:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetConditionList;
break;
case MstData.geMDataKbn.RecieptDivision:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetRecieptDivisionList;
break;
case MstData.geMDataKbn.Group:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetGroupList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
case MstData.geMDataKbn.Purchase:
callKbn = ExWebServiceMst.geWebServiceMstNmCallKbn.GetPurchaseList;
webServiceMst.MstGroupKbn = this.MstGroupKbn;
break;
}
if (flg == ExWebService.geDialogDisplayFlg.Yes)
{
webServiceMst.CallWebServiceMst(callKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
else
{
webServiceMst.CallWebServiceMst(callKbn,
ExWebService.geDialogDisplayFlg.No,
ExWebService.geDialogCloseFlg.No,
prm);
}
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
// 支払書番号
if (this.utlPaymentNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO >= " + ExCast.zCLng(this.utlPaymentNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[支払書番号 " + ExCast.zCLng(this.utlPaymentNo_F.txtID.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[支払書番号 未指定～";
}
if (this.utlPaymentNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO <= " + ExCast.zCLng(this.utlPaymentNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExCast.zCLng(this.utlPaymentNo_T.txtID.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
// 支払締日
if (this.datPaymentCloseYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.PAYMENT_YYYYMMDD >= " + ExEscape.zRepStr(this.datPaymentCloseYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [支払締日 " + this.datPaymentCloseYmd_F.Text.Trim() + "～";
}
else
{
strWhrerString1 += "] [支払締日 未指定～";
}
if (this.datPaymentCloseYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.PAYMENT_YYYYMMDD <= " + ExEscape.zRepStr(this.datPaymentCloseYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += this.datPaymentCloseYmd_T.Text.Trim();
}
else
{
strWhrerString1 += "未指定";
}
// 仕入先
if (this.utlPurchase.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PURCHASE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlPurchase.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "[仕入先 " + ExEscape.zRepStrNoQuota(this.utlPurchase.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlPurchase.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "[仕入先 未指定";
}
// 締区分
if (this.utlSummingUp.txtID.Text.Trim() != "")
{
strWhrer += " AND T.SUMMING_UP_GROUP_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlSummingUp.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [締区分 " + ExEscape.zRepStrNoQuota(this.utlSummingUp.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlSummingUp.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "] [締区分 未指定";
}
string _buf = "";
// 支払書発行
if (borPrint.Visibility == System.Windows.Visibility.Visible)
{
if (this.chkPrintNo.IsChecked == true)
{
// 発行済を除く
strWhrer += " AND (T.PAYMENT_PRINT_FLG = 0";
_buf += " [支払書発行 発行未";
}
if (this.chkPrintYes.IsChecked == true)
{
// 都度請求
if (_buf == "")
{
strWhrer += " AND (T.PAYMENT_PRINT_FLG = 1";
_buf += " [支払書発行 発行済";
}
else
{
strWhrer += " OR T.PAYMENT_PRINT_FLG = 1";
_buf += " 発行済";
}
}
if (_buf == "")
{
_buf += " [支払書発行 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
}
_buf = "";
// 出金消込
if (borReceipt.Visibility == System.Windows.Visibility.Visible)
{
if (this.chkPaymentNo.IsChecked == true)
{
strWhrer += " AND (IFNULL(RP_SUM.SUM_PRICE, 0) = 0";
_buf += " [出金消込 消込未";
}
if (this.chkPaymentPlace.IsChecked == true)
{
if (_buf == "")
{
strWhrer += " AND (IFNULL(RP_SUM.SUM_PRICE, 0) < IFNULL(T.PAYMENT_PRICE, 0)";
_buf += " [出金消込 一部消込";
}
else
{
strWhrer += " OR IFNULL(RP_SUM.SUM_PRICE, 0) < IFNULL(T.PAYMENT_PRICE, 0)";
_buf += " 一部消込";
}
}
if (this.chkPaymentYes.IsChecked == true)
{
if (_buf == "")
{
strWhrer += " AND (IFNULL(RP_SUM.SUM_PRICE, 0) = IFNULL(T.PAYMENT_PRICE, 0)";
_buf += " [出金消込 消込済";
}
else
{
strWhrer += " OR IFNULL(RP_SUM.SUM_PRICE, 0) = IFNULL(T.PAYMENT_PRICE, 0)";
_buf += " 消込済";
}
}
if (this.chkPaymentOver.IsChecked == true)
{
if (_buf == "")
{
strWhrer += " AND (IFNULL(RP_SUM.SUM_PRICE, 0) > IFNULL(T.PAYMENT_PRICE, 0)";
_buf += " [出金消込 超過消込";
}
else
{
strWhrer += " OR IFNULL(RP_SUM.SUM_PRICE, 0) > IFNULL(T.PAYMENT_PRICE, 0)";
_buf += " 超過消込";
}
}
if (_buf == "")
{
_buf += " [出金消込 指定無し]";
}
else
{
strWhrer += ")" + Environment.NewLine;
_buf += "]";
}
strWhrerString2 += _buf;
}
_buf = "";
lstUpd.Clear();
if (this.ProcKbn == eProcKbn.Report)
{
strWhrer = "";
strWhrerString1 = "";
strWhrerString2 = "";
string _no = "";
for (int i = 0; i <= lst.Count - 1; i++)
{
if (lst[i].exec_flg == true)
{
EntityPaymentClose entityUpd = new EntityPaymentClose();
entityUpd._no = lst[i].no;
lstUpd.Add(entityUpd);
if (string.IsNullOrEmpty(_no))
{
_no += ExCast.zCLng(this.lst[i].no).ToString();
}
else
{
_no += "<<@escape_comma@>>" + ExCast.zCLng(this.lst[i].no).ToString();
}
}
}
if (!string.IsNullOrEmpty(_no))
{
strWhrer += " AND T.NO IN (" + _no + ")" + Environment.NewLine;
}
if (datIssueYmd.SelectedDate != null)
{
strWhrer += "<issue ymd>" + ((DateTime)datIssueYmd.SelectedDate).ToString("yyyy/MM/dd");
}
}
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
if (Common.gWinType == Common.geWinType.ListCollectPlan)
{
#region 回収予定日
if (this.datCollectPlanYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.COLLECT_PLAN_DAY >= " + ExEscape.zRepStr(this.datCollectPlanYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[回収予定日 " + ExEscape.zRepStrNoQuota(this.datCollectPlanYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[回収予定日 未指定～";
}
if (this.datCollectPlanYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.COLLECT_PLAN_DAY <= " + ExEscape.zRepStr(this.datCollectPlanYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datCollectPlanYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
#endregion
#region 請求先
if (this.utlInvoice_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.INVOICE_ID >= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlInvoice_F.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += "] [請求先 " + ExEscape.zRepStrNoQuota(this.utlInvoice_F.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlInvoice_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [請求先 未指定～";
}
if (this.utlInvoice_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.INVOICE_ID >= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlInvoice_T.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.utlInvoice_T.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlInvoice_T.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
#endregion
}
else if (Common.gWinType == Common.geWinType.ListPaymentPlan)
{
#region 支払予定日
if (this.datCollectPlanYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.PAYMENT_PLAN_DAY >= " + ExEscape.zRepStr(this.datCollectPlanYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[支払予定日 " + ExEscape.zRepStrNoQuota(this.datCollectPlanYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[支払予定日 未指定～";
}
if (this.datCollectPlanYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.PAYMENT_PLAN_DAY <= " + ExEscape.zRepStr(this.datCollectPlanYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datCollectPlanYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
#endregion
#region 仕入先
if (this.utlPurchase_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PURCHASE_ID >= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlPurchase_F.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += "] [仕入先 " + ExEscape.zRepStrNoQuota(this.utlPurchase_F.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlPurchase_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [仕入先 未指定～";
}
if (this.utlPurchase_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PURCHASE_ID >= " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlPurchase_T.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.utlPurchase_T.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlPurchase_T.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
#endregion
}
string _buf = "";
//if (Common.gWinType == Common.geWinType.ListSalesDay)
//{
// strWhrer += "<group kbn>1";
//}
//else if (Common.gWinType == Common.geWinType.ListSalesMonth)
//{
// strWhrer += "<group kbn>2";
//}
//else if (Common.gWinType == Common.geWinType.ListSalesChange)
//{
// strWhrer += "<group kbn>3";
//}
strWhrer = strWhrer.Replace(",", "<<@escape_comma@>>");
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
public string UpdateCommodity(string random, int type, string Id, EntityCommodity entity)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
string personId = "";
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]);
personId = ExCast.zCStr(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 != "")
{
return(_message);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(認証処理)", ex);
return(CLASS_NM + ".UpdateCommodity : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString());
}
#endregion
#region Field
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = null;
string _Id = "";
#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 + ".UpdateCommodity(DbOpen)", ex);
return(CLASS_NM + ".UpdateCommodity(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region BeginTransaction
try
{
db.ExBeginTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(BeginTransaction)", ex);
return(CLASS_NM + ".UpdateCommodity(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Get Max Master ID
if (type == 1 && (Id == "" || Id == "0"))
{
try
{
DataMasterId.GetMaxMasterId(companyId,
"",
db,
DataMasterId.geMasterMaxIdKbn.Commodity,
out _Id);
if (_Id == "")
{
return("ID取得に失敗しました。");
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(GetMaxMasterId)", ex);
return(CLASS_NM + ".UpdateCommodity(GetMaxMasterId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
else
{
_Id = Id;
}
#endregion
#region Insert
if (type == 1)
{
try
{
#region Delete SQL
sb.Length = 0;
sb.Append("DELETE FROM M_COMMODITY " + Environment.NewLine);
sb.Append(" WHERE DELETE_FLG = 1 " + Environment.NewLine);
sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine);
#endregion
db.ExecuteSQL(sb.ToString(), false);
#region Insert SQL
string _main_purchase_id = entity.main_purchase_id;
if (ExCast.IsNumeric(_main_purchase_id))
{
_main_purchase_id = ExCast.zCDbl(_main_purchase_id).ToString();
}
#region SQL
sb.Length = 0;
sb.Append("INSERT INTO M_COMMODITY " + Environment.NewLine);
sb.Append(" ( COMPANY_ID" + Environment.NewLine);
sb.Append(" , ID" + Environment.NewLine);
sb.Append(" , ID2" + Environment.NewLine);
sb.Append(" , NAME" + Environment.NewLine);
sb.Append(" , KANA" + Environment.NewLine);
sb.Append(" , UNIT_ID" + Environment.NewLine);
sb.Append(" , ENTER_NUMBER" + Environment.NewLine);
sb.Append(" , NUMBER_DECIMAL_DIGIT" + Environment.NewLine);
sb.Append(" , UNIT_DECIMAL_DIGIT" + Environment.NewLine);
sb.Append(" , TAXATION_DIVISION_ID" + Environment.NewLine);
sb.Append(" , INVENTORY_MANAGEMENT_DIVISION_ID" + Environment.NewLine);
sb.Append(" , PURCHASE_LOT" + Environment.NewLine);
sb.Append(" , LEAD_TIME" + Environment.NewLine);
sb.Append(" , JUST_INVENTORY_NUMBER" + Environment.NewLine);
sb.Append(" , INVENTORY_NUMBER" + Environment.NewLine);
sb.Append(" , INVENTORY_EVALUATION_ID" + Environment.NewLine);
sb.Append(" , MAIN_PURCHASE_ID" + Environment.NewLine);
sb.Append(" , RETAIL_PRICE_SKIP_TAX" + Environment.NewLine);
sb.Append(" , RETAIL_PRICE_BEFORE_TAX" + Environment.NewLine);
sb.Append(" , SALES_UNIT_PRICE_SKIP_TAX" + Environment.NewLine);
sb.Append(" , SALES_UNIT_PRICE_BEFORE_TAX" + Environment.NewLine);
sb.Append(" , SALES_COST_PRICE_SKIP_TAX" + Environment.NewLine);
sb.Append(" , SALES_COST_PRICE_BEFORE_TAX" + Environment.NewLine);
sb.Append(" , PURCHASE_UNIT_PRICE_SKIP_TAX" + Environment.NewLine);
sb.Append(" , PURCHASE_UNIT_PRICE_BEFORE_TAX" + Environment.NewLine);
sb.Append(" , GROUP1_ID" + Environment.NewLine);
sb.Append(" , GROUP2_ID" + Environment.NewLine);
sb.Append(" , GROUP3_ID" + Environment.NewLine);
sb.Append(" , MEMO" + Environment.NewLine);
sb.Append(" , DISPLAY_FLG" + 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(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID
sb.Append(" ," + ExCast.zIdForNumIndex(_Id) + Environment.NewLine); // ID2
sb.Append(" ," + ExEscape.zRepStr(entity.name) + Environment.NewLine); // NAME
sb.Append(" ," + ExEscape.zRepStr(entity.kana) + Environment.NewLine); // KANA
sb.Append(" ," + entity.unit_id + Environment.NewLine); // UNIT_ID
sb.Append(" ," + entity.enter_number + Environment.NewLine); // ENTER_NUMBER
sb.Append(" ," + entity.number_decimal_digit + Environment.NewLine); // NUMBER_DECIMAL_DIGIT
sb.Append(" ," + entity.unit_decimal_digit + Environment.NewLine); // UNIT_DECIMAL_DIGIT
sb.Append(" ," + entity.taxation_divition_id + Environment.NewLine); // TAXATION_DIVISION_ID
sb.Append(" ," + entity.inventory_management_division_id + Environment.NewLine); // INVENTORY_MANAGEMENT_DIVISION_ID
sb.Append(" ," + entity.purchase_lot + Environment.NewLine); // PURCHASE_LOT
sb.Append(" ," + entity.lead_time + Environment.NewLine); // LEAD_TIME
sb.Append(" ," + entity.just_inventory_number + Environment.NewLine); // JUST_INVENTORY_NUMBER
sb.Append(" ," + entity.inventory_number + Environment.NewLine); // INVENTORY_NUMBER
sb.Append(" ," + entity.inventory_evaluation_id + Environment.NewLine); // INVENTORY_EVALUATION_ID
sb.Append(" ," + ExEscape.zRepStr(_main_purchase_id) + Environment.NewLine); // MAIN_PURCHASE_ID
sb.Append(" ," + entity.retail_price_skip_tax + Environment.NewLine); // RETAIL_PRICE_SKIP_TAX
sb.Append(" ," + entity.retail_price_before_tax + Environment.NewLine); // RETAIL_PRICE_BEFORE_TAX
sb.Append(" ," + entity.sales_unit_price_skip_tax + Environment.NewLine); // SALES_UNIT_PRICE_SKIP_TAX
sb.Append(" ," + entity.sales_unit_price_before_tax + Environment.NewLine); // SALES_UNIT_PRICE_BEFORE_TAX
sb.Append(" ," + entity.sales_cost_price_skip_tax + Environment.NewLine); // SALES_COST_PRICE_SKIP_TAX
sb.Append(" ," + entity.sales_cost_price_before_tax + Environment.NewLine); // SALES_COST_PRICE_BEFORE_TAX
sb.Append(" ," + entity.purchase_unit_price_skip_tax + Environment.NewLine); // PURCHASE_UNIT_PRICE_SKIP_TAX
sb.Append(" ," + entity.purchase_unit_price_before_tax + Environment.NewLine); // PURCHASE_UNIT_PRICE_BEFORE_TAX
sb.Append(" ," + ExEscape.zRepStr(entity.group1_id) + Environment.NewLine); // GROUP1_ID
sb.Append(" ," + ExEscape.zRepStr(entity.group2_id) + Environment.NewLine); // GROUP2_ID
sb.Append(" ," + ExEscape.zRepStr(entity.group3_id) + Environment.NewLine); // GROUP3_ID
sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO
sb.Append(" ," + entity.display_division_id + Environment.NewLine); // DISPLAY_FLG
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins,
PG_NM,
"M_COMMODITY",
ExCast.zCInt(personId),
_Id,
ipAdress,
userId));
#endregion
#endregion
db.ExecuteSQL(sb.ToString(), false);
#region Commodity Inventory Insert
try
{
#region Delete SQL
sb.Length = 0;
sb.Append("DELETE FROM M_COMMODITY_INVENTORY " + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID
#endregion
db.ExecuteSQL(sb.ToString(), false);
#region SQL
sb.Length = 0;
sb.Append("SELECT MT.* " + Environment.NewLine);
sb.Append(" FROM SYS_M_COMPANY_GROUP AS MT" + Environment.NewLine);
sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" ORDER BY MT.ID " + Environment.NewLine);
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
for (int i = 0; i <= dt.DefaultView.Count - 1; i++)
{
#region Insert SQL
sb.Length = 0;
sb.Append("INSERT INTO M_COMMODITY_INVENTORY " + Environment.NewLine);
sb.Append(" ( COMPANY_ID" + Environment.NewLine);
sb.Append(" , GROUP_ID" + Environment.NewLine);
sb.Append(" , ID" + Environment.NewLine);
sb.Append(" , INVENTORY_NUMBER" + 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(" ," + ExCast.zCStr(dt.DefaultView[i]["ID"]) + Environment.NewLine); // GROUP_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID
sb.Append(" ,0" + Environment.NewLine); // INVENTORY_NUMBER
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins,
PG_NM,
"M_COMMODITY_INVENTORY",
ExCast.zCInt(personId),
_Id,
ipAdress,
userId));
#endregion
db.ExecuteSQL(sb.ToString(), false);
}
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Commodity Inventory Insert)", ex);
return(CLASS_NM + ".UpdateCommodity(Commodity Inventory Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Insert)", ex);
return(CLASS_NM + ".UpdateCommodity(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region Update
if (type == 0)
{
try
{
#region SQL
string _main_purchase_id = entity.main_purchase_id;
if (ExCast.IsNumeric(_main_purchase_id))
{
_main_purchase_id = ExCast.zCDbl(_main_purchase_id).ToString();
}
sb.Length = 0;
sb.Append("UPDATE M_COMMODITY " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
0));
sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine);
sb.Append(" ,KANA = " + ExEscape.zRepStr(entity.kana) + Environment.NewLine);
sb.Append(" ,UNIT_ID = " + entity.unit_id + Environment.NewLine);
sb.Append(" ,ENTER_NUMBER = " + entity.enter_number + Environment.NewLine);
sb.Append(" ,NUMBER_DECIMAL_DIGIT = " + entity.number_decimal_digit + Environment.NewLine);
sb.Append(" ,UNIT_DECIMAL_DIGIT = " + entity.unit_decimal_digit + Environment.NewLine);
sb.Append(" ,TAXATION_DIVISION_ID = " + entity.taxation_divition_id + Environment.NewLine);
sb.Append(" ,INVENTORY_MANAGEMENT_DIVISION_ID = " + entity.inventory_management_division_id + Environment.NewLine);
sb.Append(" ,PURCHASE_LOT = " + entity.purchase_lot + Environment.NewLine);
sb.Append(" ,LEAD_TIME = " + entity.lead_time + Environment.NewLine);
sb.Append(" ,JUST_INVENTORY_NUMBER = " + entity.just_inventory_number + Environment.NewLine);
sb.Append(" ,INVENTORY_NUMBER = " + entity.inventory_number + Environment.NewLine);
sb.Append(" ,INVENTORY_EVALUATION_ID = " + entity.inventory_evaluation_id + Environment.NewLine);
sb.Append(" ,MAIN_PURCHASE_ID = " + ExEscape.zRepStr(_main_purchase_id) + Environment.NewLine);
sb.Append(" ,RETAIL_PRICE_SKIP_TAX = " + entity.retail_price_skip_tax + Environment.NewLine);
sb.Append(" ,RETAIL_PRICE_BEFORE_TAX = " + entity.retail_price_before_tax + Environment.NewLine);
sb.Append(" ,SALES_UNIT_PRICE_SKIP_TAX = " + entity.sales_unit_price_skip_tax + Environment.NewLine);
sb.Append(" ,SALES_UNIT_PRICE_BEFORE_TAX = " + entity.sales_unit_price_before_tax + Environment.NewLine);
sb.Append(" ,SALES_COST_PRICE_SKIP_TAX = " + entity.sales_cost_price_skip_tax + Environment.NewLine);
sb.Append(" ,SALES_COST_PRICE_BEFORE_TAX = " + entity.sales_cost_price_before_tax + Environment.NewLine);
sb.Append(" ,PURCHASE_UNIT_PRICE_SKIP_TAX = " + entity.purchase_unit_price_skip_tax + Environment.NewLine);
sb.Append(" ,PURCHASE_UNIT_PRICE_BEFORE_TAX = " + entity.purchase_unit_price_before_tax + Environment.NewLine);
sb.Append(" ,GROUP1_ID = " + ExEscape.zRepStr(entity.group1_id) + Environment.NewLine);
sb.Append(" ,GROUP2_ID = " + ExEscape.zRepStr(entity.group2_id) + Environment.NewLine);
sb.Append(" ,GROUP3_ID = " + ExEscape.zRepStr(entity.group3_id) + Environment.NewLine);
sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine);
sb.Append(" ,DISPLAY_FLG = " + entity.display_division_id + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID
#endregion
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Update)", ex);
return(CLASS_NM + ".UpdateCommodity(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region Delete
if (type == 2)
{
#region Exist Data
try
{
bool _ret = false;
_ret = DataExists.IsExistData(db, companyId, groupId, "T_ESTIMATE_D", "COMMODITY_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String);
if (_ret == true)
{
return("商品ID : " + Id + " は見積データに使用されている為、削除できません。");
}
_ret = DataExists.IsExistData(db, companyId, groupId, "T_ORDER_D", "COMMODITY_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String);
if (_ret == true)
{
return("商品ID : " + Id + " は受注データに使用されている為、削除できません。");
}
_ret = DataExists.IsExistData(db, companyId, groupId, "T_SALES_D", "COMMODITY_ID", ExCast.zNumZeroNothingFormat(Id), CommonUtl.geStrOrNumKbn.String);
if (_ret == true)
{
return("商品ID : " + Id + " は売上データに使用されている為、削除できません。");
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Exist Data)", ex);
return(CLASS_NM + ".UpdateCommodity(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Delete Commodity Inventory
try
{
sb.Length = 0;
sb.Append("UPDATE M_COMMODITY_INVENTORY " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Delete Commodity Inventory)", ex);
return(CLASS_NM + ".UpdateCommodity(Commodity Inventory) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Update
try
{
sb.Length = 0;
sb.Append("UPDATE M_COMMODITY " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Delete)", ex);
return(CLASS_NM + ".UpdateCommodity(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
}
#endregion
#region PG排他制御
if (type == 0 || type == 2)
{
try
{
DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(DelLockPg)", ex);
return(CLASS_NM + ".UpdateCommodity(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region CommitTransaction
try
{
db.ExCommitTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(CommitTransaction)", ex);
return(CLASS_NM + ".UpdateCommodity(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Database Close
try
{
db.DbClose();
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(DbClose)", ex);
return(CLASS_NM + ".UpdateCommodity(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,
PG_NM,
DataPgEvidence.geOperationType.Update,
"ID:" + Id.ToString());
break;
case 1:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Insert,
"ID:" + _Id.ToString());
break;
case 2:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Delete,
"ID:" + Id.ToString());
break;
default:
break;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateCommodity(Add Evidence)", ex);
return(CLASS_NM + ".UpdateCommodity(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Return
if (type == 1 && (Id == "0" || Id == ""))
{
return("Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。");
}
else
{
return("");
}
#endregion
}
public EntitySupplier GetSupplier(string random, string CustomerId, string Id)
{
EntitySupplier entity;
#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 != "")
{
entity = new EntitySupplier();
entity.MESSAGE = _message;
return(entity);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetSupplier(認証処理)", ex);
entity = new EntitySupplier();
entity.MESSAGE = CLASS_NM + ".GetSupplier : 認証処理に失敗しました。" + 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 MT.* " + Environment.NewLine);
sb.Append(" ,CM.NAME AS CUSTOMER_NAME " + Environment.NewLine);
sb.Append(" ,NM1.DESCRIPTION AS DIVIDE_PERMISSION_NAME " + Environment.NewLine);
sb.Append(" ,NM.DESCRIPTION AS DISPLAY_DIVISION_NAME " + Environment.NewLine);
sb.Append(" FROM M_SUPPLIER AS MT" + Environment.NewLine);
#region Join
// 得意先
sb.Append(" LEFT JOIN M_CUSTOMER AS CM" + Environment.NewLine);
sb.Append(" ON CM.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND CM.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND CM.COMPANY_ID = MT.COMPANY_ID" + Environment.NewLine);
sb.Append(" AND CM.ID = MT.CUSTOMER_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.DIVIDE_PERMISSION_ID + Environment.NewLine);
sb.Append(" AND NM1.ID = MT.DIVIDE_PERMISSION_ID" + Environment.NewLine);
// 表示区分
sb.Append(" LEFT JOIN SYS_M_NAME AS NM" + Environment.NewLine);
sb.Append(" ON NM.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND NM.DISPLAY_FLG = 1 " + Environment.NewLine);
sb.Append(" AND NM.DIVISION_ID = " + (int)CommonUtl.geNameKbn.DISPLAY_DIVISION_ID + Environment.NewLine);
sb.Append(" AND NM.ID = MT.DISPLAY_FLG" + Environment.NewLine);
#endregion
sb.Append(" WHERE MT.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND MT.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND MT.CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine);
sb.Append(" AND MT.ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine);
sb.Append(" ORDER BY MT.COMPANY_ID " + Environment.NewLine);
sb.Append(" ,MT.ID " + Environment.NewLine);
#endregion
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
entity = new EntitySupplier();
// 排他制御
DataPgLock.geLovkFlg lockFlg;
string strErr = DataPgLock.SetLockPg(companyId, userId, PG_NM, ExCast.zNumZeroNothingFormat(CustomerId) + "-" + ExCast.zNumZeroNothingFormat(Id), ipAdress, db, out lockFlg);
if (strErr != "")
{
entity.MESSAGE = CLASS_NM + ".GetSupplier : 排他制御(ロック情報取得)に失敗しました。" + Environment.NewLine + strErr;
}
#region Set Entity
entity.id = ExCast.zCStr(dt.DefaultView[0]["ID"]);
entity.name = ExCast.zCStr(dt.DefaultView[0]["NAME"]);
entity.kana = ExCast.zCStr(dt.DefaultView[0]["KANA"]);
entity.about_name = ExCast.zCStr(dt.DefaultView[0]["ABOUT_NAME"]);
string _zip = ExCast.zCStr(dt.DefaultView[0]["ZIP_CODE"]);
if (!string.IsNullOrEmpty(_zip) && ExCast.zCStr(_zip) != "0")
{
_zip = string.Format("{0:0000000}", ExCast.zCDbl(_zip));
entity.zip_code_from = _zip.Substring(0, 3);
entity.zip_code_to = _zip.Substring(3, 4);
}
else
{
entity.zip_code_from = "";
entity.zip_code_to = "";
}
entity.prefecture_id = ExCast.zCInt(dt.DefaultView[0]["PREFECTURE_ID"]);
entity.city_id = ExCast.zCInt(dt.DefaultView[0]["CITY_ID"]);
entity.town_id = ExCast.zCInt(dt.DefaultView[0]["TOWN_ID"]);
entity.adress_city = ExCast.zCStr(dt.DefaultView[0]["ADRESS_CITY"]);
entity.adress_town = ExCast.zCStr(dt.DefaultView[0]["ADRESS_TOWN"]);
entity.adress1 = ExCast.zCStr(dt.DefaultView[0]["ADRESS1"]);
entity.adress2 = ExCast.zCStr(dt.DefaultView[0]["ADRESS2"]);
entity.station_name = ExCast.zCStr(dt.DefaultView[0]["STATION_NAME"]);
entity.post_name = ExCast.zCStr(dt.DefaultView[0]["POST_NAME"]);
entity.person_name = ExCast.zCStr(dt.DefaultView[0]["PERSON_NAME"]);
entity.title_id = ExCast.zCInt(dt.DefaultView[0]["TITLE_ID"]);
entity.title_name = ExCast.zCStr(dt.DefaultView[0]["TITLE_NAME"]);
entity.tel = ExCast.zCStr(dt.DefaultView[0]["TEL"]);
entity.fax = ExCast.zCStr(dt.DefaultView[0]["FAX"]);
entity.mail_adress = ExCast.zCStr(dt.DefaultView[0]["MAIL_ADRESS"]);
entity.mobile_tel = ExCast.zCStr(dt.DefaultView[0]["MOBILE_TEL"]);
entity.mobile_adress = ExCast.zCStr(dt.DefaultView[0]["MOBILE_ADRESS"]);
entity.url = ExCast.zCStr(dt.DefaultView[0]["URL"]);
entity.customer_id = ExCast.zCStr(dt.DefaultView[0]["CUSTOMER_ID"]);
entity.customer_nm = ExCast.zCStr(dt.DefaultView[0]["CUSTOMER_NAME"]);
entity.divide_permission_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]);
entity.divide_permission_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]);
entity.display_division_id = ExCast.zCInt(dt.DefaultView[0]["DISPLAY_FLG"]);
entity.display_division_nm = ExCast.zCStr(dt.DefaultView[0]["DISPLAY_DIVISION_NAME"]);
entity.lock_flg = (int)lockFlg;
entity.memo = ExCast.zCStr(dt.DefaultView[0]["MEMO"]);
#endregion
}
else
{
entity = null;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetSupplier", ex);
entity = new EntitySupplier();
entity.MESSAGE = CLASS_NM + ".GetSupplier : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();
}
finally
{
db = null;
}
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Select,
"ID:" + Id.ToString());
return(entity);
}
public string UpdateSupplier(string random, int type, string CustomerId, string Id, EntitySupplier entity)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
string personId = "";
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]);
personId = ExCast.zCStr(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 != "")
{
return(_message);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(認証処理)", ex);
return(CLASS_NM + ".UpdateSupplier : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString());
}
#endregion
#region Field
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = null;
string _Id = "";
#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 + ".UpdateSupplier(DbOpen)", ex);
return(CLASS_NM + ".UpdateSupplier(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region BeginTransaction
try
{
db.ExBeginTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(BeginTransaction)", ex);
return(CLASS_NM + ".UpdateSupplier(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Get Max Master ID
if (type == 1 && (Id == "" || Id == "0"))
{
try
{
DataMasterId.GetMaxMasterId(companyId,
ExCast.zNumZeroNothingFormat(CustomerId),
db,
DataMasterId.geMasterMaxIdKbn.Supplier,
out _Id);
if (_Id == "")
{
return("ID取得に失敗しました。");
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(GetMaxMasterId)", ex);
return(CLASS_NM + ".UpdateSupplier(GetMaxMasterId) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
else
{
_Id = Id;
}
#endregion
#region Insert
if (type == 1)
{
try
{
#region Delete SQL
sb.Length = 0;
sb.Append("DELETE FROM M_SUPPLIER " + Environment.NewLine);
sb.Append(" WHERE DELETE_FLG = 1 " + Environment.NewLine);
sb.Append(" AND COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine);
sb.Append(" AND CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine);
#endregion
db.ExecuteSQL(sb.ToString(), false);
#region Insert SQL
sb.Length = 0;
sb.Append("INSERT INTO M_SUPPLIER " + Environment.NewLine);
sb.Append(" ( COMPANY_ID" + Environment.NewLine);
sb.Append(" , CUSTOMER_ID" + Environment.NewLine);
sb.Append(" , ID" + Environment.NewLine);
sb.Append(" , ID2" + Environment.NewLine);
sb.Append(" , NAME" + Environment.NewLine);
sb.Append(" , KANA" + Environment.NewLine);
sb.Append(" , ABOUT_NAME" + Environment.NewLine);
sb.Append(" , ZIP_CODE" + Environment.NewLine);
sb.Append(" , PREFECTURE_ID" + Environment.NewLine);
sb.Append(" , CITY_ID" + Environment.NewLine);
sb.Append(" , TOWN_ID" + Environment.NewLine);
sb.Append(" , ADRESS_CITY" + Environment.NewLine);
sb.Append(" , ADRESS_TOWN" + Environment.NewLine);
sb.Append(" , ADRESS1" + Environment.NewLine);
sb.Append(" , ADRESS2" + Environment.NewLine);
sb.Append(" , STATION_NAME" + Environment.NewLine);
sb.Append(" , POST_NAME" + Environment.NewLine);
sb.Append(" , PERSON_NAME" + Environment.NewLine);
sb.Append(" , TITLE_ID" + Environment.NewLine);
sb.Append(" , TITLE_NAME" + Environment.NewLine);
sb.Append(" , TEL" + Environment.NewLine);
sb.Append(" , FAX" + Environment.NewLine);
sb.Append(" , MAIL_ADRESS" + Environment.NewLine);
sb.Append(" , MOBILE_TEL" + Environment.NewLine);
sb.Append(" , MOBILE_ADRESS" + Environment.NewLine);
sb.Append(" , URL" + Environment.NewLine);
sb.Append(" , DIVIDE_PERMISSION_ID" + Environment.NewLine);
sb.Append(" , MEMO" + Environment.NewLine);
sb.Append(" , DISPLAY_FLG" + 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(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine); // CUSTOMER_ID
sb.Append(" ," + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(_Id)) + Environment.NewLine); // ID
sb.Append(" ," + ExCast.zIdForNumIndex(_Id) + Environment.NewLine); // ID2
sb.Append(" ," + ExEscape.zRepStr(entity.name) + Environment.NewLine); // NAME
sb.Append(" ," + ExEscape.zRepStr(entity.kana) + Environment.NewLine); // KANA
sb.Append(" ," + ExEscape.zRepStr(entity.about_name) + Environment.NewLine); // ABOUT_NAME
sb.Append(" ," + ExCast.zNullToZero(entity.zip_code_from + entity.zip_code_to) + Environment.NewLine); // ZIP_CODE
sb.Append(" ," + entity.prefecture_id + Environment.NewLine); // PREFECTURE_ID
sb.Append(" ," + entity.city_id + Environment.NewLine); // CITY_ID
sb.Append(" ," + entity.town_id + Environment.NewLine); // TOWN_ID
sb.Append(" ," + ExEscape.zRepStr(entity.adress_city) + Environment.NewLine); // ADRESS_CITY
sb.Append(" ," + ExEscape.zRepStr(entity.adress_town) + Environment.NewLine); // ADRESS_TOWN
sb.Append(" ," + ExEscape.zRepStr(entity.adress1) + Environment.NewLine); // ADRESS1
sb.Append(" ," + ExEscape.zRepStr(entity.adress2) + Environment.NewLine); // ADRESS2
sb.Append(" ," + ExEscape.zRepStr(entity.station_name) + Environment.NewLine); // STATION_NAME
sb.Append(" ," + ExEscape.zRepStr(entity.post_name) + Environment.NewLine); // POST_NAME
sb.Append(" ," + ExEscape.zRepStr(entity.person_name) + Environment.NewLine); // PERSON_NAME
sb.Append(" ," + entity.title_id + Environment.NewLine); // TITLE_ID
sb.Append(" ," + ExEscape.zRepStr(entity.title_name) + Environment.NewLine); // TITLE_NAME
sb.Append(" ," + ExEscape.zRepStr(entity.tel) + Environment.NewLine); // TEL
sb.Append(" ," + ExEscape.zRepStr(entity.fax) + Environment.NewLine); // FAX
sb.Append(" ," + ExEscape.zRepStr(entity.mail_adress) + Environment.NewLine); // MAIL_ADRESS
sb.Append(" ," + ExEscape.zRepStr(entity.mobile_tel) + Environment.NewLine); // MOBILE_TEL
sb.Append(" ," + ExEscape.zRepStr(entity.mobile_adress) + Environment.NewLine); // MOBILE_ADRESS
sb.Append(" ," + ExEscape.zRepStr(entity.url) + Environment.NewLine); // URL
sb.Append(" ," + entity.divide_permission_id + Environment.NewLine); // DIVIDE_PERMISSION_ID
sb.Append(" ," + ExEscape.zRepStr(entity.memo) + Environment.NewLine); // MEMO
sb.Append(" ," + entity.display_division_id + Environment.NewLine); // DISPLAY_FLG
sb.Append(CommonUtl.GetInsSQLCommonColums(CommonUtl.UpdKbn.Ins,
PG_NM,
"M_SUPPLIER",
ExCast.zCInt(personId),
_Id,
ipAdress,
userId));
#endregion
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Insert)", ex);
return(CLASS_NM + ".UpdateSupplier(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region Update
if (type == 0)
{
try
{
#region SQL
sb.Length = 0;
sb.Append("UPDATE M_SUPPLIER " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
0));
sb.Append(" ,NAME = " + ExEscape.zRepStr(entity.name) + Environment.NewLine);
sb.Append(" ,KANA = " + ExEscape.zRepStr(entity.kana) + Environment.NewLine);
sb.Append(" ,ABOUT_NAME = " + ExEscape.zRepStr(entity.about_name) + Environment.NewLine);
sb.Append(" ,ZIP_CODE = " + ExCast.zNullToZero(entity.zip_code_from + entity.zip_code_to) + Environment.NewLine);
sb.Append(" ,PREFECTURE_ID = " + entity.prefecture_id + Environment.NewLine);
sb.Append(" ,CITY_ID = " + entity.city_id + Environment.NewLine);
sb.Append(" ,TOWN_ID = " + entity.town_id + Environment.NewLine);
sb.Append(" ,ADRESS_CITY = " + ExEscape.zRepStr(entity.adress_city) + Environment.NewLine);
sb.Append(" ,ADRESS_TOWN = " + ExEscape.zRepStr(entity.adress_town) + Environment.NewLine);
sb.Append(" ,ADRESS1 = " + ExEscape.zRepStr(entity.adress1) + Environment.NewLine);
sb.Append(" ,ADRESS2 = " + ExEscape.zRepStr(entity.adress2) + Environment.NewLine);
sb.Append(" ,STATION_NAME = " + ExEscape.zRepStr(entity.station_name) + Environment.NewLine);
sb.Append(" ,POST_NAME = " + ExEscape.zRepStr(entity.post_name) + Environment.NewLine);
sb.Append(" ,PERSON_NAME = " + ExEscape.zRepStr(entity.person_name) + Environment.NewLine);
sb.Append(" ,TITLE_ID = " + entity.title_id + Environment.NewLine);
sb.Append(" ,TITLE_NAME = " + ExEscape.zRepStr(entity.title_name) + Environment.NewLine);
sb.Append(" ,TEL = " + ExEscape.zRepStr(entity.tel) + Environment.NewLine);
sb.Append(" ,FAX = " + ExEscape.zRepStr(entity.fax) + Environment.NewLine);
sb.Append(" ,MAIL_ADRESS = " + ExEscape.zRepStr(entity.mail_adress) + Environment.NewLine);
sb.Append(" ,MOBILE_TEL = " + ExEscape.zRepStr(entity.mobile_tel) + Environment.NewLine);
sb.Append(" ,MOBILE_ADRESS = " + ExEscape.zRepStr(entity.mobile_adress) + Environment.NewLine);
sb.Append(" ,URL = " + ExEscape.zRepStr(entity.url) + Environment.NewLine);
sb.Append(" ,DIVIDE_PERMISSION_ID = " + entity.divide_permission_id + Environment.NewLine);
sb.Append(" ,MEMO = " + ExEscape.zRepStr(entity.memo) + Environment.NewLine);
sb.Append(" ,DISPLAY_FLG = " + entity.display_division_id + Environment.NewLine);
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID
sb.Append(" AND CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine);
#endregion
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Update)", ex);
return(CLASS_NM + ".UpdateSupplier(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region Delete
if (type == 2)
{
#region Exist Data
try
{
bool _ret = false;
_ret = DataExists.IsExistDataDouble(db, companyId, "", "T_ESTIMATE_H", "SUPPLIER_ID", ExCast.zNumZeroNothingFormat(Id), "CUSTOMER_ID", ExCast.zNumZeroNothingFormat(CustomerId), CommonUtl.geStrOrNumKbn.String);
if (_ret == true)
{
return("ID : " + Id + " は見積データの納入先に使用されている為、削除できません。");
}
_ret = DataExists.IsExistDataDouble(db, companyId, "", "T_ORDER_H", "SUPPLIER_ID", ExCast.zNumZeroNothingFormat(Id), "CUSTOMER_ID", ExCast.zNumZeroNothingFormat(CustomerId), CommonUtl.geStrOrNumKbn.String);
if (_ret == true)
{
return("ID : " + Id + " は受注データの納入先に使用されている為、削除できません。");
}
_ret = DataExists.IsExistDataDouble(db, companyId, "", "T_SALES_H", "SUPPLIER_ID", ExCast.zNumZeroNothingFormat(Id), "CUSTOMER_ID", ExCast.zNumZeroNothingFormat(CustomerId), CommonUtl.geStrOrNumKbn.String);
if (_ret == true)
{
return("ID : " + Id + " は売上データの納入先に使用されている為、削除できません。");
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Exist Data)", ex);
return(CLASS_NM + ".UpdateSupplier(Exist Data) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Update
try
{
sb.Length = 0;
sb.Append("UPDATE M_SUPPLIER " + Environment.NewLine);
sb.Append(CommonUtl.GetUpdSQLCommonColums(PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId,
1));
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" AND ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(Id)) + Environment.NewLine); // ID
sb.Append(" AND CUSTOMER_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(CustomerId)) + Environment.NewLine);
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Delete)", ex);
return(CLASS_NM + ".UpdateSupplier(Delete) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
}
#endregion
#region PG排他制御
if (type == 0 || type == 2)
{
try
{
DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db);
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(DelLockPg)", ex);
return(CLASS_NM + ".UpdateSupplier(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region CommitTransaction
try
{
db.ExCommitTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(CommitTransaction)", ex);
return(CLASS_NM + ".UpdateSupplier(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Database Close
try
{
db.DbClose();
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(DbClose)", ex);
return(CLASS_NM + ".UpdateSupplier(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,
PG_NM,
DataPgEvidence.geOperationType.Update,
"ID:" + Id.ToString());
break;
case 1:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Insert,
"ID:" + _Id.ToString());
break;
case 2:
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.Delete,
"ID:" + Id.ToString());
break;
default:
break;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSupplier(Add Evidence)", ex);
return(CLASS_NM + ".UpdateSupplier(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Return
if (type == 1 && (Id == "0" || Id == ""))
{
return("Auto Insert success : " + "ID : " + _Id.ToString() + "で登録しました。");
}
else
{
return("");
}
#endregion
}
// 条件句SQL設定
private string GetSQLWhere()
{
string strWhrer = "";
string strWhrerString1 = "";
string strWhrerString2 = "";
#region 入金番号
if (this.utlReceiptNo_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO >= " + ExCast.zCLng(this.utlReceiptNo_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "[入金番号 " + ExEscape.zRepStrNoQuota(this.utlReceiptNo_F.txtID.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "[入金番号 未指定～";
}
if (this.utlReceiptNo_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.NO <= " + ExCast.zCLng(this.utlReceiptNo_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.utlReceiptNo_T.txtID.Text.Trim());
}
else
{
strWhrerString1 += "未指定";
}
#endregion
#region 入金日
if (Common.gWinType == Common.geWinType.ListReceiptMonth)
{
if (this.datReceiptYmd_F.Text.Trim() != "")
{
strWhrer += " AND replace(date_format(T.RECEIPT_YMD , " + ExEscape.SQL_YM + "), '0000/00', '') >= " + ExEscape.zRepStr(this.datReceiptYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [入金年月 " + ExEscape.zRepStrNoQuota(this.datReceiptYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [入金年月 未指定～";
}
if (this.datReceiptYmd_T.Text.Trim() != "")
{
strWhrer += " AND replace(date_format(T.RECEIPT_YMD , " + ExEscape.SQL_YM + "), '0000/00', '') <= " + ExEscape.zRepStr(this.datReceiptYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datReceiptYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
}
else
{
if (this.datReceiptYmd_F.Text.Trim() != "")
{
strWhrer += " AND T.RECEIPT_YMD >= " + ExEscape.zRepStr(this.datReceiptYmd_F.Text.Trim()) + Environment.NewLine;
strWhrerString1 += "] [入金日 " + ExEscape.zRepStrNoQuota(this.datReceiptYmd_F.Text.Trim()) + "～";
}
else
{
strWhrerString1 += "] [入金日 未指定～";
}
if (this.datReceiptYmd_T.Text.Trim() != "")
{
strWhrer += " AND T.RECEIPT_YMD <= " + ExEscape.zRepStr(this.datReceiptYmd_T.Text.Trim()) + Environment.NewLine;
strWhrerString1 += ExEscape.zRepStrNoQuota(this.datReceiptYmd_T.Text.Trim()) + "]";
}
else
{
strWhrerString1 += "未指定]";
}
}
#endregion
#region 入力担当者
if (this.utlPerson_F.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID >= " + ExCast.zCLng(this.utlPerson_F.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += "[入力担当者 " + this.utlPerson_F.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_F.txtNm.Text.Trim()) + "～";
}
else
{
strWhrerString2 += "[入力担当者 未指定～";
}
if (this.utlPerson_T.txtID.Text.Trim() != "")
{
strWhrer += " AND T.PERSON_ID <= " + ExCast.zCLng(this.utlPerson_T.txtID.Text.Trim()) + Environment.NewLine;
strWhrerString2 += this.utlPerson_T.txtID.Text.Trim() + "：" + ExEscape.zRepStrNoQuota(this.utlPerson_T.txtNm.Text.Trim());
}
else
{
strWhrerString2 += "未指定";
}
#endregion
#region 請求先
if (this.utlInvoice.txtID.Text.Trim() != "")
{
strWhrer += " AND T.INVOICE_ID = " + ExEscape.zRepStr(ExCast.zNumZeroNothingFormat(this.utlInvoice.txtID.Text.Trim())) + Environment.NewLine;
strWhrerString2 += "] [請求先 " + ExEscape.zRepStrNoQuota(this.utlInvoice.txtID.Text.Trim()) + "：" + ExEscape.zRepStrNoQuota(this.utlInvoice.txtNm.Text.Trim()) + "]";
}
else
{
strWhrerString2 += "] [請求先 未指定]";
}
#endregion
if (Common.gWinType == Common.geWinType.ListReceiptDay)
{
strWhrer += "<group kbn>1";
}
else if (Common.gWinType == Common.geWinType.ListReceiptMonth)
{
strWhrer += "<group kbn>2";
}
strWhrer = strWhrer.Replace(",", "<<@escape_comma@>>");
return(strWhrer + "WhereString =>" + strWhrerString1 + ";" + strWhrerString2);
}
public string UpdateStockInventory(string random, int type, string ymd, List <EntityStockInventory> entity)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
string personId = "";
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]);
personId = ExCast.zCStr(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 != "")
{
return(_message);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(認証処理)", ex);
return(CLASS_NM + ".UpdateStockInventory : 認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString());
}
#endregion
#region Field
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = null;
string _Id = "";
int _classKbn = 0;
long rec_cnt = 0;
string str_message = "";
EntityInOutDeliveryH _entityInOutDeliveryH = new EntityInOutDeliveryH();
List <EntityInOutDeliveryD> _entityInOutDeliveryListD_Plus = new List <EntityInOutDeliveryD>();
List <EntityInOutDeliveryD> _entityInOutDeliveryListD_Minus = new List <EntityInOutDeliveryD>();
#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 + ".UpdateStockInventory(DbOpen)", ex);
return(CLASS_NM + ".UpdateStockInventory(DbOpen) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region BeginTransaction
try
{
db.ExBeginTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(BeginTransaction)", ex);
return(CLASS_NM + ".UpdateStockInventory(BeginTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Update
if (type == 0)
{
try
{
for (int i = 0; i <= entity.Count - 1; i++)
{
if (entity[i].exec_flg == true && entity[i].diff_number != 0)
{
#region Update Commodity Inventory
try
{
DataCommodityInventory.UpdCommodityInventory(companyId,
groupId,
db,
ExCast.zNumZeroNothingFormat(entity[i].commodity_id),
entity[i].diff_number * -1,
PG_NM,
ExCast.zCInt(personId),
ipAdress,
userId);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSales(Update Commodity Inventory)", ex);
return("UpdateSales(Update Commodity Inventory) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Set Entity InOutDelivery
rec_cnt += 1;
EntityInOutDeliveryD _entityInOutDeliveryD = new EntityInOutDeliveryD();
_entityInOutDeliveryD.rec_no = rec_cnt;
_entityInOutDeliveryD.commodity_id = entity[i].commodity_id;
_entityInOutDeliveryD.commodity_name = entity[i].commodity_name;
_entityInOutDeliveryD.unit_id = 0;
_entityInOutDeliveryD.enter_number = 0;
_entityInOutDeliveryD.case_number = 0;
if (entity[i].diff_number > 0)
{
_entityInOutDeliveryD.number = entity[i].diff_number;
_entityInOutDeliveryListD_Minus.Add(_entityInOutDeliveryD);
}
else
{
_entityInOutDeliveryD.number = entity[i].diff_number * -1;
_entityInOutDeliveryListD_Plus.Add(_entityInOutDeliveryD);
}
#endregion
}
}
#region Update InOutDelivery
try
{
svcInOutDelivery _svcInOutDelivery = new svcInOutDelivery();
if (_entityInOutDeliveryListD_Minus.Count > 0)
{
_entityInOutDeliveryH.in_out_delivery_ymd = ymd;
_entityInOutDeliveryH.in_out_delivery_kbn = 2; // 入出庫区分：出庫
_entityInOutDeliveryH.in_out_delivery_proc_kbn = 4; // 入出庫処理区分：棚卸
_entityInOutDeliveryH.in_out_delivery_to_kbn = 1; // 入出庫先区分：グループ
_entityInOutDeliveryH.update_person_id = ExCast.zCInt(personId);
_entityInOutDeliveryH.group_id_to = groupId;
for (int i = 0; i <= _entityInOutDeliveryListD_Minus.Count - 1; i++)
{
_entityInOutDeliveryH.sum_enter_number += _entityInOutDeliveryListD_Minus[i].enter_number;
_entityInOutDeliveryH.sum_case_number += _entityInOutDeliveryListD_Minus[i].case_number;
_entityInOutDeliveryH.sum_number += _entityInOutDeliveryListD_Minus[i].number;
}
// random
// update type 1:Insert
// procKbn 4:棚卸
// InOutDeliveryNo 入出庫番号
// CauseNo 元伝票番号
str_message = _svcInOutDelivery.UpdateInOutDeliveryExcExc(random,
1,
4,
0,
0,
_entityInOutDeliveryH,
_entityInOutDeliveryListD_Minus,
null,
null);
if (str_message.IndexOf("Auto Insert success : ") == -1 && !string.IsNullOrEmpty(str_message))
{
return("UpdateStockInventory(Update InOutDelivery) : " + str_message);
}
}
_svcInOutDelivery = new svcInOutDelivery();
_entityInOutDeliveryH = null;
_entityInOutDeliveryH = new EntityInOutDeliveryH();
if (_entityInOutDeliveryListD_Plus.Count > 0)
{
_entityInOutDeliveryH.in_out_delivery_ymd = ymd;
_entityInOutDeliveryH.in_out_delivery_kbn = 1; // 入出庫区分：入庫
_entityInOutDeliveryH.in_out_delivery_proc_kbn = 4; // 入出庫処理区分：棚卸
_entityInOutDeliveryH.in_out_delivery_to_kbn = 1; // 入出庫先区分：グループ
_entityInOutDeliveryH.update_person_id = ExCast.zCInt(personId);
_entityInOutDeliveryH.group_id_to = groupId;
for (int i = 0; i <= _entityInOutDeliveryListD_Plus.Count - 1; i++)
{
_entityInOutDeliveryH.sum_enter_number += _entityInOutDeliveryListD_Plus[i].enter_number;
_entityInOutDeliveryH.sum_case_number += _entityInOutDeliveryListD_Plus[i].case_number;
_entityInOutDeliveryH.sum_number += _entityInOutDeliveryListD_Plus[i].number;
}
// random
// update type 1:Insert
// procKbn 4:棚卸
// InOutDeliveryNo 入出庫番号
// CauseNo 元伝票番号
str_message = _svcInOutDelivery.UpdateInOutDeliveryExcExc(random,
1,
4,
0,
0,
_entityInOutDeliveryH,
_entityInOutDeliveryListD_Plus,
null,
null);
if (str_message.IndexOf("Auto Insert success : ") == -1 && !string.IsNullOrEmpty(str_message))
{
return("UpdateStockInventory(Update InOutDelivery) : " + str_message);
}
}
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(Update InOutDelivery)", ex);
return("UpdateStockInventory(Update InOutDelivery) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(Insert)", ex);
return(CLASS_NM + ".UpdateStockInventory(Insert) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
}
#endregion
#region PG排他制御
//try
//{
// DataPgLock.DelLockPg(companyId, userId, PG_NM, "", ipAdress, false, db);
//}
//catch (Exception ex)
//{
// db.ExRollbackTransaction();
// CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(DelLockPg)", ex);
// return CLASS_NM + ".UpdateStockInventory(DelLockPg) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message;
//}
#endregion
#region CommitTransaction
try
{
db.ExCommitTransaction();
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(CommitTransaction)", ex);
return(CLASS_NM + ".UpdateStockInventory(CommitTransaction) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
#region Database Close
try
{
db.DbClose();
}
catch (Exception ex)
{
db.ExRollbackTransaction();
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(DbClose)", ex);
return(CLASS_NM + ".UpdateStockInventory(DbClose) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
finally
{
db = null;
}
#endregion
#region Add Evidence
try
{
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
PG_NM,
DataPgEvidence.geOperationType.DeleteAndInsert,
"");
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateStockInventory(Add Evidence)", ex);
return(CLASS_NM + ".UpdateStockInventory(Add Evidence) : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message);
}
#endregion
return("");
}
private void SetBinding()
{
bool is_null = false;
if (_entity == null)
{
_entity = new EntitySupplier();
is_null = true;
}
// マスタコントロールPropertyChanged
_entity.PropertyChanged += this.utlCustomer.MstID_Changed;
_entity.PropertyChanged += this.utlZip.MstID_Changed;
NumberConverter nmConvDecm0 = new NumberConverter();
#region Bind
string _customerId = ExCast.zNumZeroNothingFormat(this.utlCustomer.txtID.Text.Trim());
string _customerNm = this.utlCustomer.txtNm.Text.Trim();
// バインド
Binding BindingCustomerId = new Binding("_customer_id");
BindingCustomerId.Mode = BindingMode.TwoWay;
BindingCustomerId.Source = _entity;
this.utlCustomer.txtID.SetBinding(TextBox.TextProperty, BindingCustomerId);
this.utlID.txtID2.SetBinding(TextBox.TextProperty, BindingCustomerId);
Binding BindingCustomerName = new Binding("_customer_nm");
BindingCustomerName.Mode = BindingMode.TwoWay;
BindingCustomerName.Source = _entity;
this.utlCustomer.txtNm.SetBinding(TextBox.TextProperty, BindingCustomerName);
if (is_null == false)
{
this.utlCustomer.txtID.Text = _customerId;
this.utlCustomer.txtNm.Text = _customerNm;
}
Binding BindingName = new Binding("_name");
BindingName.Mode = BindingMode.TwoWay;
BindingName.Source = _entity;
this.txtName.SetBinding(TextBox.TextProperty, BindingName);
Binding BindingKana = new Binding("_kana");
BindingKana.Mode = BindingMode.TwoWay;
BindingKana.Source = _entity;
this.txtKana.SetBinding(TextBox.TextProperty, BindingKana);
Binding BindingAboutName = new Binding("_about_name");
BindingAboutName.Mode = BindingMode.TwoWay;
BindingAboutName.Source = _entity;
this.txtAdoutName.SetBinding(TextBox.TextProperty, BindingAboutName);
Binding BindingZipCodeFrom = new Binding("_zip_code_from");
BindingZipCodeFrom.Mode = BindingMode.TwoWay;
BindingZipCodeFrom.Source = _entity;
this.utlZip.txtZipNo1.SetBinding(TextBox.TextProperty, BindingZipCodeFrom);
Binding BindingZipCodeTo = new Binding("_zip_code_to");
BindingZipCodeTo.Mode = BindingMode.TwoWay;
BindingZipCodeTo.Source = _entity;
this.utlZip.txtZipNo2.SetBinding(TextBox.TextProperty, BindingZipCodeTo);
this.utlZip.is_zip_from_first_flg = true;
this.utlZip.is_zip_to_first_flg = true;
Binding BindingAdress1 = new Binding("_adress1");
BindingAdress1.Mode = BindingMode.TwoWay;
BindingAdress1.Source = _entity;
this.utlZip.SetBinding(Utl_Zip.UserControlAdress1Property, BindingAdress1);
Binding BindingAdress2 = new Binding("_adress2");
BindingAdress2.Mode = BindingMode.TwoWay;
BindingAdress2.Source = _entity;
this.utlZip.SetBinding(Utl_Zip.UserControlAdress2Property, BindingAdress2);
Binding BindingStationName = new Binding("_station_name");
BindingStationName.Mode = BindingMode.TwoWay;
BindingStationName.Source = _entity;
this.txtStationName.SetBinding(TextBox.TextProperty, BindingStationName);
Binding BindingPostName = new Binding("_post_name");
BindingPostName.Mode = BindingMode.TwoWay;
BindingPostName.Source = _entity;
this.txtPostName.SetBinding(TextBox.TextProperty, BindingPostName);
Binding BindingPersonName = new Binding("_person_name");
BindingPersonName.Mode = BindingMode.TwoWay;
BindingPersonName.Source = _entity;
this.txtPersonName.SetBinding(TextBox.TextProperty, BindingPersonName);
Binding BindingTitleId = new Binding("_title_id");
BindingTitleId.Mode = BindingMode.TwoWay;
BindingTitleId.Source = _entity;
this.utlTitle.txtID.SetBinding(TextBox.TextProperty, BindingTitleId);
Binding BindingTitleName = new Binding("_title_name");
BindingTitleName.Mode = BindingMode.TwoWay;
BindingTitleName.Source = _entity;
this.utlTitle.txtNm.SetBinding(TextBox.TextProperty, BindingTitleName);
Binding BindingTel = new Binding("_tel");
BindingTel.Mode = BindingMode.TwoWay;
BindingTel.Source = _entity;
this.txtTel.SetBinding(TextBox.TextProperty, BindingTel);
Binding BindingFax = new Binding("_fax");
BindingFax.Mode = BindingMode.TwoWay;
BindingFax.Source = _entity;
this.txtFax.SetBinding(TextBox.TextProperty, BindingFax);
Binding BindingMailAdress = new Binding("_mail_adress");
BindingMailAdress.Mode = BindingMode.TwoWay;
BindingMailAdress.Source = _entity;
this.txtMail.SetBinding(TextBox.TextProperty, BindingMailAdress);
Binding BindigDiaplayDivisionId = new Binding("_display_division_id");
BindigDiaplayDivisionId.Mode = BindingMode.TwoWay;
BindigDiaplayDivisionId.Source = _entity;
this.utlDisplay.txtID.SetBinding(TextBox.TextProperty, BindigDiaplayDivisionId);
Binding BindigDiaplayDivisionNm = new Binding("_display_division_nm");
BindigDiaplayDivisionNm.Mode = BindingMode.TwoWay;
BindigDiaplayDivisionNm.Source = _entity;
this.utlDisplay.txtNm.SetBinding(TextBox.TextProperty, BindigDiaplayDivisionNm);
Binding BindigMemo = new Binding("_memo");
BindigMemo.Mode = BindingMode.TwoWay;
BindigMemo.Source = _entity;
this.txtMemo.SetBinding(TextBox.TextProperty, BindigMemo);
#endregion
if (ExCast.IsNumeric(this.utlID.txtID.Text.Trim()))
{
this.utlID.txtID.SetZeroToNullString();
}
this.utlID.txtID.FormatToID();
this.utlTitle.txtID.SetZeroToNullString();
this.utlCustomer.txtID.SetZeroToNullString();
this.utlCustomer.txtID.FormatToID();
if (ExCast.zCInt(_entity._id) == 0)
{
_entity._divide_permission_id = 2;
_entity._display_division_id = 1;
}
}