private void Update()
{
DataTable dataTableFromRepeater = this.GetDataTableFromRepeater();
int generalId = BasePage.RequestInt32("GeneralID");
this.SavePresentExp(dataTableFromRepeater, false);
if (ContentManage.Update(generalId, ContentManage.GetNewContentData(dataTableFromRepeater)))
{
ModelInfo modelInfoById = ModelManager.GetModelInfoById(this.m_ModelId);
this.AddPermissionAndCharge(dataTableFromRepeater, modelInfoById.EnableCharge);
if (modelInfoById.EnableSignIn)
{
this.UpdateSignin(generalId, dataTableFromRepeater);
}
if (((SignInType)Enum.Parse(typeof(SignInType), this.DrpSigninType.SelectedValue)) != SignInType.EnableSignInPrivate)
{
HtmlContent.CreateHtml(dataTableFromRepeater);
}
this.UpdateKeywordsToTable(generalId, dataTableFromRepeater);
if (modelInfoById.EnbaleVote)
{
this.Vote.Add(generalId);
}
SiteCache.Remove("CK_Page_Category_" + this.m_NodeId.ToString());
BasePage.ResponseRedirect(AdminPage.AppendSecurityCode("ContentShowSuccess.aspx?Action=Modify&GeneralID=" + generalId.ToString() + "&NodeID=" + this.m_NodeId.ToString() + "&ModelID=" + this.m_ModelId.ToString() + "&ContentFieldName=" + this.m_ContentFieldName));
}
else
{
AdminPage.WriteErrMsg("修改失败！");
}
}
private void Add()
{
DataTable newContentData = ContentManage.GetNewContentData(this.GetDataTableFromRepeater());
if (ContentManage.Add(this.m_ModelId, newContentData))
{
ModelInfo modelInfoById = ModelManager.GetModelInfoById(this.m_ModelId);
if (modelInfoById.EnableSignIn)
{
this.AddSignin(newContentData);
}
this.AddPermissionAndCharge(newContentData, modelInfoById.EnableCharge);
this.SavePresentExp(newContentData, true);
if (((SignInType)Enum.Parse(typeof(SignInType), this.DrpSigninType.SelectedValue)) != SignInType.EnableSignInPrivate)
{
HtmlContent.CreateHtml(newContentData);
}
this.AddKeywordsToTable(newContentData);
int generalId = GetGeneralId(newContentData);
if (modelInfoById.EnbaleVote)
{
this.Vote.Add(generalId);
}
SiteCache.Remove("CK_Page_Category_" + this.m_NodeId.ToString());
BasePage.ResponseRedirect(AdminPage.AppendSecurityCode("ContentShowSuccess.aspx?Action=Add&GeneralID=" + generalId.ToString() + "&NodeID=" + this.m_NodeId.ToString() + "&ModelID=" + this.m_ModelId.ToString() + "&ContentFieldName=" + this.m_ContentFieldName));
}
}
private void Update()
{
DataTable dataTableFromRepeater = this.GetDataTableFromRepeater();
DataRow[] rowArray = dataTableFromRepeater.Select("FieldName = 'status'");
if ((DataConverter.CLng(rowArray[0]["FieldValue"]) == 0x63) && !this.m_UserPurviewInfo.ManageSelfPublicInfo)
{
DynamicPage.WriteUserErrMsg("已经被审核通过，您不能再进行修改！");
}
DataRow[] rowArray2 = dataTableFromRepeater.Select("FieldName = 'updatetime'");
if (rowArray2.Length > 0)
{
rowArray2[0]["FieldValue"] = DateTime.Now;
}
if (this.m_UserPurviewInfo.SetToNotCheck && !this.m_UserPurviewInfo.PublicInfoNoNeedCheck)
{
rowArray[0]["FieldValue"] = "0";
}
int generalId = BasePage.RequestInt32("GeneralID");
if (ContentManage.UpdateByUser(generalId, ContentManage.GetNewContentData(dataTableFromRepeater)))
{
this.SavePresentExp(dataTableFromRepeater, this.m_UserPurviewInfo, this.m_User);
this.UpdateKeywordsToTable(generalId, dataTableFromRepeater);
DynamicPage.WriteUserSuccessMsg("修改成功！", "ContentManage.aspx");
}
else
{
DynamicPage.WriteUserErrMsg("修改失败！");
}
}
private void Add()
{
DataTable newContentData = ContentManage.GetNewContentData(this.GetDataTableFromRepeater());
UserGroupsInfo userGroupById = UserGroups.GetUserGroupById(-2);
if (userGroupById.IsNull || string.IsNullOrEmpty(userGroupById.GroupSetting))
{
DynamicPage.WriteErrMsg("匿名会员组不存在！");
}
else
{
UserPurviewInfo groupSetting = UserGroups.GetGroupSetting(userGroupById.GroupSetting);
if (groupSetting.IsNull)
{
DynamicPage.WriteErrMsg("匿名会员组没有进行权限设置！");
}
if (groupSetting.PublicInfoNoNeedCheck)
{
DataRow[] rowArray = newContentData.Select("FieldName = 'status'");
if (rowArray[0]["FieldValue"].ToString() == "0")
{
rowArray[0]["FieldValue"] = "99";
}
}
}
if (ContentManage.Add(this.m_ModelId, newContentData))
{
this.AddKeywordsToTable(newContentData);
DynamicPage.WriteSuccessMsg("添加成功！", "../../Default.aspx");
}
else
{
DynamicPage.WriteErrMsg("添加失败！");
}
}
private void Add()
{
DataTable newContentData = ContentManage.GetNewContentData(this.GetDataTableFromRepeater());
if (this.m_UserPurviewInfo == null)
{
this.m_UserPurviewInfo = new UserPurviewInfo();
this.m_UserPurviewInfo.MaxPublicInfoOneDay = -1;
this.m_UserPurviewInfo.GetExp = 1;
}
if ((this.m_UserPurviewInfo.MaxPublicInfoOneDay == 0) || (this.m_UserPurviewInfo.MaxPublicInfoOneDay > ContentManage.GetTodayPublicInfoCountByUserName(PEContext.Current.User.UserName)))
{
if (this.m_UserPurviewInfo.PublicInfoNoNeedCheck)
{
DataRow[] rowArray = newContentData.Select("FieldName = 'status'");
if (rowArray[0]["FieldValue"].ToString() == "0")
{
rowArray[0]["FieldValue"] = "99";
}
}
this.SavePresentExp(newContentData, this.m_UserPurviewInfo, this.m_User);
if (ContentManage.Add(this.m_ModelId, newContentData))
{
if (ModelManager.GetModelInfoById(this.m_ModelId).EnableCharge)
{
this.AddCharge(newContentData);
}
this.AddKeywordsToTable(newContentData);
DynamicPage.WriteUserSuccessMsg("添加成功！", "ContentManage.aspx");
}
else
{
DynamicPage.WriteUserErrMsg("添加失败！");
}
}
else
{
DynamicPage.WriteUserErrMsg("你今天发布的内容信息总数大于网站设定的值，如要添加请与管理员联系！");
}
}
public static int BatchImport(DataTable dtField, string filePath, string specialId, int nodeId, int modelId)
{
ModelInfo modelInfoById = ModelManager.GetModelInfoById(modelId);
if (modelInfoById.IsNull)
{
return(0);
}
string tableName = modelInfoById.TableName;
ProductInfo info = new ProductInfo();
info.EnableWholesale = false;
info.EnableSingleSell = true;
info.SalePromotionType = 0;
info.ProductCharacter = modelInfoById.Character;
DataTable dataTable = GetDataTableFromModel(modelId, specialId, nodeId);
info.Fields = ContentManage.GetNewContentData(dataTable);
OleDbConnection selectConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\"");
string selectCommandText = "select * from [sheet1$]";
OleDbDataAdapter adapter = new OleDbDataAdapter(selectCommandText, selectConnection);
DataSet dataSet = new DataSet();
try
{
adapter.Fill(dataSet, "ss");
}
catch (OleDbException)
{
}
StringBuilder builder = new StringBuilder();
int num2 = 0;
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
int newProductId = GetNewProductId();
info.ProductId = newProductId;
DataRow rows = dataSet.Tables[0].Rows[i];
info.ProductName = GetExcelFieldValue(rows, dtField, "ProductName", string.Empty);
info.ProductNum = GetExcelFieldValue(rows, dtField, "ProductNum", string.Empty);
if (string.IsNullOrEmpty(info.ProductNum))
{
Random random = new Random();
info.ProductNum = DateTime.Now.ToString("yyyyMMddHHmmss") + random.Next().ToString();
}
else if (IsExistSameProductNum(info.ProductNum))
{
builder.Append("<li>商品：" + info.ProductName + "的编号已存在，未导入！</li>");
continue;
}
info.Unit = GetExcelFieldValue(rows, dtField, "Unit", "个");
info.PriceInfo.Price = DataConverter.CDecimal(GetExcelFieldValue(rows, dtField, "Price", string.Empty));
info.PriceMarket = DataConverter.CDecimal(GetExcelFieldValue(rows, dtField, "Price_Market", string.Empty));
info.Weight = DataConverter.CDouble(GetExcelFieldValue(rows, dtField, "Weight", string.Empty));
info.Stocks = DataConverter.CLng(GetExcelFieldValue(rows, dtField, "Stocks", string.Empty));
info.AlarmNum = DataConverter.CLng(GetExcelFieldValue(rows, dtField, "AlarmNum", string.Empty));
info.ProducerName = GetExcelFieldValue(rows, dtField, "ProducerName", string.Empty);
info.TrademarkName = GetExcelFieldValue(rows, dtField, "TrademarkName", string.Empty);
info.BarCode = GetExcelFieldValue(rows, dtField, "BarCode", string.Empty);
info.ProductIntro = GetExcelFieldValue(rows, dtField, "ProductIntro", string.Empty);
info.ProductExplain = GetExcelFieldValue(rows, dtField, "ProductExplain", string.Empty);
info.Stars = DataConverter.CLng(GetExcelFieldValue(rows, dtField, "Stars", "3"));
info.PriceInfo.PriceMember = DataConverter.CDecimal(GetExcelFieldValue(rows, dtField, "PriceMember", string.Empty));
info.PriceInfo.PriceAgent = DataConverter.CDecimal(GetExcelFieldValue(rows, dtField, "PriceAgent", string.Empty));
DataRow[] rowArray = info.Fields.Select("FieldName='Title'");
if (rowArray.Length == 0)
{
AddNewRows(dataTable, "Title", info.ProductName, FieldType.TitleType, 0);
}
else
{
rowArray[0][1] = info.ProductName;
}
foreach (DataRow row2 in info.Fields.Select("FieldLevel=1"))
{
string str5 = GetExcelFieldValue(rows, dtField, row2["FieldName"].ToString() + "_F", string.Empty);
if (string.IsNullOrEmpty(str5))
{
goto Label_04AA;
}
FieldType fieldtype = (FieldType)Enum.Parse(typeof(FieldType), row2["FieldType"].ToString());
string name = Field.GetFieldDataType(fieldtype).Name;
if (name != null)
{
if (!(name == "Double"))
{
if (name == "Decimal")
{
goto Label_0448;
}
if (name == "DateTime")
{
goto Label_045C;
}
if (name == "Boolean")
{
goto Label_0476;
}
if (name == "Int32")
{
goto Label_048A;
}
}
else
{
str5 = DataConverter.CDouble(str5).ToString();
}
}
goto Label_049C;
Label_0448:
str5 = DataConverter.CDecimal(str5).ToString();
goto Label_049C;
Label_045C:
str5 = DataConverter.CDate(str5).ToString();
goto Label_049C;
Label_0476:
str5 = DataConverter.CBoolean(str5).ToString();
goto Label_049C;
Label_048A:
str5 = DataConverter.CLng(str5).ToString();
Label_049C:
row2["FieldValue"] = str5;
Label_04AA :;
}
bool flag = Add(modelId, tableName, info);
StockInfo stockInfo = new StockInfo();
stockInfo.StockId = StockManage.GetMaxId() + 1;
stockInfo.StockNum = StockItem.GetInStockNum();
DataRow[] rowArray3 = info.Fields.Select("FieldName='Inputer'");
if (rowArray3.Length > 0)
{
stockInfo.Inputer = rowArray3[0]["FieldValue"].ToString();
}
stockInfo.InputTime = DateTime.Now;
stockInfo.StockType = StockType.InStock;
stockInfo.Remark = "商品库存初始";
StockManage.Add(stockInfo);
if (flag)
{
IList <StockItemInfo> infoList = new List <StockItemInfo>();
StockItemInfo item = new StockItemInfo();
item.Amount = info.Stocks;
item.Price = info.PriceInfo.Price;
item.ProductId = newProductId;
item.TableName = tableName;
item.Property = string.Empty;
item.ProductNum = info.ProductNum;
item.Unit = info.Unit;
item.ProductName = info.ProductName;
infoList.Add(item);
StockItem.Add(infoList, stockInfo.StockId);
}
else
{
builder.Append("<li>商品：" + info.ProductName + "导入失败！</li>");
continue;
}
num2++;
}
s_MessgeOfBatchImport = builder.ToString();
dataSet.Dispose();
adapter.Dispose();
selectConnection.Dispose();
return(num2);
}
