public M_Souko_Entity M_Souko_Select(M_Souko_Entity mse) { DataTable dtSouko = msdl.M_Souko_Select(mse); if (dtSouko.Rows.Count > 0) { mse.SoukoName = dtSouko.Rows[0]["SoukoName"].ToString(); mse.StoreCD = dtSouko.Rows[0]["StoreCD"].ToString(); mse.ZipCD1 = dtSouko.Rows[0]["ZipCD1"].ToString(); mse.ZipCD2 = dtSouko.Rows[0]["ZipCD2"].ToString(); mse.Address1 = dtSouko.Rows[0]["Address1"].ToString(); mse.Address2 = dtSouko.Rows[0]["Address2"].ToString(); mse.TelephoneNO = dtSouko.Rows[0]["TelephoneNo"].ToString(); mse.FaxNO = dtSouko.Rows[0]["FaxNO"].ToString(); mse.SoukoType = dtSouko.Rows[0]["SoukoType"].ToString(); mse.MakerCD = dtSouko.Rows[0]["MakerCD"].ToString(); mse.MakerName = dtSouko.Rows[0]["MakerName"].ToString(); mse.HikiateOrder = dtSouko.Rows[0]["HikiateOrder"].ToString(); mse.UnitPriceCalcKBN = dtSouko.Rows[0]["UnitPriceCalcKBN"].ToString(); mse.IdouCount = dtSouko.Rows[0]["IdouCount"].ToString(); mse.Remarks = dtSouko.Rows[0]["Remarks"].ToString(); mse.DeleteFlg = dtSouko.Rows[0]["DeleteFlg"].ToString(); return(mse); } return(null); }
public bool M_Souko_Delete(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>() { { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCD } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } }, { "@Operator", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.Operator } }, { "@Program", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ProgramID } }, { "@PC", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.PC } }, { "@OperateMode", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ProcessMode } }, { "@KeyItem", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.Key } } }; UseTransaction = true; return(InsertUpdateDeleteData(dic, "M_Souko_Delete")); }
private void F12() { if (ErrorCheck(12)) { //*** Create Entity Object mse = GetSoukoEntity(); if (bbl.ShowMessage(OperationMode == EOperationMode.DELETE ? "Q102" : "Q101") == DialogResult.Yes) { switch (OperationMode) { case EOperationMode.INSERT: InsertUpdate(1); break; case EOperationMode.UPDATE: InsertUpdate(2); break; case EOperationMode.DELETE: Delete(); break; } } else { PreviousCtrl.Focus(); } } }
private M_Souko_Entity GetSoukoEntity() { mse = new M_Souko_Entity() { SoukoCD = ScSoukoCD.Code, ChangeDate = ScSoukoCD.ChangeDate, SoukoName = TxtSoukoName.Text, StoreCD = CboStoreCD.SelectedValue.ToString(), HikiateOrder = TxtHikiateOrder.Text, ZipCD1 = txtZipCD1.Text, ZipCD2 = txtZipCD2.Text, Address1 = TxtAddress1.Text, Address2 = TxtAddress2.Text, TelephoneNO = TxtTelePhoneNo.Text, FaxNO = TxtFaxNo.Text, SoukoType = CboSoukoType.SelectedValue.ToString(), MakerCD = ScSoukoMakerCD.Code, UnitPriceCalcKBN = ChkUnitPriceCalcKBN.Checked ? "1" : "0", IdouCount = TxtIdouCount.Text, Remarks = TxtRemark.Text, DeleteFlg = ChkDeleteFlg.Checked ? "1" : "0", ProcessMode = ModeText, Operator = InOperatorCD, ProgramID = InProgramID, Key = ScSoukoCD.Code + " " + ScSoukoCD.ChangeDate, PC = InPcID, dtTemp1 = dtLocation }; return(mse); }
private void F11() { if (ErrorCheck()) { mse = GetSearchInfo(); DataTable dtSouko = ssbl.M_Souko_Search(mse); GvSouko.DataSource = dtSouko; } }
private void Form_Load(object sender, EventArgs e) { try { Scr_Clr(); string ymd = snbl.GetDate(); snbl = new ShukkaShijiTouroku_BL(); CboSouko.Bind(ymd); CboCarrier.Bind(ymd); ScJuchuuNO.Value1 = OperatorCD; ScJuchuuNO.Value2 = AllAvailableStores; //スタッフマスター(M_Staff)に存在すること //[M_Staff] M_Staff_Entity mse = new M_Staff_Entity { StaffCD = OperatorCD, ChangeDate = snbl.GetDate() }; Staff_BL bl = new Staff_BL(); bool ret = bl.M_Staff_Select(mse); if (ret) { //[M_Souko_Search] M_Souko_Entity me = new M_Souko_Entity { StoreCD = mse.StoreCD, SoukoType = "3", ChangeDate = ymd, DeleteFlg = "0" }; DataTable mdt = snbl.M_Souko_Search(me); if (mdt.Rows.Count > 0) { CboSouko.SelectedValue = mdt.Rows[0]["SoukoCD"]; } } for (int i = (int)EIndex.DayStart; i <= (int)EIndex.PlanDateEnd; i++) { detailControls[i].Text = ymd; } detailControls[(int)EIndex.StaffCD].Text = OperatorCD; ScStaff.LabelText = mse.StaffName; detailControls[0].Focus(); } catch (Exception ex) { //エラー時共通処理 MessageBox.Show(ex.Message); //EndSec(); } }
public DataTable M_SoukoWarehouse_Select(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>(); dic.Add("@DeleteFlg", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg }); return(SelectData(dic, "M_SoukoWarehouse_Select")); }
public DataTable M_Souko_BindForZaikoshoukai(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.StoreCD } }, }; return(SelectData(dic, "M_Souko_BindForZaikoshoukai")); }
public DataTable M_Souko_BindAll(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.StoreCD } }, //{ "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } }, }; return(SelectData(dic, "M_Souko_BindAll")); }
public DataTable M_SoukoName_Select(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>(); dic.Add("@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCD }); dic.Add("@ChangeDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ChangeDate }); return(SelectData(dic, "M_SoukoName_Select")); }
public DataTable M_Location_Select(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCD } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } } }; return(SelectData(dic, "M_Location_Select")); }
public DataTable M_Souko_BindForShukka(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } }, { "@DeleteFlg", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.DeleteFlg } }, }; return(SelectData(dic, "M_Souko_BindForShukka")); }
public bool M_Souko_Search(M_Souko_Entity mse) { M_Souko_DL msdl = new M_Souko_DL(); DataTable dt = msdl.M_Souko_Search(mse); if (dt.Rows.Count > 0) { mse.SoukoCD = dt.Rows[0]["SoukoCD"].ToString(); return(true); } else { return(false); } }
private M_Souko_Entity GetSearchInfo() { mse = new M_Souko_Entity { SoukoCDFrom = TxtSoukoCDFrom.Text, SoukoCDTo = TxtSoukoCDTo.Text, ChangeDate = lblChangeDate.Text, SoukoName = TxtSoukoName.Text, StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(), SoukoType = CboSoukoType.SelectedValue.Equals("-1") ? string.Empty : CboSoukoType.SelectedValue.ToString(), DeleteFlg = "0", searchType = RdoKijunBi.Checked ? "1" : "2", }; return(mse); }
public DataTable M_Souko_IsExists(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>(); dic.Add("@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCD }); dic.Add("@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate }); dic.Add("@DeleteFlg", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg }); return(SelectData(dic, "M_Souko_IsExists")); }
private void Form_Load(object sender, EventArgs e) { try { Scr_Clr(); detailControls[(int)EIndex.DayStart].Text = snbl.GetDate(); detailControls[(int)EIndex.DayEnd].Text = snbl.GetDate(); string ymd = snbl.GetDate(); CboSoukoCD.Bind(ymd); //スタッフマスター(M_Staff)に存在すること //[M_Staff] M_Staff_Entity mse = new M_Staff_Entity { StaffCD = OperatorCD, ChangeDate = snbl.GetDate() }; Staff_BL bl = new Staff_BL(); bool ret = bl.M_Staff_Select(mse); if (ret) { //[M_Souko_Select] M_Souko_Entity me = new M_Souko_Entity { StoreCD = mse.StoreCD, SoukoType = "3", ChangeDate = ymd, DeleteFlg = "0" }; DataTable mdt = snbl.M_Souko_SelectForNyuuka(me); if (mdt.Rows.Count > 0) { CboSoukoCD.SelectedValue = mdt.Rows[0]["SoukoCD"]; } } F9Visible = false; } catch (Exception ex) { //エラー時共通処理 MessageBox.Show(ex.Message); //EndSec(); } }
/// <summary> /// Select Souko's info /// SoukoType 3,4のSouko情報をSelect /// </summary> /// <param name="mse">Souko info</param> /// <returns></returns> public DataTable M_Souko_SelectForMitsumori(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.StoreCD } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } }, { "@DeleteFlg", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.DeleteFlg } } }; return(SelectData(dic, "M_Souko_SelectForMitsumori")); }
private bool DisplayData(CKM_SearchControl sc) { mse = new M_Souko_Entity { SoukoCD = sc.Code, ChangeDate = sc.ChangeDate }; dtLocation = mtsbl.M_Location_Select(mse); if (dtLocation != null) { GvTana.DataSource = dtLocation; } mse = mtsbl.M_Souko_Select(mse); if (mse != null) { TxtSoukoName.Text = mse.SoukoName; CboStoreCD.SelectedValue = mse.StoreCD; txtZipCD1.Text = mse.ZipCD1; txtZipCD2.Text = mse.ZipCD2; TxtAddress1.Text = mse.Address1; TxtAddress2.Text = mse.Address2; TxtTelePhoneNo.Text = mse.TelephoneNO; TxtFaxNo.Text = mse.FaxNO; CboSoukoType.SelectedValue = mse.SoukoType; ScSoukoMakerCD.Code = mse.MakerCD; ScSoukoMakerCD.LabelText = mse.MakerName; TxtHikiateOrder.Text = mse.HikiateOrder; ChkUnitPriceCalcKBN.Checked = mse.UnitPriceCalcKBN.Equals("1") ? true : false; TxtIdouCount.Text = mse.IdouCount; TxtRemark.Text = mse.Remarks; ChkDeleteFlg.Checked = mse.DeleteFlg.Equals("1") ? true : false; TxtSoukoName.Focus(); return(true); } else { mtsbl.ShowMessage("E133"); return(false); } }
public DataTable M_Souko_ZipcodeAddressSelect(M_Souko_Entity mse) { string sp = "M_Souko_ZipcodeAddressSelect"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } }, { "@SoukoCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCD } }, { "@ZipCD1", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ZipCD1 } }, { "@ZipCD2", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.ZipCD2 } } }; return(SelectData(dic, sp)); }
public DataTable M_Souko_Search(M_Souko_Entity mse) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@Fields", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.FieldsName } }, { "@SoukoCDFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCDFrom } }, { "@SoukoCDTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoCDTo } }, { "@SoukoName", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.SoukoName } }, { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.StoreCD } }, { "@SoukoType", new ValuePair { value1 = SqlDbType.TinyInt, value2 = mse.SoukoType } }, { "@DeleteFlg", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.DeleteFlg } }, { "@ChangeDate", new ValuePair { value1 = SqlDbType.Date, value2 = mse.ChangeDate } }, // { "@OrderBy", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.OrderBy } }, { "@SearchType", new ValuePair { value1 = SqlDbType.VarChar, value2 = mse.searchType } }, }; return(SelectData(dic, "M_Souko_Search")); }
public DataTable M_Location_Select(M_Souko_Entity mse) { return(mldl.M_Location_Select(mse)); }
public bool M_Souko_Delete(M_Souko_Entity mse) { return(msdl.M_Souko_Delete(mse)); }
public bool M_Souko_Insert_Update(M_Souko_Entity mse, int mode) { mse.LocationXml = DataTableToXml(mse.dtTemp1); return(msdl.M_Souko_Insert_Update(mse, mode)); }
public DataTable M_Souko_ZipcodeAddressSelect(M_Souko_Entity mse) { return(msdl.M_Souko_ZipcodeAddressSelect(mse)); }
public DataTable M_Souko_SelectData(M_Souko_Entity mse) { M_Souko_DL sdl = new M_Souko_DL(); return(sdl.M_Souko_SelectData(mse)); }
public DataTable M_Souko_Search(M_Souko_Entity mse) { M_Souko_DL msdl = new M_Souko_DL(); return(msdl.M_Souko_Search(mse)); }
public DataTable M_Souko_BindForShukka(M_Souko_Entity mse) { M_Souko_DL msdl = new M_Souko_DL(); return(msdl.M_Souko_BindForShukka(mse)); }
public DataTable M_Souko_AllBind(M_Souko_Entity mse) { return(msoukodl.M_Souko_AllBind(mse)); }
public DataTable M_Souko_BindAll(M_Souko_Entity mse) { return(msoukodl.M_Souko_BindAll(mse)); }
public DataTable M_Souko_Search(M_Souko_Entity mse) { return(msoukodl.M_Souko_Search(mse)); }