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;
}
}
}
