private void cbReader_TextChanged(object sender, EventArgs e)
{
CtbReaderInformationBLL cReaderBll = new CtbReaderInformationBLL();
CtbReaderInformation creader = cReaderBll.GetModel(int.Parse(cbReader.Text));
if (creader != null)
{
lbRname.Visible = true;
lbRname1.Visible = true;
lbRname1.Text = creader.readerName;
}
}
//绑定读者编号列表到控件
public void ReadersComboxBinding()
{
cbReader.Items.Clear();
CtbReaderInformationBLL cReaderBll = new CtbReaderInformationBLL();
List <CtbReaderInformation> cReaders = cReaderBll.GetModelList("readerID>0");
foreach (CtbReaderInformation cr in cReaders)
{
cbReader.Items.Add(cr.readerID);
cbGReaderID.Items.Add(cr.readerID);
}
}
/// <summary>
/// 绑定所有读者信息到datagridview
/// </summary>
private void RefreshAllReader()
{
this.dgvAllReader.Columns.Clear();
List <CtbReaderInformation> allReader = new List <CtbReaderInformation>();
CtbReaderInformationBLL allReaderBll = new CtbReaderInformationBLL();
allReader = allReaderBll.GetModelList("readerID>0");
this.dgvAllReader.DataSource = allReader;
this.dgvAllReader.Columns["readerID"].HeaderText = "读者编号";
this.dgvAllReader.Columns["readerName"].HeaderText = "读者姓名";
this.dgvAllReader.Columns["readerSex"].HeaderText = "读者性别";
this.dgvAllReader.Columns["readerOffice"].HeaderText = "读者职务";
this.dgvAllReader.Columns["readerDept"].HeaderText = "工作单位";
this.dgvAllReader.Columns["readerPhone"].HeaderText = "联系电话";
this.dgvAllReader.Columns["readerHAddress"].HeaderText = "家庭住址";
this.dgvAllReader.Columns["readerEmail"].HeaderText = "E-MAIL";
this.dgvAllReader.Columns["readerResDate"].HeaderText = "登记日期";
}
//删除读者信息
private void tsbDeleteReader_Click(object sender, EventArgs e)
{
CtbReaderInformationBLL readerInfo = new CtbReaderInformationBLL();
if (dgvAllReader.CurrentRow != null)
{
int readerID = int.Parse(dgvAllReader.CurrentRow.Cells["readerID"].Value.ToString());
if (MessageBox.Show("删除编号为" + readerID.ToString() + "的读者会删除所有与此读者关联的借阅与还书信息,确定要删除吗？", "操作提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
readerInfo.Delete(readerID);//执行删除
MessageBox.Show("删除成功！", "操作提示");
}
RefreshAllReader();//刷新显示
}
else
{
MessageBox.Show("请选中你要删除的信息再执行删除！", "操作提示");
}
}
//读者信息查询
private void btReader_Click(object sender, EventArgs e)
{
List <CtbReaderInformation> cReaders = new List <CtbReaderInformation>();
CtbReaderInformationBLL readerBll = new CtbReaderInformationBLL();
string sqlStr = "";
if (cbRID.Checked)
{
if (tbRID.Text != "")
{
sqlStr = sqlStr + "and readerID=" + tbRID.Text + " ";
}
}
if (cbRName.Checked)
{
if (tbRName.Text != "")
{
sqlStr = sqlStr + "and readerName='" + tbRName.Text + "' ";
}
}
if (cbRSex.Checked)
{
sqlStr = sqlStr + "and readerSex='" + comRSex.Text + "' ";
}
if (cbROffice.Checked)
{
if (tbROffice.Text != "")
{
sqlStr = sqlStr + "and readerOffice=" + tbROffice.Text + "' ";
}
}
if (cbRDept.Checked)
{
if (tbRDept.Text != "")
{
sqlStr = sqlStr + "and readerDept='" + tbRDept.Text + "' ";
}
}
if (cbRPhone.Checked)
{
if (tbRPhone.Text != "")
{
sqlStr = sqlStr + "and readerPhone=" + tbRPhone.Text + "' ";
}
}
if (cbREmail.Checked)
{
if (tbREmail.Text != "")
{
sqlStr = sqlStr + "and readerEmail=" + tbREmail.Text + "' ";
}
}
if (sqlStr != "")
{
sqlStr = sqlStr.Remove(0, 4);
cReaders = readerBll.GetModelList(sqlStr);
if (cReaders.Count > 0)
{
this.dgvSearchResult.Columns.Clear();
this.dgvSearchResult.DataSource = cReaders;
this.dgvSearchResult.Columns["readerID"].HeaderText = "读者编号";
this.dgvSearchResult.Columns["readerName"].HeaderText = "读者姓名";
this.dgvSearchResult.Columns["readerSex"].HeaderText = "性别";
this.dgvSearchResult.Columns["readerOffice"].HeaderText = "读者职务";
this.dgvSearchResult.Columns["readerDept"].HeaderText = "工作单位";
this.dgvSearchResult.Columns["readerPhone"].HeaderText = "联系电话期";
this.dgvSearchResult.Columns["readerHAddress"].HeaderText = "家庭住址";
this.dgvSearchResult.Columns["readerEmail"].HeaderText = "Email";
this.dgvSearchResult.Columns["readerResDate"].HeaderText = "登记日期";
}
else
{
MessageBox.Show("未查到相关信息！", "操作提示");
}
}
else
{
sqlStr = "readerID>0";
cReaders = readerBll.GetModelList(sqlStr);
if (cReaders.Count > 0)
{
this.dgvSearchResult.Columns.Clear();
this.dgvSearchResult.DataSource = cReaders;
this.dgvSearchResult.Columns["readerID"].HeaderText = "读者编号";
this.dgvSearchResult.Columns["readerName"].HeaderText = "读者姓名";
this.dgvSearchResult.Columns["readerSex"].HeaderText = "性别";
this.dgvSearchResult.Columns["readerOffice"].HeaderText = "读者职务";
this.dgvSearchResult.Columns["readerDept"].HeaderText = "工作单位";
this.dgvSearchResult.Columns["readerPhone"].HeaderText = "联系电话期";
this.dgvSearchResult.Columns["readerHAddress"].HeaderText = "家庭住址";
this.dgvSearchResult.Columns["readerEmail"].HeaderText = "Email";
this.dgvSearchResult.Columns["readerResDate"].HeaderText = "登记日期";
}
else
{
MessageBox.Show("未查到相关信息！", "操作提示");
}
}
}
private void btEnter_Click(object sender, EventArgs e)
{
//在这里我们要进行判断我们进行的是添加还是修改
//判断的方法我们这里只介绍针对我们现在这种情况的方法
//方法就是判断按钮的TEXT是"添加"还是"保存"
#region 添加事件代码部分
if (btEnter.Text == "添加")
{
CtbReaderInformation cReader = new CtbReaderInformation();
CtbReaderInformationBLL cReaderBll = new CtbReaderInformationBLL();
//这里我们允许某些字段为空,但是读者ID，和读者姓名不允许为空
if (tbReaderID.Text != "" && tbReaderName.Text != "")
{
cReader.readerID = int.Parse(tbReaderID.Text);
cReader.readerName = tbReaderName.Text;
//判断控件内容是否为空，为空不赋值，使用类属性的默认值
if (cbReaderSex.Text != "")
{
cReader.readerSex = cbReaderSex.Text;
}
if (tbReaderOffice.Text != "")
{
cReader.readerOffice = tbReaderOffice.Text;
}
if (tbReaderDept.Text != "")
{
cReader.readerDept = tbReaderDept.Text;
}
if (tbReaderPhone.Text != "")
{
cReader.readerPhone = tbReaderPhone.Text;
}
if (tbReaderAddress.Text != "")
{
cReader.readerHAddress = tbReaderAddress.Text;
}
if (tbReaderEMail.Text != "")
{
cReader.readerEmail = tbReaderEMail.Text;
}
cReader.readerResDate = dtkReaderResDate.Value;
try
{
//执行添加操作
cReaderBll.Add(cReader);
if (MessageBox.Show("添加成功！是否继续添加？", "操作提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
dlg();
ClearAllContent();
}
else
{
dlg();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统异常提示");
}
}
}
#endregion
#region 修改事件代码
if (btEnter.Text == "保存")
{
CtbReaderInformation cReader = new CtbReaderInformation();
CtbReaderInformationBLL cReaderBll = new CtbReaderInformationBLL();
//这里我们允许某些字段为空,但是读者姓名不允许为空
if (tbReaderName.Text != "")
{
cReader.readerID = int.Parse(tbReaderID.Text);
cReader.readerName = tbReaderName.Text;
//判断控件内容是否为空，为空不赋值，使用类属性的默认值
if (cbReaderSex.Text != "")
{
cReader.readerSex = cbReaderSex.Text;
}
if (tbReaderOffice.Text != "")
{
cReader.readerOffice = tbReaderOffice.Text;
}
if (tbReaderDept.Text != "")
{
cReader.readerDept = tbReaderDept.Text;
}
if (tbReaderPhone.Text != "")
{
cReader.readerPhone = tbReaderPhone.Text;
}
if (tbReaderAddress.Text != "")
{
cReader.readerHAddress = tbReaderAddress.Text;
}
if (tbReaderEMail.Text != "")
{
cReader.readerEmail = tbReaderEMail.Text;
}
cReader.readerResDate = dtkReaderResDate.Value;
//执行修改操作
try
{
cReaderBll.Update(cReader);
MessageBox.Show("修改成功", "操作提示");
dlg();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "系统异常提示");
}
}
}
#endregion
}
