/// <summary>
/// 获取新推送
/// <summary>
private void seachnewmessage(object sender)
{
Stop();
//获取推送编号
SqlParameter[] parameter_xh = new SqlParameter[]
{
new SqlParameter("@type", "查询新单据"),
};
DataTable dt_xh = db.RunProcedureDR("SK_App_GetNewPsd", parameter_xh);
if (dt_xh.Rows.Count == 0)
{
Log.Debug("推送获取编号详情", "无推送信息！");
}
else
{
foreach (DataRow dataRow in dt_xh.Rows)
{
string xh = dataRow["djbh"].ToString();
Log.Debug("推送获取编号详情", xh);
SeachNewOrder(xh);
}
}
Start();
}
/// <summary>
/// 选择商品组加入购物车
/// </summary>
/// <param name="entId">企业id</param>
/// <param name="userId">用户id</param>
/// <param name="quantity">数量</param>
/// <param name="fabh">促销方案编号</param>
/// <returns></returns>
public string CartAddGroup(string entId, string userId, decimal quantity, string fabh, out int flag, string bs, string cartType)
{
flag = 0;
string msg = "";
try
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "CartAddGroup"),
new SqlParameter("@entId", entId),
new SqlParameter("@userId", userId),
new SqlParameter("@quantity", quantity),
new SqlParameter("@fabh", fabh),
new SqlParameter("@bs", bs),
new SqlParameter("@carttype", cartType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_CartAdd", parameters);
if (table.Rows.Count > 0)
{
flag = int.Parse(table.Rows[0]["flag"].ToString());
msg = table.Rows[0]["msg"].ToString();
}
return(msg);
}
catch (Exception ex)
{
flag = 1;
return(ex.Message.ToString());
}
}
public funbool DelUserGroup(string usergroupid, string groupid)
{
sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR("PC_Group", new SqlParameter[] {
new SqlParameter("@type", "DelUserGroup"),
new SqlParameter("@UserGroupId", usergroupid),
new SqlParameter("@GroupId", groupid)
}
);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["flag"].ToString() == "1")
{
return(new funbool(true, dt.Rows[0]["msg"].ToString()));
}
else
{
return(new funbool(false, dt.Rows[0]["msg"].ToString()));
}
}
else
{
return(new funbool(false, "数据库未查出成功提示!"));
}
}
/// <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_GetType": //资质角色
foreach (DataRow dr_c1 in dtc.Rows)
{
objList += "<option value='" + dr_c1["TypeId"] + "'>" + dr_c1["Name"] + "</option>";
}
break;
default:
break;
}
}
return("{\"flag\":\"0\",\"objList\":\"" + objList + "\"}");
}
else
{
string error = "无数据";
return(JsonMethod.GetError(1, error));
}
}
/// <summary>
/// 验证客户资质
/// </summary>
/// <returns></returns>
protected string ReturnCheckKhZz(string json, string proc, string userId, string entid)
{
string r_json = "";
JObject list = (JObject)JsonConvert.DeserializeObject(json);
string khId = list["khId"].ToString();
string ywyId = list["ywyId"].ToString();
string hzId = list["hzId"].ToString();
string sqlType = list["type"].ToString();
string xentId = list["xentId"].ToString();
SqlRun sql = new SqlRun(SqlRun.sqlstr);
//验证客户资质
SqlParameter[] paramC = new SqlParameter[] {
new SqlParameter("@type", "CheckKh"),
new SqlParameter("@khId", khId),
new SqlParameter("@xentId", xentId)
};
DataTable dt = sql.RunProcedureDR("proc_Ywt_XsdInfo", paramC);
bool flag = false;
string msg = "";
if (dt.Rows.Count > 0)
{
//flag = int.Parse(dt.Rows[0]["flag"].ToString() ?? "1");
msg = dt.Rows[0]["msg"].ToString();
}
else
{
msg = dt.Rows[0]["msg"].ToString();
}
return(msg);
}
/// <summary>
/// 删除设备类型
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string GetDelTypeReturnJson(string userId, string entId, string id)
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_Coupon", new SqlParameter[] {
new SqlParameter("@type", "PC_DelType"),
new SqlParameter("@strWhere", id),
new SqlParameter("@entId", entId)
});
string r_json;
if (ds.Rows.Count > 0 && ds.Rows[0]["flag"].ToString() == "1")
{
r_json = JsonMethod.GetError(0, "删除成功");
}
else if (ds.Rows.Count > 0 && ds.Rows[0]["flag"].ToString() == "2")
{
string error = "无法删除，请清除所属优惠券";
r_json = JsonMethod.GetError(1, error);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 返回DataTable(商品分类)
/// </summary>
/// <returns></returns>
protected string GetSelectCategory()
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] {
new SqlParameter("@type", "PC_GetSelectCategory")
});
if (ds.Rows.Count > 0)
{
///加载商品分类
string category = "";
DataTable dtc = ds;
if (dtc.Rows.Count > 0)
{
foreach (DataRow dr_c1 in dtc.Rows)
{
category += "<option value='" + dr_c1["id"] + "'>" + dr_c1["title"] + "</option>";
}
}
return("{\"flag\":\"0\",\"category\":\"" + category + "\"}");
}
else
{
string error = "没有商品分类，请添加";
return(JsonMethod.GetError(1, error));
}
}
/// <summary>
/// 返回DataTable(商品组合)
/// </summary>
/// <returns></returns>
protected string GetSelectTemPro()
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] {
new SqlParameter("@type", "PC_GetSelectTemPro")
});
if (ds.Rows.Count > 0)
{
///加载商品组合
string prom = "";
DataTable dtc = ds;
if (dtc.Rows.Count > 0)
{
foreach (DataRow dr_c1 in dtc.Rows)
{
prom += "<option value='" + dr_c1["Id"] + "'>" + dr_c1["name"] + "</option>";
}
}
return("{\"flag\":\"0\",\"prom\":\"" + prom + "\"}");
}
else
{
string error = "没有主题商品组合，请添加";
return(JsonMethod.GetError(1, error));
}
}
/// <summary>
/// 再次购买
/// </summary>
/// <param name="userId">下单人Id</param>
/// <param name="entId">下单人机构</param>
/// <param name="billNo">再次购买商品的单号</param>
/// <param name="loginId">登陆人Id</param>
/// <param name="fabh"></param>
/// <param name="flag"></param>
/// <returns></returns>
public string OnceAgain(string userId, string entId, int billNo, string loginId, out bool flag, string jgjb, string khType, string cartType, string bs)
{
try
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "OnceAgain"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId),
new SqlParameter("@billNo", billNo),
new SqlParameter("@loginId", loginId),
new SqlParameter("@cartType", cartType),
new SqlParameter("@jgjb", jgjb),
new SqlParameter("@khType", khType),
new SqlParameter("@bs", bs)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR("Proc_OperationOrders", parameters);
if (dt.Rows.Count > 0)
{
flag = 0 == int.Parse(dt.Rows[0]["flag"].ToString()) ? true : false;
return(dt.Rows[0]["msg"].ToString());
}
else
{
flag = false;
return("订单存盘失败");
}
}
catch (Exception ex)
{
flag = false;
return(ex.Message.ToString());
}
}
/// <summary>
/// 返回DataTable(活动模板)
/// </summary>
/// <returns></returns>
protected string GetSelectTemplate()
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] {
new SqlParameter("@type", "PC_GetSelectTemplate")
});
if (ds.Rows.Count > 0)
{
///加载商品分类
string templatestr = "";
DataTable dtc = ds;
if (dtc.Rows.Count > 0)
{
foreach (DataRow dr_c1 in dtc.Rows)
{
templatestr += "<option value='" + dr_c1["TemplateCode"] + "'>" + dr_c1["TemplateName"] + "</option>";
}
}
return("{\"flag\":\"0\",\"templatestr\":\"" + templatestr + "\"}");
}
else
{
string error = "没有活动模板，请添加->上架";
return(JsonMethod.GetError(1, error));
}
}
/// <summary>
///获取单个组合信息
/// </summary>
/// <param name="entId">机构</param>
/// <param name="userId">用户</param>
/// <param name="fabh">活动编号</param>
/// <returns></returns>
public DataTable GetGroupInfo(string entId, string userId, string fabh)
{
///获取购物车商品列表
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetGroupOne"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entId),
new SqlParameter("@fabh", fabh)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR("Proc_PromotionInfo", param);
return(dt);
}
/// <summary>
/// 机构列表
/// </summary>
/// <returns></returns>
public List <Entdoc> EntdocList()
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "EntdocList")
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_OperationEntdoc", parameters);
List <Entdoc> list = new List <Entdoc>();
if (table.Rows.Count >= 0)
{
list = FillList(table);
}
return(list);
}
/// <summary>
/// 获取商品分类列表
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <returns></returns>
protected string GetGoodsCategory(string json, string proc, string userId, string entId)
{
SqlParameter[] param = (JsonMethod.ListParameter(json, userId, entId)).ToArray();//动态解析json参数
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR(proc, param);
string r_json;
if (dt.Rows.Count > 0)
{
r_json = JsonMethod.GoodsCategory(dt);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 返回活动模板
/// </summary>
/// <param name="templateName"></param>
/// <param name="isDel"></param>
/// <param name="status"></param>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
protected string GetTemplateDetail(string TemplateCode)
{
string r_json = "";
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_Template", new SqlParameter[] {
new SqlParameter("@type", "PC_GetTemplateDetail"),
new SqlParameter("@TemplateCode", TemplateCode)
});
if (ds.Rows.Count > 0)
{
r_json = ds.Rows[0]["txt"].ToString();
}
else
{
r_json = "";
}
return(r_json);
}
/// <summary>
/// 客户类型
/// </summary>
/// <returns></returns>
public List <ClintType> ClientType()
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "ClientType")
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls);
List <ClintType> types = new List <ClintType>();
if (table.Rows.Count > 0)
{
return(types = FillClientType(table));
}
else
{
return(types = null);
}
}
/// <summary>
/// 用户信贷
/// </summary>
/// <param name="userId">用户</param>
/// <param name="entId">机构</param>
/// <returns></returns>
public UserDebt DebtInfo(string userId, string entId)
{
//LogQueue.Write(LogType.Debug, "1", userId);
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "UserDebt"),
new SqlParameter("@userId", userId),
new SqlParameter("@entId", entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_UserInfo", sqls);
UserDebt debt = new UserDebt();
if (table.Rows.Count > 0)
{
debt = FillDebt(table);
}
return(debt);
}
/// <summary>
/// 获取多个表返回Json
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string ReturnDataTableJson(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);
DataTable table = sql.RunProcedureDR(proc, param);
if (table.Rows.Count > 0)
{
r_json = JsonMethod.DataTableToJson("0", table);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 商品首营图片
/// </summary>
/// <param name="goodsno">商品编号</param>
/// <returns></returns>
public List <ProductFirstCampPictures> ProductFirstCampPictures(string goodsno)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "ProductFirstCampPictures"),
new SqlParameter("@sqlvalue", goodsno)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable data = sql.RunProcedureDR("Proc_QualityInspection", sqls);
if (data.Rows.Count > 0)
{
return(ProductFirstCampPicturesFill(data));
}
else
{
return(null);
}
}
/// <summary>
/// APP个人中心数据
/// </summary>
/// <param name="entid"></param>
/// <returns></returns>
public List <AppModule> PerModule(string entid, string userId, string model)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "PersonerModule"),
new SqlParameter("@entid", entid),
new SqlParameter("@userId", userId),
new SqlParameter("@model", model)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
var dt = sql.RunProcedureDR("Proc_UserInfo", parameters);
List <AppModule> list = new List <AppModule>();
if (dt.Rows.Count > 0)
{
list = FillPerModule(dt);
}
return(list);
}
/// <summary>
/// 限时抢购
/// </summary>
/// <param name="entId">机构</param>
/// <param name="userId">用户</param>
/// <param name="promType">活动类型</param>
/// <param name="jgjb">价格级别</param>
/// <param name="khType">客户类型</param>
/// <param name="staleDated">证书是否过期</param>
/// <param name="landing">是否登录</param>
/// <returns></returns>
public List <PromFlashSale> GetPromFlashSale(string entId, string userId, string promType, string jgjb, string khType, bool landing, bool staleDated)
{
///获取单品促销信息
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetFlashSale"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entId),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@promType", promType),
new SqlParameter("@khlb", khType),
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR("Proc_PromotionInfo", param);//源数据
#region 重写
string now = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
//获取正在进行的商品组
DataRow[] begin = dt.Select(" startDate <= '" + now + "' and endDate > '" + now + "' ");
//LogQueue.Write(LogType.Debug, "正在进行", $"{begin.Length},now:{now}");
DataTable dtBegin = dt.Clone();
foreach (DataRow item in begin)
{
dtBegin.ImportRow(item);
}
//还未开始的商品组
DataRow[] after = dt.Select(" startDate > '" + now + "'");
//LogQueue.Write(LogType.Debug, "还未开始", $"{after.Length},now:{now}");
DataTable dtAfter = dt.Clone();
foreach (DataRow item in after)
{
dtAfter.ImportRow(item);
}
List <PromFlashSale> list = new List <PromFlashSale>();
if (dt.Rows.Count > 0)
{
list = SetDate(dtBegin, dtAfter, landing, staleDated);
}
return(list);
#endregion
}
/// <summary>
/// 返回模板绑定
/// </summary>
/// <param name="templateName"></param>
/// <param name="isDel"></param>
/// <param name="status"></param>
/// <param name="page"></param>
/// <param name="size"></param>
/// <returns></returns>
protected string GetTemplateRelationDetail(string TemplateCode)
{
string r_json = "";
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_TemplateRelation", new SqlParameter[] {
new SqlParameter("@type", "PC_GetTemplateRelationDetail"),
new SqlParameter("@TemplateRelationCode", TemplateCode)
});
if (ds.Rows.Count > 0)
{
r_json = JsonMethod.GetDataTable(0, ds.Rows.Count, 1, ds);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 资料类型
/// </summary>
/// <returns></returns>
public List <UserMaterial> MaterialType(string customerType)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "MaterialType"),
new SqlParameter("@customerType", customerType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls);
List <UserMaterial> types = new List <UserMaterial>();
if (table.Rows.Count > 0)
{
return(types = FillMaterial(table));
}
else
{
return(types = null);
}
}
/// <summary>
/// 购物车选中商品
/// </summary>
/// <param name="entId"></param>
/// <param name="userId"></param>
/// <param name="goodsList"></param>
/// <param name="jgjb"></param>
/// <returns></returns>
public List <CartGoods> CartList(string entId, string userId, string goodsList, string jgjb)
{
///获取购物车商品列表
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@Type", "GetCartList"),
new SqlParameter("@UserId", userId),
new SqlParameter("@Entid", entId),
new SqlParameter("@Jgjb", jgjb),
new SqlParameter("@List", goodsList)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_CartList", param);
List <CartGoods> list = new List <CartGoods>();
if (table.Rows.Count > 0)
{
list = FillList(table);
}
return(list);
}
/// <summary>
/// 充值方式
/// </summary>
/// <param name="entId">机构</param>
/// <returns></returns>
public List <Payment> PayTypes(string entId)
{
SqlParameter[] sqls = new SqlParameter[]
{
new SqlParameter("@type", "PayTypes"),
new SqlParameter("@entId", entId)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_OperationRecharge", sqls);
List <Payment> payApis = new List <Payment>();
if (table.Rows.Count > 0)
{
return(payApis = FillPayApi(table));
}
else
{
return(payApis = null);
}
}
/// <summary>
/// 检测用户的角色权限
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entId"></param>
/// <returns></returns>
protected string GetRoleJson(string json, string proc, 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);
string r_json;
if (ds.Rows.Count > 0)
{
int recordCount = 0;
int pageCount = 0;
r_json = JsonMethod.GetDataTable(0, recordCount, pageCount, ds);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 更新数据库的数据，返回一个表
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <returns></returns>
protected string GetReturnDs(string json, string proc, string UserId, string entid)
{
SqlParameter[] param = (JsonMethod.ListParameter(json, UserId, entid)).ToArray();//动态解析json参数
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR(proc, param);
string r_json;
if (dt.Rows.Count > 0)
{
int flag = int.Parse(dt.Rows[0]["flag"].ToString() ?? "1");
string msg = dt.Rows[0]["msg"].ToString();
r_json = JsonMethod.GetError(flag, msg);
}
else
{
string msg = dt.Rows[0]["msg"].ToString();
r_json = JsonMethod.GetError(1, msg);
}
return(r_json);
}
/// <summary>
/// 主题接口
/// </summary>
/// <returns></returns>
public JsonResult GetTemplateList(string entId, string userId)
{
try {
if (string.IsNullOrEmpty(userId))
{
return(Json(new { success = false, message = "用户未登录，请先登录" }));
}
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RunProcedureDR("Pc_TemplateRelation", new SqlParameter[]
{
new SqlParameter("@type", "CX_GetTemplateList"),
new SqlParameter("@entId", entId)
});
return(Json(JsonMethod.DataTableToJson("1", dt)));
}
catch (Exception ex)
{
LogQueue.Write(LogType.Error, "Template/GetTemplateList", ex.Message.ToString());
return(Json(new { success = false, message = "商城主题加载失败" }));
}
}
/// <summary>
/// 注册手机号验证
/// </summary>
/// <param name="telphone">手机号</param>
/// <returns></returns>
public int PhoneVerify(string telphone, out string entId)
{
entId = "";
SqlParameter[] sqls = new SqlParameter[] {
new SqlParameter("@type", "PhoneVerify"),
new SqlParameter("@telphone", telphone)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable table = sql.RunProcedureDR("Proc_OperationUser", sqls);
if (table.Rows.Count > 0)
{
entId = table.Rows[0]["entid"].ToString();
return(int.Parse(table.Rows[0]["status"].ToString()));
}
else
{
entId = "";
return(9999);
}
}
/// <summary>
/// 返回DataTable(规则详情)
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="userId"></param>
/// <param name="entid"></param>
/// <returns></returns>
protected string GeTypeDetailReturnJson(string userId, string entId, string id)
{
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable ds = sql.RunProcedureDR("Pc_Coupon", new SqlParameter[] {
new SqlParameter("@type", "PC_GetTypeDetail"),
new SqlParameter("@strWhere", id),
new SqlParameter("@entId", entId)
});
string r_json;
if (ds.Rows.Count > 0)
{
r_json = JsonMethod.GetDataTable(0, ds.Rows.Count, 1, ds);
}
else
{
string error = "无数据";
r_json = JsonMethod.GetError(1, error);
}
return(r_json);
}
/// <summary>
/// 删除购物车商品
/// </summary>
/// <param name="dltType">删除类型</param>
/// <param name="entId">企业Id</param>
/// <param name="userId">用户id</param>
/// <param name="cartId">购物车Id</param>
/// <returns></returns>
public bool DeleteCart(string entId, string userId, string dltType, string cartId, string cartType, string ywyId)
{
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter("@type", "CartDelete"),
new SqlParameter("@userId", userId),
new SqlParameter("@ywyId", ywyId),
new SqlParameter("@entId", entId),
new SqlParameter("@dltType", dltType),
new SqlParameter("@cartId", cartId),
new SqlParameter("@cartType", cartType)
};
SqlRun sql = new SqlRun(SqlRun.sqlstr);
bool flag = false;
DataTable table = sql.RunProcedureDR("Proc_CartAdd", parameters);
if (table.Rows.Count > 0)
{
flag = int.Parse(table.Rows[0]["flag"].ToString()) == 0 ? true : false;
}
return(flag);
}
