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);
}
