/// <summary>
/// 结算可用优惠券
/// </summary>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <param name="goodsList"></param>
/// <returns></returns>
public List <UserCoupon> UsableCoupon(string userId, string entId, string goodsList, int pageIndex, int pageSize, string ywyId, out int pageCount, out int recordCount, string channelName, string Pricelevel, string clientType, decimal OrdersAmount, decimal RealAmount, decimal DiscountAmount, decimal PtAmount)
{
pageCount = 0; recordCount = 0;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "UsableCoupon"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@ywyId", ywyId),
new SqlParameter("@goodsList", goodsList),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@channelName", channelName),
new SqlParameter("@jgjb", Pricelevel),
new SqlParameter("@clientType", clientType),
new SqlParameter("@ordersAmount", OrdersAmount),
new SqlParameter("@realAmount", RealAmount),
new SqlParameter("@discountAmount", DiscountAmount),
new SqlParameter("@ptAmount", PtAmount)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var list = new List <UserCoupon>();
DataSet 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());
if (set.Tables[1].Rows.Count > 0)
{
list = FillUableList(set.Tables[1]);
}
}
return(list);
}
/// <summary>
/// 首营商品
/// </summary>
/// <param name="goods">商品</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">容量</param>
/// <param name="pageCount">页数</param>
/// <param name="recordCount">条目数</param>
/// <returns></returns>
public List <ProductFirstCamp> ProductFirstCamps(string goods, int pageIndex, int pageSize, out int pageCount, out int recordCount)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "OrdersQuality"),
new SqlParameter("@sqlvalue", goods),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_QualityInspection", sqls);
pageCount = 0;
recordCount = 0;
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());
return(ProductFirstCampsFill(set.Tables[1]));
}
else
{
return(null);
}
}
/// <summary>
/// 获取促销专区信息
/// </summary>
/// <param name="entId"></param>
/// <param name="userId"></param>
/// <param name="jgjb"></param>
/// <param name="khType"></param>
/// <returns></returns>
public List <PromList> GetTopPromSingle(string entId, string userId, string promType, string jgjb, string khType, /*int num*/ int pageIndex, int pageSize, bool landing, bool staleDated, out int recordCount, out int pageCount)
{
recordCount = 0;
pageCount = 0;
///获取单品促销信息
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetTopPromSingle"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entId),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@promType", promType),
new SqlParameter("@khlb", khType),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProDataSet("Proc_PromotionInfo", param);
List <PromList> list = new List <PromList>();
if (ds.Tables.Count > 0)
{
list = SetPromSingle(ds.Tables[1], landing, staleDated);
recordCount = int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString());
pageCount = int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString());
}
return(list);
}
public string SettleAccounts(string goodsidStr, int num, string userid, string entid, string zjf, string address, string contact, string phone, string remarks)
{
string result;
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_Premiun_JieSuan",
new SqlParameter[] {
new SqlParameter("@type", "jiesuan"),
new SqlParameter("@contact", contact),
new SqlParameter("@phone", phone),
new SqlParameter("@remarks", remarks),
new SqlParameter("@goodsid", goodsidStr),
new SqlParameter("@num", num),
new SqlParameter("@userid", userid),
new SqlParameter("@entid", entid),
new SqlParameter("@totaljf", zjf),
new SqlParameter("@address", address)
}
);
if (ds.Tables[0].Rows.Count > 0)
{
var djbh = ds.Tables[0].Rows[0][0].ToString();
var msg = "您的单据编号为：" + djbh + ",此礼品将会随同订购药品一同配送，如此次单独兑换礼品则该礼品随同下次订购药品一同配送.。";
result = "{\"return_code\":\"0\",\"msg\":\"结算成功," + msg + "\"}";
}
else
{
result = "{\"return_code\":\"1\",\"msg\":\"结算失败\"}";
}
return(result);
}
/// <summary>
///
/// </summary>
/// <param name="userId">用户</param>
/// <param name="ArrondiType">诊所专区0/药店专区1</param>
/// <param name="num">显示条目数</param>
/// <param name="entId">机构</param>
/// <param name="Pricelevel">价格级别</param>
/// <returns></returns>
public List <PromList> GetPharmacyList(string entId, string userId, string ArrondiType, string Pricelevel, string KhType, /*int num,*/ int pageIndex, int pageSize, bool landing, bool staleDated, out int recordCount, out int pageCount)
{
recordCount = 0;
pageCount = 0;
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "SaleArrondi"),
new SqlParameter("@entId", entId),
new SqlParameter("@userId", userId),
new SqlParameter("@jgjb", Pricelevel),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@khlb", KhType),
new SqlParameter("@ArrondiType", ArrondiType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProDataSet("Proc_PromotionInfo", parameters);
List <PromList> lists = new List <PromList>();
if (ds.Tables.Count > 0)
{
lists = SetPromSingle(ds.Tables[1], landing, staleDated);
recordCount = int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString());
pageCount = int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString());
}
return(lists);
}
/// <summary>
/// 获取自定义数据源，根据自定义SQL语句,带分页
/// </summary>
/// <param name="sql">数据源SQL语句</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">单页数据量</param>
/// <param name="total">总数据量</param>
/// <returns></returns>
public DataSet GetCustomSQLData(string sql, int pageIndex, int pageSize, ref int recordCount, ref int pageCount)
{
SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr);
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@sql", sql),
new SqlParameter("@page", pageIndex),
new SqlParameter("@pagesize", pageSize),
new SqlParameter("@pageCount", 0), //总页数
new SqlParameter("@recordCount", 0), //总记录数
new SqlParameter("@SearchTime", 0) //执行时间 毫秒
};
sqlParams[3].Direction = ParameterDirection.Output;
sqlParams[4].Direction = ParameterDirection.Output;
sqlParams[5].Direction = ParameterDirection.Output;
DataSet dataSet = sqlhelper.RunProDataSet("Paging", sqlParams);
recordCount = Convert.ToInt32(sqlParams[4].Value);
pageCount = Convert.ToInt32(sqlParams[3].Value);
for (int i = 0; i < dataSet.Tables.Count; i++)
{
dataSet.Tables[i].Columns.Remove("ROWSTAT");
}
return(dataSet);
}
/// <summary>
/// 充值退款记录
/// </summary>
/// <param name="userId">用户</param>
/// <param name="entId">机构</param>
/// <param name="payment">支付方式 微信/支付宝/All</param>
/// <param name="operation">操作类型 1充值/0退款/99全部</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="pageSize">单页条目数</param>
/// <param name="pageCount">输出参数 总页数</param>
/// <param name="recordCount">输出参数 总条目数</param>
/// <returns></returns>
public List <RechargeOrders> RechargeRecord(string userId, string entId, string payment, int operation, int pageIndex, int pageSize, out int pageCount, out int recordCount)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "RechargeRecord"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@payment", payment),
new SqlParameter("@operation", operation),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_OperationRecharge", sqls);
List <RechargeOrders> rechargeOrders = new List <RechargeOrders>();
if (set.Tables.Count > 0)
{
rechargeOrders = FillRechargeRecord(set.Tables[1]);
pageCount = int.Parse(set.Tables[2].Rows[0]["pageCount"].ToString());
recordCount = int.Parse(set.Tables[2].Rows[0]["recordCount"].ToString());
}
else
{
pageCount = 1;
recordCount = 0;
rechargeOrders = null;
}
return(rechargeOrders);
}
/// <summary>
/// 用户充值红包
/// </summary>
/// <param name="userId">用户</param>
/// <param name="entId">机构</param>
/// <param name="target">目标 unused[未使用]/used[已使用]</param>
/// <param name="money">金额</param>
/// <param name="normal">true[正常]/false[超期异常]</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="pageSize">单页数目</param>
/// <param name="pageCount">返回总页数</param>
/// <param name="recordCount">返回总条目数</param>
/// <returns></returns>
public List <Bonus> RedEnvelopes(string userId, string entId, string target, decimal money, string normal, int pageIndex, int pageSize, out int pageCount, out int recordCount)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "rechargeBonus"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@target", target),
new SqlParameter("@money", money),
new SqlParameter("@normal", normal),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
pageCount = 1;
recordCount = 0;
DataSet set = sql.RunProDataSet("Proc_OperationRecharge", sqls);
List <Bonus> bonus = new List <Bonus>();
if (set.Tables.Count > 0)
{
bonus = FillBonus(set.Tables[1]);
pageCount = int.Parse(set.Tables[2].Rows[0]["pageCount"].ToString());
recordCount = int.Parse(set.Tables[2].Rows[0]["recordCount"].ToString());
}
else
{
bonus = null;
}
return(bonus);
}
/// <summary>
/// 积分商城首页楼层及楼层所有数据
/// </summary>
/// <param name="entId">机构</param>
/// <param name="flootType">楼层 Office【办公用品】/Electrical【家用电器】/Supplies【生活用品】/HotFor【热门兑换】亦可传空获取所有楼层，但传空时num>0</param>
/// <param name="num">前n条</param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="pageCount"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public List <IndexFloor> IntegralFloor(string entId, string flootType, int num, int pageIndex, int pageSize, out int pageCount, out int recordCount)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@Type", "IndexIntegral"),
new SqlParameter("@FootFLId", flootType),
new SqlParameter("@EntId", entId),
new SqlParameter("@Num", num),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@PageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_PremiunAdmin", sqls);
List <IndexFloor> integralGoods = new List <IndexFloor>();
pageCount = 1;
recordCount = 0;
if (set.Tables.Count > 0)
{
integralGoods = FillIntegralGoods(set.Tables[1]);
pageCount = int.Parse(set.Tables[2].Rows[0]["pageCount"].ToString());
recordCount = int.Parse(set.Tables[2].Rows[0]["recordCount"].ToString());
}
else
{
integralGoods = null;
}
return(integralGoods);
}
/// <summary>
/// PC积分商城下一批
/// </summary>
/// <param name="entId"></param>
/// <param name="flootType"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="pageCount"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public List <ImgInfo> NextGroup(string entId, string flootType, int pageIndex, int pageSize, out int pageCount, out int recordCount)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@Type", "NextGroup"),
new SqlParameter("@FootFLId", flootType),
new SqlParameter("@EntId", entId),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@PageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_PremiunAdmin", sqls);
pageCount = 1;
recordCount = 0;
List <ImgInfo> imgInfos = new List <ImgInfo>();
if (set.Tables.Count > 0)
{
imgInfos = FillNextGroup(set.Tables[1]);
pageCount = int.Parse(set.Tables[2].Rows[0]["pageCount"].ToString());
recordCount = int.Parse(set.Tables[2].Rows[0]["recordCount"].ToString());
}
else
{
imgInfos = null;
}
return(imgInfos);
}
/// <summary>
/// 代课下单客户
/// </summary>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <param name="isjh"></param>
/// <param name="isxs"></param>
/// <param name="strWhere"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="recordCount"></param>
/// <param name="pageCount"></param>
/// <returns></returns>
public List <Business> ClientList(string userId, string entId, string isjh, string isxs, string strWhere, int pageIndex, int pageSize, out int recordCount, out int pageCount)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "ClientList"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@strWhere", strWhere),
new SqlParameter("@isjh", isjh),
new SqlParameter("@isxs", isxs),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set;
set = sql.RunProDataSet("Proc_OperationBusiness", parameters);
List <Business> list = new List <Business>();
recordCount = 0; pageCount = 0;
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());
if (set.Tables[1].Rows.Count > 0)
{
list = FillList(set.Tables[1]);
}
}
return(list);
}
/// <summary>
/// 获取品牌信息
/// </summary>
/// <param name="entId"></param>
/// <param name="userId">用户Id</param>
/// <param name="jgjb">价格级别</param>
/// <param name="khType">客户类型</param>
/// <param name="khType">客户类型</param>
/// <param name="khType">客户类型</param>
/// <param name="khType">客户类型</param>
/// <returns></returns>
public List <BrandList> GetBrandList(string entId, string userId, string jgjb, string khType, bool landing, bool staleDated, string faType, string billno, int pageIndex, int pageSize, out int ecordCount, out int pageCount)
{
ecordCount = 0;
pageCount = 0;
///获取单品促销信息
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetBrandList"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entId),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@khlb", khType),
new SqlParameter("@faType", faType),
new SqlParameter("@billno", billno),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_BrandList", param);
List <BrandList> list = new List <BrandList>();
if (ds.Tables[0].Rows.Count > 0)
{
list = SetBrand(ds, landing, staleDated);
ecordCount = int.Parse(ds.Tables[3].Rows[0]["recordCount"].ToString());
pageCount = int.Parse(ds.Tables[3].Rows[0]["pageCount"].ToString());
}
return(list);
}
/// <summary>
/// 订单汇总下载质检
/// </summary>
/// <param name="startDate">开始时间</param>
/// <param name="endDate">结束时间</param>
/// <param name="order">单据编号</param>
/// <returns></returns>
public List <OrdersQuality> OrdersQuality(string startDate, string endDate, string order, int pageIndex, int pageSize, out int pageCount, out int recordCount)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "OrdersQuality"),
new SqlParameter("@ksrq", startDate),
new SqlParameter("@jsrq", endDate),
new SqlParameter("@sqlvalue", order),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_QualityInspection", sqls);
pageCount = 0;
recordCount = 0;
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());
return(OrdersQualityFill(set.Tables[1]));
}
else
{
return(null);
}
}
/// <summary>
/// 管理员登陆
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <returns></returns>
protected string UserLogin(string json, string proc, HttpContext context)
{
string r_json = "";
JObject obj = (JObject)JsonConvert.DeserializeObject(json);
var admincode = obj["code"].ToString();
//Log.Debug("登录回传验证码：", admincode);
var code = context.Session["AdminLognCode"];
//Log.Debug("后台保存二维码：", code.ToString());
if (string.IsNullOrEmpty(admincode) || code == null || code.ToString().ToLower() != admincode.ToLower())
{
return(JsonMethod.GetError(1, "验证码不正确！"));
}
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", obj["type"].ToString()),
new SqlParameter("@username", obj["username"].ToString()),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet(proc, param);
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
var pass = Encryption.GetMD5_16(obj["password"].ToString().ToString());
if (dt.Rows[0]["password"].ToString() == Encryption.GetMD5_16(obj["password"].ToString().ToString()))
{
context.Session.Timeout = 500;
//DataTable dq = ds.Tables[1];
context.Session["user"] = dt;
//context.Session["userId"] = dt.Rows[0]["userId"].ToString();
//context.Session["entId"] = dt.Rows[0]["entId"].ToString();
//context.Session["name"] = dt.Rows[0]["name"].ToString();
//context.Session["password"] = dt.Rows[0]["password"].ToString();
//context.Session["roleId"] = dt.Rows[0]["role_id"].ToString();
//context.Session["roleType"] = dt.Rows[0]["role_type"].ToString();
//context.Session["username"] = dt.Rows[0]["username"].ToString();
context.Session["role"] = null;// DateTableTool.DataTableToList<Rolestr>(dq).Select(a=>a.power).ToList();
//RoleFuns.AddAdminLoginLog(dt.Rows[0]["username"].ToString(), context.Request.ServerVariables.Get("REMOTE_ADDR").ToString(), context.Request.ServerVariables.Get("REMOTE_PORT").ToString());
r_json = JsonMethod.GetError(0, "登陆成功");
}
else
{
r_json = JsonMethod.GetError(1, "密码错误");
}
}
else
{
r_json = JsonMethod.GetError(1, "该账号不存在");
}
return(r_json);
}
/// <summary>
/// 代客下单获取会员信息
/// </summary>
/// <param name="userId">业务员Id</param>
/// <param name="strWhere">条件</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页容</param>
public ValetOrderModel <ValetOrder_MemberList> GetMemberList(string ywyId, string strWhere, int pageIndex, int pageSize)
{
ValetOrderModel <ValetOrder_MemberList> mode = new ValetOrderModel <ValetOrder_MemberList>();
mode.PageIndex = pageIndex;
mode.PageSize = pageSize;
try
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "GetSalesManList"),
new SqlParameter("@ywyId", ywyId),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize),
new SqlParameter("@strWhere", strWhere)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("proc_dkxd_GetInfo", param);
int pageCount = 0, recordCount = 0;
DataTable dt = new DataTable();
if (ds.Tables.Count >= 3)
{
pageCount = Int32.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString());
recordCount = Int32.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString());
dt = ds.Tables[1];
}
else if (ds.Tables.Count == 1)
{
pageCount = 1;
recordCount = ds.Tables[0].Rows.Count;
dt = ds.Tables[0];
}
mode.PageCount = pageCount;
mode.RecordCount = recordCount;
if (dt.Rows.Count > 0)
{
mode.Success = "000";
mode.Message = "成功";
mode.Data = SetMemberList(dt);
}
else
{
mode.Success = "001";
mode.Message = "成功,暂无数据";
}
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "ValetOrder/GetMemberList", ex.Message.ToString());
mode.Success = "002";
mode.Message = "错误," + ex.Message.ToString();
}
return(mode);
}
/// <summary>
/// 华烁获取质检报告数据列表
/// </summary>
/// <param name="type"></param>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <param name="sqlValue"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <returns></returns>
public DataSet GetQualityList(string type, string userId, string entId, string sqlValue, int pageIndex, int pageSize)
{
SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr);
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@sqlValue", sqlValue),
new SqlParameter("@pageIndex", pageIndex),
new SqlParameter("@pageSize", pageSize)
};
DataSet dataSet = sqlhelper.RunProDataSet("Proc_QualityInspectionDown", sqlParams);
return(dataSet);
}
/// <summary>
/// 获取配送方式信息
/// </summary>
/// <param name="enable">是否启用</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">单页条目</param>
/// <param name="recordCount">总条目</param>
/// <param name="pageCount">总页数</param>
/// <returns>集合List<Payment></returns>
public List <Dispatch> QueryPriceLevel(string enable)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@type", "QueryDispatch"),
new SqlParameter("@enable", enable)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_OperationDispatch", parameters);
List <Dispatch> dispatch = new List <Dispatch>();
if (set.Tables[0].Rows.Count >= 0)
{
dispatch = FillList(set.Tables[0]);
}
return(dispatch);
}
public List <IndexFloor> GetZQIndexFloor(string userId, string entId)
{
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "PrefectureRecommend"),
new SqlParameter("@EntId", entId)
};
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 = PrefectureFillFloor(ds.Tables[0], entId);
}
return(list);
}
/// <summary>
/// 获取大宗商品阶梯价格
/// </summary>
/// <param name="entid">机构ID</param>
/// <param name="article_id">文章ID</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="pageSize">单页条目</param>
/// <param name="recordCount">总条目</param>
/// <param name="pageCount">总页数</param>
/// <returns>集合List<CLPrice></returns>
public List <CLPrice> QueryCLPrice(string entid, int article_id)
{
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@type", "QueryCLPrice"),
new SqlParameter("@entid", entid),
new SqlParameter("@article_id", article_id)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet set = sql.RunProDataSet("Proc_OperationCLPrice", parameters);
List <CLPrice> cLPrices = new List <CLPrice>();
if (set.Tables.Count >= 1)
{
cLPrices = FillList(set.Tables[0]);
}
return(cLPrices);
}
//public List<IndexFloor> PrefectureParatope(List<IndexFloor> list,string entId)
//{
// SqlParameter[] param = new SqlParameter[]{
// new SqlParameter("@type","PrefectureParatope"),
// new SqlParameter("@EntId",entId)
// };
// SqlRun sql = new SqlRun(SqlRun.sqlstr);
// var dt = sql.RunProcedureDR("Proc_GoodsList", param);
//}
#endregion
#region App模块
/// <summary>
/// App模块
/// </summary>
/// <param name="entid"></param>
/// <returns></returns>
public Information AppModule(string entid)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "CarouselOrModule"),
new SqlParameter("@entid", entid)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var ds = sql.RunProDataSet("Proc_GoodsList", parameters);
Information list = new Information();
if (ds.Tables.Count > 0)
{
list = FillList(ds);
}
return(list);
}
/// <summary>
/// 加载商品选项分类/属性/状态
/// </summary>
/// <returns></returns>
protected string LoadCheckBox(string json, string proc, string userId, string entId, HttpContext context)
{
string checkType = context.Request.QueryString["CheckType"];
SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entId)).ToArray();//动态解析json参数
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet(proc, param);
///加载商品分类
string categoryList = "";
DataTable dtc = ds.Tables[0];
if (dtc.Rows.Count > 0)
{
DataRow[] drc_1 = dtc.Select("class_layer=1", "sort_id asc");
foreach (DataRow dr_c1 in drc_1)
{
categoryList += "<option value='" + dr_c1["id"] + "'>" + dr_c1["title"] + "</option>";
DataRow[] drc_2 = dtc.Select("class_layer=2 and parent_id=" + dr_c1["id"] + " ", "sort_id asc");
foreach (DataRow dr_c2 in drc_2)
{
categoryList += "<option value='" + dr_c2["id"] + "'> ├" + dr_c2["title"] + "</option>";
}
}
}
///加载商品属性
string attributeList = "";
int no = 0;
DataTable dta = ds.Tables[1];
if (dta.Rows.Count > 0)
{
foreach (DataRow dr_a in dta.Rows)
{
if (checkType == "CheckBox")
{
attributeList += "<div class='radio-box'><input name='isRecommend' type='checkbox' id='tjCheck_" + no + "' value='" + dr_a["id"] + "' ><label for='status-" + no + "'>" + dr_a["title"] + "</label></div>";
}
else
{
attributeList += "<option value='" + dr_a["id"] + "'>" + dr_a["title"] + "</option>";
}
no++;
}
}
return("{\"flag\":\"0\",\"categoryList\":\"" + categoryList + "\",\"attributeList\":\"" + attributeList + "\"}");
}
/// <summary>
/// 获取多个表返回Json
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string ReturnDataSetJson(string json, string proc, string userId, string entId)
{
SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entId)).ToArray();//动态解析json参数
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet(proc, param);
string r_json;
if (ds.Tables.Count > 0)
{
r_json = JsonMethod.DataSetToJson("0", ds);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 获取积分
/// </summary>
public string GetJF(string type, string userid, string entId)
{
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)
});
if (ds.Tables[0].Rows.Count > 0)
{
msg = JsonHelper.GetDataJson(0, 0, 0, ds.Tables[0]);
}
else
{
msg = JsonHelper.GetErrorJson(1, 0, "暂无数据");
}
return(msg);
}
/// <summary>
/// 返回模板绑定
/// </summary>
/// <param name="templateName"></param>
/// <param name="status"></param>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
protected string GetTemplateRelationReturnJson(string templateName, string status, int type, int page = 1, int size = 30)
{
string r_json = "";
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Pc_TemplateRelation", new SqlParameter[] {
new SqlParameter("@type", "PC_GetTemplateRelationList"),
new SqlParameter("@TemplateRelationName", templateName),
new SqlParameter("@TypeCode", type),
new SqlParameter("@Status", status),
new SqlParameter("@PageIndex", page),
new SqlParameter("@PageSize", size)
});
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);
}
/// <summary>
/// 单个优惠券信息
/// </summary>
/// <param name="entId"></param>
/// <param name="userId"></param>
/// <param name="couponId"></param>
/// <returns></returns>
public List <Coupon> SingleCoupon(string entId, string userId, string couponId)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "SingleCoupon"),
new SqlParameter("@entId", entId),
new SqlParameter("@userId", userId),
new SqlParameter("@couponId", couponId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var list = new List <Coupon>();
var set = sql.RunProDataSet("Proc_OperationCoupon", parameters);
if (set.Tables.Count > 0)
{
list = FillList(set.Tables[0]);
}
return(list);
}
/// <summary>
/// 加入购物车&&删除商品&&修改数量
/// </summary>
/// <param name="entId">机构</param>
/// <param name="goodsId">积分商品</param>
/// <param name="num">商品数量</param>
/// <param name="type">操作类型</param>
/// <param name="userid">用户</param>
public int AddGwc(string type, string userid, string goodsId, string entId, decimal num)
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_Premiun_details", new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@shl", num),
new SqlParameter("@goodsid", goodsId),
new SqlParameter("@userid", userid),
new SqlParameter("@entId", entId)
});
if (ds.Tables[0].Rows.Count > 0)
{
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 获取地址
/// </summary>
/// <param name="type">操作类型</param>
/// <param name="userid">用户</param>
/// <param name="entId">机构</param>
/// <returns></returns>
public string GetAddress(string type, string userid, string entId)
{
string json = "";
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet ds = sql.RunProDataSet("Proc_Premiun_details", new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@userid", userid),
new SqlParameter("@entId", entId)
});
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="userId">用户ID</param>
/// <returns></returns>
public List <UserInfo> GetUserInfo(string userId, string entId)
{
DataSet ds = new DataSet();
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@type", "UserInfo"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
ds = sql.RunProDataSet("Proc_UserInfo", param);
List <UserInfo> Ulist = new List <UserInfo>();
if (ds.Tables[0].Rows.Count > 0)
{
Ulist = SetUserInfo(ds.Tables[0], ds.Tables[1]);
}
return(Ulist);
}
/// <summary>
/// 获取自定义表单列表
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="souStr"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public DataTable GetCustomList(int pageIndex, int pageSize, string souStr, ref int recordCount)
{
SqlRun sqlhelper = new SqlRun(SqlRun.sqlstr);
SqlParameter[] sqlParams = new SqlParameter[] {
new SqlParameter("@SouStr", souStr),
new SqlParameter("@PageIndex", pageIndex),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@PageCount", 0),
new SqlParameter("@RecordCount", 0),
new SqlParameter("@SearchTime", 0)
};
sqlParams[3].Direction = ParameterDirection.Output;
sqlParams[4].Direction = ParameterDirection.Output;
sqlParams[5].Direction = ParameterDirection.Output;
DataSet dataSet = sqlhelper.RunProDataSet("Proc_CustomForm_List", sqlParams);
recordCount = Convert.ToInt32(sqlParams[4].Value);
return(dataSet.Tables[1]);
}
/// <summary>
/// 获取推荐商品
/// </summary>
public string GetGoods(string type, string entId, int page)
{
var msg = "";
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataSet dt = sql.RunProDataSet("Proc_Premiun_details", new SqlParameter[] {
new SqlParameter("@type", type),
new SqlParameter("@page", page),
new SqlParameter("@entId", entId)
});
if (dt.Tables[0].Rows.Count > 0)
{
msg = JsonHelper.GetDataJson(0, int.Parse(dt.Tables[1].Rows[0][0].ToString()), 0, dt.Tables[0]);
}
else
{
msg = JsonHelper.GetErrorJson(1, 0, "暂无数据");
}
return(msg);
}