public tb_JCH tb_JCHFind(string _sql, string _fieldsname) { tb_JCH jch = new tb_JCH(); Dblink dbl1 = new Dblink(); string[] s = _fieldsname.Split(','); try { DataSet ds = dbl1.GetDataset(_sql); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < s.Length; i++) { } } } } return(jch); } catch (Exception ee) { MessageBox.Show(ee.Message.ToString()); return(null); } }
private static void fill_dblink(CrossReferenceLink dblink, long id) { Dblink dbl = new Dblink(dblink, id); MySqlCommand cmmd9 = new MySqlCommand(dbl.get_query(), conn); MySqlDataReader reader9 = cmmd9.ExecuteReader(); reader9.Close(); }
private void frmBorrowReport_Load(object sender, EventArgs e) { ReportDocument rd = new ReportDocument(); rd.Load("LibraryReport1.rpt"); string strSql = "SELECT CardId,BookID,BookName,Author,Publisher,Price,BorrowDate,SpilthDay FROM Borrow"; Dblink db = new Dblink(); //以SQL语句为参数,产生一个Dataset DataSet dsTemp = db.GetDatasetReport(strSql, "Borrow"); DataTable dt = new DataTable(); dt = dsTemp.Tables[0]; rd.SetDataSource(dt); crystalReportViewer1.ReportSource = rd; }
public RoleComboxControl() { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select FBaseID,FBaseName from tb_base where FClass = 'Role' order by FBaseID"; ds = dbl.GetDatasetReport(sql, "tb_base"); if (ds != null) { if (ds.Tables.Count > 0) { DataSource = ds.Tables[0]; DisplayMember = "FBaseName"; ValueMember = "FBaseID"; } } }
public WareComboxControl() { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select WareID,WareName from tb_WareHouse order by WareID"; ds = dbl.GetDatasetReport(sql, "tb_base"); if (ds != null) { if (ds.Tables.Count > 0) { DataSource = ds.Tables[0]; DisplayMember = "WareName"; ValueMember = "WareID"; } } }
public ColorComboxControl() { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select ColorNo,ColorName from tb_ColorInfo where fisstop = 0 order by ColorNo"; ds = dbl.GetDatasetReport(sql, "tb_base"); if (ds != null) { if (ds.Tables.Count > 0) { DataSource = ds.Tables[0]; DisplayMember = "ColorName"; ValueMember = "ColorNo"; } } }
public BaseGroupComboxControl() { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select Groupid,Name from BaseGroup where isstop = 0 order by Groupid"; ds = dbl.GetDatasetReport(sql, "BaseGroup"); if (ds != null) { if (ds.Tables.Count > 0) { DataSource = ds.Tables[0]; DisplayMember = "Name"; ValueMember = "Groupid"; } } }
public static void SetCombox(string _class, ComboBoxEx _control) { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select FBaseID,FBaseName from tb_base where FClass = '" + _class + "' order by FBaseID"; ds = dbl.GetDatasetReport(sql, "tb_base"); List <string> listArr = new List <string>(); if (ds != null) { if (ds.Tables.Count > 0) { _control.DataSource = ds.Tables[0]; _control.DisplayMember = "FBaseName"; _control.ValueMember = "FBaseID"; } } }
public static void SetGrpCombox(ComboBoxEx _control) { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select GroupId,Name from BaseGroup where isstop = 0 order by GroupId"; ds = dbl.GetDatasetReport(sql, "BaseGroup"); List <string> listArr = new List <string>(); if (ds != null) { if (ds.Tables.Count > 0) { _control.DataSource = ds.Tables[0]; _control.DisplayMember = "Name"; _control.ValueMember = "GroupId"; } } }
public static void SetCombox(ComboBoxEx _control) { DataSet ds = new DataSet(); Dblink dbl = new Dblink(); string sql = "select EmpId,EmpName from tb_empinfo where Active= 1"; ds = dbl.GetDatasetReport(sql, "tb_EmpInfo"); List <string> listArr = new List <string>(); if (ds != null) { if (ds.Tables[0].Rows.Count > 0) { _control.DataSource = ds.Tables[0]; _control.DisplayMember = "EmpName"; _control.ValueMember = "EmpId"; } } }
public static string userid(string username) { string userid = ""; string selnum = "select empid from tb_empinfo where empname='" + username + "'"; //getSqlConnection getConnection = new getSqlConnection(); Dblink dbl = new Dblink(); DataSet ds = dbl.GetDataset(selnum); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { userid = ds.Tables[0].Rows[0]["empid"].ToString(); } } } return(userid); }
private void butAdd_Click(object sender, EventArgs e) { if (txtNumber.Text.Length == 0 || txtName.Text.Length == 0) { MessageBox.Show("借书证号和读者姓名为必填项!", "提示"); //借书证号和姓名为必填项 txtNumber.Focus(); txtNumber.SelectAll(); } else { if (MessageBox.Show("您将添加一位读者,是否继续?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { try { Dbconnection db = new Dbconnection(); Dblink dbl = new Dblink(); int Number = dbl.AutoNumber("select Max(Number) from Reader"); // 添加读者的信息 string sql = "insert into Reader values (" + Number + ",'" + txtNumber.Text.Trim() + "','" + txtName.Text.Trim() + "','0','" + txtBarcode.Text.Trim() + "','" + cmbReadertype.Text.Trim() + "','" + cmbStatu.Text.Trim() + "','" + dateTimePicker1.Text + "','" + dateTimePicker2.Text + "','" + cmbSex.Text + "','" + txtWorkshop.Text.Trim() + "','" + txtPhoneNumber.Text + "')"; if (db.ExeInfochange(sql) == 1) { MessageBox.Show("读者信息添加成功!", "提示"); //ShowAll(); } else { MessageBox.Show("数据长度不符合要求,读者信息添加失败!", "提示"); } } catch (Exception) { ; } } } }
private void tsbToexcel_Click(object sender, EventArgs e) { Dblink db = new Dblink(); db.ShowDgvInfo(dgvBookManger, true); }
private void tsbToExcel_Click(object sender, EventArgs e) { Dblink db = new Dblink(); //调用Dblink 方法来导出数据到Excel表格 db.ShowDgvInfo(dgvBorselect, true); }
private void tsbReaderToExcel_Click(object sender, EventArgs e) { Dblink db = new Dblink(); db.ShowDgvInfo(dgvUserManage, true); }