using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using GThinking.N_MODEL.Page;
using GThinking.N_WORKFLOW;
using GThinking.N_MISPRO;
using GThinking.N_MISPRO.Data;
using GThinking.N_MISPRO.Utility;
using System.Collections.Generic;

namespace GThinking.N_XLXSBJ
{
    public partial class XSYBJSQList : SingleGridBase
    {
        XSYBJSQ entity = new XSYBJSQ();
        XSYBJSQ_M queryentity = new XSYBJSQ_M();
        public static Dictionary<string, string> dicFJXXXSBZ = new Dictionary<string, string>();
        public static Dictionary<string, string> dicFJXXSYBJFL = new Dictionary<string, string>();

        public static string sFJXXSZ = "";

        #region Page类事件继承

        protected void Page_Load(object sender, EventArgs e)
        {
            this.UMID = 100860061;
            this.UMName = "销售员报价申请";
            this.CurMaster = Master;
            this.ModuleGV = ContentGrid;
            this.CurEntity = entity;
            this.CurQueryEntity = queryentity;
            this.PageHeight = 500;
            this.PageWidth = 700;
            this.sURLTarget = "XSYBJSQInfo.aspx";
            this.sQueryURLTarget = "XSYBJSQQuery.aspx";
            base.DataKeyNames = new string[] { "XLXSBJD_BJDID", "XLXSBJD_BJFLID", "XLXSBJD_XMMC", "XLXSBJD_BJRQ", "XLXSBJD_ZJE" };
          
            this.Master.EnableAttachBtn = true;

            if (!IsPostBack)
            {
                CurQueryEntity.FieldByName("SW").Value = "W";
            }
            base.InitPage();
            if (!IsPostBack)
            {
                TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
                TSQL sSQL = new TSQL(dberp);
                sSQL.Clear();
                sSQL.Add("select XLXSBJKZXXSZ_MJSQL, XLXSBJKZXXSZ_SRFS,XLXSBJKZXXSZ_DYZD from XLXSBJKZXXSZ ");
                sSQL.Add("where 1=1 ");
                sSQL.Add("  and  rtrim(convert(varchar(4000),isnull(XLXSBJKZXXSZ_MJSQL ,' ')))||' ' <> ' ' and  isnull(XLXSBJKZXXSZ_SRFS,' ') <> 'A' ");
                sSQL.Add("  and isnull(XLXSBJKZXXSZ_LBXS,'N') = 'Y'");
                DataSet ds = dberp.OpenDataSet(sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
                    {
                        sFJXXSZ += ds.Tables[0].Rows[i]["XLXSBJKZXXSZ_DYZD"].ToString().Trim() + ",";
                    }
                }

                sSQL.Clear();
                sSQL.Add(" select XLXSBJKZXXSZ_XSBZ,XLXSBJKZXXSZ_DYZD from XLXSBJKZXXSZ ");
                sSQL.Add(" where 1=1 ");
                sSQL.Add(" and isnull(XLXSBJKZXXSZ_XSBZ,' ') <> ' '");
                sSQL.Add(" and isnull(XLXSBJKZXXSZ_LBXS,'N') = 'Y'");
                ds = dberp.OpenDataSet(sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
                    {
                        string sXSBZ = ds.Tables[0].Rows[i]["XLXSBJKZXXSZ_XSBZ"].ToString().Trim();
                        string sDYZD = ds.Tables[0].Rows[i]["XLXSBJKZXXSZ_DYZD"].ToString().Trim();
                        if (!dicFJXXXSBZ.ContainsKey(sDYZD))
                            dicFJXXXSBZ.Add(sDYZD, sXSBZ);
                    }
                }

                sSQL.Clear();
                sSQL.Add(" select XLXSBJKZXXSZ_SYBJFLID,XLXSBJKZXXSZ_DYZD from XLXSBJKZXXSZ ");
                sSQL.Add(" where 1=1 ");
                sSQL.Add(" and isnull(XLXSBJKZXXSZ_SYBJFLID,' ') <> ' '");
                sSQL.Add(" and isnull(XLXSBJKZXXSZ_LBXS,'N') = 'Y'");
                ds = dberp.OpenDataSet(sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
                    {
                        string sSYBJFL = ds.Tables[0].Rows[i]["XLXSBJKZXXSZ_SYBJFLID"].ToString().Trim();
                        string sDYZD = ds.Tables[0].Rows[i]["XLXSBJKZXXSZ_DYZD"].ToString().Trim();
                        if (!dicFJXXSYBJFL.ContainsKey(sDYZD))
                            dicFJXXSYBJFL.Add(sDYZD, sSYBJFL);
                    }
                }

                Master_OnStandardQuery(null, null);
            }
        }

