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);
}
