Exemplo n.º 1
0
 public static QuantityRateQuery GetInstance()
 {
     if (crqform == null || crqform.IsDisposed)
     {
         crqform = new QuantityRateQuery();
     }
     return(crqform);
 }
Exemplo n.º 2
0
        private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e)
        {
            QuantityRateQuery Frm = QuantityRateQuery.GetInstance();

            Frm.TopLevel = false;
            Frm.Parent   = this;
            Frm.Show();
            Frm.BringToFront();
        }
Exemplo n.º 3
0
        private void CostRate_Load(object sender, EventArgs e)
        {
            this.WindowState = FormWindowState.Maximized;
            QuantityRateQuery Frm = QuantityRateQuery.GetInstance();

            Frm.TopLevel = false;
            Frm.Parent   = this;
            Frm.Show();
            Frm.BringToFront();
            Frm.Height = this.Height - 20;
        }
Exemplo n.º 4
0
        private void barButtonItem修改_ItemClick(object sender, ItemClickEventArgs e)
        {
            string  yyyy = "";
            int     id = 0, quarterid = 0;
            decimal standardpoint = 0;

            QuantityRateQuery.GetInfo(ref id, ref yyyy, ref quarterid, ref standardpoint);
            if (id != 0)
            {
                QuantityRateUpdate Frm = new QuantityRateUpdate();
                Frm.TopLevel = false;
                Frm.Parent   = this;
                Frm.Show();
                Frm.BringToFront();
            }
        }
Exemplo n.º 5
0
        private void CostRateUpdate_Load(object sender, EventArgs e)
        {
            string   yyyy = "";
            int      id = 0, quarterid = 0;
            decimal  costrate   = 0;
            DateTime dt         = DateTime.Now;
            DateTime startMonth = dt.AddDays(1 - dt.Day);  //本月月初

            this.dateTimePicker1.Value = startMonth;
            QuantityRateQuery.GetInfo(ref id, ref yyyy, ref quarterid, ref costrate);
            Common.BasicDataBind("cost_quarter", comboBoxQuarter);
            if (id != 0)
            {
                comboBoxQuarter.SelectedIndex = -1;
                comboBoxQuarter.SelectedValue = quarterid;
                dateTimePicker1.Value         = Convert.ToDateTime(yyyy + "-01");
                textEditRate.Text             = costrate.ToString();
                textEditID.Text = id.ToString();
            }
        }
Exemplo n.º 6
0
        private void simpleButtonOK_Click(object sender, EventArgs e)
        {
            ConnDB conn = new ConnDB();
            string sql  = "update COST_QUANTITY_RATE set rate = ltrim(rtrim('" + Common.IsNull(textEditRate.Text.ToString()) + "'))";

            sql = sql + " where cid = " + textEditID.Text.ToString();
            bool isok = conn.EditDatabase(sql);

            if (isok)
            {
                MessageBox.Show("修改成功!");
                QuantityRateQuery.RefreshEX();
                this.Close();
            }
            else
            {
                MessageBox.Show("失败!");
            }
            conn.Close();
        }
Exemplo n.º 7
0
 private void simpleButton复制_Click(object sender, EventArgs e)
 {
     if (comboBoxQuarter.SelectedValue.ToString() == "0")
     {
         MessageBox.Show("请选择季度");
     }
     else
     {
         MessageBoxButtons messButton = MessageBoxButtons.OKCancel;
         DialogResult      dr         = MessageBox.Show("将按最近的季度数据自动新增当前选择季度的数据,确认复制吗?", "复制最近季度数据", messButton);
         if (dr == DialogResult.OK)
         {
             ConnDB conn = new ConnDB();
             string strsql, strsql2;
             int    rows;
             bool   isok = false;
             strsql2 = "select * from COST_QUANTITY_RATE where yyyy ='" + dateTimePicker1.Text.ToString() + "' and quarter_id = " + Common.IsZero(comboBoxQuarter.SelectedValue.ToString());
             rows    = conn.ReturnRecordCount(strsql2);
             if (rows > 0)
             {
                 MessageBox.Show("该季度比率已经存在!");
             }
             else
             {
                 strsql = "insert into COST_QUANTITY_RATE(yyyy,quarter_id,rate) select '" + dateTimePicker1.Text + "','" + Common.IsZero(comboBoxQuarter.SelectedValue.ToString()) + "',rate from COST_QUANTITY_RATE where YYYY + cast(quarter_id as varchar(10)) = (select Max(yyyy+cast(quarter_id as varchar(10))) from COST_QUANTITY_RATE) ";
                 isok   = conn.EditDatabase(strsql);
                 if (isok)
                 {
                     MessageBox.Show("复制成功!");
                     QuantityRateQuery.RefreshEX();
                     this.Close();
                 }
             }
             conn.Close();
         }
     }
 }
Exemplo n.º 8
0
        private void simpleButtonOK_Click(object sender, EventArgs e)
        {
            ConnDB conn = new ConnDB();
            string strsql, strsql2;
            int    rows;

            strsql  = "insert into COST_QUANTITY_RATE(yyyy,quarter_id,rate) values('" + dateTimePicker1.Text.ToString() + "'," + comboBoxQuarter.SelectedValue.ToString() + ",ltrim(rtrim(" + Common.IsNull(textEditRate.Text.ToString()) + ")))";
            strsql2 = "select * from COST_QUANTITY_RATE where yyyy ='" + dateTimePicker1.Text.ToString() + "' and quarter_id = " + Common.IsZero(comboBoxQuarter.SelectedValue.ToString());
            if (comboBoxQuarter.SelectedValue.ToString() == "0")
            {
                MessageBox.Show("请选择季度");
            }
            else if (textEditRate.Text.ToString() == "")
            {
                MessageBox.Show("终端台数比率不能为空!");
            }
            else
            {
                rows = conn.ReturnRecordCount(strsql2);
                if (rows > 0)
                {
                    MessageBox.Show("该比率已经存在!");
                }
                else
                {
                    bool isok = conn.EditDatabase(strsql);
                    if (isok)
                    {
                        MessageBox.Show("添加成功!");
                        QuantityRateQuery.RefreshEX();
                        this.Close();
                    }
                }
            }
            conn.Close();
        }
Exemplo n.º 9
0
 private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e)
 {
     QuantityRateQuery.RefreshEX();
 }