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); } }