/// <summary>
/// 网站设置修改
/// </summary>
/// <param name="json"></param>
/// <param name="proc"></param>
/// <param name="UserId"></param>
/// <param name="entId"></param>
/// <returns></returns>
protected string SaveBase(string json, string proc, string UserId, string entId)
{
JObject obj = (JObject)JsonConvert.DeserializeObject(json);
///修改webconfig节点
BasisConfig.UpdateAppSetting("SercerIp", obj["ip"].ToString());
StringBuilder strSql = new StringBuilder();
//修改商品主表
strSql.Append("select entid from dt_system_base(nolock) where entid='" + entId + "'");
SqlRun sql = new SqlRun(SqlRun.sqlstr);
DataTable dt = sql.RtDataTable(strSql.ToString());
//清空StringBuilder
strSql.Length = 0;
if (dt.Rows.Count > 0)
{
strSql.Append("update dt_system_base set web_name=@web_name,web_ip=@web_ip,company=@company,complaints=@complaints,xxjyz=@xxjyz,xxfwz=@xxfwz,icp=@icp,beizhu=@beizhu,img_app=@img_app,img_logo=@img_logo,img_left=@img_left,img_right=@img_right,img_service=@img_service,link_service=@link_service where entid=@entid");
}
else
{
strSql.Append("insert into dt_system_base(entId,web_name,web_ip,company,complaints,xxjyz,xxfwz,icp,beizhu,img_app,img_logo,img_left,img_right,img_service,link_service) ");
strSql.Append(" values(@entId,@web_name,@web_ip,@company,@complaints,@xxjyz,@xxfwz,@icp,@beizhu,@img_app,@img_logo,@img_left,@img_right,@img_service,@link_service);");
}
SqlParameter[] prmt = new SqlParameter[] {
new SqlParameter("@entid", entId),
new SqlParameter("@web_name", obj["title"].ToString()),
new SqlParameter("@web_ip", obj["ip"].ToString()),
new SqlParameter("@company", obj["company"].ToString()),
new SqlParameter("@complaints", obj["complaints"].ToString()),
new SqlParameter("@xxjyz", obj["xxjyz"].ToString()),
new SqlParameter("@xxfwz", obj["xxfwz"].ToString()),
new SqlParameter("@icp", obj["ICP"].ToString()),
new SqlParameter("@beizhu", obj["beizhu"].ToString()),
new SqlParameter("@img_app", obj["app_url"].ToString()),
new SqlParameter("@img_logo", obj["logo_url"].ToString()),
new SqlParameter("@img_left", obj["left_url"].ToString()),
new SqlParameter("@img_right", obj["right_url"].ToString()),
new SqlParameter("@img_service", obj["kf_url"].ToString()),
new SqlParameter("@link_service", obj["kf_link"].ToString())
};
int n = sql.ExecuteSql(strSql.ToString(), prmt);
if (n > 0)
{
return(JsonMethod.GetError(0, "提交成功"));
}
else
{
return(JsonMethod.GetError(1, "提交失败"));
}
}
/// <summary>
/// 填充商品信息
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
private List <GoodsStatistical> SetGoodsInfo(DataTable dt)
{
List <GoodsStatistical> list = new List <GoodsStatistical>();
foreach (DataRow dr in dt.Rows)
{
GoodsStatistical g = new GoodsStatistical();
g.Id = int.Parse(dr["id"].ToString().Trim());
g.Article_Id = dr["article_id"].ToString().Trim();
g.Sub_Title = dr["sub_title"].ToString().Trim();
g.Drug_Spec = dr["drug_spec"].ToString().Trim();
g.Drug_Factory = dr["drug_factory"].ToString().Trim();
g.Package_Unit = dr["package_unit"].ToString().Trim();
g.Price = BasisConfig.ObjToDecimal(dr["price"].ToString().Trim(), BaseConfiguration.PricePlace, 0.00M);
g.Stock_Quantity = BasisConfig.ObjToDecimal(dr["stock_quantity"].ToString().Trim(), BaseConfiguration.InventoryPlace, 0.00M);
//大包装控制 Y-取大包装 N-不取大包装
string packControl = dr["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = dr["scattered"].ToString().Trim();
if (packControl == "Y")
{
g.Min_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
g.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
g.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
list.Add(g);
}
return(list);
}
/// <summary>
/// 填充CartList,购物车列表【未分组】
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public CartList SetCartList(DataSet ds, int pageIndex = 1, int pageSize = 30)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
CartList model = new CartList();
DataTable dt = new DataTable();
model.PageIndex = pageIndex;
model.PageSize = pageSize;
int cartNumber = 0;
if (ds.Tables.Count >= 3)
{
model.PageCount = int.Parse(ds.Tables[2].Rows[0]["pageCount"].ToString());
model.RountCount = int.Parse(ds.Tables[2].Rows[0]["recordCount"].ToString());
dt = ds.Tables[1];
}
else
{
model.PageCount = 1;
model.RountCount = ds.Tables[0].Rows.Count;
dt = ds.Tables[0];
}
decimal real_Amount = 0M; //应付金额
decimal order_Amount = 0M; //总金额
decimal discount_Amount = 0M; //优惠金额
long InventoryShows = long.Parse(BaseConfiguration.InventoryShows); //页面商品库存最大显示数量
List <CartGoods> clist = new List <CartGoods>();
foreach (DataRow dr in dt.Rows)
{
if (dr["GoodsType"].ToString() != "ZP")
{
cartNumber += 1;
}
CartGoods c = new CartGoods();
c.Id = dr["cartId"].ToString();
c.Article_Id = dr["article_id"].ToString();
c.Sub_Title = dr["sub_title"].ToString();
c.Drug_Factory = dr["drug_factory"].ToString();
c.Drug_Spec = dr["drug_spec"].ToString();
c.Big_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
c.Quantity = BasisConfig.ObjToDecimal(dr["quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
c.Stock_Quantity = BasisConfig.ObjToDecimal(dr["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
c.Fabs = dr["fabs"].ToString().Trim();
c.Price = BasisConfig.ObjToDecimal(dr["price"].ToString(), BaseConfiguration.PricePlace, 0.00M);
c.RealPrice = BasisConfig.ObjToDecimal(dr["realprice"].ToString(), BaseConfiguration.PricePlace, 0.00M);
c.Scattered = dr["scattered"].ToString();
c.Amount = c.Quantity * c.RealPrice;
c.Fabh = dr["Fabh"].ToString();
c.GoodsType = dr["GoodsType"].ToString();
c.Multiple = decimal.Parse(dr["multiple"].ToString());
//大包装控制 Y-取大包装 N-不取大包装
string packControl = dr["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = dr["scattered"].ToString().Trim();
c.Zbz = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
if (packControl == "Y")
{
c.Min_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
c.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
c.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
//图片
if (dr["img_url"].ToString() != "")
{
c.Img_Url = web_url + dr["img_url"].ToString().Trim();
}
else
{
c.Img_Url = "";
}
if (InventoryShows > 0 && c.Stock_Quantity > InventoryShows)
{
if (c.Stock_Quantity >= 1000)
{
c.Inventory = "充裕";
}
else
{
c.Inventory = "紧张";
}
}
else
{
c.Inventory = BasisConfig.ObjToDecimal(dr["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M).ToString();
}
//discount_Amount = discount_Amount + decimal.Parse(dr["discount_Amount"].ToString());//计算商品优惠金额
//order_Amount = order_Amount+(c.Quantity * c.Price);//计算订单金额
clist.Add(c);
}
model.Num = cartNumber;
model.Order_Amount = order_Amount;
model.Discount_Amount = discount_Amount;
real_Amount = order_Amount - discount_Amount;
if (real_Amount > 0)
{
model.Real_Amount = real_Amount;
}
else
{
model.Real_Amount = 0;
}
model.GoodsInfo = clist;
return(model);
}
private static void Assignment(DataRow dr, string web_url, long InventoryShows, ref int cartNumber, ref List <CartGoods> list)
{
if (dr["GoodsType"].ToString() != "ZP")
{
cartNumber += 1;
}
CartGoods c = new CartGoods
{
Id = dr["cartId"].ToString(),
Article_Id = dr["article_id"].ToString(),
Sub_Title = dr["sub_title"].ToString(),
Drug_Factory = dr["drug_factory"].ToString(),
Drug_Spec = dr["drug_spec"].ToString(),
Big_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M),
Quantity = BasisConfig.ObjToDecimal(dr["quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M),
Stock_Quantity = BasisConfig.ObjToDecimal(dr["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M),
Fabs = dr["fabs"].ToString().Trim(),
Price = BasisConfig.ObjToDecimal(dr["price"].ToString(), BaseConfiguration.PricePlace, 0.00M),
RealPrice = BasisConfig.ObjToDecimal(dr["realprice"].ToString(), BaseConfiguration.PricePlace, 0.00M),
Scattered = dr["scattered"].ToString()
};
c.Amount = c.Quantity * c.RealPrice;
c.Fabh = dr["Fabh"].ToString();
c.GoodsType = dr["GoodsType"].ToString();
c.Multiple = decimal.Parse(dr["multiple"].ToString());
//大包装控制 Y-取大包装 N-不取大包装
string packControl = dr["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = dr["scattered"].ToString().Trim();
if (packControl == "Y")
{
c.Min_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
c.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
c.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
//图片
if (dr["img_url"].ToString() != "")
{
c.Img_Url = web_url + dr["img_url"].ToString().Trim();
}
else
{
c.Img_Url = "";
}
if (InventoryShows > 0 && c.Stock_Quantity > InventoryShows)
{
if (c.Stock_Quantity >= 1000)
{
c.Inventory = "充裕";
}
else
{
c.Inventory = "紧张";
}
}
else
{
c.Inventory = BasisConfig.ObjToDecimal(dr["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M).ToString();
}
list.Add(c);
}
/// <summary>
/// 填充数据SearchGoods
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
private List <GoodsInfo> SetGoodsList(DataTable dt, List <ImgInfo> ilist = null)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
////商品信息
List <GoodsInfo> gList = new List <GoodsInfo>();
long InventoryShows = long.Parse(BaseConfiguration.InventoryShows);//页面商品库存最大显示数量
foreach (DataRow dr in dt.Rows)
{
GoodsInfo gi = new GoodsInfo
{
Article_Id = dr["article_id"].ToString(),
GoodsCode = dr["goodscode"].ToString(),
Sub_Title = dr["sub_title"].ToString(),
Drug_Spec = dr["drug_spec"].ToString(),
Package_Unit = dr["package_unit"].ToString(),
Drug_Factory = dr["drug_factory"].ToString(),
Big_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M),
Stock_Quantity = decimal.Parse(dr["stock_quantity"].ToString()),
Cxbs = dr["cxbs"].ToString(),
Fabh = dr["fabh"].ToString(),
Describe = dr["Describe"].ToString(),
ProposalPrice = Convert.ToDecimal(dr["proposalPrice"].ToString()),
CollectId = dr["collectId"].ToString(),
Valdate = dr["valdate"].ToString(),
OldValdate = dr["old_valdate"].ToString(),
Scattered = dr["scattered"].ToString(),
ApprovalNumber = dr["approval_number"].ToString(),
GoodsLimit = dr["goodslimit"].ToString().Trim(),
PassSum = int.Parse(dr["passSum"].ToString()), //评论数
RaveReviews = decimal.Parse(dr["raveReviews"].ToString()), //好评率
Price = dr["price"].ToString(),
Limit = dr["limit"].ToString().Trim(),
ImgList = ilist//商品图片列表
};
//是否允许拆零
string scattered = dr["scattered"].ToString();
if (scattered == "Y")
{
gi.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);//拆零包装
}
else
{
gi.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
if (InventoryShows > 0 && gi.Stock_Quantity > InventoryShows)
{
if (gi.Stock_Quantity >= 1000)
{
gi.Inventory = "充裕";
}
else
{
gi.Inventory = "紧张";
}
}
else
{
gi.Inventory = dr["stock_quantity"].ToString();
}
if (dr["img_url"].ToString() != "")
{
gi.ImgUrl = web_url + dr["img_url"].ToString().Trim();
}
else
{
gi.ImgUrl = "";
}
if (dr.Table.Columns.Contains("content"))
{
gi.Content = dr["content"].ToString().Trim();
}
//加载促销信息
gList.Add(gi);
}
return(gList);
}
/// <summary>
/// 填充Models(UserInfo)数据
/// </summary>
/// <returns></returns>
private List <UserInfo> SetUserInfo(DataTable dt, DataTable data)
{
//获取用户所有绑定证书存入键值对myDic
Dictionary <string, string> myDic = new Dictionary <string, string>();
foreach (DataRow item in data.Rows)
{
myDic.Add(item["fdname"].ToString().Trim(), item["materialName"].ToString().Trim());
}
//用户信息字段名
DataColumnCollection dataColumn = dt.Columns;
string webUrl = BaseConfiguration.SercerIp.ToString();
List <UserInfo> list = new List <UserInfo>();
foreach (DataRow dr in dt.Rows)
{
UserInfo User = new UserInfo()
{
EntId = dr["entid"].ToString().Trim(),
UserId = dr["userid"].ToString().Trim(),
UserName = dr["name"].ToString().Trim(),
Sex = dr["sex"].ToString().Trim(),
Telphone = dr["telphone"].ToString().Trim(),
Province = dr["province"].ToString().Trim(),
City = dr["city"].ToString().Trim(),
Balance = dr["balance"].ToString(),
Point = int.Parse(dr["point"].ToString().Trim()),
Status = int.Parse(dr["status"].ToString()),
BusinessId = dr["businessid"].ToString().Trim(),
BusinessScope = dr["businesscont"].ToString().Trim(),
BusinessName = dr["businessname"].ToString().Trim(),
Longitude = dr["Longitude"].ToString().Trim(),
Latitude = dr["Latitude"].ToString().Trim(),
Pricelevel = dr["shortname"].ToString().Trim(),
PassWord = dr["password"].ToString().Trim(),
KhType = dr["TypeID"].ToString().Trim(),
ClientType = dr["clienttype"].ToString().Trim(),
CustomerTypeId = dr["CustomerTypeId"].ToString().Trim(),
ClientLimit = dr["clientlimit"].ToString().Trim(),
CouponCount = int.Parse(dr["CouponCount"].ToString())
};
if (dr["img_url"].ToString().Trim() != "")
{
User.Img_Url = webUrl + dr["img_url"].ToString().Trim();
}
else
{
User.Img_Url = "";
}
/*证书效期提示*/
string message = "";
/*证书过期数*/
int number = 0;
bool staleDated = false;
/*提前day天开始提示*/
int day = BaseConfiguration.Day;
/*当前日期*/
var nowDate = DateTime.Now;
List <Certificate> Certificates = new List <Certificate>();
//遍历字段名
foreach (DataColumn item in dataColumn)
{
foreach (var key in myDic.Keys)
{
if (item.ColumnName.Contains(key))
{
if (dr[key].ToString() != "")
{
bool xq = DateTime.TryParse(dr[key].ToString().Trim(), out DateTime resxq);
if (xq)
{
var diff = BasisConfig.DateDiff(nowDate, resxq);
if (diff < day && diff > 0)
{
message += myDic[key] + "即将过期！\r\n";
}
else if (diff < day && diff < 0)
{
staleDated = true;
number++;
message += myDic[key] + "过期！\r\n";
}
}
}
Certificate certificate = new Certificate()
{
CertificateName = myDic[key],
FieldName = key,
ExpiryDate = dr[key].ToString(),
TimeExpiration = staleDated
};
Certificates.Add(certificate);
}
}
}
User.Certificates = Certificates;
User.OverdueNumber = number;
#region _弃用【登录时提示证书到期时间】
//#region 医疗器械经营许可证
//if (dr["ylqxjyxkzxq"].ToString().Split('&')[1] == "Y" && dr["ylqxjyxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGYLQXJYXKZXQ = DateTime.TryParse(dr["ylqxjyxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESYLQXJYXKZXQ);
// if (FLAGYLQXJYXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESYLQXJYXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "医疗器械经营许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "医疗器械经营许可证过期！\r\n";
// }
// }
//}
//User.YLQXJYXKZXQ = dr["ylqxjyxkzxq"].ToString().Split('&')[0].Trim();/*医疗器械经营许可证*/
//#endregion
//#region 药品生产许可证效期
//if (dr["ypscxkzxq"].ToString().Split('&')[1] == "Y" && dr["ypscxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGYPSCXKZXQ = DateTime.TryParse(dr["ypscxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESYPSCXKZXQ);
// if (FLAGYPSCXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESYPSCXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "药品生产许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "药品生产许可证过期！\r\n";
// }
// }
//}
//User.YPSCXKZXQ = dr["ypscxkzxq"].ToString().Split('&')[0].Trim();/*药品生产许可证*/
//#endregion
//#region 医疗器械生产许可证效期
//if (dr["ylqxscxkzxq"].ToString().Split('&')[1] == "Y" && dr["ylqxscxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGYLQXSCXKZXQ = DateTime.TryParse(dr["ylqxscxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESYLQXSCXKZXQ);
// if (FLAGYLQXSCXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESYLQXSCXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "医疗器械生产许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "医疗器械生产许可证过期！\r\n";
// }
// }
//}
//User.YLQXSCXKZXQ = dr["ylqxscxkzxq"].ToString().Split('&')[0].Trim();/*医疗器械生产许可证*/
//#endregion
//#region 医疗机构执业许可证效期
//if (dr["yljgzyxkzxq"].ToString().Split('&')[1] == "Y" && dr["yljgzyxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGYLJGZYXKZXQ = DateTime.TryParse(dr["yljgzyxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESYLJGZYXKZXQ);
// if (FLAGYLJGZYXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESYLJGZYXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "医疗机构执业许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "医疗机构执业许可证过期！\r\n";
// }
// }
//}
//User.YLJGZYXKZXQ = dr["yljgzyxkzxq"].ToString().Split('&')[0].Trim();/*医疗机构执业许可证效期*/
//#endregion
//#region 年度报告效期
//if (dr["ndbgxq"].ToString().Split('&')[1] == "Y" && dr["ndbgxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGNDBGXQ = DateTime.TryParse(dr["ndbgxq"].ToString().Split('&')[0].Trim(), out DateTime RESNDBGXQ);
// if (FLAGNDBGXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESNDBGXQ);
// if (diff < day && diff > 0)
// {
// message += "年度报告即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "年度报告过期！\r\n";
// }
// }
//}
//User.NDBGXQ = dr["ndbgxq"].ToString().Split('&')[0].Trim();/*年度报告效期*/
//#endregion
//#region 质量保证协议效期
//if (dr["zlbzxyxq"].ToString().Split('&')[1] == "Y" && dr["zlbzxyxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGZLBZXYXQ = DateTime.TryParse(dr["zlbzxyxq"].ToString().Split('&')[0].Trim(), out DateTime RESZLBZXYXQ);
// if (FLAGZLBZXYXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESZLBZXYXQ);
// if (diff < day && diff > 0)
// {
// message += "质量保证协议即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "质量保证协议过期！\r\n";
// }
// }
//}
//User.ZLBZXYXQ = dr["zlbzxyxq"].ToString().Split('&')[0].Trim();/*质量保证协议效期*/
//#endregion
//#region 母婴保健许可证
//if (dr["mybjxkzxq"].ToString().Split('&')[1] == "Y" && dr["mybjxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGMYBJXKZXQ = DateTime.TryParse(dr["mybjxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESMYBJXKZXQ);
// if (FLAGMYBJXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESMYBJXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "母婴保健许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "母婴保健许可证过期！\r\n";
// }
// }
//}
//User.MYBJXKZXQ = dr["mybjxkzxq"].ToString().Split('&')[0].Trim();/*母婴保健许可证*/
//#endregion
//#region 母婴保健技术许可证
//if (dr["mybjjsxkzxq"].ToString().Split('&')[1] == "Y" && dr["mybjjsxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGMYBJJSXKZXQ = DateTime.TryParse(dr["mybjjsxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESMYBJJSXKZXQ);
// if (FLAGMYBJJSXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESMYBJJSXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "母婴保健技术许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "母婴保健技术许可证过期！\r\n";
// }
// }
//}
//User.MYBJJSXKZXQ = dr["mybjjsxkzxq"].ToString().Split('&')[0].Trim();/*母婴保健技术许可证*/
//#endregion
//#region gsp证书效期
//if (dr["gspxq"].ToString().Split('&')[1] == "Y" && dr["gspxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGGSPZSYXQ = DateTime.TryParse(dr["gspxq"].ToString().Split('&')[0].Trim(), out DateTime RESGSPZSYXQ);
// if (FLAGGSPZSYXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESGSPZSYXQ);
// if (diff < day && diff > 0)
// {
// message += "gsp证书即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "gsp证书过期！\r\n";
// }
// }
//}
//User.GSPZSYXQ = dr["gspzsyxq"].ToString().Split('&')[0].Trim();/*gsp证书效期*/
//#endregion
//#region 药品经营许可证效期
//if (dr["ypjyxkzxq"].ToString().Split('&')[1] == "Y" && dr["ypjyxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGYPJYXKZXQ = DateTime.TryParse(dr["ypjyxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESYPJYXKZXQ);
// if (FLAGYPJYXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESYPJYXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "药品经营许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "药品经营许可证过期！\r\n";
// }
// }
//}
//User.YPJYXKZXQ = dr["ypjyxkzxq"].ToString().Split('&')[0].Trim();/*药品经营许可证效期*/
//#endregion
//#region 营业执照效期
//if (dr["yyzzxq"].ToString().Split('&')[1] == "Y" && dr["yyzzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGYYZZXQ = DateTime.TryParse(dr["yyzzxq"].ToString().Split('&')[0].Trim(), out DateTime RESYYZZXQ);
// if (FLAGYYZZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESYYZZXQ);
// if (diff < day && diff > 0)
// {
// message += "营业执照即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "营业执照过期！\r\n";
// }
// }
//}
//User.YYZZXQ = dr["yyzzxq"].ToString().Split('&')[0].Trim();/*营业执照效期*/
//#endregion
//#region 食品流通许可证效期
//if (dr["spltxkzxq"].ToString().Split('&')[1] == "Y" && dr["spltxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGSPLTXKZXQ = DateTime.TryParse(dr["spltxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESSPLTXKZXQ);
// if (FLAGSPLTXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESSPLTXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "食品流通许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "食品流通许可证过期！\r\n";
// }
// }
//}
//User.SPLTXKZXQ = dr["spltxkzxq"].ToString().Split('&')[0].Trim();/*食品流通许可证效期*/
//#endregion
//#region 委托书
//if (dr["wtsxq"].ToString().Split('&')[1] == "Y" && dr["wtsxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGWTSXQ = DateTime.TryParse(dr["wtsxq"].ToString().Split('&')[0].Trim(), out DateTime RESWTSXQ);
// if (FLAGWTSXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESWTSXQ);
// if (diff < day && diff > 0)
// {
// message += "委托书即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "委托书过期！\r\n";
// }
// }
//}
//User.WTSXQ = dr["wtsxq"].ToString().Split('&')[0].Trim();/*委托书*/
//#endregion
//#region 卫生许可证
//if (dr["wsxkzxq"].ToString().Split('&')[1] == "Y" && dr["wsxkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGWSXKZXQ = DateTime.TryParse(dr["wsxkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESWSXKZXQ);
// if (FLAGWSXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESWSXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "卫生许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "卫生许可证过期！\r\n";
// }
// }
//}
//User.WSXKZXQ = dr["wsxkzxq"].ToString().Split('&')[0].Trim();/*卫生许可证*/
//#endregion
//#region 公示许可证
//if (dr["gsyxq"].ToString().Split('&')[1] == "Y" && dr["gsyxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGGSYXQ = DateTime.TryParse(dr["gsyxq"].ToString().Split('&')[0].Trim(), out DateTime RESGSYXQ);
// if (FLAGGSYXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESGSYXQ);
// if (diff < day && diff > 0)
// {
// message += "公示许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "公示许可证过期！\r\n";
// }
// }
//}
//User.GSYXQ = dr["gsyxq"].ToString().Split('&')[0].Trim();/*公示许可证*/
//#endregion
//#region 许可证效期
//if (dr["xkzxq"].ToString().Split('&')[1] == "Y" && dr["xkzxq"].ToString().Split('&')[0].Trim() != "")
//{
// bool FLAGXKZXQ = DateTime.TryParse(dr["xkzxq"].ToString().Split('&')[0].Trim(), out DateTime RESXKZXQ);
// if (FLAGXKZXQ)
// {
// var diff = BasisConfig.DateDiff(nowDate, RESXKZXQ);
// if (diff < day && diff > 0)
// {
// message += "许可证即将过期！\r\n";
// }
// else if (diff < day && diff < 0)
// {
// staleDated = true;
// message += "许可证过期！\r\n";
// }
// }
//}
//User.XKZXQ = dr["xkzxq"].ToString().Split('&')[0].Trim();/*许可证效期*/
//#endregion
#endregion
User.StaleDated = staleDated;
User.StaleMsg = message;
list.Add(User);
}
return(list);
}
protected List <PromList> SetPromSingle(DataTable dt, bool landing, bool staleDated)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
List <PromList> list = new List <PromList>();
foreach (DataRow dr in dt.Rows)
{
PromList prom = new PromList();
prom.EntId = dr["entid"].ToString();
prom.Fabh = dr["fabh"].ToString();
prom.FaTitle = dr["faTitle"].ToString();
prom.Fabs = dr["fabs"].ToString();
prom.StartDate = dr["startDate"].ToString();
prom.EndDate = dr["endDate"].ToString();
prom.Amount = BasisConfig.ObjToDecimal(dr["Amount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.YAmount = BasisConfig.ObjToDecimal(dr["yAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.KhAmount = BasisConfig.ObjToDecimal(dr["KhAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.Describe = dr["describe"].ToString();
prom.Article_Id = dr["article_id"].ToString();
prom.Sub_Title = dr["sub_title"].ToString();
prom.Drug_Spec = dr["drug_spec"].ToString();
prom.Drug_Factory = dr["drug_factory"].ToString();
prom.Big_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
prom.Stock_Quantity = BasisConfig.ObjToDecimal(dr["Stock_Quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.ProposalPrice = BasisConfig.ObjToDecimal(dr["proposalPrice"].ToString(), BaseConfiguration.PricePlace, 0.00M);
prom.GoodsLimit = dr["goodslimit"].ToString();
//大包装控制 Y-取大包装 N-不取大包装
string packControl = dr["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = dr["scattered"].ToString().Trim();
if (packControl == "Y")
{
prom.Min_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
prom.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
prom.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
//价格
if (landing && !staleDated)
{
prom.Price = BasisConfig.ObjToDecimal(dr["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
prom.Limit = dr["limit"].ToString();
}
else
{
prom.Price = "会员可见";
prom.Limit = "Y";
}
if (dr["img_url"].ToString() != "")
{
prom.Img_Url = web_url + dr["img_url"].ToString();
}
else
{
prom.Img_Url = "";
}
list.Add(prom);
}
return(list);
}
/// <summary>
/// 填充BrandList
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public List <BrandList> SetBrand(DataSet ds, bool landing, bool staleDated)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
long InventoryShows = long.Parse(BaseConfiguration.InventoryShows);//页面商品库存最大显示数量
List <BrandList> listMt = new List <BrandList>();
foreach (DataRow drMt in ds.Tables[0].Rows)
{
///汇总信息
BrandList mt = new BrandList();
mt.EntId = drMt["entid"].ToString();
mt.BillNo = drMt["billno"].ToString();
mt.Name = drMt["name"].ToString();
mt.BeiZhu = drMt["beizhu"].ToString();
mt.Sort_Id = int.Parse(drMt["sort_id"].ToString());
mt.Fabh = drMt["fabh"].ToString();
mt.Cxbs = drMt["cxbs"].ToString();
if (drMt["img_url"].ToString() != "")
{
mt.ImgUrl = web_url + drMt["img_url"].ToString();
}
else
{
mt.ImgUrl = "";
}
if (drMt["img_url_dt"].ToString() != "")
{
mt.ImgUrlDt = web_url + drMt["img_url_dt"].ToString();
}
else
{
mt.ImgUrlDt = "";
}
DataRow[] dr = ds.Tables[2].Select("billno='" + drMt["billno"].ToString() + "'", "sort_id asc,dj_sn asc");
///详情商品信息
List <GoodsInfo> listDt = new List <GoodsInfo>();
foreach (DataRow drDt in dr)
{
GoodsInfo gi = new GoodsInfo
{
Article_Id = drDt["article_id"].ToString(),
GoodsCode = drDt["goodscode"].ToString(),
Sub_Title = drDt["sub_title"].ToString(),
Drug_Spec = drDt["drug_spec"].ToString(),
Package_Unit = drDt["package_unit"].ToString(),
Drug_Factory = drDt["drug_factory"].ToString(),
Big_Package = BasisConfig.ObjToDecimal(drDt["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M),
Stock_Quantity = BasisConfig.ObjToDecimal(drDt["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M),
ApprovalNumber = drDt["approval_number"].ToString(),
ProposalPrice = BasisConfig.ObjToDecimal(drDt["proposalPrice"].ToString(), BaseConfiguration.PricePlace, 0.00M),
Valdate = drDt["valdate"].ToString(),
Scattered = drDt["scattered"].ToString(),
Fabh = drDt["fabh"].ToString(),
Cxbs = drDt["cxbs"].ToString(),
GoodsLimit = drDt["goodslimit"].ToString()
};
//大包装控制 Y-取大包装 N-不取大包装
string packControl = drDt["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = drDt["scattered"].ToString().Trim();
if (packControl == "Y")
{
gi.Min_Package = BasisConfig.ObjToDecimal(drDt["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
gi.Min_Package = BasisConfig.ObjToDecimal(drDt["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
gi.Min_Package = BasisConfig.ObjToDecimal(drDt["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
//是否显示真实库存
if (InventoryShows > 0 && gi.Stock_Quantity > InventoryShows)
{
if (gi.Stock_Quantity >= 1000)
{
gi.Inventory = "充裕";
}
else
{
gi.Inventory = "紧张";
}
}
else
{
gi.Inventory = BasisConfig.ObjToDecimal(drDt["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M).ToString();
}
//判断用户是否登陆
if (landing && !staleDated)
{
gi.Price = BasisConfig.ObjToDecimal(drDt["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
gi.Limit = drDt["limit"].ToString();
}
else
{
gi.Price = "会员可见";
gi.Limit = "Y";
}
if (drDt["img_url"].ToString() != "")
{
gi.ImgUrl = web_url + drDt["img_url"].ToString().Trim();
}
else
{
gi.ImgUrl = "";
}
listDt.Add(gi);
}
mt.GoodsList = listDt;
listMt.Add(mt);
}
return(listMt);
}
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);
}
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="t1"></param>
/// <param name="t2"></param>
/// <param name="entId"></param>
/// <param name="landing"></param>
/// <param name="staleDated"></param>
/// <param name="jgjb"></param>
/// <returns></returns>
private List <IndexFloor> FillFloor(DataTable t1, DataTable t2, string entId, bool landing, bool staleDated, string jgjb, string userId)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
List <IndexFloor> list = new List <IndexFloor>();
foreach (DataRow dr in t1.Rows)
{
IndexFloor lc = new IndexFloor
{
Entid = dr["entid"].ToString().Trim(),
FloorId = dr["FloorId"].ToString().Trim(),
FloorTitle = dr["FloorTitle"].ToString().Trim(),
Link_Url = dr["Floor_Link"].ToString().Trim(),
TypeName = dr["TypeName"].ToString().Trim(),
Type = dr["imgTypeS"].ToString().Trim(),
AndroidLinkType = int.Parse(dr["androidlinktype"].ToString()),
AndroidLinkUrl = dr["androidlinkurl"].ToString().Trim()
};
if (dr["Floor_Img"].ToString().Trim() != "")
{
lc.Floor_Img = web_url + dr["Floor_Img"].ToString().Trim();
}
else
{
lc.Floor_Img = "";
}
List <ImgInfo> imgList = new List <ImgInfo>();
if (t2.Rows.Count > 0)
{
DataRow[] imgDr = t2.Select("EntId='" + entId + "' and FloorId='" + lc.FloorId + "'", "sort_Id asc");
//楼层详细数据
foreach (DataRow drI in imgDr)
{
ImgInfo img = new ImgInfo
{
Entid = drI["entid"].ToString().Trim(),
Title = drI["FloorTitle"].ToString().Trim(),
ArticleId = drI["Article_Id"].ToString().Trim(),
SortId = int.Parse(drI["sort_Id"].ToString().Trim()),
IsBrand = drI["Is_Brand"].ToString().Trim(),
BrandCode = drI["BrandCode"].ToString().Trim(),
LinkUrl = drI["link_url"].ToString().Trim(),
AndroidLinkType = int.Parse(dr["androidlinktype"].ToString()),
AndroidLinkUrl = drI["androidlinkurl"].ToString().Trim()
};
if (drI["img_url"].ToString().Trim() != "")
{
img.ImgUrl = web_url + drI["img_url"].ToString().Trim();
}
else
{
img.ImgUrl = "";
}
if (drI["left_pic"].ToString().Trim() != "")
{
img.LeftPic = web_url + drI["left_pic"].ToString().Trim();
}
if (drI["brand_img_url"].ToString().Trim() != "")
{
img.BrandImgUrl = web_url + drI["brand_img_url"].ToString().Trim();
}
else
{
img.BrandImgUrl = "";
}
img.SubTitle = drI["sub_title"].ToString().Trim();
img.DrugSpec = drI["drug_spec"].ToString().Trim();
img.DrugFactory = drI["drug_factory"].ToString().Trim();
if (landing && !staleDated)
{
img.Price = BasisConfig.ObjToDecimal(drI["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
}
else
{
img.Price = "会员可见";
}
img.Cxbs = drI["cxbs"].ToString().Trim();
img.Fabh = drI["fabh"].ToString().Trim();
imgList.Add(img);
}
//LogQueue.Write(LogType.Debug, "FillFloor", $"Type:{lc.Type},len:{imgDr.Length}");
//品牌推荐 最少12 不足补位
if (lc.Type == "Brand" && imgDr.Length < 12)
{
imgList = BrandParatope(imgList, entId, web_url, landing, staleDated, 12 - imgDr.Length, userId);
}
else if (lc.Type == "Weekly" && imgDr.Length < 4)
{
imgList = GoodsParatope(imgList, entId, web_url, landing, staleDated, 4 - imgDr.Length, jgjb, lc.FloorTitle, userId);
}
else if ((lc.Type == "Family" || lc.Type == "Product" || lc.Type == "InSeason" || lc.Type == "Health") && imgDr.Length < 7)
{
imgList = GoodsParatope(imgList, entId, web_url, landing, staleDated, 7 - imgDr.Length, jgjb, lc.FloorTitle, userId);
}
}
lc.FloorDetail = imgList;
list.Add(lc);
}
return(list);
}
/// <summary>
/// 填充数据(PromMt)
/// </summary>
/// <param name="promMt"></param>
/// <param name="promDt"></param>
/// <returns></returns>
protected List <PromMt> SetGroupInfo(DataTable dtMt, DataTable dtDt, bool staleDated, bool landing)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
List <PromMt> mtList = new List <PromMt>();
foreach (DataRow drMt in dtMt.Rows)
{
PromMt mt = new PromMt();
mt.EntId = drMt["entid"].ToString();
mt.Fabh = drMt["fabh"].ToString();
mt.FaTitle = drMt["faTitle"].ToString();
mt.Fabs = drMt["fabs"].ToString();
mt.StartDate = drMt["startDate"].ToString();
mt.EndDate = drMt["endDate"].ToString();
mt.Amount = BasisConfig.ObjToDecimal(drMt["amount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
mt.YAmount = BasisConfig.ObjToDecimal(drMt["yamount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
mt.KhAmount = BasisConfig.ObjToDecimal(drMt["khAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
mt.Describe = drMt["describe"].ToString();
DataRow[] drDt_1 = dtDt.Select("fabh='" + mt.Fabh + "' and entid='" + mt.EntId + "'", "fa_sn asc");
List <PromDt> dtList = new List <PromDt>();
foreach (DataRow drDt in drDt_1)
{
PromDt dt = new PromDt();
dt.Fabh = drDt["fabh"].ToString();
dt.Fa_Sn = int.Parse(drDt["fa_sn"].ToString());
dt.Article_Id = drDt["article_id"].ToString();
dt.Sub_Title = drDt["sub_title"].ToString();
dt.Drug_Factory = drDt["drug_factory"].ToString();
dt.Drug_Spec = drDt["drug_spec"].ToString();
dt.Big_Package = BasisConfig.ObjToDecimal(drDt["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
//大包装控制 Y-取大包装 N-不取大包装
string packControl = drDt["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = drDt["scattered"].ToString().Trim();
if (packControl == "Y")
{
dt.Min_Package = BasisConfig.ObjToDecimal(drDt["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
dt.Min_Package = BasisConfig.ObjToDecimal(drDt["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
dt.Min_Package = BasisConfig.ObjToDecimal(drDt["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
dt.Stock_Quantity = BasisConfig.ObjToDecimal(drDt["stock_quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
dt.GoodsLimit = drDt["goodslimit"].ToString();
if (landing && !staleDated)
{
dt.Price = BasisConfig.ObjToDecimal(drDt["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
dt.PromPrice = BasisConfig.ObjToDecimal(drDt["giftprice"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
dt.Limit = drDt["limit"].ToString();
}
else
{
dt.Price = "会员可见";
dt.PromPrice = "会员可见";
dt.Limit = "Y";
}
dt.MeetCount = decimal.Parse(drDt["meetCount"].ToString());
dt.Discount = decimal.Parse(drDt["Discount"].ToString());
dt.GiftId = drDt["GiftId"].ToString();
dt.Quantity = BasisConfig.ObjToDecimal(drDt["giftquantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
dt.MaxQuantity = BasisConfig.ObjToDecimal(drDt["giftquantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
dt.Package_Unit = drDt["package_unit"].ToString();
if (drDt["Img_Url"].ToString() != "")
{
dt.Img_Url = web_url + drDt["img_url"].ToString();
}
else
{
dt.Img_Url = "";
}
dtList.Add(dt);
}
mt.PromDt = dtList;
mtList.Add(mt);
}
return(mtList);
}
protected List <PromFlashSale> SetDate(DataTable tBegin, DataTable tAfter, bool landing, bool staleDated)
{
///获取网站ip
string web_url = BaseConfiguration.SercerIp;
List <PromFlashSale> pList = new List <PromFlashSale>();
/*正在进行的活动商品*/
if (tBegin.Rows.Count > 0)
{
PromFlashSale mt = new PromFlashSale();
mt.Title = "正在进行中";
mt.Start = 2;
mt.StartDate = tBegin.Rows[0]["startDate"].ToString();
mt.EndDat = tBegin.Rows[0]["endDate"].ToString();
List <PromList> beginList = new List <PromList>();
foreach (DataRow dr in tBegin.Rows)
{
PromList prom = new PromList();
prom.EntId = dr["entid"].ToString();
prom.EntId = dr["entname"].ToString();
prom.Fabh = dr["fabh"].ToString();
prom.FaTitle = dr["faTitle"].ToString();
prom.Fabs = dr["fabs"].ToString();
prom.StartDate = dr["startDate"].ToString();
prom.EndDate = dr["endDate"].ToString();
prom.Amount = BasisConfig.ObjToDecimal(dr["Amount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.YAmount = BasisConfig.ObjToDecimal(dr["yAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.KhAmount = BasisConfig.ObjToDecimal(dr["KhAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.Describe = dr["describe"].ToString();
prom.Article_Id = dr["article_id"].ToString();
prom.Sub_Title = dr["sub_title"].ToString();
prom.Drug_Spec = dr["drug_spec"].ToString();
prom.Drug_Factory = dr["drug_factory"].ToString();
prom.Big_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
prom.GoodsLimit = dr["goodslimit"].ToString();
//大包装控制 Y-取大包装 N-不取大包装
string packControl = dr["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = dr["scattered"].ToString().Trim();
if (packControl == "Y")
{
prom.Min_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
prom.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
prom.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
prom.Stock_Quantity = BasisConfig.ObjToDecimal(dr["Stock_Quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom.Quantity = BasisConfig.ObjToDecimal(dr["giftquantity"].ToString(), BaseConfiguration.InventoryPlace, 0.000M);
if (landing && !staleDated)
{
prom.Price = BasisConfig.ObjToDecimal(dr["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
prom.CPrice = BasisConfig.ObjToDecimal(dr["cprice"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
prom.Limit = dr["limit"].ToString();
}
else
{
prom.Price = "会员可见";
prom.CPrice = "会员可见";
prom.Limit = "Y";
}
if (dr["img_url"].ToString() != "")
{
prom.Img_Url = web_url + dr["img_url"].ToString();
}
else
{
prom.Img_Url = "";
}
beginList.Add(prom);
}
mt.list = beginList;
pList.Add(mt);
}
/*未开始的活动商品*/
if (tAfter.Rows.Count > 0)
{
var query = from q in tAfter.AsEnumerable()
group q by new { t1 = q.Field <string>("StartDate"), t2 = q.Field <string>("endDate") } into active
select new { start = active.Key.t1, end = active.Key.t2 };
foreach (var item in query)
{
DataRow[] row = tAfter.Select(" StartDate='" + item.start.ToString() + "' ");
DataTable table = tAfter.Clone();
foreach (var r in row)
{
table.ImportRow(r);
}
PromFlashSale prom = new PromFlashSale();
prom.Title = item.start.ToString() + "——" + item.end.ToString();
//prom.Title = item.start.ToString().Substring(11,5) +"-"+ item.end.ToString().Substring(11, 5);
prom.StartDate = item.start.ToString();
prom.EndDat = item.end.ToString();
prom.Start = 1;
List <PromList> afterList = new List <PromList>();
foreach (DataRow dr in table.Rows)
{
PromList prom1 = new PromList();
prom1.EntId = dr["entname"].ToString();
prom1.EntId = dr["entid"].ToString();
prom1.Fabh = dr["fabh"].ToString();
prom1.FaTitle = dr["faTitle"].ToString();
prom1.Fabs = dr["fabs"].ToString();
prom1.StartDate = dr["startDate"].ToString();
prom1.EndDate = dr["endDate"].ToString();
prom1.Amount = BasisConfig.ObjToDecimal(dr["Amount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom1.YAmount = BasisConfig.ObjToDecimal(dr["yAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom1.KhAmount = BasisConfig.ObjToDecimal(dr["KhAmount"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom1.Describe = dr["describe"].ToString();
prom1.Article_Id = dr["article_id"].ToString();
prom1.Sub_Title = dr["sub_title"].ToString();
prom1.Drug_Spec = dr["drug_spec"].ToString();
prom1.Drug_Factory = dr["drug_factory"].ToString();
prom1.Big_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
prom1.GoodsLimit = dr["goodslimit"].ToString();
//大包装控制 Y-取大包装 N-不取大包装
string packControl = dr["packControl"].ToString().Trim();
//中包装控制 Y-取中包装，不拆零 N-不取中包装，拆零
string scattered = dr["scattered"].ToString().Trim();
if (packControl == "Y")
{
prom1.Min_Package = BasisConfig.ObjToDecimal(dr["big_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
if (scattered == "Y")
{
prom1.Min_Package = BasisConfig.ObjToDecimal(dr["min_package"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
else
{
prom1.Min_Package = BasisConfig.ObjToDecimal(dr["scatteredPackage"].ToString(), BaseConfiguration.PackagePlace, 0.00M);
}
}
prom1.Stock_Quantity = BasisConfig.ObjToDecimal(dr["Stock_Quantity"].ToString(), BaseConfiguration.InventoryPlace, 0.00M);
prom1.Quantity = BasisConfig.ObjToDecimal(dr["giftquantity"].ToString(), BaseConfiguration.InventoryPlace, 0.000M);
if (landing && !staleDated)
{
prom1.Price = BasisConfig.ObjToDecimal(dr["price"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
prom1.CPrice = BasisConfig.ObjToDecimal(dr["cprice"].ToString(), BaseConfiguration.PricePlace, 0.00M).ToString();
prom1.Limit = dr["limit"].ToString();
}
else
{
prom1.Price = "会员可见";
prom1.CPrice = "会员可见";
prom1.Limit = "Y";
}
if (dr["img_url"].ToString() != "")
{
prom1.Img_Url = web_url + dr["img_url"].ToString();
}
else
{
prom1.Img_Url = "";
}
afterList.Add(prom1);
}
prom.list = afterList;
pList.Add(prom);
}
}
return(pList);
}