/// <summary>
/// 构造函数
/// </summary>
/// <param name="large">完整资源表</param>
public GeneralLargeObject(GeneralLargeObject large)
{
this.LargeItems = new List<GeneralLargeItem>();
this.Code = large.Code;
this.Culture = large.Culture;
this.CLOB = large.CLOB;
this.Remark = large.Remark;
foreach (GeneralLargeItem item in large.LargeItems)
{
var resitem = this.LargeItems.FirstOrDefault(i => i.Culture == item.Culture && i.Deleted == false);
if (resitem == null)
this.LargeItems.Add(new GeneralLargeItem { Culture = item.Culture, CLOB = item.CLOB, Remark = item.Remark });
else
resitem.CLOB = item.CLOB;
}
}
private static void Test03()
{
LiveEntities oGeneralEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection);
// 指定Child方式
GeneralLargeItem oItemA1 = new GeneralLargeItem
{
Culture = 1033,
CLOB = "hello, this is a long text (en-US)",
Source = (byte)ModelEnum.LargeObjectSource.NONE
};
GeneralLargeItem oItemA2 = new GeneralLargeItem
{
Culture = 1036,
CLOB = "hello, this is a long text (fr-FR)",
Source = (byte)ModelEnum.LargeObjectSource.NONE
};
GeneralLargeObject oLargeA = new GeneralLargeObject
{
CLOB = "hello, there are parents",
Source = (byte)ModelEnum.LargeObjectSource.DATEBASE,
LargeItems = new List<GeneralLargeItem> { oItemA1, oItemA2 }
};
// 指定Parent方式
GeneralLargeObject oLargeB = new GeneralLargeObject
{
CLOB = "hello, there are parents",
Source = (byte)ModelEnum.LargeObjectSource.DATEBASE
};
GeneralLargeItem oItemB1 = new GeneralLargeItem
{
Culture = 1033,
CLOB = "hello, this is a long text (en-US)",
Source = (byte)ModelEnum.LargeObjectSource.NONE,
LargeObject = oLargeB
};
GeneralLargeItem oItemB2 = new GeneralLargeItem
{
Culture = 1036,
CLOB = "hello, this is a long text (fr-FR)",
Source = (byte)ModelEnum.LargeObjectSource.NONE,
LargeObject = oLargeB
};
oGeneralEntities.GeneralLargeObjects.Add(oLargeA);
oGeneralEntities.GeneralLargeItems.Add(oItemB1);
oGeneralEntities.GeneralLargeItems.Add(oItemB2);
oGeneralEntities.SaveChanges();
var oResources = oGeneralEntities.GeneralLargeObjects.Include("GeneralLargeItems");
foreach (GeneralLargeObject obj1 in oResources.ToList())
{
Console.WriteLine(obj1.CLOB);
foreach (GeneralLargeItem obj2 in obj1.LargeItems)
{
CultureInfo oCulture = new CultureInfo(obj2.Culture);
Console.WriteLine(" " + oCulture.NativeName + " " + obj2.CLOB);
}
}
oGeneralEntities.Dispose();
GC.Collect();
}
/// <summary>
/// 导入消息模板
/// </summary>
/// <param name="sExcelFile">Excel文件名</param>
/// <param name="sSheetName">Sheet名</param>
public void ImportMessageTemplate(string sExcelFile, string sSheetName)
{
try
{
ExcelData oExcel = new ExcelData(sExcelFile, sSheetName);
DataColumn colOrgan = oExcel.ExcelTable.Columns["组织"];
DataColumn colCode = oExcel.ExcelTable.Columns["代码"];
DataColumn colNameCN = oExcel.ExcelTable.Columns["中文名称"];
DataColumn colNameUS = oExcel.ExcelTable.Columns["英文名称"];
DataColumn colMatterCN = oExcel.ExcelTable.Columns["中文内容"];
DataColumn colMatterUS = oExcel.ExcelTable.Columns["英文内容"];
DataColumn colRemark = oExcel.ExcelTable.Columns["备注"];
foreach (DataRow row in oExcel.ExcelTable.Rows)
{
string sOrganCode = row[colOrgan].ToString();
var oOrgan = (from o in dbEntity.MemberOrganizations
where o.Code == sOrganCode && o.Otype == (byte)ModelEnum.OrganizationType.CORPORATION
select o).FirstOrDefault();
string sCode = row[colCode].ToString();
GeneralResource oName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colNameCN].ToString(), 1033, row[colNameUS].ToString());
GeneralLargeObject oMatter = new GeneralLargeObject(2052, row[colMatterCN].ToString(), 1033, row[colMatterUS].ToString());
string sRemark = row[colRemark].ToString();
var oTemplate = (from t in dbEntity.GeneralMessageTemplates
where t.OrgID == oOrgan.Gid && t.Code == sCode
select t).FirstOrDefault();
if (oTemplate == null)
{
oTemplate = new GeneralMessageTemplate { Organization = oOrgan, Code = sCode };
dbEntity.GeneralMessageTemplates.Add(oTemplate);
}
if (oTemplate.Name == null)
oTemplate.Name = oName;
else
oTemplate.Name.SetResource(ModelEnum.ResourceType.STRING, oName);
if (oTemplate.Matter == null)
oTemplate.Matter = oMatter;
else
oTemplate.Matter.SetLargeObject(oMatter);
oTemplate.Remark = sRemark;
dbEntity.SaveChanges();
if (Utility.ConfigHelper.GlobalConst.IsDebug)
Debug.WriteLine("{0} {1} {2}", this.ToString(), sCode, sRemark);
}
oEventBLL.WriteEvent(String.Format("导入GeneralMessageTemplate成功: {0} {1}", sExcelFile, sSheetName),
ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
catch (Exception ex)
{
oEventBLL.WriteEvent(String.Format("导入GeneralMessageTemplate错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message),
ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
}
/// <summary>
/// 导入面单模板
/// </summary>
/// <param name="sExcelFile">Excel文件名</param>
/// <param name="sSheetName">Sheet名</param>
public void ImportShippingEnvelope(string sExcelFile, string sSheetName)
{
try
{
ExcelData oExcel = new ExcelData(sExcelFile, sSheetName);
DataColumn colOrgan = oExcel.ExcelTable.Columns["组织"];
DataColumn colShipper = oExcel.ExcelTable.Columns["承运商"];
DataColumn colCode = oExcel.ExcelTable.Columns["代码"];
DataColumn colStatus = oExcel.ExcelTable.Columns["状态"];
DataColumn colDescription = oExcel.ExcelTable.Columns["描述"];
DataColumn colMatterCN = oExcel.ExcelTable.Columns["中文内容"];
DataColumn colMatterUS = oExcel.ExcelTable.Columns["英文内容"];
DataColumn colRemark = oExcel.ExcelTable.Columns["备注"];
foreach (DataRow row in oExcel.ExcelTable.Rows)
{
string sOrganCode = row[colOrgan].ToString();
string sShipper = row[colShipper].ToString();
var oShipping = (from s in dbEntity.ShippingInformations
where s.Parent.Code == sOrganCode && s.Code == sShipper
&& s.Otype == (byte)ModelEnum.OrganizationType.SHIPPER
select s).FirstOrDefault();
string sCode = row[colCode].ToString();
byte nStatus;
Byte.TryParse(row[colStatus].ToString(), out nStatus);
string sDescription = row[colDescription].ToString();
GeneralLargeObject oTemplate = new GeneralLargeObject(2052, row[colMatterCN].ToString(), 1033, row[colMatterUS].ToString());
string sRemark = row[colRemark].ToString();
var oEnvelope = (from e in dbEntity.ShippingEnvelopes
where e.Deleted == false
&& e.ShipID == oShipping.Gid && e.Code == sCode
select e).FirstOrDefault();
if (oEnvelope == null)
{
oEnvelope = new ShippingEnvelope { Shipping = oShipping, Code = sCode };
dbEntity.ShippingEnvelopes.Add(oEnvelope);
}
oEnvelope.Estatus = nStatus;
oEnvelope.Matter = sDescription;
if (oEnvelope.Template == null)
oEnvelope.Template = oTemplate;
else
oEnvelope.Template.SetLargeObject(oTemplate);
oTemplate.Remark = sRemark;
dbEntity.SaveChanges();
if (Utility.ConfigHelper.GlobalConst.IsDebug)
Debug.WriteLine("{0} {1} {2}", this.ToString(), sCode, sRemark);
}
oEventBLL.WriteEvent(String.Format("导入ImportShippingEnvelope成功: {0} {1}", sExcelFile, sSheetName),
ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
catch (Exception ex)
{
oEventBLL.WriteEvent(String.Format("导入ImportShippingEnvelope错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message),
ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
}
/// <summary>
/// 导入商品定义，包括PU和SKU
/// </summary>
/// <param name="sExcelFile">Excel文件名</param>
/// <param name="sSheetName">Sheet名</param>
public void ImportProduct(string sExcelFile, string sSheetName)
{
try
{
ExcelData oExcel = new ExcelData(sExcelFile, sSheetName);
DataColumn colOrgan = oExcel.ExcelTable.Columns["组织"];
DataColumn colProdCode = oExcel.ExcelTable.Columns["PU代码"];
DataColumn colSkuCode = oExcel.ExcelTable.Columns["SKU代码"];
DataColumn colBarcode = oExcel.ExcelTable.Columns["条码"];
DataColumn colExCode1 = oExcel.ExcelTable.Columns["自定义编码"];
DataColumn colProdNameCN = oExcel.ExcelTable.Columns["PU中文名称"];
DataColumn colSkuNameCN = oExcel.ExcelTable.Columns["SKU中文名称"];
DataColumn colStdCat = oExcel.ExcelTable.Columns["标准分类"];
DataColumn colPrvCat = oExcel.ExcelTable.Columns["私有分类"];
DataColumn colBlock = oExcel.ExcelTable.Columns["拆单分组标志"];
DataColumn colMode = oExcel.ExcelTable.Columns["产品模式"];
DataColumn colUnitType = oExcel.ExcelTable.Columns["单位类型"];
DataColumn colUnitCode = oExcel.ExcelTable.Columns["单位代码"];
DataColumn colPercision = oExcel.ExcelTable.Columns["计量精度"];
DataColumn colSpecification = oExcel.ExcelTable.Columns["规格"];
DataColumn colProdPicture = oExcel.ExcelTable.Columns["主图路径"];
DataColumn colBriefCN = oExcel.ExcelTable.Columns["简单描述"];
DataColumn colIntroCN = oExcel.ExcelTable.Columns["详细描述"];
DataColumn colMinQuantity = oExcel.ExcelTable.Columns["起订量"];
DataColumn colCycle = oExcel.ExcelTable.Columns["生产周期"];
DataColumn colGuarantee = oExcel.ExcelTable.Columns["保质期"];
DataColumn colMarketPriceRMB = oExcel.ExcelTable.Columns["市场价￥"];
DataColumn colSuggestPriceRMB = oExcel.ExcelTable.Columns["建议价￥"];
DataColumn colLowestPriceRMB = oExcel.ExcelTable.Columns["最低价￥"];
DataColumn colKeywords = oExcel.ExcelTable.Columns["关键词"];
DataColumn colGrossWeight = oExcel.ExcelTable.Columns["毛重"];
DataColumn colNetWeight = oExcel.ExcelTable.Columns["净重"];
DataColumn colGrossVolume = oExcel.ExcelTable.Columns["毛体积"];
DataColumn colNetVolume = oExcel.ExcelTable.Columns["净体积"];
DataColumn colNetPiece = oExcel.ExcelTable.Columns["计件"];
DataColumn colRemark = oExcel.ExcelTable.Columns["备注"];
ProductInformation oProduct = null;
MemberOrganization oOrgan = null;
foreach (DataRow row in oExcel.ExcelTable.Rows)
{
string sOrgan = row[colOrgan].ToString();
if (!String.IsNullOrEmpty(sOrgan))
oOrgan = (from o in dbEntity.MemberOrganizations
where o.Code == sOrgan && o.Otype == (byte)ModelEnum.OrganizationType.CORPORATION
select o).FirstOrDefault();
string sProdCode = row[colProdCode].ToString();
string sSkuCode = row[colSkuCode].ToString();
if (String.IsNullOrEmpty(sSkuCode)) continue;
string sBarcode = row[colBarcode].ToString();
string sExCode1 = row[colExCode1].ToString();
GeneralResource oProdName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colProdNameCN].ToString());
GeneralResource oSkuName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colSkuNameCN].ToString());
GeneralResource oFullName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colProdNameCN].ToString() + row[colSkuNameCN].ToString());
GeneralResource oShortName = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colSkuNameCN].ToString());
string sStdCat = row[colStdCat].ToString();
string sPrvCat = row[colPrvCat].ToString();
byte nBlock;
Byte.TryParse(row[colBlock].ToString(), out nBlock);
byte nMode;
Byte.TryParse(row[colMode].ToString(), out nMode);
byte nUnitType;
Byte.TryParse(row[colUnitType].ToString(), out nUnitType);
string sUnitCode = row[colUnitCode].ToString();
byte nPercision;
Byte.TryParse(row[colPercision].ToString(), out nPercision);
GeneralResource oSpecification = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colSpecification].ToString());
string sProdPicture = row[colProdPicture].ToString();
GeneralResource oBrief = new GeneralResource(ModelEnum.ResourceType.STRING, 2052, row[colBriefCN].ToString());
GeneralLargeObject oIntro = new GeneralLargeObject(2052, row[colIntroCN].ToString());
decimal nMinQuantity;
Decimal.TryParse(row[colMinQuantity].ToString(), out nMinQuantity);
int nCycle;
Int32.TryParse(row[colCycle].ToString(), out nCycle);
int nGuarantee;
Int32.TryParse(row[colGuarantee].ToString(), out nGuarantee);
decimal nMarketPriceRMB;
Decimal.TryParse(row[colMarketPriceRMB].ToString(), out nMarketPriceRMB);
decimal nSuggestPriceRMB;
Decimal.TryParse(row[colSuggestPriceRMB].ToString(), out nSuggestPriceRMB);
decimal nLowestPriceRMB;
Decimal.TryParse(row[colLowestPriceRMB].ToString(), out nLowestPriceRMB);
string sKeywords = row[colKeywords].ToString();
decimal nGrossWeight;
Decimal.TryParse(row[colGrossWeight].ToString(), out nGrossWeight);
decimal nNetWeight;
Decimal.TryParse(row[colNetWeight].ToString(), out nNetWeight);
decimal nGrossVolume;
Decimal.TryParse(row[colGrossVolume].ToString(), out nGrossVolume);
decimal nNetVolume;
Decimal.TryParse(row[colNetVolume].ToString(), out nNetVolume);
int nNetPiece;
Int32.TryParse(row[colNetPiece].ToString(), out nNetPiece);
string sRemark = row[colRemark].ToString();
if (!String.IsNullOrEmpty(sProdCode))
{
// 导入产品主表
oProduct = (from p in dbEntity.ProductInformations
where p.OrgID == oOrgan.Gid && p.Code == sProdCode
select p).FirstOrDefault();
if (oProduct == null)
{
oProduct = new ProductInformation { Organization = oOrgan, Code = sProdCode };
dbEntity.ProductInformations.Add(oProduct);
}
if (oProduct.Name == null)
oProduct.Name = oProdName;
else
oProduct.Name.SetResource(ModelEnum.ResourceType.STRING, oProdName);
oProduct.StandardCategory = dbEntity.GeneralStandardCategorys.Where(c => c.Code == sStdCat && c.Ctype == (byte)ModelEnum.StandardCategoryType.PRODUCT).FirstOrDefault();
oProduct.Block = nBlock;
oProduct.Mode = nMode;
oProduct.Picture = sProdPicture;
if (oProduct.Brief == null)
oProduct.Brief = oBrief;
else
oProduct.Brief.SetResource(ModelEnum.ResourceType.STRING, oBrief);
if (oProduct.Matter == null)
oProduct.Matter = oIntro;
else
oProduct.Matter.SetLargeObject(oIntro);
oProduct.MinQuantity = nMinQuantity;
oProduct.ProductionCycle = nCycle;
oProduct.GuaranteeDays = nGuarantee;
oProduct.Keywords = sKeywords;
oProduct.Remark = sRemark;
dbEntity.SaveChanges();
}
// 导入产品SKU表
var oProdItem = (from i in dbEntity.ProductInfoItems
where i.OrgID == oOrgan.Gid && i.Code == sSkuCode
select i).FirstOrDefault();
if (oProdItem == null)
{
oProdItem = new ProductInfoItem { Organization = oOrgan, Code = sSkuCode };
dbEntity.ProductInfoItems.Add(oProdItem);
}
oProdItem.Product = oProduct;
oProdItem.Barcode = (String.IsNullOrEmpty(sBarcode)) ? sSkuCode : sBarcode;
oProdItem.CodeEx1 = sExCode1;
if (oProdItem.FullName == null)
oProdItem.FullName = oFullName;
else
oProdItem.FullName.SetResource(ModelEnum.ResourceType.STRING, oFullName);
if (oProdItem.ShortName == null)
oProdItem.ShortName = oShortName;
else
oProdItem.ShortName.SetResource(ModelEnum.ResourceType.STRING, oShortName);
oProdItem.StandardUnit = dbEntity.GeneralMeasureUnits.Where(u => u.Code == sUnitCode && u.Utype == nUnitType).FirstOrDefault();
if (oProdItem.Specification == null)
oProdItem.Specification = oSpecification;
else
oProdItem.Specification.SetResource(ModelEnum.ResourceType.STRING, oSpecification);
var oCurrency = (from u in dbEntity.GeneralMeasureUnits
where u.Utype == (byte)ModelEnum.MeasureUnit.CURRENCY && u.Code == "¥"
select u).FirstOrDefault();
if (oProdItem.MarketPrice == null)
oProdItem.MarketPrice = new GeneralResource(ModelEnum.ResourceType.MONEY, oCurrency.Gid, nMarketPriceRMB);
else
oProdItem.MarketPrice.SetResource(ModelEnum.ResourceType.MONEY, oCurrency.Gid, nMarketPriceRMB);
if (oProdItem.SuggestPrice == null)
oProdItem.SuggestPrice = new GeneralResource(ModelEnum.ResourceType.MONEY, oCurrency.Gid, nSuggestPriceRMB);
else
oProdItem.SuggestPrice.SetResource(ModelEnum.ResourceType.MONEY, oCurrency.Gid, nSuggestPriceRMB);
if (oProdItem.LowestPrice == null)
oProdItem.LowestPrice = new GeneralResource(ModelEnum.ResourceType.MONEY, oCurrency.Gid, nLowestPriceRMB);
else
oProdItem.LowestPrice.SetResource(ModelEnum.ResourceType.MONEY, oCurrency.Gid, nLowestPriceRMB);
oProdItem.GrossWeight = nGrossWeight;
oProdItem.NetWeight = nNetWeight;
oProdItem.GrossVolume = nGrossVolume;
oProdItem.NetVolume = nNetVolume;
oProdItem.NetPiece = nNetPiece;
oProdItem.Remark = sRemark;
dbEntity.SaveChanges();
if (Utility.ConfigHelper.GlobalConst.IsDebug)
Debug.WriteLine("{0} {1} {2} {3} {4}", this.ToString(), sProdCode, oProdName.Matter, oSkuName.Matter, sRemark);
}
oEventBLL.WriteEvent(String.Format("导入ProductInformation成功: {0} {1}", sExcelFile, sSheetName),
ModelEnum.ActionLevel.GENERIC, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
catch (Exception ex)
{
oEventBLL.WriteEvent(String.Format("导入ProductInformation错误: {0} {1} {2}", sExcelFile, sSheetName, ex.Message),
ModelEnum.ActionLevel.ERROR, ModelEnum.ActionSource.SYSTEM, this.ToString());
}
}
/// <summary>
/// 产生多语言的大对象资源文件
/// </summary>
/// <param name="organID">组织，空则表示用系统支持的所有语言</param>
/// <returns>新资源文件</returns>
public GeneralLargeObject NewLargeObject(Guid? organID = null)
{
GeneralLargeObject oLarge = new GeneralLargeObject();
List<GeneralCultureUnit> oCultures = this.GetSupportCultures(organID);
bool bIsFirst = true;
foreach (var item in oCultures)
{
if (bIsFirst)
oLarge.Culture = item.Culture;
else
oLarge.LargeItems.Add(new GeneralLargeItem { Culture = item.Culture });
bIsFirst = false;
}
return oLarge;
}
/// <summary>
/// 更新已经存在的大对象资源文件，包括插入新语言，删除过期的语言等
/// </summary>
/// <param name="large">原资源文件</param>
/// <param name="organID">组织ID，空表示用系统支持的语言/货币刷新</param>
/// <returns>新资源文件</returns>
public GeneralLargeObject RefreshLargeObject(GeneralLargeObject large, Guid? organID = null)
{
GeneralLargeObject oLarge = large;
if (oLarge == null)
oLarge = this.NewLargeObject(organID);
List<Guid> oGuidList = new List<Guid>();
List<GeneralCultureUnit> oCultures = this.GetSupportCultures(organID);
bool bIsFirst = true;
foreach (var item in oCultures)
{
if (bIsFirst)
{
oLarge.Culture = item.Culture;
}
else
{
var resitem = oLarge.LargeItems.FirstOrDefault(i => i.Culture == item.Culture && i.Deleted == false);
if (resitem == null)
oLarge.LargeItems.Add(new GeneralLargeItem { Culture = item.Culture });
else
oGuidList.Add(resitem.Gid);
}
bIsFirst = false;
}
// 删除过时的语言资源
for (int i = 0; i < oLarge.LargeItems.Count; i++)
{
var item = oLarge.LargeItems.ElementAt(i);
if (!item.Gid.Equals(Guid.Empty) && !oGuidList.Contains(item.Gid))
oLarge.LargeItems.Remove(item);
}
return oLarge;
}
/// <summary>
/// 构造函数
/// </summary>
/// <param name="nCulture">语言</param>
/// <param name="sCLOB">大字符串</param>
/// <param name="oLargeObject">主资源文件</param>
public GeneralLargeItem(short nCulture, string sCLOB, GeneralLargeObject oLargeObject)
{
this.Culture = nCulture;
this.CLOB = sCLOB;
this.LargeObject = oLargeObject;
}
/// <summary>
/// 更新已经存在的大对象资源文件，包括插入新语言，删除过期的语言等
/// </summary>
/// <param name="large">原资源文件</param>
/// <param name="organID">组织ID，空表示用系统支持的语言/货币刷新</param>
/// <returns>新资源文件</returns>
public GeneralLargeObject RefreshLargeObject(GeneralLargeObject large, Guid? organID = null)
{
return oGeneralBLL.RefreshLargeObject(large, organID);
}
public void MemberTest3()
{
LiveEntities oLiveEntities = new LiveEntities(ConfigHelper.LiveConnection.Connection);
GeneralLargeItem LargeItemA = new GeneralLargeItem
{
//LargeObject = LargeObjectA,
Culture = 1024,
CLOB = "this is a test LargeItem",
FileType = ".txt",
Source = (byte)ModelEnum.LargeObjectSource.DATEBASE,
ObjUrl = "/123/23/3"
};
GeneralLargeItem LargeItemB = new GeneralLargeItem
{
//LargeObject = LargeObjectB,
Culture = 2011,
CLOB = "this is the other test LargeItem",
FileType = ".php",
Source = (byte)ModelEnum.LargeObjectSource.NONE,
ObjUrl = "/1abc"
};
GeneralLargeObject LargeObjectA = new GeneralLargeObject
{
Code = "LargeObjectA",
Culture = 1033,
CLOB = "this is a LargeObject CLOB",
FileType = ".jpg",
ObjUrl = "/zhuchao/123",
LargeItems = new List<GeneralLargeItem> { LargeItemA, LargeItemB},
Source = (byte)ModelEnum.LargeObjectSource.DATEBASE
};
oLiveEntities.GeneralLargeObjects.Add(LargeObjectA);
oLiveEntities.SaveChanges();
//Console.WriteLine(LargeItemA.Gid);
//Console.WriteLine(LargeObjectA.Gid);
oLiveEntities.Dispose();
GC.Collect();
}
/// <summary>
/// 保存详情
/// </summary>
/// <param name="oProductInfo">产品页面对象</param>
/// <returns></returns>
public bool saveProductInfoDetail(ProductInformation model)
{
try
{
ProductInformation oProductInformation = dbEntity.ProductInformations.Include("Brief").Include("Matter").Where(p => p.Deleted == false && p.Gid == model.Gid).Single();
oProductInformation.Brief.SetResource(ModelEnum.ResourceType.STRING, model.Brief);
///////////////////////////////////待更改/////////////////////////////////////////////////////
if (oProductInformation.Matter == null)
{
GeneralLargeObject oClob = new GeneralLargeObject();
oClob.CLOB = model.Matter.CLOB;
dbEntity.GeneralLargeObjects.Add(oClob);
dbEntity.SaveChanges();
oProductInformation.aMatter = oClob.Gid;
}
else
{
oProductInformation.Matter.CLOB = model.Matter.CLOB;
}
////////////////////////////////////////////////////////////////////////////////////////////////
dbEntity.SaveChanges();
}
catch (Exception)
{
return false;
}
return true;
}
/// <summary>
/// 测试方法，最终废弃不用
/// </summary>
/// <returns></returns>
public ViewResult TestEditLargeMatter()
{
GeneralLargeItem item = new GeneralLargeItem
{
Culture = 1033,
CLOB = "<p style='color:Green'>English</p>",
};
GeneralLargeObject obj = new GeneralLargeObject
{
Culture = 2052,
CLOB = "<p style='color:Red'>中文</p>",
LargeItems = new List<GeneralLargeItem>
{
item
}
};
dbEntity.GeneralLargeObjects.Add(obj);
dbEntity.SaveChanges();
return View(obj);
}