ERP反馈信息管理（十九）

2023-08-14 18:33:46

前台显示的界面：

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

    Inherits="BioErpWeb.CRMSystem.CustomerFeedback" %>

<!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/CalenderStyle.css" rel="stylesheet" type="text/css" />

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

    <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/ValidateMessage_ZW.js" type="text/javascript"></script>

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

    <style type="text/css">

        .style1

        {

            height: 22px;

        }

    </style>

    <script type="text/javascript">

        $().ready(function () {

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

        });

    </script>

</head>

<body>

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

    <div>

        <table class="maintable">

            <tr>

                <td colspan="2" class="titlebar">

                    客户反馈信息记录

                </td>

            </tr>

            <tr>

                <td class="style1">

                    主题</td>

                <td class="style1">

                    <asp:TextBox ID="txtSubJect" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td class="style1">

                    反馈客户

                </td>

                <td class="style1">

                    <asp:TextBox ID="txtCustomerID" CssClass="required number" runat="server" OnTextChanged="txtCustomerID_TextChanged"></asp:TextBox>

                    <asp:Button  ID="Button1" runat="server" Text="选择客户" CausesValidation="false" UseSubmitBehavior="false" OnClientClick="showCustomerDialog()" />

                </td>

            </tr>

            <tr>

                <td class="style1">

                    反馈人</td>

                <td class="style1">

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

                    </asp:DropDownList>

                </td>

            </tr>

            <tr>

                <td>

                    调查时间

                </td>

                <td>

                  <asp:TextBox ID="txtInvestigateTime" CssClass="required" onfocus="setday(this);" onclick="setday(this);"  runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    回复时间</td>

                <td>

                  <asp:TextBox ID="txtRevertTime" onfocus="setday(this);" onclick="setday(this);" CssClass="required" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    反馈类型

                </td>

                <td>

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

                        <asp:ListItem>电话</asp:ListItem>

                        <asp:ListItem>短信</asp:ListItem>

                        <asp:ListItem>Email</asp:ListItem>

                    </asp:DropDownList>

                </td>

            </tr>

            <tr>

                <td>

                    备注

                </td>

                <td>

                    <asp:TextBox ID="txtRemark" Width="552px" Height="101px" CssClass="required" runat="server"></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="返回列表" OnClick="btnReturn_Click" />

                </td>

            </tr>

        </table>

        <br />

    </div>

    </form>

</body>

</html>

存储过程（添加）：

ALTER PROCEDURE [dbo].[BioCrmCustomerFeedback_ADD]

@Subject nvarchar(100),

@UserID int,

@CustomerID int,

@LinkmanID int,

@FeedbackType nvarchar(100),

@InvestigateTime datetime,

@RevertTime datetime,

@Remark nvarchar(200)

 AS

	INSERT INTO [BioCrmCustomerFeedback](

	[Subject],[UserID],[CustomerID],[LinkmanID],[FeedbackType],[InvestigateTime],[RevertTime],[Remark]

	)VALUES(

	@Subject,@UserID,@CustomerID,@LinkmanID,@FeedbackType,@InvestigateTime,@RevertTime,@Remark

	)

修改的存储过程：

ALTER PROCEDURE [dbo].[BioCrmCustomerFeedback_Update]

@FeedbackID int,

@Subject nvarchar(100),

@UserID int,

@CustomerID int,

@LinkmanID int,

@FeedbackType nvarchar(100),

@InvestigateTime datetime,

@RevertTime datetime,

@Remark nvarchar(200),

@DeleteState bit

 AS

	UPDATE [BioCrmCustomerFeedback] SET

	[Subject] = @Subject,[UserID] = @UserID,[CustomerID] = @CustomerID,[LinkmanID] = @LinkmanID,[FeedbackType]
 = @FeedbackType,[InvestigateTime] = @InvestigateTime,[RevertTime] = @RevertTime,[Remark] = @Remark,[DeleteState] = @DeleteState

	WHERE FeedbackID=@FeedbackID

添加的后台代码：

  protected void Page_Load(object sender, EventArgs e)

        {

            Session["Userid"] = "29";

            if (Session["Userid"] == null)

            {

                Response.Redirect("~/Web/Desk.aspx");

            }

        }

        protected void btnSubmit_Click(object sender, EventArgs e)

        {

            BioCrmCustomerFeedback feedback = new BioCrmCustomerFeedback()

            {

                Subject=this.txtSubJect.Text,

                UserID = int.Parse(Session["Userid"].ToString()),

                RevertTime= Convert.ToDateTime(this.txtRevertTime.Text),

                Remark=this.txtRemark.Text,

                LinkmanID= int.Parse(ddlLinkMan.SelectedValue.ToString()),

                CustomerID=int.Parse(this.txtCustomerID.Text),

                FeedbackType=this.ddlMethod.SelectedItem.Text,

                InvestigateTime=Convert.ToDateTime(this.txtInvestigateTime.Text)                 

            };

            BioCrmCustomerFeedbackBLL feedbackbll = new BioCrmCustomerFeedbackBLL();

            if (feedbackbll.BioCrmCustomerFeedbackAdd(feedback) != 0)

            {

                ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('反馈记录保存成功')", true);

            }

        }

