/// <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); }
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); }
/// <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]))); }
/// <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); }
/// <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()); }
/// <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()); }
/// <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); }
//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); }
/// <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())); }
/// <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); }
/// <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"); } }
/// <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())); }
/// <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"); }
/// <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"); }
/// <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); }
/// <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); }
/// <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"); }
/// <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())); }
/// <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); }
/// <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"); }
/// <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"); }
/// <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"); }
/// <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"); }
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"); }
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"); }
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())); }
/// <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"); }
/// <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"); }
/// <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(""); }
/// <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"); }