public void ForceTests() { GroupM <A> .Init(); GroupM <B> .Init(); GroupM <C> .Init(); Manger.Init(); Manger.Create <A>(0); Manger.Create <B>(1); Manger.Create <C>(2); DateTime d1 = DateTime.Now; //Group<C> t; Group <A> ta; for (int i = 0; i < 10000000; i++) { //t = GroupM<C>.group;//18 //t = Manger.GetGroup<C>(2);//48 ta = GroupM <A> .group;//18 //ta = Manger.GetGroup<A>(0);//70 } DateTime d2 = DateTime.Now; Console.WriteLine((d2 - d1).TotalMilliseconds); }
public GroupM GetGroup(string groupID) { GroupDA groupDA = null; DataRow dr; var g = new GroupM { }; try { groupDA = new GroupDA(); dr = groupDA.GetGroups(groupID, Operation).Rows[0]; g = new GroupM { GroupID = dr["GroupID"].ToString(), GroupName = dr["GroupName"].ToString(), Description = dr["Description"].ToString(), IsDeleted = Convert.ToByte(dr["IsDeleted"]), }; } finally { if (groupDA != null) { groupDA.CloseConnection(); } } return(g); }
// iPage 第N頁 // iSize 最大顯示數量 public DataTable fnSelects(GroupM groupM, int iPage, int iSize) { int iStart = (iPage - 1) * iSize + 1; int iEnd = iPage * iSize; string sCondition = ""; sCondition += PublicApi.fnAddCondition("[group_id]", groupM.group_id); sCondition += PublicApi.fnAddCondition("[name]", groupM.name); string sAccountSql = fnGetAccountCondition(groupM.user); if (sAccountSql != "") { sCondition += " AND [group_id] IN " + sAccountSql; } string sInquireSql = " SELECT [group_m].[NUM], " + " [group_m].[group_id], " + " [group_m].[name], " + " CONVERT(CHAR, [group_m].[create_datetime], 111) [create_datetime], " + " CONVERT(CHAR, [group_m].[modify_datetime], 111) [modify_datetime] " + " FROM (SELECT Row_number() OVER(ORDER BY[" + groupM.order + "] ASC) NUM, " + " * " + " FROM [MNDTgroup_master] " + " WHERE 1 = 1 " + sCondition + ") AS [group_m] " + " WHERE NUM BETWEEN " + iStart.ToString() + " AND " + iEnd.ToString(); return(PublicApi.fnGetDt(sInquireSql, "MNDT")); }
public bool fnIsExist(GroupM groupM) { string sSql = " SELECT COUNT([group_id]) " + " FROM [MNDTgroup_master] " + " WHERE [group_id] = '" + groupM.group_id + "' "; return(PublicApi.fnGetValue(sSql, "MNDT") == "1"); }
public string fnUpdate(GroupM groupM) { string sSql = " UPDATE [dbo].[MNDTgroup_master] " + " SET [name] = '" + groupM.name + "' " + " ,[description] = '" + groupM.description + "' " + " ,[modify_id] = '" + groupM.create_id + "' " + " ,[modify_datetime] = GETDATE() " + " WHERE [group_id] = '" + groupM.group_id + "' "; return(PublicApi.fnExecuteSQL(sSql, "MNDT")); }
public string fnDelete(GroupM groupM) { string sDetailsSql = " SELECT COUNT([group_id]) FROM [MNDTgroup_details] WHERE [group_id] = '" + groupM.group_id + "' "; string sCount = PublicApi.fnGetValue(sDetailsSql, "MNDT"); if (sCount == "0") { string sSql = " DELETE [MNDTgroup_master] " + " WHERE [group_id] = '" + groupM.group_id + "' "; return(PublicApi.fnExecuteSQL(sSql, "MNDT")); } return("錯誤訊息:明細資料大於一筆。"); }
/// <summary> /// Get all goup info /// </summary> /// <param name="groupID"></param> /// <param name="selectedGroupID"></param> /// <param name="selectedGroupName"></param> /// <returns></returns> private List <GroupM> GetAllGroup(string groupID, out string selectedGroupID, out string selectedGroupName) { selectedGroupID = ""; selectedGroupName = ""; bool getGroupFisrstElement = false; if (groupID == null) { getGroupFisrstElement = true; } List <GroupM> groupList = new List <GroupM>(); GroupDA groupDA = null; DataTable dt = new DataTable(); try { groupDA = new GroupDA(); dt = groupDA.GetAllGroup(Operation); for (int i = 0; i < dt.Rows.Count; i++) { DataRow dr = dt.Rows[i]; GroupM group = new GroupM(); group.GroupID = CommUtil.ConvertObjectToString(dr["GroupID"]); group.GroupName = CommUtil.ConvertObjectToString(dr["GroupName"]); groupList.Add(group); if (i == 0 && getGroupFisrstElement) { selectedGroupID = group.GroupID; selectedGroupName = group.GroupName; } if (group.GroupID.Equals(groupID)) { selectedGroupID = group.GroupID; selectedGroupName = group.GroupName; } } } finally { if (groupDA != null) { groupDA.CloseConnection(); } } return(groupList); }
public DataTable fnSelect(GroupM groupM) { string sSql = " SELECT TOP 1 [group_id] " + " ,[name] " + " ,[description] " + " ,[create_id] " + " ,CONVERT(char, [create_datetime], 120) [create_datetime] " + " ,[modify_id] " + " ,CONVERT(char, [modify_datetime], 120) [modify_datetime] " + " FROM [MNDTgroup_master] " + " WHERE [group_id] = '" + groupM.group_id + "' "; return(PublicApi.fnGetDt(sSql, "MNDT")); }
public string fnCount(GroupM groupM) { string sCondition = ""; sCondition += PublicApi.fnAddCondition("[group_id]", groupM.group_id); sCondition += PublicApi.fnAddCondition("[name]", groupM.name); string sAccountSql = fnGetAccountCondition(groupM.user); if (sAccountSql != "") { sCondition += " AND [group_id] IN " + sAccountSql; } string sCountSql = " SELECT COUNT([group_id]) " + " FROM [MNDTgroup_master] " + " WHERE 1 = 1 " + sCondition; string sPageSize = PublicApi.fnGetValue(sCountSql, "MNDT"); return(sPageSize); }
public string fnInsert(GroupM groupM) { string sSql = " INSERT INTO [dbo].[MNDTgroup_master] " + " ([group_id] " + " ,[name] " + " ,[description] " + " ,[create_id] " + " ,[create_datetime] " + " ,[modify_id] " + " ,[modify_datetime]) " + " VALUES " + " ('" + groupM.group_id + "' " + " ,'" + groupM.name + "' " + " ,'" + groupM.description + "' " + " ,'" + groupM.create_id + "' " + " ,GETDATE() " + " ,'" + groupM.create_id + "' " + " ,GETDATE()) "; return(PublicApi.fnExecuteSQL(sSql, "MNDT")); }
public ResultModel New(GroupM model) { ResultModel result = new ResultModel(); DateTime dt = DateTime.Now; Dictionary <string, object> paramValues = new Dictionary <string, object>(); paramValues.Add("GroupName", model.GroupName.Trim()); paramValues.Add("Operation", Operation); paramValues.Add("SystemID", "S0001"); paramValues.Add("Description", model.Description); paramValues.Add("CreatedBy", UserID); paramValues.Add("CreatedTime", dt); paramValues.Add("LastModifiedBy", UserID); paramValues.Add("LastModifiedTime", dt); paramValues.Add("NumOfUsers", 0); paramValues.Add("IsDeleted", 0); GroupDA groupDA = null; try { groupDA = new GroupDA(); result.Affected = groupDA.NewGroup(paramValues); } catch (Exception ex) { result.IsSuccess = false; result.Exception = ex.Message; } finally { if (groupDA != null) { groupDA.CloseConnection(); } } return(result); }
public ResultModel Edit(GroupM model) { ResultModel result = new ResultModel(); Dictionary <string, object> saveData = new Dictionary <string, object>(); saveData.Add("GroupName", model.GroupName.Trim()); saveData.Add("Description", model.Description); saveData.Add("LastModifiedBy", UserID); saveData.Add("LastModifiedTime", DateTime.Now); if (model.IsDeleted == 1) { saveData.Add("IsDeleted", model.IsDeleted); saveData.Add("DeletedBy", UserID); saveData.Add("DeletedTime", DateTime.Now); } GroupDA groupDA = null; try { groupDA = new GroupDA(); result.Affected = groupDA.EditGroup(saveData, model.GroupID); } catch (Exception ex) { result.IsSuccess = false; result.Exception = ex.Message; } finally { if (groupDA != null) { groupDA.CloseConnection(); } } return(result); }
// sNum 排行 public string fnSelectGroupId(GroupM groupM, string sNum) { string sCondition = ""; sCondition += PublicApi.fnAddCondition("[group_id]", groupM.group_id); sCondition += PublicApi.fnAddCondition("[name]", groupM.name); string sAccountSql = fnGetAccountCondition(groupM.user); if (sAccountSql != "") { sCondition += " AND [group_id] IN " + sAccountSql; } string sSql = " SELECT [group_m].[group_id] " + " FROM (SELECT Row_number() OVER (ORDER BY [" + groupM.order + "] ASC) NUM, " + " * " + " FROM [MNDTgroup_master] " + " WHERE 1 = 1" + sCondition + ") AS [group_m] " + " WHERE [group_m].[NUM] = '" + sNum + "' "; return(PublicApi.fnGetValue(sSql, "MNDT")); }
public ActionResult Edit(GroupM model) { if (ModelState.IsValid) { try { var result = groupBL(true).Edit(model); if (result.IsSuccess && result.Affected > 0) { return(RedirectToAction("List", "Group")); } else { ModelState.AddModelError("ErrorMessage", result.Exception); } } catch (Exception ex) { ModelState.AddModelError("ErrorMessage", ex.Message); } } return(View(model)); }
/// <summary> /// 获得排序语句 /// </summary> /// <returns>排序T-Sql语句</returns> public string GetGroupStr() { return(GroupM.GetGroupStr()); }