/// <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, "无数据"));
}
}
