ERP出库审核业务（四十四）

ERP出库审核业务（四十四）

结束表单流程的代码：

protected void btnSubmit_Click(object sender, EventArgs e) { if(this.txtreceiveDate.Text!="") { SqlComm.UpdateTableByCondition("BioSendAppInfo", "receiveDate='" + Convert.ToDateTime(this.txtreceiveDate.Text) + "'", "SendId=" + taskid); } }

根据销售表单统计此表单总金额：

-- Description: 根据销售表单统计此表单总金额-- =============================================ALTER FUNCTION [dbo].[FN_getSendTotalMoneyBySendID] ( @SendID int)RETURNS moneyASBEGIN DECLARE @TotalMoney money SELECT @TotalMoney=sum(ProPrice*ProCount) FROM dbo.BioSendGoodsProWHERE SendID=@SendID RETURN @TotalMoneyEND

创建查询视图：

CREATE VIEW [dbo].[View_SendAppInfoShowList]ASSELECT *,AuditingSate=dbo.FN_CurrentAuditingSate(3,SendId), Transmitter=ISNULL(dbo.FN_CurrentTransmitter(3,SendId),'数据错误'), Listid= ISNULL(dbo.FN_GetDynamicId(3,SendId),0),SendTotal=dbo.FN_getSendTotalMoneyBySendID(SendId) FROM dbo.View_BioSendAppInfo

产品销售发货列表查询：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="SendGoodsListShow.aspx.cs" Inherits="BioErpWeb.SendGoods.SendGoodsListShow" %><%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %><%@ Register src="../UserControl/SendProTop.ascx" tagname="SendProTop" tagprefix="uc1" %>

			否 是
&listid=<%#Eval("Listid")%>">查看详细

后台代码：