        #endregion

        #region 模板继承事件

        protected override bool Master_BeforeDeleteAction(object sender, EventArgs e)
        {
            string sBJDID = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJDID"].ToString().Trim();
            string sSQL = string.Format("select top 1 XLXSBJYLZD_BJDID from XLXSBJYLZD where XLXSBJYLZD_BJDID='{0}'", sBJDID);
            if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
            {
                ShowMessage("已申请材料用量制定，不允许删除！");
                return false;
            }

            sSQL = string.Format("select 1 from BJD where BJD_BJDID='{0}'", sBJDID);
            if (CMISproDataBase.ExistsRecord("DBERP", sSQL))
            {
                ShowMessage("报价单已反馈，不允许删除！");
                return false;
            }
            XLBJDUtils.UpdateTJBZ(sBJDID, "Delete");

            CurEntity.Param.Add("XLXSBJD_BJDID", sBJDID);

            return base.Master_BeforeDeleteAction(sender, e);
        }

        protected override void AfterDelete(TDatabase db, ref bool ActionIsDone)
        {
            base.AfterDelete(db, ref ActionIsDone);
            TSQL tSQL = new TSQL(db);
            XLBJDUtils.AfterDeleteBJD(db, tSQL, ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJDID"].ToString().Trim());
        }

        protected override bool Master_AfterDeleteAction(object sender, EventArgs e)
        {
            if (!base.Master_AfterDeleteAction(sender, e)) return false;

            base.InitEntityByCondition();
            entity.EntityTable.QuerySelSql = GetQuerySql();
            entity.GridDataBind(ContentGrid, tSession);
            ContentGrid.SelectedIndex = -1;
            return true;
        }

        protected override void Master_OnStandardQuery(object sender, EventArgs e)
        {
            base.InitEntityByCondition();
            base.Master_OnStandardQuery(sender, e);
            entity.EntityTable.QuerySelSql = GetQuerySql();
            entity.GridDataBind(ContentGrid, tSession);
        }

        protected override void moduleGV_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            base.InitEntityByCondition();
            entity.EntityTable.QuerySelSql = GetQuerySql();
            ContentGrid.SelectedIndex = -1;
            base.moduleGV_PageIndexChanging(sender, e);
        }

