private void Frm_registerOut_Load(object sender, EventArgs e) { rc001 = this.swapdata["RC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + rc001 + "'"); while (reader.Read()) { txtEdit_rc001.Text = rc001; txtEdit_rc109.EditValue = reader["RC109"]; txtEdit_rc003.EditValue = reader["RC003"]; txtEdit_rc303.EditValue = reader["RC303"]; rg_rc002.EditValue = reader["RC002"]; rg_rc202.EditValue = reader["RC202"]; txtEdit_rc004.EditValue = reader["RC004"]; txtEdit_rc404.EditValue = reader["RC404"]; txtEdit_rc150.EditValue = reader["RC150"]; //寄存到期日期 be_position.EditValue = RegisterAction.GetRegPathName(rc001); price = RegisterAction.GetBitPrice(reader["RC130"].ToString()); txtEdit_price.EditValue = price; int diff = RegisterAction.CalcOutDiffDays(rc001); int compare = string.Compare(Convert.ToDateTime(reader["RC150"]).ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd")); if (compare == 0) { checkEdit1.Enabled = false; txtEdit_nums.Enabled = false; } else if (compare > 0) //退费 { lc_1.Text = "剩余天数"; lc_2.Text = "应退费年份(年限)"; lc_3.Text = "退费金额"; isrefund = true; ///佳木斯东郊不用退费 txtEdit_nums.EditValue = 0; txtEdit_fee.EditValue = 0; } else { lc_1.Text = "过期天数"; lc_2.Text = "应补费年份(年限)"; lc_3.Text = "补费金额"; txtEdit_nums.EditValue = Math.Round((diff * 1.0f) / 365, 2); txtEdit_fee.EditValue = Convert.ToDecimal(Math.Round((diff * 1.0f) / 365, 2)) * price; } txtEdit_diff.EditValue = diff; } ////是否允许取消迁出补退 ///// //if(Tools.GetRight(Envior.cur_userId,"02070") == "0") //{ checkEdit1.Enabled = false; //} }
private void Frm_RegEdit_Load(object sender, EventArgs e) { ac001 = this.swapdata["AC001"].ToString(); register_ds = this.swapdata["dataset"] as Register_ds; OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + ac001 + "'"); while (reader.Read()) { txtEdit_rc001.EditValue = reader["RC001"]; txtEdit_rc109.EditValue = reader["RC109"]; txtEdit_rc003.EditValue = reader["RC003"]; txtEdit_rc303.EditValue = reader["RC303"]; be_position.EditValue = RegisterAction.GetRegPathName(ac001); rg_rc002.EditValue = reader["RC002"]; rg_rc202.EditValue = reader["RC202"]; txtEdit_rc004.EditValue = reader["RC004"]; txtEdit_rc404.EditValue = reader["RC404"]; txtedit_rc014.EditValue = reader["RC014"]; txtEdit_rc050.EditValue = reader["RC050"]; txtEdit_rc051.EditValue = reader["RC051"]; lookUp_rc052.EditValue = reader["RC052"]; txtEdit_ac055.EditValue = reader["RC055"]; mem_rc099.EditValue = reader["RC099"]; } lookUp_rc052.Properties.DataSource = register_ds.Relation; lookUp_rc052.Properties.ValueMember = "ST003"; lookUp_rc052.Properties.DisplayMember = "ST003"; }
private void Frm_RegisterPay_Load(object sender, EventArgs e) { string s_rc130 = string.Empty; rc001 = this.swapdata["RC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + rc001 + "'"); while (reader.Read()) { txtEdit_rc001.Text = rc001; txtEdit_rc109.EditValue = reader["RC109"]; txtEdit_rc003.EditValue = reader["RC003"]; txtEdit_rc303.EditValue = reader["RC303"]; txtEdit_rc004.EditValue = reader["RC004"]; txtEdit_rc404.EditValue = reader["RC404"]; rg_rc002.EditValue = reader["RC002"]; rg_rc202.EditValue = reader["RC202"]; be_position.Text = RegisterAction.GetRegPathName(rc001); s_rc130 = reader["RC130"].ToString(); bitprice = Convert.ToDecimal(SqlAssist.ExecuteScalar("select bi009 from bi01 where bi001='" + s_rc130 + "'", null)); txtedit_price.EditValue = bitprice; } rc04Adapter.SelectCommand.CommandText = "select * from v_rc04 where rc001='" + rc001 + "' order by rc020"; rc04Adapter.Fill(dt_rc04); gridControl1.DataSource = dt_rc04; comboBox1.Text = ""; }
private void Frm_registerOut_Load(object sender, EventArgs e) { rc001 = this.swapdata["RC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + rc001 + "'"); while (reader.Read()) { txtEdit_rc001.Text = rc001; txtEdit_rc109.EditValue = reader["RC109"]; //寄存证号 txtEdit_rc003.EditValue = reader["RC003"]; //逝者姓名 txtEdit_rc303.EditValue = reader["RC303"]; //逝者姓名2 rg_rc002.EditValue = reader["RC002"]; //性别 rg_rc202.EditValue = reader["RC202"]; //性别2 txtEdit_rc004.EditValue = reader["RC004"]; //年龄 txtEdit_rc404.EditValue = reader["RC404"]; txtEdit_rc150.EditValue = reader["RC150"]; //寄存到期日期 be_position.EditValue = RegisterAction.GetRegPathName(rc001); //price = Math.Round( RegisterAction.GetBitPrice(reader["RC130"].ToString()) / 12, 0); price = RegisterAction.GetBitPrice(reader["RC130"].ToString()); txtEdit_price.EditValue = price; //比较到期日期 (判断是否应该补或退) compare = string.Compare(Convert.ToDateTime(reader["RC150"]).ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd")); //设置补退信息 this.SetBTInfo(); } //TODO 5. 根据权限设置 是否允许补退费 checkEdit1.Enabled = true; }
private void Frm_AdjustRegisterDate_Load(object sender, EventArgs e) { s_ac001 = this.swapdata["AC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + s_ac001 + "'"); while (reader.Read()) { txtEdit_rc003.EditValue = reader["RC003"]; txtedit_pos.Text = RegisterAction.GetRegPathName(s_ac001); de_begin.EditValue = reader["RC140"]; de_end.EditValue = reader["RC150"]; } }
private void Frm_RegisterPay_Load(object sender, EventArgs e) { string s_rc130 = string.Empty; rc001 = this.swapdata["RC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + rc001 + "'"); while (reader.Read()) { txtEdit_rc001.Text = rc001; txtEdit_rc109.EditValue = reader["RC109"]; txtEdit_rc003.EditValue = reader["RC003"]; txtEdit_rc303.EditValue = reader["RC303"]; txtEdit_rc004.EditValue = reader["RC004"]; txtEdit_rc404.EditValue = reader["RC404"]; rg_rc002.EditValue = reader["RC002"]; rg_rc202.EditValue = reader["RC202"]; be_position.Text = RegisterAction.GetRegPathName(rc001); s_rc130 = reader["RC130"].ToString(); bitprice = Convert.ToDecimal(SqlAssist.ExecuteScalar("select bi009 from bi01 where bi001='" + s_rc130 + "'", null)); txtedit_price.EditValue = bitprice; //如果最后缴费日期 大于 2018-01-01 则无需混合价格 if (string.Compare(Convert.ToDateTime(reader["RC150"]).ToString("yyyyMMdd"), "20180101") > 0) { checkEdit1.Enabled = false; } else { oldprice = RegisterAction.GetLastRegPrice(rc001); } } reader.Dispose(); rc04Adapter.SelectCommand.CommandText = "select * from v_rc04 where rc001='" + rc001 + "' order by rc020"; rc04Adapter.Fill(dt_rc04); gridControl1.DataSource = dt_rc04; fpAdapter.Fill(dt_fpsource); lookup_sa004.DataSource = dt_fpsource; lookup_sa004.DisplayMember = "ITEM_TEXT"; lookup_sa004.ValueMember = "ITEM_ID"; sa01Adapter.Fill(dt_sa01); gridControl2.DataSource = dt_sa01; //comboBox1.Text = ""; this.Calc_Hj(12); }
private void Frm_RegisterMove_Load(object sender, EventArgs e) { rc001 = this.swapdata["RC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + rc001 + "'"); while (reader.Read()) { txtEdit_rc001.Text = rc001; txtEdit_rc109.EditValue = reader["RC109"]; txtEdit_rc003.EditValue = reader["RC003"]; bitId_Old = reader["RC130"].ToString(); be_position.EditValue = RegisterAction.GetRegPathName(rc001); } }
private void Frm_registerOut_Load(object sender, EventArgs e) { rc001 = this.swapdata["RC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from rc01 where rc001='" + rc001 + "'"); while (reader.Read()) { txtEdit_rc001.Text = rc001; txtEdit_rc109.EditValue = reader["RC109"]; txtEdit_rc003.EditValue = reader["RC003"]; txtEdit_rc303.EditValue = reader["RC303"]; rg_rc002.EditValue = reader["RC002"]; rg_rc202.EditValue = reader["RC202"]; txtEdit_rc004.EditValue = reader["RC004"]; txtEdit_rc404.EditValue = reader["RC404"]; txtEdit_rc150.EditValue = reader["RC150"]; //寄存到期日期 be_position.EditValue = RegisterAction.GetRegPathName(rc001); price = Math.Round(RegisterAction.GetBitPrice(reader["RC130"].ToString()) / 12, 0); txtEdit_price.EditValue = price; int diff = RegisterAction.CalcOutDiffDays(rc001); int compare = string.Compare(Convert.ToDateTime(reader["RC150"]).ToString("yyyyMMdd"), DateTime.Now.ToString("yyyyMMdd")); if (compare == 0) { checkEdit1.Enabled = false; txtEdit_nums.Enabled = false; } else if (compare > 0) //退费 { lc_1.Text = "剩余天数"; lc_2.Text = "应退费月数"; lc_3.Text = "退费金额"; isrefund = true; txtEdit_nums.EditValue = Math.Round((diff * 1.0f) / 30, 0); txtEdit_fee.EditValue = Convert.ToDecimal(Math.Round((diff * 1.0f) / 30, 0)) * price; } else { lc_1.Text = "过期天数"; lc_2.Text = "应补费月数"; lc_3.Text = "补费金额"; txtEdit_nums.EditValue = Math.Round((diff * 1.0f) / 30, 0); txtEdit_fee.EditValue = Convert.ToDecimal(Math.Round((diff * 1.0f) / 30, 0)) * price; } txtEdit_diff.EditValue = diff; } //TODO 5. 根据权限设置 是否允许补退费 //权限检查 if (!AppAction.CheckRight("迁出时允许选择补退")) { checkEdit1.Enabled = false; } }