public partial class SendGoodsListShow: BasePage { public static int pageindex = 0; public static int pagesize = 10; public static string condition = ""; protected void Page_Load(object sender, EventArgs e) { //Session["Userid"] = "29"; if (Session["Userid"] == null) { Response.Redirect("../../web/UserLogin.aspx"); } if (!IsPostBack) { getallBioCRMContractList(); } } ///

/// 查询所有员工信息 ///

private void getallBioCRMContractList() { //如果有发货管理权限（特许权限）的人员可以查看所有表单 if (SqlComm.getUserRightsByUserId(Session["Userid"].ToString()).Contains(",51,")) { this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("dbo.View_SendAppInfoShowList", condition); this.AspNetPager1.PageSize = pagesize; this.GridView1.DataSource = SqlComm.getDataByPageIndex("dbo.View_SendAppInfoShowList", "*", "SendId", condition, pageindex, pagesize); this.GridView1.DataBind(); } else if (Web.UserLogin.user.RoleId == ((int)RoseEmun.DepartMentManager)) { condition = condition + " and DepartMentID=" + Web.UserLogin.user.DepartmentId; this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("dbo.View_SendAppInfoShowList", condition); this.AspNetPager1.PageSize = pagesize; this.GridView1.DataSource = SqlComm.getDataByPageIndex("dbo.View_SendAppInfoShowList", "*", "SendId", condition, pageindex, pagesize); this.GridView1.DataBind(); } else //员工只能看自己的购进单 { condition = condition + " and AppUserId=" + Session["Userid"].ToString(); this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("dbo.View_SendAppInfoShowList", condition); this.AspNetPager1.PageSize = pagesize; this.GridView1.DataSource = SqlComm.getDataByPageIndex("dbo.View_SendAppInfoShowList", "*", "SendId", condition, pageindex, pagesize); this.GridView1.DataBind(); } for (int i = 0; i < GridView1.Rows.Count; i++) { switch (GridView1.Rows[i].Cells[1].Text) { case "0": GridView1.Rows[i].Cells[1].Text = "待审核"; GridView1.Rows[i].Cells[1].ForeColor = System.Drawing.Color.Green; break; case "2": GridView1.Rows[i].Cells[1].Text = "执行中"; GridView1.Rows[i].Cells[1].ForeColor = System.Drawing.Color.Orange; break; case "3": GridView1.Rows[i].Cells[1].Text = "已完成"; GridView1.Rows[i].Cells[1].ForeColor = System.Drawing.Color.Green; break; default: GridView1.Rows[i].Cells[1].Text = "出现错误"; break; } } } protected void AspNetPager1_PageChanged(object sender, EventArgs e) { pageindex = this.AspNetPager1.CurrentPageIndex - 1; getallBioCRMContractList(); } protected void imgbutnSearch_Click(object sender, ImageClickEventArgs e) { pageindex = 0; condition = ""; if (txtName.Text.Trim() != null && this.txtName.Text.Trim().Length != 0) { condition = condition + " and Subject like '" + txtName.Text + "%'"; } if (this.txtUserName.Text.Trim() != null && this.txtUserName.Text.Trim().Length != 0) { condition = condition + " and AppUserName like '" + txtUserName.Text + "%'"; } if (this.ddlState.SelectedValue == "1") { condition = condition + " and DeleteSate ='True'"; } else { condition = condition + " and DeleteSate ='False'"; } if (this.txtOrderTime.Text.Trim() != null && this.txtOrderTime.Text.Trim().Length != 0) { condition = condition + " and (submitTime>= '" + Convert.ToDateTime(this.txtOrderTime.Text) + "' and submitTime<'" + Convert.ToDateTime(this.txtOrderTime.Text).AddDays(1) + "')"; } getallBioCRMContractList(); } protected void Button1_Click(object sender, EventArgs e) { Response.Redirect("../SendGoods/BaoBiao/SendProInfoOutput.aspx"); } }

权限的判断：

public partial class ToOtherAspx :BasePage { protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["id"] == null || Request.QueryString["listid"] == null) { Response.Redirect("SendGoodsListShow.aspx"); return; } string id = Request.QueryString["id"].ToString(); string listid = Request.QueryString["listid"].ToString(); System.Data.DataTable dt = CommTool.SqlComm.GetDataByCondition("dbo.TaskListRecord", "ListID,TaskID,TaskTableID,Accepter,AuditingSate", " ListID=" + listid).Tables[0]; if (dt.Rows.Count == 0) { Response.Redirect("SendGoodsListShow.aspx"); return; } if (dt.Rows[0]["Accepter"].ToString() != Session["Userid"].ToString()) { Response.Redirect("SendGoodsShow.aspx?taskid=" + id + "&listid=" + listid); return; } else { if (dt.Rows[0]["AuditingSate"].ToString() == "0") { Response.Redirect("SendGoodsEdit.aspx?taskid=" + id + "&listid=" + listid); return; } else if (dt.Rows[0]["AuditingSate"].ToString() == "2") { Response.Redirect("SendGoodsRun.aspx?taskid=" + id + "&listid=" + listid); return; } else if (dt.Rows[0]["AuditingSate"].ToString() == "3") { Response.Redirect("SendGoodsShow.aspx?taskid=" + id + "&listid=" + listid); return; } else { Response.Redirect("SendGoodsListShow.aspx"); return; } } } }

水晶报表打印：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="SendProInfoOutput.aspx.cs" Inherits="BioErpWeb.SendGoods.BaoBiao.SendProInfoOutput" %><%@ Register assembly="Microsoft.ReportViewer.WebForms, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" namespace="Microsoft.Reporting.WebForms" tagprefix="rsweb" %>

出库单打印：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ChuKuPrint.aspx.cs" Inherits="BioErpWeb.Print.ChuKuPrint" %>

<% //产品发货单基本信息（1条） System.Data.DataSet ds = GetDataSet(); //产品批号信息（多条） System.Data.DataSet ds1 = this.GetProBatchsDataSet(); int mypage = 0; if ((ds1.Tables[0].Rows.Count) % 5 == 0) { mypage = (int)((ds1.Tables[0].Rows.Count) / 5); } else { mypage = ((int)((ds1.Tables[0].Rows.Count) / 5)) + 1; } decimal mon = 0; for (int n = 0; n < ds1.Tables[0].Rows.Count; n++) { mon += Convert.ToDecimal(ds1.Tables[0].Rows[n]["ProBatchPriceTotal"].ToString().Trim()); } //Convert.ToDecimal(mon); int x = ds1.Tables[0].Rows.Count; //绑定固定的联系人或者制单人名 for (int i = 0; i < x;) { %>

<%=ds.Tables[0].Rows[0]["OurCom"]%>产品出库（验收、通知）单 发货单位： <%=ds.Tables[0].Rows[0]["OurCom"]%> 联系人： <%=ds.Tables[0].Rows[0]["RealUser"]%> 系统单号： <%=DateTime.Now.ToString("yyyyMMddhhmmss")+ds.Tables[0].Rows[0]["SendID"]%> 收货单位： <%=ds.Tables[0].Rows[0]["ReceiveComName"]%> 发货时间： <%=Convert.ToDateTime(ds.Tables[0].Rows[0]["sendDate"]).ToString("yyyy-MM-dd")%> 自定义单号： <% decimal currentmoney = 0; for (int j = 0; j < 5 && i < x; j++, i++) { currentmoney += Convert.ToDecimal(ds1.Tables[0].Rows[i]["ProBatchPriceTotal"]); %> <% } %> 商品名称 规 格 生产企业 单位 数量 单价 金额 生产日期 批号 有效期 <%=i+1 %> <%=ds1.Tables[0].Rows[i]["ProName"]%> <%=ds1.Tables[0].Rows[i]["Spec"]%> <%=ds1.Tables[0].Rows[i]["MadeEnterprise"]%> <%=ds1.Tables[0].Rows[i]["Unit"]%> <%=ds1.Tables[0].Rows[i]["proCount"]%> <%=Convert.ToDecimal(ds1.Tables[0].Rows[i]["ProPrice"]).ToString("0.00")%> <%=Convert.ToDecimal(ds1.Tables[0].Rows[i]["ProBatchPriceTotal"]).ToString("0.00")%> <%=Convert.ToDateTime(ds1.Tables[0].Rows[i]["makeDate"]).ToString("yyyy-MM-dd")%> <%=ds1.Tables[0].Rows[i]["batchNum"]%> <%=Convert.ToDateTime(ds1.Tables[0].Rows[i]["expirationDate"]).ToString("yyyy-MM-dd")%> 本单入库金额小计：<%=CommTool.StringHandler.CmycurD(currentmoney)+"(￥"+currentmoney.ToString("0.00")+")" %> 整单入库金额合计：<%=CommTool.StringHandler.CmycurD(mon)+"(￥"+mon.ToString("0.00")+")"%> 单位：合格 发货人： 质量审核人： 送货人： 收货人： 白 联：存根联 红 联：财务联 绿 联：发货联 蓝 联：收货联 黄 联：随货 制单人：" /> P．<%=((int)((i - 1) / 5)) + 1%>/<%=mypage%> <% } %>

后台的代码：

public partial class ChuKuPrint: System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["Sendid"] != null) { } else { Response.Redirect("SendGoodsShow.aspx"); return; } } ///

