/// <summary>
/// 从数据库加载指定的映射脚本对象
/// </summary>
/// <param name="strMapID"></param>
/// <returns></returns>
public Model.MapScript GetSelectMapScript(string strMapID)
{
DataSet ds = GetSelectMapScriptDS(strMapID);
int iCount = ds.Tables[0].Rows.Count;
if (iCount <= 0)
{
return(null);
}
return(ObjectConvertor.ToObject <Model.MapScript>(ds.Tables[0].Rows[0]));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.SmsSpgate GetModel(string GateNumber)
{
DataSet ds = GetSelectSpgate(GateNumber);
int iCount = ds.Tables[0].Rows.Count;
if (iCount <= 0)
{
return(null);
}
//转换成实体
return(ObjectConvertor.ToObject <Model.SmsSpgate>(ds.Tables[0].Rows[0]));
}
public Model.SmsUser GetSelectSmsUser(string strUserID, string strPwd)
{
DataSet ds = dal.GetSelectSmsUser(strUserID, strPwd);
if (ds.Tables[0].Rows.Count > 0)
{
return(ObjectConvertor.ToObject <DataRow, SmsServer.Model.SmsUser>(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/*
* 导入结构:
* 总目录-|
* -供应商-|
* -图片文件夹
* -产品数据.xls
*
* 结果目录:
* 总目录-
* --合格数据
* --不合格数据
* --供应商
* --没有产品信息的图片
* --没有图片的产品.xls
*/
/// <summary>
/// 将结果保存到磁盘:
/// </summary>
/// <param name="productHasImages"></param>
public void HandlerCheckResult(string supplierName, IList <Product> productHasImages, IList <Product> productNotHasImages,
IList <Product> productsExistedInDb,
IList <FileInfo> imagesHasProduct, IList <FileInfo> imagesNotHasProduct,
string outputFolder)
{
DirectoryInfo dirRoot = new DirectoryInfo(outputFolder);
TransferInDatatable transfer = new TransferInDatatable();
//如果没有合格数据 则不需要创建
if (productHasImages.Count > 0)
{
DirectoryInfo dirQuanlified = IOHelper.EnsureDirectory(outputFolder + "合格数据\\");
DirectoryInfo dirSupplierQuanlified = IOHelper.EnsureDirectory(dirQuanlified.FullName + supplierName + "\\");
DirectoryInfo dirSupplierQuanlifiedImages = IOHelper.EnsureDirectory(dirSupplierQuanlified.FullName + supplierName + "\\");
foreach (Product product in productHasImages)
{
try
{
FileInfo imageFile = imagesHasProduct.Single(x => StringHelper.ReplaceSpace(Path.GetFileNameWithoutExtension(x.Name))
.Equals(StringHelper.ReplaceSpace(product.ModelNumber), StringComparison.OrdinalIgnoreCase));
File.Copy(imageFile.FullName, dirSupplierQuanlified.FullName + supplierName + "\\" + imageFile.Name, true);
//同时拷贝到网站图片路径
if (!string.IsNullOrEmpty(WebProductImagesPath) && outputFolder != WebProductImagesPath)
{
string newImageName = (product.Name + product.SupplierName + product.ModelNumber).GetHashCode().ToString() + imageFile.Extension;
File.Copy(imageFile.FullName, WebProductImagesPath + newImageName, true);
}
}
catch (Exception ex)
{
throw new Exception("图片复制出错:" + dirSupplierQuanlified.FullName + "---" + product.ModelNumber + "---" + ex.Message);
}
}
DataTable dtProductsHasImage = ObjectConvertor.ToDataTable <Product>(productHasImages);
transfer.CreateXslFromDataTable(dtProductsHasImage, 1, dirSupplierQuanlified.FullName + "\\" + supplierName + ".xls");
}
//没有图片的产品
string dirPathNotQuanlified = outputFolder + "不合格数据\\";
string dirPathSupplierNotQuanlified = dirPathNotQuanlified + supplierName + "\\";
if (productNotHasImages.Count > 0)
{
DirectoryInfo dirSupplierNotQuanlified = IOHelper.EnsureDirectory(dirPathSupplierNotQuanlified);
DataTable dtProductsNotHasImage = ObjectConvertor.ToDataTable <Product>(productNotHasImages);
transfer.CreateXslFromDataTable(dtProductsNotHasImage, 1, dirSupplierNotQuanlified + "没有图片的数据_" + supplierName + ".xls");
}
//没有产品的图片
if (imagesNotHasProduct.Count > 0)
{
string dirPathSupplierNotQuanlifiedImages = dirPathSupplierNotQuanlified + "多余图片_" + supplierName + "\\";
DirectoryInfo dirSupplierNotQuanlifiedImages = IOHelper.EnsureDirectory(dirPathSupplierNotQuanlifiedImages);
foreach (FileInfo file in imagesNotHasProduct)
{
file.CopyTo(dirSupplierNotQuanlifiedImages + file.Name, true);
}
}
//多余的图片
//重复数据
if (productsExistedInDb.Count > 0)
{
string dirPathSupplierRepeated = dirPathSupplierNotQuanlified + "数据库内已存在的数据_" + supplierName + "\\";
DirectoryInfo dirSupplierRepeated = IOHelper.EnsureDirectory(dirPathSupplierRepeated);
DataTable dtProductsRepeated = ObjectConvertor.ToDataTable <Product>(productsExistedInDb);
transfer.CreateXslFromDataTable(dtProductsRepeated, 1, dirSupplierRepeated.FullName + "\\" + supplierName + ".xls");
}
}
