lyfz_repos/铂金版源码/LYFZ.WeixinServers/DZKJ/DZKJ_CustomerAccount.aspx.cs

using LYFZ.WeixinServers.WeiXinAPP;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace LYFZ.WeixinServers.DZKJ
{
    public partial class DZKJ_CustomerAccount : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            CommonHandler.CheckLoginJump(this);
            if (!IsPostBack)
            {
                if (Request.QueryString["page"] != null)
                {
                    try
                    {
                        pageIndex = Convert.ToInt32(Request.QueryString["page"].ToString());
                        if (pageIndex <= 0)
                        {
                            pageIndex = 1;
                        }
                    }
                    catch { }
                }
                if (Request.QueryString["Keyword"] != null)
                {
                    Keyword = Request.QueryString["Keyword"].ToString().Trim();
                }
                if (Request.QueryString["IsEnabled"] != null)
                {
                    IsEnabled = Request.QueryString["IsEnabled"].ToString().Trim();
                }
                if (!String.IsNullOrEmpty(Request.QueryString["DistId"]))
                {
                    DistId = Request.QueryString["DistId"].ToString().Trim();
                }
                if (Request.QueryString["PeriodOfValidity"] != null)
                {
                    PeriodOfValidity = Request.QueryString["PeriodOfValidity"].ToString().Trim();
                }
                if (Request.QueryString["del"] != null && Request.QueryString["del"].ToString().Length > 0)
                {
                    try
                    {
                        if (CommonHandler.CheckAdmin(this))
                        {
                            long delID = Convert.ToInt64(Request.QueryString["del"].ToString());
                            deleteDZKJ_Customer(delID);

                        }

                    }
                    catch (Exception ex)
                    {
                        showMsegesBox("删除失败，请重试.错误原因:" + ex.Message);
                    }
                }
            }
            bindUserList();
        }

        void deleteDZKJ_Customer(long id)
        {
            LYFZ.WeixinServiceDate.DAL.DAL_DZKJ_TaskExecutionStatistics DDTes = new WeixinServiceDate.DAL.DAL_DZKJ_TaskExecutionStatistics();

            LYFZ.WeixinServiceDate.DAL.DAL_DZKJ_CustomerAccount DDCustAcount = new WeixinServiceDate.DAL.DAL_DZKJ_CustomerAccount();

            string account = DDCustAcount.GetModel(id).Account;

            LYFZ.WeixinServiceDate.DAL.DAL_DZKJ_TaskExecutionStatistics DDTeakExecStatistics = new WeixinServiceDate.DAL.DAL_DZKJ_TaskExecutionStatistics();

            if (DDTeakExecStatistics.Exists("Account", account) && !CommonHandler.isAdmin(this,false))
            {
                showMsegesBox("删除失败,客户已经开始使用中");
            }
            else {
                if (DZKJ_Dal.Delete(id))
                {
                    this.Response.Redirect("DZKJ_CustomerAccount.aspx");
                }
                else
                {
                    showMsegesBox("删除失败，请重试.");
                }
            }
        }

        void showMsegesBox(string msg)
        {
            Response.Write("<script>alert('" + msg + "');document.location='DZKJ_CustomerAccount.aspx';</script>"); return;
        }

        LYFZ.WeixinServiceDate.DAL.DAL_DZKJ_CustomerAccount DZKJ_Dal = new WeixinServiceDate.DAL.DAL_DZKJ_CustomerAccount();
        public System.Text.StringBuilder CustomerAccountListHtmlTb = new System.Text.StringBuilder();
        string Keyword = String.Empty;
        string IsEnabled = String.Empty;
        string PeriodOfValidity = String.Empty;
        string DistId = String.Empty;
        int pageIndex = 1;
        int pageSize = Global.PageSize;
        public string PagingInfoHtml = String.Empty;
        void bindUserList()
        {
            string whereStr = String.Empty;
            if (!String.IsNullOrEmpty(Keyword))
            {
                whereStr = " ([Account] like '%" + Keyword + "%' or [CompanyName] like '%" + Keyword + "%' or [Contacts] like '%" + Keyword + "%' or [Telephone] like '%" + Keyword + "%' ) and ";
            }
            else if (!String.IsNullOrEmpty(IsEnabled))
            {
                whereStr = "IsEnabled=" + IsEnabled + " and ";
            }
            else if (!String.IsNullOrEmpty(PeriodOfValidity))
            {
                if (PeriodOfValidity.Trim() == "0")
                {
                    whereStr = "PeriodOfValidity<'" + DateTime.Now.ToString("yyyy-MM-dd") + "' and ";
                }
                else if (PeriodOfValidity.Trim() == "1")
                {
                    whereStr = "PeriodOfValidity>='" + DateTime.Now.ToString("yyyy-MM-dd") + "' and ";
                }
            }

            if (!String.IsNullOrEmpty(DistId)){
                whereStr += "DistributorID=" + DistId;
            }else{
                whereStr += CommonHandler.isAdmin(this, false) ? "1=1" : "DistributorID=" + CommonHandler.GetAdminUser(this).ID;
            }

            int pageCount = 0;
            int sumCount = DZKJ_Dal.GetRecordCount(whereStr);

            DataSet ds = DZKJ_Dal.GetListByPage(whereStr, "RegistrationTime desc", pageIndex, pageSize, ref pageCount);

            pageIndex = pageIndex > pageCount ? pageCount : pageIndex;

            string countInfo = "当前" + pageIndex.ToString() + "/" + pageCount.ToString() + "页|" + pageSize.ToString() + "条/页|共" + sumCount.ToString() + "条记录";

            PagingInfoHtml = LYFZ.WXLibrary.PageTabList.GetPagingInfo_Web(pageCount, pageIndex, countInfo);

            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                DataRow row = ds.Tables[0].Rows[i];
                CustomerAccountListHtmlTb.Append("<tr>"
                    + "<td>" + GetIsEnabled(Convert.ToInt32(row["IsEnabled"].ToString())) + "</td>"
                    + "<td>" + row["CompanyName"].ToString() + "</td>"
                    + "<td><a  href=\"/DZKJ/DZKJTaskOneView.aspx?viewtype=1&ExecDate=" + DateTime.Now.ToString("yyyy-MM-dd") + "&Account=" + row["Account"].ToString() + "\">" + row["Account"].ToString() + "</a></td>"
                    + "<td>" + row["Contacts"].ToString() + "</td>"
                    + "<td>" + GetSex(Convert.ToInt32(row["Sex"].ToString())) + "</td>"
                    + "<td>" + row["Telephone"].ToString() + "</td>"
                    + "<td>" + Convert.ToDateTime(row["PeriodOfValidity"]).ToString("yyyy-MM-dd") + "</td>"
                    + "<td>" + row["StartSimulatorCount"].ToString() + "</td>"
                    + "<td>" + Convert.ToDateTime(row["RegistrationTime"]).ToString("yyyy-MM-dd HH:mm:ss") + "</td>"
                    + "<td>" + GetLatestLoginTime(row["LatestLoginTime"]) + "</td>"
                    + "<td>"
                    + "<a href=\"DZKJ_AddCustomer.aspx?eid=" + row["id"].ToString() + "\"  style=\"margin-right:10px;\"><i class=\"fa fa-pencil\"></i></a>"
                    + "<a href=\"#myModal\" role=\"button\"   onclick=\"setModalValue('" + row["id"].ToString() + "')\"  data-toggle=\"modal\"><i class=\"fa fa-remove\"></i></a>"
                    + "</td>"
                    + " </tr>");
            }
        }
        string GetLatestLoginTime(object LatestLoginTime)
        {
            try
            {
                DateTime tempt;

                if (LatestLoginTime != null)
                {
                    if (DateTime.TryParse(LatestLoginTime.ToString(), out tempt))
                    {
                        return tempt.ToString("yyyy-MM-dd HH:mm:ss");
                    }
                    else
                    {
                        return "";
                    }
                }
            }
            catch { }
            return "";
        }
        string GetIsEnabled(int IsEnabled)
        {
            if (IsEnabled == 1)
            {
                return "正常";
            }
            else
            {
                return "已禁用";
            }
        }
        string GetSex(int sex)
        {
            if (sex == 1)
            {
                return "男";
            }
            else
            {
                return "女";
            }
        }

        /*
         *   <th>状态</th>
         <th>企业名</th>
         <th>帐号</th>
         <th>联系人</th>
         <th>性别</th>
         <th>联系电话</th>
          <th>有效期</th>
           <th>模拟器个数</th>
            <th>注册时间</th>
            <th>最新登录IP</th>
            <th>最新登录时间</th>
         * [ID]
     ,[Account]
     ,[Password]
     ,[Contacts]
     ,[Telephone]
     ,[Sex]
     ,[CompanyName]
     ,[CompanyAddress]
     ,[PeriodOfValidity]
     ,[StartSimulatorCount]
     ,[HardwareCode]
     ,[IP]
     ,[RegistrationTime]
     ,[LatestLoginTime]
     ,[IsEnabled] */

    }
}