Esempio n. 1
0
        /// <summary>
        /// 获取用户的信息(E_User表)
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetUsers(object obj)
        {
            ArrayList arr  = JSON.getPara(obj);
            DataTable dt   = dAL_LevelSetDts.GetUsers(ValueHandler.GetStringValue(arr[0]));
            string    json = JSON.DataTableToTreeList(dt);

            return(json);
        }
Esempio n. 2
0
        public string GetNOVaildData(object obj)
        {
            ArrayList arr  = JSON.getPara(obj);
            DataTable dt   = dAL_OriginalData.GetNOVaildData(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), ValueHandler.GetStringValue(arr[2]));
            string    json = JSON.DataTableToArrayList(dt);

            return(json);
        }
Esempio n. 3
0
        /// <summary>
        /// 得到原数据数量
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetOriginalDataCount(object obj)
        {
            ArrayList arr = JSON.getPara(obj);

            return(dAL_OriginalData.GetOriginalDataCount(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]),
                                                         ValueHandler.GetStringValue(arr[2]), ValueHandler.GetStringValue(arr[3]),
                                                         ValueHandler.GetStringValue(arr[4])));
        }
Esempio n. 4
0
        /// <summary>
        /// 获取修改记录
        /// </summary>
        /// <param name="obj"></param>
        public string GetBillHistoryInfo(object obj)
        {
            ArrayList arr  = JSON.getPara(obj);
            DataTable dt   = dAL_BillHistory.GetBillHistoryInfo(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetIntNumberValue(arr[1]), ValueHandler.GetIntNumberValue(arr[2]));
            string    json = JSON.DataTableToArrayList(dt);

            return(json);
        }
Esempio n. 5
0
        /// <summary>
        /// 得到数据
        /// </summary>
        public string GetCXT_Customer(CXT_Customer Model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("Cust_Name = '" + ValueHandler.GetStringValue(Model.Cust_Name) + "', ");

            strSql.Append("Cust_OldName = '" + ValueHandler.GetStringValue(Model.Cust_OldName) + "', ");

            strSql.Append("Cust_NameKey = '" + ValueHandler.GetStringValue(Model.Cust_NameKey) + "', ");

            strSql.Append("Cust_Phone = '" + ValueHandler.GetStringValue(Model.Cust_Phone) + "', ");

            strSql.Append("Cust_Linkman = '" + ValueHandler.GetStringValue(Model.Cust_Linkman) + "', ");

            strSql.Append("Cust_LinkPhone = '" + ValueHandler.GetStringValue(Model.Cust_LinkPhone) + "', ");

            strSql.Append("Cust_ProvinceCode = '" + ValueHandler.GetStringValue(Model.Cust_ProvinceCode) + "', ");

            strSql.Append("Cust_ProvinceName = '" + ValueHandler.GetStringValue(Model.Cust_ProvinceName) + "', ");

            strSql.Append("Cust_CityCode = '" + ValueHandler.GetStringValue(Model.Cust_CityCode) + "', ");

            strSql.Append("Cust_CityName = '" + ValueHandler.GetStringValue(Model.Cust_CityName) + "', ");

            strSql.Append("Cust_CountyCode = '" + ValueHandler.GetStringValue(Model.Cust_CountyCode) + "', ");

            strSql.Append("Cust_CountyName = '" + ValueHandler.GetStringValue(Model.Cust_CountyName) + "', ");

            strSql.Append("Cust_Address = '" + ValueHandler.GetStringValue(Model.Cust_Address) + "', ");

            strSql.Append("Cust_IsBill = '" + ValueHandler.GetStringValue(Model.Cust_IsBill) + "', ");

            strSql.Append("Cust_BillMoney = " + ValueHandler.GetIntNumberValue(Model.Cust_BillMoney) + ", ");

            strSql.Append("Cust_BillNumber = '" + ValueHandler.GetStringValue(Model.Cust_BillNumber) + "', ");

            strSql.Append("Cust_Nature = '" + ValueHandler.GetStringValue(Model.Cust_Nature) + "', ");

            strSql.Append("Cust_KFVoice = '" + ValueHandler.GetStringValue(Model.Cust_KFVoice) + "', ");

            strSql.Append("Cust_Source = '" + ValueHandler.GetStringValue(Model.Cust_Source) + "', ");

            strSql.Append("Cust_OpenDate = " + ValueHandler.GetMarkStringDateValue(Model.Cust_OpenDate) + ", ");

            strSql.Append("Cust_WH_Remark = '" + ValueHandler.GetStringValue(Model.Cust_WH_Remark) + "', ");

            strSql.Append("Cust_WH_UserName = '******', ");

            strSql.Append("Cust_State = '" + ValueHandler.GetStringValue(Model.Cust_State) + "', ");

            string NowTime = DateTime.Now.ToString();

            strSql.Append("Cust_OperateTime = '" + NowTime + "', ");

            strSql.Append("Cust_IsView = " + ValueHandler.GetIntNumberValue(Model.Cust_IsView) + "");

            return(strSql.ToString());
        }
