【财产异动】-----详细设计二

最新推荐文章于 2024-09-12 19:36:01 发布

Jasson

最新推荐文章于 2024-09-12 19:36:01 发布

阅读量867

点赞数

分类专栏： ZcoderLife 文章标签： string dataset session object asp.net button

本文链接：https://blog.csdn.net/jiali765/article/details/5790534

版权

ZcoderLife 专栏收录该内容

28 篇文章 0 订阅

订阅专栏

今天接着来，这一部分就是程式的实现了，代码的编写！其实流程的签核是跟AgilePoint 的框架有关系的，我只是把相应的添加进去，现在想想还真有点下积木游戏一下，一层层的来！按照厂商的框架，在它的基础上添加自己的应用。完全是跟ASP.net开发一个样了。当然那是你最拿手的好戏了吧。

OK,废话就不多说了，直接贴吧。看不看得明白就都随缘吧！我还是把他分开两部分吧（ASP.NET和Eflow Button Event）

1. ASP.NET部分

using System; using System.Text; using System.Collections; using System.Configuration; using System.Data; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using SystemLead.Helper; using SystemLead.Product.AgilePoint; using ADG.Developer.Data.ASSET.FIASSET; using ADG.Developer.Data.ASSET.Model; using SystemLead.ADG.Developer.BPMWeb.Base; namespace ADG.Developer.BPMWeb.ASSET.DEV.FIASSET { public partial class HCM_FIASSET : AFPageBase { HCM_FIASSETCORE com = new HCM_FIASSETCORE(); private string ass_NO=""; #region Page Event protected void Page_Load(object sender, EventArgs e) { this.LabelUserA.BorderStyle = BorderStyle.None; this.LabelUserB.BorderStyle = BorderStyle.None; this.LabelKostlA.BorderStyle = BorderStyle.None; this.LabelKostlB.BorderStyle = BorderStyle.None; ; // ass_NO = this.GetCustomAttr("ASS_NO").ToString(); if (!IsPostBack) { if (Request.QueryString["ATYPE"] != null) { if (!string.IsNullOrEmpty(Request.QueryString["ATYPE"].ToString())) { if (Request.QueryString["ATYPE"].ToString() == "TW") { base._ProcessTemplateName = "固定資產-TW"; base.SetProgramTitle("固定資產-TW"); this.NAFCreateProcInstButton1.ProcessTemplateName = "固定資產-TW"; } else { base._ProcessTemplateName = "財產異動-CN"; base.SetProgramTitle("財產異動-CN"); this.NAFCreateProcInstButton1.ProcessTemplateName = "財產異動-CN"; } } } else { if (base.GetCustomAttr("TTYPE").ToString().IndexOf("CN") > 0) { base._ProcessTemplateName = "財產異動-CN"; base.SetProgramTitle("財產異動-CN"); this.NAFCreateProcInstButton1.ProcessTemplateName = "財產異動-CN"; } else { base._ProcessTemplateName = "固定資產-TW"; base.SetProgramTitle("固定資產-TW"); this.NAFCreateProcInstButton1.ProcessTemplateName = "固定資產-TW"; } } base.SetUIControls(this.Page); base.InitCommentData(this.CommentEdit1); if (this.GetCustomAttr("ASS_NO") != null) { ass_NO = this.GetCustomAttr("ASS_NO").ToString(); setDefault2(ass_NO); } else { Session["GridViewDataSource"] = null; setDefault(); } if (this.GetCustomAttr("ASS_FIDATE") != null) { setPrint(); this.UCReport1.Visible = true; this.TextBoxASS_FIDate.btEnabled = false; this.TextBoxASS_FIDate.Enabled = false; TextBoxASS_FIDate.SelectedDate = Convert.ToDateTime(this.GetCustomAttr("ASS_FIDATE")); } createdSession(); } if (this.IsPostBack) { if (this.GetCustomAttr("ASS_NO") != null) { if (base.GetManualDisplayName() == "起單人") { } else { ass_NO = this.GetCustomAttr("ASS_NO").ToString(); setDefault2(ass_NO); } } else { if (Request.QueryString["ATYPE"].ToString() == "TW") { base._ProcessTemplateName = "固定資產-TW"; base.SetProgramTitle("固定資產-TW"); base.SetCustomAttr("TTYPE", "固定資產TW"); this.NAFCreateProcInstButton1.ProcessTemplateName = "固定資產-TW"; } else { base._ProcessTemplateName = "財產異動-CN"; base.SetProgramTitle("財產異動-CN"); base.SetCustomAttr("TTYPE", "財產異動CN"); this.NAFCreateProcInstButton1.ProcessTemplateName = "財產異動-CN"; } // GridViewFI_ASS_DETAILDataBind(); } } } #endregion #region Button Event protected void ImageButtonQuery_Click(object sender, EventArgs e) { GridViewFI_ASS_DETAILDataBind(); } protected void GridViewFI_ASS_DETAIL_RowDeleting(object sender, GridViewDeleteEventArgs e) { DataTable dt; dt = (DataTable)Session["GridViewDataSource"]; string id = (GridViewFI_ASS_DETAIL.DataKeys[e.RowIndex].Value).ToString(); DataRow[] dr; dr = dt.Select("ID="+id); dt.Rows.Remove(dr[0]); Session["GridViewDataSource"] = dt; GridViewFI_ASS_DETAILDataBind(); } protected void GridViewFI_ASS_DETAIL_RowCreated(object sender, GridViewRowEventArgs e) { if (this.GetCustomAttr("ASS_NO") != null) { if (base.GetManualDisplayName() == "起單人") { } else { if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[0].Visible = false; } } } if (e.Row.RowType == DataControlRowType.DataRow || e.Row.RowType == DataControlRowType.Header) { e.Row.Cells[14].Visible = false; } } protected void GridViewFI_ASS_DETAIL_PageIndexChanging(object sender, GridViewPageEventArgs e) { DataTable dt; dt = (DataTable)Session["GridViewDataSource"]; if (dt != null) { GridViewFI_ASS_DETAIL.PageIndex = e.NewPageIndex; GridViewFI_ASS_DETAIL.DataSource = dt.DefaultView; GridViewFI_ASS_DETAIL.DataBind(); } } protected void DropDownListBukrs_SelectedIndexChanged(object sender, EventArgs e) { clearSessionTB(); GridViewFI_ASS_DETAILDataBind(); } protected void TextBoxUserA_TextChanged(object sender, EventArgs e) { //clearSessionTB(); //GridViewFI_ASS_DETAILDataBind(); } #endregion #region Sub Event private void setDefault() { //綁定公司 DataTable dtBukrs,dtGsber; if (base._ProcessTemplateName == "固定資產-TW") dtBukrs = com.getBukrs("1"); else dtBukrs = com.getBukrs("2"); DropDownListBukrs.DataSource = dtBukrs.DefaultView; DropDownListBukrs.DataTextField = "CHT_NAME"; DropDownListBukrs.DataValueField = "CODE"; DropDownListBukrs.DataBind(); //綁定業務範圍 dtGsber = com.getGsber(); DropDownListGsber.DataSource = dtGsber.DefaultView; DropDownListGsber.DataTextField = "comdname"; DropDownListGsber.DataValueField = "comdid"; DropDownListGsber.DataBind(); //設定日期為當前時間日期 LabelASS_Date.Text = DateTime.Now.ToString("yyyy-MM-dd"); LabelASS_ID.Text = base.UserName; this.AFApproveButton1.Visible = false; this.AFRejectButton1.Visible = false; this.AFSaveDataButton1.Visible = false; this.AFSaveDataButton1.Enabled = false; this.NAFCreateProcInstButton1.Visible = true; this.NAFCreateProcInstButton1.Enabled = true; this.AFCancelProcInstButton1.Visible = true; this.AFCancelProcInstButton1.Enabled = true; } private void setDefault2(string ass) { //綁定公司 DataTable dtBukrs, dtGsber; if (base.GetCustomAttr("TTYPE").ToString().IndexOf("CN") > 0) dtBukrs = com.getBukrs("2"); else dtBukrs = com.getBukrs("1"); DropDownListBukrs.DataSource = dtBukrs.DefaultView; DropDownListBukrs.DataTextField = "CHT_NAME"; DropDownListBukrs.DataValueField = "CODE"; DropDownListBukrs.DataBind(); //綁定業務範圍 dtGsber = com.getGsber(); DropDownListGsber.DataSource = dtGsber.DefaultView; DropDownListGsber.DataTextField = "comdname"; DropDownListGsber.DataValueField = "comdid"; DropDownListGsber.DataBind(); if (base.GetManualDisplayName() != "起單人") allUnable(false); else { this.TextBoxASS_NO.Enabled = false; this.UK1.btEnabled = false; this.TextBoxUserA.Enabled = false; this.TextBoxKostlA.Enabled = false; this.DropDownListBukrs.Enabled = false; this.DropDownListGsber.Enabled = false; this.LabelKostlA.Enabled = false; this.LabelUserA.Enabled = false; } GridViewFI_ASS_DETAILDataBind2(ass); } private void allUnable(bool b) { this.TextBoxASS_FIDate.btEnabled = b; this.TextBoxASS_FIDate.Enabled = b; this.TextBoxASS_Mark.Enabled = b; this.TextBoxASS_NO.Enabled = b; this.TextBoxASS_Reason.Enabled = b; this.TextBoxUserA.Enabled = b; this.TextBoxUserB.Enabled = b; this.TextBoxKostlA.Enabled = b; this.UK1.btEnabled = b; this.LabelKostlA.Enabled= b; this.LabelKostlB.Enabled = b; this.USER2.btEnabled = b; this.LabelUserA.Enabled = b; this.LabelUserB.Enabled= b; this.KOSTL2.btEnabled = b; this.TextBoxKostlB.Enabled = b; this.LabelKostlB.Enabled= b; this.DropDownListASS_MType.Enabled = b; this.DropDownListASS_Type.Enabled = b; this.DropDownListBukrs.Enabled = b; this.DropDownListGsber.Enabled = b; //this.CheckBoxIsout.Enabled = b; this.UCReport1.Visible = b; this.PanelButton.Visible = b; this.NAFCreateProcInstButton1.Visible = b; this.AFCancelProcInstButton1.Visible = b; } private void createdSession() { DataTable dt ; HCM_FIASSETCORE com = new HCM_FIASSETCORE(); dt = com.createTable(); if(Session["GridViewDataSource"]==null) Session["GridViewDataSource"] = dt; } private string createNO() { string ass_no; ass_no = com.getNewASS_NO(); return ass_no; } private void GridViewFI_ASS_DETAILDataBind() { DataTable dt = new DataTable(); if (Session["GridViewDataSource"] != null) { dt = (DataTable)Session["GridViewDataSource"]; GridViewFI_ASS_DETAIL.DataSource = dt.DefaultView; GridViewFI_ASS_DETAIL.DataKeyNames = new string[] { "ID" }; GridViewFI_ASS_DETAIL.DataBind(); } } private void GridViewFI_ASS_DETAILDataBind2(string ass) { DataTable dtDETAIL, dtMASTER; string ogreh = ""; switch (base.GetManualDisplayName()) { case "品管判定單位": ogreh = "QA"; break; case "資訊判定單位": ogreh = "ITD"; break; case "總務判定單位": ogreh = "HRD"; break; case "模具判定單位": ogreh = "MOULD"; break; case "設備判定單位": ogreh = "APP"; break; case "工務判定單位": ogreh = "APP"; break; case "技術判定單位": ogreh = "TEC"; break; case "會計單位": this.TextBoxASS_FIDate.btEnabled = true; this.TextBoxASS_FIDate.Enabled = true; ogreh = "%"; break; default: ogreh = "%"; break; } dtMASTER = com.getMasterByNo(ass); dtDETAIL = com.getDetailByNoAnln1(ass, ogreh); if (dtMASTER.Rows.Count > 0) { TextBoxASS_NO.Text = dtMASTER.Rows[0]["ASS_NO"].ToString(); LabelASS_ID.Text = dtMASTER.Rows[0]["ASS_APPRID"].ToString(); LabelASS_Date.Text = Convert.ToDateTime(dtMASTER.Rows[0]["ASS_DATE"]).ToString("yyyy-MM-dd"); DropDownListASS_Type.SelectedValue = dtMASTER.Rows[0]["ASS_TYPE"].ToString(); DropDownListASS_MType.SelectedValue = dtMASTER.Rows[0]["ASS_MTYPE"].ToString(); // if (!(base.GetManualDisplayName() == "會計單位")) TextBoxASS_FIDate.SelectedDate = Convert.ToDateTime(dtMASTER.Rows[0]["ASS_FIDATE"]); if (base.GetManualDisplayName() == "工務匯總") { if (CheckBoxIsout.Checked == true) { base.SetCustomAttr("ISOUT", Convert.ToBoolean(true)); } else { base.SetCustomAttr("ISOUT", Convert.ToBoolean(false)); } } else { if (this.GetCustomAttr("ISOUT") != null) { if (this.GetCustomAttr("ISOUT").ToString().ToUpper() == "TRUE") CheckBoxIsout.Checked = true; else CheckBoxIsout.Checked = false; } } TextBoxASS_Reason.Text = dtMASTER.Rows[0]["ASS_REASON"].ToString(); ; TextBoxASS_Mark.Text = dtMASTER.Rows[0]["ASS_MARK"].ToString(); this.TextBoxUserB.Text = dtMASTER.Rows[0]["ASS_USER_B"].ToString(); this.TextBoxUserA.Text = dtMASTER.Rows[0]["ASS_USER_A"].ToString(); this.TextBoxKostlA.Text = dtMASTER.Rows[0]["ASS_KOSTL_A"].ToString(); this.TextBoxKostlB.Text = dtMASTER.Rows[0]["ASS_KOSTL_B"].ToString(); DropDownListGsber.SelectedValue = dtMASTER.Rows[0]["GSBER"].ToString(); DropDownListBukrs.SelectedValue = dtMASTER.Rows[0]["BUKRS"].ToString(); this.LabelKostlB.Text = base.GetCustomAttr("PKOSTL").ToString(); this.LabelUserB.Text = base.GetCustomAttr("PNAME").ToString(); this.LabelUserA.Text= base.GetCustomAttr("BPERNRNAME").ToString(); this.LabelKostlA.Text = base.GetCustomAttr("BKOSTL").ToString(); } com.updataDataToTable(ref dtDETAIL); Session["GridViewDataSource"] = dtDETAIL; GridViewFI_ASS_DETAIL.DataSource = dtDETAIL.DefaultView; GridViewFI_ASS_DETAIL.DataKeyNames = new string[] { "ID" }; GridViewFI_ASS_DETAIL.DataBind(); } private void savePageData() { DataTable dt = (DataTable)Session["GridViewDataSource"]; int returnNum = -1; string ass_no = createNO(); base.SetCustomAttr("ASS_NO", ass_no); if (DropDownListASS_MType.SelectedValue == "3") { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(true)); } else { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(false)); } if (DropDownListASS_MType.SelectedValue == "1" || DropDownListASS_MType.SelectedValue == "2") { base.SetCustomAttr("ISBF", Convert.ToBoolean(true)); } else { base.SetCustomAttr("ISBF", Convert.ToBoolean(false)); } if (DropDownListASS_Type.SelectedValue == "B") { if (base._ProcessTemplateName == "固定資產-TW") { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(true)); base.SetCustomAttr("TTYPE", "列管品TW"); } else { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(true)); base.SetCustomAttr("TTYPE", "列管品CN"); } } FI_ASS_MASTER insertMaster = new FI_ASS_MASTER(); FI_ASS_DETAIL insertDetail = new FI_ASS_DETAIL(); insertDetail.Ass_no = ass_no; insertMaster.Ass_no = ass_no; insertMaster.Ass_type = DropDownListASS_Type.SelectedValue.ToString(); insertMaster.Ass_mtype = DropDownListASS_MType.SelectedValue.ToString(); insertMaster.Ass_date = LabelASS_Date.Text.ToString(); // insertMaster.Ass_fidate = TextBoxASS_FIDate.SelectedDate.ToShortDateString();//"2010/05/27"; insertMaster.Ass_apprid = LabelASS_ID.Text.ToString(); insertMaster.Ass_Reason = TextBoxASS_Reason.Text.ToString(); insertMaster.Ass_mark = TextBoxASS_Mark.Text.ToString(); insertMaster.Ass_user_b = this.TextBoxUserB.Text; insertMaster.Ass_user_a = this.TextBoxUserA.Text; insertMaster.Ass_kostl_a = this.TextBoxKostlA.Text; insertMaster.Ass_kostl_b = this.TextBoxKostlB.Text; insertMaster.State = "0";// insertMaster.Gsber = DropDownListGsber.SelectedValue.ToString(); insertMaster.Kostl = ""; insertMaster.Kostlv = ""; if (CheckBoxIsout.Checked == true) { insertMaster.Isout = "True"; base.SetCustomAttr("ISOUT", Convert.ToBoolean(true)); } else { insertMaster.Isout = "False"; base.SetCustomAttr("ISOUT", Convert.ToBoolean(false)); } insertMaster.Bukrs = DropDownListBukrs.SelectedValue.ToString(); returnNum = com.insertDataToMaster(insertMaster); if (returnNum < 0) { //不成功 LabelMessage.Text = "插入Master發生錯誤"; } if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { returnNum = -1; insertDetail.Ass_anln1 = dt.Rows[i]["ASS_ANLN1"].ToString(); insertDetail.Ass_anln2 = dt.Rows[i]["ASS_ANLN2"].ToString(); insertDetail.Ass_txt50 = dt.Rows[i]["ASS_TXT50"].ToString(); insertDetail.Ass_aktiv = dt.Rows[i]["ASS_AKTIV"].ToString(); insertDetail.Ass_kostl = dt.Rows[i]["ASS_KOSTL"].ToString(); insertDetail.Ass_pernr = dt.Rows[i]["ASS_PERNR"].ToString(); insertDetail.Ass_name2 = dt.Rows[i]["NAME2"].ToString(); insertDetail.Ass_ktext = dt.Rows[i]["ASS_KTEXT"].ToString(); insertDetail.Ass_stort = dt.Rows[i]["ASS_STORT"].ToString(); insertDetail.Ass_werks = dt.Rows[i]["ASS_WERKS"].ToString(); insertDetail.Ass_anlue = dt.Rows[i]["ASS_ANLUE"].ToString(); insertDetail.Ass_anlue_txt = dt.Rows[i]["ASS_ANLUE_TXT"].ToString(); insertDetail.Ass_anlkl = dt.Rows[i]["ASS_ANLKL"].ToString(); insertDetail.Ass_urwrt = dt.Rows[i]["ASS_URWRT"].ToString(); insertDetail.Ass_menge = dt.Rows[i]["ASS_MENGE"].ToString(); insertDetail.Orgeh = deptment(insertDetail.Ass_anlue.Substring(0, 6).ToString(), insertMaster.Gsber, insertMaster.Bukrs).Trim().ToUpper(); switch (insertDetail.Orgeh) { case "QA": base.SetCustomAttr("QA", pernerWindows("QA", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISQA", Convert.ToBoolean(true)); break; case "APP": base.SetCustomAttr("APP", pernerWindows("APP", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISAPP", Convert.ToBoolean(true)); break; case "ITD": base.SetCustomAttr("ITD", pernerWindows("ITD", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISITD", Convert.ToBoolean(true)); break; case "HRD": base.SetCustomAttr("HRD", pernerWindows("HRD", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISOTHER", Convert.ToBoolean(true)); break; case "MOULD": base.SetCustomAttr("MOULD", pernerWindows("MOULD", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISMOULD", Convert.ToBoolean(true)); break; case "TEC": base.SetCustomAttr("TEC", pernerWindows("TEC", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISTEC", Convert.ToBoolean(true)); break; default: //this.LabelMessage.Text = ""; break; } returnNum = com.insertDataToDetail(insertDetail); if (returnNum < 0) { //不成功 LabelMessage.Text += "插入Detail發生錯誤:" + insertDetail.Ass_no + " " + dt.Rows[i]["ASS_ANLN1"].ToString() + " " + dt.Rows[i]["ASS_ANLN2"].ToString(); } } clearSessionTB(); } } private void updataPageData() { DataTable dt = (DataTable)Session["GridViewDataSource"]; int returnNum = -1; string ass_no = base.GetCustomAttr("ASS_NO").ToString(); returnNum = com.deleteDataToDetail(ass_no); returnNum = -1; returnNum = com.deleteDataToMaster(ass_no); returnNum = -1; if (DropDownListASS_MType.SelectedValue == "3") { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(true)); } else { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(false)); } if (DropDownListASS_Type.SelectedValue == "B") { if (base._ProcessTemplateName == "固定資產-TW") { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(true)); base.SetCustomAttr("TTYPE", "列管品TW"); } else { base.SetCustomAttr("ISMOVE", Convert.ToBoolean(true)); base.SetCustomAttr("TTYPE", "列管品CN"); } } if (DropDownListASS_MType.SelectedValue == "1" || DropDownListASS_MType.SelectedValue == "2") { base.SetCustomAttr("ISBF", Convert.ToBoolean(true)); } else { base.SetCustomAttr("ISBF", Convert.ToBoolean(false)); } FI_ASS_MASTER insertMaster = new FI_ASS_MASTER(); FI_ASS_DETAIL insertDetail = new FI_ASS_DETAIL(); insertDetail.Ass_no = ass_no; insertMaster.Ass_no = ass_no; insertMaster.Ass_type = DropDownListASS_Type.SelectedValue.ToString(); insertMaster.Ass_mtype = DropDownListASS_MType.SelectedValue.ToString(); insertMaster.Ass_date = LabelASS_Date.Text.ToString(); // insertMaster.Ass_fidate = TextBoxASS_FIDate.SelectedDate.ToShortDateString();//"2010/05/27"; insertMaster.Ass_apprid = LabelASS_ID.Text.ToString(); insertMaster.Ass_Reason = TextBoxASS_Reason.Text.ToString(); insertMaster.Ass_mark = TextBoxASS_Mark.Text.ToString(); insertMaster.Ass_user_b = this.TextBoxUserB.Text; insertMaster.Ass_user_a = this.TextBoxUserA.Text; insertMaster.Ass_kostl_a = this.TextBoxKostlA.Text; insertMaster.Ass_kostl_b = this.TextBoxKostlB.Text; insertMaster.State = "0";// insertMaster.Gsber = DropDownListGsber.SelectedValue.ToString(); insertMaster.Kostl = ""; insertMaster.Kostlv = ""; if (CheckBoxIsout.Checked == true) { insertMaster.Isout = "True"; base.SetCustomAttr("ISOUT", Convert.ToBoolean(true)); } else { insertMaster.Isout = "False"; base.SetCustomAttr("ISOUT", Convert.ToBoolean(false)); } insertMaster.Bukrs = DropDownListBukrs.SelectedValue.ToString(); returnNum = com.insertDataToMaster(insertMaster); if (returnNum < 0) { //不成功 LabelMessage.Text = "插入Master發生錯誤"; } if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { returnNum = -1; insertDetail.Ass_anln1 = dt.Rows[i]["ASS_ANLN1"].ToString(); insertDetail.Ass_anln2 = dt.Rows[i]["ASS_ANLN2"].ToString(); insertDetail.Ass_txt50 = dt.Rows[i]["ASS_TXT50"].ToString(); insertDetail.Ass_aktiv = Convert.ToDateTime(dt.Rows[i]["ASS_AKTIV"]).ToString("yyyy-MM-dd"); insertDetail.Ass_kostl = dt.Rows[i]["ASS_KOSTL"].ToString(); insertDetail.Ass_pernr = dt.Rows[i]["ASS_PERNR"].ToString(); insertDetail.Ass_name2 = dt.Rows[i]["NAME2"].ToString(); insertDetail.Ass_ktext = dt.Rows[i]["ASS_KTEXT"].ToString(); insertDetail.Ass_stort = dt.Rows[i]["ASS_STORT"].ToString(); insertDetail.Ass_werks = dt.Rows[i]["ASS_WERKS"].ToString(); insertDetail.Ass_anlue = dt.Rows[i]["ASS_ANLUE"].ToString(); insertDetail.Ass_anlue_txt = dt.Rows[i]["ASS_ANLUE_TXT"].ToString(); insertDetail.Ass_anlkl = dt.Rows[i]["ASS_ANLKL"].ToString(); insertDetail.Ass_urwrt = dt.Rows[i]["ASS_URWRT"].ToString(); insertDetail.Ass_menge = dt.Rows[i]["ASS_MENGE"].ToString(); insertDetail.Orgeh = deptment(insertDetail.Ass_anlue.Substring(0, 6).ToString(), insertMaster.Gsber, insertMaster.Bukrs).Trim().ToUpper(); switch (insertDetail.Orgeh) { case "QA": base.SetCustomAttr("QA", pernerWindows("QA", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISQA", Convert.ToBoolean(true)); break; case "APP": base.SetCustomAttr("APP", pernerWindows("APP", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISAPP", Convert.ToBoolean(true)); break; case "ITD": base.SetCustomAttr("ITD", pernerWindows("ITD", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISITD", Convert.ToBoolean(true)); break; case "HRD": base.SetCustomAttr("HRD", pernerWindows("HRD", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISOTHER", Convert.ToBoolean(true)); break; case "MOULD": base.SetCustomAttr("MOULD", pernerWindows("MOULD", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISMOULD", Convert.ToBoolean(true)); break; case "TEC": base.SetCustomAttr("TEC", pernerWindows("TEC", insertMaster.Bukrs, insertMaster.Gsber)); base.SetCustomAttr("ISTEC", Convert.ToBoolean(true)); break; default: //this.LabelMessage.Text = ""; break; } returnNum = com.insertDataToDetail(insertDetail); if (returnNum < 0) { //不成功 LabelMessage.Text += "插入Detail發生錯誤:" + insertDetail.Ass_no + " " + dt.Rows[i]["ASS_ANLN1"].ToString() + " " + dt.Rows[i]["ASS_ANLN2"].ToString(); } } clearSessionTB(); } } private string deptment(string ass_anln1,string gsbers,string bukrs) { string ret=""; ret = com.getDeptByAsset(ass_anln1, gsbers, bukrs); return ret; } private string pernerWindows(string orgeh,string bukrs,string sale) { string ret = ""; ret = com.getDeptWindowByOrgeh(orgeh, bukrs,sale); return ret; } private void clearSessionTB() { DataTable dt = (DataTable)Session["GridViewDataSource"]; dt.Rows.Clear(); Session["GridViewDataSource"] = dt; } private string USERNO(string Buk, string type) { return com.getUSERNO(Buk.ToUpper(), type.ToUpper()); } private void setCustomAttrAll() { string cop; cop = DropDownListBukrs.SelectedValue; base.SetCustomAttr("DefaultConnection", ConfigurationManager.AppSettings["Default"]); base.SetCustomAttr("PERNR", LabelASS_ID.Text); base.SetCustomAttr("BPERNR", this.TextBoxUserA.Text.ToString()); base.SetCustomAttr("ASS_DATE", Convert.ToDateTime(this.LabelASS_Date.Text)); if (this.GetCustomAttr("TTYPE").ToString() == "列管品TW")//TW 列管品時塞總務為會計 { base.SetCustomAttr("ACC", this.USERNO(cop, "HR")); } else { base.SetCustomAttr("ACC", this.USERNO(cop, "ACC")); } if (this.GetCustomAttr("TTYPE").ToString() == "財產異動") { base.SetCustomAttr("GW", this.USERNO(cop, "GW")); } base.SetCustomAttr("HR", this.USERNO(cop,"HR"));//總務負責人 base.SetCustomAttr("PERNRNAME", base.UserFullName); base.SetCustomAttr("BPERNRNAME", this.LabelUserA.Text); base.SetCustomAttr("BKOSTL", this.LabelKostlA.Text); base.SetCustomAttr("PNAME", this.LabelUserB.Text); base.SetCustomAttr("PKOSTL",this.LabelKostlB.Text); base.SetCustomAttr("PPERNR", this.TextBoxUserB.Text.Trim().ToString());//後保管人簽核 } private void clearCustomAttrAll() { base.SetCustomAttr("ISQA", Convert.ToBoolean(false)); base.SetCustomAttr("ISAPP", Convert.ToBoolean(false)); base.SetCustomAttr("ISITD", Convert.ToBoolean(false)); base.SetCustomAttr("ISOTHER", Convert.ToBoolean(false)); base.SetCustomAttr("ISMOULD", Convert.ToBoolean(false)); base.SetCustomAttr("ISTEC", Convert.ToBoolean(false)); } private string IsNullQuery() { string strReturn = ""; if (string.IsNullOrEmpty(this.TextBoxUserA.Text.ToString())) strReturn += "原保管人未填寫 "; if (string.IsNullOrEmpty(this.TextBoxKostlA.Text.ToString())) strReturn += "原保管人的成本中心未填寫 "; return strReturn; } private string IsNullAll() { string strReturn = ""; if (string.IsNullOrEmpty(this.TextBoxUserA.Text)) strReturn += "原保管人 "; if (string.IsNullOrEmpty(this.TextBoxKostlA.Text)) strReturn += "原保管人的成本中心 "; if (string.IsNullOrEmpty(this.TextBoxUserB.Text)) strReturn += "後保管人未填寫 "; if (string.IsNullOrEmpty(this.TextBoxKostlB.Text)) strReturn += "後保管人的成本中心 "; if (string.IsNullOrEmpty(this.TextBoxASS_Mark.Text)) strReturn += "備註 "; if (string.IsNullOrEmpty(this.TextBoxASS_Reason.Text)) strReturn += "異動原因 "; if (strReturn != "") strReturn += "未填寫"; return strReturn; } private string IsNullAll2() { string strReturn = ""; if (string.IsNullOrEmpty(this.TextBoxUserA.Text)) strReturn += "原保管人 "; if (string.IsNullOrEmpty(this.TextBoxKostlA.Text)) strReturn += "原保管人的成本中心 "; if (string.IsNullOrEmpty(this.TextBoxASS_Mark.Text)) strReturn += "備註 "; if (string.IsNullOrEmpty(this.TextBoxASS_Reason.Text)) strReturn += "異動原因 "; if (strReturn != "") strReturn += "未填寫"; return strReturn; } private void setPrint() { Button bPrint = (Button)UCReport1.FindControl("ButtonPrint"); bPrint.Visible = true; bPrint.Enabled = true; // DataSet dtSouce = setPrintContent(this.GetCustomAttr("ASS_NO").ToString()); DataSet dtSouce = setPrintContent(this.GetCustomAttr("ASS_NO").ToString()); UCReport1.DataSource = dtSouce; UCReport1.ReportName = "CNReport"; } private DataSet setPrintContent(string ASS_NO) { DataTable MASTER = new DataTable(); DataTable DETAIL = new DataTable(); DataTable m = com.getMasterByNo(ASS_NO); DataTable d = com.getDetailByNo(ASS_NO); MASTER.Columns.Add("ASS_NO"); MASTER.Columns.Add("ASS_MTYPE"); MASTER.Columns.Add("ASS_FIDATE"); MASTER.Columns.Add("ASS_USER_A"); MASTER.Columns.Add("ASS_USER_B"); MASTER.Columns.Add("ASS_KOSTL_A"); MASTER.Columns.Add("ASS_KOSTL_B"); MASTER.Columns.Add("ASS_REASON"); MASTER.Columns.Add("NOTE"); MASTER.Columns.Add("IsOut"); MASTER.Columns.Add("CNAME"); MASTER.Columns.Add("ENAME"); DETAIL.Columns.Add("ASS_NO"); DETAIL.Columns.Add("ASS_ANLN1"); DETAIL.Columns.Add("ASS_ANLN2"); DETAIL.Columns.Add("ASS_TXT50"); DETAIL.Columns.Add("ASS_MENGE"); DETAIL.Columns.Add("ASS_AKTIV"); for (int i = 0; i < m.Rows.Count; i++) { MASTER.Rows.Add(); MASTER.Rows[i]["ASS_NO"]=m.Rows[i]["ASS_NO"]; MASTER.Rows[i]["ASS_MTYPE"] = m.Rows[i]["ASS_MTYPE"]; MASTER.Rows[i]["ASS_FIDATE"] = string.Format("{0:d}",Convert.ToDateTime(m.Rows[i]["ASS_FIDATE"]));//; MASTER.Rows[i]["ASS_USER_A"] = base.GetUserInfo(this.GetCustomAttr("BPERNR").ToString()).FullName.ToString(); MASTER.Rows[i]["ASS_USER_B"] = base.GetUserInfo(this.TextBoxUserB.Text).FullName.ToString(); MASTER.Rows[i]["ASS_KOSTL_A"] = m.Rows[i]["ASS_KOSTL_A"]; MASTER.Rows[i]["ASS_KOSTL_B"] = m.Rows[i]["ASS_KOSTL_B"]; MASTER.Rows[i]["ASS_REASON"] = m.Rows[i]["ASS_REASON"]; MASTER.Rows[i]["NOTE"] = m.Rows[i]["NOTE"]; if (m.Rows[i]["IsOut"].ToString().ToUpper() == "TRUE") MASTER.Rows[i]["Isout"] = "V"; else MASTER.Rows[i]["IsOut"] = "X"; if (base.GetCustomAttr("TTYPE").ToString().IndexOf("CN") > 0) { MASTER.Rows[i]["CNAME"] = "明安運動器材(東莞)有限公司"; MASTER.Rows[i]["ENAME"] = "ADVANCED SPORTING GOODS (DONG GUAN) CO., LTD."; } else { MASTER.Rows[i]["CNAME"] = "明安國際企業股份有限公司"; MASTER.Rows[i]["ENAME"] = "ADVANCED INTERNATIONAL MULTITECH CO., LTD."; } } for (int j = 0; j < d.Rows.Count; j++) { DETAIL.Rows.Add(); DETAIL.Rows[j]["ASS_NO"]=d.Rows[j]["ASS_NO"]; DETAIL.Rows[j]["ASS_ANLN1"]=d.Rows[j]["ASS_ANLN1"]; DETAIL.Rows[j]["ASS_ANLN2"]=d.Rows[j]["ASS_ANLN2"]; DETAIL.Rows[j]["ASS_TXT50"]=d.Rows[j]["ASS_TXT50"]; DETAIL.Rows[j]["ASS_MENGE"]=d.Rows[j]["ASS_MENGE"]; DETAIL.Rows[j]["ASS_AKTIV"] = string.Format("{0:d}", Convert.ToDateTime(d.Rows[j]["ASS_AKTIV"])); } DataSet ds = new DataSet(); ds.Tables.Add(MASTER); ds.Tables.Add(DETAIL); //ds.Relations.Add("MDASS_NO", ds.Tables[0].Columns["ASS_NO"], ds.Tables[1].Columns["ASS_NO"]); return ds; } #endregion

2. Eflow Button Event部分

#endregion #region Eflow Button Event protected void NAFCreateProcInstButton1_Click(object sender, EventArgs e) { if (this.GridViewFI_ASS_DETAIL.Rows.Count < 1) {Utility.IsShowMsg("沒有選擇詳細異動資料"); return;} string ret ; if (DropDownListASS_MType.SelectedValue == "1" || DropDownListASS_MType.SelectedValue == "2") { ret = IsNullAll2(); } else { ret = IsNullAll(); } if (ret == "") { savePageData(); this.NAFCreateProcInstButton1.NProcessCreateProcInst(); setCustomAttrAll(); // _AssignedDept = base.GetAssignDeptByNotSameManager(this.GetCustomAttr("BPERNR").ToString(), base.GetUserInfo(this.GetCustomAttr("BPERNR").ToString()).MainDepartmentID.ToString()); _AssignedDept = base.GetAssignDeptByNotSameManager(base.UserName, base.DepID); if (base.GetUserInfo(this.GetCustomAttr("PERNR").ToString()).MainDepartmentID == base.GetUserInfo(this.GetCustomAttr("BPERNR").ToString()).MainDepartmentID) { base.SetCustomAttr("ISDIFF", Convert.ToBoolean(false)); } else { base.SetCustomAttr("ISDIFF", Convert.ToBoolean(true)); } if (base.GetUserInfo(GetCustomAttr("BPERNR").ToString()).Rank == "01" || base.GetUserInfo(GetCustomAttr("BPERNR").ToString()).Rank == "00") { base.SetCustomAttr("ISDIFF", Convert.ToBoolean(false)); } com.connClose(); base.SetComments(this.CommentEdit1, CommentType.Created); base.AFCompleteWorkItem(); } else { Utility.IsShowMsg(ret); return; } } protected void AFApproveButton1_Click(object sender, EventArgs e) { if (base.GetManualDisplayName() == "會計單位") { if (TextBoxASS_FIDate.SelectedDate < DateTime.Now.Date) { Utility.IsShowMsg("請輸入正確的處分日期 "); return; } base.SetCustomAttr("ASS_FIDATE", Convert.ToDateTime(TextBoxASS_FIDate.SelectedDate.ToShortDateString())); base.SetCustomAttr("NOTE", this.CommentEdit1._lblComment.Text); } if (base.GetManualDisplayName() == "起單人") { clearCustomAttrAll(); if (this.GridViewFI_ASS_DETAIL.Rows.Count < 1) {Utility.IsShowMsg("沒有選擇詳細異動資料"); return;} string ret = ""; if (DropDownListASS_MType.SelectedValue == "1" || DropDownListASS_MType.SelectedValue == "2") { ret = IsNullAll2(); } else { ret = IsNullAll(); } if (ret == "") { updataPageData(); setCustomAttrAll(); _AssignedDept = base.GetAssignDeptByNotSameManager(base.UserName, base.DepID); if (this.GetCustomAttr("PERNR").ToString() == this.GetCustomAttr("BPERNR").ToString()) { base.SetCustomAttr("ISDIFF", Convert.ToBoolean(false)); } else { base.SetCustomAttr("ISDIFF", Convert.ToBoolean(true)); } if (base.GetUserInfo(GetCustomAttr("BPERNR").ToString()).Rank == "01" || base.GetUserInfo(GetCustomAttr("BPERNR").ToString()).Rank == "00") { base.SetCustomAttr("ISDIFF", Convert.ToBoolean(false)); } } else { Utility.IsShowMsg(ret); return; } } if (base.GetManualDisplayName() == "起單人主管逐級簽核") { if (base.GetUserInfo(base.UserName).Rank == "01" || base.GetUserInfo(base.UserName).Rank == "00") { base.SetCustomAttr("ISOO", Convert.ToBoolean(true)); } else { base.SetCustomAttr("ISOO", Convert.ToBoolean(false)); } } com.connClose(); base.NAFCompleteApprove(this.CommentEdit1); } protected void AFRejectButton1_Click(object sender, EventArgs e) { if (this.CommentEdit1._txtComment.Text == "") { Utility.IsShowMsg("請輸入退回原因"); com.connClose(); return; } base.NAFCompleteReject(this.CommentEdit1); } protected void AFCancelProcInstButton1_Click(object sender, EventArgs e) { } protected void AFSaveDataButton1_Click(object sender, EventArgs e) { } #endregion

这两部分是连在一起的，在一个页面的。想要交代的还是有很多的啊，就怕自己说不明白，还是大家直接看吧，看不明白的地方再问。

PS:代码有点乱吧，控制的多了啊！这些代码还只是第一张页面的，其他的都没上。其他的应该跟正常的ASP.net一样的啦！