public void GetThongTin() { var dt = ExecSQL.ExecProcedureDataFistOrDefault <PhieuNhapXuat>("pro_ct_phieunhapxuat", new { option = 1, maphieu = txt_maphieu.Text }); cbo_donvi.EditValue = dt.madonvi; cbo_kho.EditValue = dt.makho; cbo_loaiphieu.EditValue = dt.idloaiphieunhapxuat; txt_diengiai.Text = dt.diengiai; txt_ngaynhap.EditValue = dt.ngaynhap; }
private void cbo_donvi_EditValueChanged(object sender, EventArgs e) { if (string.IsNullOrEmpty(cbo_donvi.Text)) { return; } var dt = ExecSQL.ExecProcedureDataFistOrDefault <DonVi>("pro_get_donvi", new { option = 4, madonvi = cbo_donvi.EditValue }); txt_donvi.Text = dt.donvi; txt_diachi.Text = dt.diachi; }
private void gridView1_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e) { if (string.IsNullOrEmpty(txt_maphieu.Text)) { Form1.Default.ShowMessageWarning("Bạn vui lòng nhập vào mã phiếu để tiếp tục."); return; } var view = (GridView)sender; var i = view.FocusedRowHandle; switch (view.FocusedColumn.FieldName) { case "matruyen": var dt = ExecSQL.ExecProcedureDataFistOrDefault <TenTruyen>("pro_get_tentruyen", new { option = 2, matruyen = e.Value.ToString() }); if (dt == null) { return; } view.SetRowCellValue(i, "donvitinh", dt.donvitinh); view.SetRowCellValue(i, "tuatruyen", dt.tuatruyen); view.SetRowCellValue(i, "tentruyen", dt.tentruyen); view.SetRowCellValue(i, "tap", dt.tap); view.SetRowCellValue(i, "dongia", dt.giabia); view.SetRowCellValue(i, "slxuat", 1); view.SetRowCellValue(i, "thanhtien2", dt.giabia); break; case "slxuat": view.SetRowCellValue(i, "thanhtien2", Convert.ToInt32(e.Value) * Convert.ToInt32(view.GetRowCellValue(i, "dongia"))); break; case "giabia": view.SetRowCellValue(i, "thanhtien2", Convert.ToInt32(e.Value) * Convert.ToInt32(view.GetRowCellValue(i, "slxuat"))); break; } }