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 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 }
public override void RecordAdd() { if (Common.gblnDesynchronizeLock == true) return; if (_entityListD == null) _entityListD = new ObservableCollection<EntityInOutDeliveryD>(); EntityInOutDeliveryD entity = new EntityInOutDeliveryD(); int cnt = 1; if (_entityListD != null) cnt = _entityListD.Count + 1; entity._rec_no = cnt; SetInitCombo(ref entity); // コンボボックス初期選択 _entityListD.Add(entity); dg.SelectedIndex = ExCast.zCInt(entity._rec_no) - 1; dg.Focus(); if (dg.CurrentColumn != null) { dg.ScrollIntoView(entity, dg.Columns[0]); dg.CommitEdit(); dg.CurrentColumn = dg.Columns[0]; dg.BeginEdit(); dg.MoveNextCell(); } // ファンクションキー設定 string _activeCtlName = ""; if (this.activeControl != null) _activeCtlName = ExCast.zCStr(this.activeControl.Name); switch (_activeCtlName) { case "txtGoodsName": case "cboUnit": case "txtEnterNum": case "txtNumber": case "txtCaseNum": case "txtGoodsID": if (this._entityListD.Count > 1) { ExVisualTreeHelper.SetFunctionKeyEnabled("F8", true, this); } else { ExVisualTreeHelper.SetFunctionKeyEnabled("F8", false, this); } break; } }
private void SetInitCombo(ref EntityInOutDeliveryD entityD) { // コンボボックス初期選択 List<string> lst; lst = MeiNameList.GetListMei(MeiNameList.geNameKbn.UNIT_ID); entityD._unit_nm = lst[0]; entityD._unit_id = MeiNameList.GetID(MeiNameList.geNameKbn.UNIT_ID, lst[0]); }