//========================================================================= // FunctionName : AutoGenerateKCYYBH /// <summary> /// 自动生成KCYYBH编号方法 /// </summary> /// <returns>返回KCYYBH新编号</returns> //========================================================================= public string AutoGenerateKCYYBH(T_BM_KCYYXXApplicationData appData) { int intNumberLength = 8; string strPrefix = ("YY").ToString(); strPrefix = strPrefix.ToLower() == "null" ? "" : strPrefix; T_BM_KCYYXXBusinessEntity instanceT_BM_KCYYXXBusinessEntity = (T_BM_KCYYXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_KCYYXXBusinessEntity)); string strMaxValue; StringBuilder sbNewID = new StringBuilder(string.Empty); sbNewID.Append(strPrefix); strMaxValue = instanceT_BM_KCYYXXBusinessEntity.GetMaxValue(strPrefix, intNumberLength).ToString(); if (strMaxValue != String.Empty) { if (strMaxValue.Length == strPrefix.Length + intNumberLength) { int intMaxValue = Convert.ToInt32(strMaxValue.Substring(strPrefix.Length, intNumberLength)) + 1; sbNewID.Append(FillZeroToString(intMaxValue.ToString(), intNumberLength)); } else { sbNewID.Append(FillZeroToString("1", intNumberLength)); } } else { sbNewID.Append(FillZeroToString("1", intNumberLength)); } return(sbNewID.ToString()); }
public static IEnumerable <T_BM_KCYYXXApplicationData> GetCollectionFromImportDataTable(DataTable dt) { List <T_BM_KCYYXXApplicationData> collection = new List <T_BM_KCYYXXApplicationData>(); foreach (DataRow dr in dt.Rows) { T_BM_KCYYXXApplicationData applicationData = new T_BM_KCYYXXApplicationData() { ObjectID = (dr.ReadGuidNullable("ObjectID") == null ? null : dr.ReadGuidNullable("ObjectID").ToString()), KCYYBH = dr.ReadString("KCYYBH"), KCBBH = dr.ReadString("KCBBH"), HYBH = dr.ReadString("HYBH"), YYSJ = dr.ReadDateTimeNullable("YYSJ"), YYBZ = dr.ReadString("YYBZ"), SKZT = dr.ReadString("SKZT"), XHKS = dr.ReadInt32Nullable("XHKS"), KTZP = dr.ReadString("KTZP"), JSPJ = dr.ReadString("JSPJ"), PJR = dr.ReadString("PJR"), PJSJ = dr.ReadDateTimeNullable("PJSJ"), }; collection.Add(applicationData); } return(collection); }
//========================================================================= // FunctionName : Query /// <summary> /// 检索方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_KCYYXXApplicationData Query(T_BM_KCYYXXApplicationData appData) { T_BM_KCYYXXBusinessEntity instanceT_BM_KCYYXXBusinessEntity = (T_BM_KCYYXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_KCYYXXBusinessEntity)); instanceT_BM_KCYYXXBusinessEntity.AppData = appData; if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { instanceT_BM_KCYYXXBusinessEntity.SelectByKey(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { instanceT_BM_KCYYXXBusinessEntity.SelectByObjectID(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceT_BM_KCYYXXBusinessEntity.SelectByAnyCondition(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_KCYYXXBusinessEntity.SelectByAnyCondition(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } return(instanceT_BM_KCYYXXBusinessEntity.AppData); }
//========================================================================= // FunctionName : Count /// <summary> /// 统计记录数方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_KCYYXXApplicationData Count(T_BM_KCYYXXApplicationData appData) { T_BM_KCYYXXBusinessEntity instanceT_BM_KCYYXXBusinessEntity = (T_BM_KCYYXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_KCYYXXBusinessEntity)); instanceT_BM_KCYYXXBusinessEntity.AppData = appData; instanceT_BM_KCYYXXBusinessEntity.CountByAnyCondition(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; return(instanceT_BM_KCYYXXBusinessEntity.AppData); }
//========================================================================= // FunctionName : Modify /// <summary> /// 更新方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_KCYYXXApplicationData Modify(T_BM_KCYYXXApplicationData appData) { T_BM_KCYYXXBusinessEntity instanceT_BM_KCYYXXBusinessEntity = (T_BM_KCYYXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_KCYYXXBusinessEntity)); instanceT_BM_KCYYXXBusinessEntity.AppData = appData; if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { if (instanceT_BM_KCYYXXBusinessEntity.IsExistByKey() == true) { instanceT_BM_KCYYXXBusinessEntity.UpdateByKey(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { if (instanceT_BM_KCYYXXBusinessEntity.IsExistByObjectID() == true) { instanceT_BM_KCYYXXBusinessEntity.UpdateByObjectID(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.BATCH) { instanceT_BM_KCYYXXBusinessEntity.UpdateByObjectIDBatch(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BM_KCYYXXBusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceT_BM_KCYYXXBusinessEntity.UpdateByAnyCondition(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { if (instanceT_BM_KCYYXXBusinessEntity.IsExistByObjectID() == true) { instanceT_BM_KCYYXXBusinessEntity.UpdateByObjectID(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } return(instanceT_BM_KCYYXXBusinessEntity.AppData); }
//===================================================================== // FunctionName : GetDataByObjectID /// <summary> /// 以ObjectID为条件查询记录并返回AppData /// </summary> //===================================================================== public static T_BM_KCYYXXApplicationData GetDataByObjectID(string strObjectID) { // 创建数据库连接 Database db = DatabaseFactory.CreateDatabase("strConnManager"); string strProcName = "SP_SelectT_BM_KCYYXXByObjectID"; DbCommand cmdProc = db.GetStoredProcCommand(strProcName); // 设定存储过程输入参数 db.AddInParameter(cmdProc, "@ObjectID", DbType.String); // 对存储过程参数赋值 db.SetParameterValue(cmdProc, "@ObjectID", strObjectID); // 执行存储过程 return(T_BM_KCYYXXApplicationData.FillDataFromDataReader(db.ExecuteReader(cmdProc))); }
//========================================================================= // FunctionName : Add /// <summary> /// 添加方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BM_KCYYXXApplicationData Add(T_BM_KCYYXXApplicationData appData) { T_BM_KCYYXXBusinessEntity instanceT_BM_KCYYXXBusinessEntity = (T_BM_KCYYXXBusinessEntity)CreateBusinessEntityInstance(typeof(T_BM_KCYYXXBusinessEntity)); instanceT_BM_KCYYXXBusinessEntity.AppData = appData; if (instanceT_BM_KCYYXXBusinessEntity.IsExistByKey() == false) { instanceT_BM_KCYYXXBusinessEntity.Insert(); instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BM_KCYYXXBusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } return(instanceT_BM_KCYYXXBusinessEntity.AppData); }