客户信息导出

yzh

2022-06-08 9c98f5d15e35587b7bcd9d7c8a506c467e758632

 web/web/GwClient.aspx.cs

@@ -8,12 +8,15 @@
using Dao;
using System.Collections.Generic;
using System.Text;
using System.Configuration;

public partial class _GwClient : PageBase<SysUser>, IRequiresSessionState
{

    protected List<SysUser> SysUserList;
    protected List<GwProduct> GwProductList;
    protected List<GwProduct> GwProductList;    

    string addressClasses = ConfigurationManager.AppSettings["addressClasses"];

    protected void Page_Load(object sender, EventArgs e)
    {
@@ -41,6 +44,13 @@
            this.GwProductList = gwProductDao.getAllList(bean);
        }
    }
    public int IsEnable
    {
        get
        {
            return this.AppContext.GetInt("IsEnable");
        }
    }


    //归属业务员
@@ -64,9 +74,9 @@
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }
@@ -92,9 +102,9 @@
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }
@@ -120,9 +130,9 @@
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }
@@ -148,9 +158,9 @@
            }

            if (userId == bean.UserID)
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.UserID, (object)bean.UserName);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.UserID, (object)bean.UserName);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.UserID, (object)bean.UserName);
        }
        return stringBuilder.ToString();
    }
@@ -177,9 +187,9 @@
            }

            if (productId.Equals(bean.Id))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.Id, (object)bean.Name);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.Id, (object)bean.Name);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.Id, (object)bean.Name);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.Id, (object)bean.Name);
        }
        return stringBuilder.ToString();
    }
@@ -211,12 +221,54 @@
            }

            if (productId.Equals(bean.Id))
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{0}-{1}</option>", (object)bean.Id, (object)bean.Name);
                stringBuilder.AppendFormat("<option value=\"{0}\" selected>{1}</option>", (object)bean.Id, (object)bean.Name);
            else
                stringBuilder.AppendFormat("<option value=\"{0}\">{0}-{1}</option>", (object)bean.Id, (object)bean.Name);
                stringBuilder.AppendFormat("<option value=\"{0}\">{1}</option>", (object)bean.Id, (object)bean.Name);
        }
        return stringBuilder.ToString();
    }

    //所有个性产品
    protected string ClientProductAll()
    {
        using (GwProductDao gwProductDao = new GwProductDao())
        {
            GwProduct gwProduct = new GwProduct();
            gwProduct.Classes = 1;  //0-产品分类；1-产品
            gwProduct.IsDefault = 0;    //默认值0。0-个性化；1-系统默认。
            gwProduct.IsEnable = 1;    //0-停用；1-启用；默认1
            List<GwProduct> list = gwProductDao.getAllList(gwProduct);

            StringBuilder stringBuilder = new StringBuilder();
            stringBuilder.Append("<table cellpadding='5'>");
            if(list.Count>0)
            {
                for (int i = 0; i < list.Count; i++)
                {
                    GwProduct bean = (GwProduct)list[i];

                    //行开始符
                    if (i%5 == 0)
                    {
                        stringBuilder.Append("<tr>");
                    }

                    //行单元格
                    stringBuilder.AppendFormat("<td><input  type=\"checkbox\" id=\"_ProductId\"  name=\"_ProductId\" value=\"{0}\" /><span  style='padding:5px;'>{1} </span>  \r\n         </td>", (object)bean.Id, (object)bean.Name);

                    //行结束符
                    if (i % 5 == 4 || i == (list.Count - 1))
                    {
                        stringBuilder.Append("</tr>");
                    }

                }
            }
            stringBuilder.Append("</table>");

            return stringBuilder.ToString();
        }
    }


}