/// <summary> /// 請求締処理よりデータ抽出時に使用 /// </summary> /// <param name="dme"></param> /// <returns></returns> public DataTable D_BillingProcessing_SelectAll(D_BillingProcessing_Entity dme) { string sp = "D_BillingProcessing_SelectAll"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = dme.StoreCD } }, }; return(SelectData(dic, sp)); }
/// <summary> /// 締処理済の場合(以下のSelectができる場合)Error /// </summary> /// <param name="de"></param> /// <returns></returns> public bool CheckBillingDate(D_BillingProcessing_Entity de) { D_BillingProcessing_DL dpd = new D_BillingProcessing_DL(); DataTable dt = dpd.CheckBillingDate(de); bool ret = false; if (dt.Rows.Count > 0) { de.ProcessingNO = dt.Rows[0]["ProcessingNO"].ToString(); ret = true; } return(ret); }
/// <summary> /// 締処理済の場合(以下のSelectができる場合)Error /// </summary> /// <param name="de"></param> /// <returns></returns> public DataTable CheckBillingDate(D_BillingProcessing_Entity de) { Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@StoreCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.StoreCD } }, { "@CustomerCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.CustomerCD } }, { "@BillingDate", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.BillingDate } } }; return(SelectData(dic, "CheckBillingDate")); }
protected override void ExecDisp() { D_BillingProcessing_Entity dbe = new D_BillingProcessing_Entity { StoreCD = CboStoreCD.SelectedValue.ToString() }; DataTable dt = ssbl.D_BillingProcessing_SelectAll(dbe); GvDetail.DataSource = dt; if (dt.Rows.Count > 0) { GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect; GvDetail.CurrentRow.Selected = true; GvDetail.Enabled = true; //GvDetail.Focus(); } else { //ssbl.ShowMessage("E128"); } }