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