public static IEnumerable <T_BG_0601ApplicationData> GetCollectionFromImportDataTable(DataTable dt) { List <T_BG_0601ApplicationData> collection = new List <T_BG_0601ApplicationData>(); foreach (DataRow dr in dt.Rows) { T_BG_0601ApplicationData applicationData = new T_BG_0601ApplicationData() { ObjectID = (dr.ReadGuidNullable("ObjectID") == null ? null : dr.ReadGuidNullable("ObjectID").ToString()), FBH = dr.ReadString("FBH"), BT = dr.ReadString("BT"), LanguageID = dr.ReadString("LanguageID"), FBLM = dr.ReadString("FBLM"), FBBM = dr.ReadString("FBBM"), FBZT = dr.ReadString("FBZT"), XXLX = dr.ReadString("XXLX"), XXTPDZ = dr.ReadString("XXTPDZ"), XXNR = dr.ReadString("XXNR"), FJXZDZ = dr.ReadString("FJXZDZ"), PZRJGH = dr.ReadString("PZRJGH"), XXZT = dr.ReadString("XXZT"), IsTop = dr.ReadString("IsTop"), TopSort = dr.ReadInt32Nullable("TopSort"), IsBest = dr.ReadString("IsBest"), YXSJRQ = dr.ReadDateTimeNullable("YXSJRQ"), FBRJGH = dr.ReadString("FBRJGH"), FBSJRQ = dr.ReadDateTimeNullable("FBSJRQ"), FBIP = dr.ReadString("FBIP"), LLCS = dr.ReadInt32Nullable("LLCS"), }; collection.Add(applicationData); } return(collection); }
//========================================================================= // FunctionName : AutoGenerateFBH /// <summary> /// 自动生成FBH编号方法 /// </summary> /// <returns>返回FBH新编号</returns> //========================================================================= public string AutoGenerateFBH(T_BG_0601ApplicationData appData) { int intNumberLength = 8; string strPrefix = ("XX").ToString(); strPrefix = strPrefix.ToLower() == "null" ? "" : strPrefix; T_BG_0601BusinessEntity instanceT_BG_0601BusinessEntity = (T_BG_0601BusinessEntity)CreateBusinessEntityInstance(typeof(T_BG_0601BusinessEntity)); string strMaxValue; StringBuilder sbNewID = new StringBuilder(string.Empty); sbNewID.Append(strPrefix); strMaxValue = instanceT_BG_0601BusinessEntity.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 DataSet GetNewsList(string strLMH, int intListNumber, string strXXZT = null, string strIsBest = null, string strXXLX = null) { appData = new T_BG_0601ApplicationData(); appData.CurrentPage = 1; appData.PageSize = intListNumber; appData.SortField = "IsTop DESC, TopSort ASC, FBSJRQ"; appData.Sort = false; if (strIsBest != null) { appData.IsBest = strIsBest; } appData.FBLMBatch = GetSubColumn(strLMH); if (strXXLX != null) { appData.XXLX = strXXLX; } if (strXXZT != null) { appData.XXZT = strXXZT; } T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic = (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic)); appData = instanceT_BG_0601ApplicationLogic.Query(appData); return(appData.ResultSet); }
//========================================================================= // FunctionName : Query /// <summary> /// 检索方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BG_0601ApplicationData Query(T_BG_0601ApplicationData appData) { T_BG_0601BusinessEntity instanceT_BG_0601BusinessEntity = (T_BG_0601BusinessEntity)CreateBusinessEntityInstance(typeof(T_BG_0601BusinessEntity)); instanceT_BG_0601BusinessEntity.AppData = appData; if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { instanceT_BG_0601BusinessEntity.SelectByKey(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { instanceT_BG_0601BusinessEntity.SelectByObjectID(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceT_BG_0601BusinessEntity.SelectByAnyCondition(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BG_0601BusinessEntity.SelectByAnyCondition(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } return(instanceT_BG_0601BusinessEntity.AppData); }
//========================================================================= // FunctionName : Count /// <summary> /// 统计记录数方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BG_0601ApplicationData Count(T_BG_0601ApplicationData appData) { T_BG_0601BusinessEntity instanceT_BG_0601BusinessEntity = (T_BG_0601BusinessEntity)CreateBusinessEntityInstance(typeof(T_BG_0601BusinessEntity)); instanceT_BG_0601BusinessEntity.AppData = appData; instanceT_BG_0601BusinessEntity.CountByAnyCondition(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; return(instanceT_BG_0601BusinessEntity.AppData); }
//========================================================================= // FunctionName : Modify /// <summary> /// 更新方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BG_0601ApplicationData Modify(T_BG_0601ApplicationData appData) { T_BG_0601BusinessEntity instanceT_BG_0601BusinessEntity = (T_BG_0601BusinessEntity)CreateBusinessEntityInstance(typeof(T_BG_0601BusinessEntity)); instanceT_BG_0601BusinessEntity.AppData = appData; if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.PK) { if (instanceT_BG_0601BusinessEntity.IsExistByKey() == true) { instanceT_BG_0601BusinessEntity.UpdateByKey(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ID) { if (instanceT_BG_0601BusinessEntity.IsExistByObjectID() == true) { instanceT_BG_0601BusinessEntity.UpdateByObjectID(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } else if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.BATCH) { instanceT_BG_0601BusinessEntity.UpdateByObjectIDBatch(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else if (instanceT_BG_0601BusinessEntity.AppData.OPCode == ApplicationDataBase.OPType.ALL) { instanceT_BG_0601BusinessEntity.UpdateByAnyCondition(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { if (instanceT_BG_0601BusinessEntity.IsExistByObjectID() == true) { instanceT_BG_0601BusinessEntity.UpdateByObjectID(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } } return(instanceT_BG_0601BusinessEntity.AppData); }
public DataSet GetXXNR(string guidObjectID) { appData = new T_BG_0601ApplicationData(); appData.PageSize = 1; appData.ObjectID = guidObjectID; appData.OPCode = RICH.Common.Base.ApplicationData.ApplicationDataBase.OPType.ID; T_BG_0601ApplicationLogic instanceT_BG_0601ApplicationLogic = (T_BG_0601ApplicationLogic)CreateApplicationLogicInstance(typeof(T_BG_0601ApplicationLogic)); appData = instanceT_BG_0601ApplicationLogic.Query(appData); return(appData.ResultSet); }
//========================================================================= // FunctionName : Add /// <summary> /// 添加方法 /// </summary> /// <param name="appData">应用数据实体</param> /// <returns>返回数据实体对象</returns> //========================================================================= public T_BG_0601ApplicationData Add(T_BG_0601ApplicationData appData) { T_BG_0601BusinessEntity instanceT_BG_0601BusinessEntity = (T_BG_0601BusinessEntity)CreateBusinessEntityInstance(typeof(T_BG_0601BusinessEntity)); instanceT_BG_0601BusinessEntity.AppData = appData; if (instanceT_BG_0601BusinessEntity.IsExistByKey() == false) { instanceT_BG_0601BusinessEntity.Insert(); instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Succeed; } else { instanceT_BG_0601BusinessEntity.AppData.ResultCode = ApplicationDataBase.ResultState.Failure; } return(instanceT_BG_0601BusinessEntity.AppData); }