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()
{
if (_entityH == null)
{
_entityH = new EntityInOutDeliveryH();
}
if (_entityListD == null)
{
_entityListD = new ObservableCollection<EntityInOutDeliveryD>();
}
// マスタコントロールPropertyChanged
_entityH.PropertyChanged += this.utlCompanyGroup.MstID_Changed;
_entityH.PropertyChanged += this.utlCustomer.MstID_Changed;
_entityH.PropertyChanged += this.utlPurchase.MstID_Changed;
_entityH.PropertyChanged += this.utlPerson.MstID_Changed;
_entityH.PropertyChanged += this._PropertyChanged;
this.utlCustomer.ParentData = _entityH;
this.utlPurchase.ParentData = _entityH;
this.utlPerson.ParentData = _entityH;
NumberConverter nmConvDecm0 = new NumberConverter();
NumberConverter nmConvDecm2 = new NumberConverter();
nmConvDecm2.DecimalPlaces = 2;
#region Bind
// バインド
Binding BindingInOutDeliveryYmd = new Binding("_in_out_delivery_ymd");
BindingInOutDeliveryYmd.Mode = BindingMode.TwoWay;
BindingInOutDeliveryYmd.Source = _entityH;
this.datInOutDeliveryYmd.SetBinding(DatePicker.SelectedDateProperty, BindingInOutDeliveryYmd);
if (string.IsNullOrEmpty(_entityH._in_out_delivery_ymd))
{
_entityH._in_out_delivery_ymd = DateTime.Now.ToString("yyyy/MM/dd");
}
Binding BindingInpPersonID = new Binding("_update_person_id");
BindingInpPersonID.Mode = BindingMode.TwoWay;
BindingInpPersonID.Source = _entityH;
this.utlPerson.txtID.SetBinding(TextBox.TextProperty, BindingInpPersonID);
Binding BindingInpPersonName = new Binding("_update_person_nm");
BindingInpPersonName.Mode = BindingMode.TwoWay;
BindingInpPersonName.Source = _entityH;
this.utlPerson.txtNm.SetBinding(TextBox.TextProperty, BindingInpPersonName);
if (_entityH._update_person_id == 0)
{
// デフォルト担当の設定
this.utlPerson.txtID.Text = Common.gintDefaultPersonId.ToString();
_entityH._update_person_id = Common.gintDefaultPersonId;
this.utlPerson.MstID_Changed(null, new PropertyChangedEventArgs("_update_person_id"));
}
Binding BindingInOutDeliveryKbnId = new Binding("_in_out_delivery_kbn");
BindingInOutDeliveryKbnId.Mode = BindingMode.TwoWay;
BindingInOutDeliveryKbnId.Source = _entityH;
this.utlInOutDeliveryKbn.txtID.SetBinding(TextBox.TextProperty, BindingInOutDeliveryKbnId);
Binding BindingInOutDeliveryKbnName = new Binding("_in_out_delivery_kbn_nm");
BindingInOutDeliveryKbnName.Mode = BindingMode.TwoWay;
BindingInOutDeliveryKbnName.Source = _entityH;
this.utlInOutDeliveryKbn.txtNm.SetBinding(TextBox.TextProperty, BindingInOutDeliveryKbnName);
Binding BindingInOutDeliveryToKbnId = new Binding("_in_out_delivery_to_kbn");
BindingInOutDeliveryToKbnId.Mode = BindingMode.TwoWay;
BindingInOutDeliveryToKbnId.Source = _entityH;
this.utlInOutDeliveryToKbn.txtID.SetBinding(TextBox.TextProperty, BindingInOutDeliveryToKbnId);
Binding BindingInOutDeliveryToKbnName = new Binding("_in_out_delivery_to_kbn_nm");
BindingInOutDeliveryToKbnName.Mode = BindingMode.TwoWay;
BindingInOutDeliveryToKbnName.Source = _entityH;
this.utlInOutDeliveryToKbn.txtNm.SetBinding(TextBox.TextProperty, BindingInOutDeliveryToKbnName);
Binding BindingCompanyGroupId = new Binding("_group_id_to");
BindingCompanyGroupId.Mode = BindingMode.TwoWay;
BindingCompanyGroupId.Source = _entityH;
this.utlCompanyGroup.txtID.SetBinding(TextBox.TextProperty, BindingCompanyGroupId);
Binding BindingCompanyGroupName = new Binding("_group_id_to_nm");
BindingCompanyGroupName.Mode = BindingMode.TwoWay;
BindingCompanyGroupName.Source = _entityH;
this.utlCompanyGroup.txtNm.SetBinding(TextBox.TextProperty, BindingCompanyGroupName);
Binding BindingCustomeNo = new Binding("_customer_id");
BindingCustomeNo.Mode = BindingMode.TwoWay;
BindingCustomeNo.Source = _entityH;
this.utlCustomer.txtID.SetBinding(TextBox.TextProperty, BindingCustomeNo);
Binding BindingCustomeName = new Binding("_customer_name");
BindingCustomeName.Mode = BindingMode.TwoWay;
BindingCustomeName.Source = _entityH;
this.utlCustomer.txtNm.SetBinding(TextBox.TextProperty, BindingCustomeName);
Binding BindingPurchaseId = new Binding("_purchase_id");
BindingPurchaseId.Mode = BindingMode.TwoWay;
BindingPurchaseId.Source = _entityH;
this.utlPurchase.txtID.SetBinding(TextBox.TextProperty, BindingPurchaseId);
Binding BindingPurchaseName = new Binding("_purchase_name");
BindingPurchaseName.Mode = BindingMode.TwoWay;
BindingPurchaseName.Source = _entityH;
this.utlPurchase.txtNm.SetBinding(TextBox.TextProperty, BindingPurchaseName);
Binding BindingMemo = new Binding("_memo");
BindingMemo.Mode = BindingMode.TwoWay;
BindingMemo.Source = _entityH;
this.txtMemo.SetBinding(TextBox.TextProperty, BindingMemo);
// 入数計
Binding BindingEnterNumber = new Binding("_sum_enter_number");
BindingEnterNumber.Mode = BindingMode.TwoWay;
BindingEnterNumber.Source = _entityH;
BindingEnterNumber.Converter = nmConvDecm0;
this.txtEnterNumber.SetBinding(TextBox.TextProperty, BindingEnterNumber);
// ケース数計
Binding BindingCaseNumber = new Binding("_sum_case_number");
BindingCaseNumber.Mode = BindingMode.TwoWay;
BindingCaseNumber.Source = _entityH;
BindingCaseNumber.Converter = nmConvDecm0;
this.txtCaseNumber.SetBinding(TextBox.TextProperty, BindingCaseNumber);
// 数量計
Binding BindingNumber = new Binding("_sum_number");
BindingNumber.Mode = BindingMode.TwoWay;
BindingNumber.Source = _entityH;
BindingNumber.Converter = nmConvDecm2;
this.txtNumber.SetBinding(TextBox.TextProperty, BindingNumber);
#endregion
this.utlCustomer.txtID.SetZeroToNullString();
this.utlPurchase.txtID.SetZeroToNullString();
this.utlCompanyGroup.txtID.SetZeroToNullString();
this.utlPerson.txtID.SetZeroToNullString();
}
// データ取得コールバック呼出
public override void DataSelect(int intKbn, object objList)
{
switch ((ExWebService.geWebServiceCallKbn)intKbn)
{
#region 入出庫
// 入出庫ヘッダ
case _GetHeadWebServiceCallKbn:
// 更新
if (objList != null)
{
_entityH = (EntityInOutDeliveryH)objList;
// エラー発生時
if (_entityH._message != "" && _entityH._message != null)
{
webService.ProcessingDlgClose();
this.utlNo.txtID.Text = "";
return;
}
switch (_entityH._in_out_delivery_proc_kbn)
{
case 2:
webService.ProcessingDlgClose();
ExMessageBox.Show("売上計上分の為、修正できません。");
this.utlNo.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlNo, 10);
return;
case 3:
webService.ProcessingDlgClose();
ExMessageBox.Show("仕入計上分の為、修正できません。");
this.utlNo.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlNo, 10);
return;
}
// バインド反映
SetBinding();
// 明細データ取得
GetDetailData(_entityH._id);
}
// 新規
else
{
//// 明細追加
//this.btnF7_Click(null, null);
//this.dg.ItemsSource = _entityListD;
//webService.ProcessingDlgClose();
//this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
//this.utlNo.txtID_IsReadOnly = true;
webService.ProcessingDlgClose();
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
this.utlNo.txtID_IsReadOnly = false;
}
ExBackgroundWorker.DoWork_Focus(this.datInOutDeliveryYmd, 10);
break;
// 入出庫明細
case _GetDetailWebServiceCallKbn:
// 2回設定がかかりエラーになる為
try
{
this.dg.ItemsSource = null;
}
catch
{
return;
}
if (objList != null)
{
_entityListD = (ObservableCollection<EntityInOutDeliveryD>)objList;
}
else
{
_entityListD = null;
}
// 明細追加
this.btnF7_Click(null, null);
// 明細再計算
DataDetail.IsCalcPrice = false;
DataDetail.ReCalcDetail(_entityH, _entityListD);
DataDetail.IsCalcPrice = true;
this.dg.ItemsSource = _entityListD;
// 前回情報保持
ConvertBeforeData(_entityH, _entityListD, _before_entityH, _before_entityListD);
if (_entityH._lock_flg == 0)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Sel;
}
ExBackgroundWorker.DoWork_Focus(this.datInOutDeliveryYmd, 10);
this.utlNo.txtID_IsReadOnly = true;
//this.utlNo.IsEnabled = false;
break;
#endregion
default:
break;
}
}
// F2ボタン(クリア) クリック
public override void btnF2_Click(object sender, RoutedEventArgs e)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Init;
// 先頭選択
this.dg.SelectedFirst();
// ヘッダ初期化
_entityH = null;
SetBinding();
// 明細初期化
_entityListD = null;
_entityListD = new ObservableCollection<EntityInOutDeliveryD>();
// 明細追加
Common.gblnDesynchronizeLock = false;
this.btnF7_Click(null, null);
this.dg.ItemsSource = _entityListD;
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Init;
this.utlNo.txtID_IsReadOnly = false;
//this.utlNo.IsEnabled = true;
this.utlNo.txtID.Text = "";
ExBackgroundWorker.DoWork_Focus(this.utlNo.txtID, 10);
// ロック解除
DataPgLock.gLockPg(PG_NM, "", (int)DataPgLock.geLockType.UnLock);
}
private void ConvertBeforeData(EntityInOutDeliveryH _prm_entityH,
ObservableCollection<EntityInOutDeliveryD> _prm_entityListD,
EntityInOutDeliveryH _prm_before_entityH,
ObservableCollection<EntityInOutDeliveryD> _prm_before_entityListD)
{
#region Set Entity Detail
_prm_before_entityListD.Clear();
for (int i = 0; i <= _prm_entityListD.Count - 1; i++)
{
EntityInOutDeliveryD _entityD = new EntityInOutDeliveryD();
_entityD._id = _prm_entityListD[i]._id;
_entityD._rec_no = _prm_entityListD[i]._rec_no;
//_entityD._breakdown_id = _prm_entityListD[i]._breakdown_id;
//_entityD._breakdown_nm = _prm_entityListD[i]._breakdown_nm;
//_entityD._deliver_division_id = _prm_entityListD[i]._deliver_division_id;
//_entityD._deliver_division_nm = _prm_entityListD[i]._deliver_division_nm;
_entityD._commodity_id = _prm_entityListD[i]._commodity_id;
_entityD._commodity_name = _prm_entityListD[i]._commodity_name;
_entityD._unit_id = _prm_entityListD[i]._unit_id;
_entityD._unit_nm = _prm_entityListD[i]._unit_nm;
_entityD._enter_number = _prm_entityListD[i]._enter_number;
_entityD._case_number = _prm_entityListD[i]._case_number;
_entityD._number = _prm_entityListD[i]._number;
//_entityD._unit_price = _prm_entityListD[i]._unit_price;
//_entityD._sales_cost = _prm_entityListD[i]._sales_cost;
//_entityD._tax = _prm_entityListD[i]._tax;
//_entityD._no_tax_price = _prm_entityListD[i]._no_tax_price;
//_entityD._price = _prm_entityListD[i]._price;
//_entityD._profits = _prm_entityListD[i]._profits;
//_entityD._profits_percent = _prm_entityListD[i]._profits_percent;
//_entityD._tax_division_id = _prm_entityListD[i]._tax_division_id;
//_entityD._tax_division_nm = _prm_entityListD[i]._tax_division_nm;
//_entityD._tax_percent = _prm_entityListD[i]._tax_percent;
_entityD._inventory_management_division_id = _prm_entityListD[i]._inventory_management_division_id;
_entityD._inventory_number = _prm_entityListD[i]._inventory_number;
//_entityD._retail_price_skip_tax = _prm_entityListD[i]._retail_price_skip_tax;
//_entityD._retail_price_before_tax = _prm_entityListD[i]._retail_price_before_tax;
//_entityD._sales_unit_price_skip_tax = _prm_entityListD[i]._sales_unit_price_skip_tax;
//_entityD._sales_unit_price_before_tax = _prm_entityListD[i]._sales_unit_price_before_tax;
//_entityD._sales_cost_price_skip_tax = _prm_entityListD[i]._sales_cost_price_skip_tax;
//_entityD._sales_cost_price_before_tax = _prm_entityListD[i]._sales_cost_price_before_tax;
_entityD._number_decimal_digit = _prm_entityListD[i]._number_decimal_digit;
//_entityD._unit_decimal_digit = _prm_entityListD[i]._unit_decimal_digit;
//_entityD._order_id = _prm_entityListD[i]._order_id;
//_entityD._order_number = _prm_entityListD[i]._order_number;
//_entityD._order_stay_number = _prm_entityListD[i]._order_stay_number;
_entityD._memo = _prm_entityListD[i]._memo;
_entityD._lock_flg = _prm_entityListD[i]._lock_flg;
_entityD._message = _prm_entityListD[i]._message;
_prm_before_entityListD.Add(_entityD);
}
#endregion
#region Set Entity Head
_prm_before_entityH._id = _prm_entityH._id;
_prm_before_entityH._no = _prm_entityH._no;
//_prm_before_entityH._red_before_no = _prm_entityH._red_before_no;
//_prm_before_entityH._order_no = _prm_entityH._order_no;
//_prm_before_entityH._estimateno = _prm_entityH._estimateno;
_prm_before_entityH._in_out_delivery_ymd = _prm_entityH._in_out_delivery_ymd;
_prm_before_entityH._in_out_delivery_kbn = _prm_entityH._in_out_delivery_kbn;
_prm_before_entityH._in_out_delivery_kbn_nm = _prm_entityH._in_out_delivery_kbn_nm;
_prm_before_entityH._in_out_delivery_to_kbn = _prm_entityH._in_out_delivery_to_kbn;
_prm_before_entityH._in_out_delivery_to_kbn_nm = _prm_entityH._in_out_delivery_to_kbn_nm;
_prm_before_entityH._in_out_delivery_proc_kbn = _prm_entityH._in_out_delivery_proc_kbn;
_prm_before_entityH._in_out_delivery_proc_kbn_nm = _prm_entityH._in_out_delivery_proc_kbn_nm;
_prm_before_entityH._cause_no = _prm_entityH._cause_no;
_prm_before_entityH._group_id_to = _prm_entityH._group_id_to;
_prm_before_entityH._group_id_to_nm = _prm_entityH._group_id_to_nm;
_prm_before_entityH._customer_id = _prm_entityH._customer_id;
_prm_before_entityH._customer_name = _prm_entityH._customer_name;
_prm_before_entityH._purchase_id = _prm_entityH._purchase_id;
_prm_before_entityH._purchase_name = _prm_entityH._purchase_name;
//_prm_before_entityH._business_division_id = _prm_entityH._business_division_id;
//_prm_before_entityH._business_division_name = _prm_entityH._business_division_name;
//_prm_before_entityH._supplier_id = _prm_entityH._supplier_id;
//_prm_before_entityH._supplier_name = _prm_entityH._supplier_name;
//_prm_before_entityH._supply_ymd = _prm_entityH._supply_ymd;
_prm_before_entityH._sum_enter_number = _prm_entityH._sum_enter_number;
_prm_before_entityH._sum_case_number = _prm_entityH._sum_case_number;
_prm_before_entityH._sum_number = _prm_entityH._sum_number;
//_prm_before_entityH._sum_unit_price = _prm_entityH._sum_unit_price;
//_prm_before_entityH._sum_sales_cost = _prm_entityH._sum_sales_cost;
//_prm_before_entityH._sum_tax = _prm_entityH._sum_tax;
//_prm_before_entityH._sum_no_tax_price = _prm_entityH._sum_no_tax_price;
//_prm_before_entityH._sum_price = _prm_entityH._sum_price;
//_prm_before_entityH._sum_profits = _prm_entityH._sum_profits;
//_prm_before_entityH._profits_percent = _prm_entityH._profits_percent;
//_prm_before_entityH._invoice_close_flg = _prm_entityH._invoice_close_flg;
_prm_before_entityH._memo = _prm_entityH._memo;
_prm_before_entityH._update_flg = _prm_entityH._update_flg;
_prm_before_entityH._update_person_id = _prm_entityH._update_person_id;
_prm_before_entityH._update_person_nm = _prm_entityH._update_person_nm;
_prm_before_entityH._update_date = _prm_entityH._update_date;
_prm_before_entityH._update_time = _prm_entityH._update_time;
//_prm_before_entityH._price_fraction_proc_id = _prm_entityH._price_fraction_proc_id;
//_prm_before_entityH._tax_fraction_proc_id = _prm_entityH._tax_fraction_proc_id;
//_prm_before_entityH._unit_kind_id = _prm_entityH._unit_kind_id;
//_prm_before_entityH._credit_limit_price = _prm_entityH._credit_limit_price;
//_prm_before_entityH._sales_credit_price = _prm_entityH._sales_credit_price;
//_prm_before_entityH._before_sales_credit_price = _prm_entityH._before_sales_credit_price;
//_prm_before_entityH._invoice_id = _prm_entityH._invoice_id;
//_prm_before_entityH._invoice_name = _prm_entityH._invoice_name;
//_prm_before_entityH._invoice_yyyymmdd = _prm_entityH._invoice_yyyymmdd;
//_prm_before_entityH._credit_rate = _prm_entityH._credit_rate;
//_prm_before_entityH._collect_day = _prm_entityH._collect_day;
//_prm_before_entityH._collect_cycle_id = _prm_entityH._collect_cycle_id;
//_prm_before_entityH._invoice_no = _prm_entityH._invoice_no;
//_prm_before_entityH._invoice_state = _prm_entityH._invoice_state;
//_prm_before_entityH._receipt_receivable_kbn = _prm_entityH._receipt_receivable_kbn;
//_prm_before_entityH._receipt_receivable_kbn_nm = _prm_entityH._receipt_receivable_kbn_nm;
_prm_before_entityH._lock_flg = _prm_entityH._lock_flg;
_prm_before_entityH._message = _prm_entityH._message;
#endregion
}
// For InOutDelivery
public static void CalcSumDetail(EntityInOutDeliveryH entityH, ObservableCollection<EntityInOutDeliveryD> entityD)
{
EntityBaseH entityBaseH = null;
ObservableCollection<EntityBaseD> entityBaseD = null;
ConvertFrom(entityH, ref entityBaseH, entityD, ref entityBaseD);
_CalcSumDetail(ref entityBaseH, ref entityBaseD);
ConvertTo(entityBaseH, ref entityH, entityBaseD, ref entityD);
}
// For InOutDelivery
public static void ReCalcDetail(EntityInOutDeliveryH entityH, ObservableCollection<EntityInOutDeliveryD> entityD)
{
for (int i = 0; i <= entityD.Count - 1; i++)
{
// 明細計算
CalcDetail(i, entityH, entityD);
}
// 明細合計計算
CalcSumDetail(entityH, entityD);
}
// For InOutDelivery
public static void ConvertTo(EntityBaseH entityBaseH, ref EntityInOutDeliveryH entityH, ObservableCollection<EntityBaseD> entityBaseD, ref ObservableCollection<EntityInOutDeliveryD> entityD)
{
for (int i = 0; i <= entityD.Count - 1; i++)
{
#region Set Entity
entityD[i]._id = entityBaseD[i].id;
entityD[i]._rec_no = entityBaseD[i].rec_no;
//entityD[i]._breakdown_id = entityBaseD[i].breakdown_id;
//entityD[i]._breakdown_nm = entityBaseD[i].breakdown_nm;
//entityD[i]._deliver_division_id = entityBaseD[i].deliver_division_id;
//entityD[i]._deliver_division_nm = entityBaseD[i].deliver_division_nm;
entityD[i]._commodity_id = entityBaseD[i].commodity_id;
entityD[i]._commodity_name = entityBaseD[i].commodity_name;
entityD[i]._unit_id = entityBaseD[i].unit_id;
entityD[i]._unit_nm = entityBaseD[i].unit_nm;
entityD[i]._enter_number = entityBaseD[i].enter_number;
entityD[i]._case_number = entityBaseD[i].case_number;
entityD[i]._number = entityBaseD[i].number;
//entityD[i]._order_number = entityBaseD[i].order_number;
//entityD[i]._order_stay_number = entityBaseD[i].order_stay_number;
//entityD[i]._unit_price = entityBaseD[i].unit_price;
//entityD[i]._sales_cost = entityBaseD[i].sales_cost;
//entityD[i]._tax = entityBaseD[i].tax;
//entityD[i]._no_tax_price = entityBaseD[i].no_tax_price;
//entityD[i]._price = entityBaseD[i].price;
//entityD[i]._profits = entityBaseD[i].profits;
//entityD[i]._profits_percent = entityBaseD[i].profits_percent;
//entityD[i]._tax_division_id = entityBaseD[i].tax_division_id;
//entityD[i]._tax_division_nm = entityBaseD[i].tax_division_nm;
//entityD[i]._tax_percent = entityBaseD[i].tax_percent;
entityD[i]._inventory_management_division_id = entityBaseD[i].inventory_management_division_id;
entityD[i]._inventory_number = entityBaseD[i].inventory_number;
//entityD[i]._retail_price_skip_tax = entityBaseD[i].retail_price_skip_tax;
//entityD[i]._retail_price_before_tax = entityBaseD[i].retail_price_before_tax;
//entityD[i]._sales_unit_price_skip_tax = entityBaseD[i].sales_unit_price_skip_tax;
//entityD[i]._sales_unit_price_before_tax = entityBaseD[i].sales_unit_price_before_tax;
//entityD[i]._sales_cost_price_skip_tax = entityBaseD[i].sales_cost_price_skip_tax;
//entityD[i]._sales_cost_price_before_tax = entityBaseD[i].sales_cost_price_before_tax;
entityD[i]._number_decimal_digit = entityBaseD[i].number_decimal_digit;
//entityD[i]._unit_decimal_digit = entityBaseD[i].unit_decimal_digit;
#endregion
}
#region Set Entity Head
//entityH._tax_change_id = entityBaseH.tax_change_id;
//entityH._business_division_id = entityBaseH.business_division_id;
//entityH._price_fraction_proc_id = entityBaseH.price_fraction_proc_id;
//entityH._tax_fraction_proc_id = entityBaseH.tax_fraction_proc_id;
//entityH._unit_kind_id = entityBaseH.unit_kind_id;
entityH._sum_enter_number = entityBaseH.sum_enter_number;
entityH._sum_case_number = entityBaseH.sum_case_number;
entityH._sum_number = entityBaseH.sum_number;
//entityH._sum_unit_price = entityBaseH.sum_unit_price;
//entityH._sum_sales_cost = entityBaseH.sum_sales_cost;
//entityH._sum_tax = entityBaseH.sum_tax;
//entityH._sum_no_tax_price = entityBaseH.sum_no_tax_price;
//entityH._sum_price = entityBaseH.sum_price;
//entityH._sum_profits = entityBaseH.sum_profits;
//entityH._profits_percent = entityBaseH.profits_percent;
//entityH._credit_rate = entityBaseH.credit_rate;
#endregion
}
// For InOutDelivery
public static void CalcDetailNumber(int i, EntityInOutDeliveryH entityH, ObservableCollection<EntityInOutDeliveryD> entityD)
{
EntityBaseH entityBaseH = null;
ObservableCollection<EntityBaseD> entityBaseD = null;
ConvertFrom(entityH, ref entityBaseH, entityD, ref entityBaseD);
_CalcDetailNumber(i, ref entityBaseD);
ConvertTo(entityBaseH, ref entityH, entityBaseD, ref entityD);
// 明細計算
CalcDetail(i, entityH, entityD);
// 明細合計計算
CalcSumDetail(entityH, entityD);
}
// For InOutDelivery
public static void SetCommodityToDetail(int i, EntityInOutDeliveryH entityH, ObservableCollection<EntityInOutDeliveryD> entityD, svcMstData.EntityMstData mst)
{
if (i == -1) return;
svcMstData.EntityMstData _mst = mst;
EntityBaseH entityBaseH = null;
ObservableCollection<EntityBaseD> entityBaseD = null;
ConvertFrom(entityH, ref entityBaseH, entityD, ref entityBaseD);
_SetCommodityToDetail(i, ref entityBaseH, ref entityBaseD, _mst, eKbn.InOutDelivery);
ConvertTo(entityBaseH, ref entityH, entityBaseD, ref entityD);
// 明細計算
CalcDetailNumber(i, entityH, entityD);
CalcDetail(i, entityH, entityD);
}
// For InOutDelivery
public static void ConvertFrom(EntityInOutDeliveryH entityH, ref EntityBaseH entityBaseH, ObservableCollection<EntityInOutDeliveryD> entityD, ref ObservableCollection<EntityBaseD> entityBaseD)
{
entityBaseD = new ObservableCollection<EntityBaseD>();
for (int i = 0; i <= entityD.Count - 1; i++)
{
EntityBaseD _entityBaseD = new EntityBaseD();
#region Set Entity Detail
_entityBaseD.id = entityD[i]._id;
_entityBaseD.rec_no = ExCast.zCInt(entityD[i]._rec_no);
//_entityBaseD.breakdown_id = entityD[i]._breakdown_id;
//_entityBaseD.breakdown_nm = entityD[i]._breakdown_nm;
//_entityBaseD.deliver_division_id = entityD[i]._deliver_division_id;
//_entityBaseD.deliver_division_nm = entityD[i]._deliver_division_nm;
_entityBaseD.commodity_id = entityD[i]._commodity_id;
_entityBaseD.commodity_name = entityD[i]._commodity_name;
_entityBaseD.unit_id = entityD[i]._unit_id;
_entityBaseD.unit_nm = entityD[i]._unit_nm;
_entityBaseD.enter_number = entityD[i]._enter_number;
_entityBaseD.case_number = entityD[i]._case_number;
_entityBaseD.number = entityD[i]._number;
//_entityBaseD.order_number = entityD[i]._purchase_order_number;
//_entityBaseD.order_stay_number = entityD[i]._purchase_order_stay_number;
//_entityBaseD.unit_price = entityD[i]._unit_price;
//_entityBaseD.sales_cost = entityD[i]._sales_cost;
//_entityBaseD.tax = entityD[i]._tax;
//_entityBaseD.no_tax_price = entityD[i]._no_tax_price;
//_entityBaseD.price = entityD[i]._price;
//_entityBaseD.profits = entityD[i]._profits;
//_entityBaseD.profits_percent = entityD[i]._profits_percent;
//_entityBaseD.tax_division_id = entityD[i]._tax_division_id;
//_entityBaseD.tax_division_nm = entityD[i]._tax_division_nm;
//_entityBaseD.tax_percent = entityD[i]._tax_percent;
_entityBaseD.inventory_management_division_id = entityD[i]._inventory_management_division_id;
_entityBaseD.inventory_number = entityD[i]._inventory_number;
//_entityBaseD.retail_price_skip_tax = entityD[i]._retail_price_skip_tax;
//_entityBaseD.retail_price_before_tax = entityD[i]._retail_price_before_tax;
//_entityBaseD.sales_unit_price_skip_tax = entityD[i]._sales_unit_price_skip_tax;
//_entityBaseD.sales_unit_price_before_tax = entityD[i]._sales_unit_price_before_tax;
//_entityBaseD.sales_cost_price_skip_tax = entityD[i]._sales_cost_price_skip_tax;
//_entityBaseD.sales_cost_price_before_tax = entityD[i]._sales_cost_price_before_tax;
//_entityBaseD.purchase_unit_price_skip_tax = entityD[i]._purchase_unit_price_skip_tax;
//_entityBaseD.purchase_unit_price_before_tax = entityD[i]._purchase_unit_price_before_tax;
_entityBaseD.number_decimal_digit = entityD[i]._number_decimal_digit;
//_entityBaseD.unit_decimal_digit = entityD[i]._unit_decimal_digit;
#endregion
entityBaseD.Add(_entityBaseD);
}
entityBaseH = new EntityBaseH();
#region Set Entity Head
//entityBaseH.tax_change_id = entityH._tax_change_id;
//entityBaseH.business_division_id = entityH._business_division_id;
//entityBaseH.price_fraction_proc_id = entityH._price_fraction_proc_id;
//entityBaseH.tax_fraction_proc_id = entityH._tax_fraction_proc_id;
//entityBaseH.unit_kind_id = entityH._unit_kind_id;
entityBaseH.sum_enter_number = entityH._sum_enter_number;
entityBaseH.sum_case_number = entityH._sum_case_number;
entityBaseH.sum_number = entityH._sum_number;
//entityBaseH.sum_unit_price = entityH._sum_unit_price;
//entityBaseH.sum_sales_cost = entityH._sum_sales_cost;
//entityBaseH.sum_tax = entityH._sum_tax;
//entityBaseH.sum_no_tax_price = entityH._sum_no_tax_price;
//entityBaseH.sum_price = entityH._sum_price;
//entityBaseH.sum_profits = entityH._sum_profits;
//entityBaseH.profits_percent = entityH._profits_percent;
//entityBaseH.credit_rate = entityH._credit_rate;
#endregion
}
private void UpdateInOutDelivery(int type, long InOutDeliveryNo, EntityInOutDeliveryH entityH, ObservableCollection<EntityInOutDeliveryD> entityD, EntityInOutDeliveryH before_entityH, ObservableCollection<EntityInOutDeliveryD> before_entityD)
{
try
{
svcInOutDeliveryClient svc = new svcInOutDeliveryClient();
svc.UpdateInOutDeliveryCompleted += new EventHandler<UpdateInOutDeliveryCompletedEventArgs>(this.UpdateInOutDeliveryCompleted);
svc.UpdateInOutDeliveryAsync(Common.gstrSessionString, type, InOutDeliveryNo, entityH, entityD, before_entityH, before_entityD);
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".UpdateInOutDelivery" + Environment.NewLine + ex.ToString(), "エラー確認");
}
}
private void GetInOutDeliveryHCompleted(Object sender, GetInOutDeliveryHCompletedEventArgs e)
{
try
{
objInOutDeliveryH = e.Result;
if (DialogCloseFlg == geDialogCloseFlg.Yes & win != null)
{
win.Close();
win = null;
}
if (objInOutDeliveryH != null)
{
if (objInOutDeliveryH._message != "" && objInOutDeliveryH._message != null)
{
// 認証失敗
ExMessageBox.Show(objInOutDeliveryH._message);
objPerent.DataSelect((int)geWebServiceCallKbn.GetInOutDeliveryListH, (object)objInOutDeliveryH);
}
else
{
// 認証成功
objPerent.DataSelect((int)geWebServiceCallKbn.GetInOutDeliveryListH, (object)objInOutDeliveryH);
}
}
else
{
objPerent.DataSelect((int)geWebServiceCallKbn.GetInOutDeliveryListH, null);
}
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".GetInOutDeliveryHCompleted" + Environment.NewLine + ex.ToString(), "エラー確認");
}
finally
{
if (DialogCloseFlg == geDialogCloseFlg.Yes & win != null)
{
win.Close();
win = null;
}
}
}
private void GetInOutDeliveryH(long InOutDeliveryNoFrom, long InOutDeliveryNoTo)
{
try
{
objInOutDeliveryH = null; // 初期化
svcInOutDeliveryClient svc = new svcInOutDeliveryClient();
svc.GetInOutDeliveryHCompleted += new EventHandler<GetInOutDeliveryHCompletedEventArgs>(this.GetInOutDeliveryHCompleted);
svc.GetInOutDeliveryHAsync(Common.gstrSessionString, InOutDeliveryNoFrom, InOutDeliveryNoTo);
}
catch (Exception ex)
{
this.ProcessingDlgClose();
ExMessageBox.Show(CLASS_NM + ".GetInOutDeliveryH" + Environment.NewLine + ex.ToString(), "エラー確認");
}
}
