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私人筆記查詢));
}
