现在的位置: 首页 > 综合 > 正文

呵呵–到哪哪闲?

2013年01月30日 ⁄ 综合 ⁄ 共 15471字 ⁄ 字号 评论关闭

   先用一周时间熟悉下一期的项目。。。。

 

1。。汇总相关资料
::::::::::::建crm客户关系管理10-4-22。

2。。为treeview动态(在webconfig中)设置跳转地址。
aspx:::  <div id="navigateTree">
                <asp:TreeView ID="TreeView1" runat="server" Height="515px" ImageSet="Arrows" >
                    <ParentNodeStyle Font-Bold="True" />
                    <HoverNodeStyle Font-Underline="True" ForeColor="#5555DD" Font-Bold="False" />
                    <SelectedNodeStyle Font-Underline="True" ForeColor="#5555DD" HorizontalPadding="0px"
                        VerticalPadding="0px" Font-Bold="False" Font-Overline="False"/>
                    <Nodes>
                        <asp:TreeNode Text="标准报价规则" Value="标准报价规则" Expanded="False">
                            <asp:TreeNode NavigateUrl="~/UI/Quotation/FromZone.aspx" Target="main" Text="始发区域"

Value="始发区域"></asp:TreeNode>
                            <asp:TreeNode Text="目的区域" Value="目的区域" NavigateUrl="~/UI/Quotation/ToZone.aspx"

Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="始发地/目的地分区" Value="始发地/目的地分区"

NavigateUrl="~/UI/Quotation/FromToZone.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="服务类别" Value="服务类别" NavigateUrl="~/UI/Quotation/Service.aspx"

Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="标准报价" Value="标准报价"

NavigateUrl="~/UI/Quotation/RateDetail.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="导出标准报价记录" Value="导出标准报价记录"

NavigateUrl="~/UI/Quotation/ExportQuotation.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="导入标准报价记录" Value="导入标准报价记录"

NavigateUrl="~/UI/Quotation/ImportQuotation.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="导出DOC标准格式报价报表" Value="导出报价报表"

Target="_blank"></asp:TreeNode>
                            <asp:TreeNode Text="导出DOC明细格式报价报表" Value="导出DOC明细格式报价报表"

Target="_blank"></asp:TreeNode>
                            <asp:TreeNode Text="导出SPS标准格式报价报表" Value="导出SPS标准格式报价报表"

Target="_blank"></asp:TreeNode>
                            <asp:TreeNode Text="导出SPS明细格式报价报表" Value="导出SPS明细格式报价报表"

Target="_blank"></asp:TreeNode>
                        </asp:TreeNode>
                        <asp:TreeNode Text="折扣计算规则" Value="折扣计算规则" Expanded="False">
                            <asp:TreeNode Text="折扣模板" Value="折扣模板"

NavigateUrl="~/UI/Discount/DiscTemplateQuery.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="设置客户折扣模板" Value="设置客户折扣模板"

NavigateUrl="~/UI/Discount/SetAccountDiscountTemplate.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="导出折扣计算规则记录" Value="导出折扣计算规则记录"

NavigateUrl="~/UI/Discount/ExportDiscountRule.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="导入折扣计算规则记录" Value="导入折扣计算规则记录"

NavigateUrl="~/UI/Discount/ImportDiscountRule.aspx" Target="main"></asp:TreeNode>
                        </asp:TreeNode>
                        <asp:TreeNode Text="附加费计算规则" Value="附加费计算规则" Expanded="False">
                            <asp:TreeNode Text="附加费模板" Value="附加费模板"

NavigateUrl="~/UI/Surcharge/SurchargeTemplate.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="附加费规则" Value="附加费规则"

NavigateUrl="~/UI/Surcharge/SurchargeRule.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="附加费模板与附加费规则关系" Value="附加费模板与附加费规则关系"

NavigateUrl="~/UI/Surcharge/SurchargeTemplateRule.aspx" Target="main"></asp:TreeNode>
                            <asp:TreeNode Text="设置客户附加费模板" Value="设置客户附加费模板"

NavigateUrl="~/UI/Surcharge/SetAccountSurchargeTemplate.aspx" Target="main"></asp:TreeNode>
                        </asp:TreeNode>
                    </Nodes>
                    <NodeStyle Font-Names="Tahoma" Font-Size="10pt" ForeColor="Black" HorizontalPadding="5px"
                        NodeSpacing="0px" VerticalPadding="0px" />
                </asp:TreeView>
                </div>
