private void InsertUpdateData() { string DateAndTime = System.DateTime.Now.ToString(); tze = new T_Zaiko_Entity(); tze.HanbaiShohinCD = txtSKUCD.Text; tze.JanCD = txtJANCD.Text; tze.CapitalZaiko = txtCapitalZaiko.Text; tze.ToyonakaZaiko = txtToyonakaZaiko.Text; tze.IshibashiZaiko = txtIshibashiZaiko.Text; tze.EsakaZaiko = txtEsakaZaiko.Text; tze.SannomiyaZaiko = txtSannomiyaZaiko.Text; tze.UpdateDateTime = DateAndTime; lle = new L_Log_Entity(); lle.OperateDate = DateAndTime; lle.InsertOperator = loginInfo.OperatorCode; lle.Program = "PSKS110S"; lle.PC = loginInfo.PcName; lle.OperateMode = "在庫変更"; lle.KeyItem = txtSKUCD.Text; if (zhbl.T_Zaiko_INSERT_UPDATE(tze, lle)) { } }
public bool T_Zaiko_INSERT_UPDATE(T_Zaiko_Entity tze, L_Log_Entity lle) { if (tzdl.T_Zaiko_INSERT_UPDATE(tze)) { return(lldl.L_Log_Insert(lle)); } return(false); }
public frmZaikoHenkou(T_Zaiko_Entity ZaikoData, Login_Info loginInfo) { InitializeComponent(); this.loginInfo = loginInfo; txtSKUCD.Text = ZaikoData.HanbaiShohinCD; txtJANCD.Text = ZaikoData.JanCD; txtItemName.Text = ZaikoData.ItemName; txtColor.Text = ZaikoData.Color; txtSize.Text = ZaikoData.Size; txtCapitalZaiko.Text = ZaikoData.CapitalZaiko; txtToyonakaZaiko.Text = ZaikoData.ToyonakaZaiko; txtIshibashiZaiko.Text = ZaikoData.IshibashiZaiko; txtEsakaZaiko.Text = ZaikoData.EsakaZaiko; txtSannomiyaZaiko.Text = ZaikoData.SannomiyaZaiko; }
public bool T_Zaiko_INSERT_UPDATE(T_Zaiko_Entity Zaiko_Data) { Dictionary <string, string> dic = new Dictionary <string, string>(); dic.Add("@HanbaiShohinCD", Zaiko_Data.HanbaiShohinCD); dic.Add("@JanCD", Zaiko_Data.JanCD); dic.Add("@CapitalZaiko", Zaiko_Data.CapitalZaiko.Replace(",", "")); dic.Add("@ToyonakaZaiko", Zaiko_Data.ToyonakaZaiko.Replace(",", "")); dic.Add("@IshibashiZaiko", Zaiko_Data.IshibashiZaiko.Replace(",", "")); dic.Add("@EsakaZaiko", Zaiko_Data.EsakaZaiko.ToString().Replace(",", "")); dic.Add("@SannomiyaZaiko", Zaiko_Data.SannomiyaZaiko.ToString().Replace(",", "")); dic.Add("@UpdateDateTime", Zaiko_Data.UpdateDateTime.ToString()); return(InsertUpdateDeleteData(dic, "T_Zaiko_INSERT_UPDATE")); }
/// <summary> /// Display Data for GridView /// repaied by PTK 02182019 /// </summary> private void DisplayData() { if (ErrorCheck()) { Cursor.Current = Cursors.WaitCursor; tze = new T_Zaiko_Entity(); string qty = tze.CapitalZaiko; ise = GetData(); dt_PSKS0110S = psks0110sbl.PSKS0110S_Select(ise); if (dt_PSKS0110S.Rows.Count > 0) { //if(dt_PSKS0110S !=null || dt_PSKS0110S.Rows.Count>0) //{ dgvPSKS0110S.DataSource = dt_PSKS0110S; Cursor.Current = Cursors.Default; btnDisplay.Focus(); } else { DSP_MSG("E128", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); } } }
/// <summary> /// Call frmZaikoHenkou Form /// </summary> /// <param name="rowIndex"></param> private void frmZaikoHenkou_Display(int rowIndex) { int current_row = rowIndex; tze = new T_Zaiko_Entity(); tze.HanbaiShohinCD = dt_PSKS0110S.Rows[rowIndex]["SKUCD"].ToString(); tze.JanCD = dt_PSKS0110S.Rows[rowIndex]["JANCD"].ToString(); tze.ItemName = dt_PSKS0110S.Rows[rowIndex]["商品名"].ToString(); tze.Color = dt_PSKS0110S.Rows[rowIndex]["カラー"].ToString(); tze.Size = dt_PSKS0110S.Rows[rowIndex]["サイズ"].ToString(); tze.CapitalZaiko = dt_PSKS0110S.Rows[rowIndex]["自社"].ToString(); tze.ToyonakaZaiko = dt_PSKS0110S.Rows[rowIndex]["豊中"].ToString(); tze.IshibashiZaiko = dt_PSKS0110S.Rows[rowIndex]["石橋"].ToString(); tze.EsakaZaiko = dt_PSKS0110S.Rows[rowIndex]["江坂"].ToString(); tze.SannomiyaZaiko = dt_PSKS0110S.Rows[rowIndex]["三宮"].ToString(); tze.HenkanNouki = dt_PSKS0110S.Rows[rowIndex]["納期"].ToString(); frmZaikoHenkou frmZaiko = new frmZaikoHenkou(tze, loginInfo); frmZaiko.ShowDialog(); if (frmZaiko.flgExist) { ucBrand.SetFocus(); } else { string str = dgvPSKS0110S.Rows[current_row].Cells["colJiSha"].Value.ToString(); if ((frmZaiko.oldJisha != "") && (dgvPSKS0110S.Rows[current_row].Cells["colJiSha"].Value.ToString() != frmZaiko.oldJisha)) { flg_Jisha_Err = true; } else { flg_Jisha_Err = false; } if ((frmZaiko.oldToyonaka != "") && (dgvPSKS0110S.Rows[current_row].Cells["colToyonakaZaiko"].Value.ToString() != frmZaiko.oldToyonaka)) { flg_Toyonaka_Err = true; } else { flg_Toyonaka_Err = false; } #region set zaiko tze = frmZaiko.tze; if (tze != null) { dt_PSKS0110S.Rows[rowIndex]["自社"] = tze.CapitalZaiko; dt_PSKS0110S.Rows[rowIndex]["豊中"] = tze.ToyonakaZaiko; dt_PSKS0110S.Rows[rowIndex]["石橋"] = tze.IshibashiZaiko; dt_PSKS0110S.Rows[rowIndex]["江坂"] = tze.EsakaZaiko; dt_PSKS0110S.Rows[rowIndex]["三宮"] = tze.SannomiyaZaiko; dt_PSKS0110S.Rows[rowIndex]["納期"] = tze.HenkanNouki; } #endregion if (flg_Jisha_Err) { dgvPSKS0110S.Rows[current_row].Cells["colJiSha"].Style.BackColor = Color.Yellow; } if (flg_Toyonaka_Err) { dgvPSKS0110S.Rows[current_row].Cells["colToyonakaZaiko"].Style.BackColor = Color.Yellow; } } }