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