cs:::
{
    if (!IsPostBack)
        {
            //动态设置TreeView节点的URL
            SetDynamURL(TreeView1.Nodes);  
        }
    }

    /// <summary>
    /// 遍历TreeView,设置字节点的URL
    /// </summary>
    /// <param name="tc"></param>
    protected void SetDynamURL(TreeNodeCollection tc)
    {
        //递归遍历TreeView的所有节点        foreach (TreeNode node in tc)
        {
            if (node.Text == "导出DOC标准格式报价报表")
            {
                node.NavigateUrl = ConfigurationManager.AppSettings["PCReport_DOC_1_URL"].ToString();
            }
            if (node.Text == "导出DOC明细格式报价报表")
            {
                node.NavigateUrl = ConfigurationManager.AppSettings["PCReport_DOC_2_URL"].ToString();
            }
            if (node.Text == "导出SPS标准格式报价报表")
            {
                node.NavigateUrl = ConfigurationManager.AppSettings["PCReport_SPS_1_URL"].ToString();
            }
            if (node.Text == "导出SPS明细格式报价报表")
            {
                node.NavigateUrl = ConfigurationManager.AppSettings["PCReport_SPS_2_URL"].ToString();
            }
            SetDynamURL(node.ChildNodes);
        }
    }

webconfig:
<appSettings>
  <add key="OCS_HQ" value="OCS, OCS-SINOTRANS"/>
  <add key="neiqin" value="销售内勤"/>
  <add key="guanliyuan" value="管理员"/>
  <add key="PCReport_DOC_1_URL" value="http://192.168.100.136/ReportServer/Pages/ReportViewer.aspx?%

2fOCS_MSCRM%2f%e6%a0%87%e5%87%86%e8%b4%b9%e7%8e%87%e8%a1%a8(DOC)&amp;rs:Command=Render"/>
  <add key="PCReport_DOC_2_URL" value="http://192.168.100.136/ReportServer/Pages/ReportViewer.aspx?%

2fOCS_MSCRM%2f%e6%98%8e%e7%bb%86%e8%b4%b9%e7%8e%87%e8%a1%a8(DOC)&amp;rs:Command=Render"/>
  <add key="PCReport_SPS_1_URL" value="http://192.168.100.136/ReportServer/Pages/ReportViewer.aspx?%

2fOCS_MSCRM%2f%e6%a0%87%e5%87%86%e8%b4%b9%e7%8e%87%e8%a1%a8(SPS)&amp;rs:Command=Render"/>
  <add key="PCReport_SPS_2_URL" value="http://192.168.100.136/ReportServer/Pages/ReportViewer.aspx?%

2fOCS_MSCRM%2f%e6%98%8e%e7%bb%86%e8%b4%b9%e7%8e%87%e8%a1%a8(SPS)&amp;rs:Command=Render"/>
  <add key="ExportPath" value="~/UI/Files/"/>
  <add key="ImportPath" value="~/UI/Files/"/>
  <add key="QuotationTemplatePath" value="~/UI/template/标准报价导入模板.xlt"/>
  <add key="DiscountTemplatePath" value="~/UI/template/折扣导入模板.xlt"/>
  <add key="CrmWebServies" value="http://192.168.0.230:5555/mscrmservices/2006/crmservice.asmx"/>
 </appSettings> 

3...js隐藏显示::
 <script type="text/javascript">
 var hideNavigateBar = 0;
      function swapNavigate()
       {
       if(hideNavigateBar==0)
         { 
         hideNavigateBar=1;
         document.getElementById("navigateTree").style.display="none";
         document.getElementById("swapNavigateSpan").innerText="显示导航栏";
         }
       else
        {
        hideNavigateBar=0;
        document.getElementById("navigateTree").style.display="block";
        document.getElementById("swapNavigateSpan").innerText="隐藏导航栏";
        }
       }
</script>

  <span onclick="swapNavigate()" id="swapNavigateSpan" style="cursor:hand;">隐藏导航栏</span>

4。。。当参数是类时,在方法体类改变了类的属性,外界是否能够看到。。。能看到
《我之前的代码有个地方多余了。。就是当给facade 传入一个parameter参数时,再返回一个parameter。。不用另外定义一个新的

parameter。直接读取传入的parameter的对应属性就可以了》

5..当项目中有自定义 的异常类时,在得到异常的地方,抛出自定义的异常

6。。 为txtbox添加 回车按钮触发事件!
 this.TextBox1.Attributes.Add("onkeydown", string.Format("javascript:if (13 == window.event.keyCode){{{0};return

false;}}", this.ClientScript.GetPostBackEventReference(this.Button1, "")));

