/// <summary>
/// 上传文件公用类
/// </summary>
/// <param name="_file"></param>
/// <returns></returns>
public FileUploadResult UploadFileCommon(HttpPostedFileBase _file)
{
try
{
string _fileInfotype = _file.ContentType; //Path.GetExtension(file.FileName).ToLower();
int _fileInfosize = (int)_file.InputStream.Length;
if (_fileInfosize == 0)
{
return(new FileUploadResult {
result = false, ResultExplain = "上传空文件"
});
}
Stream stream = _file.InputStream;
byte[] buffer = new byte[_fileInfosize];
stream.Read(buffer, 0, _fileInfosize);
var t = Path.GetExtension(_file.FileName);
t = t == null ? "jpg" : t.Replace(".", "");
//获得原图的路径
string ImageUrl = FastDFSClient.UploadFile(FastDFSClient.DefaultGroup, buffer, t);
//获得服务器地址
string url = GetConfig.FullPath() + GetThumbsImage(ImageUrl, 364, 230);
return(new FileUploadResult {
url = url, ResultExplain = "成功", name = ImageUrl, result = true
});
}
catch (Exception)
{
return(new FileUploadResult {
url = "", ResultExplain = "失败", name = "", result = false
});
}
}
/// <summary>
/// 根据商品Id,sku码Id获取商品信息
/// </summary>
/// <param name="lstGoodsId">商品Id集合</param>
/// <param name="lstSkuProductIds">sku码Id集合</param>
/// <param name="languageId">语言代码</param>
/// <returns></returns>
public ResultModel GetGoodsInfo(List <String> lstGoodsId, List <String> lstSkuProductIds, int languageId)
{
ResultModel result = new ResultModel {
IsValid = false
};
if (lstGoodsId == null || lstGoodsId.Count == 0)
{
result.Messages.Add("参数异常,请稍候再试");
}
else
{
var goodsidattr = string.Join(",", lstGoodsId.Select(m => "'" + SqlFilterUtil.ReplaceSqlChar(m) + "'").ToArray());
var skuattr = string.Join(",", lstSkuProductIds.Select(m => "'" + SqlFilterUtil.ReplaceSqlChar(m) + "'").ToArray());
StringBuilder sb = new StringBuilder();
string sql = @"Select p.FareTemplateID,p.Volume,sp.PurchasePrice,sp.Stock AS 'StockQuantity',sp.MarketPrice,sp.SkuName As 'ValueStr',sp.SKU_ProducId As 'SkuNumber',p.RebateDays,p.RebateRatio
,p.PostagePrice,p.SupplierId, p.ProductID AS 'GoodsId',p.FreeShipping,p.Weight,p.MerchantID AS 'ComId',p.Status,p.MerchantID,
(SELECT reverse(stuff(reverse((
SELECT DISTINCT BBB.AttributeName+',' FROM dbo.SKU_AttributeValues AAA JOIN dbo.SKU_Attributes BBB ON AAA.AttributeId=BBB.AttributeId
WHERE CHARINDEX(convert(varchar,AAA.ValueId)+'_',sp.SKUStr)>0
OR CHARINDEX('_'+convert(varchar,AAA.ValueId),sp.SKUStr)>0
OR sp.SKUStr=convert(varchar,AAA.ValueId) FOR XML PATH(''))),1,1,''))) As 'AttributeName'
,pp.PicUrl As 'Pic',pl.ProductName AS 'GoodsName',
Case When (pr.StarDate<=GETDATE() and pr.EndDate>=GETDATE() and pr.SalesRuleId=2 and pr.Discount>0) Then sp.HKPrice*pr.Discount
Else sp.HKPrice End As 'GoodsUnits'
,m.ShopName AS 'ComName',m.IsProvideInvoices
,0 As 'Count',0 As 'IsChecked' From Product p
LEFT JOIN ProductPic pp on p.ProductID = pp.ProductId LEFT JOIN Product_Lang pl ON p.ProductID = pl.ProductId
LEFT JOIN YH_MerchantInfo m ON p.MerchantID=m.MerchantID LEFT JOIN SKU_Product sp on p.ProductId = sp.ProductId
LEFT JOIN ProductRule pr ON p.ProductID = pr.ProductId
Where pp.Flag = 1 And pl.LanguageID ={0} AND sp.SKU_ProducId IN ({1}) AND p.ProductId IN ({2});";
sb.AppendFormat(sql, languageId, skuattr, goodsidattr);
var data = _database.RunSqlQuery(x => x.ToResultSets(sb.ToString()));
List <dynamic> sources = data[0];
result.Data = sources.ToEntity <GoodsInfoModel>();
foreach (var prodcut in result.Data)
{
prodcut.Pic = GetConfig.FullPath() + prodcut.Pic;
}
result.IsValid = true;
}
return(result);
}
/// <summary>
/// 获取图片
/// </summary>
/// <param name="helper"></param>
/// <param name="ImageUrl">地址</param>
/// <param name="ImageSize">宽</param>
/// <param name="height">高</param>
/// <returns></returns>
public static string GetImagesUrl(string ImageUrl, int ImageSize, int height = 0)
{
string str = "";
if (height == 0)
{
str = GetThumbsImage(ImageUrl, ImageSize);
}
else
{
str = GetThumbsImage(ImageUrl, ImageSize, height);
}
if (string.IsNullOrWhiteSpace(str))
{
return(string.Empty);
}
return(GetConfig.FullPath() + GetThumbsImage(ImageUrl, ImageSize, height));
}
/// <summary>
/// 获取原始图片
/// </summary>
/// <param name="helper"></param>
/// <param name="ImageUrl"></param>
/// <returns></returns>
public static string GetImagesUrl(string ImageUrl)
{
return(GetConfig.FullPath() + ImageUrl);
}
/// <summary>
/// 获取原始图片
/// </summary>
/// <param name="helper"></param>
/// <param name="ImageUrl"></param>
/// <returns></returns>
public static string GetImagesUrl(this HtmlHelper helper, string ImageUrl)
{
return(GetConfig.FullPath() + ImageUrl);
}
