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