private void btnDownLoad_Click(object sender, RoutedEventArgs e)
{
Button btn = (Button)sender;
string no = btn.Name.Replace("btn", "");
for (int i = 0; i <= _entityList.Count - 1; i++)
{
if (ExCast.zCLng(no) == _entityList[i]._no)
{
string[] prm = new string[4];
prm[0] = _entityList[i]._upload_file_name1;
prm[1] = _entityList[i]._upload_file_path1;
wc = new ExWebClient();
wc.utlParentFKey = null;
wc.FileDownLoad(DataReport.geReportKbn.None, CLASS_NM, prm);
}
}
}
private void searchDlg_Closed(object sender, EventArgs e)
{
Dlg_Copying dlg = (Dlg_Copying)sender;
if (dlg.utlCopying.DialogResult == true)
{
// ロック解除
DataPgLock.gLockPg(PG_NM, ExCast.zCStr(_entity._id), (int)DataPgLock.geLockType.UnLock);
if (dlg.utlCopying.copy_id == "")
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Init;
this.utlID.txtID_IsReadOnly = false;
this.utlID.txtID.Text = "";
}
else
{
if (dlg.utlCopying.ExistsData == true)
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.Upd;
}
else
{
this.utlFunctionKey.gFunctionKeyEnable = Utl_FunctionKey.geFunctionKeyEnable.New;
}
string _id = dlg.utlCopying.copy_id;
if (ExCast.IsNumeric(dlg.utlCopying.copy_id))
{
_id = ExCast.zCDbl(_id).ToString();
_entity._id = ExCast.zCInt(_id);
this.utlID.txtID.Text = _id;
this.utlID.txtID.FormatToID();
}
else
{
_entity._id = ExCast.zCInt(_id);
this.utlID.txtID.Text = _id;
}
this.utlID.txtID_IsReadOnly = true;
ExBackgroundWorker.DoWork_Focus(this.txtName, 10);
}
}
}
// リスト取得コールバック呼出
public override void DataSelect(int intKbn, object objList)
{
if ((ExWebService.geWebServiceCallKbn)intKbn == this.WebServiceCallKbn)
{
if (objList != null)
{
entityList = (ObservableCollection <EntityPaymentCash>)objList;
var records =
(from n in entityList
orderby n.payment_cash_ymd descending, n.no descending
select new { n.no, n.payment_cash_ymd, n.purchase_id, n.purchase_nm, n.sum_price }).Distinct();
this.lst.Clear();
foreach (var rec in records)
{
string _no = ExCast.zFormatForID(rec.no, Common.gintidFigureSlipNo);
lst.Add(new DisplayPaymentCashList(rec.no,
_no,
rec.payment_cash_ymd,
rec.purchase_id,
rec.purchase_nm,
rec.sum_price.ToString("#,##0")));
}
this.dg.Focus();
this.dg.ItemsSource = null;
this.dg.ItemsSource = lst;
if (lst.Count > 0)
{
this.dg.SelectedIndex = 0;
}
ExBackgroundWorker.DoWork_Focus(dg, 10);
}
else
{
entityList = null;
this.lst.Clear();
this.dg.ItemsSource = null;
ExBackgroundWorker.DoWork_Focus(this.datPaymentCashYmd_F, 10);
}
}
}
private void unitPriceDlg_Closed(object sender, EventArgs e)
{
Dlg_UnitPriceSetting unitPriceDlg = (Dlg_UnitPriceSetting)sender;
if (unitPriceDlg.DialogResult == true)
{
if (_entityListD.Count > DataForm.CurrentIndex && DataForm.CurrentIndex != -1)
{
_entityListD[DataForm.CurrentIndex]._unit_price = unitPriceDlg.return_unit_price;
}
}
if (beforeValue != ExCast.zCStr(_entityListD[DataForm.CurrentIndex]._unit_price))
{
DataDetail.CalcDetail(DataForm.CurrentIndex, _entityH, _entityListD);
this.Focus();
_txtUnitPrice.Focus();
_txtUnitPrice = null;
}
}
public override void MstDataSelect(ExWebServiceMst.geWebServiceMstNmCallKbn intKbn, svcMstData.EntityMstData mst)
{
try
{
svcMstData.EntityMstData _mst = null;
_mst = mst;
switch (intKbn)
{
case ExWebServiceMst.geWebServiceMstNmCallKbn.GetCommodity:
if (DataForm.CurrentIndex == -1)
{
return;
}
if (_mst == null)
{
return;
}
// attribute20に選択された行が設定されてくる
if (string.IsNullOrEmpty(_mst.attribute20))
{
// 商品から明細へ
DataDetail.SetCommodityToDetail(DataForm.CurrentIndex, this._entityH, this._entityListD, _mst);
OnFormatAll();
}
else
{
if (_entityListD.Count >= ExCast.zCInt(_mst.attribute20) + 1)
{
// 商品から明細へ
DataDetail.SetCommodityToDetail(ExCast.zCInt(_mst.attribute20), _entityH, _entityListD, _mst);
OnFormatAll();
}
}
break;
}
}
catch
{
}
}
/// <summary>
/// 伝票番号取得
/// </summary>
/// <param name="companyId">会社ID</param>
/// <param name="groupId">グループID</param>
/// <param name="db"></param>
/// <param name="kbn">伝票区分</param>
/// <param name="accountPeriod">会計年</param>
/// <param name="no">伝票番号</param>
/// <param name="id">伝票ID</param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void GetInOutDeliveryNo(string companyId,
string groupId,
ExMySQLData db,
geInOutDeliverySlipKbn kbn,
long cause_no,
ref long _no,
ref long _id)
{
StringBuilder sb;
DataTable dt;
_no = 0;
_id = 0;
try
{
sb = new StringBuilder();
sb.Length = 0;
// 存在確認
sb.Append("SELECT ID " + Environment.NewLine);
sb.Append(" ,NO " + Environment.NewLine);
sb.Append(" FROM T_IN_OUT_DELIVERY_H AS T" + Environment.NewLine);
sb.Append(" WHERE T.DELETE_FLG = 0 " + Environment.NewLine);
sb.Append(" AND T.COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND T.GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND T.IN_OUT_DELIVERY_PROC_KBN = " + (int)kbn + Environment.NewLine);
sb.Append(" AND T.CAUSE_NO = " + cause_no + Environment.NewLine);
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
_no = ExCast.zCLng(dt.DefaultView[0]["NO"]);
_id = ExCast.zCLng(dt.DefaultView[0]["ID"]);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetInOutDeliveryNo", ex);
throw;
}
}
// F11ボタン(印刷) クリック
public override void btnF11_Click(object sender, RoutedEventArgs e)
{
if (ExCast.zCInt(this.utlClass.txtID.Text.Trim()) == 0)
{
ExMessageBox.Show("分類区分を選択して下さい。");
return;
}
if (ExCast.zCInt(this.utlClass.txtID.Text.Trim()) > 3)
{
ExMessageBox.Show("分類区分を適切に入力(選択)して下さい。");
return;
}
switch (ExCast.zCInt(this.utlClass.txtID.Text.Trim()))
{
case 1:
Common.report.utlReport.MstGroupKbn = Class.Data.MstData.geMGroupKbn.CustomerGrouop1;
break;
case 2:
Common.report.utlReport.MstGroupKbn = Class.Data.MstData.geMGroupKbn.CommodityGrouop1;
break;
case 3:
Common.report.utlReport.MstGroupKbn = Class.Data.MstData.geMGroupKbn.PurchaseGrouop1;
break;
default:
ExMessageBox.Show("分類区分を適切に選択して下さい。");
return;
}
Common.report.utlReport.gPageType = Common.gePageType.None;
Common.report.utlReport.gWinMsterType = _WinMsterType;
beforeWinGroupType = Common.gWinGroupType;
Common.gWinGroupType = Common.geWinGroupType.Report;
Common.report.Closed -= reportDlg_Closed;
Common.report.Closed += reportDlg_Closed;
Common.report.Show();
}
private void txtZipNo2_LostFocus(object sender, RoutedEventArgs e)
{
if (this.txtZipNo1.Text.Trim() == "")
{
this.UserControlAdress1 = "";
this.UserControlAdress2 = "";
return;
}
if (this.txtZipNo2.Text.Trim() == "")
{
this.UserControlAdress1 = "";
this.UserControlAdress2 = "";
return;
}
if (Is_Zip_Upd == false)
{
return;
}
string zip1 = this.txtZipNo1.Text.Trim();
if (zip1 != "" && ExCast.IsNumeric(zip1))
{
zip1 = string.Format("{0:000}", ExCast.zCDbl(zip1));
}
string zip2 = this.txtZipNo2.Text.Trim();
if (zip2 != "" && ExCast.IsNumeric(zip2))
{
zip2 = string.Format("{0:0000}", ExCast.zCDbl(zip2));
}
this.txtZipNo1.Text = zip1;
this.txtZipNo2.Text = zip2;
MstData _mstData = new MstData();
_mstData.GetMData(MstData.geMDataKbn.Zip, new string[] { zip1, zip2 }, this);
}
public static string GetAccountPeriod(string accountBeginPeriod, string ymd)
{
if (accountBeginPeriod.Length != 4 || ymd.Length != 10)
{
return("");
}
string _ymd = ymd.Replace("/", "");
string _YYYY = _ymd.Substring(0, 4);
string _MMDD = _ymd.Substring(4, 4);
if (ExCast.zCInt(accountBeginPeriod) > ExCast.zCInt(_MMDD))
{
return((ExCast.zCInt(_YYYY) - 1).ToString());
}
else
{
return(_YYYY);
}
}
// データ追加・更新・削除
private void UpdateData(Common.geUpdateType upd)
{
object[] prm = new object[4];
prm[0] = (int)upd;
if (ExCast.IsNumeric(this.utlID.txtID.Text.Trim()))
{
prm[1] = ExCast.zCLng(this.utlID.txtID.Text.Trim());
}
else
{
prm[1] = this.utlID.txtID.Text.Trim();
}
prm[2] = _entity;
webService.objPerent = this;
webService.CallWebService(_UpdWebServiceCallKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
private static void logOut(string log, Exception ex)
{
string _companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
string _userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
string _now = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss").Replace("i", "");
try
{
using (FileStream fileStream = new FileStream(@"F:\sitesroot\0\log\AppLog.txt", FileMode.Append))
using (Stream streamSync = Stream.Synchronized(fileStream))
using (BinaryWriter writer = new BinaryWriter(streamSync))
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append(_now + " >>>>>>>> log start " + " [COMPANY ID : " + _companyId + "] [USER ID : " + _userId + "] -------------------- " + Environment.NewLine);
sb.Append(_now + " >>>>>>>> " + log + Environment.NewLine);
if (ex != null)
{
sb.Append(_now + " >>>>>>>> " + "--------------- Exception Message --------------------" + Environment.NewLine +
_now + " >>>>>>>> " + ex.Message + Environment.NewLine);
sb.Append(_now + " >>>>>>>> " + "--------------- Exception HelpLink -------------------" + Environment.NewLine +
_now + " >>>>>>>> " + ex.HelpLink + Environment.NewLine);
sb.Append(_now + " >>>>>>>> " + "--------------- Exception Source ---------------------" + Environment.NewLine +
_now + " >>>>>>>> " + ex.Source + Environment.NewLine);
sb.Append(_now + " >>>>>>>> " + "--------------- Exception StackTrace -----------------" + Environment.NewLine +
_now + " >>>>>>>> " + ex.StackTrace + Environment.NewLine);
sb.Append(_now + " >>>>>>>> " + "--------------- Exception TargetSite -----------------" + Environment.NewLine +
_now + " >>>>>>>> " + ex.TargetSite + Environment.NewLine);
sb.Append(_now + " >>>>>>>> " + "------------------------------------------------------" + Environment.NewLine);
}
sb.Append(_now + " >>>>>>>> log end " + " [COMPANY ID : " + _companyId + "] [USER ID : " + _userId + "] -------------------- " + Environment.NewLine + Environment.NewLine);
byte[] bytesData = System.Text.Encoding.GetEncoding("shift_jis").GetBytes(sb.ToString());
writer.Write(bytesData);
writer.Flush();
}
}
catch (Exception e)
{
Debug.Print(ex.Message.ToString());
}
}
public override void MstDataSelect(ExWebServiceMst.geWebServiceMstNmCallKbn intKbn, svcMstData.EntityMstData mst)
{
try
{
svcMstData.EntityMstData _mst = null;
_mst = mst;
switch (intKbn)
{
case ExWebServiceMst.geWebServiceMstNmCallKbn.GetRecieptDivision:
if (DataForm.CurrentIndex == -1)
{
return;
}
if (_mst == null)
{
return;
}
// attribute20に選択された行が設定されてくる
if (string.IsNullOrEmpty(_mst.attribute20))
{
_entityListD[ExCast.zCInt(_mst.attribute20) + 1]._receipt_division_nm = "";
OnFormatAll();
}
else
{
if (_entityListD.Count >= ExCast.zCInt(_mst.attribute20) + 1)
{
_entityListD[ExCast.zCInt(_mst.attribute20)]._receipt_division_nm = mst.name;
OnFormatAll();
}
}
break;
}
}
catch
{
}
}
// 条件句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);
}
/// <summary>
/// 伝票番号取得
/// </summary>
/// <param name="companyId">会社ID</param>
/// <param name="groupId">グループID</param>
/// <param name="db"></param>
/// <param name="kbn">伝票区分</param>
/// <param name="accountPeriod">会計年</param>
/// <param name="no">伝票番号</param>
/// <param name="id">伝票ID</param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static long GetMaxSlipNo(string companyId,
string groupId,
ExMySQLData db,
string tableName,
string columnName)
{
StringBuilder sb;
DataTable dt;
long no = 1;
try
{
sb = new StringBuilder();
sb.Length = 0;
// 存在確認
sb.Append("SELECT MAX(T." + columnName + ") AS MAX_NO " + Environment.NewLine);
sb.Append(" FROM " + tableName + " AS T" + Environment.NewLine);
sb.Append(" WHERE T.COMPANY_ID = " + companyId + Environment.NewLine);
if (groupId != "")
{
sb.Append(" AND T.GROUP_ID = " + groupId + Environment.NewLine);
}
sb.Append(" FOR UPDATE");
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
no = ExCast.zCLng(dt.DefaultView[0]["MAX_NO"]) + 1;
}
return(no);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetMaxSlipNo", ex);
throw;
}
}
private void GetMstData()
{
object[] prm = new object[2];
int id = 0;
for (int i = 0; i <= this._entityUserList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbUser.SelectedValue) == _entityUserList[i].name)
{
id = ExCast.zCInt(_entityUserList[i].attribute1);
}
}
prm[0] = id;
webService.objPerent = this;
webService.CallWebService(_GetWebServiceCallKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
// データ追加・更新・削除
private void UpdateData(Common.geUpdateType upd)
{
object[] prm = new object[3];
prm[0] = (int)upd;
prm[1] = 0;
_entityUpdate._title = this.txtTitle.Text;
for (int i = 0; i <= _entityPersonList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbPerson.SelectedValue) == _entityPersonList[i].name)
{
_entityUpdate._person_id = ExCast.zCInt(_entityPersonList[i].id);
_entityUpdate._d_person_id = ExCast.zCInt(_entityPersonList[i].id);
}
}
if (this.cmbKbn.SelectedValue != null)
{
_entityUpdate._inquiry_division_id = MeiNameList.GetID(MeiNameList.geNameKbn.INQUIRY_DIVISION_ID, ExCast.zCStr(this.cmbKbn.SelectedValue));
}
if (this.cmbLevel.SelectedValue != null)
{
_entityUpdate._inquiry_level_id = MeiNameList.GetID(MeiNameList.geNameKbn.LEVEL_ID, ExCast.zCStr(this.cmbLevel.SelectedValue));
}
_entityUpdate._inquiry_level_state_id = 1; // オープン
_entityUpdate._title = this.txtTitle.Text;
_entityUpdate._content = this.txtContent.Text;
_entityUpdate._rec_no = 1;
_entityUpdate._kbn = 0; // ユーザー
prm[2] = _entityUpdate;
webService.objWindow = this;
webService.CallWebService(ExWebService.geWebServiceCallKbn.UpdateInquiry,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
/// <summary>
/// 最大ID取得
/// </summary>
/// <param name="db"></param>
/// <param name="id">ID</param>
/// <param name="ipAdress"></param>
/// <param name="userId"></param>
public static void GetMaxId(ExMySQLData db,
string tbl_name,
string id_col_name,
out string id)
{
StringBuilder sb;
DataTable dt;
bool exist = false;
try
{
sb = new StringBuilder();
sb.Length = 0;
// 存在確認
sb.Append("SELECT " + id_col_name + " AS MAX_ID " + Environment.NewLine);
sb.Append(" FROM " + tbl_name + Environment.NewLine);
sb.Append(" ORDER BY " + id_col_name + " DESC " + Environment.NewLine);
sb.Append(" LIMIT 0, 1 " + Environment.NewLine);
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
id = (ExCast.zCLng(dt.DefaultView[0]["MAX_ID"]) + 1).ToString();
}
else
{
id = "1";
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetMaxId", ex);
id = "";
throw;
}
}
private void Init()
{
GetPersonList();
txtTitle.Text = _entityList[0]._title;
txtNo.Text = ExCast.zCStr(_entityList[0]._no);
txtKbn.Text = _entityList[0]._inquiry_division_nm;
txtLevel.Text = _entityList[0]._inquiry_level_nm;
txtState.Text = _entityList[0]._inquiry_level_state_nm;
for (int i = 0; i <= _entityList.Count - 1; i++)
{
TextBox txt = new TextBox();
txt.IsReadOnly = true;
txt.AcceptsReturn = true;
txt.HorizontalScrollBarVisibility = ScrollBarVisibility.Auto;
txt.Text += _entityList[i]._d_date_time + Environment.NewLine;
if (_entityList[i]._kbn == 0)
{
// ユーザー時
txt.Text += _entityList[i]._d_person_nm + " 様" + Environment.NewLine;
txt.Background = new SolidColorBrush(Colors.White);
}
else
{
// サポート時
txt.Text += _entityList[i]._support_person_nm + Environment.NewLine;
txt.Background = new SolidColorBrush(Colors.LightGray);
}
txt.Text += "---------------------------------------------------------------------------------------------------------------------" + Environment.NewLine;
txt.Text += _entityList[i]._content + Environment.NewLine;
this.stpHistory.Children.Add(txt);
TextBlock tbk = new TextBlock();
tbk.Height = 5;
this.stpHistory.Children.Add(tbk);
}
}
private void GetMstData()
{
object[] prm = new object[1];
prm[0] = "";
for (int i = 0; i <= _entityUserList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbLoginId.SelectedValue) == _entityUserList[i].id)
{
prm[0] = ExCast.zCInt(_entityUserList[i].attribute1);
}
}
if (ExCast.zCStr(prm[0]) == "")
{
return;
}
webService.objPerent = this;
webService.CallWebService(_GetWebServiceCallKbn,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
public static void UpdateSlipNo(string companyId,
string groupId,
ExMySQLData db,
geSlipKbn kbn,
string accountPeriod,
long no,
long id)
{
StringBuilder sb;
try
{
sb = new StringBuilder();
sb.Append("UPDATE M_SLIP_MANAGEMENT " + Environment.NewLine);
sb.Append(" SET ID = " + id.ToString() + Environment.NewLine);
// 追加時
if (no != 0)
{
sb.Append(" ,NO = " + no.ToString() + Environment.NewLine);
}
sb.Append(" WHERE COMPANY_ID = " + companyId + Environment.NewLine);
sb.Append(" AND GROUP_ID = " + groupId + Environment.NewLine);
sb.Append(" AND SLIP_DIVISION = " + ((int)kbn).ToString() + Environment.NewLine);
sb.Append(" AND YEAR = " + ExCast.zCInt(accountPeriod).ToString() + Environment.NewLine);
sb.Append(" AND DELETE_FLG = 0 " + Environment.NewLine);
db.ExecuteSQL(sb.ToString(), false);
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".UpdateSlipNo", ex);
no = 0;
id = 0;
throw;
}
}
private void txt_LostFocus(object sender, RoutedEventArgs e)
{
Control ctl = (Control)sender;
ExTextBox txt = null;
ExDatePicker dap = null;
ComboBox cmb = null;
int i = beforeSelectedIndex;
switch (ctl.Name)
{
case "txtReceiptDivisionId":
txt = (ExTextBox)sender;
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
MstData _mstData = new MstData();
_mstData.GetMData(MstData.geMDataKbn.RecieptDivision, new string[] { ExCast.zCStr(txt.Text), ExCast.zCStr(i) }, this);
break;
default:
break;
}
}
// データ追加・更新・削除
private void UpdateData(Common.geUpdateType upd)
{
object[] prm = new object[3];
prm[0] = (int)upd;
prm[1] = _entityList[0]._no;
_entityUpdate._no = _entityList[0]._no;
_entityUpdate._company_id = _entityList[0]._company_id;
_entityUpdate._gropu_id = _entityList[0]._gropu_id;
_entityUpdate._person_id = _entityList[0]._person_id;
_entityUpdate._date_time = _entityList[0]._date_time;
_entityUpdate._title = _entityList[0]._title;
_entityUpdate._inquiry_division_id = _entityList[0]._inquiry_division_id;
_entityUpdate._inquiry_level_id = _entityList[0]._inquiry_level_id;
_entityUpdate._inquiry_level_state_id = 2; // 回答待ち
_entityUpdate._rec_no = _entityList[0]._rec_no + 1;
_entityUpdate._kbn = 0; // ユーザー
_entityUpdate._title = this.txtTitle.Text;
_entityUpdate._content = this.txtContent.Text;
for (int i = 0; i <= _entityPersonList.Count - 1; i++)
{
if (ExCast.zCStr(this.cmbPerson.SelectedValue) == _entityPersonList[i].name)
{
_entityUpdate._d_person_id = ExCast.zCInt(_entityPersonList[i].id);
}
}
prm[2] = _entityUpdate;
webService.objWindow = this;
webService.CallWebService(ExWebService.geWebServiceCallKbn.UpdateInquiry,
ExWebService.geDialogDisplayFlg.Yes,
ExWebService.geDialogCloseFlg.Yes,
prm);
}
protected override void OnTextInputUpdate(TextCompositionEventArgs e)
{
try
{
bool flg = InputCheck(e.Text);
if (flg == false)
{
e.Handled = true;
}
// 値セット
switch (InputMode)
{
case geInputMode.Number:
this.Value = ExCast.zCDbl(this.Text).ToString();
break;
case geInputMode.Alphanumeric:
this.Value = this.Text;
break;
case geInputMode.Date:
this.Value = this.Text.Replace("/", "");
break;
case geInputMode.FullShapeNative:
this.Value = this.Text;
break;
}
}
catch (Exception ex)
{
}
base.OnTextInputUpdate(e);
}
// 入力チェック(更新時)
public override void InputCheckUpdate()
{
#region Field
string errMessage = "";
string warnMessage = "";
Control errCtl = null;
#endregion
try
{
for (int i = 0; i <= _entity.Count - 1; i++)
{
// IDまたは名称の入力がある場合(空行は無視)
if (!string.IsNullOrEmpty(_entity[i]._id) || !string.IsNullOrEmpty(_entity[i]._name))
{
#region 入力チェック
#region 必須チェック
// ID
if (string.IsNullOrEmpty(_entity[i]._id))
{
errMessage += (i + 1) + "行目のIDが入力されていません。" + Environment.NewLine;
if (errCtl == null)
{
errCtl = this.dg;
_selectIndex = i;
_selectColumn = 0;
}
}
// 名称
if (string.IsNullOrEmpty(_entity[i]._name))
{
errMessage += (i + 1) + "行目の名称が入力されていません。" + Environment.NewLine;
if (errCtl == null)
{
errCtl = this.dg;
_selectIndex = i;
_selectColumn = 1;
}
}
#endregion
#region 適正値入力チェック
if (!string.IsNullOrEmpty(_entity[i]._id))
{
if (ExCast.zCInt(_entity[i]._id) == 0)
{
errMessage += (i + 1) + "行目のIDに「0」以外を入力して下さい。" + Environment.NewLine;
if (errCtl == null)
{
errCtl = this.dg;
_selectIndex = i;
_selectColumn = 0;
}
}
}
//// 主仕入先
//if (ExCast.zCStr(_entity._main_purchase_id) != "" && string.IsNullOrEmpty(_entity._main_purchase_nm))
//{
// errMessage += "主仕入先が適切に入力(選択)されていません。" + Environment.NewLine;
// if (errCtl == null) errCtl = this.utlMainPurchaseId.txtID;
//}
#endregion
#region 一IDチェック
if (!string.IsNullOrEmpty(_entity[i]._id))
{
for (int _i = 0; _i <= _entity.Count - 1; _i++)
{
if (_i != i && ExCast.zCInt(_entity[i]._id) == ExCast.zCInt(_entity[_i]._id) && !string.IsNullOrEmpty(_entity[_i]._id) && ExCast.zCInt(_entity[i]._id) != 0)
{
string _msg = "ID : " + ExCast.zCInt(_entity[i]._id) + " が重複して入力されています。" + Environment.NewLine;
if (errMessage.IndexOf(_msg) == -1)
{
errMessage += _msg;
if (errCtl == null)
{
errCtl = this.dg;
_selectIndex = i;
_selectColumn = 0;
}
}
}
}
}
#endregion
#region 日付チェック
//// 納入指定日
//if (string.IsNullOrEmpty(_entity.supply_ymd) == false)
//{
// if (ExCast.IsDate(_entity.supply_ymd) == false)
// {
// errMessage += "納入指定日の形式が不正です。(yyyy/mm/dd形式で入力(選択)して下さい)" + Environment.NewLine;
// if (errCtl == null) errCtl = this.datNokiYmd;
// }
//}
#endregion
#region 日付変換
// 受注日
//if (string.IsNullOrEmpty(_entity.order_ymd) == false)
//{
// _entity.order_ymd = ExCast.zConvertToDate(_entity.order_ymd).ToString("yyyy/MM/dd");
//}
#endregion
#region 数値チェック
// ID
if (!string.IsNullOrEmpty(_entity[i]._id))
{
if (!ExCast.IsNumeric(_entity[i]._id))
{
errMessage += (i + 1) + "行目のIDに数値が入力されていません。" + Environment.NewLine;
if (errCtl == null)
{
errCtl = this.dg;
_selectIndex = i;
_selectColumn = 0;
}
}
}
#endregion
#region 正数チェック
//if (this.utlMode.Mode != Utl_FunctionKey.geFunctionKeyEnable.Init)
//{
// if (ExCast.zCLng(this.utlID.txtID.Text.Trim()) < 0)
// {
// errMessage += "IDには正の整数を入力して下さい。" + Environment.NewLine;
// }
//}
#endregion
#region 範囲チェック
//if (ExCast.zCLng(this.utlID.txtID.Text.Trim()) > 9999)
//{
// errMessage += "IDには4桁の正の整数を入力して下さい。" + Environment.NewLine;
//}
//if (ExString.LenB(_entity._memo) > 32)
//{
// errMessage += "備考には全角16桁文字以内(半角32桁文字以内)を入力して下さい。" + Environment.NewLine;
// if (errCtl == null) errCtl = this.txtMemo;
//}
#endregion
#endregion
_entity[i]._display_division_id = MeiNameList.GetID(MeiNameList.geNameKbn.DISPLAY_DIVISION_ID, ExCast.zCStr(_entity[i]._display_division_nm)) - 1;
}
}
#region エラー or 警告時処理
bool flg = true;
if (!string.IsNullOrEmpty(errMessage))
{
ExMessageBox.Show(this, errCtl, errMessage, Dlg.MessageBox.MessageBoxIcon.Error);
flg = false;
}
if (!string.IsNullOrEmpty(warnMessage))
{
warnMessage += "このまま登録を続行してもよろしいですか？" + Environment.NewLine;
ExMessageBox.ResultShow(this, errCtl, warnMessage);
flg = false;
//if (ExMessageBox.ResultShow(warnMessage) == MessageBoxResult.No)
//{
// flg = false;
//}
}
this.txtDummy.IsTabStop = false;
if (flg == false)
{
if (errCtl != null)
{
switch (errCtl.Name)
{
case "dg":
errCtl.Focus();
this.dg.SelectedIndex = _selectIndex;
dg.CurrentColumn = dg.Columns[_selectColumn];
ExBackgroundWorker.DoWork_Focus(errCtl, 10);
break;
default:
ExBackgroundWorker.DoWork_Focus(errCtl, 10);
break;
}
}
return;
}
#endregion
#region 更新処理
UpdateData();
#endregion
}
finally
{
Common.gblnBtnProcLock = false;
Common.gblnBtnDesynchronizeLock = false;
}
}
private void dg_CellEditEnded(object sender, DataGridCellEditEndedEventArgs e)
{
EntityCondition entity = (EntityCondition)e.Row.DataContext;
// コンボボックスID連動
switch (e.Column.DisplayIndex)
{
case 2: // 表示区分
if (_entity == null)
{
return;
}
if (_entity.Count >= dg.SelectedIndex && dg.SelectedIndex != -1)
{
_entity[dg.SelectedIndex]._display_division_id = MeiNameList.GetID(MeiNameList.geNameKbn.DISPLAY_DIVISION_ID, ExCast.zCStr(entity._display_division_nm)) - 1;
}
break;
}
}
public static void gAddEvidence(int saveFlg, string companyId, string userId, string ipAdress, string sessionString, string pgId, DataPgEvidence.geOperationType type, string memo)
{
if (saveFlg != 1)
{
return;
}
StringBuilder sb = new StringBuilder();
DataTable dt;
ExMySQLData db = ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString);
// 日時取得
string date = "";
string time = "";
int millisecond = 0;
DateTime now = DateTime.Now;
date = now.ToString("yyyy/MM/dd");
time = now.ToString("HH:mm:ss");
millisecond = now.Millisecond;
// PG実行履歴登録
try
{
sb.Length = 0;
sb.Append("INSERT INTO H_PG_EXEC_HISTORY " + Environment.NewLine);
sb.Append(" (COMPANY_ID" + Environment.NewLine);
sb.Append(" ,USER_ID" + Environment.NewLine);
sb.Append(" ,PG_ID" + Environment.NewLine);
sb.Append(" ,OPERATION_DATE" + Environment.NewLine);
sb.Append(" ,OPERATION_TIME" + Environment.NewLine);
sb.Append(" ,OPERATION_MILLISECOND" + Environment.NewLine);
sb.Append(" ,OPERATION_TYPE" + Environment.NewLine);
sb.Append(" ,PG_NAME" + Environment.NewLine);
sb.Append(" ,OPERATION_TYPE_NAME" + Environment.NewLine);
sb.Append(" ,MEMO" + Environment.NewLine);
sb.Append(" ,UPDATE_FLG" + Environment.NewLine);
sb.Append(" ,DELETE_FLG" + Environment.NewLine);
sb.Append(" ,CREATE_PG_ID" + Environment.NewLine);
sb.Append(" ,CREATE_ADRESS" + Environment.NewLine);
sb.Append(" ,CREATE_USER_ID" + Environment.NewLine);
sb.Append(" ,CREATE_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_DATE" + Environment.NewLine);
sb.Append(" ,UPDATE_TIME" + Environment.NewLine);
sb.Append(")" + Environment.NewLine);
sb.Append("VALUES (" + companyId + Environment.NewLine); // COMPANY_ID
sb.Append(" ," + userId + Environment.NewLine); // USER_ID
sb.Append(" ," + ExEscape.zRepStr(pgId) + Environment.NewLine); // PG_ID
sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // OPERATION_DATE
sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // OPERATION_TIME
sb.Append(" ," + millisecond.ToString() + Environment.NewLine); // OPERATION_MILLISECOND
sb.Append(" ," + (int)type + Environment.NewLine); // OPERATION_TYPE
sb.Append(" ," + ExEscape.zRepStr(DataPgEvidence.GetPgName(pgId)) + Environment.NewLine); // PG_NAME
sb.Append(" ," + ExEscape.zRepStr(DataPgEvidence.GetOperationTypeName(type)) + Environment.NewLine); // OPERATION_TYPE_NAME
sb.Append(" ," + ExEscape.zRepStr(memo) + Environment.NewLine); // MEMO
sb.Append(" ,0" + Environment.NewLine); // UPDATE_FLG
sb.Append(" ,0" + Environment.NewLine); // DELETE_FLG
sb.Append(" ,'SYSTEM'" + Environment.NewLine); // CREATE_PG_ID
sb.Append(" ," + ExEscape.zRepStr(ipAdress) + Environment.NewLine); // CREATE_ADRESS
sb.Append(" ," + ExEscape.zRepStr(userId) + Environment.NewLine); // CREATE_USER_ID
sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // CREATE_DATE
sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // CREATE_TIME
sb.Append(" ,'SYSTEM'" + Environment.NewLine); // UPDATE_PG_ID
sb.Append(" ," + ExEscape.zRepStr(ipAdress) + Environment.NewLine); // UPDATE_ADRESS
sb.Append(" ," + ExEscape.zRepStr(userId) + Environment.NewLine); // UPDATE_USER_ID
sb.Append(" ," + ExEscape.zRepStr(date) + Environment.NewLine); // UPDATE_DATE
sb.Append(" ," + ExEscape.zRepStr(time) + Environment.NewLine); // UPDATE_TIME
sb.Append(")");
if (db.ExecuteSQL(sb.ToString(), true) == false)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".gAddEvidence(ExecuteSQL) : " + Environment.NewLine + ExSession.GetSessionDb(ExCast.zCInt(userId), sessionString).errMessage);
return;
}
switch (type)
{
case DataPgEvidence.geOperationType.Start:
case DataPgEvidence.geOperationType.End:
if (pgId == DataPgEvidence.PGName.System)
{
DataPgLock.DelLockPg(companyId, userId, "", "", ipAdress, true, db);
}
else
{
DataPgLock.DelLockPg(companyId, userId, pgId, "", ipAdress, true, db);
}
break;
default:
break;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".gAddEvidence(Insert)", ex);
db.ExRollbackTransaction();
}
}
public void AddEvidence(string random, string pgId, int type, string memo)
{
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
try
{
companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]);
userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]);
sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]);
string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]));
if (_message != "")
{
return;
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".AddEvidence(認証処理)", ex);
return;
}
#endregion
gAddEvidence(1, companyId, userId, ipAdress, sessionString, pgId, (DataPgEvidence.geOperationType)type, memo);
}
public List <EntityStockInventory> GetStockInventoryList(string random, string strWhereSql, string strOrderBySql)
{
List <EntityStockInventory> entityList = new List <EntityStockInventory>();
#region 認証処理
string companyId = "";
string groupId = "";
string userId = "";
string ipAdress = "";
string sessionString = "";
int idFigureCommodity = 0;
int idFigureCustomer = 0;
int idFigurePurchase = 0;
int idFigureSlipNo = 0;
try
{
companyId = ExCast.zCStr(HttpContext.Current.Session[ExSession.COMPANY_ID]);
groupId = ExCast.zCStr(HttpContext.Current.Session[ExSession.GROUP_ID]);
userId = ExCast.zCStr(HttpContext.Current.Session[ExSession.USER_ID]);
ipAdress = ExCast.zCStr(HttpContext.Current.Session[ExSession.IP_ADRESS]);
sessionString = ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]);
idFigureCommodity = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_GOODS]);
idFigureCustomer = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_CUSTOMER]);
idFigurePurchase = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_PURCHASE]);
idFigureSlipNo = ExCast.zCInt(HttpContext.Current.Session[ExSession.ID_FIGURE_SLIP_NO]);
string _message = ExSession.SessionUserUniqueCheck(random, ExCast.zCStr(HttpContext.Current.Session[ExSession.SESSION_RANDOM_STR]), ExCast.zCInt(HttpContext.Current.Session[ExSession.USER_ID]));
if (_message != "")
{
EntityStockInventory entity = new EntityStockInventory();
entity.MESSAGE = _message;
entityList.Add(entity);
return(entityList);
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetStockInventoryList(認証処理)", ex);
EntityStockInventory entity = new EntityStockInventory();
entity.MESSAGE = "認証処理に失敗しました。" + Environment.NewLine + ex.Message.ToString();;
entityList.Add(entity);
return(entityList);
}
#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();
ExReportManeger rptMgr = new ExReportManeger();
rptMgr.idFigureCommodity = idFigureCommodity;
rptMgr.idFigureCustomer = idFigureCustomer;
rptMgr.idFigurePurchase = idFigurePurchase;
rptMgr.idFigureSlipNo = idFigureSlipNo;
sb.Append(rptMgr.GetStockInventoryListReportSQL(companyId, groupId, strWhereSql, strOrderBySql));
dt = db.GetDataTable(sb.ToString());
if (dt.DefaultView.Count > 0)
{
for (int i = 0; i <= dt.DefaultView.Count - 1; i++)
{
#region Set Entity
EntityStockInventory entity = new EntityStockInventory();
entity.commodity_id = ExCast.zCStr(dt.DefaultView[i]["COMMODITY_ID"]);
entity.commodity_name = ExCast.zCStr(dt.DefaultView[i]["COMMODITY_NAME"]);
entity.account_inventory_number = ExCast.zCDbl(dt.DefaultView[i]["INVENTORY_NUMBER"]);
entity.practice_inventory_number = ExCast.zCDbl(dt.DefaultView[i]["INVENTORY_NUMBER"]);
entity.diff_number = 0;
entity.exec_flg = false;
entity.lock_flg = 0;
entityList.Add(entity);
#endregion
}
}
}
catch (Exception ex)
{
CommonUtl.ExLogger.Error(CLASS_NM + ".GetStockInventoryList", ex);
entityList.Clear();
EntityStockInventory entity = new EntityStockInventory();
entity.MESSAGE = CLASS_NM + ".GetStockInventoryList : 予期せぬエラーが発生しました。" + Environment.NewLine + ex.Message.ToString();
entityList.Add(entity);
}
finally
{
db = null;
}
svcPgEvidence.gAddEvidence(ExCast.zCInt(HttpContext.Current.Session[ExSession.EVIDENCE_SAVE_FLG]),
companyId,
userId,
ipAdress,
sessionString,
DataPgEvidence.PGName.StockInventory.StockInventoryInp,
DataPgEvidence.geOperationType.Select,
"Where:" + strWhereSql + ",Orderby:" + strOrderBySql);
return(entityList);
}
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 txt_LostFocus(object sender, RoutedEventArgs e)
{
Control ctl = (Control)sender;
ExTextBox txt = null;
ComboBox cmb = null;
int i = beforeSelectedIndex;
switch (ctl.Name)
{
case "cmbBreakdown":
cmb = (ComboBox)sender;
if (_entityListD.Count > i && i != -1)
{
// コンボボックスID連携
_entityListD[i]._breakdown_id = MeiNameList.GetID(MeiNameList.geNameKbn.BREAKDOWN_ID, ExCast.zCStr(cmb.SelectedValue));
// 消費税
if (_entityListD[i]._breakdown_id == 5)
{
_entityListD[i]._tax_division_nm = "非課税";
_entityListD[i]._tax_division_id = MeiNameList.GetID(MeiNameList.geNameKbn.TAX_DIVISION_ID, ExCast.zCStr(_entityListD[i]._tax_division_nm));
}
}
break;
case "txtGoodsId":
txt = (ExTextBox)sender;
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
MstData _mstData = new MstData();
_mstData.GetMData(MstData.geMDataKbn.Commodity, new string[] { ExCast.zCStr(txt.Text), ExCast.zCStr(i) }, this);
break;
case "cboUnit":
cmb = (ComboBox)sender;
if (_entityListD.Count > i && i != -1)
{
// コンボボックスID連携
_entityListD[i]._unit_id = MeiNameList.GetID(MeiNameList.geNameKbn.UNIT_ID, ExCast.zCStr(cmb.SelectedValue));
}
break;
case "txtEnterNum":
// 明細入数計算
txt = (ExTextBox)sender;
if (_entityListD.Count > i && i != -1)
{
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
_entityListD[i]._enter_number = ExCast.zCDbl(txt.Text);
DataDetail.CalcDetailNumber(i, _entityH, _entityListD);
}
break;
case "txtCaseNum":
// 明細ケース数計算
txt = (ExTextBox)sender;
if (_entityListD.Count > i && i != -1)
{
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
_entityListD[i]._case_number = ExCast.zCDbl(txt.Text);
DataDetail.CalcDetailNumber(i, _entityH, _entityListD);
}
break;
case "txtNumber":
// 明細数量計算
txt = (ExTextBox)sender;
if (_entityListD.Count > i && i != -1)
{
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
//OrderDetailData.CalcDetailNumber(i, _entityH, _entityListD);
_entityListD[i]._number = ExCast.zCDbl(txt.Text);
DataDetail.CalcDetail(i, _entityH, _entityListD);
}
break;
case "txtUnitPrice":
// 明細計算
txt = (ExTextBox)sender;
if (_entityListD.Count > i && i != -1)
{
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
_entityListD[i]._unit_price = ExCast.zCDbl(txt.Text);
DataDetail.CalcDetail(i, _entityH, _entityListD);
}
break;
case "txtPrice":
// 明細計算
txt = (ExTextBox)sender;
if (_entityListD.Count > i && i != -1)
{
if (beforeValue == ExCast.zCStr(txt.Text))
{
return;
}
_entityListD[i]._price = ExCast.zCDbl(txt.Text);
DataDetail.IsCalcPrice = false;
DataDetail.CalcDetail(i, _entityH, _entityListD);
DataDetail.IsCalcPrice = true;
}
break;
case "cboTaxDivision":
cmb = (ComboBox)sender;
if (_entityListD.Count > i && i != -1)
{
// コンボボックスID連携
_entityListD[i]._tax_division_id = MeiNameList.GetID(MeiNameList.geNameKbn.TAX_DIVISION_ID, ExCast.zCStr(cmb.SelectedValue));
// 課税区分が課税で内訳が消費税の場合
if (_entityListD[i]._tax_division_id == 1 && _entityListD[i]._breakdown_id == 5)
{
ExMessageBox.Show("内訳が消費税の場合、課税区分に課税を選択できません。");
_entityListD[i]._tax_division_nm = "非課税";
_entityListD[i]._tax_division_id = MeiNameList.GetID(MeiNameList.geNameKbn.TAX_DIVISION_ID, ExCast.zCStr(_entityListD[i]._tax_division_nm));
}
// 明細計算
DataDetail.CalcDetail(i, _entityH, _entityListD);
}
break;
case "txtGoodsNm":
case "txtDetailMemo":
break;
}
}
