ERP退货系统管理（四十五）

2022-08-04 19:32:38

添加的存储过程：（添加退货申请信息的存储过程）

CREATE PROCEDURE [dbo].[BioBackSendGoods_ADD]

@SendBackID INT OUTPUT,

@SubJect NVARCHAR(100),

@AppUserID INT,

@DepartMentID INT,

@EndTimeLimit DATETIME,

@SendUnit NVARCHAR(100),

@BackUnit INT,

@SendID INT,

@SendAppUser INT,

@SendRealUser INT,

@SendDate DATETIME,

@BackRealUser INT

 AS

    INSERT INTO [BioBackSendGoods](

    [SubJect],[AppUserID],[DepartMentID],[EndTimeLimit],[SendUnit],[BackUnit],[SendID],[SendAppUser],[SendRealUser],[SendDate],[BackRealUser]

    )VALUES(

    @SubJect,@AppUserID,@DepartMentID,@EndTimeLimit,@SendUnit,@BackUnit,@SendID,@SendAppUser,@SendRealUser,@SendDate,@BackRealUser

    )

    SET @SendBackID = @@IDENTITY

GO

视图：

CREATE VIEW [dbo].[BioBackSendGoodsViews]

AS

SELECT

	SendBackID,

	SubJect,

	AppUserID,

	AppUserName=dbo.getUserNameByUserID(AppUserID),

	SubmitTime,

	DepartMentID,

	DepartMentName=dbo.FN_GetDepartMentByID(DepartMentID),

	EndTimeLimit,

	DeleteSate,

	SendUnit,

	BackUnit,

	BackUnitName=dbo.getCustomerByID(BackUnit),

	SendID,

	SendAppUser,

	SendAppUserName=dbo.getUserNameByUserID(SendAppUser),

	SendRealUser,

	SendRealUserName=dbo.getUserNameByUserID(SendRealUser),

	SendDate,

	BackRealUser,

	BackRealUserName=dbo.getUserNameByUserID(BackRealUser),

	DoneTime,

	isQualityCheck,

	QualityUserID,

	QualityUserName=dbo.getUserNameByUserID(QualityUserID),

	isfinance,

	FinanceUserID,

	FinanceUserName=dbo.getUserNameByUserID(FinanceUserID),

	StockUserid,

	StockUserName=dbo.getUserNameByUserID(StockUserid),

	IsStockAllow,

	StockID,

	StockName=dbo.FN_getStockNameByStockID(StockID),

	BackProTotalCount=ISNULL(dbo.FN_getTotalProCount(SendBackID),0),

	BackProTotalMoney=ISNULL(dbo.FN_getTotalProMoney(SendBackID),0)

FROM

	BioBackSendGoods

添加退货产品信息的存储过程：

CREATE PROCEDURE [dbo].[BioBackGoodsPro_ADD]

@BackSendID INT,

@ProID INT,

@ProName NVARCHAR(100),

@SendCount INT,

@BackGoodsCount INT,

@BackProBaths NVARCHAR(100),

@SendPrice MONEY,

@BackPrice MONEY,

@StockDate DATETIME,

@ExPriationDate DATETIME,

@MakeDate DATETIME,

@ReturnBackBox NVARCHAR(100),

@proBaths NVARCHAR(100)

 AS

	INSERT INTO [BioBackGoodsPro](

	[BackSendID],[ProID],[ProName],[SendCount],[BackGoodsCount],[BackProBaths],[SendPrice],[BackPrice],[StockDate],[ExPriationDate],
[MakeDate],[ReturnBackBox],[proBaths]

	)VALUES(

	@BackSendID,@ProID,@ProName,@SendCount,@BackGoodsCount,@BackProBaths,@SendPrice,@BackPrice,@StockDate,@ExPriationDate,
@MakeDate,@ReturnBackBox,@proBaths

	)

退货申请的前端页面：

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="BackSendGoodsNew.aspx.cs"

    Transaction="Required" Inherits="BioErpWeb.BackSendGoods.BackSendGoodsNew" %>

