コード例 #1
0
        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();
        }
コード例 #2
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 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);
     }
 }
コード例 #3
0
ファイル: HZFP_SQD.cs プロジェクト: SoL-Alucard-Git/HX-Base
        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);
        }
コード例 #4
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 public BMBase()
 {
     this.dataSet  = new AisinoDataSet();
     this.KeyWord  = string.Empty;
     this.selectbm = "";
     this.Initialize();
 }
コード例 #5
0
ファイル: BMSPSelect.cs プロジェクト: hkloudou/HX-Base
 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);
     }
 }
コード例 #6
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 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;
 }
コード例 #7
0
        public AisinoDataSet QueryMerchandise(int pagesize, int pageno)
        {
            AisinoDataSet dataSet = this.baseDAO.querySQLDataSet(this.SQLID, this.condition, pagesize, pageno);

            this.AddShowColumn(dataSet);
            return(dataSet);
        }
コード例 #8
0
        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));
        }
コード例 #9
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
        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);
            }
        }
コード例 #10
0
        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);
        }
コード例 #11
0
ファイル: DJCF.cs プロジェクト: SoL-Alucard-Git/HX-Base
 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);
     }
 }
コード例 #12
0
ファイル: DJCF.cs プロジェクト: SoL-Alucard-Git/HX-Base
 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);
     }
 }
コード例 #13
0
 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();
 }
コード例 #14
0
ファイル: DJCF.cs プロジェクト: SoL-Alucard-Git/HX-Base
 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);
     }
 }
コード例 #15
0
ファイル: BMSPSM.cs プロジェクト: hkloudou/HX-Base
 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);
     }
 }
コード例 #16
0
        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));
        }
コード例 #17
0
ファイル: BMSPSelect.cs プロジェクト: hkloudou/HX-Base
 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);
 }
コード例 #18
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 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);
         }
     }
 }
コード例 #19
0
ファイル: HZTKClient.cs プロジェクト: SoL-Alucard-Git/HX-Base
        private AisinoDataSet getxfmc()
        {
            Aisino.Fwkp.Bmgl.Forms.BMKHSelect selet = new Aisino.Fwkp.Bmgl.Forms.BMKHSelect();
            AisinoDataSet dataset = selet.GetKHData("", 10, 1);

            return(dataset);
        }
コード例 #20
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 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;
 }
コード例 #21
0
ファイル: HZTKClient.cs プロジェクト: SoL-Alucard-Git/HX-Base
        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);
        }
コード例 #22
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 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;
 }
コード例 #23
0
        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);
        }
コード例 #24
0
ファイル: BMBase!3.cs プロジェクト: hkloudou/HX-Base
 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);
     }
 }
コード例 #25
0
 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();
 }
コード例 #26
0
 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);
 }
コード例 #27
0
        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);
        }
コード例 #28
0
        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);
        }
コード例 #29
0
        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);
        }
コード例 #30
0
 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 ? "是" : "否";
         }
     }
 }