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 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 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 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 <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 <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 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 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 <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 <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筆記版本控制查詢));
}
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 <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 <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);
}
//=========================== 購物車查詢(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私人筆記查詢));
}
public static List <CChat> fn聊聊未讀查詢(int from, int to)
{
string sql = $"EXEC 聊聊未讀查詢 @{CChatKey.fMemberFrom},";
sql += $"@{CChatKey.fMemberTo}";
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter(CChatKey.fMemberFrom, from),
new SqlParameter(CChatKey.fMemberTo, to)
};
List <CChat> lsChat = (List <CChat>)CDbManager.querySql(sql, paras, reader聊聊未讀查詢);
return(lsChat);
}
public static List <CTemplate> fn模板查詢()
{
string sql = $"EXEC 模板查詢";
return((List <CTemplate>)CDbManager.querySql(sql, null, reader模板查詢));
}
//=========================== 商品瀏覽紀錄查詢(all) =========================== //
public static List <CProductBrowse> fn商品瀏覽紀錄查詢()
{
string sql = $"EXEC 商品瀏覽紀錄查詢";
return((List <CProductBrowse>)CDbManager.querySql(sql, null, reader商品瀏覽紀錄查詢));
}
public static List <CNote> fn私人筆記全部查詢()
{
string sql = $"EXEC 私人筆記全部查詢";
return((List <CNote>)CDbManager.querySql(sql, null, reader私人筆記全部查詢));
}
public static List <CMember> fn會員查詢()
{
string sql = $"EXEC 會員查詢";
return((List <CMember>)CDbManager.querySql(sql, null, reader查詢會員));
}
//=========================== 購物車商品查詢(all) =========================== //
public static List <CCartProduct> fn購物車商品查詢()
{
string sql = $"EXEC 購物車商品查詢";
return((List <CCartProduct>)CDbManager.querySql(sql, null, reader購物車商品查詢));
}
public static List <CAdmin> fn管理員查詢()
{
string sql = $"EXEC 管理員查詢";
return((List <CAdmin>)CDbManager.querySql(sql, null, reader管理員查詢));
}
//=========================== 商品類別對照查詢(all) =========================== //
public static List <CProductCompare> fn商品類別對照查詢()
{
string sql = $"EXEC 商品類別對照查詢";
return((List <CProductCompare>)CDbManager.querySql(sql, null, reader商品類別對照查詢));
}