// iPage 第N頁
// iSize 最大顯示數量
public DataTable fnSelects(GroupD groupD, int iPage, int iSize)
{
int iStart = (iPage - 1) * iSize + 1;
int iEnd = iPage * iSize;
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[group_id]", groupD.group_id);
string sInquireSql =
" SELECT [group_d].[id], " +
" [user].[name], " +
" [group_d].[create_id], " +
" CONVERT(CHAR, [group_d].[create_datetime], 111) [create_datetime], " +
" [group_d].[modify_id], " +
" CONVERT(CHAR, [group_d].[modify_datetime], 111) [modify_datetime] " +
" FROM (SELECT Row_number() OVER (ORDER BY [id] ASC) NUM, " +
" * " +
" FROM [MNDTgroup_details] " +
" WHERE 1 = 1 " + sCondition + ") AS [group_d] " +
" LEFT JOIN [MNDTUser] [user] " +
" ON [group_d].[id] = [user].[id] " +
" WHERE NUM BETWEEN " + iStart.ToString() + " AND " + iEnd.ToString();
return(PublicApi.fnGetDt(sInquireSql, "MNDT"));
}
public string fnDelete(GroupD groupD)
{
string sSql =
" DELETE [dbo].[MNDTgroup_details] " +
" WHERE [group_id] = '" + groupD.group_id + "' " +
" AND [id] = '" + groupD.id + "' ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
public string fnCount(GroupD groupD)
{
string sCondition = "";
sCondition += PublicApi.fnAddCondition("[group_id]", groupD.group_id);
string sCountSql =
" SELECT COUNT([group_id]) " +
" FROM [MNDTgroup_details] " +
" WHERE 1 = 1 " + sCondition;
string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT");
return(sPageSize);
}
public string fnInsert(GroupD groupD)
{
string sSql = " INSERT INTO [MNDTgroup_details] " +
" ([group_id] " +
" ,[id] " +
" ,[create_id] " +
" ,[create_datetime] " +
" ,[modify_id] " +
" ,[modify_datetime]) " +
" VALUES " +
" ('" + groupD.group_id + "' " +
" ,'" + groupD.id + "' " +
" ,'" + groupD.create_id + "' " +
" ,GETDATE() " +
" ,'" + groupD.create_id + "' " +
" ,GETDATE()) ";
return(PublicApi.fnExecuteSQL(sSql, "MNDT"));
}
