/// <summary>
/// 获取数据返回数据列表
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <returns></returns>
protected string GetReturnJson(string json, string proc, string userId, string entId)
{
string r_json;
SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entId)).ToArray();//动态解析json参数
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet(proc, param);
if (ds.Tables.Count >= 3)
{
if (ds.Tables[1].Rows.Count > 0)
{
int recordCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim());
int pageCount = Convert.ToInt32(ds.Tables[2].Rows[0]["pageCount"].ToString().Trim());
DataTable table = sql.GetChinaName(ds.Tables[1]);
r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, table, ds.Tables[1]);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
int recordCount = 0;
int pageCount = 0;
r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[0]);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
}
return(r_json);
}
/// <summary>
/// 获取用户优惠券
/// </summary>
/// <param name="entId">机构</param>
/// <param name="userId">用户</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="pageSize">每页条目</param>
/// <param name="enable">是否使用</param>
/// <param name="limit">是否过期</param>
/// <param name="recordCount">总条目</param>
/// <param name="pageCount">总页数</param>
/// <returns></returns>
public List <Coupon> UserCouponList(string entId, string userId, string source, int pageIndex, int pageSize, int enable, out int recordCount, out int pageCount)
{
recordCount = 0; pageCount = 0;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "UserCouponList"),
new SqlParameter("@entId", entId),
new SqlParameter("@userId", userId),
new SqlParameter("@enable", enable),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var list = new List <Coupon>();
var set = sql.RunProDataSet("Proc_OperationCoupon", parameters);
if (set.Tables.Count >= 3)
{
pageCount = int.Parse(set.Tables[2].Rows[0]["pageCount"].ToString());
recordCount = int.Parse(set.Tables[2].Rows[0]["recordCount"].ToString());
int code = 10006;
switch (source)
{
case "苹果端":
code = 10005;
break;
case "电脑端":
code = 10000;
break;
case "安卓端":
code = 10003;
break;
}
list = FillList(set.Tables[1]).Where(a => a.TypeCoding == 10006 | a.TypeCoding == code).ToList();
}
return(list);
}
/// <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);
}
protected string UpdateDelRoleJson(string status, string strWhere)
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Proc_Admin_MembersQuery", new SqlParameter[] {
new SqlParameter("@type", "PC_DelRole"),
new SqlParameter("@strWhere", strWhere)
});
string r_json;
if (ds.Rows.Count > 0 && ds.Rows[0]["flag"].ToString() == "1")
{
r_json = JsonMethod.GetError(0, "删除成功");
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 查询用户到货提醒
/// </summary>
/// <param name="entId"></param>
/// <param name="userId"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public List <GoodsArrival> GoodsArrivalQuery(string entId, string userId, int pageIndex, int pageSize, out int recordCount, out int pageCount)
{
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetGoodsArrival"),
new SqlParameter("@entId", entId),
new SqlParameter("@userId", userId),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_Goods_Statistical", param);
DataTable dt = null;
if (ds.Tables.Count >= 3)
{
dt = ds.Tables[1];
recordCount = int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString());
pageCount = int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString());
}
else
{
dt = ds.Tables[0];
recordCount = dt.Rows.Count;
pageCount = 1;
}
List <GoodsArrival> list = new List <GoodsArrival>();
if (dt.Rows.Count > 0)
{
list = SetGoodsArrivalInfo(dt);
}
return(list);
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "StatisticalDal/GoodsArrivalQuery", ex.Message.ToString());
throw ex;
}
}
/// <summary>
/// 查询商户充值订单
/// </summary>
/// <param name="orderNo"></param>
/// <returns></returns>
public List <RechargeOrders> InquireRecharge(string orderNo)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "InquireRecharge"),
new SqlParameter("@orderNo", orderNo)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_OperationRecharge", sqls);
List <RechargeOrders> rechargeOrders = new List <RechargeOrders>();
if (set.Tables[0].Rows.Count > 0)
{
rechargeOrders = FillRechargeOrders(set.Tables[0]);
}
else
{
rechargeOrders = null;
}
return(rechargeOrders);
}
public JsonResult SaveHelpCategory(string proc, string type, string class_layer, string parent_id, string sort_id, string title, string content, string id)
{
try
{
if (id == "")
{
id = "0";
}
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR(proc, new SqlParameter[] {
new SqlParameter("type", type),
new SqlParameter("class_layer", class_layer),
new SqlParameter("parent_id", parent_id),
new SqlParameter("sort_id", sort_id),
new SqlParameter("title", title),
new SqlParameter("channel_id", "11"),
new SqlParameter("call_index", ""),
new SqlParameter("seo_title", ""),
new SqlParameter("content", content),
new SqlParameter("id", id)
});
if (dt.Rows.Count > 0 && (int.Parse(dt.Rows[0]["flag"].ToString())) > 0)
{
return(Json(new { flag = true, message = "添加成功" }));
}
else
{
return(Json(new { flag = false, message = "添加失败" }));
}
}
catch (Exception ex)
{
Log.Error("错误:帮助资讯存盘", ex.Message);
LogQueue.Write(LogType.Error, "Article/SaveArticle", ex.Message);
return(Json(new { success = false, message = "帮助资讯存盘失败！" }));
}
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
protected string UpdateUserInfo(string json, string password)
{
JObject obj = (JObject)JsonConvert.DeserializeObject(json);
string pwd = "";
if (obj["pwd"].ToString().Trim() == password)
{
pwd = obj["pwd"].ToString().Trim();
}
else
{
pwd = Encryption.GetMD5_16(obj["pwd"].ToString().Trim());
}
string name = obj["name"].ToString();
string sex = obj["sex"].ToString();
string telphone = obj["telphone"].ToString();
string birthday = obj["birthday"].ToString();
string point = obj["point"].ToString();
string status = obj["status"].ToString();
string userIds = obj["userId"].ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append($"update dt_users set name='{name}',sex='{sex}',telphone='{telphone}',birthday='{birthday}',point='{point}',status='{obj["status"].ToString()}',");
strSql.Append($"password='******' where userId='{userIds}'"); //entId = @entId,
SqlRun sql = new SqlRun(SqlRun.sqlstr);
bool flag = sql.ExecuteSql(strSql.ToString());
if (flag)
{
return(JsonMethod.GetError(0, "存盘成功"));
}
else
{
return(JsonMethod.GetError(1, "操作失败"));
}
}
/// <summary>
/// 积分商品详情
/// </summary>
/// <param name="entId"></param>
/// <param name="goodsId"></param>
/// <returns></returns>
public string IntegralGoods(string entId, string goodsId)
{
string json = string.Empty;
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@type", "jifenDetail"),
new SqlParameter("@goodsid", goodsId),
new SqlParameter("@entId", entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_Premiun_details", param);
if (ds.Tables[0].Rows.Count > 0)
{
json = JsonHelper.GetDataJson(0, 0, 0, ds.Tables[0]);
}
else
{
json = JsonHelper.GetErrorJson(1, 0, "暂无数据");
}
return(json);
}
/// <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);
}
/// <summary>
/// 领取优惠券
/// </summary>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <param name="couponCode"></param>
/// <param name="flag"></param>
/// <returns></returns>
public string GetCoupon(string userId, string entId, int couponCode, out bool flag)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "GetCoupon"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@couponCode", couponCode)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_OperationCoupon", parameters);
if (table.Rows.Count > 0)
{
flag = 0 == int.Parse(table.Rows[0]["flag"].ToString()) ? true : false;
return(table.Rows[0]["msg"].ToString().Trim());
}
else
{
flag = false;
return("优惠券领取失败！");
}
}
public string PicturesData(string userId, string entId, string sqlvalue, string type, string arguments, string imgUrl)
{
try
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", type),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@sqlvalue", sqlvalue),
new SqlParameter("@arguments", arguments)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable data = sql.RunProcedureDR("Proc_QualityInspection", sqls);
UplaodImg(sqlvalue, type, data, imgUrl, arguments);
return(JsonHelper.GetDataJson(0, data.Rows.Count, data));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "QualityInspectionReport/UplaodImg", ex.ToString());
return(JsonHelper.GetErrorJson(1, 0, ex.ToString()));
}
}
/// <summary>
/// 保存模板绑定
/// </summary>
/// <param name="title"></param>
/// <param name="newsType"></param>
/// <param name="sortId"></param>
/// <param name="dates"></param>
/// <param name="content"></param>
/// <returns></returns>
protected string SaveTemplateRelation(string promotioncode, string templatecode, string categorycode, int txtType, string templateimg, int sort_id, string id)
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
int num = sql.ExecuteNonQuery("Pc_TemplateRelation", new SqlParameter[] {
new SqlParameter("@type", "PC_AddTemplateRelation"),
new SqlParameter("@PromotionCode", promotioncode),
new SqlParameter("@TemplateCode", templatecode),
new SqlParameter("@CategoryCode", categorycode),
new SqlParameter("@TypeCode", txtType),
new SqlParameter("@TemplateImg", templateimg),
new SqlParameter("@Sort_id", sort_id),
new SqlParameter("@strWhere", id),
});
if (num > 0)
{
return(JsonMethod.GetError(0, "操作成功"));
}
else
{
return(JsonMethod.GetError(1, "操作失败"));
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="ids"></param>
/// <returns></returns>
public bool BatchDelete(int[] ids)
{
if (ids.Length == 0)
{
return(false);
}
SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr);
int flag = 0;
for (int i = 0; i < ids.Length; i++)
{
SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@id", ids[i]) };
flag += sqlhelper.ExecuteNonQuery("Proc_DeleteCustomForm", sqlParams);
}
if (flag > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 客户审核
/// </summary>
/// <param name="json"></param>
/// <returns></returns>
public string AuditCustomer(string json)
{
JObject obj = (JObject)JsonConvert.DeserializeObject(json);
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_businessdoc set beactive=@status where businessid=@businessId and entid=@entId");
SqlParameter[] pram = new SqlParameter[] {
new SqlParameter("@status", obj["status"].ToString()),
new SqlParameter("@businessId", obj["businessId"].ToString()),
new SqlParameter("@entId", obj["entId"].ToString()),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
int n = sql.ExecuteSql(strSql.ToString(), pram);
if (n > 0)
{
return(JsonMethod.GetError(0, "操作成功"));
}
else
{
return(JsonMethod.GetError(1, "操作失败"));
}
}
/// <summary>
/// 充值选项
/// </summary>
/// <returns></returns>
public List <RechargeGoods> RechargeOptions(string entId, string userId)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "RechargeGoods"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId)
};
List <RechargeGoods> rechargeGoods = new List <RechargeGoods>();
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_OperationRecharge", sqls);
DataTable table = set.Tables[0];
if (table.Rows.Count > 0)
{
rechargeGoods = FillRechargeGoods(table);
}
else
{
rechargeGoods = null;
}
return(rechargeGoods);
}
/// <summary>
/// 获取用户资料
/// </summary>
/// <param name="userId">用户Id</param>
/// <param name="entId">机构Id</param>
/// <returns></returns>
public List <UserRegister> AcquireMaterial(string telphone, string entId)
{
SqlParameter[] sqls = new SqlParameter[] {
new SqlParameter("@type", "AcquireMaterial"),
new SqlParameter("@telphone", telphone),
new SqlParameter("@entId", entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
//DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls);
DataSet set = sql.RunProDataSet("Proc_OperationUser", sqls);
//LogQueue.Write(LogType.Debug, "表数目", set.Tables.Count.ToString());
List <UserRegister> infos = new List <UserRegister>();
if (set.Tables.Count > 0)
{
infos = FillList(set);
}
else
{
infos = null;
}
return(infos);
}
public string SaveCustomer(string json)
{
JObject obj = (JObject)JsonConvert.DeserializeObject(json);
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_businessdoc set businesscode=@businesscode,businessname=@businessname,entid=@entid,clienttype=@clienttype,");
strSql.Append("beactive=@beactive,shortname=@shortname,businesscont=@businesscont,address=@address,wtr=@wtr,wtsyxq=@wtsyxq,");
strSql.Append("xkzyxq=@xkzyxq,yyzzyxq=@yyzzyxq,gspzsyxq=@gspzsyxq where entid=@oldentid and businessid=@businessid ");
SqlParameter[] pram = new SqlParameter[] {
new SqlParameter("@businesscode", obj["businesscode"].ToString()),
new SqlParameter("@businessname", obj["businessname"].ToString()),
new SqlParameter("@entid", obj["entid"].ToString()),
new SqlParameter("@clienttype", obj["clienttype"].ToString()),
new SqlParameter("@beactive", obj["beactive"].ToString()),
new SqlParameter("@shortname", obj["shortname"].ToString()),
new SqlParameter("@businesscont", obj["businesscont"].ToString()),
new SqlParameter("@address", obj["address"].ToString()),
new SqlParameter("@wtr", obj["wtr"].ToString()),
new SqlParameter("@wtsyxq", obj["wtsyxq"].ToString()),
new SqlParameter("@xkzyxq", obj["xkzyxq"].ToString()),
new SqlParameter("@yyzzyxq", obj["yyzzyxq"].ToString()),
new SqlParameter("@gspzsyxq", obj["gspzsyxq"].ToString()),
new SqlParameter("@oldentid", obj["oldentid"].ToString()),
new SqlParameter("@businessid", obj["businessid"].ToString())
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
int n = sql.ExecuteSql(strSql.ToString(), pram);
if (n > 0)
{
return(JsonMethod.GetError(0, "存盘成功"));
}
else
{
return(JsonMethod.GetError(1, "存盘失败"));
}
}
public IndexAdvert GetIndexAdvert(string entId)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "GetIndexAdvert"),
new SqlParameter("@entId", entId)
};
IndexAdvert lc = new IndexAdvert();
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProcedureDR("Pc_Log", param);
string web_url = BaseConfiguration.SercerIp;
if (ds.Rows.Count > 0)
{
foreach (DataRow dr in ds.Rows)
{
lc = new IndexAdvert
{
linkurl = dr["linkurl"].ToString().Trim(),
height = dr["height"].ToString().Trim(),
width = dr["width"].ToString().Trim()
};
if (dr["imgurl"].ToString().Trim() != "")
{
lc.imgurl = web_url + dr["imgurl"].ToString().Trim();
}
else
{
lc.imgurl = "";
}
}
return(lc);
}
else
{
return(null);
}
}
public void ServerVariables(string entId, string userId, HttpRequest request)
{
//发出请求的远程主机的IP地址
var addr = request.ServerVariables["Remote_Addr"].ToString();
//发出请求的远程主机名称
var host = "";
//发出请求的远程主机端口
var port = request.ServerVariables["SERVER_PORT"].ToString();
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ServerVariables(UserID,EntID,Host,Addr,Port,RecordDate)values(@userId,@entId,@host,@addr,@port,@date)");
SqlParameter[] sqls = new SqlParameter[] {
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@host", host),
new SqlParameter("@addr", addr),
new SqlParameter("@port", port),
new SqlParameter("@date", DateTime.Now)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
sql.RunSqlNumber(strSql.ToString(), sqls);
}
/// <summary>
/// 获取积分流水&&获取积分订单汇总
/// </summary>
public string GetMsg(string type, string userid, string entId, int page, int size)
{
var msg = "";
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_Premiun_user",
new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@userid", userid),
new SqlParameter("@entId", entId),
new SqlParameter("@pageIndex", page),
new SqlParameter("@pageSize", size)
}
);
if (ds.Tables[1].Rows.Count > 0)
{
msg = JsonHelper.GetDataJson(0, int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString()), int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString()), ds.Tables[1]);
}
else
{
msg = JsonHelper.GetErrorJson(1, 0, "暂无数据");
}
return(msg);
}
public List <IndexFloor> GetIndexFloor(string userId, string entId)
{
///获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = dal.GetUserInfo(userId, entId);
string jgjb = "", KhType = "";
bool landing = false;
bool staleDated = false;
if (user.Count > 0)
{
entId = user[0].EntId;
jgjb = user[0].Pricelevel;
KhType = user[0].KhType;
landing = true;
staleDated = user[0].StaleDated;
}
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "floorImg"),
new SqlParameter("@jgjb", jgjb),
new SqlParameter("@khlb", KhType),
new SqlParameter("@EntId", entId),
new SqlParameter("@userId", userId),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProDataSet("Proc_GoodsList", param);
List <IndexFloor> list = new List <IndexFloor>();
if (ds.Tables.Count > 0)
{
list = FillFloor(ds.Tables[0], ds.Tables[1], entId, landing, staleDated, jgjb, userId);
}
return(list);
}
public List <IndexWebConfig> GetIndexConfig(string entId, string imgType)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "PC_GetWebConfig"),
new SqlParameter("@entId", entId),
new SqlParameter("@imgType", imgType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProcedureDR("Pc_Log", param);
List <IndexWebConfig> list = new List <IndexWebConfig>();
string web_url = BaseConfiguration.SercerIp;
if (ds.Rows.Count > 0)
{
foreach (DataRow dr in ds.Rows)
{
IndexWebConfig lc = new IndexWebConfig
{
ImgType = dr["ImgType"].ToString().Trim(),
TypeName = dr["TypeName"].ToString().Trim(),
WebValue = dr["WebValue"].ToString().Trim(),
ImgOrText = int.Parse(dr["ImgOrText"].ToString())
};
if (dr["imgurl"].ToString().Trim() != "")
{
lc.imgurl = web_url + dr["imgurl"].ToString().Trim();
}
else
{
lc.imgurl = "";
}
list.Add(lc);
}
}
return(list);
}
/// <summary>
/// 搜索页获取商品列表
/// </summary>
/// <param name="ywyId">业务员Id</param>
/// <param name="userId">客户Id</param>
/// <param name="searchValue">搜索条件</param>
/// <param name="letter">厂家首字母</param>
/// <param name="tags">排序类型</param>
/// <param name="isKc">是否有货</param>
/// <param name="CategoryId">商品分类Id</param>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">没页行数</param>
/// <returns></returns>
public ValetOrderModel <GoodsInfo> GetGoodsList(string ywyId, string userId, string searchValue, string letter, string tags, string isKc, string CategoryId, int pageIndex, int pageSize, string entid)
{
ValetOrderModel <GoodsInfo> mode = new ValetOrderModel <GoodsInfo>();
mode.PageIndex = pageIndex;
mode.PageSize = pageSize;
////加载用户信息
string jgjb = "", clientlimit = "", KhType = "";
try
{
//获取用户信息
UserInfoDal dal = new UserInfoDal();
List <UserInfo> user = new List <UserInfo>();
user = dal.GetUserInfo(userId, entid);
if (user.Count <= 0)
{
mode.Success = "002";
mode.Message = "客户信息获取失败";
return(mode);
}
entid = user[0].EntId;
jgjb = user[0].Pricelevel;
clientlimit = user[0].ClientLimit;
KhType = user[0].KhType;
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "ValetOrder/GetGoodsList", ex.Message.ToString());
mode.Success = "002";
mode.Message = "客户信息获取失败," + ex.Message.ToString();
return(mode);
}
try
{
///加载查询条件
StringBuilder StrWhere = new StringBuilder();
if (searchValue.IndexOf(" ") >= 0)
{
string goodsValue, factoryValue;
string[] searchString = searchValue.Split(' ');
goodsValue = searchString[0];
factoryValue = searchString[1];
StrWhere.Append(" and b.mnemonic_code like '%" + goodsValue + "%' and b.Origin_mnemonic_code like '%" + factoryValue + "%' ");
}
else
{
StrWhere.Append(" and(b.goodscode like '%" + searchValue + "%' or b.sub_title like '%" + searchValue + "%' or b.mnemonic_code like '%" + searchValue + "%'");
StrWhere.Append(" or b.drug_factory like '%" + searchValue + "%' or b.Origin_mnemonic_code like '%" + searchValue + "%') ");
}
//是否有货筛选
if (isKc == "Y")
{
StrWhere.Append(" and c.stock_quantity>0 ");
}
//商品价格大于0筛选
StrWhere.Append(" and d.price>0.0");
///厂家首字母筛选
if (letter != "")
{
StrWhere.Append(" and left(b.Origin_mnemonic_code,1)='" + letter + "'");
}
StringBuilder order = new StringBuilder();
order.Append(" ");
//商品排序
switch (tags)
{
case "click_u": //点击量升序
order.Append(" order by a.click asc,b.goodscode asc");
break;
case "click_d": //点击量降序
order.Append(" order by a.click desc,b.goodscode desc");
break;
case "sales_u": //销量升序
order.Append(" order by a.sales asc,b.goodscode asc");
break;
case "sales_d": //销量降序
order.Append(" order by a.sales desc,b.goodscode desc");
break;
case "price_u": //价格升序
order.Append(" order by d.price asc,b.goodscode asc");
break;
case "price_d": //价格降序
order.Append(" order by d.price desc,b.goodscode desc");
break;
case "cxbs": //促销排序
order.Append(" order by fabh desc,b.goodscode asc");
break;
case "cjpx": //厂家排序
order.Append(" order by drug_factory asc");
break;
case "sppx": //商品排序
order.Append(" order by sub_title asc");
break;
default:
order.Append(" order by b.goodscode asc");
break;
}
//////统计客户搜索类容
if (searchValue != "")
{
bool flag = StatisticalDal.GoodsStatistical("GoodsSearch", searchValue, entid);
}
///获取商品列表
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetList"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entid),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@StrWhere", StrWhere.ToString()),
new SqlParameter("@Order", order.ToString()),
new SqlParameter("@CategoryId", CategoryId),
new SqlParameter("@Login_Id", ywyId),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@khlb", KhType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_GoodsList", param);
mode.Success = "001";
if (ds.Tables.Count > 0)
{
DataTable dt = new DataTable();
if (ds.Tables.Count >= 3)
{
dt = ds.Tables[1];
}
else
{
dt = ds.Tables[0];
}
if (dt.Rows.Count > 0)
{
mode.Data = SetGoodsList(dt);
mode.Success = "000";
mode.Message = "商品加载成功";
}
}
return(mode);
}
catch (Exception ex)
{
mode.Success = "002";
mode.Message = "商品信息加载失败," + ex.Message.ToString();
return(mode);
}
}
public string TabularData(string json, string userId, string entId)
{
string JSON = "{\"status\":";
string message = "", status = "0";
DataSet ds = new DataSet();
DataTable dt = new DataTable();
DataTable dt_fd = new DataTable();
SqlRun sqlRun = new SqlRun(SqlRun.sqlstr);
try
{
ds = AcquireData(json, userId, entId);
int ReCount = 0, pgCount = 0;
message = "{\"fdname\":{";
if (ds.Tables.Count > 2)
{
dt = ds.Tables[1];
dt_fd = sqlRun.GetChinaName(dt);
ReCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim());
pgCount = Convert.ToInt32(ds.Tables[2].Rows[0]["PageCount"].ToString().Trim());
}
else
{
dt = ds.Tables[0];
dt_fd = sqlRun.GetChinaName(dt);
ReCount = dt.Rows.Count;
}
if (dt_fd != null)
{
foreach (DataColumn dc in dt.Columns)
{
if (dc.ColumnName.Contains("ROWSTAT"))
{
continue;
}
DataRow[] dr = dt_fd.Select("fdname = '" + dc.ColumnName + "'");
string chnname = dr.Length == 1 ? dr[0]["chnname"].ToString() : dc.ColumnName;
message += "\"" + dc.ColumnName.Trim() + "\":\"" + chnname + "\",";
}
message = message.Substring(0, message.Length - 1);
message += "},";
}
else
{
throw new Exception("未获取字段");
}
message += "\"ReCount\":" + ReCount + ",\"pgCount\":" + pgCount + ",\"Content\":";
if (dt.Rows.Count > 0)
{
message += "[";
foreach (DataRow dr in dt.Rows)
{
message += "{";
foreach (DataColumn dc in dt.Columns)
{
if (dc.ColumnName.Contains("ROWSTAT"))
{
continue;
}
message += "\"" + dc.ColumnName.Trim() + "\":\"" + dr[dc.ColumnName].ToString().Trim() + "\",";
}
message = message.Substring(0, message.Length - 1);
message += "},";
}
message = message.Substring(0, message.Length - 1);
message += "]";
}
else
{
message += "\"无记录\"";
}
message += "}";
}
catch (Exception e)
{
status = "2";
message = "\"" + e.Message.Trim().Replace("\"", "\\\"").Replace("\r", "").Replace("\n", "") + "\"";
}
JSON += "\"" + status + "\"";
JSON += ",\"message\":" + message + "}";
return(JSON);
}
public List <ImgInfo> GoodsParatope(List <ImgInfo> imgList, string entId, string webUrl, bool landing, bool staleDated, int len, string jgjb, string title, string userId)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "GoodsParatope"),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@EntId", entId),
new SqlParameter("@userId", userId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var dt = sql.RunProcedureDR("Proc_GoodsList", param);
List <ImgInfo> source = new List <ImgInfo>();
List <ImgInfo> back = new List <ImgInfo>();
//LogQueue.Write(LogType.Debug, "商品count", $"{dt.Rows.Count}");
if (dt.Rows.Count > 0)
{
//补位数据
foreach (DataRow item in dt.Rows)
{
ImgInfo img = new ImgInfo
{
Entid = item["entid"].ToString().Trim(),
Title = title,
ArticleId = item["Article_Id"].ToString().Trim(),
SortId = int.Parse(item["sort_Id"].ToString().Trim()),
IsBrand = "N",
BrandCode = "",
LinkUrl = item["link_url"].ToString().Trim()
};
if (item["img_url"].ToString().Trim() != "")
{
img.ImgUrl = webUrl + item["img_url"].ToString().Trim();
}
else
{
img.ImgUrl = "";
}
if (item["left_pic"].ToString().Trim() != "")
{
img.LeftPic = webUrl + item["left_pic"].ToString().Trim();
}
if (item["brand_img_url"].ToString().Trim() != "")
{
img.BrandImgUrl = webUrl + item["brand_img_url"].ToString().Trim();
}
else
{
img.BrandImgUrl = "";
}
img.SubTitle = item["sub_title"].ToString().Trim();
img.DrugSpec = item["drug_spec"].ToString().Trim();
img.DrugFactory = item["drug_factory"].ToString().Trim();
if (landing && !staleDated)
{
img.Price = BasisConfig.ObjToDecimal(item["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
}
else
{
img.Price = "会员可见";
}
img.Cxbs = item["cxbs"].ToString().Trim();
img.Fabh = item["fabh"].ToString().Trim();
source.Add(img);
}
//加入现有商品
imgList.ForEach(t => back.Add(t));
//已存在的品牌
var exist = imgList.Select(t => t.ArticleId).Distinct().ToList();
//移除已存在的品牌
source.RemoveAll(t => exist.Contains(t.ArticleId));
if (source.Count > 0)
{
int length = source.Count > len ? len : source.Count;
Random random = new Random();
int index = source.Count > len?random.Next(source.Count - len + 1) : 0;
source = source.GetRange(index, length);
source.ForEach(p => { back.Add(p); });
}
}
return(back);
}
/// <summary>
/// 返回DataTable(渠道分类)
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string GetReturnJsonBox(string json, string proc, string typename, string userId, string entid)
{
SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entid)).ToArray();//动态解析json参数
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR(proc, param);
if (ds.Rows.Count > 0)
{
///加载节点
string objList = "";
DataTable dtc = ds;
if (dtc.Rows.Count > 0)
{
switch (typename)
{
case "Pc_GetClassType": //设备类型//应用范围
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["Code"] + "'>" + dr_c1["Name"] + "</option>";
}
break;
case "Pc_GetCouponType": //领取类型
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["typeCoding"] + "'>" + dr_c1["typeName"] + "</option>";
}
break;
case "Pc_GetBrandType": //品牌类型
var num = 0;
foreach (DataRow dr_c1 in dtc.Rows)
{
//;
objList += "<input type='checkbox' id='chkPpBox" + num + "' value='" + dr_c1["billno"] + "' title='" + dr_c1["name"] + "' /> <label for='chkPpBox" + num + "''>" + dr_c1["name"] + "</label>  ";
num++;
}
break;
case "Pc_GoodsGroup": //商品分组
var n = 0;
foreach (DataRow dr_c1 in dtc.Rows)
{
//;
objList += "<input type='checkbox' id='chkPpBox" + n + "' value='" + dr_c1["billno"] + "' title='" + dr_c1["name"] + "' /> <label for='chkPpBox" + n + "''>" + dr_c1["name"] + "</label>  ";
n++;
}
break;
case "Pc_GetHelperType":
case "Pc_GetCateGoryType": //分类类型
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["title"] + "</option>";
}
break;
case "Pc_GetShengType": //省
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["name"] + "</option>";
}
break;
case "Pc_GetShiType": //市
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["name"] + "</option>";
}
break;
case "Pc_GetQuType": //区
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["name"] + "</option>";
}
break;
default:
break;
}
}
return("{\"flag\":\"0\",\"objList\":\"" + objList + "\"}");
}
else
{
string error = "无数据";
return(JsonMethod.GetError(1, error));
}
}
public string ActivityTheme(string promotionCode, string templateCode, string lx = "PC")
{
AppMsg <Object> jsonResult = new AppMsg <Object>();
string html = "";
try
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet dt = sql.RunProDataSet("Pc_TemplateRelation", new SqlParameter[]
{
new SqlParameter("@type", "CX_GetTemplateRelation"),
new SqlParameter("@PromotionCode", promotionCode),
new SqlParameter("@TemplateCode", templateCode)
});
if (dt.Tables.Count == 2 && dt.Tables[0].Rows.Count > 0 && dt.Tables[1].Rows.Count > 0)
{
html = dt.Tables[0].Rows[0]["TemplateText"].ToString();
DataRowCollection datalist = dt.Tables[1].Rows;
string boxTop = GetRegValue(html, "<!--截取TopStatr-->", "<!--截取TopEnd-->");
string tboxTop = boxTop;
if (boxTop != "")
{
string Topleft = GetRegValue(boxTop, "<!--leftTopStatr-->", "<!--leftTopEnd-->");
string tleft = Topleft;
if (datalist.Count == 1)
{
tleft = tleft.Replace("@left@article_id", datalist[0]["article_id"].ToString());
tleft = tleft.Replace("@left@pdoduct", datalist[0]["sub_title"].ToString());
tleft = tleft.Replace("@left@old", datalist[0]["price"].ToString());
tleft = tleft.Replace("@left@new", datalist[0]["price"].ToString());
tleft = tleft.Replace("@left@image", datalist[0]["img_url"].ToString());
tleft = tleft.Replace("@left@gg", datalist[0]["drug_spec"].ToString());
tboxTop.Replace(Topleft, tleft);
html.Replace(boxTop, tboxTop);
datalist.Remove(datalist[0]);
}
else if (datalist.Count >= 2)
{
var leftobj = datalist[0];
var rightobj = datalist[1];
tleft = tleft.Replace("@left@article_id", leftobj["article_id"].ToString());
tleft = tleft.Replace("@left@pdoduct", leftobj["sub_title"].ToString());
tleft = tleft.Replace("@left@old", leftobj["price"].ToString());
tleft = tleft.Replace("@left@new", leftobj["price"].ToString());
tleft = tleft.Replace("@left@image", leftobj["img_url"].ToString());
tleft = tleft.Replace("@left@gg", leftobj["drug_spec"].ToString());
//分割线 第二块
tboxTop = tboxTop.Replace("@right@article_id", rightobj["article_id"].ToString());
tboxTop = tboxTop.Replace("@right@pdoduct", rightobj["sub_title"].ToString());
tboxTop = tboxTop.Replace("@right@old", rightobj["price"].ToString());
tboxTop = tboxTop.Replace("@right@new", rightobj["price"].ToString());
tboxTop = tboxTop.Replace("@right@image", rightobj["img_url"].ToString());
tboxTop = tboxTop.Replace("@right@gg", rightobj["drug_spec"].ToString());
tboxTop = tboxTop.Replace(Topleft, tleft);
html = html.Replace(boxTop, tboxTop);
datalist.Remove(leftobj);
datalist.Remove(rightobj);
}
}
string boxAll = GetRegValue(html, "<!--截取Statr-->", "<!--截取end-->");
string leftAll = GetRegValue(boxAll, "<!--leftStatr-->", "<!--leftEnd-->");
string left = leftAll;
string box = boxAll;
string texthtml = "";
if (datalist.Count == 1)
{
//left = left.Replace("@left@huodong", datalist[0]["fabh"].ToString());
left = left.Replace("@left@article_id", datalist[0]["article_id"].ToString());
left = left.Replace("@left@pdoduct", datalist[0]["sub_title"].ToString());
left = left.Replace("@left@old", datalist[0]["price"].ToString());
left = left.Replace("@left@new", datalist[0]["price"].ToString());
left = left.Replace("@left@image", datalist[0]["img_url"].ToString());
left = left.Replace("@left@gg", datalist[0]["drug_spec"].ToString());
texthtml += left;
left = leftAll;
}
else if (datalist.Count % 2 != 0)
{
for (var i = 0; i < datalist.Count; i++)
{
//box = box.Replace("@left@huodong", datalist[i]["fabh"].ToString());
box = box.Replace("@left@article_id", datalist[i]["article_id"].ToString());
box = box.Replace("@left@pdoduct", datalist[i]["sub_title"].ToString());
box = box.Replace("@left@old", datalist[i]["price"].ToString());
box = box.Replace("@left@new", datalist[i]["price"].ToString());
box = box.Replace("@left@image", datalist[i]["img_url"].ToString());
box = box.Replace("@left@gg", datalist[i]["drug_spec"].ToString());
i++;
//box = box.Replace("@right@huodong", datalist[i]["fabh"].ToString());
box = box.Replace("@right@article_id", datalist[i]["article_id"].ToString());
box = box.Replace("@right@pdoduct", datalist[i]["sub_title"].ToString());
box = box.Replace("@right@old", datalist[i]["price"].ToString());
box = box.Replace("@right@new", datalist[i]["price"].ToString());
box = box.Replace("@right@image", datalist[i]["img_url"].ToString());
box = box.Replace("@right@gg", datalist[i]["drug_spec"].ToString());
texthtml += box;
box = boxAll;
if ((i + 1) == (datalist.Count - 1))
{
i++;
//left = left.Replace("@left@huodong", datalist[i]["fabh"].ToString());
left = left.Replace("@left@article_id", datalist[i]["article_id"].ToString());
left = left.Replace("@left@pdoduct", datalist[i]["sub_title"].ToString());
left = left.Replace("@left@old", datalist[i]["price"].ToString());
left = left.Replace("@left@new", datalist[i]["price"].ToString());
left = left.Replace("@left@image", datalist[i]["img_url"].ToString());
left = left.Replace("@left@gg", datalist[i]["drug_spec"].ToString());
texthtml += left;
left = leftAll;
}
}
}
else
{
for (var i = 0; i < datalist.Count; i++)
{
//box = box.Replace("@left@huodong", datalist[i]["fabh"].ToString());
box = box.Replace("@left@article_id", datalist[i]["article_id"].ToString());
box = box.Replace("@left@pdoduct", datalist[i]["sub_title"].ToString());
box = box.Replace("@left@old", datalist[i]["price"].ToString());
box = box.Replace("@left@new", datalist[i]["price"].ToString());
box = box.Replace("@left@image", datalist[i]["img_url"].ToString());
box = box.Replace("@left@gg", datalist[i]["drug_spec"].ToString());
i++;
//box = box.Replace("@right@huodong", datalist[i]["fabh"].ToString());
box = box.Replace("@right@article_id", datalist[i]["article_id"].ToString());
box = box.Replace("@right@pdoduct", datalist[i]["sub_title"].ToString());
box = box.Replace("@right@old", datalist[i]["price"].ToString());
box = box.Replace("@right@new", datalist[i]["price"].ToString());
box = box.Replace("@right@image", datalist[i]["img_url"].ToString());
box = box.Replace("@right@gg", datalist[i]["drug_spec"].ToString());
texthtml += box;
box = boxAll;
}
}
html = "<body>" + html.Replace(boxAll, texthtml) + "</body>";
}
else
{
throw new Exception("没有主题页");
}
}
catch (Exception ex)
{
html = ex.Message;
}
return(html);
}
public List <ImgInfo> BrandParatope(List <ImgInfo> imgList, string entId, string webUrl, bool landing, bool staleDated, int len, string userId)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "BrandParatope"),
new SqlParameter("@EntId", entId),
new SqlParameter("@userId", userId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var dt = sql.RunProcedureDR("Proc_GoodsList", param);
List <ImgInfo> source = new List <ImgInfo>();
List <ImgInfo> back = new List <ImgInfo>();
if (dt.Rows.Count > 0)
{
//补位数据
foreach (DataRow item in dt.Rows)
{
ImgInfo img = new ImgInfo
{
Entid = item["entid"].ToString().Trim(),
Title = item["FloorTitle"].ToString().Trim(),
ArticleId = item["Article_Id"].ToString().Trim(),
SortId = int.Parse(item["sort_Id"].ToString().Trim()),
IsBrand = item["Is_Brand"].ToString().Trim(),
BrandCode = item["BrandCode"].ToString().Trim(),
LinkUrl = item["link_url"].ToString().Trim()
};
if (item["img_url"].ToString().Trim() != "")
{
img.ImgUrl = webUrl + item["img_url"].ToString().Trim();
}
else
{
img.ImgUrl = "";
}
if (item["left_pic"].ToString().Trim() != "")
{
img.LeftPic = webUrl + item["left_pic"].ToString().Trim();
}
if (item["brand_img_url"].ToString().Trim() != "")
{
img.BrandImgUrl = webUrl + item["brand_img_url"].ToString().Trim();
}
else
{
img.BrandImgUrl = "";
}
img.SubTitle = item["sub_title"].ToString().Trim();
img.DrugSpec = item["drug_spec"].ToString().Trim();
img.DrugFactory = item["drug_factory"].ToString().Trim();
if (landing && !staleDated)
{
img.Price = BasisConfig.ObjToDecimal(item["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
}
else
{
img.Price = "会员可见";
}
img.Cxbs = item["cxbs"].ToString().Trim();
img.Fabh = item["fabh"].ToString().Trim();
source.Add(img);
}
imgList.ForEach(t => back.Add(t));
//已存在的品牌
var exist = imgList.Select(t => t.ArticleId).Distinct().ToList();
//移除已存在的品牌
source.RemoveAll(t => exist.Contains(t.ArticleId));
if (source.Count > 0)
{
int length = source.Count > len ? len : source.Count;
Random random = new Random();
int index = source.Count > len?random.Next(source.Count - len + 1) : 0;
source = source.GetRange(index, length);
source.ForEach(p => { back.Add(p); });
}
if (source.Count < len)
{
var placehold = XmlOperation.ReadXml("Base", "RecommendPicture");
for (int i = 0; i < len - source.Count; i++)
{
ImgInfo imgInfo = new ImgInfo
{
Entid = entId,
Title = "品牌推荐",
ArticleId = "",
SortId = 99,
IsBrand = "Y",
BrandCode = "",
LinkUrl = "",
ImgUrl = placehold,
LeftPic = "",
BrandImgUrl = placehold,
DrugFactory = "",
DrugSpec = "",
SubTitle = "",
Price = "",
Cxbs = "",
Fabh = ""
};
back.Add(imgInfo);
}
}
}
return(back);
}
/// <summary>
/// 获取数据返回数据列表
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string GetReturnJson(string json, string proc, string userId, string entid)
{
List <SqlParameter> listPrmt = new List <SqlParameter>();
JObject o = JObject.Parse(json);
IEnumerable <JProperty> properties = o.Properties();
bool flag = true;
foreach (JProperty item in properties)
{
if (item.Name.Trim() != "")
{
if (item.Name.ToString() == "Entid")
{
flag = false;
}
if (item.Name.ToString() == "PassWord")//密码md5加密
{
listPrmt.Add(new SqlParameter("@" + item.Name, Encryption.GetMD5_16(item.Value.ToString())));
}
else if (item.Name.ToString() == "XPassWord")//密码md5加密
{
listPrmt.Add(new SqlParameter("@" + item.Name, Encryption.GetMD5_16(item.Value.ToString())));
}
else
{
listPrmt.Add(new SqlParameter("@" + item.Name, item.Value.ToString().Trim() ?? ""));
}
}
}
if (userId != "")
{
listPrmt.Add(new SqlParameter("@UserId", userId));
}
if (entid != "" && flag == true)
{
listPrmt.Add(new SqlParameter("@entId", entid));
}
SqlParameter[] param = listPrmt.ToArray();//动态解析json参数
JObject obj = (JObject)JsonConvert.DeserializeObject(json);
string familyid = "";
if (obj["type"].ToString() == "GetAdminList")
{
familyid = Familylist(userId, entid);
Log.Info("家族主键", familyid);
}
if (familyid != "" && flag == true)
{
listPrmt.Add(new SqlParameter("@familyid", familyid));
}
//获取顶级以及最底层所有会员的状态
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet(proc, param);
string r_json;
if (ds.Tables.Count >= 3)
{
if (ds.Tables[1].Rows.Count > 0)
{
int recordCount = Convert.ToInt32(ds.Tables[2].Rows[0]["recordCount"].ToString().Trim());
int pageCount = Convert.ToInt32(ds.Tables[2].Rows[0]["pageCount"].ToString().Trim());
r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[1]);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
int recordCount = 0;
int pageCount = 0;
r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds.Tables[0]);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
}
return(r_json);
}