Esempio n. 6
0
        /// <summary>
        /// 查询总数
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetNum(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_CustomerReturns.GetNum(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), ValueHandler.GetStringValue(arr[2]), ValueHandler.GetStringValue(arr[3]), ValueHandler.GetStringValue(arr[4]),
                                                       ValueHandler.GetStringValue(arr[5]), ValueHandler.GetStringValue(arr[6]), ValueHandler.GetStringValue(arr[7]), ValueHandler.GetStringValue(arr[8]), ValueHandler.GetStringValue(arr[9]),
                                                       ValueHandler.GetStringValue(arr[10]), ValueHandler.GetStringValue(arr[11]), ValueHandler.GetStringValue(arr[12]), ValueHandler.GetStringValue(arr[13]), ValueHandler.GetStringValue(arr[14]), ValueHandler.GetStringValue(arr[17]), GetPlace());

            return(dt.Rows[0]["num"].ToString());
        }
Esempio n. 7
0
        /// <summary>
        /// 查询总数
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetCustomerCount(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            string    dt  = dAL_AllQuery.GetCustomerCount(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), ValueHandler.GetStringValue(arr[2]), ValueHandler.GetStringValue(arr[3]), ValueHandler.GetStringValue(arr[4]),
                                                          ValueHandler.GetStringValue(arr[5]), ValueHandler.GetStringValue(arr[6]), ValueHandler.GetStringValue(arr[7]), ValueHandler.GetStringValue(arr[8]), ValueHandler.GetStringValue(arr[9]),
                                                          ValueHandler.GetStringValue(arr[10]), ValueHandler.GetStringValue(arr[11]), ValueHandler.GetStringValue(arr[12]), ValueHandler.GetStringValue(arr[13]), ValueHandler.GetStringValue(arr[14]));

            return(dt);
        }
Esempio n. 8
0
        //public string PlImportChargeData(object obj)
        //{
        //    ArrayList arr = JSON.getPara(obj);
        //    bool flag = dAL_CallCenter.PlImportChargeData(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), ValueHandler.GetStringValue(arr[2])
        //                ,BLL_User.User_Code);

        //    if (flag)
        //        return "true";
        //    return "false";
        //}

        #endregion

        /// <summary>
        /// 根据条件获取历史计费列表
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetSSBDealChargeData(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_CallCenter.GetSSBDealChargeData(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), ValueHandler.GetStringValue(arr[2])
                                                                , ValueHandler.GetStringValue(arr[3]), ValueHandler.GetStringValue(arr[4]), ValueHandler.GetStringValue(arr[5]));
            string json = JSON.DataTableToArrayList(dt);

            return(json);
        }