/// 获取发货申请表单基本信息 ///

/// public DataSet GetDataSet() { string id = Request.QueryString["Sendid"].ToString(); DataSet ds = SqlComm.GetDataByCondition("dbo.View_SendAppInfoShowList", "*", "Sendid=" + id); return ds; } ///

/// 发货产品批号信息 ///

/// DataSet public DataSet GetProBatchsDataSet() { string id = Request.QueryString["Sendid"].ToString(); DataSet ds = SqlComm.GetDataByCondition("dbo.View_SendGoodsBatchInfoPrint", "*", "Sendid=" + id); return ds; } }

打印的视图：

CREATE VIEW [dbo].[View_SendGoodsBatchInfoPrint]ASSELECT ProName, Spec=dbo.FN_getProSpecbyProID(ProID), MadeEnterprise=dbo.FN_getMadeEnterpriseByProID(ProID), Unit=dbo.FN_getProUnitbyProID(ProID), ProBatchID, SendProID, batchNum, boxNum, proCount, ProPrice, ProBatchPriceTotal=proCount*ProPrice, ProStockID, stockDate, stockID, expirationDate, makeDate, SendID, ProID FROM dbo.View_SendGoodsProBatchInfo

发货的产品批号的视图：

CREATE VIEW [dbo].[View_SendGoodsProBatchInfo]ASSELECT a.*,b.ProBatchID,b.batchNum,b.boxNum,b.proCount AS BatchProCount,b.ProStockID,b.stockDate,b.expirationDate,b.makeDate,b.stockID,b.isprinted, ProName=dbo.FN_getProNameByProID(a.ProID) FROM dbo.BioSendGoodsPro AS a INNER JOIN dbo.BioSendProBatch AS bON b.SendProID = a.SendProID

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。