<%@ Register Src="../UserControl/BaseTop.ascx" TagName="BaseTop" TagPrefix="uc2" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

    <link href="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />

    <link href="../Styles/Style.css" rel="stylesheet" type="text/css" />

    <script src="../Scripts/jquery-1.4.1.js" type="text/javascript"></script>

    <script src="../Scripts/jquery.validate.js" type="text/javascript"></script>

    <script src="../Scripts/validateExtender.js" type="text/javascript"></script>

    <script src="../Scripts/ValidateMessage_ZW.js" type="text/javascript"></script>

    <script src="../Scripts/jquery.metadata.js" type="text/javascript"></script>

    <link href="../Styles/InputStyle1.css" rel="stylesheet" type="text/css" />

    <script src="../JS/CheckDepartMent.js" type="text/javascript"></script>

    <script src="../Scripts/jquery-ui-1.7.custom.min.js" type="text/javascript"></script>

    <link href="../Scripts/jquery-ui-1.7.custom.css" rel="stylesheet" type="text/css" />

    <script src="../JS/CheckUserName.js" type="text/javascript"></script>

    <script src="../JS/CustomerName.js" type="text/javascript"></script>

    <script src="../JS/ProNameChoose.js" type="text/javascript"></script>

    <script src="../JS/SendNumberCheck.js" type="text/javascript"></script>

    <script src="../Scripts/Comm.js" type="text/javascript"></script>

    <script type="text/javascript">

        $(document).ready(function () {

            $("#form1").validate();

        });

    </script>

    <style type="text/css">

        .trbar

        {

            background-color: #eeeeee;

        }

        .w80

        {

            width: 80px;

        }

        .w100

        {

            width: 100px;

        }

        .w150

        {

            width: 150px;

        }

    </style>

</head>

<body>

    <form id="form1" runat="server">

    <asp:ScriptManager ID="ScriptManager1" runat="server">

    </asp:ScriptManager>

    <div>

        <table class="maintable Inupttable" style="width: 900px;">

            <tr>

                <td colspan="8">

                    <uc2:BaseTop ID="BaseTop1" runat="server" />

                </td>

            </tr>

            <tr>

                <td class="w80">

                    申请部门

                </td>

                <td class="w150">

                    <asp:DropDownList ID="ddlDepartMent" runat="server">

                    </asp:DropDownList>

                </td>

                <td class="style14">

                    制表人

                    <asp:Label ID="lbApplayUser" runat="server"></asp:Label>

                </td>

                <td>

                    经手人

                </td>

                <td>

                    <asp:TextBox ID="txtRealUserID" CssClass="{required:true,digits:true, min:1}" runat="server"

                        Width="78px"></asp:TextBox>

                    <input id="btnUser" type="button" value="选择" class="btnchoose" onclick="showDialog3()" />

                </td>

                <td>

                    制表时间

                </td>

                <td>

                    <asp:Label ID="lbTime" runat="server" Text="Label"></asp:Label>

                </td>

            </tr>

        </table>

        <asp:UpdatePanel ID="UpdatePanel1" runat="server">

            <ContentTemplate>

                <table class="maintable Inupttable" style="width: 900px;">

                    <tr>

                        <td>

                            <span>退货客户</span><span>

                                <asp:TextBox ID="txtSendCom" runat="server" Width="59px" CssClass="{required:true,digits:true, min:1}"

                                    OnTextChanged="txtSendCom_TextChanged"></asp:TextBox>

                                <asp:Button ID="Button2" runat="server" Text="选择" UseSubmitBehavior="false" class="btnchoose"

                                    OnClientClick="showCustomerDialog3()" />

                                <asp:Label ID="Label2" runat="server" Text="→" ForeColor="Green"></asp:Label>

                                <asp:Label ID="lbCustomer" runat="server" Text=""></asp:Label>

                            </span><span>选择退货单据</span> <span>

                                <asp:TextBox ID="txtSendNumber" runat="server"

                                ontextchanged="txtSendNumber_TextChanged"></asp:TextBox>

                                <asp:Button ID="Button3" runat="server" class="btnchoose" OnClientClick="{showBackSendNumber($('#txtSendCom').val())}"

                                    Text="选择" UseSubmitBehavior="false" />

                                <asp:Label ID="Label1" runat="server" CssClass="red" Text="提示:请按箭头指向顺序操作，如知道发货单单号，可直接在下面输入发货单号查询">
