/// <summary> /// 根据ID获取单条自定义表单 /// </summary> /// <param name="id"></param> /// <param name="isDefaultValue">是否设置搜索字段的默认值</param> /// <returns></returns> public Models.CustomForm GetSingleCustomForm(int id, bool isDefaultValue) { SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr); string sql = "select * from dt_custom_form where [ID]=" + id; DataTable dt = sqlhelper.RtDataTable(sql); Models.CustomForm model = new Models.CustomForm(); if (dt.Rows.Count > 0) { model.ID = Convert.ToInt32(dt.Rows[0]["ID"]); model.Name = dt.Rows[0]["Name"].ToString(); model.SQL = dt.Rows[0]["SQL"].ToString(); model.Fields = dt.Rows[0]["Fields"].ToString(); List <Fields> fieldsList = JsonConvert.DeserializeObject <List <Fields> >(model.Fields); // 使用默认值读数据 if (isDefaultValue) { foreach (var f in fieldsList) { if (f.type == "date" && string.IsNullOrWhiteSpace(f.defaultValue)) { f.defaultValue = DateTime.Now.Date.ToString("yyyy-MM-dd HH:mm:ss"); } model.SQL = model.SQL.Replace(f.field, f.defaultValue); } } } return(model); }
/// <summary> /// 获取购物车条目数 /// </summary> /// <param name="entId"></param> /// <param name="userId"></param> /// <returns></returns> public int GetCartCount(string entId, string userId, string ywyId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select a.entId,cartId from dt_cart_keys a(nolock) join Fun_UserEntDoc('" + userId + "') b on a.entId=b.entid and ywyId='" + ywyId + "'"); SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RtDataTable(strSql.ToString()); return(dt.Rows.Count); }
/// <summary> /// 网站设置修改 /// </summary> /// <param name="json"></param> /// <param name="proc"></param> /// <param name="UserId"></param> /// <param name="entId"></param> /// <returns></returns> protected string SaveBase(string json, string proc, string UserId, string entId) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); ///修改webconfig节点 BasisConfig.UpdateAppSetting("SercerIp", obj["ip"].ToString()); StringBuilder strSql = new StringBuilder(); //修改商品主表 strSql.Append("select entid from dt_system_base(nolock) where entid='" + entId + "'"); SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RtDataTable(strSql.ToString()); //清空StringBuilder strSql.Length = 0; if (dt.Rows.Count > 0) { strSql.Append("update dt_system_base set web_name=@web_name,web_ip=@web_ip,company=@company,complaints=@complaints,xxjyz=@xxjyz,xxfwz=@xxfwz,icp=@icp,beizhu=@beizhu,img_app=@img_app,img_logo=@img_logo,img_left=@img_left,img_right=@img_right,img_service=@img_service,link_service=@link_service where entid=@entid"); } else { strSql.Append("insert into dt_system_base(entId,web_name,web_ip,company,complaints,xxjyz,xxfwz,icp,beizhu,img_app,img_logo,img_left,img_right,img_service,link_service) "); strSql.Append(" values(@entId,@web_name,@web_ip,@company,@complaints,@xxjyz,@xxfwz,@icp,@beizhu,@img_app,@img_logo,@img_left,@img_right,@img_service,@link_service);"); } SqlParameter[] prmt = new SqlParameter[] { new SqlParameter("@entid", entId), new SqlParameter("@web_name", obj["title"].ToString()), new SqlParameter("@web_ip", obj["ip"].ToString()), new SqlParameter("@company", obj["company"].ToString()), new SqlParameter("@complaints", obj["complaints"].ToString()), new SqlParameter("@xxjyz", obj["xxjyz"].ToString()), new SqlParameter("@xxfwz", obj["xxfwz"].ToString()), new SqlParameter("@icp", obj["ICP"].ToString()), new SqlParameter("@beizhu", obj["beizhu"].ToString()), new SqlParameter("@img_app", obj["app_url"].ToString()), new SqlParameter("@img_logo", obj["logo_url"].ToString()), new SqlParameter("@img_left", obj["left_url"].ToString()), new SqlParameter("@img_right", obj["right_url"].ToString()), new SqlParameter("@img_service", obj["kf_url"].ToString()), new SqlParameter("@link_service", obj["kf_link"].ToString()) }; int n = sql.ExecuteSql(strSql.ToString(), prmt); if (n > 0) { return(JsonMethod.GetError(0, "提交成功")); } else { return(JsonMethod.GetError(1, "提交失败")); } }
/// <summary> /// 返回DataTable(权限访问) /// </summary> /// <param name="userId">用户主键</param> /// <param name="entId"></param> /// <param name="ConfigType">权限等级</param> /// <returns></returns> protected string GettIndexUrlJson(string entid, string username) { SqlRun sql = new SqlRun(SqlRun.sqlstr); List <Dt_Method> list = new List <Dt_Method>(); if (entid == "superintendent") { list = DateTableTool.DataTableToList <Dt_Method>(sql.RtDataTable($"select * from Dt_Method m join [Dt_RoleMethod] rm on rm.MethodId=m.Id join dt_users us on rm.RoleId=us.role_id and us.entid='superintendent'")); } else { list = DateTableTool.DataTableToList <Dt_Method>(sql.RtDataTable($"select m.* from Dt_Method m join [Dt_RoleMethod] rm on rm.MethodId=m.Id join dt_users us on rm.RoleId=us.role_id where m.status=1 and us.entid='" + entid + "' and us.username='******' and m.Source in('B2B','ALL')")); } if (list.Count() > 0) { ///加载Html string urlList = ""; foreach (Dt_Method meth in list.Where(a => a.FatherId == null)) { urlList += "<dl id='menu-" + meth.Id + "'>"; urlList += " <dt ><i class='Hui-iconfont ztbj' style='font-size: 20px'>" + meth.IcoAddress + "</i> " + meth.Title + "<i class='Hui-iconfont menu_dropdown-arrow'></i></dt>"; urlList += " <dd>"; urlList += " <ul>"; foreach (Dt_Method son in list.Where(a => a.FatherId == meth.Id).ToList()) { urlList += "<li><a data-href='" + son.Power + "' data-title='" + son.Title + "' href='javascript:void(0)'><i class='Hui-iconfont'>" + son.IcoAddress + "</i> " + son.Title + "</a></li>"; } urlList += " </ul>"; urlList += " </dd>"; urlList += "</dl>"; } return("{\"flag\":\"0\",\"urlList\":\"" + urlList + "\"}"); } else { string error = "无数据"; return(JsonMethod.GetError(1, error)); } }
private string GetClientType(HttpContext context, string userid, string entid) { string Json = ""; string sqlStr = "select TypeID,ClientType from dt_CustomerType where status=1 order by TypeID asc"; SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RtDataTable(sqlStr); if (dt.Rows.Count > 0) { Json = JsonMethod.GetDataTable(0, dt.Rows.Count, 1, dt); } else { Json = JsonMethod.GetError(1, "客户分类加载失败"); } return(Json); }
/// <summary> /// 获取购物车商品列表 /// </summary> /// <param name="userId">客户ID</param> /// <returns></returns> public DataTable GetCartEntList(string userId) { DataTable dt = new DataTable(); try { StringBuilder strSql = new StringBuilder(); strSql.Append($"select distinct c.entid,c.entname from dt_cart_keys a join Dt_UserEntDoc b on a.userId=b.userId and a.entid=b.entid join dt_entdoc c on b.entId=c.entid where b.status=2 and a.userId='{userId}' "); SqlRun sql = new SqlRun(SqlRun.sqlstr); dt = sql.RtDataTable(strSql.ToString()); } catch (Exception ex) { dt = null; LogQueue.Write(LogType.Error, "Cart/GetCartEntList", ex.Message.ToString()); } return(dt); }
protected string GetWebSiteBase(string json, string proc, string UserId, string entId) { JObject obj = (JObject)JsonConvert.DeserializeObject(json); StringBuilder strSql = new StringBuilder(); //修改商品主表 strSql.Append("select entId,web_name,web_ip,company,complaints,xxjyz,xxfwz,icp,beizhu,img_app,img_logo,img_left,img_right,img_service,link_service from dt_system_base(nolock) where entid='" + entId + "'"); SqlRun sql = new SqlRun(SqlRun.sqlstr); DataTable dt = sql.RtDataTable(strSql.ToString()); if (dt.Rows.Count > 0) { return(JsonMethod.GetDataTable(0, 1, 1, dt)); } else { return(JsonMethod.GetError(1, "无数据")); } }