7。。。取得datatable后先排序,再赋值给gridview::
  //如果param.GridViewDataSource的行数大于0
        if (param.GridViewDataSource != null)
        {
            //判断gridview的sort顺序,如果sort顺序不是空            if (!string.Empty.Equals(param.SortExp))
            {
                //给grid的sort顺序赋值 ///indate desc                param.GridViewDataSource.DefaultView.Sort =

param.SortExp + " " + param.SortType;
            }
            //给Gridview绑定数据源            grvToZone.DataSource = param.GridViewDataSource.DefaultView;
        }

8..把一些公共信息统一放到一个message类中。如
    public class Consts
    {
        /// <summary>
        /// Declare messages
        /// </summary>
        public class Messages
        {
            //公共信息
            public const string M_Common_001 = "新增成功!<br>";
            public const string M_Common_002 = "新增失败!<br>";
            public const string M_Common_003 = "修改成功!<br>";
            public const string M_Common_004 = "修改失败!<br>";
            public const string M_Common_005 = "删除成功!<br>";
            public const string M_Common_006 = "删除失败!<br>";
            public const string M_ImportCommon_001 = "文件上传成功!<br>";
            public const string M_ImportCommon_002 = "文件上传失败!<br>";
            public const string M_ImportCommon_003 = "请确认上传的是Excel文件!<br>";
            public const string M_ImportCommon_004 = "请选择要上传的文件!<br>";
            public const string M_ImportCommon_005 = "请选择始发区域!<br>";

            //Service画面 
            public const string M_Service_001 = "服务类别名称不能超过10个字符!<br>";
            public const string M_Service_002 = "服务类别编号不能超过10个字符!<br>";
            public const string M_Service_003 = "请输入必输项!<br>";
            public const string M_Service_004 = "输入的服务类别编号已经存在!<br>";
            public const string M_Service_005 = "输入的服务类别编号已被标记删除!请在数据库层修改!<br>";
            public const string M_Service_006 = "输入的服务类别名称已经存在!<br>";
            public const string M_Service_007 = "服务类别编号必须输入英文或数字!<br>";
            public const string M_Service_008 = "请输入服务类别名称!<br>";
            public const string M_Service_009 = "请输入服务类别编号!<br>";
            public const string M_Service_010 = "该服务类别正在被使用,不能被删除!<br>";
            public const string M_Service_011 = "输入的服务类别名称已被标记删除!请在数据库层修改!<br>";

 
        }

        public class SessionKeys
        {
            //通用保存状态
            public const string SaveState = "SaveState";

            //Service画面
            public const string Service_ParameterName = "Service_ParameterName";

            //FromToZone画面
            public const string FromToZone_ParameterName = "FromToZone_ParameterName";

            //ExportQuotation画面
            public const string ExportQuotation_ParameterName = "ExportQuotation_ParameterName";

            //ImportQuotation画面
            public const string ImportQuotation_ParameterName = "ImportQuotation_ParameterName";

            //ExportReport画面
            public const string ExportReport_ParameterName = "ExportReport_ParameterName";

            //DiscTemplateQuery画面
            public const string DiscTemplateQuery_ParameterName = "DiscTemplateQuery_ParameterName";

            //DiscTemplateMaintenance画面
            public const string DiscTemplateMaintenance_ParameterName = "DiscTemplateMaintenance_ParameterName";

            //导入前判断用户是否有权限
            public const string purview = "销售内勤";

         }
         /// <summary>
         /// 判断用户是否有权限访问该页面
         /// </summary>
         /// <param name="PageID">页面编号</param>
         /// <returns></returns>
         public static bool LimitUser(string userName)
         {
             bool bolRight = false;
             ParameterFromZone param = new ParameterFromZone();
             FacadeFromZone facade = new FacadeFromZone();
             param.UserName = userName;
             facade.QueryForRoleName(param);
             if (param.droptable.Rows.Count > 0)
             {
                 string itemCount = param.droptable.Rows[0][0].ToString();
                 if (itemCount.Equals("0"))
                 {
                     bolRight = false;
                 }
                 else
                 {
                     bolRight = true;
                 }
             }                      
             return bolRight;
         }

         public class SortAsc
         {
             #region private construtor

             private SortAsc()
             {
             }

             #endregion

             public const string Ascend = "ASC";
             public const string Descend = "DESC";
         }
}

9。。。显示一个模态窗体
  function showWin1()
        {
            window.showModalDialog("RateCategorySet.aspx", window,

"dialogWidth=460px;dialogHeight=350px;dialogLeft=100px;dialogTop=100px");
            //location.reload("RateDetail.aspx");
            document.form1.action="RateDetail.aspx"; 
            document.form1.submit();  
         }

