public override bool Update(EnterpriseContractEntity entity)
{
string commandText = string.Format(@"Update [XQYCEnterpriseContract] Set
[ContractGuid] = {0}ContractGuid,
[EnterpriseGuid] = {0}EnterpriseGuid,
[EnterpriseInfo] = {0}EnterpriseInfo,
[ContractTitle] = {0}ContractTitle,
[ContractDetails] = {0}ContractDetails,
[ContractStartDate] = {0}ContractStartDate,
[ContractStopDate] = {0}ContractStopDate,
[ContractCreateDate] = {0}ContractCreateDate,
[ContractCreateUserKey] = {0}ContractCreateUserKey,
[ContractLaborCount] = {0}ContractLaborCount,
[ContractLaborAddon] = {0}ContractLaborAddon,
[ContractStatus]= {0}ContractStatus,
[PropertyNames] = {0}PropertyNames,
[PropertyValues] = {0}PropertyValues
Where [ContractID] = {0}ContractID", ParameterNamePrefix);
TParameter[] sqlParas = PrepareParasAll(entity);
bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas);
return(isSuccessful);
}
/// <summary>
///
/// </summary>
/// <param name="reader"></param>
/// <param name="entity"></param>
protected override void InnerLoad(IDataReader reader, ref EnterpriseContractEntity entity)
{
if (reader != null && reader.IsClosed == false && entity != null)
{
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractID"))
{
entity.ContractID = reader.GetInt32(reader.GetOrdinal("ContractID"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractGuid"))
{
entity.ContractGuid = reader.GetGuid(reader.GetOrdinal("ContractGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseGuid"))
{
entity.EnterpriseGuid = reader.GetGuid(reader.GetOrdinal("EnterpriseGuid"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "EnterpriseInfo"))
{
entity.EnterpriseInfo = reader.GetString(reader.GetOrdinal("EnterpriseInfo"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractTitle"))
{
entity.ContractTitle = reader.GetString(reader.GetOrdinal("ContractTitle"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractDetails"))
{
entity.ContractDetails = reader.GetString(reader.GetOrdinal("ContractDetails"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractStartDate"))
{
entity.ContractStartDate = reader.GetDateTime(reader.GetOrdinal("ContractStartDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractStopDate"))
{
entity.ContractStopDate = reader.GetDateTime(reader.GetOrdinal("ContractStopDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractCreateDate"))
{
entity.ContractCreateDate = reader.GetDateTime(reader.GetOrdinal("ContractCreateDate"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractCreateUserKey"))
{
entity.ContractCreateUserKey = reader.GetString(reader.GetOrdinal("ContractCreateUserKey"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractLaborCount"))
{
entity.ContractLaborCount = reader.GetInt32(reader.GetOrdinal("ContractLaborCount"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractLaborAddon"))
{
entity.ContractLaborAddon = reader.GetString(reader.GetOrdinal("ContractLaborAddon"));
}
if (DataReaderHelper.IsExistFieldAndNotNull(reader, "ContractStatus"))
{
entity.ContractStatus = (Logics)reader.GetInt32(reader.GetOrdinal("ContractStatus"));
}
}
}
public override bool Create(EnterpriseContractEntity entity)
{
//在创建实体时如果实体的Guid尚未指定，那么给其赋初值
if (entity.ContractGuid == Guid.Empty)
{
entity.ContractGuid = GuidHelper.NewGuid();
}
string commandText = string.Format(@"Insert Into [XQYCEnterpriseContract] (
[ContractGuid],
[EnterpriseGuid],
[EnterpriseInfo],
[ContractTitle],
[ContractDetails],
[ContractStartDate],
[ContractStopDate],
[ContractCreateDate],
[ContractCreateUserKey],
[ContractLaborCount],
[ContractLaborAddon],
[ContractStatus],
[PropertyNames],
[PropertyValues]
)
Values (
{0}ContractGuid,
{0}EnterpriseGuid,
{0}EnterpriseInfo,
{0}ContractTitle,
{0}ContractDetails,
{0}ContractStartDate,
{0}ContractStopDate,
{0}ContractCreateDate,
{0}ContractCreateUserKey,
{0}ContractLaborCount,
{0}ContractLaborAddon,
{0}ContractStatus,
{0}PropertyNames,
{0}PropertyValues
)", ParameterNamePrefix);
TParameter[] sqlParas = PrepareParasAll(entity);
bool isSuccessful = HelperExInstance.ExecuteSingleRowNonQuery(commandText, sqlParas);
return(isSuccessful);
}
protected override void InnerPrepareParasAll(EnterpriseContractEntity entity, ref List <TParameter> paraList)
{
List <TParameter> list = new List <TParameter>()
{
GenerateParameter("ContractID", entity.ContractID),
GenerateParameter("ContractGuid", entity.ContractGuid),
GenerateParameter("EnterpriseGuid", entity.EnterpriseGuid),
GenerateParameter("EnterpriseInfo", entity.EnterpriseInfo ?? String.Empty),
GenerateParameter("ContractTitle", entity.ContractTitle ?? String.Empty),
GenerateParameter("ContractDetails", entity.ContractDetails ?? String.Empty),
GenerateParameter("ContractStartDate", entity.ContractStartDate),
GenerateParameter("ContractStopDate", entity.ContractStopDate),
GenerateParameter("ContractCreateDate", entity.ContractCreateDate),
GenerateParameter("ContractCreateUserKey", entity.ContractCreateUserKey ?? String.Empty),
GenerateParameter("ContractLaborCount", entity.ContractLaborCount),
GenerateParameter("ContractLaborAddon", entity.ContractLaborAddon ?? String.Empty),
GenerateParameter("ContractStatus", entity.ContractStatus)
};
paraList.AddRange(list);
}
public ActionResult ContractItem(string enterpriseKey, string itemKey, EnterpriseContractEntity originalEntity)
{
bool isSuccessful = false;
string displayMessage = string.Empty;
EnterpriseContractEntity targetEntity = null;
if (GuidHelper.IsInvalidOrEmpty(itemKey) == true)
{
targetEntity = new EnterpriseContractEntity();
targetEntity.EnterpriseGuid = Converter.ChangeType<Guid>(enterpriseKey);
targetEntity.EnterpriseInfo = EnterpriseBLL.Instance.Get(targetEntity.EnterpriseGuid).CompanyName;
targetEntity.ContractCreateDate = DateTime.Now;
targetEntity.ContractCreateUserKey = BusinessUserBLL.CurrentUser.UserGuid.ToString();
SetTargetContractEntityValue(originalEntity, ref targetEntity);
isSuccessful = EnterpriseContractBLL.Instance.Create(targetEntity);
}
else
{
targetEntity = EnterpriseContractBLL.Instance.Get(itemKey);
SetTargetContractEntityValue(originalEntity, ref targetEntity);
isSuccessful = EnterpriseContractBLL.Instance.Update(targetEntity);
}
if (isSuccessful == true)
{
displayMessage = "数据保存成功";
}
else
{
displayMessage = "数据保存失败";
}
return Json(new LogicStatusInfo(isSuccessful, displayMessage));
}
private void SetTargetContractEntityValue(EnterpriseContractEntity originalEntity, ref EnterpriseContractEntity targetEntity)
{
targetEntity.ContractDetails = originalEntity.ContractDetails;
targetEntity.ContractLaborAddon = originalEntity.ContractLaborAddon;
targetEntity.ContractLaborCount = originalEntity.ContractLaborCount;
targetEntity.ContractStartDate = originalEntity.ContractStartDate;
targetEntity.ContractStopDate = originalEntity.ContractStopDate;
targetEntity.ContractTitle = originalEntity.ContractTitle;
targetEntity.ContractStatus = originalEntity.ContractStatus;
}
