using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using BLL.CardBill;
using BLL.Sys;
using CPCBILLSYS.Common;
using Ext.Net;
using Model;
using Newtonsoft.Json.Linq;

namespace CPCBILLSYS
{
    public partial class CPCBalanceMg : System.Web.UI.Page
    {
        LogClass log = new LogClass();
        /// <summary>
        /// 基础
        /// </summary>
        DictionaryBLL dicbll = new DictionaryBLL(CommonHelper._dbType, CommonHelper.DbConStr);
        /// <summary>
        /// cpc
        /// </summary>
        CPCCardBLL cpcbll = new CPCCardBLL(CommonHelper._dbType, CommonHelper.DbConStr);
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                if (CommonHelper._userType == "3")
                {
                    if (string.IsNullOrEmpty(Request.QueryString["userId"]) || string.IsNullOrEmpty(Request.QueryString["userName"]))
                    {
                        Response.Write("<script>alert('错误的访问！');window.location.href='http://10.15.0.36:9996'</script>");
                        return;
                    }
                    try
                    {
                        hdUserId.Value = Request.QueryString["userId"].ToString();
                        hdMan.Value = HttpUtility.UrlDecode(Request.QueryString["userName"].ToString());
                    }
                    catch
                    {
                        Response.Write("<script>alert('数据库访问异常！');window.location.href='http://10.15.0.36:9996'</script>");
                        return;
                    }

                    //hdUserId.Value = "1";
                    //hdMan.Value = "武俊涛";
                }
                else
                {
                    if (Session["UserID"] == null || Session["SysID"] == null || Session["MAN"] == null)
                    {
                        Response.Write("<script>alert('错误的访问！');window.location.href='../Default.aspx'</script>");
                        return;
                    }
                    hdUserId.Value = Session["UserID"].ToString();
                    hdMan.Value = Session["MAN"].ToString();
                }
                s_txtStartDt.Value = DateTime.Now.AddDays(-1);
                s_txtStartDt.MaxDate = DateTime.Now.AddDays(-1);

                s_txtStDt.Value = DateTime.Now.AddDays(-1);
                s_txtStDt.MaxDate = DateTime.Now.AddDays(-1);