</asp:Label>

                            </span>

                        </td>

                    </tr>

                    <tr>

                        <td>

                            <div>

                                <asp:Label ID="Label7" runat="server" CssClass="gray2" Text="以下信息为对应发货单原始记录，如需退货请在填写必要信息："></asp:Label>

                            </div>

                        </td>

                    </tr>

                </table>

                <table class="maintable Inupttable" style="width: 900px;">

                    <tr>

                        <td>

                            退货单据

                        </td>

                        <td>

                            <asp:TextBox ID="txtSendID1" Width="60px" runat="server" AutoPostBack="True"

                                ontextchanged="txtSendID1_TextChanged"></asp:TextBox>

                        </td>

                        <td class="style6">

                            发货商

                        </td>

                        <td class="style8">

                            <asp:TextBox ID="txtSendUnit" ReadOnly="true" runat="server"></asp:TextBox>

                        </td>

                        <td class="style11">

                            退货商

                        </td>

                        <td>

                            <asp:TextBox ID="txtBackUnit" ReadOnly="true" runat="server"></asp:TextBox>

                        </td>

                        <tr>

                            <td>

                                发货申请人

                            </td>

                            <td>

                                <asp:TextBox ID="txtSenApplay" ReadOnly="true" Width="60px" runat="server"></asp:TextBox>

                            </td>

                            <td class="style6">

                                发货经手人

                            </td>

                            <td class="style8">

                                <asp:TextBox ID="txtSendRealUser" ReadOnly="true" runat="server"></asp:TextBox>

                            </td>

                            <td class="style11">

                                发货时间

                            </td>

                            <td>

                                <asp:TextBox ID="txtSendDate" ReadOnly="true" runat="server"></asp:TextBox>

                            </td>

                        </tr>

                </table>

                   <table id="tb2" cellpadding="0" border="0" cellspacing="0" class="maintable Inupttable"

            style="width: 900px;">

            <tr>

                <td class="blue4">

                    产 品 名 称 及 规 格( 批号货号信息 )

                </td>

                <td class="blue4">

                    可退货数量

                </td>

                <td class="blue4">

                    退货数量

                </td>

                <td class="blue4">

                    发货价

                </td>

                <td class="blue4">

                    退货价

                </td>

                <td class="blue4">

                    批号

                </td>

                <td class="blue4">

                    退货货号

                </td>

                <td class="blue4">

                    入库日期

                </td>

                <td class="blue4">

                    近效期

                </td>

             <td class="blue4">

                 生产日期

             </td>

            </tr>

            <tr>

                <td id="td2" class="blue4" style="width: 200px;">

                    <input id="txtProName0" readonly="readonly" name="txtProName0" type="text" class="input"

                        style="color: green; width: 200px" />

                    <input name="txtProID" type="hidden" />

                </td>

                <td>

                    <input id="txtProCount0" readonly="readonly" name="txtProCount0" class="input" type="text"

                        style="color: green; width: 60px;" />

                </td>

                <td>

                    <input id="txtBacknum" name="txtBaxknum" maxlength="7" title="提示：这里填写退货数量，如果此产品不退货，请保持它的默认值0。"

                        class="input" style="width: 60px;" type="text" value="0" />

                </td>

                <td>

                    <input id="txtProPrice0" readonly="readonly" name="txtProPrice0" class="input" style="color: green;

                        width: 60px" type="text" />

                </td>

                <td>

                    <input id="txtbackPrice" name="txtbackPrice" maxlength="8" class="input" title="提示：此处填写退货价格，此处默认为发货价格，可以根据需要修改"

                        style="width: 60px;" type="text" value="0" />

                </td>

                <td class="blue4">

                    <input id="txtProBatch0" name="txtProBatch0" readonly="readonly" class="input" style="width: 85px;

                        color: green" type="text" />

                </td>

                <td>

                    <input id="txtProBoxNum0" name="txtProBoxNum0" class="input" style="width: 105px;"

                        maxlength="50" title="提示：此处填写货号，此处为默认货号，可根据需要修改" type="text" />

                </td>

                <td>

                    <input id="txtMarkDate0" readonly="readonly" name="txtStockDate0" class="input" style="width: 70px;

                        color: green" type="text" />

                </td>

                <td>

                    <input id="txtExPirationDate0" readonly="readonly" name="txtExPirationDate0" class="input"

                        style="width: 70px; color: green" type="text" />

                </td>

                <td>

			<input id="txtMakeDate"  name="txtMakeDate" class="input" title="提示：此处生产日期默认'1900-01-01'，