Esempio n. 9
0
        /// <summary>
        /// 获取资讯信息
        /// </summary>
        /// <param name="Pub_LS_Code1">移动端Code</param>
        /// <param name="Pub_LS_Code2">平台名称Code</param>
        /// <param name="Pub_LS_Code3">信息大类Code</param>
        /// <param name="Pub_Title">标题</param>
        /// <param name="Pub_Code">Code</param>
        /// <param name="Pub_LS_Code4">4级节点(信息小类)</param>
        /// <param name="Pub_SA_Code1">省</param>
        /// <param name="Pub_SA_Code2">市</param>
        /// <param name="Pub_SA_Code3">区</param>
        /// <param name="BeginTime">开始时间</param>
        /// <param name="EndTime">结束时间</param>
        /// <param name="PageIndex">当前页码</param>
        /// <param name="PageNum">每页显示数据量</param>
        /// <returns>资讯信息DataTable</returns>
        public DataTable GetPublicInfo(string Pub_LS_Code1, string Pub_LS_Code2, string Pub_LS_Code3, string Pub_Title, string Pub_Code, string Pub_LS_Code4, string Pub_SA_Code1, string Pub_SA_Code2, string Pub_SA_Code3, string BeginTime, string EndTime, string PageIndex, string PageNum)
        {
            StringBuilder sql = new StringBuilder();

            if (ValueHandler.GetStringValue(Pub_Code) != "")
            {
                sql.AppendFormat("SELECT Pub_Code,Pub_LS_Code1,Pub_LS_Code2,Pub_LS_Code3,Pub_LS_Code4,Pub_Title,Pub_ArticleSource,Pub_Pic,Pub_DisplayMode,Pub_Content  FROM dbo.XXSD_PublicInfo WHERE Pub_Code='{0}'", Pub_Code);
            }
            else
            {
                sql.AppendFormat("SELECT TOP {0} Pub_Code,Pub_Title,LS_Name1,LS_Name2,Pub_KeyWords,JoinDate,JoinMan FROM(", ValueHandler.GetIntNumberValue(PageNum));
                sql.Append("SELECT P.Pub_Code,P.Pub_Title,L1.LS_Name AS 'LS_Name1',L2.LS_Name AS 'LS_Name2',P.Pub_KeyWords,P.JoinDate,P.JoinMan,ROW_NUMBER() OVER (ORDER BY P.JoinDate DESC) AS 'Num' FROM XXSD_PublicInfo P LEFT JOIN XXSD_LevelSet L1 ON P.Pub_LS_Code3=L1.LS_Code LEFT JOIN XXSD_LevelSet L2 ON P.Pub_LS_Code4=L2.LS_Code WHERE 1=1");
                if (ValueHandler.GetStringValue(Pub_LS_Code1) != "")
                {
                    sql.AppendFormat(" AND P.Pub_LS_Code1 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code1));
                }
                if (ValueHandler.GetStringValue(Pub_LS_Code2) != "")
                {
                    sql.AppendFormat(" AND P.Pub_LS_Code2 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code2));
                }
                if (ValueHandler.GetStringValue(Pub_LS_Code3) != "")
                {
                    sql.AppendFormat(" AND P.Pub_LS_Code3 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code3));
                }
                if (ValueHandler.GetStringValue(Pub_LS_Code4) != "")
                {
                    sql.AppendFormat(" AND P.Pub_LS_Code4 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code4));
                }
                if (ValueHandler.GetStringValue(Pub_SA_Code1) != "")
                {
                    sql.AppendFormat(" AND P.Pub_SA_Code1 = '{0}'", ValueHandler.GetStringValue(Pub_SA_Code1));
                }
                if (ValueHandler.GetStringValue(Pub_SA_Code2) != "")
                {
                    sql.AppendFormat(" AND P.Pub_SA_Code2 = '{0}'", ValueHandler.GetStringValue(Pub_SA_Code2));
                }
                if (ValueHandler.GetStringValue(Pub_SA_Code3) != "")
                {
                    sql.AppendFormat(" AND P.Pub_SA_Code3 = '{0}'", ValueHandler.GetStringValue(Pub_SA_Code3));
                }
                if (ValueHandler.GetStringValue(Pub_Title) != "")
                {
                    sql.AppendFormat(" AND P.Pub_Title LIKE '%{0}%'", ValueHandler.GetStringValue(Pub_Title));
                }
                if (ValueHandler.GetMarkStringDateValue(BeginTime) != "" && ValueHandler.GetMarkStringDateValue(BeginTime) != "null" && ValueHandler.GetMarkStringDateValue(BeginTime) != null)
                {
                    sql.AppendFormat(" AND P.JoinDate >= '{0}'", ValueHandler.GetStringValue(BeginTime));
                }
                if (ValueHandler.GetMarkStringDateValue(EndTime) != "" && ValueHandler.GetMarkStringDateValue(EndTime) != "null" && ValueHandler.GetMarkStringDateValue(EndTime) != null)
                {
                    sql.AppendFormat(" AND P.JoinDate <= '{0}'", ValueHandler.GetStringValue(EndTime));
                }
                sql.AppendFormat(") T WHERE T.Num >(0+({0}-1)*{1})", ValueHandler.GetIntNumberValue(PageIndex), ValueHandler.GetIntNumberValue(PageNum));
            }
            return(SearchData(sql.ToString()));
        }
Esempio n. 10
0
        /// <summary>
        /// 获取用户角色权限
        /// </summary>
        public string GetUserModule(object obj)
        {
            ArrayList arr    = JSON.getPara(obj);
            DataTable dtTemp = dAL_UserSetDts.GetUserModule(ValueHandler.GetStringValue(arr[0]));
            DataTable dt     = dtTemp.Copy();

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                //取当前模块的按钮集合
                DataTable dt1     = new SqlBase().SearchData("SELECT SM_FunIDs FROM dbo.AF_SysModule WHERE SM_Code = '" + ValueHandler.GetStringValue(dt.Rows[i]["UP_SM_Code"]) + "'");
                string    strFuns = ValueHandler.GetStringValue(dt1.Rows[0]["SM_FunIDs"]);

                if (ValueHandler.GetStringValue(dt.Rows[i]["UP_SM_FunIDs"]) != "" || (ValueHandler.GetStringValue(dt.Rows[i]["UP_SM_FunIDs"]) == "" && strFuns != ""))
                {
                    if (ValueHandler.GetStringValue(dt.Rows[i]["UP_SM_FunIDs"]) != "")
                    {
                        string[] strArr = ValueHandler.GetStringValue(dt.Rows[i]["UP_SM_FunIDs"]).Split(',');
                        for (int j = 0; j < strArr.Length; j++)
                        {
                            //从原模块按钮中替换掉未选择的按钮Code
                            strFuns = strFuns.Replace(ValueHandler.GetStringValue(strArr[j]), "");
                            //第一个按钮被替换
                            if (strFuns != "")
                            {
                                if (strFuns.Substring(0, 1) == ",")
                                {
                                    strFuns = strFuns.Substring(1, strFuns.Length - 1);
                                }
                            }
                            //中间替换时会产生2个逗号
                            strFuns = strFuns.Replace(",,", ",");
                            //最后一个按钮被替换
                            if (strFuns != "")
                            {
                                if (strFuns.Substring(strFuns.Length - 1, 1) == ",")
                                {
                                    strFuns = strFuns.Substring(0, strFuns.Length - 1);
                                }
                            }
                        }
                    }
                    string[] ArrFuns = strFuns.Split(',');
                    for (int k = 0; k < ArrFuns.Length; k++)
                    {
                        DataRow dr = dt.NewRow();
                        dr["UP_SM_FunIDs"] = ArrFuns[k];
                        dr["UP_SM_Code"]   = ValueHandler.GetStringValue(dt.Rows[i]["UP_SM_Code"]) + "|" + ArrFuns[k];
                        dr["SM_Type"]      = "1";
                        dtTemp.Rows.Add(dr.ItemArray);
                    }
                }
            }
            String json = JSON.DataTableToTreeList(dtTemp);

            return(json);
        }
Esempio n. 11
0
        /// <summary>
        /// 获取资讯信息数量
        /// </summary>
        /// <param name="Pub_LS_Code1">移动端Code</param>
        /// <param name="Pub_LS_Code2">平台名称Code</param>
        /// <param name="Pub_LS_Code3">信息大类Code</param>
        /// <param name="Pub_Title">标题</param>
        /// <param name="Pub_Code">Code</param>
        /// <param name="Pub_LS_Code4">4级节点(信息小类)</param>
        /// <param name="Pub_SA_Code1">省</param>
        /// <param name="Pub_SA_Code2">市</param>
        /// <param name="Pub_SA_Code3">区</param>
        /// <param name="BeginTime">开始时间</param>
        /// <param name="EndTime">结束时间</param>
        /// <param name="PageIndex">当前页码</param>
        /// <param name="PageNum">每页显示数据量</param>
        /// <returns>数据量</returns>
        public string GetDataCount(string Pub_LS_Code1, string Pub_LS_Code2, string Pub_LS_Code3, string Pub_Title, string Pub_Code, string Pub_LS_Code4, string Pub_SA_Code1, string Pub_SA_Code2, string Pub_SA_Code3, string BeginTime, string EndTime, string PageIndex, string PageNum)
        {
            StringBuilder sql = new StringBuilder();

            sql.Append("SELECT COUNT(Pub_Code) AS 'DataCount' FROM XXSD_PublicInfo P LEFT JOIN XXSD_LevelSet L1 ON P.Pub_LS_Code3=L1.LS_Code LEFT JOIN XXSD_LevelSet L2 ON P.Pub_LS_Code4=L2.LS_Code WHERE 1=1");
            if (ValueHandler.GetStringValue(Pub_LS_Code1) != "")
            {
                sql.AppendFormat(" AND P.Pub_LS_Code1 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code1));
            }
            if (ValueHandler.GetStringValue(Pub_LS_Code2) != "")
            {
                sql.AppendFormat(" AND P.Pub_LS_Code2 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code2));
            }
            if (ValueHandler.GetStringValue(Pub_LS_Code3) != "")
            {
                sql.AppendFormat(" AND P.Pub_LS_Code3 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code3));
            }
            if (ValueHandler.GetStringValue(Pub_LS_Code4) != "")
            {
                sql.AppendFormat(" AND P.Pub_LS_Code4 = '{0}'", ValueHandler.GetStringValue(Pub_LS_Code4));
            }
            if (ValueHandler.GetStringValue(Pub_SA_Code1) != "")
            {
                sql.AppendFormat(" AND P.Pub_SA_Code1 = '{0}'", ValueHandler.GetStringValue(Pub_SA_Code1));
            }
            if (ValueHandler.GetStringValue(Pub_SA_Code2) != "")
            {
                sql.AppendFormat(" AND P.Pub_SA_Code2 = '{0}'", ValueHandler.GetStringValue(Pub_SA_Code2));
            }
            if (ValueHandler.GetStringValue(Pub_SA_Code3) != "")
            {
                sql.AppendFormat(" AND P.Pub_SA_Code3 = '{0}'", ValueHandler.GetStringValue(Pub_SA_Code3));
            }
            if (ValueHandler.GetStringValue(Pub_Title) != "")
            {
                sql.AppendFormat(" AND P.Pub_Title LIKE '%{0}%'", ValueHandler.GetStringValue(Pub_Title));
            }
            if (ValueHandler.GetMarkStringDateValue(BeginTime) != "" && ValueHandler.GetMarkStringDateValue(BeginTime) != "null" && ValueHandler.GetMarkStringDateValue(BeginTime) != null)
            {
                sql.AppendFormat(" AND P.JoinDate >= '{0}'", ValueHandler.GetStringValue(BeginTime));
            }
            if (ValueHandler.GetMarkStringDateValue(EndTime) != "" && ValueHandler.GetMarkStringDateValue(EndTime) != "null" && ValueHandler.GetMarkStringDateValue(EndTime) != null)
            {
                sql.AppendFormat(" AND P.JoinDate <= '{0}'", ValueHandler.GetStringValue(EndTime));
            }
            DataTable dt = SearchData(sql.ToString());

            if (dt.Rows.Count > 0)
            {
                return(dt.Rows[0]["DataCount"].ToString());
            }
            else
            {
                return("0");
            }
        }
Esempio n. 12
0
        /// <summary>
        /// 验证是否开户
        /// </summary>
        /// <param name="billno"></param>
        /// <returns></returns>
        public DataTable GetXFBCustomerListByBillNumber(string billno)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append($@"SELECT Cust_Code
                        FROM dbo.XFB_Customer
                        WHERE Cust_BillNumber = '{ ValueHandler.GetStringValue(billno)}'");

            return(SearchData(sb.ToString()));
        }
Esempio n. 13
0
        /// <summary>
        /// 筛选
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GeneralXFBDatas(object obj)
        {
            ArrayList arr = JSON.getPara(obj);

            if (dAL_OriginalDataDts.GeneralXFBDatas(ValueHandler.GetStringValue(arr[0]), BLL_User.User_Name))
            {
                return("true");
            }
            return("false");
        }
Esempio n. 14
0
        /// <summary>
        /// 标记为已使用
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string MarkWQTAlreadyUse(object obj)
        {
            ArrayList arr = JSON.getPara(obj);

            if (dAL_OriginalData.MarkWQTAlreadyUse(ValueHandler.GetStringValue(arr[0])))
            {
                return("true");
            }
            return("false");
        }
Esempio n. 15
0
        /// <summary>
        /// 查询数据
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetUser(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_UserSetDts.GetUser(ValueHandler.GetStringValue(arr[0]));

            dt.Rows[0]["User_Password"] = Security.DecryptDES(dt.Rows[0]["User_Password"].ToString());
            string json = JSON.DataTableToTreeList(dt);

            return(json);
        }
Esempio n. 16
0
        /// <summary>
        /// 获取号段信息
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetNoMangerInfo(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_NoManager.GetNoMangerInfo(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]),
                                                          ValueHandler.GetStringValue(arr[2]), ValueHandler.GetStringValue(arr[3]),
                                                          ValueHandler.GetIntNumberValue(arr[4]), ValueHandler.GetIntNumberValue(arr[5]));
            string json = JSON.DataTableToArrayList(dt);

            return(json);
        }
Esempio n. 17
0
        /// <summary>
        /// 删除原始数据
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string DeleteWQTDatas(object obj)
        {
            ArrayList arr = JSON.getPara(obj);

            if (dAL_OriginalData.DeleteWQTDatas(ValueHandler.GetStringValue(arr[0])))
            {
                return("true");
            }
            return("false");
        }
Esempio n. 18
0
        /// <summary>
        /// 保存密码
        /// </summary>
        /// <param name="e_User"></param>
        /// <returns></returns>
        public bool SavePass(string userCode, string password)
        {
            StringBuilder sb = new StringBuilder();

            sb.Append("\r IF EXISTS(SELECT User_Code FROM AF_User WHERE User_Code = '" + ValueHandler.GetStringValue(userCode) + "')");
            sb.Append("\r BEGIN ");
            sb.Append("UPDATE AF_User SET User_PassWord = '******'");
            sb.Append(" WHERE User_Code ='" + ValueHandler.GetStringValue(userCode) + "'");
            sb.Append("\r END");
            return(UpdateData(sb.ToString()));
        }
Esempio n. 19
0
        /// <summary>
        /// 查询列表
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string GetCust(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_CustomerReturns.GetCust(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), ValueHandler.GetStringValue(arr[2]), ValueHandler.GetStringValue(arr[3]), ValueHandler.GetStringValue(arr[4]),
                                                        ValueHandler.GetStringValue(arr[5]), ValueHandler.GetStringValue(arr[6]), ValueHandler.GetStringValue(arr[7]), ValueHandler.GetStringValue(arr[8]), ValueHandler.GetStringValue(arr[9]),
                                                        ValueHandler.GetStringValue(arr[10]), ValueHandler.GetStringValue(arr[11]), ValueHandler.GetStringValue(arr[12]), ValueHandler.GetStringValue(arr[13]), ValueHandler.GetStringValue(arr[14]),
                                                        ValueHandler.GetStringValue(arr[15]), ValueHandler.GetStringValue(arr[16]), ValueHandler.GetStringValue(arr[17]), GetPlace());
            string json = JSON.DataTableToArrayList(dt);

            return(json);
        }
Esempio n. 20
0
        /// <summary>
        /// 得到旧密码
        /// </summary>
        /// <returns></returns>
        public string GetPass(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_UpdatePass.GetPass(ValueHandler.GetStringValue(BLL_User.User_Code));

            if (dt.Rows[0][0].ToString() == Security.EncryptDES(arr[0].ToString()))
            {
                return("true");
            }
            return("false");
        }
Esempio n. 21
0
        /// <summary>
        /// 增加 修改 一条数据
        /// </summary>
        public string UpdateCodeType(object obj)
        {
            ArrayList arr  = JSON.getPara(obj);
            bool      flag = dAL_CodeType.UpdateType(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]), BLL_User.User_Name);

            if (flag)
            {
                return("true");
            }
            return("false");
        }
Esempio n. 22
0
        /// <summary>
        /// 是否是黑名单号码
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string IsBlackPhone(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_BlackList.IsBlackPhone(ValueHandler.GetStringValue(arr[0]));

            if (dt != null && dt.Rows.Count > 0)
            {
                return("true");
            }
            return("false");
        }
Esempio n. 23
0
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string DelBlackList(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            bool      dt  = dAL_BlackList.DelBlackList(ValueHandler.GetStringValue(arr[0]));

            if (dt)
            {
                return("true");
            }
            return("false");
        }
Esempio n. 24
0
        public string PlInsertBlackPhone(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            bool      dt  = dAL_BlackListDts.PlInsertBlackPhone(ValueHandler.GetStringValue(arr[0]), BLL_User.User_Name, arr[1].ToString());

            if (dt)
            {
                return("true");
            }
            return("false");
        }
Esempio n. 25
0
        public string InvalidData(object obj)
        {
            ArrayList arr  = JSON.getPara(obj);
            bool      flag = dAL_OriginalData.InvalidData(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]));

            if (flag)
            {
                return("true");
            }
            return("false");
        }