10:构造一个临时表:
    /// <summary>
    /// 获得数据
    /// </summary>
    /// <returns></returns>
    public DataTable getData()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add(new DataColumn("id", typeof(Int32)));
        dt.Columns.Add(new DataColumn("name", typeof(String)));

        for (int i = 1; i < 6; i++)
        {
            DataRow dr = dt.NewRow();
            dr[0] = i;
            dr[1] = "name" + i;
            dt.Rows.Add(dr);
        }
        return dt;
    }

11。。导出为excel引用的Interop.excel.dll

代码

using System.Net;
using System.IO;

/// <summary>
/// 测试导出数据
/// </summary>
public partial class Default2 : System.Web.UI.Page
{
    
protected void Page_Load(object sender, EventArgs e)
    {
        bindData();
    }

    /// <summary>
    
/// 绑定gridview
    
/// </summary>
    public void bindData()
    {
        
this.GridView1.DataSource = this.getData();
        
this.GridView1.DataBind();
    }

    /// <summary>
    
/// 获得数据
    
/// </summary>
    
/// <returns></returns>
    public DataTable getData()
    {
        DataTable dt 
= new DataTable();
        dt.Columns.Add(
new DataColumn("id"typeof(Int32)));
        dt.Columns.Add(
new DataColumn("name"typeof(String)));

        for (int i = 1; i < 6; i++)
        {
            DataRow dr 
= dt.NewRow();
            dr[
0= i;
            dr[
1= "name" + i;
            dt.Rows.Add(dr);
        }
        
return dt;
    }

    /// <summary>
    
/// 导出
    
/// </summary>
    
/// <param name="sender"></param>
    
/// <param name="e"></param>
    protected void Button1_Click(object sender, EventArgs e)
    {
        ExportExcel(
this.getData());
    }

    /// <summary>
    
/// 导出Excel的方法
    
/// </summary>
    
/// <param name="path"></param>
    private void ExportExcel(DataTable dt)
    {
        
object missing = System.Reflection.Missing.Value;
        
//打开Excel模板文件  
        string modileFileName = @"D:\\test.xls";//模板文件名称
        FileInfo fileExcel = new FileInfo(modileFileName);
 
        
//copy模板文件到新的文件中,并设置其属性可以更改   
        string newPath = fileExcel.CopyTo("d:\\temp.xls"true).FullName;
        FileInfo newFile 
= new FileInfo(newPath);
        newFile.IsReadOnly 
= false;

        //打开新文件  
        Excel.Application ExcelApp = new Excel.Application();
        Excel.Workbook ExcelWorkBook 
= ExcelApp.Application.Workbooks.Open(newPath, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
        
//将打开的Excel隐藏  
        ExcelApp.Visible = false;

        //重命名一个sheet 
        Excel.Worksheet ExcelWorkSheet1 = (Excel.Worksheet)ExcelWorkBook.Worksheets[1];
        ExcelWorkSheet1.Name 
= "用户数据";
        
//继续添加类似
        
//Excel.Worksheet ExcelWorkSheet2 = (Excel.Worksheet)ExcelWorkBook.Worksheets[2];
        
// ExcelWorkSheet2.Name = "标准报价数据";

        
#region 对第一个Sheet的操作
        
int rowcount1 ;
        rowcount1 
= (int)dt.Rows.Count;
        
//填充第一个Sheet的说明和表头
        ExcelWorkSheet1.Cells[11= "报表测试";
        ExcelWorkSheet1.Cells[
21= "ID";
        ExcelWorkSheet1.Cells[
22= "NAME";

        //填充第一个Sheet的数据
        int i;
        
for (i = 0; i < rowcount1; i++)
        {
            ExcelWorkSheet1.Cells[i 
+ 31= dt.Rows[i][0].ToString().Trim();
            ExcelWorkSheet1.Cells[i 
+ 32= dt.Rows[i][1].ToString().Trim();
        }
        
#endregion

        #region 对第二个Sheet的操作
        
#endregion
        
try
        {
            
//给Excel文件命名
            string newFilename = "标准报价_" + DateTime.Now.ToString("yyyyMMdd"+ "_" + DateTime.Now.ToString("hhmmss"+ ".xls";
            
//另存为Excel文件
            ExcelWorkBook.SaveAs("D:\\33" + newFilename, missing, missing, missing, missing, missing, Excel.XlSaveAsAccessMode.xlExclusive, missing, missing, missing, missing, missing);
            ExcelWorkBook.Close(
falsenullnull);
            
//删除Copy后的文件
            newFile.Delete();   
            ExcelWorkSheet1 
= null;
            ExcelApp.Quit();
            System.GC.Collect();
        }
        
catch (Exception ex)
        {
            
if (ex.Message != "")
            {
                
//记录错误日志
                this.Response.Write("error:" + ex.Message);
            }
        }
    }

}
 

 

 

 

抱歉!评论已关闭.