影片出租管理.docx
- 文档编号:13180305
- 上传时间:2023-06-11
- 格式:DOCX
- 页数:16
- 大小:70.40KB
影片出租管理.docx
《影片出租管理.docx》由会员分享,可在线阅读,更多相关《影片出租管理.docx(16页珍藏版)》请在冰点文库上搜索。
影片出租管理
出租管理(Hire.cs)窗体设计
在窗体上拖入9个label控件,7个textbox控件,6个button控件,并设置如下“
控件
属性
设置值
说明
Hire
text
出租管理
label1
text
出租序号:
label2
text
影片序号:
label3
text
顾客序号:
label4
text
数量
label5
text
张:
label6
text
折扣:
label7
text
押金:
label8
text
职员号:
label9
text
出租影片管理:
Button1
text
新顾客
name
BtLog
Button2
text
出租
name
BtHire
Button3
text
还片
name
BtReturn
Button4
text
清除
name
BtClear
Button5
text
浏览
name
BtBrowse
Button6
text
返回
name
BtExit
textBox1
显示“出租序号”
textBox2
显示“影片序号”
textBox3
显示“顾客序号”
textBox6
显示“数量”
textBox7
显示“折扣”
textBox8
显示“押金”
textBox9
显示“职员号”
usingSystem.Data.OleDb;//必须手工引入
OleDbConnectionconnc=newOleDbConnection();//定义全局变量
OleDbCommandcommc1=newOleDbCommand();//分别创建连个命令对象,DataAdapter对象和DataSet对象对Purchase(采购表)和Stock(库存表)进行操作
OleDbCommandcommc2=newOleDbCommand();
OleDbDataAdaptermyDAc1=newOleDbDataAdapter();
OleDbDataAdaptermyDAc2=newOleDbDataAdapter();
DataSetds1=newDataSet();
DataSetds2=newDataSet();
privatevoidStr()//自定义函数,创建连接字符串
{
stringconstr="Provider=Microsoft.Jet.OLEDB.4.0;";
constr+="DataSource=FilmManager.mdb;";
connc.ConnectionString=constr;
connc.Open();
commc1.Connection=connc;
commc2.Connection=connc;
}
privatevoidClear()//自定义过程,清空各文本框内容
{
this.textBox1.Text="";this.textBox2.Text="";this.textBox3.Text="";
this.textBox6.Text="";this.textBox7.Text="";this.textBox8.Text="";
this.textBox9.Text="";
}
privatevoidBtLog_Click(objectsender,EventArgse)
{//“新顾客”按钮的单击事件
Customercs=newCustomer();//显示顾客管理窗体
cs.ShowDialog();
}
privatevoidBtClear_Click(objectsender,EventArgse)
{//“清除”按钮的单击事件
Clear();//调用自定义过程实现各文本框内容清空
}
privatevoidBtBrower_Click(objectsender,EventArgse)
{//“浏览”按钮的单击事件
HireBhb=newHireB();//调用出租影片管理浏览窗体
hb.ShowDialog();
}
privatevoidBtExit_Click(objectsender,EventArgse)
{//“返回”按钮的单击事件
this.Close();
}
privatevoidBtReturn_Click(objectsender,EventArgse)
{//“还片”按钮的单击事件
Returnfrf=newReturnf();//显示“还片管理”窗体
rf.ShowDialog();
}
privatevoidBtHire_Click(objectsender,EventArgse)
{
if(textBox1.Text==""){MessageBox.Show("“顾客序号”必填");return;}
if(textBox2.Text==""){MessageBox.Show("“影片序号”必填");return;}
if(textBox3.Text==""){MessageBox.Show("“出租序号”必填");return;}
if(textBox6.Text==""){MessageBox.Show("“数量”必填");return;}
if(textBox7.Text==""){MessageBox.Show("“折扣”必填");return;}
if(textBox9.Text==""){MessageBox.Show("“职员号”必填");return;}
try
{
this.Str();
myDAc1.SelectCommand=commc1;
commc1.CommandText="select*fromHire";
commc1.ExecuteNonQuery();
ds1.Clear();
this.myDAc1.Fill(ds1,"Hire");
myDAc2.SelectCommand=commc2;
commc2.CommandText="select*fromStock";
commc2.ExecuteNonQuery();
ds2.Clear();
this.myDAc2.Fill(ds2,"Stock");
//依次遍历stock(库存表)的各条记录,若有该影片的库存则可以出租,在Hire表中添加一条出租记录,在Stock(库存中相应影片的数量减一)
for(inti=0;i { if(Convert.ToString(ds2.Tables["Stock"].Rows[i]["FilmID"])==Convert.ToString(textBox2.Text)&&Convert.ToInt32(ds2.Tables["Stock"].Rows[i]["Amount"])>=Convert.ToInt32(textBox6.Text)) { stringins="insertintoHire(HireID,FilmID,CustomerID,Amount,Discount,"; ins+="Deposit,EmployeeID)values('"+textBox1.Text+"','"+textBox2.Text+"','"; ins+=textBox3.Text+"',"; ins+=textBox6.Text+","+textBox7.Text+","+textBox8.Text+",'"; ins+=textBox9.Text+"')"; intch=Convert.ToInt32(ds2.Tables["Stock"].Rows[i]["Amount"])-Convert.ToInt32(this.textBox6.Text); stringupstr="updateStocksetAmount="+Convert.ToString(ch)+"whereFilmID='"+textBox2.Text+"'"; commc1.CommandText=ins; commc1.ExecuteNonQuery(); commc2.CommandText=upstr; commc2.ExecuteNonQuery(); ds1.Clear(); this.myDAc1.Fill(ds1,"Hire"); ds2.Clear(); this.myDAc2.Fill(ds2,"Stock"); } } } catch(Exceptionoe) { MessageBox.Show(oe.Message,"Error"); } finally { if(connc.State==ConnectionState.Open) connc.Close(); } Clear();//清空各文本框的值 } } } 出租影片管理浏览窗体(HireB.cs)设计 在窗体拖入1个label控件,1个dataGrid控件,并设置如下: HireB text 出租影片管理浏览 Label1 text 出租影片管理浏览 usingSystem.Data.OleDb;//手工引入该命名空间 OleDbConnectionconnc=newOleDbConnection();//定义全局变量 OleDbCommandcommc=newOleDbCommand(); OleDbDataAdaptermyDAc=newOleDbDataAdapter(); DataSetds=newDataSet(); privatevoidHireB_Load(objectsender,EventArgse) { try { stringmyconStr="Provider=Microsoft.Jet.OLEDB.4.0;"; myconStr+="DataSource=FilmManager.mdb;"; connc.ConnectionString=myconStr; connc.Open(); commc.Connection=connc; stringsql="select*fromFilm"; commc.CommandText="select*fromHire"; myDAc.SelectCommand=commc; myDAc.Fill(ds,"Hire"); dataGrid1.SetDataBinding(ds,"Hire"); } catch(Exceptionoe) { MessageBox.Show(oe.Message,"Error"); } finally { if(connc.State==ConnectionState.Open) connc.Close(); } } } 还片管理窗体设计(Returnf.cs)设计 在窗体上拖入12个label控件,8个button控件,10个textbox控件,并设置如下: 控件 属性 设置值 说明 Returnf text 还片管理 label1 text 出租序号: label2 text 影片序号: label3 text 顾客序号: label4 text 数量: label5 text 张: label6 text 租片日期: Label7 text 折扣 Label8 text 还片日期: Label9 text 租金: Label10 text 职员: Label11 text 请输入要还片子的出租序号: 还片管理 Label12 text 还片管理 Button1 text |< name BtFirst Button2 text < name BtPre Button3 text > name BNext Button4 text >| name BtEnd Button5 text 还片 name BtReturn Button6 text 清除 name BtClear Button7 text 浏览 name BtBrowse Button8 text 返回 name BtExit textBox1 显示“出租序号” textBox2 显示“影片序号” textBox3 显示“顾客序号” textBox4 显示“租片日期” textBox5 显示“还片日期” textBox6 显示“数量” textBox7 显示“折扣” textBox8 显示“租金” textBox9 显示“职员” textBox10 输入要还片子的出租序号 usingSystem.Data.OleDb;//必须手工引入 OleDbConnectionconnc=newOleDbConnection();//定义全局变量 OleDbCommandcommc1=newOleDbCommand();//分别创建连个命令对象,DataAdapter对象和DataSet对象对Purchase(采购表)和Stock(库存表)进行操作 OleDbCommandcommc2=newOleDbCommand(); OleDbDataAdaptermyDAc1=newOleDbDataAdapter(); OleDbDataAdaptermyDAc2=newOleDbDataAdapter(); DataSetds1=newDataSet(); DataSetds2=newDataSet(); privateBindingManagerBaseNavigator; privatevoidStr()//自定义函数,创建连接字符串 { stringconstr="Provider=Microsoft.Jet.OLEDB.4.0;"; constr+="DataSource=FilmManager.mdb;"; connc.ConnectionString=constr; connc.Open(); commc1.Connection=connc; commc2.Connection=connc; } privatevoidBtReturn_Click(objectsender,EventArgse) { try { this.Str(); myDAc1.SelectCommand=commc1; commc1.CommandText="select*fromHire"; commc1.ExecuteNonQuery(); ds1.Clear(); this.myDAc1.Fill(ds1,"Hire"); myDAc2.SelectCommand=commc2; commc2.CommandText="select*fromStock"; commc2.ExecuteNonQuery(); ds2.Clear(); this.myDAc2.Fill(ds2,"Stock"); if(this.textBox8.Text=="") { MessageBox.Show("还未计算“租金”"); return; } stringupd="updateHiresetRent="+textBox8.Text+",DueDate='"+System.DateTime.Now+"'whereHireID='"+textBox10.Text+"'"; commc1.CommandText=upd; commc1.ExecuteNonQuery(); ds1.Clear(); this.myDAc1.Fill(ds1,"Hire"); for(inti=0;i { if(Convert.ToString(ds2.Tables["Stock"].Rows[i]["FilmID"])==Convert.ToString(textBox2.Text)) { intch=Convert.ToInt32(ds2.Tables["Stock"].Rows[i]["Amount"])+Convert.ToInt32(this.textBox6.Text); stringupstr="updateStocksetAmount="+Convert.ToString(ch)+"whereFilmID='"+textBox2.Text+"'"; commc2.CommandText=upstr; commc2.ExecuteNonQuery(); ds2.Clear(); this.myDAc2.Fill(ds2,"Stock"); } } } catch(Exceptionoe) { MessageBox.Show(oe.Message,"Error"); } finally { if(connc.State==ConnectionState.Open) connc.Close(); } this.textBox1.Text="";this.textBox2.Text="";this.textBox3.Text=""; this.textBox4.Text="";this.textBox5.Text="";this.textBox6.Text=""; this.textBox7.Text="";this.textBox8.Text="";this.textBox9.Text=""; } privatevoidBtClear_Click(objectsender,EventArgse) { this.textBox1.Text="";this.textBox2.Text="";this.textBox3.Text=""; this.textBox4.Text="";this.textBox5.Text="";this.textBox6.Text=""; this.textBox7.Text="";this.textBox8.Text="";this.textBox9.Text=""; } privatevoidBtBrower_Click(objectsender,EventArgse) {//"浏览"按钮的单击事件 Returnfbrf=newReturnfb();//显示“还片管理浏览”窗体 rf.ShowDialog(); } privatevoidBtExit_Click(objectsender,EventArgse) { this.Close(); } privatevoidReturnf_Load(objectsender,EventArgse) {//窗体的加载事件 try { this.Str(); myDAc1.SelectCommand=commc1; commc1.CommandText="select*fromHire"; commc1.ExecuteNonQuery(); ds1.Clear(); this.myDAc1.Fill(ds1,"Hire"); Navigator=this.BindingContext[ds1,"Hire"]; this.textBox1.DataBindings.Add("Text",ds1,"Hire.HireID"); this.textBox2.DataBindings.Add("Text",ds1,"Hire.FilmID"); this.textBox3.DataBindings.Add("Text",ds1,"Hire.CustomerID"); this.textBox7.DataBindings.Add("Text",ds1,"Hire.Discount"); this.textBox6.DataBindings.Add("Text",ds1,"Hire.Amount"); this.textBox9.DataBindings.Add("Text",ds1,"Hire.EmployeeID"); this.textBox4.DataBindings.Add("Text",ds1,"Hire.HireDate"); this.textBox5.Text=Convert.ToString(System.DateTime.Now); } catch(Exceptionoe) { MessageBox.Show(oe.Message); } finally { if(connc.State==ConnectionState.Open) connc.Close(); } } privatevoidBtFirst_Click(objectsender,EventArgse) {//“|<
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 影片 出租 管理
![提示](https://static.bingdoc.com/images/bang_tan.gif)