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