        protected override void moduleGV_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                string sWPID = e.Row.Cells[0].Text.Trim();
                string sBJFLID = ContentGrid.DataKeys[e.Row.RowIndex]["XLXSBJD_BJFLID"].ToString().Trim();
                e.Row.Cells[0].Text = _curWorkFlow.GetWPName("XLXSBJ_BJD", e.Row.Cells[0].Text.Trim());
                e.Row.Cells[e.Row.Cells.Count - 3].Text = _curWorkFlow.UserInfo.GetUserNames(e.Row.Cells[e.Row.Cells.Count - 3].Text.Trim());
                e.Row.Cells[e.Row.Cells.Count - 4].Text = _curWorkFlow.UserInfo.GetUserNames(e.Row.Cells[e.Row.Cells.Count - 4].Text.Trim());
                int iKZSZStart = ContentGrid.Columns.IndexOf(ContentGrid.FindColumnByFieldName("KZSZ01"));
                for (int i = 1; i < 5; i++)
                {
                    string sZDM = "KZSZ" + i.ToString().PadLeft(2, '0');
                    if (dicFJXXXSBZ.ContainsKey(sZDM))
                    {
                        string sXSBZ = "," + dicFJXXXSBZ[sZDM] + ",";
                        if (!sXSBZ.Contains("," + sWPID + ","))
                        {
                            e.Row.Cells[iKZSZStart + i - 1].Text = "";
                        }
                    }
                    if (dicFJXXSYBJFL.ContainsKey(sZDM))
                    {
                        string sSYBJFL = "," + dicFJXXSYBJFL[sZDM] + ",";
                        if (!sSYBJFL.Contains("," + sBJFLID + ","))
                        {
                            e.Row.Cells[iKZSZStart + i - 1].Text = "";
                        }
                    }
                }

                int iKZZFStart = ContentGrid.Columns.IndexOf(ContentGrid.FindColumnByFieldName("KZZF01"));
                for (int i = 1; i < 11; i++)
                {
                    string sZDM = "KZZF" + i.ToString().PadLeft(2, '0');
                    if (sFJXXSZ.Contains(sZDM))
                        e.Row.Cells[iKZZFStart + i - 1].Text = GetZFSelected(sZDM, e.Row.Cells[iKZZFStart + i - 1].Text.Trim());
                    if (dicFJXXXSBZ.ContainsKey(sZDM))
                    {
                        string sXSBZ = "," + dicFJXXXSBZ[sZDM] + ",";
                        if (!sXSBZ.Contains("," + sWPID + ","))
                        {
                            e.Row.Cells[iKZZFStart + i - 1].Text = "";
                        }
                    }
                    if (dicFJXXSYBJFL.ContainsKey(sZDM))
                    {
                        string sSYBJFL = "," + dicFJXXSYBJFL[sZDM] + ",";
                        if (!sSYBJFL.Contains("," + sBJFLID + ","))
                        {
                            e.Row.Cells[iKZZFStart + i - 1].Text = "";
                        }
                    }
                }

                int iKZRQStart = ContentGrid.Columns.IndexOf(ContentGrid.FindColumnByFieldName("KZRQ01"));
                for (int i = 1; i < 5; i++)
                {
                    string sZDM = "KZRQ" + i.ToString().PadLeft(2, '0');
                    if (dicFJXXXSBZ.ContainsKey(sZDM))
                    {
                        string sXSBZ = "," + dicFJXXXSBZ[sZDM] + ",";
                        if (!sXSBZ.Contains("," + sWPID + ","))
                        {
                            e.Row.Cells[iKZRQStart + i - 1].Text = "";
                        }
                    }
                    if (dicFJXXSYBJFL.ContainsKey(sZDM))
                    {
                        string sSYBJFL = "," + dicFJXXSYBJFL[sZDM] + ",";
                        if (!sSYBJFL.Contains("," + sBJFLID + ","))
                        {
                            e.Row.Cells[iKZRQStart + i - 1].Text = "";
                        }
                    }
                }