                s_txtEndDt.Value = DateTime.Now.AddDays(1);
                s_txtEndDt.MaxDate = DateTime.Now.AddDays(1);
                StCardInfo.AutoLoadParams.Add(new Ext.Net.Parameter("Start", "0"));
                StCardInfo.AutoLoadParams.Add(new Ext.Net.Parameter("Limit", Paging.PageSize.ToString()));
                BindSub();
                BindClassNo();
                if (CommonHelper._userType != "1")
                {
                    s_txtStartDt.Hide();
                    btnBalance.Hide();
                    Button1.Hide();
                    btnFzBalance.Hide();
                }
            }
        }
        /// <summary>
        /// 绑定站
        /// </summary>
        public void BindSub()
        {
            if (CommonHelper._userType == "1")
            {
                //s_cmbSubcom.Disabled = true;
                //s_cmbSta.Disabled = true;
                s_cmbSubcom.Hidden = true;
                s_cmbSta.Hidden = true;
            }
            else
            {
                storeSubCompany.DataSource = dicbll.GetSubCompany("");
            }
            storeSubCompany.DataBind();
        }
        public void BindClassNo()
        {
            stClassNo.DataSource = dicbll.GetClass("");
            stClassNo.DataBind();
        }

        protected void s_cmbSubcom_Select(object sender, Ext.Net.DirectEventArgs e)
        {
            stSta.DataSource = dicbll.GetStaAllInfo(" and SUBCOMNO='" + s_cmbSubcom.SelectedItem.Value + "'");
            stSta.DataBind();
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnSearch_Click(object sender, Ext.Net.DirectEventArgs e)
        {
            string sqlwhere = string.Empty;
            try
            {
                if (s_txtStartDt.Value != null || !string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
                {
                    if (CommonHelper._dbType == "1")
                    {
                        sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
                    }
                    else if (CommonHelper._dbType == "4")
                    {
                        sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
                    }
                    else
                    {
                        sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd')";
                    }
                }
                if (CommonHelper._userType == "1")
                {
                    sqlwhere += " and stano='" + CommonHelper._userStaNo + "'";
                    DataTable dt = cpcbll.GetCPCBalanceSum(sqlwhere);
                    string lyct = dt.Rows[0]["LYCT"].ToString();
                    string sjct = dt.Rows[0]["SJCT"].ToString();
                    string badct = dt.Rows[0]["DJBADCT"].ToString();
                    string lostct = dt.Rows[0]["DJLOSTCT"].ToString();
                    string morect = dt.Rows[0]["DJMORECT"].ToString();
                    lbShow.Text = "【CPC领用总量】：" + lyct + "【CPC上缴总量】：" + sjct + "【盈亏数量】：" + ((int.Parse(sjct) + int.Parse(morect)) - (int.Parse(lyct) + int.Parse(badct) + int.Parse(lostct))) + "";
                }
            }
            catch
            {
                lbShow.Text = "【CPC领用总量】：0【CPC上缴总量】：0【盈亏数量】：0";
            }
            wdSearch.Hide();
            Paging.SetPageIndex(1);
            StCardInfo.DataBind();
        }
        /// <summary>
        /// 
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void StCardInfo_RefreshData(object sender, Ext.Net.StoreRefreshDataEventArgs e)
        {
            int start; int limit;
            if (!string.IsNullOrEmpty(e.Parameters["Start"]) && !string.IsNullOrEmpty(e.Parameters["Limit"]))
            {
                start = int.Parse(e.Parameters["Start"]);
                limit = int.Parse(e.Parameters["Limit"]);
            }
            else
            {
                start = e.Start;
                limit = e.Limit;
            }
            if (s_txtStDt.Value == null || string.IsNullOrEmpty(s_txtEndDt.Value.ToString()))
            {
                CommonHelper.MsgShowInfo("请选择查询日期！");
                return;
            }
            else
            {
                if (Convert.ToDateTime(s_txtStDt.Value.ToString()) > Convert.ToDateTime(s_txtEndDt.Value.ToString()))
                {
                    CommonHelper.MsgShowInfo("起始日期不大于结束日期！");
                    return;
                }
            }
            string sqlwhere = string.Empty;
            if (CommonHelper._dbType == "1")
            {
                sqlwhere += "and classdate>='" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "' and classdate<='" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "'";
            }
            else if (CommonHelper._dbType == "4")
            {
                sqlwhere += " and classdate>=DATE_FORMAT('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d') and classdate<=DATE_FORMAT('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
            }
            else
            {
                sqlwhere += "and classdate>=to_date('" + Convert.ToDateTime(s_txtStDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd') and classdate<=to_date('" + Convert.ToDateTime(s_txtEndDt.Value).ToString("yyyy-MM-dd") + "','yyyy-MM-dd')";
            }
            if (s_cmbClassNo.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbClassNo.SelectedItem.Value))
            {
                sqlwhere += " and CLASSNO='" + s_cmbClassNo.SelectedItem.Value + "'";
            }
            if (s_cmbSubcom.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbSubcom.SelectedItem.Value))
            {
                sqlwhere += " and SUBCOMNO='" + s_cmbSubcom.SelectedItem.Value + "'";
            }
            if (s_cmbSta.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbSta.SelectedItem.Value))
            {
                sqlwhere += " and STANO='" + s_cmbSta.SelectedItem.Value + "'";
            }
            int ct = 0;
            DataTable dt = cpcbll.GetBalanceLst(sqlwhere, start + 1, start + limit, out ct);
            if (dt.Rows.Count > 0)
            {
                e.Total = ct;
                List<CPCBalanceModel> lst = cpcbll.GetBlanceLstByFlag(dt);
                StCardInfo.DataSource = lst;
            }
            else
            {
                if (CommonHelper._userType == "1")
                {
                    CommonHelper.MsgShowInfo("请先生成平衡数据！");
                }
            }
            StCardInfo.DataBind();
        }
        /// <summary>
        /// 生成平衡单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnBalance_Click(object sender, Ext.Net.DirectEventArgs e)
        {
            string sqlwhere = string.Empty;
            if (hdUserId.Value == null || hdMan.Value == null)
            {
                CommonHelper.MsgShowInfo("页面过期，请重新登录！");
                return;
            }

            if (string.IsNullOrEmpty(hdUserId.Value.ToString()) || hdUserId.Value.ToString().ToLower() == "admin")
            {
                CommonHelper.MsgShowInfo("该用户无生成平衡单权限，请用该站监控或者票管账户登录");
                return;
            }
            if (!string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
            {
                if (CommonHelper._dbType == "1")
                {
                    sqlwhere += " and classdate='" + s_txtStartDt.Value + "'";
                }
                else if (CommonHelper._dbType == "4")
                {
                    //DATE_FORMAT
                    sqlwhere += " and classdate=date_format('" + Convert.ToDateTime(s_txtStartDt.Value).ToString("yyyy-MM-dd") + "','%Y-%m-%d')";
                }
                else
                {
                    sqlwhere += " and classdate=to_date('" + s_txtStartDt.Value + "','yyyy-MM-dd HH24:mi:ss')";
                }
            }
            else
            {
                CommonHelper.MsgShowInfo("请选择统计日");
                return;
            }
            if (s_cmbClassNo.SelectedItem.Value != null && string.IsNullOrEmpty(s_cmbClassNo.SelectedItem.Value))
            {
                sqlwhere += " and CLASSNO='" + s_cmbClassNo.SelectedItem.Value + "'";
            }
            if (CommonHelper._userType == "1")
            {
                sqlwhere += " and stano=" + CommonHelper._userStaNo + "";
            }
            else
            {
                if (s_cmbSta.SelectedItem.Value != null && !string.IsNullOrEmpty(s_cmbSta.SelectedItem.Value.ToString()))
                {
                    sqlwhere += " and stano='" + s_cmbSta.SelectedItem.Value + "'";
                }
            }
            try
            {
                bool f = cpcbll.CreatePreBlance(sqlwhere, hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType);
                if (f)
                {
                    CommonHelper.MsgShowInfo("生成预交易平衡信息生成成功");
                    log.Info("btnBalance_Click", "生成预交易平衡信息生成成功");
                }
                else
                {
                    CommonHelper.MsgShowInfo("生成预交易平衡信息生成失败，请重新点击生成");
                    log.Info("btnBalance_Click", "生成预交易平衡信息生成失败，请重新点击生成");
                }
            }
            catch (Exception ex)
            {
                CommonHelper.MsgShowInfo("生成预交易平衡信息异常:<font color='red'>" + ex.Message + "</font>");
                log.Info("btnBalance_Click", ex.Message);
            }
            StCardInfo.DataBind();
        }
        /// <summary>
        /// 生成平衡单-封站
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void btnFzBalance_Click(object sender, Ext.Net.DirectEventArgs e)
        {
            string sqlwhere = string.Empty;
            if (hdUserId.Value == null || hdMan.Value == null)
            {
                CommonHelper.MsgShowInfo("页面过期，请重新登录！");
                return;
            }

            if (string.IsNullOrEmpty(hdUserId.Value.ToString()) || hdUserId.Value.ToString().ToLower() == "admin")
            {
                CommonHelper.MsgShowInfo("该用户无生成平衡单权限，请用该站监控或者票管账户登录");
                return;
            }
            if (!string.IsNullOrEmpty(s_txtStartDt.Value.ToString()))
            {
                sqlwhere += " and classdate='" + s_txtStartDt.Value + "'";
            }
            else
            {
                CommonHelper.MsgShowInfo("请选择统计日");
                return;
            }
            try
            {
                bool f = cpcbll.CreatePreBlanceByFz(CommonHelper._userStaNo, s_txtStartDt.Value.ToString(), hdUserId.Value.ToString(), hdMan.Value.ToString(), CommonHelper._userType);
                if (f)
                {
                    CommonHelper.MsgShowInfo("生成预交易平衡信息生成成功");
                    log.Info("btnBalance_Click", "生成预交易平衡信息生成成功");
                }
                else
                {
                    CommonHelper.MsgShowInfo("生成预交易平衡信息生成失败，请重新点击生成");
                    log.Info("btnBalance_Click", "生成预交易平衡信息生成失败，请重新点击生成");
                }
            }
            catch (Exception ex)
            {
                CommonHelper.MsgShowInfo("生成预交易平衡信息生成异常,联系软件维护人员");
                log.Info("btnBalance_Click", ex.Message);
            }
            StCardInfo.DataBind();
        }
        /// <summary>
        /// 手工登记
        /// 本人只能更改本人的
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        [DirectMethod]
        public void DJEidtFor(string str)
        {
            if (hdUserId.Value == null || hdMan.Value == null)
            {
                CommonHelper.MsgShowInfo("页面过期，请重新登录！");
                return;
            }
            if (string.IsNullOrEmpty(str))
            {
                CommonHelper.MsgShowInfo("请选择操作的行");
                return;
            }
            if (hdMKDt.Value == null || hdMKDt.Value.ToString() == "" || hdoldDt.Value == null || hdoldManNo.Value == null)
            {
                CommonHelper.MsgShowInfo("数据已过期，请重新选择修改数据...");
                return;
            }
            try
            {
                JObject obj = JObject.Parse(str.Trim());
                string subcomno = obj["SUBCOMNO"].ToString();
                string roadno = obj["ROADNO"].ToString();
                string stano = obj["STANO"].ToString();
                string classdate = Convert.ToDateTime(obj["CLASSDATE"].ToString()).ToString("yyyy-MM-dd");
                string porttype = obj["PORTTYPE"].ToString();
                string classno = obj["CLASSNO"].ToString();
                string manno = obj["MANNO"].ToString();
                if (obj["ADMANNO"] != null && !string.IsNullOrEmpty(obj["ADMANNO"].ToString()) && obj["USERTYPE"] != null)
                {
                    if (!obj["ADMANNO"].ToString().Equals(hdUserId.Value.ToString()) || !obj["USERTYPE"].ToString().Equals(CommonHelper._userType))
                    {
                        CommonHelper.MsgShowInfo("非本人/非本单位录入数据，不允许更改...");
                        return;
                    }
                }
                else
                {
                    CommonHelper.MsgShowInfo("票据平衡数据数据不完整，联系维护人员...");
                    return;
                }
                DataTable dt;
                //启用修改指令
                //if (CommonHelper._updateflag == CommonHelper._UpdateOrder_Flag.ToString())
                //{
                //    string djDt = hdMKDt.Value.ToString();
                //    TimeSpan ts = DateTime.Now - Convert.ToDateTime(djDt);
                //    if ((ts.TotalMinutes > 60 && ts.Days == 0) || ts.Days >= 1)
                //    {
                //        if (!CommonHelper.CheckUpdate(out dt, Convert.ToDateTime(hdMKDt.Value).Date))
                //        {
                //            CommonHelper.MsgShowInfo("未收到-修改指令，不允许更改数据，请提交修改申请...");
                //            return;
                //        }
                //    }
                //}
                //else
                //{
                //    string djDt = hdMKDt.Value.ToString();
                //    TimeSpan ts = DateTime.Now - Convert.ToDateTime(djDt);
                //    if ((ts.Hours > 1 && ts.Days == 0) || ts.Days >= 1)
                //    {
                //        CommonHelper.MsgShowInfo("数据已超过1小时，不允许修改...");
                //        return;
                //    }
                //}
                CB_CARDBALANCE_TABLE mdl = new CB_CARDBALANCE_TABLE();
                mdl.STANO = int.Parse(stano);
                mdl.PORTTYPE = int.Parse(porttype);
                mdl.MANNO = int.Parse(manno);
                mdl.CLASSNO = int.Parse(classno);
                mdl.CLASSDATE = Convert.ToDateTime(classdate);
                //mdl.MKDT = Convert.ToDateTime(hdMKDt.Value.ToString());
                mdl.DJCPCCT = string.IsNullOrEmpty(txtDjCPCCt.Text.Trim()) ? 0 : int.Parse(txtDjCPCCt.Text.Trim());
                mdl.DJETCCT = string.IsNullOrEmpty(txtDjETCCt.Text.Trim()) ? 0 : int.Parse(txtDjETCCt.Text.Trim());
                mdl.DJALLCT = string.IsNullOrEmpty(txtDjAllCt.Text.Trim()) ? 0 : int.Parse(txtDjAllCt.Text.Trim());
                mdl.DJBADCT = string.IsNullOrEmpty(txtDjBadCt.Text.Trim()) ? 0 : int.Parse(txtDjBadCt.Text.Trim());
                mdl.DJLOSTCT = string.IsNullOrEmpty(txtDjLostCt.Text.Trim()) ? 0 : int.Parse(txtDjLostCt.Text.Trim());
                mdl.DJLYCT = string.IsNullOrEmpty(txtDjLyCt.Text.Trim()) ? 0 : int.Parse(txtDjLyCt.Text.Trim());
                mdl.DJMORECT = string.IsNullOrEmpty(txtDjMoreCt.Text.Trim()) ? 0 : int.Parse(txtDjMoreCt.Text.Trim());
                mdl.DJOTHERCT = string.IsNullOrEmpty(txtDjOhterCt.Text.Trim()) ? 0 : int.Parse(txtDjOhterCt.Text.Trim());
                mdl.DJPARPERCT = string.IsNullOrEmpty(txtDjParperCt.Text.Trim()) ? 0 : int.Parse(txtDjParperCt.Text.Trim());
                mdl.DJSJCT = string.IsNullOrEmpty(txtDjSjCt.Text.Trim()) ? 0 : int.Parse(txtDjSjCt.Text.Trim());
                mdl.DATEMARK = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                mdl.ADMANNO = int.Parse(hdUserId.Value.ToString());
                mdl.ADMAN = hdMan.Value.ToString();
                mdl.DJLESSCT = string.IsNullOrEmpty(txtDjLessCt.Text.Trim()) ? 0 : int.Parse(txtDjLessCt.Text.Trim());
                mdl.DJBRKCARCT = string.IsNullOrEmpty(txtDjBrkCt.Text.Trim()) ? 0 : int.Parse(txtDjBrkCt.Text.Trim());
                //mdl.USERTYPE = int.Parse(CommonHelper._userType);
                if (cpcbll.UpdateDjBalance(mdl, CreateLog(subcomno, classdate, stano, porttype, manno, classno)))
                {
                    CommonHelper.MsgShowInfo("CPC平衡人工登记成功");
                }
                else
                {
                    CommonHelper.MsgShowInfo("CPC平衡人工登记失败，请重新操作！");
                }
            }
            catch (Exception ex)
            {
                CommonHelper.MsgShowInfo("CPC平衡人工登记异常:" + ex.Message);
            }
            StCardInfo.DataBind();
        }


        /// <summary>
        /// 构建日志（参数：主键值）
        /// </summary>
        /// <param name="verid"></param>
        /// <param name="classdate"></param>
        /// <param name="stano"></param>
        /// <param name="porttype"></param>
        /// <param name="manno"></param>
        /// <param name="classno"></param>
        /// <returns></returns>
        public CB_OP_LOG CreateLog(string subcomno, string classdate, string stano, string porttype, string manno, string classno)
        {
            //CLASSDATE=@CLASSDATE and VERID=@VERID and STANO=@STANO and PORTTYPE=@PORTTYPE and MANNO=@MANNO and CLASSNO=@CLASSNO
            bool f = false;
            CB_OP_LOG mdl = new CB_OP_LOG();
            try
            {
                string n_classdt = "00000000" + Convert.ToDateTime(classdate).ToString("yyyyMMdd");
                string n_stano = "0000" + stano;
                string n_potytype = "00" + porttype;
                string n_manno = "0000000000000000" + manno;
                string n_classno = "00" + classno;
                string n_subcomno = "0000" + subcomno;
                string keyNo = n_classdt.Substring(n_classdt.Length - 8) + n_stano.Substring(n_stano.Length - 4) + n_potytype.Substring(n_potytype.Length - 2) + n_manno.Substring(n_manno.Length - 16) + n_classno.Substring(n_classno.Length - 2);
                mdl.KEYLISTNO = keyNo;//主键集合
                mdl.ID = CommonHelper._Prmis_Cpc_balance + n_subcomno.Substring(n_subcomno.Length - 4) + n_stano.Substring(n_stano.Length - 4) + DateTime.Now.ToString("yyyyMMddHHmmss");
                mdl.TBNAME = CommonHelper.GetTbNameByPrmisid(CommonHelper._Prmis_Cpc_balance);//对应的表名称
                mdl.TYPE = CommonHelper._OpLog_Jx;//1-根据字典表解析KEYLISTNO  2-不需要解析
                mdl.PRMISID = CommonHelper._Prmis_Cpc_balance;//模块号
                mdl.SUBCOMNO = int.Parse(subcomno);
                mdl.STANO = int.Parse(CommonHelper._userStaNo);
                mdl.OPTYPE = 1;//产生日志类型 1-修改
                mdl.OLDT = Convert.ToDateTime(hdoldDt.Value.ToString());
                mdl.OLMANNO = int.Parse(hdoldManNo.Value.ToString());
                mdl.OLMAN = hdoldMan.Value.ToString();
                mdl.OLUSERTYPE = int.Parse(hdoldUType.Value.ToString());
                mdl.DATETIME = DateTime.Now;
                mdl.UPMANNO = int.Parse(hdUserId.Value.ToString());
                mdl.UPMAN = hdMan.Value.ToString();
                mdl.UPUSERTYPE = int.Parse(CommonHelper._userType);
                mdl.BAK1 = 0;
                mdl.BAK2 = 0;
                mdl.BAK3 = 0;
                mdl.BAK4 = string.Empty;
                mdl.BAK5 = string.Empty;
                mdl.BAK6 = string.Empty;
            }
            catch (Exception ex)
            {
                mdl = null;
            }
            return mdl;
        }
    }
}