定义一个查询视图：

SELECT   dbo.BioCrmCustomerFeedback.FeedbackID, dbo.BioCrmCustomerFeedback.Subject,

                dbo.BioCrmCustomerFeedback.UserID, dbo.BioCrmCustomerFeedback.CustomerID,

                dbo.BioCrmCustomerFeedback.LinkmanID, dbo.BioCrmCustomerFeedback.FeedbackType,

                dbo.BioCrmCustomerFeedback.InvestigateTime, dbo.BioCrmCustomerFeedback.RevertTime,

                dbo.BioCrmCustomerFeedback.Remark, dbo.BioCrmCustomerFeedback.DeleteState,

                dbo.BioCrmCustomer.CustomerName, dbo.BioCrmLinkmanInfo.LinkmanName, dbo.UserManager.UserName

FROM      dbo.BioCrmCustomerFeedback INNER JOIN

                dbo.BioCrmCustomer ON dbo.BioCrmCustomerFeedback.CustomerID = dbo.BioCrmCustomer.CustomerID INNER JOIN

                dbo.BioCrmLinkmanInfo ON dbo.BioCrmCustomerFeedback.LinkmanID = dbo.BioCrmLinkmanInfo.LinkmanID INNER JOIN

                dbo.UserManager ON dbo.BioCrmCustomerFeedback.UserID = dbo.UserManager.UserId

显示的界面：

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

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="cc1" %>

<%@ Register assembly="AspNetPager" namespace="Wuqi.Webdiyer" tagprefix="webdiyer" %>

<%@ Register src="../UserControl/CRMMenuBar.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="../Styles/ERPBaseStyle.css" rel="stylesheet" type="text/css" />

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

    <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 src="../JS/CustomerName.js" type="text/javascript"></script>

</head>

<body>

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

    <div>

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

        </asp:ScriptManager>

        <uc1:CRMMenuBar ID="CRMMenuBar1" runat="server" />

    </div>

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

    <ContentTemplate>

    <div>

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

             <tr>

                 <td colspan="4" class="titlebar">

                     <span>客户反馈记录信息管理</span>

                 </td>

             </tr>

             <tr>

                 <td class="tdsearch">

                       <asp:Label ID="Label2" runat="server" Text="客户名："></asp:Label>

                      <asp:TextBox ID="txtCustomerID" runat="server"></asp:TextBox>

                     <input ID="Button1" value="选择客户" type="button" Width="60px"  onclick="showCustomerDialog()" />

                 </td>

                 <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="Label3" runat="server" Text="联系时间"></asp:Label>

                     <asp:TextBox ID="txtContactTime" runat="server"></asp:TextBox>

                     <cc1:CalendarExtender ID="CalendarExtender1" TargetControlID="txtContactTime" Format="yyyy-MM-dd" runat="server">

                     </cc1:CalendarExtender>

                 </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="4" class="bottomtd">

                     <asp:GridView ID="GridView1" Width="100%"  runat="server"  AutoGenerateColumns="False" DataKeyNames="FeedbackID">

                         <Columns>

                             <asp:TemplateField HeaderText="记录编号" HeaderStyle-HorizontalAlign="Center">

                                 <ItemTemplate>

                                     <asp:Label ID="Label4" runat="server" Text='<%# Eval("FeedbackID") %>'></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("Subject") %>'></asp:Label>

                                 </ItemTemplate>

                                 <ItemStyle Width="120px" HorizontalAlign="Center" />

                                 <HeaderStyle HorizontalAlign="Center"></HeaderStyle>

                                 <ItemStyle HorizontalAlign="Center" />

                             </asp:TemplateField>

                             <asp:TemplateField HeaderText="反馈客户(公司）" HeaderStyle-HorizontalAlign="Center">

                                 <ItemTemplate>

                                     <asp:Label ID="Label6" runat="server" Text='<%# Eval("CustomerName") %>'></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("LinkmanName") %>'></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("FeedbackType") %>'></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='<%# Convert.ToDateTime(Eval("InvestigateTime")).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="lbreverttime" runat="server" Text='<%# Convert.ToDateTime(Eval("RevertTime")).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="Label10" runat="server" Text='<%#Eval("UserName") %>'></asp:Label>

                                 </ItemTemplate>

                                 <HeaderStyle HorizontalAlign="Center"></HeaderStyle>

                                 <ItemStyle HorizontalAlign="Center" />

                             </asp:TemplateField>

                             <asp:TemplateField HeaderText="反馈备注" HeaderStyle-HorizontalAlign="Center">

                                 <ItemTemplate>

                                     <asp:Label ID="lbremark" runat="server" Text='<%#Eval("Remark").ToString().Length>5?Eval("Remark").ToString().Substring(0,5)+"…":Eval("Remark").ToString()  %>'></asp:Label>

                                 </ItemTemplate>

                                 <HeaderStyle HorizontalAlign="Center"></HeaderStyle>

                                 <ItemStyle HorizontalAlign="Center" />

                             </asp:TemplateField>

                             <asp:HyperLinkField DataNavigateUrlFields="FeedbackID"

                                 DataNavigateUrlFormatString="ContactRecordUpdate.aspx?ID={0}" HeaderText="操作"

                                 Text="查看并修改">

                             <HeaderStyle HorizontalAlign="Center" />

                             <ItemStyle HorizontalAlign="Center" />

                             </asp:HyperLinkField>

                         </Columns>

                     </asp:GridView>

                 </td>

             </tr>

             <tr>

              <td  colspan="4">

                  <webdiyer:AspNetPager ID="AspNetPager1" runat="server"   CssClass="paginator" CurrentPageButtonClass="cpb"

                      onpagechanged="AspNetPager1_PageChanged">

                  </webdiyer:AspNetPager>

                 </td>

             </tr>

     </table>

    </div>

    </ContentTemplate>

    </asp:UpdatePanel>

    </form>

