采購管理子系統(tǒng)詳細(xì)設(shè)計說明書

NF-ERP之采購管理子系統(tǒng)幫助采購人員控制并完成從采購計劃、采購執(zhí)行到到采購質(zhì)檢等全部過程具有最佳的供貨狀態(tài)，重點(diǎn)實(shí)現(xiàn)的目標(biāo)如下：現(xiàn)對供應(yīng)商信息的動態(tài)管理和維護(hù)；學(xué)、準(zhǔn)確、靈活的制定采購計劃，指導(dǎo)和規(guī)范企業(yè)日常的采購經(jīng)營活動；證采購產(chǎn)品的及時與準(zhǔn)確，確保生產(chǎn)的持續(xù)進(jìn)行；物資采購的制定，企業(yè)日常到貨、到貨檢驗(yàn)、付款結(jié)算進(jìn)行跟蹤和追溯。b本項(xiàng)目的任務(wù)提出者：黃燕、游夢云、蘭軍、謝萬林游夢云、蘭軍、謝萬林部的所有員工磅過磅、倉庫收料入庫的依據(jù)。算的采購發(fā)票，都是在途發(fā)票P統(tǒng)的結(jié)構(gòu)報表管理發(fā)票管理質(zhì)檢管理調(diào)度管理計劃管理供應(yīng)商推薦供應(yīng)商檔案貨品檔案客戶化設(shè)置登記貨品檔案審核貨品檔案貨品I級設(shè)置貨品II級設(shè)置貨品III級設(shè)置報表管理發(fā)票管理質(zhì)檢管理調(diào)度管理計劃管理供應(yīng)商推薦供應(yīng)商檔案貨品檔案客戶化設(shè)置登記貨品檔案審核貨品檔案貨品I級設(shè)置貨品II級設(shè)置貨品III級設(shè)置NFNF-ERP采購管理系發(fā)票信息發(fā)票信息價預(yù)覽薦單案發(fā)票信息單薦案發(fā)票信息單薦薦貨品用途貨品用途供應(yīng)商推薦采購員貨品檔案供應(yīng)商檔案計劃管理調(diào)度管理質(zhì)檢管理發(fā)票管理供應(yīng)商推薦采購員貨品檔案供應(yīng)商檔案計劃管理調(diào)度管理質(zhì)檢管理發(fā)票管理客客戶化設(shè)置報表管理報表管理加，I級的添加可以結(jié)合符合規(guī)定寫，但I(xiàn)I級貨品要根據(jù)I級類型類型來添加，三級類型是根據(jù)II級中的類型來添加；還有對貨品用途的設(shè)置，主要是用途的添加；還有權(quán)限的管理，分為管理員和采購員，能夠?qū)Ω髯缘墓芾矸秶龀鲆?guī)定和調(diào)整。貨品III進(jìn)行添加；還有對貨品的用途進(jìn)行添加；管理員和采購人員對該系統(tǒng)的管理行授權(quán)貨品I貨品I權(quán)限設(shè)置II客戶化設(shè)置貨貨品用UI面]圖3.2添加貨品I級圖3.3貨品II級查詢圖3.4貨品II添加圖3.5貨品III查詢圖3.6貨品III添加圖3.7貨品用途查詢圖3.8貨品用途添加圖3.9權(quán)限設(shè)置/獲取角色列表publicvoidGetList(){ListRoleInfostau.Find(p=>true).ToList();forintii<st.Count;i++){RadioButtonListItemsAddnewListItemstirolesNameirolesIdToString}}/獲取父節(jié)點(diǎn)的資源publicvoidGetCh(){thisRepeaterDataSource=re.Find(p=>p.parentNode==null).ToList();thisRepeater.DataBind();}/獲取父節(jié)點(diǎn)之下的資源publicvoidGetChild(objectsender,EventArgse){oreachRepeaterItemiteminRepeaterItems{if(item.ItemType==ListItemType.Item||item.ItemType==tItemTypeAlternatingItem{CheckBoxcbkitemFindControlee)asCheckBox;//cbk.Checked=false;bkChecked{Repeaterrepeaitem.FindControl("Repeater2")asRepeater;repea.DataSource=re.Find(p=>p.parentNode==ConvertToIntcbkCssClassToList();repeaDataBind);}{Repeaterrepeaitem.FindControl("Repeater2")asRepeater;repeaDataSource=null;repeaDataBind);}}}}/角色按鈕改變時改變protectedvoidRadioButtonList1_SelectedIndexChanged(objectsender,EventArgse){rChList<RolesNodeInfo>listr=GetSRPConvertToIntthisRadioButtonListSelectedValue));//父節(jié)點(diǎn)選中的和展開子節(jié)點(diǎn)forintii<listr.Count;i++){oreachRepeaterItemiteminRepeaterItems{if(item.ItemType==ListItemType.Item||item.ItemType==tItemTypeAlternatingItem{CheckBoxcbkitemFindControlee)asCheckBox;ifConvertToIntcbkCssClass)==listr[i].nodeId){kCheckedtrueChildnullnull}}}}/選擇子節(jié)點(diǎn)選中的forintii<listr.Count;i++){oreachRepeaterItemiteminRepeaterItems{if(item.ItemType==ListItemType.Item||item.ItemType==tItemTypeAlternatingItem{CheckBoxcbkitemFindControlee)asCheckBox;ifConvertToIntcbkCssClass)==listr[i].nodeId){Repeaterrepeaitem.FindControl("Repeater2")asRepeater;forintjj<listr.Count;j++){oreachRepeaterItemiteminrepeaItems{if(item2.ItemType==ListItemType.Item||itemItemTypeListItemTypeAlternatingItem){CheckBoxcb=item2.FindControl("cc")asoxif(Convert.ToInt32(cb.CssClass)==trjnodeId{Checkedtrue}}}}}}}}}BoxpublicvoidClearCh(){oreachRepeaterItemiteminRepeaterItems{if(item.ItemType==ListItemType.Item||item.ItemType==tItemTypeAlternatingItem{CheckBoxcbkitemFindControlee)asCheckBox;kCheckedfalse}}}listpublicList<RolesNodeInfo>GetSRP(intid){returnstrFind(p=>p.rolesId==Convert.ToInt32(id)).ToList();}/修改角色資源protectedvoidButton1_Click(objectsender,EventArgse){intcount0;ListintintlinewListint);//CHeckBox全部選中資源idoreachRepeaterItemiteminRepeaterItems{if(item.ItemType==ListItemType.Item||item.ItemType==tItemTypeAlternatingItem{CheckBoxcbkitemFindControlee)asCheckBox;bkChecked{intliAddConvertToIntcbk.CssClass));Repeaterrepeaitem.FindControl("Repeater2")asRepeater;oreachRepeaterItemiteminrepeaItems{if(item2.ItemType==ListItemType.Item||item2.ItemType==tItemTypeAlternatingItem{CheckBoxcbitemFindControlcc")asCheckBox;bChecked{intliAddConvertToIntcbCssClass));}}}}{t}}}登記貨登記貨查詢貨變更貨ifcountRepeater1.Items.Count){ClientScript.RegisterStartupScript(GetType(),Guid.NewGuid().ToString(),ipt}{intidConvertToInt2(RadioButtonList1.SelectedValue);ListRolesNodeInfolistr=GetSRP(id);telistrforintii<intli.Count;i++){RolesNodeInforolesnodenewRolesNodeInfo();rolesnoderolesId=id;rolesnodenodeId=intli[i];olesnode}ClientScript.RegisterStartupScript(GetType(),Guid.NewGuid().ToString(),}}問題無模塊描述本模塊主要包括四個子模塊，主要是：登記貨品檔案，審核貨品檔案，查詢貨品檔案，變更貨品檔案；主要流程是：登記貨品檔案—對登記的貨品檔案進(jìn)行審核-審核通過的貨品對于貨品的檔案進(jìn)行更改2功能品檔案：登記貨品檔案的貨品檔案進(jìn)行審核檔案：對已經(jīng)通過審核的貨品進(jìn)行條件查詢對已經(jīng)通過審核的貨品進(jìn)行變更流程邏輯]審審核貨4UI展示所對應(yīng)的表示界面]如：圖4.2等待審核圖4.3貨品審核圖4.4查詢貨品圖4.5貨品變更圖4.6變更貨品核心代碼//接收傳過來的ProIdintproIdConvertToInt2(Request["proId"].ToString());ProductInfoDAproiDAnewProductInfoDA();varpro=proiDA.Find(p=>ductId==proId).FirstOrDefault();thistxtproductNameText=ductName;/下拉列表框顯示所有的用途varresert=proDA.Find(p=>p.typeFather==0).ToList();opproductTypeIDataSourceresertdropproductTypeIDataValueFieldtypeIddropproductTypeIDataTextFieldtypeNamepproductTypeIDataBind/保存變更的貨品信息ProductInfoDAproDAnewProductInfoDA();intproIdConvertToInt2(Request["proId"].ToString());varpro=proDA.Find(p=>ductId==proId).FirstOrDefault();ductName=this.txtproductName.Text.Trim();pro.Cess=string.IsNullOrEmpty(this.txtCess.Text.Trim())?null:newNullable<decimal>(Convert.ToDecimal(this.txtCess.Text.Trim()));pro.useId=Convert.ToInt32(this.dropproductUse.SelectedItem.Value.Trim());pro.typeId=Convert.ToInt32(this.dropproductTypeIII.SelectedItem.Value.Trim());ductBreed=this.txtproductBreed.Text.Trim();尚未解決的問題無ductSpec=this.txtproductSpec.Text.Trim();pro.barCode=this.txtbarCode.Text.Trim();pro.Unit=this.txtUnit.Text.Trim();pro.inPrice=Convert.ToDecimal(this.txtinPrice.Text.Trim());pro.outPrice=Convert.ToDecimal(this.txtoutPrice.Text.Trim());pro.upperLimit=this.txtupperLimit.Text.Trim();pro.lowerLimit=this.txtlowerLimit.Text.Trim();pro.employeeId=Convert.ToInt32(this.dropemployeeName.SelectedItem.Value.Trim());pro.registerDate=Convert.ToDateTime(this.txtregisterDate.Text.Trim());pro.Remark=this.txtRemark.Text.Trim();proDA.Save();ResponseRedirectProductEditaspx");}/當(dāng)選擇I級貨品?II級貨品自動?變?yōu)镮級貨品的子類protectedvoiddropproductTypeI_SelectedIndexChanged(objectsender,EventArgse){intidConvertToInt32(dropproductTypeI.SelectedItem.Value);varret=proDA.Find(p=>p.typeFather==id2).ToList();thisdropproductTypeIIDataSource=ret;thisdropproductTypeIIDataValueField="typeId";thisdropproductTypeIIDataTextField="typeName";thisdropproductTypeIIDataBind();}IIprotectedvoiddropproductTypeII_SelectedIndexChanged(objectsender,EventArgse){intidConvertToInt32(dropproductTypeII.SelectedItem.Value);varret=proDA.Find(p=>p.typeFather==id3).ToList();thisdropproductTypeIIIDataSource=ret;thisdropproductTypeIIIDataTextField="typeName";thisdropproductTypeIIIDataValueField="typeId";thisdropproductTypeIIIDataBind();}登記供登記供應(yīng)商檔案查詢供應(yīng)商檔案審核供應(yīng)商檔案本模塊主要是分為四個子模塊：登記供應(yīng)商檔案，審核供應(yīng)商檔案，查詢供應(yīng)商檔案，模塊對自身的功能都能順利的進(jìn)行，簡單易懂商檔案：主要是對供應(yīng)商的添加進(jìn)行登記經(jīng)登記的供應(yīng)商檔案信息但未審核的供應(yīng)商檔案信息進(jìn)行審核商檔案：對已經(jīng)審核通過的供應(yīng)商檔案進(jìn)行查詢，并且查看其詳細(xì)信息：對已經(jīng)審核通過的供應(yīng)商檔案進(jìn)行更新]檔案變變更供應(yīng)商檔案所對應(yīng)的表示界面]如：案圖5.2供應(yīng)商信息審核圖5.3供應(yīng)商信息審核圖5.4查詢供應(yīng)商信息圖5.5供應(yīng)商詳細(xì)信息圖5.6更新供應(yīng)商信息圖5.7修改供應(yīng)商信息IDintidConvertToInt(Request["supID"]);varsup=supInfoda.Find(p=>p.supplyId==id).FirstOrDefault();txtSupplyNameText=sup.supplyName;txtsupplyRelationText=sup.supplyRelation;txtrelationPhoneText=sup.relationPhone;txtphotoNumberText=sup.photoNumber;txtEmailText=sup.Email;txtpostalCodeText=sup.postalCode;txtfaxNumberText=sup.faxNumber;//登記人ddlemployeeDataSourceempInfodaFindp=>true).ToList();ddlemployeeDataValueFieldemployeeIdddlemployeeDataTextFieldemployeeNameemployeeDataBindvarrs=empInfoda.Find(p=>p.employeeId==ployeeIdFirstOrDefaultddlemployeeItemsFindByTextrsemployeeNameSelected=true;txtbankNameText=sup.bankName;txtbankNumberTextsup.bankNumber;txtlinkAddressTextsup.linkAddress;txtwebSiteText=sup.webSite;/貨品類型vartype1=protypeda.Find(p=>p.typeFather==0);ddltypeDataSourcetypeddltypeDataTextFieldtypeName;ddltypeDataValueFieldtypeId;ltypeDataBindintidConvertToInt2(ddltype1.SelectedItem.Value);vartype2=protypeda.Find(p=>p.typeFather==id1);ddltypeDataSourcetypeddltypeDataTextFieldtypeName;ddltypeDataValueFieldtypeId;ltypeDataBindintidConvertToInt2(ddltype2.SelectedItem.Value);vartype3=protypeda.Find(p=>p.typeFather==id2);ddltypeDataSourcetypeddltypeDataTextFieldtypeName;ddltypeDataValueFieldtypeId;ltypeDataBindtxtregisterDate.Text=sup.registerDate+"";txtTaxText=sup.Tax;txtRemarkTextsup.Remark;修改好的信息保存,isCheck為0intidConvertToInt(Request["supID"]);varinfo=supInfoda.Find(p=>p.supplyId==id).FirstOrDefault();infosupplyNametxtSupplyNameTextTrim);infosupplyRelationtxtsupplyRelationTextTrim);inforelationPhonetxtrelationPhoneTextTrim);infophotoNumbertxtphotoNumberTextTrim);infoEmailtxtEmailTextTrim);infopostalCodetxtpostalCodeTextTrim();infofaxNumbertxtfaxNumberTextTrim);intempIdConvertToInt(this.ddlemployee.SelectedItem.Value);nfoemployeeIdempIdinfobankNumbertxtbankNumberTextTrim);infolinkAddresstxtlinkAddressTextTrim();infowebSitetxtwebSiteTextTrim);infoBankddlBankSelectedItemTextTrim();ProductTypeInfoprotypeinfo=newProductTypeInfo();inttypeId=Convert.ToInt32(this.ddltype1.SelectedItem.Value);protypeinfo.typeId=typeId;infoTaxtxtTaxTextTrim);infoRemarktxtRemarkTextTrim();infotypeIdConvertToInt(ddltype3.SelectedItem.Value);inforegisterDateConvertToDateTimetxtregisterDateText);infoischeck0;fodaSaveprotectedvoidddltype1_SelectedIndexChanged(objectsender,EventArgse){intidConvertToInt2(ddltype1.SelectedItem.Value);vartype=protypeda.Find(p=>p.typeFather==id1).ToList();ddltypeDataSourcetypeddltypeDataTextFieldtypeName;ddltypeDataValueFieldtypeId;ltypeDataBindintidConvertToInt2(ddltype2.SelectedItem.Value);vartype=protypeda.Find(p=>p.typeFather==id2).ToList();ddltypeDataSourcetypeddltypeDataTextFieldtypeName;ddltypeDataValueFieldtypeId;ltypeDataBind}protectedvoidddltype2_SelectedIndexChanged(objectsender,EventArgse){intidConvertToInt2(ddltype2.SelectedItem.Value);vartype=protypeda.Find(p=>p.typeFather==id2).ToList();ddltypeDataSourcetypeddltypeDataTextFieldtypeName;ddltypeDataValueFieldtypeId;ltypeDataBind}題無本模塊主要包括四個子模塊：登記供應(yīng)商推薦，審核供應(yīng)商商推薦，查詢供應(yīng)商推薦，登記貨品供應(yīng)登記貨品供應(yīng)查詢供應(yīng)商推薦審核供應(yīng)商推薦查詢供應(yīng)商推薦-變更薦；本模塊的特點(diǎn)是簡單的操作方式，但功能齊全的供應(yīng)商進(jìn)行登記添加；記的供應(yīng)商推薦進(jìn)行審核商推薦：對已經(jīng)審核通過的供應(yīng)商推薦進(jìn)行條件查詢：對已經(jīng)審核通過的供應(yīng)商推薦信息進(jìn)行更改]推薦變變更供應(yīng)商推薦I所對應(yīng)的表示界面]如：圖6.1供應(yīng)商推薦登記圖6.2供應(yīng)商推薦登記圖6.3推薦供應(yīng)商圖6.4供應(yīng)商推薦審核圖6.5供應(yīng)商推薦審核/審核并調(diào)用方法，把狀態(tài)該為通過審核ifeCommandName"shenhe"){intidConvertToInt2(e.CommandArgument);/List<StockSystem.Model.SupplyInfo>ui=su.Find(p=>p.supplyId==id).ToList();yididBindDataResponseRedirectTextaspx");}ifeCommandName"delete"){upplyInfoDAuserinfoDAnewSupplyInfoDAintidConvertToInt2(e.CommandArgument);ListStockSystemModelSupplyInfo>ui=userinfoDA.Find(p=>p.supplyId==dToList/userinfoDA.Delete(ui);BindData}/查詢所有的數(shù)據(jù)，并且把狀態(tài)改為1kSystemDataDataContextsdnewStockSystemDataDataContextvarresult=(fromcinsd.GetTable<StockSystem.Model.SupplyInfo>()wherec.supplyId==idctcFirstOrDefaultresult.ischeck=1;itChanges/獲取選中復(fù)選框的值，并且存儲在回話里面intcount0;Listintintli=newList<int>();foreachRepeaterItemiteminRepeaterItems{ifitemItemType==ListItemType.Item||item.ItemType==stItemTypeAlternatingItem{CheckBoxcbkitemFindControlchkOrder")asCheckBox;cbkChecked{intidConvertToInt2(cbk.CssClass);tliAddid}{nt}}}ifcountRepeater1.Items.Count){ClientScriptRegisterStartupScriptGetTypeGuidNewGuid().ToString(),}ionlinintliResponseRedirectSupplyRecomaspx");//ClientScript.RegisterStartupScript(GetT/請求會話不為空時，執(zhí)行這些語句ifRequestids!=null){intidsConvertToInt2(Request["ids"]);yInfoDAproductdasnewSupplyInfoDArepsupplyDataSource=productdas.Find(p=>p.supplyId==ids).ToList();repsupplyDataBind);}ifSessionss!=null){RecommendInfouSession["ss"]asRecommendInfo;if(u.isCheck==1){RecommendInfoDAussnewRecommendInfoDA();}}/綁定供應(yīng)商privatevoidBindGongYingShang(){ifSessionlin!=null){lyInfoDAsdanewSupplyInfoDAListintlist=Session["lin"]asList<int>;ListModelSupplyInforesult=newList<Model.SupplyInfo>();forinti;i<list.Count;i++){resultAddsda.Find(s=>s.supplyId==list[i]).FirstOrDefault());}repsupplyDataSource=result;repsupplyDataBind);}}問題子模塊更改供應(yīng)商推薦還為開發(fā)成功述本模塊主要分為3個子模塊，主要是：制定采購計劃，審核采購計劃，查詢采購計劃；主要的功能是來制計劃，讓采購人員能夠按照采購計劃來進(jìn)行采購計劃：先生成采購計劃單，再進(jìn)行提交制定的采購計劃單進(jìn)行審核計劃：把已經(jīng)通過審核的采購計劃進(jìn)行條件查詢輯查詢采審查詢采審核采]制制定采UI所對應(yīng)的表示界面]如：圖7.1生成計劃單圖7.2制定采購計劃圖7.3審核采購計劃圖7.4查詢采購計劃碼//獲取repeater中控件的值intcount0;oreachRepeaterItemiteminreporderItems{ifitemItemType==ListItemType.Item||item.ItemType==stItemTypeAlternatingItem{CheckBoxcbkitemFindControlchkOrder")asCheckBox;cbkChecked{intidConvertToInt2(cbk.CssClass);sionOrderIdidResponseRedirectPlanaspx");break;}{nt}}}ifcountreporder.Items.Count){ClientScriptRegisterStartupScriptGetTypeGuidNewGuid().ToString(),}//獲取傳過來的pidintidConvertToInt2(Request["pid"]);labPlanIdTextid";EmployeeInfoDAempnewEmployeeInfoDA();varres=emp.Find(em=>true).ToList();lEmpDataSourceresddlEmpDataTextFieldemployeeNameddlEmpDataValueFieldemployeeIdEmpDataBindlabtimeTextDateTimeNow+"";DetailPlanInfoDAdplandanewDetailPlanInfoDA();varresultdplanda.Find(p=>p.planId==id).FirstOrDefault();ProductInfoDAproductnewProductInfoDA();varrs=product.Find(p=>ductId==ductId).FirstOrDefault();labIdTextresultdpId+"";labPIdTextresultproductId+"";labPNameTextrsproductNamelabPDescTextresultRemarklabPNumTextresultQuantity+"";決的問題無[給出對該基本模塊的簡要描述，主要說明安排設(shè)計本模塊的目的意義，并且，還要說行單；本模塊流程清晰，易操作，易維護(hù)。購執(zhí)行單：把采購計劃生成采購執(zhí)行單成的采購執(zhí)行單進(jìn)行審核制定制定采購執(zhí)行單查詢采購執(zhí)行單執(zhí)行單：把已經(jīng)通過審核的采購執(zhí)行單進(jìn)行查詢]審審核采購執(zhí)行單所對應(yīng)的表示界面]如：圖8.1制定采購執(zhí)行單圖8.2制定采購執(zhí)行單圖8.3查詢采購執(zhí)行單圖8.4審核采購執(zhí)行單圖8.5查詢采購執(zhí)行單//獲取repeater中的值intpidConvertToInt2(Session["PlanId"]);ExecteInfoDAedanewExecteInfoDA();ExecteInfoexnewExecteInfo();lanIdpidexproductIdConvertToIntlabpid.Text);xmakeUserddlEmpSelectedItemTextexmakeTimeConvertToDateTimelabetimeText;exsumNumberConvertToIntlabnumsum.Text);exisCheck;exexecteState;excheckState;exticketState;Addexdecimals0;//獲取repeater中控件的值oreachRepeaterItemiteminrepsupplyItems{ifitemItemType==ListItemType.Item||item.ItemType==stItemTypeAlternatingItem{Labelsupplyiditem.FindControl("labsid")asLabel;TextBoxnumberitemFindControl"txtnum")asTextBox;TextBoxpriceitemFindControl"txtprice")asTextBox;TextBoxsumitemFindControl"txtSum")asTextBox;TextBoxtimeitemFindControl"txtptime")asTextBox;TextBoxmanitemFindControl"txtman")asTextBox;TextBoxphone=item.FindControl("txtphone")asTextBox;/總計?vertToDecimalsumTextDetailExecteInfoDAdedanewDetailExecteInfoDA();DetailExecteInfodenewDetailExecteInfo();eexecteIdexExecteIddesupplyIdConvertToIntsupplyid.Text);deQuantityConvertToIntnumber.Text);dePriceConvertToDecimalpriceText);depayTimeConvertToDateTimetimeTextdesubTotalConvertToDecimalsumText);delinkMammanText"";dePhonephoneText";deRemarkaAddde}}查詢質(zhì)審查詢質(zhì)審核質(zhì)essiontotalsResponseRedirectExecteOrderListaspx?id="+ex.ExecteId);無[給出對該基本模塊的簡要描述，主要說明安排設(shè)計本模塊的目的意義，并且，還要說本模塊主要包括3個子模塊，分別是：登記質(zhì)檢結(jié)果，審核質(zhì)檢結(jié)果，查詢質(zhì)檢結(jié)果；登記質(zhì)檢結(jié)果-審核質(zhì)檢結(jié)果-查詢質(zhì)檢結(jié)果；本模塊管理結(jié)果：把采購執(zhí)行單中采購的貨品進(jìn)行質(zhì)檢，并進(jìn)行登記登記的結(jié)果進(jìn)行審核結(jié)果：把已經(jīng)通過審核的質(zhì)檢結(jié)果進(jìn)行時間段的查詢]登登記質(zhì)UI所對應(yīng)的表示界面]如：圖9.1質(zhì)檢結(jié)果登記圖9.2質(zhì)檢結(jié)果登記圖9.3等待審核圖9.4審核圖9.5查詢審核結(jié)果圖9.6質(zhì)檢詳情/審核通過protectedvoidbtnreset_Click(objectsender,EventArgse){CheckInfoDAcheckDAnewCheckInfoDA;intIDConvertToInt2(lblcheckId.Text.Trim());varret=checkDA.Find(p=>p.checkId==ID).FirstOrDefault();radoutChecked{retcheckUser=dropcheckUser.Text.Trim();retcheckTime=Convert.ToDateTime(lblcheckTime.Text.Trim());eckDASave{}{}}radokChecked{retcheckUser=dropcheckUser.Text.Trim();retcheckTime=Convert.ToDateTime(lblcheckTime.Text.Trim());ret.isCheck=1;eckDASaveif(ret.isCheck==1){ResponseRedirectCheckCheckerOKaspx");}{}}}/根據(jù)輸入的時間段來查詢數(shù)據(jù)protectedvoidButton1_Click(objectsender,EventArgse){ifthistxtTimeText!=""&&this.txtTime2.Text!=""){varret1=dcDA.Find(p=>p.CheckInfo.checkTime>=ConvertToDateTimethistxtTimeTextTrim())&&p.CheckInfo.checkTime<=ConvertToDateTimethistxtTimeTextTrim))).ToList();thisRepeater.DataSource=ret1;thisRepeater.DataBind();}elseifthistxtTimeText!=""&&this.txtTime2.Text==""){varret2=dcDA.Find(p=>p.CheckInfo.checkTime>=ConvertToDateTimethistxtTimeTextTrim))).ToList();thisRepeater.DataSource=ret2;thisRepeater.DataBind();}elseifthistxtTimeText==""&&this.txtTime2.Text!=""){varret3=dcDA.Find(p=>p.CheckInfo.checkTime<=ConvertToDateTimethistxtTimeTextTrim))).ToList();thisRepeater.DataSource=ret3;thisRepeater.DataBind();}查詢查詢發(fā)登記發(fā){varret=dcDA.Find(p=>p.CheckInfo.isCheck==1).ToList();thisRepeater.DataSource=ret;thisRepeater.DataBind();}}的問題無[給出對該基本模塊的簡要描述，主要說明安排設(shè)計本模塊的目的意義，并且，還要說：發(fā)票的管理，對發(fā)票進(jìn)行開票和審核。信息：主要是把質(zhì)檢結(jié)果進(jìn)行開發(fā)票，并進(jìn)行發(fā)票的登記登記的發(fā)票進(jìn)行審核信息：對已經(jīng)通過審核進(jìn)行的發(fā)票進(jìn)行查詢]審審核發(fā)所對應(yīng)的表示界面]如：inttidConvertToInt2(Request["tid"]);//1添加員工到ddlmarkUserddlmarkUserDataSourceempDaFindem=>true).ToList();ddlmarkUserDataTextFieldemployeeNameddlmarkUserDataValueFieldemployeeIDmarkUserDataBind/2.添加發(fā)票信息到table中varticket=ticketDA.Find(t=>t.ticketId==tid).FirstOrDefault();labExecteIdTextticketexecteId+"";ddlmarkUserItemsFindByTextticketmarkUserSelected=true;labmarkTimeTextticketmarkTime+"";labproductIdTextticketproductID+"";labproductNameTextticketProductInfoproductName;labsumMoneyTextticketsumMoney+"";/3.添加發(fā)票詳細(xì)信息到repInvoiceInforepInvoiceInfo.DataSource=deticketDA.Find(d=>d.ticketId==ticketticketId.ToList();repInvoiceInfoDataBind);/審核是否通過protectedvoidbtnSub_Click(objectsender,EventArgse){/1.保存登記人到發(fā)票表ticketmarkUser=ddlmarkUser.SelectedItem.Text;/2.保存本次收到金額到發(fā)票明細(xì)表decimals0;foreachRepeaterItemiinthisrepInvoiceInfoItems{DetailTicketInfodenewDetailTicketInfo();ifiItemTypeListItemType.Item||i.ItemType==ListItemType.AlternatingItem){TextBoxckMoneyiFindControl"txtcheckMoney")asTextBox;decheckMoneyConvertToDecimalckMoneyText);decompleteMoneyConvertToDecimalckMoneyText);icketDAAddde}ConvertToDecimaldecompleteMoney}/3.發(fā)票表中的isCheck改為1,獲取審核時間執(zhí)行表中的發(fā)票狀態(tài)改為1inttidConvertToInt2(Request["tid"]);varti=ticketDA.Find(t=>t.ticketId==tid).FirstOrDefault();radoutChecked{ticheckTime=DateTime.Now;ticompleteMoney=s;//已收總額?tishengMoney=ti.sumMoney-s;//未收總額?ticketDASave);{JScriptAlert);}}radokChecked{ti.isCheck=1;ticheckTime=DateTime.Now;ticompleteMoney=s;//已收總額tishengMoney=ti.sumMoney-s;//未收總額ticketDASave);iftiisCheck{/4.跳轉(zhuǎn)到CheckInvioceOK.aspx頁面?ResponseRedirectCheckInvioceOKaspx");}}}無覽：對供應(yīng)商以及其提供的貨品的單價進(jìn)行預(yù)覽檢結(jié)果用報表的形式展現(xiàn)出來]質(zhì)檢質(zhì)檢詳情報報表管理采采購價所對應(yīng)的表示界面]如：privatestaticSqlConnectionconnection;publicstaticSqlConnectionConnection{{/stringconnectionString=ConfigurationSettings.AppSettings["connStr"];stringconnectionString="Server=LocalHost;IntegratedSPIDatabaseStockSystemDataifconnectionnull){onnectionnewSqlConnectionconnectionStringnectionOpen}elseifconnectionStateSystem.Data.ConnectionState.Closed){nectionOpen}elseifconnectionStateSystem.Data.ConnectionState.Broken){nectionClosenectionOpen}returnconnection}}publicstaticintExecuteCommand(stringsafeSql){ommandcmdnewSqlCommandsafeSqlConnectionintresultcmdExecuteNonQuery;returnresult;}publicstaticintExecuteCommand(stringsql,SqlParameter[]values){ommandcmdnewSqlCommandsqlConnectionParametersAddRangevaluesreturncmdExecuteNonQuery();}publicstaticintExecuteCommand(stringsql,SqlParametervalue){ommandcmdnewSqlCommandsqlConnectionParametersAddvalueintresultcmdExecuteNonQuery;returnresult;}publicstaticintExecuteScalar(stringsafeSql){ommandcmdnewSqlCommandsafeSqlConnectionintresultintcmdExecuteScalar();returnresult;}publicstaticintExecuteScalar(stringsql,SqlParameter[]values){ommandcmdnewSqlCommandsqlConnectionParametersAddRangevaluesintresultintcmdExecuteScalar();returnresult;}publicstaticintExecuteScalar(stringsql,SqlParametervalue){ommandcmdnewSqlCommandsqlConnectionParametersAddvalueintresultintcmdExecuteScalar();returnresult;}publicstaticSqlDataReaderExecuteReader(stringsafeSql){ommandcmdnewSqlCommandsafeSqlConnectionderreadernully{readercmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);}hExceptionex{}returnreader}publicstaticSqlDataReaderExecuteReader(stringsql,SqlParametervalue){ommandcmdnewSqlCommandsqlConnectionParametersAddvalueaderreadernully{readercmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);}hExceptionex{}returnreader}publicstaticSqlDataReaderExecuteReader(stringsql,SqlParameter[]values){ommandcmdnewSqlCommandsqlConnectionParametersAddRangevaluesaderreadernully{readercmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);}hExceptionex{}returnreader}publicstaticboolExecute_proc(stringproc_n