public static void fn商品更新(CProduct product) { string sql = $"EXEC 商品更新 "; sql += $"@{CProductKey.fProductId},"; sql += $"@{CProductKey.fName},"; sql += $"@{CProductKey.fDescription},"; sql += $"@{CProductKey.fContent},"; sql += $"@{CProductKey.fPrice},"; sql += $"@{CProductKey.fLaunchDate},"; sql += $"@{CProductKey.fTheRemovedDate},"; sql += $"@{CProductKey.fDownloadTimes},"; sql += $"@{CProductKey.fLikeCount},"; sql += $"@{CProductKey.fMemberSellerId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CProductKey.fProductId, product.fProductId), new SqlParameter(CProductKey.fName, product.fName), new SqlParameter(CProductKey.fDescription, product.fDescription), new SqlParameter(CProductKey.fContent, product.fContent), new SqlParameter(CProductKey.fPrice, product.fPrice), new SqlParameter(CProductKey.fLaunchDate, product.fLaunchDate), new SqlParameter(CProductKey.fTheRemovedDate, (object)product.fTheRemovedDate ?? DBNull.Value), //可NULL new SqlParameter(CProductKey.fDownloadTimes, product.fDownloadTimes), new SqlParameter(CProductKey.fLikeCount, product.fLikeCount), new SqlParameter(CProductKey.fMemberSellerId, product.fMemberSellerId) }; CDbManager.executeSql(sql, paras); }
public static CProduct fn商品新增(CMember member, CProduct product) { string sql = $"EXEC 商品新增 "; sql += $"@{CProductKey.fName},"; sql += $"@{CProductKey.fDescription},"; sql += $"@{CProductKey.fContent},"; sql += $"@{CProductKey.fPrice},"; sql += $"@{CProductKey.fLaunchDate},"; sql += $"@{CProductKey.fTheRemovedDate},"; sql += $"@{CProductKey.fDownloadTimes},"; sql += $"@{CProductKey.fLikeCount},"; sql += $"@{CProductKey.fMemberSellerId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CProductKey.fName, product.fName), new SqlParameter(CProductKey.fDescription, product.fDescription), new SqlParameter(CProductKey.fContent, product.fContent), new SqlParameter(CProductKey.fPrice, product.fPrice), new SqlParameter(CProductKey.fLaunchDate, product.fLaunchDate), new SqlParameter(CProductKey.fTheRemovedDate, (object)product.fTheRemovedDate ?? DBNull.Value), //可NULL new SqlParameter(CProductKey.fDownloadTimes, product.fDownloadTimes), new SqlParameter(CProductKey.fLikeCount, product.fLikeCount), new SqlParameter(CProductKey.fMemberSellerId, member.fMemberId) }; CDbManager.executeSql(sql, paras); CProduct NewProduct = fn商品查詢().LastOrDefault(); return(NewProduct); }
public static void fn留言更新(CComment comment) { string sql = $"EXEC 留言更新 @{CCommentKey.fCommentId},"; sql += $"@{CCommentKey.fCommentDateTime},"; sql += $"@{CCommentKey.fContent},"; sql += $"@{CCommentKey.fIsRetract},"; sql += $"@{CCommentKey.fLikeCount},"; sql += $"@{CCommentKey.fIsBanned},"; sql += $"@{CCommentKey.fProductId},"; sql += $"@{CCommentKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CCommentKey.fCommentId, comment.fCommentId), new SqlParameter(CCommentKey.fCommentDateTime, comment.fCommentDateTime), new SqlParameter(CCommentKey.fContent, comment.fContent), new SqlParameter(CCommentKey.fIsRetract, comment.fIsRetract), new SqlParameter(CCommentKey.fLikeCount, comment.fLikeCount), new SqlParameter(CCommentKey.fIsBanned, comment.fIsBanned), new SqlParameter(CCommentKey.fProductId, comment.fProductId), new SqlParameter(CCommentKey.fMemberId, comment.fMemberId) }; CDbManager.executeSql(sql, paras); }
public static void fn訂單私人筆記新增(CNote note) { string sql = $"EXEC 私人筆記新增 "; sql += $"@{CNoteKey.fNoteListName},"; sql += $"@{CNoteKey.fCreateDateTime},"; sql += $"@{CNoteKey.fEditDateTime},"; sql += $"@{CNoteKey.fNoteListLevel},"; sql += $"@{CNoteKey.fIsMyFavourite},"; sql += $"@{CNoteKey.fIsTrash},"; sql += $"@{CNoteKey.fHTMLContent},"; sql += $"@{CNoteKey.fJsonContent},"; sql += $"@{CNoteKey.fTheShareLink},"; sql += $"@{CNoteKey.fTheContactPerson},"; sql += $"@{CNoteKey.fFolderId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CNoteKey.fNoteListName, note.fNoteListName), new SqlParameter(CNoteKey.fCreateDateTime, note.fCreateDateTime), new SqlParameter(CNoteKey.fEditDateTime, note.fEditDateTime), new SqlParameter(CNoteKey.fNoteListLevel, note.fNoteListLevel), new SqlParameter(CNoteKey.fIsMyFavourite, note.fIsMyFavourite), new SqlParameter(CNoteKey.fIsTrash, note.fIsTrash), new SqlParameter(CNoteKey.fHTMLContent, note.fHTMLContent), new SqlParameter(CNoteKey.fJsonContent, note.fJsonContent), new SqlParameter(CNoteKey.fTheShareLink, (object)note.fTheShareLink ?? DBNull.Value), //可NULL new SqlParameter(CNoteKey.fTheContactPerson, (object)note.fTheContactPerson ?? DBNull.Value), //可NULL new SqlParameter(CNoteKey.fFolderId, note.fFolderId) }; CDbManager.executeSql(sql, paras); }
public static List <CComment> fn留言查詢() { string sql = $"EXEC 留言查詢"; List <CComment> IsComment = (List <CComment>)CDbManager.querySql(sql, null, reader留言查詢); return(IsComment); }
public static List <CDetailOrder> fn訂單明細查詢() { string sql = $"EXEC 訂單明細查詢"; List <CDetailOrder> IsCDetailOrder = (List <CDetailOrder>)CDbManager.querySql(sql, null, reader訂單明細查詢); return(IsCDetailOrder); }
public static void 管理員更新(CAdmin admin) { string sql = $"EXEC 管理員更新 "; sql += $"@{CAdminKey.fAdminId},"; sql += $"@{CAdminKey.fAdminAccount},"; sql += $"@{CAdminKey.fAdminPassword},"; sql += $"@{CAdminKey.fName},"; sql += $"@{CAdminKey.fGender},"; sql += $"@{CAdminKey.fBirthDay},"; sql += $"@{CAdminKey.fTheAddress},"; sql += $"@{CAdminKey.fMobilePhone},"; sql += $"@{CAdminKey.fThePhoto},"; sql += $"@{CAdminKey.fHireDateTime},"; sql += $"@{CAdminKey.fLastLoginDateTime}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CAdminKey.fAdminId, admin.fAdminId), new SqlParameter(CAdminKey.fAdminAccount, admin.fAdminAccount), new SqlParameter(CAdminKey.fAdminPassword, admin.fAdminPassword), new SqlParameter(CAdminKey.fName, admin.fName), new SqlParameter(CAdminKey.fGender, admin.fGender), new SqlParameter(CAdminKey.fBirthDay, admin.fBirthDay), new SqlParameter(CAdminKey.fTheAddress, (object)admin.fTheAddress ?? DBNull.Value), //可NULL new SqlParameter(CAdminKey.fMobilePhone, admin.fMobilePhone), new SqlParameter(CAdminKey.fThePhoto, (object)admin.fThePhoto ?? DBNull.Value), //可NULL new SqlParameter(CAdminKey.fHireDateTime, admin.fHireDateTime), new SqlParameter(CAdminKey.fLastLoginDateTime, admin.fLastLoginDateTime) }; CDbManager.executeSql(sql, paras); }
public static void fn會員瀏覽紀錄新增(CMember member) { string sql = $"EXEC 會員瀏覽紀錄新增 @{CMemberBrowseKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CMemberBrowseKey.fMemberId, member.fMemberId) }; CDbManager.executeSql(sql, paras); }
//==========================購物車個人商品查詢==========================// public static List <CCartProduct> fn購物車商品個人查詢(int cartid) { string sql = $"EXEC 購物車商品個人查詢 @{CCartProductKey.fCartId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CCartProductKey.fCartId, cartid) }; return((List <CCartProduct>)CDbManager.querySql(sql, paras, reader購物車商品個人查詢)); }
public static void fn聊聊更新(int a) { string sql = $"EXEC 聊聊更新 @{CChatKey.fChatId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CChatKey.fChatId, a) }; CDbManager.executeSql(sql, paras); }
public static void fn會員更新點數(CMember member, int point) { string sql = $"EXEC 會員更新點數 @{CMemberKey.fMemberId},@{CMemberKey.fMoneyPoint}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CMemberKey.fMemberId, member.fMemberId), new SqlParameter(CMemberKey.fMoneyPoint, point) }; CDbManager.executeSql(sql, paras); }
public static List <CMemberOrderSelectVM> fn會員訂單個人查詢(CMember m) { string sql = $"EXEC 訂單明細個人查詢 "; sql += $"@{CMemberOrderSelectVMKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter(CMemberOrderSelectVMKey.fMemberId, m.fMemberId)); return((List <CMemberOrderSelectVM>)CDbManager.querySql(sql, paras, reader會員訂單個人查詢)); }
public static List <CBlackList> fn黑名單查詢() { string sql = $"EXEC 黑名單查詢"; //List<SqlParameter> paras = new List<SqlParameter>() //{ // new SqlParameter(CBlackListKey.fMemberId, member.fMemberId) //}; List <CBlackList> lsBlackList = (List <CBlackList>)CDbManager.querySql(sql, null, reader黑名單查詢); return(lsBlackList); }
public static List <CIncome> fn公司收入查詢() { string sql = $"EXEC 公司收入查詢"; //List<SqlParameter> paras = new List<SqlParameter>() //{ // new SqlParameter(CIncomeKey.fMemberId, member.fMemberId) //}; /*List<CIncome> lsIncome =*/ return((List <CIncome>)CDbManager.querySql(sql, null, reader公司收入查詢)); //return lsIncome; }
public static void fn筆記資料夾更新(CNoteFolder noteFolder) { string sql = $"EXEC 筆記資料夾更新 @{CNoteFolderKey.fFolderId}, @{ CNoteFolderKey.fFolderName}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CNoteFolderKey.fFolderId, noteFolder.fFolderId), new SqlParameter(CNoteFolderKey.fFolderName, noteFolder.fFolderName) }; CDbManager.executeSql(sql, paras); }
public static List <CNoteFolder> fn筆記資料夾查詢(CMember member) { string sql = $"EXEC 筆記資料夾查詢 @{CNoteFolderKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CNoteFolderKey.fMemberId, member.fMemberId) }; List <CNoteFolder> lsNoteFolder = (List <CNoteFolder>)CDbManager.querySql(sql, paras, reader筆記資料夾查詢); return(lsNoteFolder); }
public static List <CProductRank> fn評價查詢(int productid) { string sql = $"EXEC 評價查詢 @{CDetailOrderKey.fProductId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CDetailOrderKey.fProductId, productid), }; List <CProductRank> IsCProductRank = (List <CProductRank>)CDbManager.querySql(sql, paras, reader評價查詢); return(IsCProductRank); }
public static List <CProducttotal> fn評價個人查詢(int orderid) { string sql = $"EXEC 評價個人查詢 @{CProducttotalKey.fRank}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CProducttotalKey.fRank, orderid), }; List <CProducttotal> IsProducttotal = (List <CProducttotal>)CDbManager.querySql(sql, paras, reader評價個人查詢); return(IsProducttotal); }
public static List <CChat> fn聊聊查詢(CMember member) { string sql = $"EXEC 聊聊查詢 @{CChatKey.fMemberFrom}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CChatKey.fMemberFrom, member.fMemberId) }; List <CChat> lsChat = (List <CChat>)CDbManager.querySql(sql, paras, reader聊聊查詢); return(lsChat); }
//=========================== 購物車個人更新 =========================== // public static void fn購物車個人更新(int cartid) { string sql = $"EXEC 購物車個人更新 @{CCartKey.fCartId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CCartKey.fCartId, cartid), }; CDbManager.executeSql(sql, paras); }
public static List <COrder> fn訂單查詢(CMember member) { string sql = $"EXEC 訂單查詢 @{COrderKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(COrderKey.fMemberId, member.fMemberId) }; List <COrder> IsCOrder = (List <COrder>)CDbManager.querySql(sql, paras, reader訂單查詢); return(IsCOrder); }
public static void fn聊聊已讀更新(int a, CMember member) { string sql = $"EXEC 聊聊已讀更新 @{CChatKey.fMemberFrom},@{CChatKey.fMemberTo}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CChatKey.fMemberFrom, a), new SqlParameter(CChatKey.fMemberTo, member.fMemberId) }; CDbManager.executeSql(sql, paras); }
public static List <CVersion> fn筆記版本控制查詢用VersionID查(int versionId) { string sql = $"EXEC 筆記版本控制查詢用VersionID查 "; sql += $"@{CVersionKey.fVersionId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CVersionKey.fVersionId, versionId) }; return((List <CVersion>)CDbManager.querySql(sql, paras, reader筆記版本控制查詢用VersionID查)); }
public static List <CChat> fn聊聊個人查詢(CMember member, int a) { string sql = $"EXEC 聊聊個人查詢 @{CChatKey.fMemberFrom},@{CChatKey.fMemberTo}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CChatKey.fMemberFrom, member.fMemberId), new SqlParameter(CChatKey.fMemberTo, a) }; List <CChat> IsChatBeau = (List <CChat>)CDbManager.querySql(sql, paras, reader聊聊個人查詢); return(IsChatBeau); }
public static List <CSetting> fn會員系統設定查詢(CMember member) { string sql = $"EXEC 系統設定查詢 "; sql += $"@{CMemberKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter(CSettingKey.fMemberId, member.fMemberId)); return((List <CSetting>)CDbManager.querySql(sql, paras, reader查詢系統設定)); }
public static List <CNotice> fn通知訊息查詢(CMember member) { string sql = $"EXEC 通知訊息查詢 "; sql += $"@{CMemberKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>(); paras.Add(new SqlParameter(CNoticeKey.fMemberId, member.fMemberId)); return((List <CNotice>)CDbManager.querySql(sql, paras, reader查詢通知訊息)); }
public static List <CMemberBrowse> fn會員瀏覽紀錄查詢() { string sql = $"EXEC 會員瀏覽紀錄查詢"; //List<SqlParameter> paras = new List<SqlParameter>() //{ // new SqlParameter(CMemberBrows // eKey.fMemberId, member.fMemberId) //}; //List<CMemberBrowse> lsMemberBrowse = (List<CMemberBrowse>)CDbManager.querySql(sql, paras, reader會員瀏覽紀錄查詢); return((List <CMemberBrowse>)CDbManager.querySql(sql, null, reader會員瀏覽紀錄查詢));; }
public static List <CVersion> fn筆記版本控制查詢(CNote note) { string sql = $"EXEC 筆記版本控制查詢 "; sql += $"@{CVersionKey.fNoteId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CVersionKey.fNoteId, note.fNoteId) }; return((List <CVersion>)CDbManager.querySql(sql, paras, reader筆記版本控制查詢)); }
//=========================== 購物車查詢(all) =========================== // public static List <CCart> fn購物車查詢(CMember member) { string sql = $"EXEC 購物車查詢 "; sql += $"@{CCartKey.fMemberId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CCartKey.fMemberId, member.fMemberId) }; return((List <CCart>)CDbManager.querySql(sql, paras, reader購物車查詢)); }
public static List <CNote> fn私人筆記查詢(CNoteFolder noteFolder) { string sql = $"EXEC 私人筆記查詢 "; sql += $"@{CNoteKey.fFolderId}"; List <SqlParameter> paras = new List <SqlParameter>() { new SqlParameter(CNoteKey.fFolderId, noteFolder.fFolderId) }; return((List <CNote>)CDbManager.querySql(sql, paras, reader私人筆記查詢)); }