HBSZRX/API/CallCenterApi/CallCenterAp.../T_Bus_WorkOr...

using System;
using System.Data;
using System.Text;
using System.Data.SqlClient;
using CallCenterApi.DB;//Please add references
namespace CallCenterApi.DAL
{
    /// <summary>
    /// 数据访问类:T_Bus_WorkOrder
    /// </summary>
    public partial class T_Bus_WorkOrder
    {
        public T_Bus_WorkOrder()
        { }
        #region  Method

        /// <summary>
        /// 是否存在该记录
        /// </summary>
        public bool Exists(string F_WorkOrderId)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from T_Bus_WorkOrder WITH(NOLOCK)");
            strSql.Append(" where F_WorkOrderId=@F_WorkOrderId ");
            SqlParameter[] parameters = {
					new SqlParameter("@F_WorkOrderId", SqlDbType.NVarChar,20)};
            parameters[0].Value = F_WorkOrderId;

            return DbHelperSQL.Exists(strSql.ToString(), parameters);
        }

        /// <summary>
        /// 根据条件查询存在多少记录
        /// </summary>
        public int GetCountByCondition(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select count(1) from T_Bus_WorkOrder WITH(NOLOCK)");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            object result=DbHelperSQL.GetSingle(strSql.ToString());
            if(result==null)
            {
                return 0;

            }
            else
            {
                return Convert.ToInt32(result);
            }
        }
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(CallCenterApi.Model.T_Bus_WorkOrder model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into T_Bus_WorkOrder(");
            strSql.Append("F_WorkOrderId,F_CusName,F_CusSex,F_CusPhone,F_CusAddress,F_ConName,F_ConPhone,F_ZipCode,F_Email,F_ComTitle,F_ComContent,F_IsProtect,F_IsFile,F_InfoSource,F_UserCode,F_InfoType,F_InfoConBigType,F_InfoConSmallType,F_SourceArea,F_SourceAddress,F_RegDate,F_IsResult,F_Result,F_SubmitFlag,F_ProcessingFlag,F_WorkState,F_IsClosed,F_IsRead,F_RemindWorkday,F_OverdueWorkday,F_IsOverdue,F_IsDelete,F_IsEnabled,F_EnableTime)");
            strSql.Append(" values (");
            strSql.Append("@F_WorkOrderId,@F_CusName,@F_CusSex,@F_CusPhone,@F_CusAddress,@F_ConName,@F_ConPhone,@F_ZipCode,@F_Email,@F_ComTitle,@F_ComContent,@F_IsProtect,@F_IsFile,@F_InfoSource,@F_UserCode,@F_InfoType,@F_InfoConBigType,@F_InfoConSmallType,@F_SourceArea,@F_SourceAddress,@F_RegDate,@F_IsResult,@F_Result,@F_SubmitFlag,@F_ProcessingFlag,@F_WorkState,@F_IsClosed,@F_IsRead,@F_RemindWorkday,@F_OverdueWorkday,@F_IsOverdue,@F_IsDelete,@F_IsEnabled,@F_EnableTime)");
            SqlParameter[] parameters = {
					new SqlParameter("@F_WorkOrderId", SqlDbType.NVarChar,20),
					new SqlParameter("@F_CusName", SqlDbType.NVarChar,20),
					new SqlParameter("@F_CusSex", SqlDbType.NVarChar,10),
					new SqlParameter("@F_CusPhone", SqlDbType.NVarChar,20),
					new SqlParameter("@F_CusAddress", SqlDbType.NVarChar,200),
					new SqlParameter("@F_ConName", SqlDbType.NVarChar,20),
					new SqlParameter("@F_ConPhone", SqlDbType.NVarChar,20),
					new SqlParameter("@F_ZipCode", SqlDbType.NVarChar,10),
					new SqlParameter("@F_Email", SqlDbType.NVarChar,50),
					new SqlParameter("@F_ComTitle", SqlDbType.NVarChar,200),
					new SqlParameter("@F_ComContent", SqlDbType.Text),
					new SqlParameter("@F_IsProtect", SqlDbType.Bit,1),
					new SqlParameter("@F_IsFile", SqlDbType.Bit,1),
					new SqlParameter("@F_InfoSource", SqlDbType.Int,4),
					new SqlParameter("@F_UserCode", SqlDbType.NVarChar,20),
					new SqlParameter("@F_InfoType", SqlDbType.Int,4),
					new SqlParameter("@F_InfoConBigType", SqlDbType.Int,4),
					new SqlParameter("@F_InfoConSmallType", SqlDbType.Int,4),
					new SqlParameter("@F_SourceArea", SqlDbType.Int,4),
					new SqlParameter("@F_SourceAddress", SqlDbType.NVarChar,200),
					new SqlParameter("@F_RegDate", SqlDbType.DateTime),
					new SqlParameter("@F_IsResult", SqlDbType.Bit,1),
					new SqlParameter("@F_Result", SqlDbType.Text),
					new SqlParameter("@F_SubmitFlag", SqlDbType.Int,4),
					new SqlParameter("@F_ProcessingFlag", SqlDbType.Int,4),
					new SqlParameter("@F_WorkState", SqlDbType.Int,4),
					new SqlParameter("@F_IsClosed", SqlDbType.Bit,1),
					new SqlParameter("@F_IsRead", SqlDbType.Bit,1),
					new SqlParameter("@F_RemindWorkday", SqlDbType.Int,4),
					new SqlParameter("@F_OverdueWorkday", SqlDbType.Int,4),
					new SqlParameter("@F_IsOverdue", SqlDbType.Bit,1),
                                        	new SqlParameter("@F_IsDelete", SqlDbType.Bit,1),
                                        	new SqlParameter("@F_IsEnabled", SqlDbType.Bit,1),
                                        new SqlParameter("@F_EnableTime", SqlDbType.DateTime)};
            parameters[0].Value = model.F_WorkOrderId;
            parameters[1].Value = model.F_CusName;
            parameters[2].Value = model.F_CusSex;
            parameters[3].Value = model.F_CusPhone;
            parameters[4].Value = model.F_CusAddress;
            parameters[5].Value = model.F_ConName;
            parameters[6].Value = model.F_ConPhone;
            parameters[7].Value = model.F_ZipCode;
            parameters[8].Value = model.F_Email;
            parameters[9].Value = model.F_ComTitle;
            parameters[10].Value = model.F_ComContent;
            parameters[11].Value = model.F_IsProtect;
            parameters[12].Value = model.F_IsFile;
            parameters[13].Value = model.F_InfoSource;
            parameters[14].Value = model.F_UserCode;
            parameters[15].Value = model.F_InfoType;
            parameters[16].Value = model.F_InfoConBigType;
            parameters[17].Value = model.F_InfoConSmallType;
            parameters[18].Value = model.F_SourceArea;
            parameters[19].Value = model.F_SourceAddress;
            parameters[20].Value = model.F_RegDate;
            parameters[21].Value = model.F_IsResult;
            parameters[22].Value = model.F_Result;
            parameters[23].Value = model.F_SubmitFlag;
            parameters[24].Value = model.F_ProcessingFlag;
            parameters[25].Value = model.F_WorkState;
            parameters[26].Value = model.F_IsClosed;
            parameters[27].Value = model.F_IsRead;
            parameters[28].Value = model.F_RemindWorkday;
            parameters[29].Value = model.F_OverdueWorkday;
            parameters[30].Value = model.F_IsOverdue;
            parameters[31].Value = model.F_IsDelete;
            parameters[32].Value = model.F_IsEnabled;
            parameters[33].Value = model.F_EnableTime;
            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool Update(CallCenterApi.Model.T_Bus_WorkOrder model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_Bus_WorkOrder set ");
            strSql.Append("F_CusName=@F_CusName,");
            strSql.Append("F_CusSex=@F_CusSex,");
            strSql.Append("F_CusPhone=@F_CusPhone,");
            strSql.Append("F_CusAddress=@F_CusAddress,");
            strSql.Append("F_ConName=@F_ConName,");
            strSql.Append("F_ConPhone=@F_ConPhone,");
            strSql.Append("F_ZipCode=@F_ZipCode,");
            strSql.Append("F_Email=@F_Email,");
            strSql.Append("F_ComTitle=@F_ComTitle,");
            strSql.Append("F_ComContent=@F_ComContent,");
            strSql.Append("F_IsProtect=@F_IsProtect,");
            strSql.Append("F_IsFile=@F_IsFile,");
            strSql.Append("F_InfoSource=@F_InfoSource,");
            strSql.Append("F_UserCode=@F_UserCode,");
            strSql.Append("F_InfoType=@F_InfoType,");
            strSql.Append("F_InfoConBigType=@F_InfoConBigType,");
            strSql.Append("F_InfoConSmallType=@F_InfoConSmallType,");
            strSql.Append("F_SourceArea=@F_SourceArea,");
            strSql.Append("F_SourceAddress=@F_SourceAddress,");
            strSql.Append("F_RegDate=@F_RegDate,");
            strSql.Append("F_IsResult=@F_IsResult,");
            strSql.Append("F_Result=@F_Result,");
            strSql.Append("F_SubmitFlag=@F_SubmitFlag,");
            strSql.Append("F_ProcessingFlag=@F_ProcessingFlag,");
            strSql.Append("F_WorkState=@F_WorkState,");
            strSql.Append("F_IsClosed=@F_IsClosed,");
            strSql.Append("F_IsRead=@F_IsRead,");
            strSql.Append("F_RemindWorkday=@F_RemindWorkday,");
            strSql.Append("F_OverdueWorkday=@F_OverdueWorkday,");
            strSql.Append("F_IsOverdue=@F_IsOverdue,");
            strSql.Append("F_IsDelete=@F_IsDelete,");
            strSql.Append("F_IsEnabled=@F_IsEnabled,");
            strSql.Append("F_EnableTime=@F_EnableTime");
            strSql.Append(" where F_WorkOrderId=@F_WorkOrderId ");
            SqlParameter[] parameters = {
					new SqlParameter("@F_CusName", SqlDbType.NVarChar,20),
					new SqlParameter("@F_CusSex", SqlDbType.NVarChar,10),
					new SqlParameter("@F_CusPhone", SqlDbType.NVarChar,20),
					new SqlParameter("@F_CusAddress", SqlDbType.NVarChar,200),
					new SqlParameter("@F_ConName", SqlDbType.NVarChar,20),
					new SqlParameter("@F_ConPhone", SqlDbType.NVarChar,20),
					new SqlParameter("@F_ZipCode", SqlDbType.NVarChar,10),
					new SqlParameter("@F_Email", SqlDbType.NVarChar,50),
					new SqlParameter("@F_ComTitle", SqlDbType.NVarChar,200),
					new SqlParameter("@F_ComContent", SqlDbType.Text),
					new SqlParameter("@F_IsProtect", SqlDbType.Bit,1),
					new SqlParameter("@F_IsFile", SqlDbType.Bit,1),
					new SqlParameter("@F_InfoSource", SqlDbType.Int,4),
					new SqlParameter("@F_UserCode", SqlDbType.NVarChar,20),
					new SqlParameter("@F_InfoType", SqlDbType.Int,4),
					new SqlParameter("@F_InfoConBigType", SqlDbType.Int,4),
					new SqlParameter("@F_InfoConSmallType", SqlDbType.Int,4),
					new SqlParameter("@F_SourceArea", SqlDbType.Int,4),
					new SqlParameter("@F_SourceAddress", SqlDbType.NVarChar,200),
					new SqlParameter("@F_RegDate", SqlDbType.DateTime),
					new SqlParameter("@F_IsResult", SqlDbType.Bit,1),
					new SqlParameter("@F_Result", SqlDbType.Text),
					new SqlParameter("@F_SubmitFlag", SqlDbType.Int,4),
					new SqlParameter("@F_ProcessingFlag", SqlDbType.Int,4),
					new SqlParameter("@F_WorkState", SqlDbType.Int,4),
					new SqlParameter("@F_IsClosed", SqlDbType.Bit,1),
					new SqlParameter("@F_IsRead", SqlDbType.Bit,1),
					new SqlParameter("@F_RemindWorkday", SqlDbType.Int,4),
					new SqlParameter("@F_OverdueWorkday", SqlDbType.Int,4),
					new SqlParameter("@F_IsOverdue", SqlDbType.Bit,1),
					new SqlParameter("@F_WorkOrderId", SqlDbType.NVarChar,20),
                                        new SqlParameter("@F_IsDelete", SqlDbType.Bit,1),
                                        new SqlParameter("@F_IsEnabled", SqlDbType.Bit,1),
                                        new SqlParameter("@F_EnableTime", SqlDbType.DateTime)};
            parameters[0].Value = model.F_CusName;
            parameters[1].Value = model.F_CusSex;
            parameters[2].Value = model.F_CusPhone;
            parameters[3].Value = model.F_CusAddress;
            parameters[4].Value = model.F_ConName;
            parameters[5].Value = model.F_ConPhone;
            parameters[6].Value = model.F_ZipCode;
            parameters[7].Value = model.F_Email;
            parameters[8].Value = model.F_ComTitle;
            parameters[9].Value = model.F_ComContent;
            parameters[10].Value = model.F_IsProtect;
            parameters[11].Value = model.F_IsFile;
            parameters[12].Value = model.F_InfoSource;
            parameters[13].Value = model.F_UserCode;
            parameters[14].Value = model.F_InfoType;
            parameters[15].Value = model.F_InfoConBigType;
            parameters[16].Value = model.F_InfoConSmallType;
            parameters[17].Value = model.F_SourceArea;
            parameters[18].Value = model.F_SourceAddress;
            parameters[19].Value = model.F_RegDate;
            parameters[20].Value = model.F_IsResult;
            parameters[21].Value = model.F_Result;
            parameters[22].Value = model.F_SubmitFlag;
            parameters[23].Value = model.F_ProcessingFlag;
            parameters[24].Value = model.F_WorkState;
            parameters[25].Value = model.F_IsClosed;
            parameters[26].Value = model.F_IsRead;
            parameters[27].Value = model.F_RemindWorkday;
            parameters[28].Value = model.F_OverdueWorkday;
            parameters[29].Value = model.F_IsOverdue;
            parameters[30].Value = model.F_WorkOrderId;
            parameters[31].Value = model.F_IsDelete;
            parameters[32].Value = model.F_IsEnabled;
            parameters[33].Value = model.F_EnableTime;
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(string F_WorkOrderId)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_Bus_WorkOrder ");
            strSql.Append(" where F_WorkOrderId=@F_WorkOrderId ");
            SqlParameter[] parameters = {
					new SqlParameter("@F_WorkOrderId", SqlDbType.NVarChar,20)};
            parameters[0].Value = F_WorkOrderId;

            int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool DeleteList(string F_WorkOrderIdlist)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("delete from T_Bus_WorkOrder ");
            strSql.Append(" where F_WorkOrderId in (" + F_WorkOrderIdlist + ")  ");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool DeleteLogicList(string F_WorkOrderIdlist)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("update T_Bus_WorkOrder set F_IsDelete=1 ");
            strSql.Append(" where F_WorkOrderId in (" + F_WorkOrderIdlist + ")  ");
            int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
            if (rows > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }
        /// <summary>
        /// 更新一批数据的状态
        /// </summary>
        public bool UpdateStateList(string F_WorkOrderIdlist, string p_State)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("update T_Bus_WorkOrder ");
                strSql.Append(" set F_WorkState=" + p_State);
                strSql.Append(" where F_WorkOrderId in (" + F_WorkOrderIdlist + ")  ");
                int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
                if (rows > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 更新一批数据的状态，修改删除标志，处理标志，登记人
        /// </summary>
        public bool UpdateData(string F_WorkOrderIdlist, string p_IsDelete,string p_IsEnabled,string p_UserCode)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("update T_Bus_WorkOrder ");
                strSql.Append(" set F_IsDelete=" + p_IsDelete + ",F_IsEnabled=" + p_IsEnabled + ",F_EnableTime=getdate(),F_UserCode='" + p_UserCode+"'");
                strSql.Append(" where F_WorkOrderId in (" + F_WorkOrderIdlist + ")  ");
                int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
                if (rows > 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.T_Bus_WorkOrder GetModel(string F_WorkOrderId)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append("select  top 1 F_WorkOrderId,F_CusName,F_CusSex,F_CusPhone,F_CusAddress,F_ConName,F_ConPhone,F_ZipCode,F_Email,F_ComTitle,F_ComContent,F_IsProtect,F_IsFile,F_InfoSource,F_UserCode,F_InfoType,F_InfoConBigType,F_InfoConSmallType,F_SourceArea,F_SourceAddress,F_RegDate,F_IsResult,F_Result,F_SubmitFlag,F_ProcessingFlag,F_WorkState,F_IsClosed,F_IsRead,F_RemindWorkday,F_OverdueWorkday,F_IsOverdue,F_IsDelete,F_IsEnabled from T_Bus_WorkOrder WITH(NOLOCK) ");
            strSql.Append(" where F_WorkOrderId=@F_WorkOrderId ");
            SqlParameter[] parameters = {
					new SqlParameter("@F_WorkOrderId", SqlDbType.NVarChar,20)};
            parameters[0].Value = F_WorkOrderId;

            CallCenterApi.Model.T_Bus_WorkOrder model = new CallCenterApi.Model.T_Bus_WorkOrder();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["F_WorkOrderId"] != null && ds.Tables[0].Rows[0]["F_WorkOrderId"].ToString() != "")
                {
                    model.F_WorkOrderId = ds.Tables[0].Rows[0]["F_WorkOrderId"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusName"] != null && ds.Tables[0].Rows[0]["F_CusName"].ToString() != "")
                {
                    model.F_CusName = ds.Tables[0].Rows[0]["F_CusName"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusSex"] != null && ds.Tables[0].Rows[0]["F_CusSex"].ToString() != "")
                {
                    model.F_CusSex = ds.Tables[0].Rows[0]["F_CusSex"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusPhone"] != null && ds.Tables[0].Rows[0]["F_CusPhone"].ToString() != "")
                {
                    model.F_CusPhone = ds.Tables[0].Rows[0]["F_CusPhone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusAddress"] != null && ds.Tables[0].Rows[0]["F_CusAddress"].ToString() != "")
                {
                    model.F_CusAddress = ds.Tables[0].Rows[0]["F_CusAddress"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ConName"] != null && ds.Tables[0].Rows[0]["F_ConName"].ToString() != "")
                {
                    model.F_ConName = ds.Tables[0].Rows[0]["F_ConName"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ConPhone"] != null && ds.Tables[0].Rows[0]["F_ConPhone"].ToString() != "")
                {
                    model.F_ConPhone = ds.Tables[0].Rows[0]["F_ConPhone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ZipCode"] != null && ds.Tables[0].Rows[0]["F_ZipCode"].ToString() != "")
                {
                    model.F_ZipCode = ds.Tables[0].Rows[0]["F_ZipCode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_Email"] != null && ds.Tables[0].Rows[0]["F_Email"].ToString() != "")
                {
                    model.F_Email = ds.Tables[0].Rows[0]["F_Email"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ComTitle"] != null && ds.Tables[0].Rows[0]["F_ComTitle"].ToString() != "")
                {
                    model.F_ComTitle = ds.Tables[0].Rows[0]["F_ComTitle"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ComContent"] != null && ds.Tables[0].Rows[0]["F_ComContent"].ToString() != "")
                {
                    model.F_ComContent = ds.Tables[0].Rows[0]["F_ComContent"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_IsProtect"] != null && ds.Tables[0].Rows[0]["F_IsProtect"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsProtect"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsProtect"].ToString().ToLower() == "true"))
                    {
                        model.F_IsProtect = true;
                    }
                    else
                    {
                        model.F_IsProtect = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_IsFile"] != null && ds.Tables[0].Rows[0]["F_IsFile"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsFile"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsFile"].ToString().ToLower() == "true"))
                    {
                        model.F_IsFile = true;
                    }
                    else
                    {
                        model.F_IsFile = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_InfoSource"] != null && ds.Tables[0].Rows[0]["F_InfoSource"].ToString() != "")
                {
                    model.F_InfoSource = int.Parse(ds.Tables[0].Rows[0]["F_InfoSource"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_UserCode"] != null && ds.Tables[0].Rows[0]["F_UserCode"].ToString() != "")
                {
                    model.F_UserCode = ds.Tables[0].Rows[0]["F_UserCode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_InfoType"] != null && ds.Tables[0].Rows[0]["F_InfoType"].ToString() != "")
                {
                    model.F_InfoType = int.Parse(ds.Tables[0].Rows[0]["F_InfoType"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_InfoConBigType"] != null && ds.Tables[0].Rows[0]["F_InfoConBigType"].ToString() != "")
                {
                    model.F_InfoConBigType = int.Parse(ds.Tables[0].Rows[0]["F_InfoConBigType"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_InfoConSmallType"] != null && ds.Tables[0].Rows[0]["F_InfoConSmallType"].ToString() != "")
                {
                    model.F_InfoConSmallType = int.Parse(ds.Tables[0].Rows[0]["F_InfoConSmallType"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_SourceArea"] != null && ds.Tables[0].Rows[0]["F_SourceArea"].ToString() != "")
                {
                    model.F_SourceArea = int.Parse(ds.Tables[0].Rows[0]["F_SourceArea"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_SourceAddress"] != null && ds.Tables[0].Rows[0]["F_SourceAddress"].ToString() != "")
                {
                    model.F_SourceAddress = ds.Tables[0].Rows[0]["F_SourceAddress"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_RegDate"] != null && ds.Tables[0].Rows[0]["F_RegDate"].ToString() != "")
                {
                    model.F_RegDate = DateTime.Parse(ds.Tables[0].Rows[0]["F_RegDate"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_IsResult"] != null && ds.Tables[0].Rows[0]["F_IsResult"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsResult"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsResult"].ToString().ToLower() == "true"))
                    {
                        model.F_IsResult = true;
                    }
                    else
                    {
                        model.F_IsResult = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_Result"] != null && ds.Tables[0].Rows[0]["F_Result"].ToString() != "")
                {
                    model.F_Result = ds.Tables[0].Rows[0]["F_Result"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_SubmitFlag"] != null && ds.Tables[0].Rows[0]["F_SubmitFlag"].ToString() != "")
                {
                    model.F_SubmitFlag = int.Parse(ds.Tables[0].Rows[0]["F_SubmitFlag"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_ProcessingFlag"] != null && ds.Tables[0].Rows[0]["F_ProcessingFlag"].ToString() != "")
                {
                    model.F_ProcessingFlag = int.Parse(ds.Tables[0].Rows[0]["F_ProcessingFlag"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_WorkState"] != null && ds.Tables[0].Rows[0]["F_WorkState"].ToString() != "")
                {
                    model.F_WorkState = int.Parse(ds.Tables[0].Rows[0]["F_WorkState"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_IsClosed"] != null && ds.Tables[0].Rows[0]["F_IsClosed"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsClosed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsClosed"].ToString().ToLower() == "true"))
                    {
                        model.F_IsClosed = true;
                    }
                    else
                    {
                        model.F_IsClosed = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_IsRead"] != null && ds.Tables[0].Rows[0]["F_IsRead"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsRead"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsRead"].ToString().ToLower() == "true"))
                    {
                        model.F_IsRead = true;
                    }
                    else
                    {
                        model.F_IsRead = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_RemindWorkday"] != null && ds.Tables[0].Rows[0]["F_RemindWorkday"].ToString() != "")
                {
                    model.F_RemindWorkday = int.Parse(ds.Tables[0].Rows[0]["F_RemindWorkday"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_OverdueWorkday"] != null && ds.Tables[0].Rows[0]["F_OverdueWorkday"].ToString() != "")
                {
                    model.F_OverdueWorkday = int.Parse(ds.Tables[0].Rows[0]["F_OverdueWorkday"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_IsOverdue"] != null && ds.Tables[0].Rows[0]["F_IsOverdue"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsOverdue"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsOverdue"].ToString().ToLower() == "true"))
                    {
                        model.F_IsOverdue = true;
                    }
                    else
                    {
                        model.F_IsOverdue = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_IsDelete"] != null && ds.Tables[0].Rows[0]["F_IsDelete"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsDelete"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsDelete"].ToString().ToLower() == "true"))
                    {
                        model.F_IsDelete = true;
                    }
                    else
                    {
                        model.F_IsDelete = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_IsEnabled"] != null && ds.Tables[0].Rows[0]["F_IsEnabled"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsEnabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsEnabled"].ToString().ToLower() == "true"))
                    {
                        model.F_IsEnabled = true;
                    }
                    else
                    {
                        model.F_IsEnabled = false;
                    }
                }
                return model;
            }
            else
            {
                return null;
            }
        }


        /// <summary>
        /// 从视图得到一个对象实体
        /// </summary>
        public CallCenterApi.Model.T_Bus_WorkOrder GetModelFromView(string F_WorkOrderId)
        {

            StringBuilder strSql = new StringBuilder();
            strSql.Append(@"select  top 1 [F_WorkOrderId]
      ,[F_RegDate]
      ,[F_UserCode]
      ,[F_InfoType]
      ,[F_RecFileUrl]
      ,[F_InfoConBigType]
      ,[F_InfoConSmallType]
      ,[F_WorkState]
      ,[F_ComContent]
      ,[F_InfoSource]
      ,[F_CusName]
      ,[F_CusSex]
      ,[F_CusPhone]
      ,[F_CusAddress]
      ,[F_ConName]
      ,[F_ConPhone]
      ,[F_ZipCode]
      ,[F_Email]
      ,[F_ComTitle]
      ,[F_IsProtect]
      ,[F_IsFile]
      ,[F_SourceArea]
      ,[F_SourceAddress]
      ,[F_Result],[F_WorkState]");
            strSql.Append(" from v_WorkOrder WITH(NOLOCK) ");
            strSql.Append(" where F_WorkOrderId=@F_WorkOrderId ");
            SqlParameter[] parameters = {
					new SqlParameter("@F_WorkOrderId", SqlDbType.NVarChar,20)};
            parameters[0].Value = F_WorkOrderId;

            CallCenterApi.Model.T_Bus_WorkOrder model = new CallCenterApi.Model.T_Bus_WorkOrder();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["F_WorkOrderId"] != null && ds.Tables[0].Rows[0]["F_WorkOrderId"].ToString() != "")
                {
                    model.F_WorkOrderId = ds.Tables[0].Rows[0]["F_WorkOrderId"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusName"] != null && ds.Tables[0].Rows[0]["F_CusName"].ToString() != "")
                {
                    model.F_CusName = ds.Tables[0].Rows[0]["F_CusName"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusSex"] != null && ds.Tables[0].Rows[0]["F_CusSex"].ToString() != "")
                {
                    model.F_CusSex = ds.Tables[0].Rows[0]["F_CusSex"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusPhone"] != null && ds.Tables[0].Rows[0]["F_CusPhone"].ToString() != "")
                {
                    model.F_CusPhone = ds.Tables[0].Rows[0]["F_CusPhone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_CusAddress"] != null && ds.Tables[0].Rows[0]["F_CusAddress"].ToString() != "")
                {
                    model.F_CusAddress = ds.Tables[0].Rows[0]["F_CusAddress"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ConName"] != null && ds.Tables[0].Rows[0]["F_ConName"].ToString() != "")
                {
                    model.F_ConName = ds.Tables[0].Rows[0]["F_ConName"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ConPhone"] != null && ds.Tables[0].Rows[0]["F_ConPhone"].ToString() != "")
                {
                    model.F_ConPhone = ds.Tables[0].Rows[0]["F_ConPhone"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ZipCode"] != null && ds.Tables[0].Rows[0]["F_ZipCode"].ToString() != "")
                {
                    model.F_ZipCode = ds.Tables[0].Rows[0]["F_ZipCode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_Email"] != null && ds.Tables[0].Rows[0]["F_Email"].ToString() != "")
                {
                    model.F_Email = ds.Tables[0].Rows[0]["F_Email"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ComTitle"] != null && ds.Tables[0].Rows[0]["F_ComTitle"].ToString() != "")
                {
                    model.F_ComTitle = ds.Tables[0].Rows[0]["F_ComTitle"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_ComContent"] != null && ds.Tables[0].Rows[0]["F_ComContent"].ToString() != "")
                {
                    model.F_ComContent = ds.Tables[0].Rows[0]["F_ComContent"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_IsProtect"] != null && ds.Tables[0].Rows[0]["F_IsProtect"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsProtect"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsProtect"].ToString().ToLower() == "true"))
                    {
                        model.F_IsProtect = true;
                    }
                    else
                    {
                        model.F_IsProtect = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_IsFile"] != null && ds.Tables[0].Rows[0]["F_IsFile"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["F_IsFile"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsFile"].ToString().ToLower() == "true"))
                    {
                        model.F_IsFile = true;
                    }
                    else
                    {
                        model.F_IsFile = false;
                    }
                }
                if (ds.Tables[0].Rows[0]["F_InfoSource"] != null && ds.Tables[0].Rows[0]["F_InfoSource"].ToString() != "")
                {
                    model.F_InfoSource = int.Parse(ds.Tables[0].Rows[0]["F_InfoSource"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_UserCode"] != null && ds.Tables[0].Rows[0]["F_UserCode"].ToString() != "")
                {
                    model.F_UserCode = ds.Tables[0].Rows[0]["F_UserCode"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_InfoType"] != null && ds.Tables[0].Rows[0]["F_InfoType"].ToString() != "")
                {
                    model.F_InfoType = int.Parse(ds.Tables[0].Rows[0]["F_InfoType"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_InfoConBigType"] != null && ds.Tables[0].Rows[0]["F_InfoConBigType"].ToString() != "")
                {
                    model.F_InfoConBigType = int.Parse(ds.Tables[0].Rows[0]["F_InfoConBigType"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_InfoConSmallType"] != null && ds.Tables[0].Rows[0]["F_InfoConSmallType"].ToString() != "")
                {
                    model.F_InfoConSmallType = int.Parse(ds.Tables[0].Rows[0]["F_InfoConSmallType"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_SourceArea"] != null && ds.Tables[0].Rows[0]["F_SourceArea"].ToString() != "")
                {
                    model.F_SourceArea = int.Parse(ds.Tables[0].Rows[0]["F_SourceArea"].ToString());
                }
                if (ds.Tables[0].Rows[0]["F_SourceAddress"] != null && ds.Tables[0].Rows[0]["F_SourceAddress"].ToString() != "")
                {
                    model.F_SourceAddress = ds.Tables[0].Rows[0]["F_SourceAddress"].ToString();
                }
                if (ds.Tables[0].Rows[0]["F_RegDate"] != null && ds.Tables[0].Rows[0]["F_RegDate"].ToString() != "")
                {
                    model.F_RegDate = DateTime.Parse(ds.Tables[0].Rows[0]["F_RegDate"].ToString());
                }
                //if (ds.Tables[0].Rows[0]["F_IsResult"] != null && ds.Tables[0].Rows[0]["F_IsResult"].ToString() != "")
                //{
                //    if ((ds.Tables[0].Rows[0]["F_IsResult"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsResult"].ToString().ToLower() == "true"))
                //    {
                //        model.F_IsResult = true;
                //    }
                //    else
                //    {
                //        model.F_IsResult = false;
                //    }
                //}
                if (ds.Tables[0].Rows[0]["F_Result"] != null && ds.Tables[0].Rows[0]["F_Result"].ToString() != "")
                {
                    model.F_Result = ds.Tables[0].Rows[0]["F_Result"].ToString();
                }
                //if (ds.Tables[0].Rows[0]["F_SubmitFlag"] != null && ds.Tables[0].Rows[0]["F_SubmitFlag"].ToString() != "")
                //{
                //    model.F_SubmitFlag = int.Parse(ds.Tables[0].Rows[0]["F_SubmitFlag"].ToString());
                //}
                //if (ds.Tables[0].Rows[0]["F_ProcessingFlag"] != null && ds.Tables[0].Rows[0]["F_ProcessingFlag"].ToString() != "")
                //{
                //    model.F_ProcessingFlag = int.Parse(ds.Tables[0].Rows[0]["F_ProcessingFlag"].ToString());
                //}
                if (ds.Tables[0].Rows[0]["F_WorkState"] != null && ds.Tables[0].Rows[0]["F_WorkState"].ToString() != "")
                {
                    model.F_WorkState = int.Parse(ds.Tables[0].Rows[0]["F_WorkState"].ToString());
                }
                //if (ds.Tables[0].Rows[0]["F_IsClosed"] != null && ds.Tables[0].Rows[0]["F_IsClosed"].ToString() != "")
                //{
                //    if ((ds.Tables[0].Rows[0]["F_IsClosed"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsClosed"].ToString().ToLower() == "true"))
                //    {
                //        model.F_IsClosed = true;
                //    }
                //    else
                //    {
                //        model.F_IsClosed = false;
                //    }
                //}
                //if (ds.Tables[0].Rows[0]["F_IsRead"] != null && ds.Tables[0].Rows[0]["F_IsRead"].ToString() != "")
                //{
                //    if ((ds.Tables[0].Rows[0]["F_IsRead"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsRead"].ToString().ToLower() == "true"))
                //    {
                //        model.F_IsRead = true;
                //    }
                //    else
                //    {
                //        model.F_IsRead = false;
                //    }
                //}
                //if (ds.Tables[0].Rows[0]["F_RemindWorkday"] != null && ds.Tables[0].Rows[0]["F_RemindWorkday"].ToString() != "")
                //{
                //    model.F_RemindWorkday = int.Parse(ds.Tables[0].Rows[0]["F_RemindWorkday"].ToString());
                //}
                //if (ds.Tables[0].Rows[0]["F_OverdueWorkday"] != null && ds.Tables[0].Rows[0]["F_OverdueWorkday"].ToString() != "")
                //{
                //    model.F_OverdueWorkday = int.Parse(ds.Tables[0].Rows[0]["F_OverdueWorkday"].ToString());
                //}
                //if (ds.Tables[0].Rows[0]["F_IsOverdue"] != null && ds.Tables[0].Rows[0]["F_IsOverdue"].ToString() != "")
                //{
                //    if ((ds.Tables[0].Rows[0]["F_IsOverdue"].ToString() == "1") || (ds.Tables[0].Rows[0]["F_IsOverdue"].ToString().ToLower() == "true"))
                //    {
                //        model.F_IsOverdue = true;
                //    }
                //    else
                //    {
                //        model.F_IsOverdue = false;
                //    }
                //}

                return model;
            }
            else
            {
                return null;
            }
        }

        /// <summary>
        /// 获得数据列表
        /// </summary>
        public DataSet GetList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select F_WorkOrderId,F_CusName,F_CusSex,F_CusPhone,F_CusAddress,F_ConName,F_ConPhone,F_ZipCode,F_Email,F_ComTitle,F_ComContent,F_IsProtect,F_IsFile,F_InfoSource,F_UserCode,F_InfoType,F_InfoConBigType,F_InfoConSmallType,F_SourceArea,F_SourceAddress,F_RegDate,F_IsResult,F_Result,F_SubmitFlag,F_ProcessingFlag,F_WorkState,F_IsClosed,F_IsRead,F_RemindWorkday,F_OverdueWorkday,F_IsOverdue,F_IsDelete,F_IsEnabled ");
            strSql.Append(" FROM T_Bus_WorkOrder WITH(NOLOCK) ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            return DbHelperSQL.Query(strSql.ToString());
        }

        /// <summary>
        /// 获得前几行数据
        /// </summary>
        public DataSet GetList(int Top, string strWhere, string filedOrder)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("select ");
            if (Top > 0)
            {
                strSql.Append(" top " + Top.ToString());
            }
            strSql.Append(" F_WorkOrderId,F_CusName,F_CusSex,F_CusPhone,F_CusAddress,F_ConName,F_ConPhone,F_ZipCode,F_Email,F_ComTitle,F_ComContent,F_IsProtect,F_IsFile,F_InfoSource,F_UserCode,F_InfoType,F_InfoConBigType,F_InfoConSmallType,F_SourceArea,F_SourceAddress,F_RegDate,F_IsResult,F_Result,F_SubmitFlag,F_ProcessingFlag,F_WorkState,F_IsClosed,F_IsRead,F_RemindWorkday,F_OverdueWorkday,F_IsOverdue,F_IsDelete,F_IsEnabled ");
            strSql.Append(" FROM T_Bus_WorkOrder WITH(NOLOCK) ");
            if (strWhere.Trim() != "")
            {
                strSql.Append(" where " + strWhere);
            }
            strSql.Append(" order by " + filedOrder);
            return DbHelperSQL.Query(strSql.ToString());
        }

        /*
        /// <summary>
        /// 分页获取数据列表
        /// </summary>
        public DataSet GetList(int PageSize,int PageIndex,string strWhere)
        {
            SqlParameter[] parameters = {
                    new SqlParameter("@tblName", SqlDbType.VarChar, 255),
                    new SqlParameter("@fldName", SqlDbType.VarChar, 255),
                    new SqlParameter("@PageSize", SqlDbType.Int),
                    new SqlParameter("@PageIndex", SqlDbType.Int),
                    new SqlParameter("@IsReCount", SqlDbType.Bit),
                    new SqlParameter("@OrderType", SqlDbType.Bit),
                    new SqlParameter("@strWhere", SqlDbType.VarChar,1000),
                    };
            parameters[0].Value = "T_Bus_WorkOrder";
            parameters[1].Value = "F_WorkOrderId";
            parameters[2].Value = PageSize;
            parameters[3].Value = PageIndex;
            parameters[4].Value = 0;
            parameters[5].Value = 0;
            parameters[6].Value = strWhere;	
            return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds");
        }*/


        /// <summary>
        /// 根据坐席号获取新的工单号
        /// </summary>
        /// <param name="p_UserCode"></param>
        /// <returns></returns>
        public string GetNewWorkOrderID(string p_UserCode)
        {

            string newWorkOrderID = string.Empty;//新工单号
            string oldWorkOrderID = string.Empty;
            string headPart = DateTime.Now.ToString("yyyyMMdd");//工单号前8位
            string middlePart = string.Empty;//工单号中间部分
            string endPart = "001";//工单号最后部分，如果超过初始位数，自动从头开始           
            StringBuilder strSql = new StringBuilder();
            object p_Result = null;
            //如果是网站
            if (string.IsNullOrEmpty(p_UserCode.Trim()))
            {
                middlePart = "00";
                strSql.Append("select top 1 F_WorkOrderId from T_Bus_WorkOrder WITH(NOLOCK)");
                //strSql.Append(" where F_UserCode is null or F_UserCode=''  order by F_RegDate desc");
                strSql.AppendFormat(" where F_WorkOrderId like '{0}%' order by F_WorkOrderId desc", headPart + middlePart);
                p_Result = DbHelperSQL.GetSingle(strSql.ToString());
            }
            else
            {
                middlePart = p_UserCode;
                strSql.Append("select top 1 F_WorkOrderId from T_Bus_WorkOrder WITH(NOLOCK)");
                //strSql.Append(" where  F_UserCode=@F_UserCode  order by F_RegDate desc");
                strSql.AppendFormat(" where  F_WorkOrderId like '{0}%'  order by F_WorkOrderId desc", headPart + middlePart);
                SqlParameter[] parameters = {
					new SqlParameter("@F_UserCode", SqlDbType.NVarChar,20)};
                parameters[0].Value = p_UserCode;
                p_Result = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            }


            if (p_Result != null)
            {

                oldWorkOrderID = p_Result.ToString();
                if (oldWorkOrderID.Length > 8)
                {
                    string oldHead = oldWorkOrderID.Substring(0, 8);
                    string oldEnd = oldWorkOrderID.Substring(oldWorkOrderID.Length - endPart.Length);
                    int num = Convert.ToInt32(oldEnd) + 1;
                    string newCode = string.Empty;
                    for (int i = num.ToString().Length; i < endPart.Length; i++)
                    {
                        newCode += "0";
                    }
                    endPart = newCode + num;
                }

            }
            newWorkOrderID = headPart + middlePart + endPart;

            return newWorkOrderID;
        }
        #endregion  Method
        #region addMethod
        #region 获取催办信息
        public DataTable getViewData(string WorkOrderId)
        {
            DataTable dt = null;
            string sqlStr = "select * from v_WorkOrderRemind WITH(NOLOCK) where F_WorkOrderId='" + WorkOrderId + "'";
            dt = DbHelperSQL.Query(sqlStr).Tables[0];
            return dt;
        }
        #endregion
        #region 获取交办信息
        public DataTable getAssigned(string WorkOrderId)
        {
            DataTable dt = new DataTable();
            string sqlstr = "select * from View_workOrderAssigned WITH(NOLOCK) where F_WorkOrderId='" + WorkOrderId + "' order by View_workOrderAssigned.F_AssignedId desc";
            dt = DbHelperSQL.Query(sqlstr).Tables[0];
            return dt;
        }
        #endregion
        #endregion


        /// <summary>
        /// 获取逾期的工单
        /// </summary>
        /// <param name="regDate"></param>
        /// <returns></returns>
        public DataTable getOverDueWorkOrder(string regDate,string DeptId)
        {
            string sql = string.Format("select * from T_Bus_WorkOrder WITH(NOLOCK) where F_WorkOrderId in (select F_WorkOrderId  from T_Bus_AssignedInfo WITH(NOLOCK) where DATEDIFF(d,F_SubmitDate,'{0}')>0 and F_DeptId={1} and (F_ResultState=0 or F_ResultState is null)) and F_WorkState=21", regDate, DeptId);
            return DbHelperSQL.Query(sql).Tables[0];
        }
        /// <summary>
        /// 获取逾期的工单
        /// </summary>
        /// <param name="regDate"></param>
        /// <returns></returns>
        public DataTable getOverDueWorkOrder(string regDate)
        {
            string sql = string.Format("select * from T_Bus_WorkOrder WITH(NOLOCK) where F_WorkOrderId in (select F_WorkOrderId  from T_Bus_AssignedInfo WITH(NOLOCK) where DATEDIFF(d,F_SubmitDate,'{0}')>0 ) and F_WorkState=21", regDate);
            return DbHelperSQL.Query(sql).Tables[0];
        }

    }
}