public void Remove_WebMedia(string WebMediaID)
{
string Table_Name = "NexusShop_WebMedia";
string Filter = "WebMediaID = " + DataEval.QuoteText(WebMediaID);
Delete_DataRows(Table_Name, Filter);
}
public int Count_Variant_Property_Option(string Variant_PropertyID)
{
string Table_Name = "NexusShop_Product_Variant_Property_Options";
string Filter = "Variant_PropertyID = " + DataEval.QuoteText(Variant_PropertyID);
return(chk_Count(Table_Name, Filter));
}
public void Remove_Product_Variant_Spliter(string Variant_SpliterID)
{
string Table_Name = "NexusShop_Product_Variant_Spliters";
string Filter = "Variant_SpliterID = " + DataEval.QuoteText(Variant_SpliterID);
Delete_DataRows(Table_Name, Filter);
}
// 获取 Product Variant 信息
#region Get
public DataRow Get_Product_Variant(string Product_VariantID)
{
string Table_Name = "NexusShop_Product_Variants";
string Filter = "Product_VariantID = " + DataEval.QuoteText(Product_VariantID);
return(Show_ItemRow(Table_Name, null, Filter, null));
}
public int Count_Variant_Spliter(string Product_VariantID)
{
string Table_Name = "NexusShop_Product_Variant_Spliters";
string Filter = "Product_VariantID = " + DataEval.QuoteText(Product_VariantID);
return(chk_Count(Table_Name, Filter));
}
public bool Chk_Variant_Spliter_usage(string Variant_SpliterID)
{
string Table_Name = "NexusShop_Product_Variant_Properties";
string Filter = "Variant_SpliterID = " + DataEval.QuoteText(Variant_SpliterID);
return(chk_Exist(Table_Name, Filter));
}
public DataSet Get_Currency_TargetRates(string CurrencyID, string SortOrder = "")
{
string Table_Name = "NexusShop_Currency_Rate";
string Filter = "Target_CurrencyID = " + DataEval.QuoteText(CurrencyID);
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public bool Chk_Product_Variant(string Product_VariantID)
{
string Table_Name = "NexusShop_Product_Variants";
string Filter = "Product_VariantID = " + DataEval.QuoteText(Product_VariantID);
return(chk_Exist(Table_Name, Filter));
}
// 获取 Currency 信息
#region Get
public DataRow Get_Currency(string CurrencyID)
{
string Table_Name = "NexusShop_Currencies";
string Filter = "CurrencyID = " + DataEval.QuoteText(CurrencyID);
return(Show_ItemRow(Table_Name, null, Filter, null));
}
public DataRow Get_Product_Variant_Property_Option(string OptionID)
{
string Table_Name = "NexusShop_Product_Variant_Property_Options";
string Filter = "OptionID = " + DataEval.QuoteText(OptionID);
return(Show_ItemRow(Table_Name, null, Filter, null));
}
public DataRow Get_Product_Search(string ProductID)
{
string Table_Name = "View_NexusShop_Product_List";
string Filter = "ProductID = " + DataEval.QuoteText(ProductID);
return(Show_ItemRow(Table_Name, null, Filter, null));
}
public void Remove_WebMedia_ByProductID(string ProductID)
{
string Table_Name = "NexusShop_WebMedia";
string Filter = "ProductID = " + DataEval.QuoteText(ProductID);
Delete_DataRows(Table_Name, Filter);
}
// 删除 Product Variant 信息
#region Remove
public void Remove_Product_Variant(string Product_VariantID)
{
string Table_Name = "NexusShop_Product_Variants";
string Filter = "Product_VariantID = " + DataEval.QuoteText(Product_VariantID);
Delete_DataRows(Table_Name, Filter);
}
public DataSet Get_Page_Privacy_FullList(string PageIndexID)
{
string Table_Name = "View_NexusCore_Page_Privacy_List";
string Filter = "PageIndexID = " + DataEval.QuoteText(PageIndexID);
string SortOrder = "UserGroup_Name";
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public DataRow Get_Currency_Rate(string Origin_CurrencyID, string Target_CurrencyID)
{
string Table_Name = "NexusShop_Currency_Rate";
string Filter = "Origin_CurrencyID = " + DataEval.QuoteText(Origin_CurrencyID)
+ " AND "
+ "Target_CurrencyID = " + DataEval.QuoteText(Target_CurrencyID);
return(Show_ItemRow(Table_Name, null, Filter, null));
}
public void Remove_UserInGroups(string UserID, string UserGroupID)
{
string Table_Name = "NexusUser_UserInGroups";
string Filter = "UserID = " + DataEval.QuoteText(UserID)
+ " AND "
+ "UserGroupID = " + DataEval.QuoteText(UserGroupID);
Delete_DataRows(Table_Name, Filter);
}
public bool Chk_Page_Privacy(string PageIndexID, string UserGroupID)
{
string Table_Name = "NexusCore_Page_Privacies";
string Filter = "PageIndexID = " + DataEval.QuoteText(PageIndexID);
Filter += "AND "
+ "UserGroupID = " + DataEval.QuoteText(UserGroupID);
return(chk_Exist(Table_Name, Filter));
}
public DataRow Get_Page_Privacy(string PageIndexID, string UserGroupID)
{
string Table_Name = "NexusCore_Page_Privacies";
string Filter = "PageIndexID = " + DataEval.QuoteText(PageIndexID);
Filter += "AND "
+ "UserGroupID = " + DataEval.QuoteText(UserGroupID);
return(Show_ItemRow(Table_Name, null, Filter, null));
}
public bool Chk_UserInGroup(string UserID, string UserGroupID)
{
string Table_Name = "NexusUser_UserInGroups";
string Filter = "UserID = " + DataEval.QuoteText(UserID);
Filter += " AND "
+ "UserGroupID = " + DataEval.QuoteText(UserGroupID);
return(chk_Exist(Table_Name, Filter));
}
public bool Chk_Photo_Item_Mapping(string PhotoID, string CategoryID)
{
string Table_Name = "NexusPhoto_Item_Mapping";
string Filter = "PhotoID = " + DataEval.QuoteText(PhotoID);
Filter += " AND "
+ "CategoryID = " + DataEval.QuoteText(CategoryID);
return(chk_Exist(Table_Name, Filter));
}
public bool Chk_Product_Mapping(string ProductID, string CategoryID)
{
string Table_Name = "NexusShop_Product_Mapping";
string Filter = "ProductID = " + DataEval.QuoteText(ProductID);
Filter += " AND "
+ "CategoryID = " + DataEval.QuoteText(CategoryID);
return(chk_Exist(Table_Name, Filter));
}
public DataSet Get_Product_AttributeIndexes(string ProductID, bool isView, string SortOrder = "SortOrder")
{
string Table_Name = "view_NexusShop_Product_AttributeIndex_List";
string Filter = "ProductID = " + DataEval.QuoteText(ProductID);
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "SortOrder";
}
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public DataRow Get_Navigator(string PageIndexID)
{
string Table_Name = "View_NexusCore_PageIndex_List";
string Filter = "Page_CategoryID = 1";
Filter += " AND "
+ "PageIndexID = " + DataEval.QuoteText(PageIndexID);
string SortOrder = "SortOrder";
return(Show_ItemRow(Table_Name, null, Filter, SortOrder));
}
public DataSet Get_Product_Attributes(string Attribute_IndexID, string SortOrder = "SortOrder")
{
string Table_Name = "NexusShop_Product_Attributes";
string Filter = "Attribute_IndexID = " + DataEval.QuoteText(Attribute_IndexID);
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "SortOrder";
}
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public DataSet Get_Product_Variant_Properties_BySpliterID(string Variant_SpliterID, string SortOrder = "SortOrder")
{
string Table_Name = "NexusShop_Product_Variant_Properties";
string Filter = "Variant_SpliterID = " + DataEval.QuoteText(Variant_SpliterID);
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "SortOrder";
}
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public DataSet Get_WebMedia(string ProductID, string SortOrder = "SortOrder")
{
string Table_Name = "NexusShop_WebMedia";
string Filter = "ProductID = " + DataEval.QuoteText(ProductID);
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "SortOrder";
}
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public DataSet Get_Product_Mappings(string ProductID, bool isView, string SortOrder = "Category_Name")
{
string Table_Name = "view_NexusShop_Product_Cateogries";
string Filter = "ProductID = " + DataEval.QuoteText(ProductID);
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "Category_Name";
}
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
public DataSet Get_RichTexts(string CategoryID, string SortOrder)
{
string Table_Name = "NexusGeneral_RichTexts";
string Filter = "CategoryID = " + DataEval.QuoteText(CategoryID);
if (DataEval.IsEmptyQuery(SortOrder))
{
SortOrder = "Display_Name";
}
return(Show_Items(Table_Name, null, Filter, SortOrder, -1));
}
protected void Update_Data_Field_StringID(string Table_Name, List <e2Data> UpdateData)
{
string sqlCMD = "SELECT ";
bool isFirstField = true;
foreach (e2Data myUpdateDate in UpdateData)
{
if (!isFirstField)
{
sqlCMD += ", ";
}
sqlCMD += myUpdateDate.FieldName;
isFirstField = false;
}
sqlCMD += " FROM "
+ Table_Name
+ " WHERE "
+ UpdateData[0].FieldName
+ "="
+ DataEval.QuoteText(UpdateData[0].FieldValue);
using (TransactionScope ts = new TransactionScope())
{
MySqlDataAdapter sqlDbAdp = new MySqlDataAdapter(sqlCMD, MySqlConn);
DataSet myDataSet = new DataSet();
MySqlCommandBuilder myCB = new MySqlCommandBuilder(sqlDbAdp);
sqlDbAdp.Fill(myDataSet, Table_Name);
DataRow newRow = myDataSet.Tables[Table_Name].Rows[0];
foreach (e2Data myUpdateDate in UpdateData)
{
newRow[myUpdateDate.FieldName] = DbTypeConvert(myUpdateDate.FieldValue, myDataSet.Tables[Table_Name].Columns[myUpdateDate.FieldName].DataType);
}
sqlDbAdp.Update(myDataSet, Table_Name);
ts.Complete();
}
}
protected void btn_Update_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Lib.NewsMgr myNewsMgr = new Lib.NewsMgr();
string News_Date;
if (RadDateTimePicker_NewsDate.SelectedDate != null)
{
News_Date = RadDateTimePicker_NewsDate.SelectedDate.ToString();
}
else
{
News_Date = DateTime.Now.ToString();
}
e2Data[] UpdateData =
{
new e2Data("NewsID", _newsid),
new e2Data("CategoryID", CategoryTree_Menu.Selected_CategoryID),
new e2Data("UserID", Security.Users.UserStatus.Current_UserID(this.Page)),
new e2Data("UserName", Security.Users.UserStatus.Current_UserName(this.Page)),
new e2Data("News_Date", News_Date),
new e2Data("News_ModifyDate", DateTime.Now.ToString()),
new e2Data("News_Title", tbx_Title.Text),
new e2Data("News_Brief", TextEditor_ContentBrief.Content),
new e2Data("News_Content", TextEditor_NewsContent.Content),
new e2Data("News_Status", droplist_NewsStatus.SelectedValue),
new e2Data("News_Password", tbx_Password.Text),
new e2Data("Author", tbx_Author.Text),
new e2Data("Source_Name", tbx_SourceName.Text),
new e2Data("Source_URL", tbx_SourceURL.Text)
};
myNewsMgr.Edit_News_Post(UpdateData);
// Switch Category
CategoryMgr myCategoryMgr = new CategoryMgr();
myCategoryMgr.Move_ComponentInCategory_Item(_source_categoryid, CategoryTree_Menu.Selected_CategoryID, "3A79BF21-D0DF-4825-BFB2-7F6738C12BA7");
// Finish Update Close Window
string _finishupdate_script = string.Format("CloseAndRebind({0});", DataEval.QuoteText("Module_ControlPanel"));
ScriptManager.RegisterStartupScript(this.Page, typeof(Page), "myScript", _finishupdate_script, true);
}
}