</body>

</html>

查询的代码：

  public static int pageindex = 0;

        public static int pagesize = 10;

        public static string condition = "";

        protected void Page_Load(object sender, EventArgs e)

        {

           if (!IsPostBack)

            {

               getallPageList();

            }

        }

        /// <summary>

        /// 查询所有联系人信息

        /// </summary>

        private void getallPageList()

        {

            this.AspNetPager1.RecordCount = SqlComm.getDataCountByCondition("dbo.View_CrmCustomerFeedback", condition);

            this.AspNetPager1.PageSize = pagesize;

            this.GridView1.DataSource = SqlComm.getDataByPageIndex("dbo.View_CrmCustomerFeedback", "*", "FeedbackID", 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 = "";

            getallPageList();

        }

修改的BLL层：

  /// <summary>

      /// 修改业务

      /// </summary>

      /// <param name="model">BioCrmCustomerFeedback</param>

      /// <returns>int</returns>

      public int BioCrmCustomerFeedbackUpdate(BioCrmCustomerFeedback model)

      {

          SqlParameter[] parameters = {

					new SqlParameter("@FeedbackID", SqlDbType.Int,4),

					new SqlParameter("@Subject", SqlDbType.NVarChar,100),

					new SqlParameter("@UserID", SqlDbType.Int,4),

					new SqlParameter("@CustomerID", SqlDbType.Int,4),

					new SqlParameter("@LinkmanID", SqlDbType.Int,4),

					new SqlParameter("@FeedbackType", SqlDbType.NVarChar,100),

					new SqlParameter("@InvestigateTime", SqlDbType.DateTime),

					new SqlParameter("@RevertTime", SqlDbType.DateTime),

					new SqlParameter("@Remark", SqlDbType.NVarChar,200),

					new SqlParameter("@DeleteState", SqlDbType.Bit,1)};

          parameters[0].Value = model.FeedbackID;

          parameters[1].Value = model.Subject;

          parameters[2].Value = model.UserID;

          parameters[3].Value = model.CustomerID;

          parameters[4].Value = model.LinkmanID;

          parameters[5].Value = model.FeedbackType;

          parameters[6].Value = model.InvestigateTime;

          parameters[7].Value = model.RevertTime;

          parameters[8].Value = model.Remark;

          parameters[9].Value = model.DeleteState;

        return  DataBaseHelper.ExcuteSqlReturnInt("BioCrmCustomerFeedback_Update", CommandType.StoredProcedure, parameters);

      }

修改的界面：

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

    Inherits="BioErpWeb.CRMSystem.CustomerFeedbackEdit" %>

<!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/CalenderStyle.css" rel="stylesheet" type="text/css" />

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

    <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/ValidateMessage_ZW.js" type="text/javascript"></script>

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

    <style type="text/css">

        .style1

        {

            height: 22px;

        }

    </style>

    <script type="text/javascript">

        $().ready(function () {

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

        });

    </script>

</head>

<body>

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

    <div>

        <table class="maintable">

            <tr>

                <td colspan="2" class="titlebar">

                    客户反馈信息记录

                </td>

            </tr>

            <tr>

                <td class="style1">

                    主题</td>

                <td class="style1">

                    <asp:TextBox ID="txtSubJect" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td class="style1">

                    反馈客户

                </td>

                <td class="style1">

                    <asp:TextBox ID="txtCustomerID" CssClass="required number" runat="server" OnTextChanged="txtCustomerID_TextChanged"></asp:TextBox>

                    <asp:Button  ID="Button1" runat="server" Text="选择客户" CausesValidation="false" UseSubmitBehavior="false" OnClientClick="showCustomerDialog()" />

                </td>

            </tr>

            <tr>

                <td class="style1">

                    反馈人</td>

                <td class="style1">

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

                    </asp:DropDownList>

                    <asp:HyperLink ID="HyperLink1" NavigateUrl="~/CRMSystem/LinkManAdd.aspx" runat="server">添加联系人</asp:HyperLink>

                </td>

            </tr>

            <tr>

                <td>

                    调查人</td>

                <td>

                    <asp:TextBox ID="txtUserName" runat="server"></asp:TextBox>

                    <asp:Button ID="btn" runat="server" Text="选择员工"  OnClientClick="showDialog()" UseSubmitBehavior="false"/>

                </td>

            </tr>

            <tr>

                <td>

                    调查时间

                </td>

                <td>

                  <asp:TextBox ID="txtInvestigateTime" CssClass="required" onfocus="setday(this);" onclick="setday(this);"  runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    回复时间</td>

                <td>

                  <asp:TextBox ID="txtRevertTime" onfocus="setday(this);" onclick="setday(this);" CssClass="required" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    反馈类型

                </td>

                <td>

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

                        <asp:ListItem>电话</asp:ListItem>

                        <asp:ListItem>短信</asp:ListItem>

                        <asp:ListItem>Email</asp:ListItem>

                    </asp:DropDownList>

                </td>

            </tr>

            <tr>

                <td>

                    备注

                </td>

                <td>

                    <asp:TextBox ID="txtRemark" Width="552px" Height="101px" CssClass="required" runat="server"></asp:TextBox>

                </td>

            </tr>

            <tr>

                <td>

                    删除状态</td>

                <td>

                    <asp:CheckBox ID="cbDelete" Text="是" runat="server" />

                </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="返回列表" OnClick="btnReturn_Click" UseSubmitBehavior="false" />

                </td>

            </tr>

        </table>

        <br />

    </div>

    </form>

</body>

</html>

后台修改的代码：

 public partial class CustomerFeedbackEdit: System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

            Session["Userid"] = "29";

            if (Session["Userid"] == null)

            {

                Response.Redirect("~/Web/Desk.aspx");

            }

            if (!IsPostBack)

            {

                getpageInfobind();

            }

        }

        /// <summary>

        /// 绑定页面基本信息

        /// </summary>

        private void getpageInfobind()

        {

            if (Request.QueryString["ID"] == null)

            {

                Response.Redirect("CustomerFeedbackList.aspx");

                return;

            }

            string id=Request.QueryString["ID"].ToString();

            System.Data.SqlClient.SqlDataReader reader= SqlComm.GetDataReaderByCondition("BioCrmCustomerFeedback", "*", " FeedbackID=" + id);

           while (reader.Read())

           {

               this.txtSubJect.Text = reader["Subject"].ToString();

               this.txtRevertTime.Text = reader["RevertTime"].ToString();

               this.txtRemark.Text = reader["Remark"].ToString();

               this.txtInvestigateTime.Text = reader["InvestigateTime"].ToString();

               this.txtCustomerID.Text = reader["CustomerID"].ToString();

               //绑定反馈信息的联系人

               ddlLinkManband(reader["LinkmanID"].ToString());

               this.ddlMethod.SelectedItem.Text = reader["FeedbackType"].ToString();

               this.cbDelete.Checked =Convert.ToBoolean( reader["DeleteState"].ToString());

               this.txtUserName.Text = reader["UserID"].ToString();

           } 

        }

        /// <summary>

        /// 绑定反馈信息的联系人

        /// </summary>

        /// <param name="linkmanid"></param>

        private void ddlLinkManband(string linkmanid)

        {

            ddlLinkMan.DataSource = SqlComm.GetDataByCondition("BioCrmLinkmanInfo","LinkmanID,LinkmanName"," LinkmanID="+linkmanid);

            ddlLinkMan.DataTextField = "LinkmanName";

            ddlLinkMan.DataValueField = "LinkmanID";

            ddlLinkMan.DataBind();

            ddlLinkMan.SelectedValue = linkmanid;

        }

        protected void btnSubmit_Click(object sender, EventArgs e)

        {

            BioCrmCustomerFeedback feedback = new BioCrmCustomerFeedback()

            {

                FeedbackID=int.Parse(Request.QueryString["ID"].ToString()),

                Subject=this.txtSubJect.Text,

                UserID = int.Parse(Session["Userid"].ToString()),

                RevertTime= Convert.ToDateTime(this.txtRevertTime.Text),

                Remark=this.txtRemark.Text,

                LinkmanID= int.Parse(ddlLinkMan.SelectedValue.ToString()),

                CustomerID=int.Parse(this.txtCustomerID.Text),

                FeedbackType=this.ddlMethod.SelectedItem.Text,

                InvestigateTime=Convert.ToDateTime(this.txtInvestigateTime.Text),

                DeleteState=cbDelete.Checked                        

            };

            BioCrmCustomerFeedbackBLL feedbackbll = new BioCrmCustomerFeedbackBLL();

            if (feedbackbll.BioCrmCustomerFeedbackUpdate(feedback) != 0)

            {

                Response.Redirect("CustomerFeedbackList.aspx");

            }

        }

        protected void btnReturn_Click(object sender, EventArgs e)

        {

            Server.Transfer("CustomerFeedbackList.aspx");

        }

        protected void txtCustomerID_TextChanged(object sender, EventArgs e)

        {

         if(txtCustomerID.Text.Trim()!="" && txtCustomerID.Text.Trim().Length!=0&&txtCustomerID.Text.Trim()!="请选择")

            {

                string id=this.txtCustomerID.Text;

                System.Data.DataTable dt = SqlComm.GetDataByCondition("BioCrmLinkmanInfo", "LinkmanID,LinkmanName", "CustomerID=" + id).Tables[0];

                if (dt.Rows.Count > 0)

                {

                    this.ddlLinkMan.DataSource = dt;

                    this.ddlLinkMan.DataTextField = "LinkmanName";

                    this.ddlLinkMan.DataValueField = "LinkmanID";

                    this.ddlLinkMan.DataBind();

                }

                else

                {

                    this.ddlLinkMan.Items.Clear();

                    this.ddlLinkMan.Items.Add(new ListItem("--请选择--", "0"));

                }

            }

        }

    }

