/// <summary>
/// 获知支付配置信息
/// </summary>
/// <param name="payType">支付方式</param>
/// <param name="entId">企业id</param>
/// <returns></returns>
public List <PayApi> GetPayInfo(string payType, string entId)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select payid,AppId,Merchants,AppKey,AppSecert,SSlCertPath,SSlCertPassword,NotifyUrl,RefundUrl,Ip,ProxyUrl,ReportLevel,LogLevel,PayType,Beactive,Web_Url,EntId,Sort_Id from dt_payapi (NOLOCK) ");
strSql.Append(" where Beactive='Y' and Entid=@Entid");
if (payType != "全部")
{
strSql.Append(" and PayType='" + payType + "'");
}
strSql.Append(" order by Sort_Id asc ");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Entid", entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <PayApi> PList = new List <PayApi>();
if (dt.Rows.Count > 0)
{
PList = SetPayInfo(dt);
}
return(PList);
}
public JsonResult AppUpdateEdition()
{
try
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
StringBuilder strsql = new StringBuilder();
strsql.Append(" select top 1 VersionNo,UpdateDescription,ForceUpdate,DownloadAddress,VersionName from Zzsk_AppUpdate order by UpdateTime desc");
DataTable data = sql.RunSqlDataTable(strsql.ToString());
if (data.Rows.Count != 1)
{
throw new Exception("系统后台未配置！请暂停自动更新！");
}
string web_url = BaseConfiguration.SercerIp;
return(Json(new
{
success = true,
obj = new AppUpdate(
decimal.Parse(data.Rows[0]["VersionNo"].ToString()),
int.Parse(data.Rows[0]["ForceUpdate"].ToString()),
data.Rows[0]["UpdateDescription"].ToString(),
web_url + data.Rows[0]["DownloadAddress"].ToString(),
data.Rows[0]["VersionName"].ToString()
)
}
));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Img/AppUpdateEdition", ex.Message.ToString());
return(Json(new { success = false, message = "系统后台未配置！请暂停自动更新！" }));
}
}
/// <summary>
/// 商城首页图片获取
/// </summary>
/// <param name="Num"></param>
/// <param name="ImgType"></param>
/// <param name="source">pc/app</param>
/// <returns></returns>
public List <ImgInfo> GetImgInfo(int num, string imgType, string entId, string source, string singular)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select ");
if (num != 0)
{
strSql.Append("top " + num + "");
}
if (singular == "")
{
strSql.Append("ID,Sort_id,title,isnull(img_url,'') as img_url,isnull(link_url,'') as link_url,ImgType,article_id,beizhu,entid,isnull(androidlinkurl,'') as androidlinkurl,androidlinktype,TypeName from (select row_number() over(partition by a.ImgType, a.imgTypeS order by add_time desc) as bh, a.ID, a.Sort_id, a.title, a.img_url, a.link_url, a.ImgType, a.imgTypeS, a.ArticleID as article_id, a.status, a.link_name, a.xh, a.beizhu, a.entid, a.source, a.add_time,isnull(a.androidlinkurl,'') as androidlinkurl,isnull(a.androidlinktype,0) as androidlinktype , b.TypeName from dt_mall_attribute a(nolock) join dt_ImgType b(nolock) on a.imgTypeS = b.ImgType where a.ImgType = @ImgType and a.Entid = @entId and a.source = @source and a.status=2 ) t where bh = 1 ");
}
else
{
strSql.Append(" a.ID, a.Sort_id, a.title, isnull(a.img_url,'') as img_url, isnull(a.link_url,'') as link_url, a.ImgType, a.imgTypeS, a.ArticleID as article_id, a.status, a.link_name, a.xh, a.beizhu, a.entid, a.source, a.add_time,isnull(a.androidlinkurl,'') as androidlinkurl,isnull(a.androidlinktype,0) as androidlinktype , b.TypeName from dt_mall_attribute a(nolock) join dt_ImgType b(nolock) on a.imgTypeS = b.ImgType where a.ImgType = @ImgType and a.Entid = @entId and a.source = @source and a.status=2 order by Sort_id asc ");
}
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@ImgType", imgType),
new SqlParameter("@entId", entId),
new SqlParameter("@source", source)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <ImgInfo> IList = new List <ImgInfo>();
if (dt.Rows.Count > 0)
{
IList = SetImgInfo(dt);
}
return(IList);
}
/// <summary>
/// 用户登陆
/// </summary>
/// <param name="UserName">登陆名</param>
/// <param name="passWord">密码</param>
/// <returns></returns>
public DataTable UserLoginDal(string UserName, string loginType, string passWord)
{
StringBuilder strSql = new StringBuilder();
if (loginType == "account")
{
if (UserName.Contains("DWI") || UserName.Contains("dwi"))
{
strSql.Append("select userid,entid,status,password,role_type from dt_users where businessid=@UserName and password=@PassWord and role_id=1");
}
else
{
strSql.Append("select userid,entid,status,password,role_type from dt_users where UserName=@UserName and password=@PassWord and role_id=1");
}
}
else
{
strSql.Append("select userid,entid,status,password,role_type from dt_users where telphone=@UserName and password=@PassWord and role_id=1");
}
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@UserName", UserName),
new SqlParameter("@PassWord", passWord)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = new DataTable();
dt = sql.RunSqlDataTable(strSql.ToString(), param);
return(dt);
}
/// <summary>
/// 根据商品分类id获取列表
/// </summary>
/// <param name="CategoryId">分类Id</param>
/// <returns></returns>
public List <Category> GetCategory(string categoryId, string entId)
{
///
if (entId == "")
{
entId = BaseConfiguration.EntId;//默认企业id
}
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,isnull(link_url,'') as link_url,isnull(img_url,'') as img_url,content,entid ");
strSql.Append(" from dt_article_category(nolock) a where channel_id=7 ");
//strSql.Append(" from dt_article_category(nolock) a where channel_id=7 and entid=@EntId ");
strSql.Append(" and exists(select 1 from dt_article_category b(nolock) where b.id=@categoryId and a.parent_id=b.parent_id)");
strSql.Append(" order by sort_id asc,id desc ");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@categoryId", categoryId),
//new SqlParameter("@EntId",entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <Category> CList = new List <Category>();
if (dt.Rows.Count > 0)
{
CList = SetCategory(dt);
}
return(CList);
}
/// <summary>
/// 检测是否有到货提醒 有为true 没有为false
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static bool CheckGoodsArrival(string entId, string userId, string article_Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select Id from Zzsk_ArrivalReminder where ProductId=" + article_Id + " and UserId='" + userId + "' and EntId='" + entId + "'");
SqlRun sql = new SqlRun(SqlRun.sqlstr);
bool flag = sql.RunSqlDataTable(strSql.ToString()).Rows.Count > 0;
return(flag);
}
/// <summary>
/// 获取整个机构的管理员，只获取下级
/// </summary>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string Familylist(string userId, string entid)
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunSqlDataTable($"select UserId,FatherUserId from dt_users where role_type=2 and entid='{entid}'");
if (ds.Rows.Count > 0)
{
StringBuilder builder = new StringBuilder();
return(DgId(userId, ds.Rows, builder).ToString());
}
else
{
return("");
}
}
/// <summary>
/// 主题色
/// </summary>
/// <param name="entId">机构</param>
/// <returns></returns>
public string SubjectColor(string entId)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Value from Zzsk_ConfigValue a(nolock) join Zzsk_Configuration b(nolock) on a.ConfigId=b.Id and b.TypeCode=901 where a.Status = 1 and b.Status = 1 and b.Code=0 and a.Entid = @entId");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@entId", entId),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
string color = "";
if (dt.Rows.Count > 0)
{
color = dt.Rows[0]["Value"].ToString();
}
return(color);
}
/// <summary>
///获取网站系统
/// </summary>
/// <param name="entId"></param>
/// <returns></returns>
public List <SystemBase> GetSystemBase(string entId)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select web_name,web_ip,company,complaints,xxjyz,xxfwz,icp,img_logo,img_app,img_left,img_right,img_service,link_service from dt_system_base where entId=@entId");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@entId", entId),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <SystemBase> list = new List <SystemBase>();
if (dt.Rows.Count > 0)
{
list = SetSystemBase(dt);
}
return(list);
}
/// <summary>
/// 获取用户地址
/// </summary>
/// <param name="entId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public List <Address> GetUserAddress(string entId, string userId)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,user_id,accept_name,province,city,prefecture,address,telphone,is_default from dt_user_address (nolock) where entId=@entid and user_Id=@userId order by is_default desc");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@entid", entId),
new SqlParameter("@userId", userId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <Address> list = new List <Address>();
if (dt.Rows.Count > 0)
{
list = SetUserAddress(dt);
}
return(list);
}
/// <summary>
/// 获取商品详情图片
/// </summary>
/// <param name="articleId"></param>
/// <returns></returns>
public List <ImgInfo> GetGoodsDetailImg(string articleId)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append(" select entid,id,sort_id,'Goods' as ImgType,article_id,isnull(img_url,'') as img_url,'' as androidlinkurl,0 as androidlinktype,'商品图片' as TypeName");
strSql.Append(" from dt_article_albums(nolock) where article_id=@articleId");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@articleId", articleId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <ImgInfo> IList = new List <ImgInfo>();
if (dt.Rows.Count > 0)
{
IList = SetImgInfo(dt);
}
return(IList);
}
/// <summary>
/// 个人中心角标
/// </summary>
/// <param name="entId">企业</param>
/// <param name="userId">用户</param>
/// <returns></returns>
public CornerMark CornerMark(string entId, string userId)
{
DataTable table = new DataTable();
SqlParameter[] sql = new SqlParameter[]
{
new SqlParameter("@type", "CornerMark"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId)
};
SqlRun sqlRun = new SqlRun(SqlRun.sqlstr);
table = sqlRun.RunSqlDataTable("Proc_UserInfo", sql);
CornerMark cornerMark = new CornerMark();
if (table.Rows.Count > 0)
{
cornerMark = CornerMarkFill(table.Rows[0]);
}
return(cornerMark);
}
/// <summary>
/// 获取商品分类/首页导航栏
/// </summary>
/// <param name="Channel_Id"></param>
/// <returns></returns>
public List <Models.Category> GetCategory(string entid, int channelId)
{
DataTable dt = new DataTable();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,isnull(link_url,'') as link_url,isnull(img_url,'') as img_url,content,entid ");
strSql.Append(" from dt_article_category where channel_id=@Channel_Id /*and entid=@EntId*/ ");
strSql.Append(" order by sort_id asc,id desc ");
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Channel_Id", channelId),
new SqlParameter("@EntId", entid)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
dt = sql.RunSqlDataTable(strSql.ToString(), param);
List <Models.Category> CList = new List <Models.Category>();
if (dt.Rows.Count > 0)
{
CList = SetCategory(dt);
}
return(CList);
}