c#中DataGrid的數據新增編輯刪除操作代碼
2024-07-21 02:23:19
供稿：網友
private void deletedevdata()
??{
???int deletenum=0;
???//刪除選中的某一行或多行記錄，調用datagrid的isselected（i）函數，如果函數返回結果為true，則表示該行被選中
???arraylist arrlist = new arraylist();
???for(int i=0;i???{???
????if(dtg_basicdatainfo.isselected(i)==true)
????{?
?????f_wr_public.vo_devspec vo_devspec_delete = new f_wr_public.vo_devspec();
?????//表中第11列保存的是設備類型的主鍵，但沒有顯示在表中。
?????vo_devspec_delete.devspecid = int64.parse(devspec.rows[i][10].tostring());
?????arrlist.add(vo_devspec_delete);
?????deletenum++;
????}
???}
???if (deletenum !=0)
???{
????if (messagebox.show ("你確定要刪除這些數據嗎？", "刪除數據",
?????messageboxbuttons.yesno, messageboxicon.question)== dialogresult.yes)
????{
?????f_wr_public.f_wr_public f_wr_public = new f_wr_public.f_wr_public();?????
?????f_wr_public.vo_devspec[] arrvo_devspec_delete = new f_wr_public.vo_devspec[deletenum];
?????ienumerator ienum = arrlist.getenumerator();
?????int deleteindex=0;
?????while(ienum.movenext())
?????{
??????arrvo_devspec_delete[deleteindex] = (f_wr_public.vo_devspec)ienum.current;
??????arrvo_devspec_delete[deleteindex].col=int64.maxvalue;
??????arrvo_devspec_delete[deleteindex].devtypeid=int64.maxvalue;
??????arrvo_devspec_delete[deleteindex].num=int64.maxvalue;
??????arrvo_devspec_delete[deleteindex].row=int64.maxvalue;
??????deleteindex++;
?????}
?????f_wr_public.removedevspec(arrvo_devspec_delete);
?????messagebox.show ("刪除成功！", "刪除數據",messageboxbuttons.ok, messageboxicon.information);
????}
????else
????{
?????return;
????}
???}
???else
???{
????messagebox.show ("未選中所要刪除的數據！", "刪除數據", messageboxbuttons.ok, messageboxicon.warning);
???}
??}
?
private void querydevspec()
??{
???try
???{
????devspec.clear();
????f_wr_public.f_wr_public f_wr_public = new f_wr_public.f_wr_public();
????f_wr_public.vo_devspec vo_devspec = new f_wr_public.vo_devspec();
????vo_devspec.col=int64.maxvalue;
????vo_devspec.devspecid=int64.maxvalue;
????vo_devspec.devtypeid=int64.parse(cbo_devtype.selectedvalue.tostring());
????vo_devspec.num=int64.maxvalue;
????vo_devspec.row=int64.maxvalue;
????f_wr_public.vo_devspec[] arrvo_devspec=f_wr_public.querydevspec(vo_devspec);
????if(arrvo_devspec!=null)
????{
?????for(int i=0;i?????{
??????f_wr_public.vo_devspec vo_devspec_result = arrvo_devspec[i];
??????datarow myrow;
??????myrow = devspec.newrow();
??????myrow["設備大類"] =dic_devspec[vo_devspec_result.devtypeid].displaymember.tostring();
??????myrow["規格類型"] = vo_devspec_result.spectype;
??????myrow["生產廠家"] = vo_devspec_result.manufacturer;
??????myrow["長"] = [email protected];
??????myrow["寬"] = vo_devspec_result.width;
??????myrow["高"] = vo_devspec_result.high;
??????if ( vo_devspec_result.num != int64.maxvalue)
??????{
???????myrow["數量"] = vo_devspec_result.num;
??????}
??????else
???????myrow["數量"] ="";
??????if ( vo_devspec_result.row != int64.maxvalue)
??????{
???????myrow["行"] = vo_devspec_result.row;
??????}
??????else
???????myrow["行"] = "";
??????if ( vo_devspec_result.col != int64.maxvalue)
??????{
???????myrow["列"] = vo_devspec_result.col;
??????}
??????else
???????myrow["列"] = "";;
??????
??????myrow["排列方式"] = vo_devspec_result.disposetype;
??????myrow["設備型號"] = vo_devspec_result.devspecid;
??????devspec.rows.add(myrow);
?????}
?????devspec.acceptchanges();
?????//設置dtg_basicdatainfo的datamember為devspec
?????dtg_basicdatainfo.datamember = devspec.tostring();
?????dtg_basicdatainfo.datasource=dataset1;
?????devtablestyle.mappingname="devspec";
?????rowcounts=arrvo_devspec.length;
????}
????else
????{
?????rowcounts=0;
????}
????dtg_basicdatainfo.readonly = true;
???}
???catch(exception ee)
???{
????
????messagebox.show (ee.tostring(), "error",
?????messageboxbuttons.ok, messageboxicon.information);
???}
??}
?
?private void savedevdata()
??? {
???try
???{
????f_wr_public.f_wr_public f_wr_public = new f_wr_public.f_wr_public();
????//如果某行的狀態為added，則表示該行的數據是新增加的
????datarow[] datarowadd = devspec.select(null,null,dataviewrowstate.added);
????int mcount= datarowadd.length;
????if (mcount != 0)
????{
?????f_wr_public.vo_devspec[] arrvo_devspec_add = new f_wr_public.vo_devspec[mcount];
?????for(int i=0;i?????{
??????f_wr_public.vo_devspec vo_devspec = new f_wr_public.vo_devspec();
??????vo_devspec.col=int64.maxvalue;
??????vo_devspec.num=int64.maxvalue;
??????vo_devspec.row=int64.maxvalue;
??????vo_devspec.devtypeid =int64.parse(cbo_devtype.selectedvalue.tostring());
??????vo_devspec.spectype=datarowadd[i][1].tostring();
??????vo_devspec.manufacturer=datarowadd[i][2].tostring();
[email protected]=datarowadd[i][3].tostring();
??????vo_devspec.width=datarowadd[i][4].tostring();
??????vo_devspec.high=datarowadd[i][5].tostring();
??????if(!datarowadd[i][6].tostring().equals(""))
??????{
???????vo_devspec.num= int64.parse(datarowadd[i][6].tostring());
??????}
??????if(!datarowadd[i][7].tostring().equals(""))
??????{
???????vo_devspec.row= int64.parse(datarowadd[i][7].tostring());
??????}
??????if(!datarowadd[i][8].tostring().equals(""))
??????{
???????vo_devspec.col= int64.parse(datarowadd[i][8].tostring());
??????}
??????vo_devspec.disposetype=datarowadd[i][9].tostring();
??????vo_devspec.devspecid=int64.maxvalue;
????????
????????
??????arrvo_devspec_add[i] = vo_devspec;
?????}
?????f_wr_public.adddevspec(arrvo_devspec_add);
?????messagebox.show ("增加成功！", "增加數據",messageboxbuttons.ok, messageboxicon.information);
????}
????//如果某行的狀態為modifiedcurrent，則表示該行的數據被修改過
????datarow[] datarowmodify = devspec.select(null,null,dataviewrowstate.modifiedcurrent);
????int intdatarowmodify = datarowmodify.length;
????if (intdatarowmodify != 0)
????{
?????f_wr_public.vo_devspec[] arrvo_devspec_modify = new f_wr_public.vo_devspec[intdatarowmodify];
?????for(int i=0;i?????{
??????f_wr_public.vo_devspec vo_devspec = new f_wr_public.vo_devspec();
??????//表中第11列保存的是設備類型的主鍵，但沒有顯示在表中。
??????vo_devspec.devspecid= int64.parse(datarowmodify[i][10].tostring());
??????//
??????vo_devspec.col=int64.maxvalue;
??????vo_devspec.num=int64.maxvalue;
??????vo_devspec.row=int64.maxvalue;
??????vo_devspec.spectype=datarowmodify[i][1].tostring();
??????vo_devspec.manufacturer=datarowmodify[i][2].tostring();
[email protected]=datarowmodify[i][3].tostring();
??????vo_devspec.width=datarowmodify[i][4].tostring();
??????vo_devspec.high=datarowmodify[i][5].tostring();
??????if(!datarowmodify[i][6].tostring().equals(""))
??????{
???????vo_devspec.num= int64.parse(datarowmodify[i][6].tostring());
??????}
??????if(!datarowmodify[i][7].tostring().equals(""))
??????{
???????vo_devspec.row= int64.parse(datarowmodify[i][7].tostring());
??????}
??????if(!datarowmodify[i][8].tostring().equals(""))
??????{
???????vo_devspec.col= int64.parse(datarowmodify[i][8].tostring());
??????}
??????vo_devspec.disposetype=datarowmodify[i][9].tostring();
??????arrvo_devspec_modify[i] = vo_devspec;
?????}
???????
?????f_wr_public.modifydevspec(arrvo_devspec_modify);
?????messagebox.show ("保存成功！", "保存數據",messageboxbuttons.ok, messageboxicon.information);
????}
????devspec.acceptchanges();
???}
???catch(exception ee)
???{
????messagebox.show (ee.tostring(), "error",messageboxbuttons.ok, messageboxicon.information);
???}
??? }
?
?
private void queryifsavedevdata()
??{
???/*該函數查詢dev表中是否有未保存的數據，如果有，則詢問是否保存，
??? * 如果用戶回答需要保存，則調用savedevdata過程保存數據,如果回答否，
??? * 則調用查詢過程querydevspec刷新頁面*/
???datarow[] datarowadd1 = devspec.select(null,null,dataviewrowstate.added);
???int maddcount1= datarowadd1.length;
???datarow[] datarowmodify1 = devspec.select(null,null,dataviewrowstate.modifiedcurrent);
???int mmodifycount1=datarowmodify1.length;
???if (maddcount1!=0 || mmodifycount1 !=0)
???{
????if (messagebox.show ("有編輯過的數據未保存，需要保存嗎？", "提示",
?????messageboxbuttons.yesno, messageboxicon.question)== dialogresult.yes)
?????savedevdata();
????else
?????querydevspec();
???}
??}
?
