コード例 #1
0
        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";
        }
コード例 #2
0
ファイル: Frm_RegOrig.cs プロジェクト: anrk0451/White
 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";
 }
コード例 #3
0
ファイル: Frm_Register.cs プロジェクト: anrk0451/White
        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();
        }
コード例 #4
0
        /// <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();
            }
        }