IT计算机图书管理系统C源代码Word文档下载推荐.docx
《IT计算机图书管理系统C源代码Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《IT计算机图书管理系统C源代码Word文档下载推荐.docx(62页珍藏版)》请在冰点文库上搜索。
![IT计算机图书管理系统C源代码Word文档下载推荐.docx](https://file1.bingdoc.com/fileroot1/2023-5/10/cc77590b-a34e-425b-9c99-55d434f5dae6/cc77590b-a34e-425b-9c99-55d434f5dae61.gif)
listBox2.Items.Clear();
listBox3.Items.Clear();
if(sql.rows.GetLength(0)!
=0)
for(inti=0;
i<
sql.rows.GetLength(0);
i++)
listBox1.Items.Add(sql.rows[i,0].ToString());
listBox2.Items.Add(sql.rows[i,1].ToString());
listBox3.Items.Add(sql.rows[i,2].ToString());
else
listBox1.Text="
listBox2.Text="
listBox3.Text="
MessageBox.Show("
无符合查询条件的结果!
"
提示"
);
privatevoidForm_BuyAndSale_Load(objectsender,EventArgse)
//将窗体的任务栏隐藏
this.FormBorderStyle=System.Windows.Forms.FormBorderStyle.None;
sql=newSQL(Form_load.connectionString);
sql.ExecuteSQL("
select*fromts_tushuxiaoshou"
show();
lastSQL="
select*fromts_tushuxiaoshou"
privatevoidbutThisQuarter_Click(objectsender,EventArgse)
intmonth=System.DateTime.Now.Month;
intspace=(3-month%3)%3;
stringmin=System.DateTime.Now.Year.ToString()+STR.add0(Convert.ToString(month+space-2))+"
00"
stringmax=System.DateTime.Now.Year.ToString()+STR.add0(Convert.ToString(month+space))+"
99"
select*fromts_tushuxiaoshouwheresaledate>
'
+min+"
andsaledate<
+max+"
privatevoidbutThisYear_Click(objectsender,EventArgse)
stringmin=System.DateTime.Now.Year.ToString()+"
0000"
stringmax=System.DateTime.Now.Year.ToString()+"
9999"
privatevoidbutAll_Click(objectsender,EventArgse)
privatevoidbutSearch_Click(objectsender,EventArgse)
try
int.Parse(Min.Text);
int.Parse(Max.Text);
catch
数值格式不正确!
Min.Text="
Max.Text="
return;
if(int.Parse(Min.Text)>
int.Parse(Max.Text))
最小值应小于或等于最大值!
select*fromts_tushuxiaoshouwheresalequantitybetween"
+Min.Text+"
and"
+Max.Text);
+Max.Text;
privatevoidbutton1_Click(objectsender,EventArgse)
this.Close();
}
publicpartialclassForm_Customer:
publicForm_Customer()
stringoldcustomerID="
publicstaticstringCUSTOMERID="
publicstaticstringCUSTOMERNAME="
customerID.Text=sql.rows[sql.getPos(),0].ToString();
customername.Text=sql.rows[sql.getPos(),1].ToString();
customerinfo.Text=sql.rows[sql.getPos(),2].ToString();
customeraddress.Text=sql.rows[sql.getPos(),3].ToString();
customertelephone.Text=sql.rows[sql.getPos(),4].ToString();
customersex.Text=sql.rows[sql.getPos(),5].ToString();
customeremail.Text=sql.rows[sql.getPos(),6].ToString();
customerID.Text="
customername.Text="
customerinfo.Text="
customeraddress.Text="
customertelephone.Text="
customersex.Text="
customeremail.Text="
CUSTOMERID=customerID.Text;
CUSTOMERNAME=customername.Text;
privatevoidForm_Customer_Load(objectsender,EventArgse)
select*fromts_kehuorderbycustomerID"
privatevoidAddOrder_Click(objectsender,EventArgse)
if(customerID.Text!
="
)
Form_Customer_AddOrderchild=newForm_Customer_AddOrder();
child.ShowDialog();
请先选择一个客户!
privatevoidbutAlter_Click(objectsender,EventArgse)
if(butAlter.Text=="
修改"
butAlter.Text="
更新"
oldcustomerID=customerID.Text;
customerID.ReadOnly=false;
customername.ReadOnly=false;
customerinfo.ReadOnly=false;
customeraddress.ReadOnly=false;
customertelephone.ReadOnly=false;
customersex.ReadOnly=false;
customeremail.ReadOnly=false;
butAdd.Enabled=false;
butDelete.Enabled=false;
butFirst.Enabled=false;
butPrev.Enabled=false;
butNext.Enabled=false;
butLast.Enabled=false;
butSearch.Enabled=false;
butLookOverOrders.Enabled=false;
butShowAll.Enabled=false;
AddOrder.Enabled=false;
if(sql.ExecuteSQL("
updatets_kehusetcustomerID='
+customerID.Text
+"
customername='
+customername.Text
customerinfo='
+customerinfo.Text
customeraddress='
+customeraddress.Text
customertelephone='
+customertelephone.Text
customersex='
+customersex.Text
customeremail='
+customeremail.Text+"
wherecustomerID='
+oldcustomerID+"
==false||
updatets_kehudingdansetcustomerID='
==false)
customerID.ReadOnly=true;
customername.ReadOnly=true;
customerinfo.ReadOnly=true;
customeraddress.ReadOnly=true;
customertelephone.ReadOnly=true;
customersex.ReadOnly=true;
customeremail.ReadOnly=true;
butAdd.Enabled=true;
butDelete.Enabled=true;
butFirst.Enabled=true;
butPrev.Enabled=true;
butNext.Enabled=true;
butLast.Enabled=true;
butSearch.Enabled=true;
butLookOverOrders.Enabled=true;
AddOrder.Enabled=true;
butShowAll.Enabled=true;
privatevoidbutAdd_Click(objectsender,EventArgse)
if(butAdd.Text=="
添加"
butAdd.Text="
提交"
butAlter.Enabled=false;
if(this.customeraddress.Text=="
请输入完整信息!
elseif(this.customeremail.Text=="
elseif(this.customerID.Text=="
请输入完整信息"
elseif(this.customerinfo.Text=="
请输入完整信息!
elseif(this.customername.Text=="
elseif(this.customersex.Text=="
insertintots_kehuvalues('
+customerID.Text+"
'
+customername.Text+"
+customerinfo.Text+"
+customeraddress.Text+"
+customertelephone.Text+"
+customersex.Text+"
)"
butAlter.Enabled=true;
catch(Exceptione1)
MessageBox.Show(e1.Message);
privatevoidbutDelete_Click(objectsender,EventArgse)
deletefromts_kehuwherecustomerID='
privatevoidbutShowAll_Click(objectsender,EventArgse)
if(comboBox1.Text=="
客户名称"
if(comboBox2.Text=="
精确"
select*fromts_kehuwherecustomername='
+textForSearch.Text+"
orderbycustomerID"
select*fromts_kehuwherecustomernamelike'
%"
%'
select*fromts_kehuwherecustomeremail='
select*fromts_kehuwherecustomeremaillike'
privatevoidbut