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