查询拼结的代码：

   protected void imgbutnSearch_Click(object sender, ImageClickEventArgs e)

        {

            pageindex = 0;

            condition = "";

            if (this.txtSubject.Text.Trim() != null && this.txtSubject.Text.Trim().Length != 0)

            {

                condition = condition + " and Subject like '" + txtSubject.Text + "%'";

            }

            if (this.txtCustomerID.Text.Trim() != null && this.txtCustomerID.Text.Trim().Length != 0)

            {

                condition = condition + " and CustomerID  ='" + this.txtCustomerID.Text + "'";

            }

            if (this.txts.Text != "" && this.txtend.Text != "")

            {

                condition = condition + " and (InvestigateTime  >='" + this.txts.Text + "' and InvestigateTime<'" + this.txtend.Text + "')";

            }

            getallPageList();

        }

自已定义js验证的扩展方法：

jQuery.extend(

jQuery.validator.messages, {

required: "必选字段",

remote: "请修正该字段",

email: "请输入正确格式的电子邮件",

url: "请输入合法的网址",

date: "请输入合法的日期",

dateISO: "请输入合法的日期 (如：2011-11-02).",

number: "请输入合法的数字",

digits: "只能输入整数",

creditcard: "请输入合法的信用卡号",

equalTo: "请再次输入相同的值",

accept: "请输入拥有合法后缀名的字符串",

maxlength: $.validator.format("请输入一个长度最多是 {0} 的字符串"),

minlength: $.validator.format("请输入一个长度最少是 {0} 的字符串"),

rangelength: $.validator.format("请输入一个长度介于 {0} 和 {1} 之间的字符串"),

range: $.validator.format("请输入一个介于 {0} 和 {1} 之间的值"),

max: $.validator.format("请输入一个最大为 {0} 的值"),

min: $.validator.format("请输入一个最小为 {0} 的值")

});
上一篇：Win环境下Oracle小数据量数据库的物理备份


下一篇：ASP.NET(C#) GridView （编辑、删除、更新、取消）