首页 > 代码库 > ERP渠道文档管理(二十三)
ERP渠道文档管理(二十三)
基本需求:
用例图:
存储过程:
CREATE PROCEDURE [dbo].[BioErpCrmChannelDocument_ADD]@DocumentID int,@ChannelID int AS INSERT INTO [BioErpCrmChannelDocument]( [DocumentID],[ChannelID] )VALUES( @DocumentID,@ChannelID )
CREATE PROCEDURE BioErpCrmChannelDocument_Update@ChannelDocumentID int,@DocumentID int,@ChannelID int,@DeleteState bit AS UPDATE [BioErpCrmChannelDocument] SET [DocumentID] = @DocumentID,[ChannelID] = @ChannelID,[DeleteState] = @DeleteState WHERE ChannelDocumentID=@ChannelDocumentID
CREATE VIEW dbo.View_CRMChannelDocumentInfo AS SELECT dbo.BioErpCrmManageChannel.ChannelName, dbo.UserManager.UserName, dbo.BioCrmCorrelationDocument.DocumentID, dbo.BioCrmCorrelationDocument.Subject, dbo.BioCrmCorrelationDocument.Name, dbo.BioCrmCorrelationDocument.Type, dbo.BioCrmCorrelationDocument.DocumentLevel, dbo.BioCrmCorrelationDocument.DocumentSize, dbo.BioCrmCorrelationDocument.ExetendName, dbo.BioCrmCorrelationDocument.[Content], dbo.BioCrmCorrelationDocument.UserID, dbo.BioCrmCorrelationDocument.UploadTime, dbo.BioCrmCorrelationDocument.Remark, dbo.BioErpCrmChannelDocument.DeleteState, dbo.BioErpCrmChannelDocument.ChannelDocumentID, dbo.BioErpCrmChannelDocument.ChannelID FROM dbo.BioErpCrmChannelDocument INNER JOIN dbo.BioCrmCorrelationDocument ON dbo.BioErpCrmChannelDocument.DocumentID = dbo.BioCrmCorrelationDocument.DocumentID INNER JOIN dbo.UserManager ON dbo.BioCrmCorrelationDocument.UserID = dbo.UserManager.UserId INNER JOIN dbo.BioErpCrmManageChannel ON dbo.BioErpCrmChannelDocument.ChannelID = dbo.BioErpCrmManageChannel.ChannelID
BLL代码:
public class ChannelDocumentBLL { /// <summary> /// 文档信息添加 /// </summary> /// <param name="document">文档对象</param> /// <returns>int</returns> public int BioErpCrmChannelDocumentAdd(BioErpCrmChannelDocument document) { SqlParameter[] pars = new SqlParameter[]{ new SqlParameter("@DocumentID",document.DocumentID), new SqlParameter("@ChannelID",document.ChannelID) }; return DataBaseHelper.ExcuteSqlReturnInt("BioErpCrmChannelDocument_ADD", CommandType.StoredProcedure, pars); } /// <summary> /// 修改文档对象 /// </summary> /// <param name="document">文档对象</param> /// <returns>int</returns> public int BioErpCrmChannelDocumentUpdate(BioErpCrmChannelDocument document) { SqlParameter[] pars = new SqlParameter[]{ new SqlParameter("@ChannelDocumentID",document.ChannelDocumentID), new SqlParameter("@DocumentID",document.DocumentID), new SqlParameter("@ChannelID",document.ChannelID), new SqlParameter("@DeleteState",document.DeleteState) }; return DataBaseHelper.ExcuteSqlReturnInt("BioErpCrmChannelDocument_Update", CommandType.StoredProcedure, pars); } /// <summary> /// 根据ID查询文档的详细信息 /// </summary> /// <param name="id"></param> /// <returns></returns> public ViewCRMChannelDocumentInfo getChannelDocumentViewByDocumentID(string id) { SqlDataReader reader= CommTool.SqlComm.GetDataReaderByCondition("View_CRMChannelDocumentInfo", "*", " DocumentID=" + id); ViewCRMChannelDocumentInfo view= null; if (reader.Read()) { view = new ViewCRMChannelDocumentInfo() { UserName = reader["UserName"].ToString(), ChannelName = reader["ChannelName"].ToString(), DocumentID = int.Parse(reader["DocumentID"].ToString()), UserID = int.Parse(reader["UserID"].ToString()), UploadTime = Convert.ToDateTime(reader["UploadTime"].ToString()), Type = reader["Type"].ToString(), Subject = reader["Subject"].ToString(), Remark = reader["Remark"].ToString(), Name = reader["Name"].ToString(), ExetendName = reader["ExetendName"].ToString(), DocumentSize = long.Parse(reader["DocumentSize"].ToString()), DocumentLevel = reader["DocumentLevel"].ToString() }; } reader.Close(); return view; } }
前端代码:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ChannelDocumentAdd.aspx.cs" Inherits="BioErpWeb.CRMSystem.CrmChannelDocument.ChannelDocumentAdd" %><!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="http://www.mamicode.com/Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" /> <link href="http://www.mamicode.com/Styles/CalenderStyle.css" rel="stylesheet" type="text/css" /> <script src="http://www.mamicode.com/JS/ChannelChoose.js" type="text/javascript"></script> <script src="http://www.mamicode.com/Scripts/jquery-1.4.1.min.js" type="text/javascript"></script> <script src="http://www.mamicode.com/Scripts/jquery.validate.js" type="text/javascript"></script> <script src="http://www.mamicode.com/Scripts/ValidateMessage_ZW.js" type="text/javascript"></script> <script type="text/javascript"> $(document).ready(function () { $("#form1").validate(); }); </script></head><body> <form id="form1" runat="server"> <div> <table class="maintable"> <tr> <td colspan="2" class="titlebar"><span>渠道文档信息上传</span></td> </tr> <tr> <td>主题</td><td><asp:TextBox ID="txtsubJect" runat="server" CssClass="required"></asp:TextBox></td> </tr> <tr> <td> 文档等级</td> <td> <asp:DropDownList ID="ddlLevel" runat="server"> <asp:ListItem Selected="True">一般文件</asp:ListItem> <asp:ListItem>重要文件</asp:ListItem> <asp:ListItem>非常重要文件</asp:ListItem> <asp:ListItem>特别重要</asp:ListItem> </asp:DropDownList> </td> </tr> <tr> <td> 文档选择</td> <td> <asp:FileUpload ID="FileUpload1" runat="server" /> </td> </tr> <tr> <td> 所属渠道 </td> <td > <asp:TextBox ID="txtSuperChannelID" runat="server"></asp:TextBox><input type="button" value="http://www.mamicode.com/选择" style=" width:100px;" onclick="showChannel()" /> </td> </tr> <tr> <td> 说明</td> <td > <asp:TextBox ID="txtRemark" TextMode="MultiLine" Rows="5" runat="server" Width="380px"></asp:TextBox> </td> </tr> <tr> <td colspan="2" class="bottomtd"> <asp:Button ID="btnSubmit" runat="server" Text="文档信息上传" onclick="btnSubmit_Click" /> <asp:Button ID="btnReturn" runat="server" Text="返回列表" UseSubmitBehavior="false" onclick="btnReturn_Click" /> </td> </tr> </table> <br /> </div> </form></body></html>
后端代码:
public partial class ChannelDocumentAdd : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { Session["Userid"] = "29"; if (!IsPostBack) { } } protected void btnSubmit_Click(object sender, EventArgs e) { BioCrmCorrelationDocument document = new BioCrmCorrelationDocument(); document.Subject = this.txtsubJect.Text; document.Name = DateTime.Now.ToString("yyyyMMddhhmmss") + this.FileUpload1.FileName; document.UserID = int.Parse(Session["Userid"].ToString()); document.Remark = this.txtRemark.Text; document.DocumentLevel = this.ddlLevel.SelectedValue; document.Content = this.FileUpload1.FileBytes; document.DocumentSize = this.FileUpload1.FileContent.Length; document.Type = this.FileUpload1.PostedFile.ContentType; document.ExetendName = System.IO.Path.GetExtension(this.FileUpload1.FileName); //物理文件上传 string filepath = Server.MapPath(@"\Files\CRMChannelFiles\"); Comm.FileUpLoad(this.FileUpload1, filepath, document.Name); BioCrmCorrelationDocumentBLL documentbll = new BioCrmCorrelationDocumentBLL(); //文档信息添加 包括文件上传(转换为二进制数组后上传) int documentid = documentbll.BioCrmCorrelationDocumentAdd(document); if (documentid != 0) { BioErpCrmChannelDocument channeldocument = new BioErpCrmChannelDocument(); channeldocument.ChannelID = int.Parse(this.txtSuperChannelID.Text.ToString()); channeldocument.DocumentID = documentid; ChannelDocumentBLL channelbll = new ChannelDocumentBLL(); int count= channelbll.BioErpCrmChannelDocumentAdd(channeldocument); if (count != 0) { ClientScript.RegisterStartupScript(this.GetType(), "test", "alert(‘添加成功‘)", true); } else { SqlComm.DeleteTableByCondition("BioCrmCorrelationDocument", " DocumentID=" + documentid); ClientScript.RegisterStartupScript(this.GetType(), "test", "alert(‘添加失败‘)", true); } } } }
渠道文档管理显示界面:
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ChannelDocumentListShow.aspx.cs" Inherits="BioErpWeb.CRMSystem.CrmChannelDocument.ChannelDocumentListShow" %><%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %><%@ Register src="http://www.mamicode.com/UserControl/CRMChannelMenuBar.ascx" tagname="CRMMenuBar" tagprefix="uc1" %><!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="http://www.mamicode.com/Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" /> <link href="http://www.mamicode.com/Styles/AspNetPagerStyle.css" rel="stylesheet" type="text/css" /> <link href="http://www.mamicode.com/Scripts/jquery-ui-1.7.custom.css" rel="stylesheet" type="text/css" /> <script src="http://www.mamicode.com/Scripts/jquery-1.4.1.js" type="text/javascript"></script> <script src="http://www.mamicode.com/Scripts/jquery-ui-1.7.custom.min.js" type="text/javascript"></script> <style type="text/css"> td{ text-align:center;} .tdsearch{ line-height:30px;} .menubar{ background:url(../Web/images/block_hd_bg.png); height:25px; width:100%;} .menubar ul{ margin:0px; padding:0px; list-style:none;} .menubar ul li{ display:inline; line-height:25px;} .menubar ul li a{display:inline-block; text-align:center; width:100px; color:#0066CC; text-decoration:none;} </style> <script type="text/javascript"> $().ready(function () { $("#txtDate").datepicker({dateFormat:‘yy-mm-dd‘}); }); </script></head><body> <form id="form1" runat="server"> <div> <uc1:CRMMenuBar ID="CRMMenuBar1" runat="server" /> </div> <div> <table class="maintable" style=" width:900px;"> <tr> <td colspan="5" class="titlebar"> <span>渠道文档管理</span> </td> </tr> <tr> <td class="tdsearch"> <asp:Label ID="Label1" runat="server" Text="文档主题:"></asp:Label> <asp:TextBox ID="txtName" runat="server"></asp:TextBox> </td> <td class="tdsearch"> <asp:Label ID="Label2" runat="server" Text="渠道名:"></asp:Label> <asp:TextBox ID="txtCName" runat="server"></asp:TextBox> </td> <td class="tdsearch"> <asp:Label ID="Label3" runat="server" Text="上传时间:"></asp:Label> <asp:TextBox ID="txtDate" runat="server"></asp:TextBox> </td> <td class="tdsearch"> <asp:ImageButton ID="imgbutnSearch" Width="60" Height="22" runat="server" ImageUrl="~/Web/images/Btnsearch.gif" onclick="imgbutnSearch_Click" /> <asp:ImageButton ID="imgbtnNew" runat="server" Width="60" Height="22" ImageUrl="~/Web/images/btnadd.gif" onclick="imgbtnNew_Click"/> </td> </tr> <tr> <td colspan="5" class="bottomtd"> <asp:GridView ID="GridView1" Width="100%" runat="server" AutoGenerateColumns="False" DataKeyNames="DocumentID"> <Columns> <asp:TemplateField HeaderText="文档主题" HeaderStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:Label ID="Label4" runat="server" Text=‘<%# Eval("Subject") %>‘></asp:Label> </ItemTemplate> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> <asp:TemplateField HeaderText="文档名" HeaderStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:Label ID="Label5" runat="server" Text=‘<%# Eval("Name") %>‘></asp:Label> </ItemTemplate> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> <asp:TemplateField HeaderText="所属渠道" HeaderStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:Label ID="Label6" runat="server" Text=‘<%# Eval("ChannelName") %>‘></asp:Label> </ItemTemplate> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> <asp:TemplateField HeaderText="文件级别" HeaderStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:Label ID="Label7" runat="server" Text=‘<%# Eval("DocumentLevel") %>‘></asp:Label> </ItemTemplate> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> <asp:TemplateField HeaderText="上传时间" HeaderStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:Label ID="Label9" runat="server" Text=‘<%# Convert.ToDateTime( Eval("UploadTime")).ToString("yyyy-MM-dd") %>‘></asp:Label> </ItemTemplate> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> <asp:TemplateField HeaderText="上传用户" HeaderStyle-HorizontalAlign="Center"> <ItemTemplate> <asp:Label ID="Label9" runat="server" Text=‘<%# Eval("UserName") %>‘></asp:Label> </ItemTemplate> <HeaderStyle HorizontalAlign="Center"></HeaderStyle> <ItemStyle HorizontalAlign="Center" /> </asp:TemplateField> <asp:HyperLinkField DataNavigateUrlFields="DocumentID" DataNavigateUrlFormatString="DocumentEditAndDown.aspx?ID={0}" HeaderText="操作" Text="下载/编辑"> <HeaderStyle HorizontalAlign="Center" /> <ItemStyle HorizontalAlign="Center" /> </asp:HyperLinkField> </Columns> </asp:GridView> </td> </tr> <tr> <td colspan="5"> <webdiyer:AspNetPager ID="AspNetPager1" runat="server" CssClass="paginator" CurrentPageButtonClass="cpb" onpagechanged="AspNetPager1_PageChanged"> </webdiyer:AspNetPager> </td> </tr> </table> </div> </form></body></html>
后端代码:
public partial class ChannelDocumentListShow : System.Web.UI.Page { 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"); return; } if (!IsPostBack) { getallPageList(); } } /// <summary> /// 查询所有联系人信息 /// </summary> private void getallPageList() { string id = Session["Userid"].ToString(); condition += " and UserID=" + id; if (UserLogin.user.RoleId == 6) //市场部经理 { condition += " or UserID !=" + id; } this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("dbo.View_CRMChannelDocumentInfo", condition); this.AspNetPager1.PageSize = pagesize; this.GridView1.DataSource = SqlComm.getDataByPageIndex("dbo.View_CRMChannelDocumentInfo", "*", "DocumentID", condition, pageindex, pagesize); this.GridView1.DataBind(); } protected void AspNetPager1_PageChanged(object sender, EventArgs e) { pageindex = this.AspNetPager1.CurrentPageIndex - 1; getallPageList(); } 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.txtCName.Text.Trim() != null && this.txtCName.Text.Trim().Length != 0) { condition = condition + " and ChannelName like ‘" + txtCName.Text + "%‘"; } if (this.txtDate.Text.Trim() != null && this.txtDate.Text.Trim().Length!=0) { condition = condition + " and (UploadTime >= ‘" + this.txtDate.Text + "‘ AND UploadTime< ‘" + Convert.ToDateTime(this.txtDate.Text).AddDays(1) + "‘)"; } getallPageList(); } protected void btnNew_Click(object sender, EventArgs e) { } protected void imgbtnNew_Click(object sender, ImageClickEventArgs e) { Server.Transfer("ChannelDocumentAdd.aspx"); } }
ERP渠道文档管理(二十三)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。