DevExpress LookUpEdit控件的使用方法

private void fromQualityComplete_Load(object sender, EventArgs e)
        {
            var order = m_vh.Grid.FocusedRowHandle;  //获取焦点行任意单元格的数据int
            var row = m_vh.Grid.GetDataRow(order);   //获取行数据
            Order = row.Field<string>("cOrder");//获取值

            dtPickerDate.Text = DateTime.Now.ToString("yyyy-MM-dd");

            sql = "select a.dNewDate,b.cSubjectContent,c.cPsnName from HV_QualityOrder_h a "
                + "left join HV_QualityOrder_b b on b.QOhId = a.QOhId "
                + "left join EI_Person c on c.pk_person = b.pk_person "
                + "where cOrder = '" + Order + "'";
            var dt = m_vh.User.GetTable(sql);
            var dr = dt.Rows[0];
            txtKTOrder.Text = Order;
            txtKTName.Text = dr["cSubjectContent"].ToString();
            txtRes.Text = dr["cPsnName"].ToString();
            dateNewTxt = dr["dNewDate"].ToString();

            sql = "select pk_rating,cRating from HI_QualityRating order by pk_rating ";
            var dtRating = m_vh.User.GetTable(sql);
            lUpEditRating.Properties.DataSource = dtRating;  //LookUpEdit绑定数据源
            lUpEditRating.Properties.ValueMember = "pk_rating";  //实际要用的字段
            lUpEditRating.Properties.DisplayMember = "cRating";  //实际显示的字段
            //修改LookUpEdit格式成为CommonBox下拉框的风格
            lUpEditRating.Properties.ShowHeader = false;  //表头不显示
            lUpEditRating.Properties.ShowFooter = false;  //表尾不显示
            lUpEditRating.Properties.PopulateColumns();   //不显示字段名方法
            lUpEditRating.Properties.Columns["pk_rating"].Visible = false;  //不显示指定字段名
            lUpEditRating.ItemIndex = 2;  //默认取第3行
            lUpEditRating.EditValue = 3;  //默认取值
            //idRating = this.lUpEditRating.EditValue.ToString();  //使用返回值
            //nameRating = this.lUpEditRating.Text.Trim();         //使用显示值
        }

        private void btnSave_Click(object sender, EventArgs e)
        {
            var datetxt = Convert.ToDateTime(dtPickerDate.EditValue).ToString("yyyy-MM-dd");
            DateTime date = Convert.ToDateTime(datetxt);
            DateTime dateNew = Convert.ToDateTime(dateNewTxt);
            idRating = lUpEditRating.EditValue.ToString();
            if (date < dateNew)
            {
                MessageBox.Show("实际完成时间不能小于制单日期!","提示");
                return;
            }
            else
            {
                sql = "update HV_QualityOrder_b set iReference = 1, dActualTime = '" + datetxt + "',"
                    + "pk_rating = '" + int.Parse(idRating) + "' where cOrder = '" + Order + "'";
                m_vh.User.DoSql(sql, "");
                m_vh.Refresh();
                Close();
                QCLog.AddUpdateLog("UPDATE", sql);
            }
        }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值