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_RegOrig_Load(object sender, EventArgs e) { register_ds = this.swapdata["dataset"] as Register_ds; lookUp_rc052.Properties.DataSource = register_ds.Relation; lookUp_rc052.Properties.ValueMember = "ST003"; lookUp_rc052.Properties.DisplayMember = "ST003"; }
private void Frm_Register_Load(object sender, EventArgs e) { register_ds = this.swapdata["dataset"] as Register_ds; source = this.swapdata["source"].ToString(); if (source == "0") //本馆火化寄存 { ac001 = this.swapdata["AC001"].ToString(); OracleDataReader reader = SqlAssist.ExecuteReader("select * from ac01 where ac001='" + ac001 + "'"); while (reader.Read()) { txtEdit_rc001.EditValue = reader["AC001"]; txtEdit_rc003.EditValue = reader["AC003"]; rg_rc002.EditValue = reader["AC002"]; txtEdit_rc004.EditValue = reader["AC004"]; txtedit_rc014.EditValue = reader["AC014"]; txtEdit_rc050.EditValue = reader["AC050"]; txtEdit_rc051.EditValue = reader["AC051"]; lookUp_rc052.EditValue = reader["AC052"]; txtEdit_ac055.EditValue = reader["AC055"]; } } lookup_sa004.DataSource = register_ds.Jcfp; lookup_sa004.DisplayMember = "ITEM_TEXT"; lookup_sa004.ValueMember = "ITEM_ID"; lookUp_rc052.Properties.DataSource = register_ds.Relation; lookUp_rc052.Properties.ValueMember = "ST003"; lookUp_rc052.Properties.DisplayMember = "ST003"; register_ds.Sa01.Rows.Clear(); gridControl1.DataSource = register_ds.Sa01; //寄存所属套餐 DataRow dr_new = null; foreach (DataRow r in register_ds.RegCombo.Rows) { dr_new = register_ds.Sa01.NewRow(); dr_new["SA004"] = r["CB021"]; //商品或服务编号 dr_new["PRICE"] = MiscAction.GetItemFixPrice(r["CB021"].ToString()); dr_new["NUMS"] = r["CB030"]; dr_new["SA007"] = Convert.ToDecimal(dr_new["PRICE"]) * Convert.ToInt32(dr_new["NUMS"]); fpfee += Convert.ToDecimal(dr_new["SA007"]); register_ds.Sa01.Rows.Add(dr_new); } this.CalcHJ(); }
/// <summary> /// 骨灰寄存办理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItem20_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (FireAction.FireIsSettled(AC001) == "1") { XtraMessageBox.Show("已经办理火化且结算完成,不能继续办理业务!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } if (gridView1.LocateByValue("SA002", "08") >= 0) { XtraMessageBox.Show("【寄存】已经办理!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } Register_ds register_ds = new Register_ds(); Frm_Register frm_1 = new Frm_Register(); frm_1.swapdata["dataset"] = register_ds; frm_1.swapdata["source"] = "0"; //本馆火化寄存 frm_1.swapdata["AC001"] = AC001; if (frm_1.ShowDialog() == DialogResult.OK) { this.RefreshSalesData(); } }