private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0023BLL bll = new KB.BLL.DATA0023BLL(db); if (SqlWhere.Length > 0) { list = bll.GetEntityByCode(textBoxSupplierCode.Text.Trim(), SqlWhere); } else { list = bll.GetEntityByCode(textBoxSupplierCode.Text.Trim()); } dataGridView1.DataSource = list; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0497BLL bll = new KB.BLL.DATA0497BLL(db); if (type == -1) { list = (List <KB.Models.DATA0497>)bll.FindBySql(" ACTIVE_FLAG=0 AND APPROVAL_ROUTE_CODE like '%" + textBox1.Text.Trim() + "%'"); } else { list = (List <KB.Models.DATA0497>)bll.FindBySql(" ACTIVE_FLAG=0 AND APPROVAL_ROUTE_CODE like '%" + textBox1.Text.Trim() + "%' and APPROVAL_TYPE =" + type.ToString()); } dataGridView1.DataSource = list; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
protected void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0017BLL data0017BLL = new KB.BLL.DATA0017BLL(db); string sqlWhere = string.Format(" (inv_part_number like '%{0}%' or inv_part_description like '%{0}%') ", textBox1.Text.Trim()); if (where.Length > 0) { sqlWhere = where + " and " + sqlWhere; } if (orderBy.Length > 0) { sqlWhere = sqlWhere + orderBy; } data0017List = (List <KB.Models.DATA0017>)data0017BLL.FindBySql(sqlWhere, topNum); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = data0017List; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
protected void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0016BLL bll = new KB.BLL.DATA0016BLL(db); if (data0017Ptr > 0) { data0016List = bll.GetDefaultLocationByInventory(data0017Ptr); } else { data0016List = (List <KB.Models.DATA0016>)bll.FindBySql(string.Format(" code like '{0}' or location like '%{0}%'", textBox1.Text.Trim())); } dataGridView1.DataSource = data0016List; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private DataTable tb;//存储DATA0038中的Parameter private void FormParameter_Load(object sender, EventArgs e) { dataGridView1.AutoGenerateColumns = false; dataGridView1.MultiSelect = false; dataGridView1.AllowUserToResizeRows = false; dataGridView1.RowHeadersVisible = false; KB.DAL.DBHelper db = null; try { db = new KB.DAL.DBHelper(); tb = db.GetDataSet(string.Format("select distinct {0} as parameter from data0038 where {0} is not null order by {0}", ColumnName)); for (int i = tb.Rows.Count - 1; i >= 0; i--)//删除空行 { if (tb.Rows[i][0].ToString().Trim().Length == 0) { tb.Rows.RemoveAt(i); } } BindData(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { if (db != null) { db.CloseConnection(); } } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0034BLL bll = new KB.BLL.DATA0034BLL(db); if (!showExpendedData) { list = (List <KB.Models.DATA0034>)bll.FindBySql(" DEPT_CODE like '%" + textBoxCode.Text.Trim() + "%' and (ACTIVE_FLAG = 0 OR ACTIVE_FLAG IS NULL)" + SqlWhere); } else { try { #region 初始化拓展表 DataTable temp = bll.getDataSet("select * from sysobjects where name = 'DATA0034E' and xtype = 'U'"); if (temp != null & temp.Rows.Count == 0) { string execSql = @"create table DATA0034E ( rkey numeric(10,0) identity(1,1) primary key, data0034ptr numeric(10,0) not null, )"; db.ExecuteCommand(execSql); } #endregion list = (List <KB.Models.DATA0034>)bll.FindBySql(" DEPT_CODE like '%" + textBoxCode.Text.Trim() + "%' and (ACTIVE_FLAG = 0 OR ACTIVE_FLAG IS NULL)" + " and RKEY IN (select data0034ptr from DATA0034E) " + SqlWhere + " order by DEPT_CODE"); } catch (Exception error) { throw error; } } dataGridView1.DataSource = list; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0395BLL bll = new KB.BLL.DATA0395BLL(db); var tb = bll.QueryMirForMaintenanceOrder(textBoxCode.Text.Trim()); dataGridView1.DataSource = null; dataGridView1.DataSource = tb; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0172BLL bll = new KB.BLL.DATA0172BLL(db); var list = (List <DATA0172>)bll.FindBySql(string.Format(" STATUS_OF_MO=4 and MO_NUMBER like '%{0}%' order by MO_NUMBER", textBoxCode.Text.Trim())); dataGridView1.DataSource = null; dataGridView1.DataSource = list; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { DATA0555BLL bll = new DATA0555BLL(db); dataGridView1.DataSource = bll.GetMirList("1", "2", textBoxMirNo.Text.Trim()); } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); textBoxMirNo.Focus(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0161BLL bll = new KB.BLL.DATA0161BLL(db); list = (List <KB.Models.DATA0161>)bll.FindBySql(" EQUIPMENT_NAME like '%" + textBoxCode.Text.Trim() + "%'"); dataGridView1.DataSource = list; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
protected void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0370BLL bll = new KB.BLL.DATA0370BLL(db); list = (List <KB.Models.DATA0370>)bll.FindBySql(" CODE like '%" + textBox1.Text.Trim() + "%' and (Data0370.ACTIVE_FLAG = 0 OR Data0370.ACTIVE_FLAG IS NULL)"); dataGridView1.DataSource = list; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0005BLL bll = new KB.BLL.DATA0005BLL(db); data0005List = (List <KB.Models.DATA0005>)bll.FindBySql(" empl_code like '%" + textBoxCode.Text.Trim() + "%' or employee_name like '%" + textBoxCode.Text.Trim() + "%'"); dataGridView1.DataSource = data0005List; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { DATA0466BLL bll = new DATA0466BLL(db); DataTable tb = bll.QueryROForBasePage(textBoxCode.Text.Trim(), Data0023Ptr); dataGridView1.DataSource = null; dataGridView1.DataSource = tb; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
protected void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0015BLL data0015BLL = new KB.BLL.DATA0015BLL(db); data0015List = (List <KB.Models.DATA0015>)data0015BLL.FindBySql(string.Format("warehouse_code like '%{0}%' or warehouse_name like '%{0}%' ", textBox1.Text.Trim())); dataGridView1.AutoGenerateColumns = false; dataGridView1.DataSource = data0015List; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void BindData() { KB.DAL.DBHelper db = null; try { db = new KB.DAL.DBHelper(); KB.BLL.DATA0039BLL bll = new KB.BLL.DATA0039BLL(db); string sqlWhere = " REJECT_DEFECT_FLAG = '{0}' and (REJ_CODE like '%{1}%' or REJECT_DESCRIPTION like '%{1}%')"; list = (List <DATA0039>)bll.FindBySql(string.Format(sqlWhere, RejectType, txtUserInput.Text.Trim())); dataGridView1.DataSource = list; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { if (dataGridView1.CurrentCell != null && e.RowIndex >= 0) { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0172BLL bll = new KB.BLL.DATA0172BLL(db); Data0172 = bll.getDATA0172ByRECORD_KEY_MO(decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString())); this.DialogResult = DialogResult.OK; } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } } }
private void BindData() { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { KB.BLL.DATA0013BLL bll = new KB.BLL.DATA0013BLL(db); data0013List = (List <KB.Models.DATA0013>)bll.FindBySql(" NP_CODE like '%" + textBox1.Text.Trim() + "%'"); var list = new List <D13Item>(); foreach (var d13 in data0013List) { var item = new D13Item(); item.rkey = d13.RKEY; item.NP_CODE = d13.NP_CODE; item.NOTE_PAD_LINE = (string.IsNullOrEmpty(d13.NOTE_PAD_LINE_1) ? "" : d13.NOTE_PAD_LINE_1.Trim()) + (string.IsNullOrEmpty(d13.NOTE_PAD_LINE_2) ? "" : d13.NOTE_PAD_LINE_2.Trim()) + (string.IsNullOrEmpty(d13.NOTE_PAD_LINE_3) ? "" : d13.NOTE_PAD_LINE_3.Trim()) + (string.IsNullOrEmpty(d13.NOTE_PAD_LINE_4) ? "" : d13.NOTE_PAD_LINE_4.Trim()); list.Add(item); } dataGridView1.DataSource = null; dataGridView1.DataSource = list; for (int i = 0; i < list.Count; i++) { dataGridView1.Rows[i].Cells[0].Value = list[i].NP_CODE; dataGridView1.Rows[i].Cells[1].Value = list[i].NOTE_PAD_LINE; } } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } }
private void dataGridView1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { if (dataGridView1.CurrentCell != null && dataGridView1.CurrentCell.RowIndex >= 0) { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { Data0017Ptr = decimal.Parse(dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString()); DATA0017BLL bll = new DATA0017BLL(db); inventory = bll.getDATA0017ByRKEYWithNolock(Data0017Ptr); this.DialogResult = DialogResult.OK; } catch (Exception ex) { KB.FUNC.log.RecordInfo(ex); MessageBox.Show(ex.ToString()); } finally { db.CloseConnection(); } } }
private void BaseWorkOrder_Load(object sender, EventArgs e) { KB.DAL.DBHelper db = new KB.DAL.DBHelper(); try { d06bll = new DATA0006BLL(db); dataGridView1.AutoGenerateColumns = false; if (HasOpType == 1) { txt_SearchStr.Visible = false; btn_Clean.Visible = false; } else { txt_SearchStr.Text = work_order_number; } top = 200; BindData(); } finally { db.CloseConnection(); } }