public BMXZQY() { this.Initialize(); List <Dictionary <string, string> > list = new List <Dictionary <string, string> >(); Dictionary <string, string> item = new Dictionary <string, string>(); item.Add("AisinoLBL", "编码"); item.Add("Property", "BM"); item.Add("Type", "Text"); item.Add("Width", "100"); item.Add("Align", "MiddleLeft"); item.Add("HeadAlign", "MiddleCenter"); item.Add("Visible", "True"); list.Add(item); item = new Dictionary <string, string>(); item.Add("AisinoLBL", "名称"); item.Add("Property", "MC"); item.Add("Type", "Text"); item.Add("Width", "200"); item.Add("Align", "MiddleLeft"); item.Add("HeadAlign", "MiddleLeft"); list.Add(item); this.aisinoDataGrid1.ColumeHead = list; this.aisinoDataGrid1.MultiSelect = false; this.aisinoDataGrid1.AborCellPainting = true; this.aisinoDataGrid1.ReadOnly = true; this.aisinoDataGrid1.DataGrid.AllowUserToDeleteRows = false; this.KeyWord = "%"; this.dataSet = this.districtManager.QueryByKey(this.KeyWord, this.districtManager.Pagesize, this.districtManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; this.aisinoDataGrid1.Refresh(); }
protected virtual void btnAdd_Click(object sender, EventArgs e) { try { string name = string.Empty; if (this.aisinoDataGrid1.SelectedRows.Count != 1) { if (this.treeViewBM1.SelectedNode == null) { MessageManager.ShowMsgBox("INP-235104"); return; } name = this.treeViewBM1.SelectedNode.Name; } else if ("0" == this.aisinoDataGrid1.SelectedRows[0].Cells["WJ"].Value.ToString()) { name = this.aisinoDataGrid1.SelectedRows[0].Cells["BM"].Value.ToString(); } else { name = this.aisinoDataGrid1.SelectedRows[0].Cells["SJBM"].Value.ToString(); } if (((BaseForm)Activator.CreateInstance(typeof(tEdit), new object[] { name, this })).ShowDialog() == DialogResult.OK) { this.dataSet = this.bllManager.QueryData(this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; } } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } }
public AisinoDataSet SelectSelList(int page, int count, int month, string xfsh) { AisinoDataSet set = null; try { this.dict.Clear(); if (month != 0) { this.dict.Add("MONbz", 1); this.dict.Add("MON", new DateTime(DateTime.Now.Year, month, DateTime.Now.Day).ToString("yyyy-MM-dd")); } else { this.dict.Add("MONbz", 0); this.dict.Add("MON", ""); this.dict.Add("xfsh", xfsh); } set = this.baseDao.querySQLDataSet("aisino.Fwkp.Hzfp.SelectSQDSelList", this.dict, count, page); } catch (BaseException exception) { ExceptionHandler.HandleError(exception); } catch (Exception exception2) { ExceptionHandler.HandleError(exception2); } return(set); }
public BMBase() { this.dataSet = new AisinoDataSet(); this.KeyWord = string.Empty; this.selectbm = ""; this.Initialize(); }
private void textBoxWaitKey_TextChanged(object sender, EventArgs e) { try { this.shangpinManager.CurrentPage = 1; this.KeyWord = (sender as ToolStripTextBox).Text.Trim(); if (this.SpecialSP == string.Empty) { if ((this.ShowCanselect == 0) && (this.SelectSlv >= 0.0)) { this.dataSet = this.shangpinManager.QueryByKeyDisplaySEL(this.KeyWord, this.SelectSlv, this.shangpinManager.Pagesize, this.shangpinManager.CurrentPage); } else { this.dataSet = this.shangpinManager.QueryByKeyDisplaySEL(this.KeyWord, this.shangpinManager.Pagesize, this.shangpinManager.CurrentPage); } } else { this.dataSet = this.shangpinManager.QueryByKeyDisplaySEL(this.KeyWord, this.SpecialSP, this.shangpinManager.Pagesize, this.shangpinManager.CurrentPage); } this.aisinoDataGrid1.DataSource = this.dataSet; this.ChangeCanSelect(); this.textBoxWaitKey.Focus(); } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } }
private void btnQuery_Click(object sender, EventArgs e) { this.bllManager.CurrentPage = 1; this.KeyWord = this.textBoxWaitKey.Text.Trim(); this.dataSet = this.bllManager.QueryByKey(this.KeyWord, this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; }
public AisinoDataSet QueryMerchandise(int pagesize, int pageno) { AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, pagesize, pageno); this.AddShowColumn(dataSet); return(dataSet); }
internal override BaseResult DoService() { Aisino.Fwkp.Bmgl.Forms.BMKHSelect selet = new Aisino.Fwkp.Bmgl.Forms.BMKHSelect(); AisinoDataSet dataset = selet.GetKHData("", 99999, 1); return(new GetKHResult(_args, dataset.Data)); }
protected virtual bool treeViewBM1_onTreeNodeClick(object sender, TreeViewEventArgs e) { bool flag = false; try { if ((e.Node != this.treeViewBM1.TopNode) && (e.Node != null)) { this.selectbm = e.Node.Name; } else { this.selectbm = ""; } this.bllManager.CurrentPage = 1; this.dataSet = this.bllManager.SelectNodeDisplay(this.selectbm, this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; if (this.aisinoDataGrid1.DataSource.Data.Rows.Count > 1) { flag = true; } return(flag); } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); return(flag); } }
public AisinoDataSet QueryByKeyDisplaySEL(string KeyWord, string specialSP, int Pagesize, int Pageno) { this.condition.Clear(); this.condition.Add("key", "%" + KeyWord + "%"); if (specialSP == "HYSY") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPqueryKeyHYSYDisplaySEL"; } else if (specialSP == "XT") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPqueryKeyXTDisplaySEL"; } else if (specialSP == "SNY") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPqueryKeySNYDisplaySEL"; } else if (specialSP == "Except_HYSY") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPqueryKeyExceptHYSYDisplaySEL"; } AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, Pagesize, Pageno); this.AddShowColumn(dataSet); return(dataSet); }
private void textBoxKey_TextChanged(object sender, EventArgs e) { try { this.KeyWords = this.textBoxKey.Text.Trim(); this.DJmonth = this.comboBoxYF.SelectedItem.ToString(); this.DJtype = this.comboBoxDJZL.SelectedValue.ToString(); this.JYrule = this.comboBoxJYGZ.SelectedValue.ToString(); if (this.JYrule == "s") { this.aisinoDataGrid1.remove_DataGridRowSelectionChanged(new EventHandler <DataGridRowEventArgs>(this.aisinoDataGrid1_DataGridRowSelectionChanged)); this.CheckAdd(this.djcfBLL.Pagesize, this.djcfBLL.CurrentPage); this.aisinoDataGrid1.add_DataGridRowSelectionChanged(new EventHandler <DataGridRowEventArgs>(this.aisinoDataGrid1_DataGridRowSelectionChanged)); } else { this.dataSet = this.djcfBLL.QueryXSDJ(this.KeyWords, this.DJmonth, this.DJtype, this.JYrule, this.djcfBLL.Pagesize, this.djcfBLL.CurrentPage); this.aisinoDataGrid1.set_DataSource(this.dataSet); } } catch (Exception exception) { HandleException.HandleError(exception); } }
private void aisinoDataGrid1_DataGridRowSelectionChanged(object sender, DataGridRowEventArgs e) { try { this.Grid1BH = e.get_CurrentRow().Cells["BH"].Value.ToString().Trim(); this.dataSet = this.djcfBLL.QueryXSDJMX(this.Grid1BH, this.djcfBLL.Pagesize, 1); this.aisinoDataGrid2.set_DataSource(this.dataSet); SaleBill bill = this.billBL.Find(this.Grid1BH); int count = this.aisinoDataGrid2.get_Rows().Count; for (int i = 0; i < count; i++) { string str = this.aisinoDataGrid2.get_Rows()[i].Cells["SLV"].Value.ToString(); string str2 = this.aisinoDataGrid2.get_Rows()[i].Cells["XH"].Value.ToString(); if (((str != null) && (str != "")) && (str != "中外合作油气田")) { string str3 = this.billBL.ShowSLV(bill, str2, str); if (str3 != "") { this.aisinoDataGrid2.get_Rows()[i].Cells["SLV"].Value = str3; } } } } catch (Exception exception) { HandleException.HandleError(exception); } }
private void aisinoDataGrid1_GoToPageEvent(object sender, GoToPageEventArgs e) { this.customerManager.Pagesize = e.PageSize; this.dataSet = this.customerManager.QueryDistrict(e.PageSize, e.PageNO); this.aisinoDataGrid1.DataSource = this.dataSet; this.ChangeCanSelect(); }
private void btnQuery_Click(object sender, EventArgs e) { try { this.KeyWords = this.textBoxKey.Text.Trim(); this.DJmonth = this.comboBoxYF.SelectedItem.ToString(); this.DJtype = this.comboBoxDJZL.SelectedValue.ToString(); this.JYrule = this.comboBoxJYGZ.SelectedValue.ToString(); int result = 1; int.TryParse(PropertyUtil.GetValue("WBJK_DJCF_DATAGRID1"), out result); this.djcfBLL.CurrentPage = result; if (this.JYrule == "s") { this.aisinoDataGrid1.remove_DataGridRowSelectionChanged(new EventHandler <DataGridRowEventArgs>(this.aisinoDataGrid1_DataGridRowSelectionChanged)); this.CheckAdd(this.djcfBLL.Pagesize, this.djcfBLL.CurrentPage); this.aisinoDataGrid1.add_DataGridRowSelectionChanged(new EventHandler <DataGridRowEventArgs>(this.aisinoDataGrid1_DataGridRowSelectionChanged)); } else { this.dataSet = this.djcfBLL.QueryXSDJ(this.KeyWords, this.DJmonth, this.DJtype, this.JYrule, this.djcfBLL.Pagesize, this.djcfBLL.CurrentPage); this.aisinoDataGrid1.set_DataSource(this.dataSet); } if (this.aisinoDataGrid1.get_DataSource().get_Data().Rows.Count == 0) { this.aisinoDataGrid2.set_DataSource(this.djcfBLL.QueryXSDJMX("NoExcitBH", this.djcfBLL.Pagesize, 1)); MessageManager.ShowMsgBox("INP-272203"); } } catch (Exception exception) { HandleException.HandleError(exception); } }
private void btnModify_Click(object sender, EventArgs e) { try { if (this.aisinoDataGrid1.SelectedRows.Count == 1) { string bM = this.aisinoDataGrid1.SelectedRows[0].Cells["BM"].Value.ToString(); BMSPSM_Edit edit = new BMSPSM_Edit(this.aisinoDataGrid1.SelectedRows[0].Cells["SZ"].Value.ToString(), bM, true); if (edit.ShowDialog() == DialogResult.OK) { this.dataSet = this.customerManager.QueryGoodsTax(this.customerManager.Pagesize, this.customerManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; } } else { MessageManager.ShowMsgBox("INP-235105"); } } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } }
internal override BaseResult DoService() { Aisino.Fwkp.Bmgl.Forms.BMSPSelect selet = new Aisino.Fwkp.Bmgl.Forms.BMSPSelect("", -1.0, 0, ""); AisinoDataSet dataset = selet.GetSPData("", 10, 1); return(new GetSPResult(_args, dataset.Data)); }
private bool treeViewBM1_onTreeNodeClick(object sender, TreeViewEventArgs e) { this.textBoxWaitKey.Text = ""; if (e.Node != this.treeViewBM1.TopNode) { this.selectbm = e.Node.Name; } else { this.selectbm = ""; } this.shangpinManager.CurrentPage = 1; if (this.SpecialSP == string.Empty) { if ((this.ShowCanselect == 0) && (this.SelectSlv >= 0.0)) { this.dataSet = this.shangpinManager.SelectNodeDisplaySEL(this.selectbm, this.SelectSlv, this.shangpinManager.Pagesize, this.shangpinManager.CurrentPage); } else { this.dataSet = this.shangpinManager.SelectNodeDisplaySEL(this.selectbm, this.shangpinManager.Pagesize, this.shangpinManager.CurrentPage); } } else { this.dataSet = this.shangpinManager.SelectNodeDisplaySEL(this.selectbm, this.SpecialSP, this.shangpinManager.Pagesize, this.shangpinManager.CurrentPage); } this.aisinoDataGrid1.DataSource = this.dataSet; this.ChangeCanSelect(); return(true); }
protected virtual void aisinoDataGrid1_DataGridRowDbClickEvent(object sender, DataGridRowEventArgs e) { if ((("Object" != typeof(tEdit).Name) || ("Object" != typeof(tFenLei).Name)) || ("Object" != typeof(tSelect).Name)) { try { string str = e.CurrentRow.Cells["BM"].Value.ToString(); if ("0" == e.CurrentRow.Cells["WJ"].Value.ToString()) { if (((BaseForm)Activator.CreateInstance(typeof(tFenLei), new object[] { this, str, true })).ShowDialog() == DialogResult.OK) { this.bllManager.CurrentPage = 1; this.dataSet = this.bllManager.SelectNodeDisplay(this.selectbm, this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; this.treeViewBM1.TreeLoad(); this.treeViewBM1.SelectNodeByText(this.selectbm); } } else if (((BaseForm)Activator.CreateInstance(typeof(tEdit), new object[] { str, true })).ShowDialog() == DialogResult.OK) { this.dataSet = this.bllManager.QueryData(this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; } } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } } }
private AisinoDataSet getxfmc() { Aisino.Fwkp.Bmgl.Forms.BMKHSelect selet = new Aisino.Fwkp.Bmgl.Forms.BMKHSelect(); AisinoDataSet dataset = selet.GetKHData("", 10, 1); return(dataset); }
private void textBoxWaitKey_TextChanged(object sender, EventArgs e) { this.bllManager.CurrentPage = 1; this.KeyWord = (sender as ToolStripTextBox).Text.Trim(); this.dataSet = this.bllManager.QueryByKey(this.KeyWord, this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; }
private AisinoDataSet getsplist() { Aisino.Fwkp.Bmgl.Forms.BMSPSelect selet = new Aisino.Fwkp.Bmgl.Forms.BMSPSelect("", -1.0, 0, ""); AisinoDataSet dataset = selet.GetSPData("", 10, 1); return(dataset); }
private void aisinoDataGrid1_GoToPageEvent(object sender, GoToPageEventArgs e) { this.bllManager.CurrentPage = e.PageNO; this.bllManager.Pagesize = e.PageSize; this.dataSet = this.bllManager.QueryData(e.PageSize, e.PageNO); this.aisinoDataGrid1.DataSource = this.dataSet; }
public AisinoDataSet SelectNodeDisplaySEL(string selectedBM, string specialSP, int Pagesize, int Pageno) { this.condition.Clear(); this.condition.Add("BM", "%" + selectedBM + "%"); if (specialSP == "HYSY") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPbmlikeAndHYSYSEL"; } else if (specialSP == "XT") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPbmlikeAndXTSEL"; } else if (specialSP == "SNY") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPbmlikeAndSNYSEL"; } else if (specialSP == "Except_HYSY") { this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPbmlikeAndExcept_HYSYSEL"; } AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, Pagesize, Pageno); this.AddShowColumn(dataSet); return(dataSet); }
private void btnModify_Click(object sender, EventArgs e) { try { if (this.aisinoDataGrid1.SelectedRows.Count == 1) { string str = this.aisinoDataGrid1.SelectedRows[0].Cells["BM"].Value.ToString(); if ("0" == this.aisinoDataGrid1.SelectedRows[0].Cells["WJ"].Value.ToString()) { if (((BaseForm)Activator.CreateInstance(typeof(tFenLei), new object[] { this, str, true })).ShowDialog() == DialogResult.OK) { this.bllManager.CurrentPage = 1; this.dataSet = this.bllManager.SelectNodeDisplay(this.selectbm, this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; this.treeViewBM1.TreeLoad(); this.treeViewBM1.SelectNodeByText(this.selectbm); } } else if (((BaseForm)Activator.CreateInstance(typeof(tEdit), new object[] { str, true })).ShowDialog() == DialogResult.OK) { this.dataSet = this.bllManager.QueryData(this.bllManager.Pagesize, this.bllManager.CurrentPage); this.aisinoDataGrid1.DataSource = this.dataSet; } } else { MessageManager.ShowMsgBox("INP-235105"); } } catch (Exception exception) { this.log.Error(exception.ToString()); ExceptionHandler.HandleError(exception); } }
private void aisinoDataGrid1_GoToPageEvent(object sender, GoToPageEventArgs e) { PropertyUtil.SetValue("pagesize", e.PageSize.ToString()); this.fpflManager.CurrentPage = e.PageNO; this.dataSet = this.fpflManager.QueryData(e.PageSize, e.PageNO); this.aisinoDataGrid1.DataSource = this.dataSet; this.ChangeCanSelect(); }
private void toolUpdate_Click(object sender, EventArgs e) { new SPFLService().UpdateSPFL(); this.dataSet = this.spflManager.QueryData(this.spflManager.Pagesize, this.spflManager.CurrentPage); base.aisinoDataGrid1.DataSource = this.dataSet; base.treeViewBM1.TreeLoad(); base.treeViewBM1.SelectNodeByText(base.treeViewBM1.RootNodeString); }
public AisinoDataSet SelectNodeDisplaySEL(string selectedBM, int Pagesize, int Pageno) { this.condition.Clear(); this.condition.Add("key", selectedBM + "%"); this.SQLID = "aisino.Fwkp.Bmgl.BMSPFL.SPFLbmlikeSEL"; AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, Pagesize, Pageno); this.AddShowColumn(dataSet); return(dataSet); }
public AisinoDataSet QueryByKeySEL(string KeyWord, int pagesize, int pageno) { this.condition.Clear(); this.condition.Add("key", "%" + KeyWord + "%"); this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPqueryKeySEL"; AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, pagesize, pageno); this.AddShowColumn(dataSet); return(dataSet); }
public AisinoDataSet SelectNodeDisplay(string selectedBM, double slv, int Pagesize, int Pageno) { this.condition.Clear(); this.condition.Add("BM", selectedBM + "%"); this.condition.Add("SLV", slv); this.SQLID = "aisino.Fwkp.Bmgl.BMSP.SPbmlikeAndSlv"; AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, Pagesize, Pageno); this.AddShowColumn(dataSet); return(dataSet); }
private void AddShowColumn(AisinoDataSet dataSet) { dataSet.Data.Constraints.Clear(); dataSet.Data.Columns.Add("SLVStr"); dataSet.Data.Columns.Add("DJStr"); dataSet.Data.Columns.Add("ISHIDEBOOL"); dataSet.Data.Columns.Add("HSJBZSTR"); for (int i = 0; i < dataSet.Data.Rows.Count; i++) { double num2 = (double)dataSet.Data.Rows[i]["SLV"]; double num3 = (double)dataSet.Data.Rows[i]["DJ"]; string str = (string)dataSet.Data.Rows[i]["ISHIDE"]; bool flag = (bool)dataSet.Data.Rows[i]["HSJBZ"]; int num4 = (int)dataSet.Data.Rows[i]["WJ"]; bool flag2 = (bool)dataSet.Data.Rows[i]["HYSY"]; string str2 = dataSet.Data.Rows[i]["LSLVBS"].ToString(); if ((num2 == 0.05) && flag2) { dataSet.Data.Rows[i]["SLVStr"] = "中外合作油气田"; } else if ((("0.00" == num2.ToString("f2")) && (str2 == "1")) && Flbm.IsYM()) { dataSet.Data.Rows[i]["SLVStr"] = "免税"; } else if ((("0.00" == num2.ToString("f2")) && (str2 == "2")) && Flbm.IsYM()) { dataSet.Data.Rows[i]["SLVStr"] = "不征税"; } else if ((("0.00" == num2.ToString("f2")) && (num4 == 1)) && Flbm.IsYM()) { dataSet.Data.Rows[i]["SLVStr"] = "0%"; } else if ("0.015" == num2.ToString("f3")) { dataSet.Data.Rows[i]["SLVStr"] = "减按1.5%计算"; } else if ((("0.00" == num2.ToString("f2")) && (num4 == 1)) && !Flbm.IsYM()) { dataSet.Data.Rows[i]["SLVStr"] = "免税"; } else { dataSet.Data.Rows[i]["SLVStr"] = (num2 == 0.0) ? "" : num2.ToString("P0"); } dataSet.Data.Rows[i]["ISHIDEBOOL"] = (str == "0000000000") ? "否" : "是"; if (num4 == 1) { dataSet.Data.Rows[i]["DJStr"] = (num3 == 0.0) ? "" : num3.ToString("C"); dataSet.Data.Rows[i]["HSJBZSTR"] = flag ? "是" : "否"; } } }