public static QuantityRateQuery GetInstance() { if (crqform == null || crqform.IsDisposed) { crqform = new QuantityRateQuery(); } return(crqform); }
private void barButtonItem查询_ItemClick(object sender, ItemClickEventArgs e) { QuantityRateQuery Frm = QuantityRateQuery.GetInstance(); Frm.TopLevel = false; Frm.Parent = this; Frm.Show(); Frm.BringToFront(); }
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; }
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(); } }
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(); } }
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(); }
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(); } } }
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(); }
private void barButtonItem刷新_ItemClick(object sender, ItemClickEventArgs e) { QuantityRateQuery.RefreshEX(); }