public void F12()
{
if (ErrorCheck())
{
adminCD = string.Empty;
if (gdvPSKS0119M.Rows.Count > 0)
{
if ((DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")))
{
DataTable dtUpdate = new DataTable();
dtUpdate.Columns.Add("OperatorCD");
dtUpdate.Columns.Add("AdminCD");
dtUpdate.Columns.Add("HanbaiShohinCD");
dtUpdate.Columns.Add("JanCD");
dtUpdate.Columns.Add("vc_maker_shohin");
dtUpdate.Columns.Add("taisho");
dtUpdate.Columns.Add("kijunsu");
dtUpdate.Columns.Add("Zaiko_keisan");
dtUpdate.Columns.Add("shijisho_CD");
dtUpdate.Columns.Add("Memo");
foreach (DataGridViewRow row in gdvPSKS0119M.Rows)
{
DataRow dtrow = dtUpdate.NewRow();
dtrow["OperatorCD"] = loginInfo.OperatorCode;
dtrow["AdminCD"] = row.Cells["colAdminCD"].Value.ToString();
dtrow["HanbaiShohinCD"] = row.Cells["colSKUCD"].Value.ToString();
dtrow["JanCD"] = row.Cells["colJANCD"].Value.ToString();
dtrow["vc_maker_shohin"] = row.Cells["colMakerCD"].Value.ToString();
dtrow["taisho"] = row.Cells["colTaisho"].Value.ToString() == "無効"? "0": "1";
dtrow["kijunsu"] = row.Cells["colRefNo"].Value.ToString();
DataGridViewComboBoxCell cmb = (DataGridViewComboBoxCell)row.Cells["colZaikoKeisan"];
dtrow["Zaiko_keisan"] = cmb.Value.ToString() == "-1" ? string.Empty :cmb.Value.ToString();
dtrow["shijisho_CD"] = row.Cells["colInstructionNo"].Value.ToString();
dtrow["Memo"] = row.Cells["colRemark"].Value.ToString();
dtUpdate.Rows.Add(dtrow);
}
mzke = new M_Zaiko_Kanri_Entity
{
dt = dtUpdate,
};
lle = new L_Log_Entity
{
Program = "PSKS0119M",
PC = loginInfo.PcName,
OperateMode = "InsertUpdate",
};
if (psks0119mbl.M_Zaiko_KanriInsertUpdate(mzke, lle))
{
DSP_MSG("I101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
//Clear();
txtFilePath.Focus();
}
}
}
}
}
public DataTable PSKS0120S_InitialSelect(M_Zaiko_Kanri_Entity zaiko_kanri)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperatorCD", zaiko_kanri.OperatorCD);
return(SelectData(dic, "PSKS0120S_InitialSelect"));
}
public bool PSKS0120S_Update(M_Zaiko_Kanri_Entity zaiko_kanri)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@xml", zaiko_kanri.xml);
dic.Add("@UpdateDateTime", zaiko_kanri.UpdateDateTime);
return(InsertUpdateDeleteData(dic, "PSKS0120S_Update"));
}
public bool M_Zaiko_KanriInsertUpdate(M_Zaiko_Kanri_Entity mzke, L_Log_Entity lle)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@xml", mzke.xml);
dic.Add("@Program", lle.Program);
dic.Add("@PC", lle.PC);
dic.Add("@OperateMode", lle.OperateMode);
return(InsertUpdateDeleteData(dic, "M_Zaiko_KanriInsertUpdate"));
}
private void btnSetting_Click(object sender, EventArgs e)
{
adminCD = string.Empty;
if (gdvPSKS0119M.Rows.Count > 0)
{
if (txtRefNo.Text.Length <= 3)
{
if (ArradminCD.Count > 0)
{
adminCD = string.Join(",", (string[])ArradminCD.ToArray(Type.GetType("System.String")));
}
if (string.IsNullOrWhiteSpace(adminCD))
{
DSP_MSG("E805", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); //Please! Check the Checkbox
}
else
{
mzke = new M_Zaiko_Kanri_Entity
{
OperatorCD = loginInfo.OperatorCode,
AdminCD = adminCD,
taisho = cboTaisho1.SelectedValue.ToString(),
kijunsu = string.IsNullOrWhiteSpace(txtRefNo.Text) ? "-1" : txtRefNo.Text,
Zaiko_keisan = string.IsNullOrWhiteSpace(cboZaikoKeisan.SelectedValue.ToString()) ? "-1" : cboZaikoKeisan.SelectedValue.ToString(),
};
//if (psks0119mbl.M_Zaiko_Kanri_Setting(mzke))
//{
foreach (DataGridViewRow row in gdvPSKS0119M.Rows)
{
DataGridViewCheckBoxCell chk1 = row.Cells["colChk"] as DataGridViewCheckBoxCell;
if (Convert.ToBoolean(chk1.Value) == true)
{
string taisho1 = mzke.taisho != "-1" && mzke.taisho == "0" ? "無効" : "有効";
row.Cells["colTaisho"].Value = mzke.taisho == "-1" ? row.Cells["colTaisho"].Value.ToString() : taisho1;
row.Cells["colRefNo"].Value = mzke.kijunsu == "-1" ? row.Cells["colRefNo"].Value.ToString() : mzke.kijunsu;
DataGridViewComboBoxCell cmb = (DataGridViewComboBoxCell)row.Cells["colZaikoKeisan"];
cmb.Value = mzke.Zaiko_keisan == "-1" ? cmb.Value.ToString() : mzke.Zaiko_keisan;
}
chk1.Value = false;
ArradminCD.Remove(row.Cells["colAdminCD"].Value.ToString());
}
//DSP_MSG("I101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
txtFilePath.Focus();
// }
}
}
else
{
DSP_MSG("E143", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); //Character count is over!!
txtRefNo.Focus();
}
}
}
public bool M_Zaiko_Kanri_Setting(M_Zaiko_Kanri_Entity mzke)
{
Dictionary <string, string> dic = new Dictionary <string, string>();
dic.Add("@OperatorCD", mzke.OperatorCD);
dic.Add("@AdminCD", mzke.AdminCD);
dic.Add("@taisho", mzke.taisho);
dic.Add("@kijunsu", mzke.kijunsu);
dic.Add("@Zaiko_keisan", mzke.Zaiko_keisan);
return(InsertUpdateDeleteData(dic, "PSKS0119M_InsertUpdate"));
}
private void Initial_GridviewBind()
{
dtPSKS0102S = new DataTable();
zaikokanri = new M_Zaiko_Kanri_Entity();
zaikokanri.OperatorCD = loginInfo.OperatorCode;
dtPSKS0102S = p102Sbl.PSKS0120S_InitialSelect(zaikokanri);
if (dtPSKS0102S.Rows.Count > 0)
{
dgvPSKS0102S.DataSource = dtPSKS0102S;
}
}
public bool PSKS0120S_Update(M_Zaiko_Kanri_Entity zaikokanri, L_Log_Entity lle)
{
zaikokanri.UpdateDateTime = lle.OperateDate = System.DateTime.Now.ToString();
zaikokanridl.StartTransaction();
logdl.Transaction = zaikokanridl.Transaction;
if (zaikokanridl.PSKS0120S_Update(zaikokanri))
{
if (logdl.L_Log_Insert(lle))
{
zaikokanridl.CommitTransaction();
return(true);
}
}
return(false);
}
private void DataDelete()
{
gdvPSKS0119M.EndEdit();
adminCD = string.Empty;
if (gdvPSKS0119M.Rows.Count > 0)
{
if (ArradminCD.Count > 0)
{
adminCD = string.Join(",", (string[])ArradminCD.ToArray(Type.GetType("System.String")));
}
if (string.IsNullOrWhiteSpace(adminCD))
{
DSP_MSG("E805", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty); //Please! Check the Checkbox
}
else
{
mzke = new M_Zaiko_Kanri_Entity
{
OperatorCD = loginInfo.OperatorCode,
AdminCD = adminCD,
};
lle = new L_Log_Entity
{
Program = "PSKS0119M",
PC = loginInfo.PcName,
OperateMode = "Delete",
};
if (psks0119mbl.M_Zaiko_RenkanriDelete(mzke, lle))
{
DSP_MSG("I102", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
Clear();
txtFilePath.Focus();
}
}
}
}
private void UpdateData()
{
if ((DSP_MSG("Q101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty).Equals("1")))
{
DataTable dtUpdate = new DataTable();
dtUpdate.Columns.Add("OperatorCD");
dtUpdate.Columns.Add("AdminCD");
dtUpdate.Columns.Add("Shijisho");
dtUpdate.Columns.Add("Memo");
dt = dgvPSKS0102S.DataSource as DataTable;
foreach (DataRow dr in dt.Rows)
{
if (dr.RowState == DataRowState.Modified)
{
DataRow row = dtUpdate.NewRow();
row["OperatorCD"] = dr["OperatorCD"];
row["AdminCD"] = dr["AdminCD"];
row["Shijisho"] = dr["Shijisho"];
row["Memo"] = dr["Memo"];
dtUpdate.Rows.Add(row);
}
}
if (dtUpdate.Rows.Count > 0)
{
zaikokanri = new M_Zaiko_Kanri_Entity();
zaikokanri.xml = p102Sbl.DataTableToXml(dtUpdate);
lle = GetLogData();
if (p102Sbl.PSKS0120S_Update(zaikokanri, lle))
{
DSP_MSG("I101", string.Empty, string.Empty, string.Empty, string.Empty, string.Empty);
}
}
}
}
public DataTable PSKS0120S_InitialSelect(M_Zaiko_Kanri_Entity zaikokanri)
{
return(zaikokanridl.PSKS0120S_InitialSelect(zaikokanri));
}
public bool M_Zaiko_RenkanriDelete(M_Zaiko_Kanri_Entity mzke, L_Log_Entity lle)
{
return(mzkdl.M_Zaiko_RenkanriDelete(mzke, lle));
}
public bool M_Zaiko_KanriInsertUpdate(M_Zaiko_Kanri_Entity mzke, L_Log_Entity lle)
{
mzke.xml = DataTableToXml(mzke.dt);
return(mzkdl.M_Zaiko_KanriInsertUpdate(mzke, lle));
}
public bool M_Zaiko_Kanri_Setting(M_Zaiko_Kanri_Entity mzke)
{
return(mzkdl.M_Zaiko_Kanri_Setting(mzke));
}
