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