                int iKZWBStart = ContentGrid.Columns.IndexOf(ContentGrid.FindColumnByFieldName("KZWB01"));
                for (int i = 1; i < 5; i++)
                {
                    string sZDM = "KZWB" + i.ToString().PadLeft(2, '0');
                    if (dicFJXXXSBZ.ContainsKey(sZDM))
                    {
                        string sXSBZ = "," + dicFJXXXSBZ[sZDM] + ",";
                        if (!sXSBZ.Contains("," + sWPID + ","))
                        {
                            e.Row.Cells[iKZWBStart + i - 1].Text = "";
                        }
                    }
                    if (dicFJXXSYBJFL.ContainsKey(sZDM))
                    {
                        string sSYBJFL = "," + dicFJXXSYBJFL[sZDM] + ",";
                        if (!sSYBJFL.Contains("," + sBJFLID + ","))
                        {
                            e.Row.Cells[iKZWBStart + i - 1].Text = "";
                        }
                    }
                }
                LinkPageParam.AddString("WFID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSBJD_WFID"].ToString().Trim());
                LinkPageParam.AddString("WFINST", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSBJD_WFINST"].ToString().Trim());
                LinkPageParam.AddString("XLXSBJD_BJDID", ContentGrid.DataKeys[e.Row.RowIndex]["XLXSBJD_BJDID"].ToString().Trim());
            }
            base.moduleGV_RowDataBound(sender, e);
        }

        protected override void BeforeAttach()
        {
            attDoc.WorkTableName = "XLXSBJD";
            attDoc.UpdCondition = string.Format(" XLXSBJD_BJDID='{0}'", ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJDID"].ToString().Trim());
            string sFJSCGS = XLBJDUtils.GetAttDocFilter();
            if (!sFJSCGS.Equals(""))
            {
                this.attDoc.Filter = sFJSCGS;
            }
            base.BeforeAttach();
        }

        protected override void Master_wfAfterActionEvent(TWorkflow Sender, TWFAction Action, bool ActionIsDone)
        {
            base.Master_wfAfterActionEvent(Sender, Action, ActionIsDone);

            if (!ActionIsDone)
                return;

            TSQL SQL = new TSQL(Sender.dbe);
            SQL.Clear();
            SQL.Add(" update XLXSBJD");
            SQL.Add(" set XLXSBJD_WFID = :XLXSBJD_WFID, ");
            SQL.Add("     XLXSBJD_WPID = :XLXSBJD_WPID, ");
            SQL.Add("     XLXSBJD_WFAWAITER = :XLXSBJD_WFAWAITER, ");
            SQL.Add("     XLXSBJD_WFHANDLER = :XLXSBJD_WFHANDLER, ");
            SQL.Add("     XLXSBJD_WFINST = :XLXSBJD_WFINST, ");
            SQL.Add("     XLXSBJD_ACTNAME = :XLXSBJD_ACTNAME ");
            SQL.Add(" where XLXSBJD_BJDID = :XLXSBJD_BJDID ");
            SQL.ParamByName("XLXSBJD_WFID").Value = Sender.WFID;
            SQL.ParamByName("XLXSBJD_WFINST").Value = Sender.WFInst;
            SQL.ParamByName("XLXSBJD_WPID").Value = Sender.WPID;
            SQL.ParamByName("XLXSBJD_WFAWAITER").Value = Sender.Awaiter;
            SQL.ParamByName("XLXSBJD_WFHANDLER").Value = Sender.Handler;
            SQL.ParamByName("XLXSBJD_ACTNAME").Value = Sender.GetWFActionName(Action);
            SQL.ParamByName("XLXSBJD_BJDID").Value = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJDID"].ToString().Trim();
            Sender.dbe.ExecSQL(SQL);

            string sBJDID = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJDID"].ToString().Trim();
            string sBJFLID = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJFLID"].ToString().Trim();
            string sXM = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_XMMC"].ToString().Trim();
            string sBJRQ = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJRQ"].ToString().Trim();
            string sZJE = ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_ZJE"].ToString().Trim();

            string sCurZT = TWorkflow.Utils.WFGetBZSWID(Sender.WFID, Sender.WPID);
            //若“100860062|销售报价业务配置”项目检索来源为“YXXM|售前项目”且XLXSBJD_XMMC不为空
            if (sCurZT == "ZZZZ")
            {
                string sPSDH = "";

                bool bINS = false;
                XLBJD_BDOBill.InsBJPS(SQL, Sender.dbe, Sender, Action, sBJDID, tSession, "100860061",ref sPSDH, ref bINS);
                if (bINS)
                {
                    XLBJD_BDOBill.DispatchtoZZZZ(sPSDH, tSession);
                }

            }

            if (Sender.WPID.Equals("ZZZZ"))
                XLBJDUtils.UpdateBJWCSJ(ContentGrid.DataKeys[ContentGrid.SelectedIndex]["XLXSBJD_BJDID"].ToString().Trim());
        }

        #endregion

        #region 私有函数
        //加载选择类型的字符数据
        private string GetZFSelected(string sZDM, string sValue)
        {
            string sResult = sValue;
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Clear();
            sSQL.Add("select XLXSBJKZXXSZ_MJSQL, XLXSBJKZXXSZ_SRFS from XLXSBJKZXXSZ ");
            sSQL.Add("where XLXSBJKZXXSZ_DYZD = :pDYZD ");
            sSQL.Add("  and  rtrim(convert(varchar(4000),isnull(XLXSBJKZXXSZ_MJSQL ,' ')))||' ' <> ' ' and  isnull(XLXSBJKZXXSZ_SRFS,' ') <> 'A' ");
            sSQL.ParamByName("pDYZD").Value = sZDM.Trim();
            DataSet ds = dberp.OpenDataSet(sSQL);
            if (ds.Tables[0].Rows.Count > 0)
            {
                sValue = "," + sValue + ",";
                sResult = "";
                string sMJSQL = ds.Tables[0].Rows[0][0].ToString().Trim();
                string sSRFS = ds.Tables[0].Rows[0][1].ToString().Trim();
                sSQL.Clear();
                sSQL.Add(sMJSQL);
                DataSet dsResult = dberp.OpenDataSet(sSQL);
                if (sSRFS.Trim().Equals("B"))
                {
                    for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
                    {
                        if (sValue.Trim().Contains("," + dsResult.Tables[0].Rows[i][0].ToString().Trim() + ","))
                        {
                            sResult += dsResult.Tables[0].Rows[i][0].ToString().Trim() + "|" + dsResult.Tables[0].Rows[i][1].ToString().Trim();
                            break;
                        }
                    }
                }
                else
                {
                    for (int i = 0; i < dsResult.Tables[0].Rows.Count; i++)
                    {
                        if (sValue.Trim().Contains("," + dsResult.Tables[0].Rows[i][0].ToString().Trim() + ","))
                        {
                            sResult += dsResult.Tables[0].Rows[i][1].ToString().Trim() + ",";
                        }
                    }
                }
                sResult = sResult.TrimEnd(',');
            }
            return sResult;
        }

        //设置附加信息是否显示
        private void SetFJXX()
        {
            TDatabase dberp = TContextDatabases.GetDatabase("DBERP");
            TSQL sSQL = new TSQL(dberp);
            sSQL.Clear();
            sSQL.Add("select XLXSBJKZXXSZ_MC, XLXSBJKZXXSZ_DYZD from XLXSBJKZXXSZ where isnull(XLXSBJKZXXSZ_LBXS,'N') = 'Y' order by XLXSBJKZXXSZ_BH");
            DataSet ds = dberp.OpenDataSet(sSQL);
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                ContentGrid.FindColumnByFieldName(ds.Tables[0].Rows[i][1].ToString().Trim()).Visible = true;
                ContentGrid.FindColumnByFieldName(ds.Tables[0].Rows[i][1].ToString().Trim()).HeaderText = ds.Tables[0].Rows[i][0].ToString().Trim();
            }
        }

        private string GetQuerySql()
        {
            SetFJXX();
            string sSQL = " select XLXSBJD_BJDID,XLXSBJD_BJFLID, XLXSBJD_JGBID,XLXSBJD_CLHQJGBID, XLXSBJD_BJRQ,XLXSBJD_SYDWID,XLXSBJD_XSBMID,XLXSBJD_KH,XLXSBJD_XMMC,XLXSBJD_FKSM,XLXSBJD_BZ,XLXSBJD_CZJSXY,XLXSBJD_TXY,XLXSBJD_ZJE,"
                        + " case when isnull(XLXSBJFL_BJFLID,' ')=' ' then ' ' else rtrim(XLXSBJD_BJFLID)|| '|' ||XLXSBJFL_BJFLMC end as BJFL,"
                        + " case when isnull(XLXSBJD_SYDWID,' ') = ' ' then ' ' else rtrim(XLXSBJD_SYDWID)|| '|' || GS_GSMC end as XSDW,"
                        + " case when isnull(XLXSBJD_XSBMID,' ') = ' ' then ' ' else rtrim(XLXSBJD_XSBMID)||'|'||BM_MC end as BJGSBM, "
                        + " XLXSBJKZXX_KZSZ01 as KZSZ01, XLXSBJKZXX_KZSZ02 as KZSZ02, XLXSBJKZXX_KZSZ03 as KZSZ03, XLXSBJKZXX_KZSZ04 as KZSZ04, XLXSBJKZXX_KZSZ05 as KZSZ05, "
                        + " XLXSBJKZXX_KZZF01 as KZZF01, XLXSBJKZXX_KZZF02 as KZZF02, XLXSBJKZXX_KZZF03 as KZZF03, XLXSBJKZXX_KZZF04 as KZZF04, XLXSBJKZXX_KZZF05 as KZZF05, "
                        + " XLXSBJKZXX_KZZF06 as KZZF06, XLXSBJKZXX_KZZF07 as KZZF07, XLXSBJKZXX_KZZF08 as KZZF08, XLXSBJKZXX_KZZF09 as KZZF09, XLXSBJKZXX_KZZF10 as KZZF10, "
                        + " XLXSBJKZXX_KZRQ01 as KZRQ01, XLXSBJKZXX_KZRQ02 as KZRQ02, XLXSBJKZXX_KZRQ03 as KZRQ03, XLXSBJKZXX_KZRQ04 as KZRQ04, XLXSBJKZXX_KZRQ05 as KZRQ05, "
                        + " XLXSBJKZXX_KZWB01 as KZWB01, XLXSBJKZXX_KZWB02 as KZWB02, XLXSBJKZXX_KZWB03 as KZWB03, XLXSBJKZXX_KZWB04 as KZWB04, XLXSBJKZXX_KZWB05 as KZWB05, "
                        + " XLXSBJD_DOCGRPID,XLXSBJD_FJS,XLXSBJD_WHR, XLXSBJD_WHRID, XLXSBJD_WHSJ, XLXSBJD_WFID, XLXSBJD_WFINST, XLXSBJD_WPID, XLXSBJD_WFAWAITER, XLXSBJD_WFHANDLER, XLXSBJD_ACTNAME "
                        + " from XLXSBJD "
                        + " left join XLXSBJKZXX on XLXSBJKZXX_BJDID = XLXSBJD_BJDID "
                        + " left join GS on GS_SYDWID=XLXSBJD_SYDWID"
                        + " left join XLXSBJFL on XLXSBJD_BJFLID=XLXSBJFL_BJFLID"
                        + " left join BM on BM_BMID=XLXSBJD_XSBMID"
                        + " where  1=1 ";
            switch (CurQueryEntity.FieldByName("SW").Value.Trim())
            {
                case "W":
                    sSQL += "\r\n and " + _curWorkFlow.GetWhereAgent("XLXSBJ_BJD", tSession.UserId, "XLXSBJD_WFAWAITER", "XLXSBJD_WFID", "XLXSBJD_WPID");
                    break;
                case "H":
                    sSQL += "\r\n and XLXSBJD_WFHANDLER LIKE :XLXSBJD_WFHANDLER ";
                    entity.Param.Add("XLXSBJD_WFHANDLER", "%," + tSession.UserId + ",%");
                    break;
                case "A":
                    break;
            }
            if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("WFAWAITER").Value.Trim()))
            {
                sSQL += " \r\n and XLXSBJD_WFAWAITER like :pWFAWITER  ";
                entity.Param.Add("pWFAWITER", string.Format("%,{0},%", CurQueryEntity.FieldByName("WFAWAITER").Value.Trim()));
            }
            if (!string.IsNullOrEmpty(CurQueryEntity.FieldByName("STATE").Value.Trim()))
            {
                sSQL += "\r\n and " + CMISproDataBase.GetWhereEqual("XLXSBJD_WPID", CurQueryEntity.FieldByName("STATE").Value.Trim());
            }
            if (!CurQueryEntity.FieldByName("KH").Value.Trim().Equals(""))
            {
                sSQL += "\r\n and (XLXSBJD_KH like :pKH) ";
                entity.Param.Add("pKH", "%" + CurQueryEntity.FieldByName("KH").Value.Trim() + "%");
            }
            if (!CurQueryEntity.FieldByName("XM").Value.Trim().Equals(""))
            {
                sSQL += "\r\n and (XLXSBJD_XMMC like :pXM) ";
                entity.Param.Add("pXM", "%" + CurQueryEntity.FieldByName("XM").Value.Trim() + "%");
            }
            if (!CurQueryEntity.FieldByName("TXY").Value.Trim().Equals(""))
            {
                sSQL += "\r\n and (XLXSBJD_TXY = :pTXY) ";
                entity.Param.Add("pTXY", CurQueryEntity.FieldByName("TXY").Value.Trim());
            }
            if (!CurQueryEntity.FieldByName("XSBM").Value.Trim().Equals(""))
            {
                sSQL += "\r\n and " + CMISproDataBase.GetWhereEqual("XLXSBJD_XSBMID", CurQueryEntity.FieldByName("XSBM").Value.Trim());
            }
            if (!CurQueryEntity.FieldByName("BJDID").Value.Trim().Equals(""))
            {
                sSQL += "\r\n and XLXSBJD_BJDID like :pBJDID ";
                entity.Param.Add("pBJDID", "%" + CurQueryEntity.FieldByName("BJDID").Value.Trim() + "%");
            }
            if (!CurQueryEntity.FieldByName("BJBZ").Value.Trim().Equals(""))
            {
                sSQL += "\r\n and XLXSBJD_BZ like :pBJBZ ";
                entity.Param.Add("pBJBZ", "%" + CurQueryEntity.FieldByName("BJBZ").Value.Trim() + "%");
            }
            if (!string.IsNullOrEmpty(GetOption("BJU012").Trim()))
            {
                sSQL += " and (" + CMISproDataBase.GetWhereEqual("XLXSBJD_BJFLID", GetOption("BJU012").Trim());
                sSQL += "      or isnull(XLXSBJD_BJFLID, ' ') = ' ')";
            }
            if (!string.IsNullOrEmpty(GetOption("KZZXU003").Trim()))
            {
                sSQL += " and (" + CMISproDataBase.GetWhereEqual("XLXSBJD_SYDWID", GetOption("KZZXU003").Trim());
                sSQL += "      or isnull(XLXSBJD_SYDWID, ' ') = ' ')";
            }
            if (!string.IsNullOrEmpty(GetOption("HJU006").Trim()))
            {
                sSQL += " and (" + CMISproDataBase.GetWhereEqual("XLXSBJD_XSBMID", GetOption("HJU006").Trim());
                sSQL += "      or isnull(XLXSBJD_XSBMID, ' ') = ' ')";
            }
            sSQL += CMISproDataBase.GetTimeConditionSQL("XLXSBJD_BJRQ",
                                            CurQueryEntity.FieldByName("BJRQS").Value.ToString().Trim(),
                                            CurQueryEntity.FieldByName("BJRQZ").Value.ToString().Trim(),
                                            DateTimeType.dtDate, DateTimeType.dtDate);


            sSQL += " order by XLXSBJD_BJRQ DESC , XLXSBJD_BJDID ";
            
            return sSQL;
        }

        #endregion
    }
}