Esempio n. 26
0
        public DataTable GetSSBCustomerListByBillNumber(string billno, string code)
        {
            StringBuilder sb     = new StringBuilder();
            string        sWhere = !string.IsNullOrEmpty(code) ? string.Format(" where Cust_Code !='{0}'", code) : "";

            sb.Append($@"select * from (SELECT Cust_Code
                        FROM dbo.SSB_Customer
                        WHERE Cust_BillNumber = '{ ValueHandler.GetStringValue(billno)}')t {sWhere}");

            return(SearchData(sb.ToString()));
        }
Esempio n. 27
0
        /// <summary>
        /// 修改原始数据地区、计费信息
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string UpdateDatas(object obj)
        {
            ArrayList arr = JSON.getPara(obj);

            if (dAL_OriginalData.UpdateDatas(ValueHandler.GetStringValue(arr[0]), ValueHandler.GetStringValue(arr[1]),
                                             ValueHandler.GetStringValue(arr[2]), ValueHandler.GetStringValue(arr[3])))
            {
                return("true");
            }
            return("false");
        }
Esempio n. 28
0
        /// <summary>
        /// 诚信通客服异常退回
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string BackCXTCustomer(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            bool      dt  = dAL_CustomerReturns.BackCXTCustomer(ValueHandler.GetStringValue(arr[0]));

            if (dt)
            {
                return("true");
            }
            return("false");
        }
Esempio n. 29
0
        /// <summary>
        /// 获取按钮权限
        /// </summary>
        /// <param name="obj">用户ID</param>
        /// <returns></returns>
        public string GetMenuRight(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            DataTable dt  = dAL_Pub.GetMenuRight(BLL_User.User_Code, ValueHandler.GetStringValue(arr[0]));

            if (dt.Rows.Count > 0)
            {
                return(ValueHandler.GetStringValue(dt.Rows[0]["UP_SM_FunIDs"]));
            }
            return("");
        }
Esempio n. 30
0
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="obj"></param>
        /// <returns></returns>
        public string DelKeyManager(object obj)
        {
            ArrayList arr = JSON.getPara(obj);
            bool      dt  = dAL_KeyWord.DelKeyManager(ValueHandler.GetStringValue(arr[0]));

            if (dt)
            {
                return("true");
            }
            return("false");
        }