//========================================================================= // FunctionName : Query /// <summary> /// 检索方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public DictionaryTypeApplicationData Query(DictionaryTypeApplicationData appData) { DictionaryTypeBusinessEntity instanceDictionaryTypeBusinessEntity = (DictionaryTypeBusinessEntity)CreateBusinessEntityInstance(typeof(DictionaryTypeBusinessEntity)); instanceDictionaryTypeBusinessEntity.AppData = appData; if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { instanceDictionaryTypeBusinessEntity.SelectByKey(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { instanceDictionaryTypeBusinessEntity.SelectByObjectID(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceDictionaryTypeBusinessEntity.SelectByAnyCondition(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceDictionaryTypeBusinessEntity.SelectByAnyCondition(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } return(instanceDictionaryTypeBusinessEntity.AppData); }
protected virtual void CountAnyField() { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); appData = instanceDictionaryTypeApplicationLogic.Count(appData); }
protected virtual void btnAddConfirm_Click(object sender, EventArgs e) { Session[ConstantsManager.SESSION_REDIRECT_PAGE] = CURRENT_PATH + "/" + WEBUI_SEARCH_FILENAME; Session[ConstantsManager.SESSION_MESSAGE_TYPE] = "SuccessClose"; appData = new DictionaryTypeApplicationData(); AddRecord(); }
protected virtual bool AJAX_Delete(string strObjectID) { bool boolReturn = false; try { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); DictionaryTypeApplicationData appData = new DictionaryTypeApplicationData(); appData.OPCode = ApplicationDataBase.OPType.ID; appData.ObjectID = strObjectID; appData = instanceDictionaryTypeApplicationLogic.Query(appData); if (appData.RecordCount > 0) { appData = instanceDictionaryTypeApplicationLogic.Delete(appData); if (appData.ResultCode == ApplicationDataBase.ResultState.Succeed) { boolReturn = true; } else { boolReturn = false; } } else { boolReturn = false; } } catch (Exception) { boolReturn = false; } return(boolReturn); }
protected virtual void btnModifyConfirm_Click(object sender, EventArgs e) { Session[ConstantsManager.SESSION_REDIRECT_PAGE] = CURRENT_PATH + "/" + WEBUI_SEARCH_FILENAME; Session[ConstantsManager.SESSION_MESSAGE_TYPE] = "SuccessClose"; appData = new DictionaryTypeApplicationData(); appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID; ModifyRecord(); }
//========================================================================= // FunctionName : Count /// <summary> /// 统计记录数方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public DictionaryTypeApplicationData Count(DictionaryTypeApplicationData appData) { DictionaryTypeBusinessEntity instanceDictionaryTypeBusinessEntity = (DictionaryTypeBusinessEntity)CreateBusinessEntityInstance(typeof(DictionaryTypeBusinessEntity)); instanceDictionaryTypeBusinessEntity.AppData = appData; instanceDictionaryTypeBusinessEntity.CountByAnyCondition(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; return(instanceDictionaryTypeBusinessEntity.AppData); }
protected virtual bool AJAX_Modify(string strFieldName, string strFieldValue, string strObjectID) { bool boolReturn = false; try { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); DictionaryTypeApplicationData appData = new DictionaryTypeApplicationData(); appData.OPCode = ApplicationDataBase.OPType.ID; appData.ObjectID = strObjectID; appData = instanceDictionaryTypeApplicationLogic.Query(appData); if (appData.RecordCount > 0) { switch (strFieldName) { case "ObjectID": appData.ObjectID = Convert.ToString(strFieldValue); break; case "DM": appData.DM = Convert.ToString(strFieldValue); break; case "MC": appData.MC = Convert.ToString(strFieldValue); break; case "SM": appData.SM = Convert.ToString(strFieldValue); break; } appData = instanceDictionaryTypeApplicationLogic.Modify(appData); if (appData.ResultCode == ApplicationDataBase.ResultState.Succeed) { boolReturn = true; } else { boolReturn = false; } } else { boolReturn = false; } } catch (Exception) { boolReturn = false; } return(boolReturn); }
//========================================================================= // FunctionName : Modify /// <summary> /// 更新方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public DictionaryTypeApplicationData Modify(DictionaryTypeApplicationData appData) { DictionaryTypeBusinessEntity instanceDictionaryTypeBusinessEntity = (DictionaryTypeBusinessEntity)CreateBusinessEntityInstance(typeof(DictionaryTypeBusinessEntity)); instanceDictionaryTypeBusinessEntity.AppData = appData; if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { if (instanceDictionaryTypeBusinessEntity.IsExistByKey() == true) { instanceDictionaryTypeBusinessEntity.UpdateByKey(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { if (instanceDictionaryTypeBusinessEntity.IsExistByObjectID() == true) { instanceDictionaryTypeBusinessEntity.UpdateByObjectID(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.BATCH) { instanceDictionaryTypeBusinessEntity.UpdateByObjectIDBatch(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceDictionaryTypeBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceDictionaryTypeBusinessEntity.UpdateByAnyCondition(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { if (instanceDictionaryTypeBusinessEntity.IsExistByObjectID() == true) { instanceDictionaryTypeBusinessEntity.UpdateByObjectID(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } return(instanceDictionaryTypeBusinessEntity.AppData); }
protected virtual bool AJAX_IsExist(string strFieldName, string strFieldValue) { bool boolReturn = false; try { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); DictionaryTypeApplicationData appData = new DictionaryTypeApplicationData(); appData.Sort = false; appData.SortField = "ObjectID"; appData.PageSize = 1; appData.CurrentPage = 1; appData.OPCode = ApplicationDataBase.OPType.ALL; switch (strFieldName) { case "ObjectID": appData.ObjectID = Convert.ToString(strFieldValue); break; case "DM": appData.DM = Convert.ToString(strFieldValue); break; case "MC": appData.MC = Convert.ToString(strFieldValue); break; case "SM": appData.SM = Convert.ToString(strFieldValue); break; default: appData.PageSize = 0; break; } appData = instanceDictionaryTypeApplicationLogic.Query(appData); if (appData.RecordCount > 0) { boolReturn = true; } else { boolReturn = false; } } catch (Exception) { boolReturn = false; } return(boolReturn); }
//===================================================================== // FunctionName : GetDataByObjectID /// <summary> /// 以ObjectID为条件查询记录并返回AppData /// </summary> //===================================================================== public static DictionaryTypeApplicationData GetDataByObjectID(string strObjectID) { // 创建数据库连接 Database db = DatabaseFactory.CreateDatabase("strConnManager"); string strProcName = "SP_SelectDictionaryTypeByObjectID"; DbCommand cmdProc = db.GetStoredProcCommand(strProcName); // 设定存储过程输入参数 db.AddInParameter(cmdProc, "@ObjectID", DbType.String); // 对存储过程参数赋值 db.SetParameterValue(cmdProc, "@ObjectID", strObjectID); // 执行存储过程 return(DictionaryTypeApplicationData.FillDataFromDataReader(db.ExecuteReader(cmdProc))); }
RICH.Common.Base.ApplicationData.ApplicationDataBase SetBatchOperationValue( string strRelatedTableName, Type typeofApplicationData, DictionaryTypeApplicationData appData, GridViewRow gvrTemp ) { RICH.Common.Base.ApplicationData.ApplicationDataBase ApplicationData = (RICH.Common.Base.ApplicationData.ApplicationDataBase)Activator.CreateInstance(typeofApplicationData); Type typeField; Object[] objConstructParms; Object objValue; return(ApplicationData); }
protected virtual void QueryRecord() { if (GetQueryInputParameter()) { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); appData = instanceDictionaryTypeApplicationLogic.Query(appData); } else { // 对错误消息进行处理 MessageContent = strMessageInfo; Session[ConstantsManager.SESSION_MESSAGE_TYPE] = "FaildPre"; } }
protected virtual string AJAX_QuerySingle(string strFieldName, string strFieldValue, string strReturnFieldName) { string strReturn = string.Empty; try { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); DictionaryTypeApplicationData appData = new DictionaryTypeApplicationData(); appData.Sort = false; appData.SortField = "ObjectID"; appData.PageSize = 1; appData.CurrentPage = 1; appData.OPCode = ApplicationDataBase.OPType.ALL; switch (strFieldName) { case "ObjectID": appData.ObjectID = Convert.ToString(strFieldValue); break; case "DM": appData.DM = Convert.ToString(strFieldValue); break; case "MC": appData.MC = Convert.ToString(strFieldValue); break; case "SM": appData.SM = Convert.ToString(strFieldValue); break; default: appData.PageSize = 0; break; } appData = instanceDictionaryTypeApplicationLogic.Query(appData); if (appData.RecordCount > 0) { strReturn = appData.ResultSet.Tables[0].Rows[0][strReturnFieldName] == DBNull.Value ? "" : appData.ResultSet.Tables[0].Rows[0][strReturnFieldName].ToString(); } } catch (Exception) { strReturn = string.Empty; } return(strReturn); }
protected virtual void btnOperate_Click(object sender, EventArgs e) { switch (Request["ctl00$MainContentPlaceHolder$ddlOperation"].ToLower()) { case "remove": appData = new DictionaryTypeApplicationData(); appData.ObjectIDBatch = (string)Request["ObjectIDBatch"]; appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.BATCH; DeleteRecord(); break; default: break; } Initalize(); }
protected virtual void ModifyRecord() { if (GetModifyInputParameter()) { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); // 主表修改 appData = instanceDictionaryTypeApplicationLogic.Modify(appData); // 相关表批量修改 RelatedTableModifyBatch(); MessageContent = MessageManager.GetMessageInfo(MessageManager.HINT_MSGID_0015, new string[] { "字典类型", "修改" }, strMessageInfo); string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0003, new string[] { (string)Session[ConstantsManager.SESSION_USER_LOGIN_NAME], "字典类型", appData.DM.ToString(), "修改" }); LogLibrary.LogWrite("A02", strLogContent, null, null, null); Page.CloseWindow(true); } }
//========================================================================= // FunctionName : Add /// <summary> /// 添加方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public DictionaryTypeApplicationData Add(DictionaryTypeApplicationData appData) { DictionaryTypeBusinessEntity instanceDictionaryTypeBusinessEntity = (DictionaryTypeBusinessEntity)CreateBusinessEntityInstance(typeof(DictionaryTypeBusinessEntity)); instanceDictionaryTypeBusinessEntity.AppData = appData; if (instanceDictionaryTypeBusinessEntity.IsExistByKey() == false) { instanceDictionaryTypeBusinessEntity.Insert(); instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceDictionaryTypeBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } return(instanceDictionaryTypeBusinessEntity.AppData); }
protected virtual void DeleteRecord() { if (GetDeleteInputParameter()) { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); appData = instanceDictionaryTypeApplicationLogic.Delete(appData); string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0003, new string[] { (string)Session[ConstantsManager.SESSION_USER_LOGIN_NAME], "字典类型", (string)appData.ObjectIDBatch, "删除" }); LogLibrary.LogWrite("A02", strLogContent, null, null, null); } else { // 对错误消息进行处理 MessageContent = strMessageInfo; Session[ConstantsManager.SESSION_MESSAGE_TYPE] = "FaildPre"; } }
public static IEnumerable <DictionaryTypeApplicationData> GetCollectionFromImportDataTable(DataTable dt) { List <DictionaryTypeApplicationData> collection = new List <DictionaryTypeApplicationData>(); foreach (DataRow dr in dt.Rows) { DictionaryTypeApplicationData applicationData = new DictionaryTypeApplicationData() { ObjectID = (dr.ReadGuidNullable("ObjectID") == null ? null : dr.ReadGuidNullable("ObjectID").ToString()), DM = dr.ReadString("DM"), MC = dr.ReadString("MC"), SM = dr.ReadString("SM"), }; collection.Add(applicationData); } return(collection); }
protected virtual void AddRecord() { if (GetAddInputParameter()) { DictionaryTypeApplicationLogic instanceDictionaryTypeApplicationLogic = (DictionaryTypeApplicationLogic)CreateApplicationLogicInstance(typeof(DictionaryTypeApplicationLogic)); // 添加主表 appData = instanceDictionaryTypeApplicationLogic.Add(appData); // 批量添加相关表 RelatedTableAddBatch(); if (appData.ResultCode == ApplicationDataBase.ResultState.Succeed) { MessageContent = MessageManager.GetMessageInfo(MessageManager.HINT_MSGID_0015, new string[] { "字典类型", "添加" }, strMessageInfo); string strLogContent = MessageManager.GetMessageInfo(MessageManager.LOG_MSGID_0003, new string[] { (string)Session[ConstantsManager.SESSION_USER_LOGIN_NAME], "字典类型", appData.DM.ToString(), "添加" }); LogLibrary.LogWrite("A02", strLogContent, null, null, null); Page.CloseWindow(true); } else { MessageContent = MessageManager.GetMessageInfo(MessageManager.ERR_MSGID_0013, new string[] { "此编号", "字典类型" }, strMessageInfo); Session[ConstantsManager.SESSION_MESSAGE_TYPE] = "FaildPre"; } } }