如果知道真实生产日期，请修改为退货产品的真实日期；如果不知道，请保持默认值。格式：YYYY-MM-DD" style="width:75px;" 	type="text" value="1900-01-01" />

			</td>

            </tr>

        </table>

            </ContentTemplate>

        </asp:UpdatePanel>

        <table class="maintable Inupttable" style="width: 900px;">

            <tr>

                <td>

                    备注：

                </td>

                <td colspan="5">

                    <asp:TextBox ID="txtRemark" runat="server" Width="523px"></asp:TextBox>

                </td>

                <td>

                    审批核人

                </td>

                <td>

                    <asp:TextBox ID="txtNetUserId" CssClass="{required:true,digits:true, min:1}" runat="server"

                        Width="70px"></asp:TextBox>

                    <input id="btnUser0" type="button" value="选择" class="btnchoose" onclick="showDialog3()" />

                </td>

            </tr>

            <tr>

                <td colspan="8" class="bottomtd">

                    <asp:Button ID="btnSubmit0" runat="server" Text="暂存" OnClick="btnSubmit0_Click" />

                     <asp:Button ID="btnSubmit" runat="server" Text="保存" OnClick="btnSubmit_Click" />

                </td>

            </tr>

        </table>

         <asp:HiddenField ID="hf_applayUserid" runat="server" />

               <asp:HiddenField ID="hfBackUnitID" runat="server" />

               <asp:HiddenField ID="hfBackApplayUserid" runat="server" />

                <asp:HiddenField ID="hfBackRealUserid" runat="server" />

        <br />

        <br />

    </div>

    </form>

</body>

</html>

前端js：

//客户选择对话框

function showBackSendNumber(backUnitID) {

    if (backUnitID == undefined || backUnitID == '' || backUnitID == '请选择') {

        alert('请先选择退货单位');

        return false;

    }

    var backunitid = backUnitID;

    var re = showModalDialog("../../PersonList/SendNOList.aspx?backUnitID=" + backunitid,"", "dialogWidth=320px;dialogHeight=350px");

    var obj = window.event.srcElement;

    var td = obj.parentNode;

    var txts = td.getElementsByTagName('input');

    if (re == null || re == "") {

        if (txts[0].value == "" || txts[0].value == null) {

            txts[0].value = "请选择";

        }

    }

    else {

        txts[0].value = re;

    }

}

选择的嵌套页面的前台：

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title></title>

    <script src="../Scripts/jquery-1.4.1.js" type="text/javascript"></script>

    <link href="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />

    <script type="text/javascript">

        function search() {

            if (document.getElementById("txtSearchName").value == "") {

                alert("请输入退货单号（模糊查询）");

                return false;

            }

        }

        function choose() {

                var value = document.getElementById("sltUserList").value;

                window.returnValue = value;

                window.close();

            }

    </script>

    <style type="text/css">

        #PersonIframeList

        {

            height: 233px;

        }

    </style>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <br />

     <table>

         <tr>

             <td>

                 <span>退货单据

                     <input id="txtSearchName" name="txtSearchName" runat="server" type="text" size="50" style="width: 150px;"

                         maxlength="50" />

                     </span> <asp:Button ID="Button1" runat="server"

                     OnClientClick="search()" Text="查询" onclick="Button1_Click" />

             </td>

         </tr>

         <tr>

             <td>

               <select multiple="multiple" id="sltUserList"  onchange="choose()"

            style=" width:292px; margin:0px; height: 187px;">

                 <%=this.GetUserList%>

         </select>

             </td>

         </tr>

         <tr>

             <td style="vertical-align: bottom;" class="bottomtd">

                 <span id="chooseProName">

                     <input type="button" value="选择" onclick="choose()" style="width: 100px;" />

                 </span>

             </td>

         </tr>

     </table>

    </div>

    </form>

</body>

</html>
上一篇：java教程


下一篇：【百度地图API】建立全国银行位置查询系统（一）——如何创建地图