public int Insert(SealUnionRequestsEntity entity)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dbo.SealUnionRequests(");
strSql.Append("SealRequestsID,SealID,ApprovedBy,ApprovedDate,IsSealed,SealedBy,SealedDate)");
strSql.Append(" values (");
strSql.Append("@SealRequestsID,@SealID,@ApprovedBy,@ApprovedDate,@IsSealed,@SealedBy,@SealedDate)");
strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
db.AddInParameter(dbCommand, "SealRequestsID", DbType.Int32, entity.SealRequestsID);
db.AddInParameter(dbCommand, "SealID", DbType.Int32, entity.SealID);
db.AddInParameter(dbCommand, "ApprovedBy", DbType.Int32, entity.ApprovedBy);
db.AddInParameter(dbCommand, "ApprovedDate", DbType.DateTime, entity.ApprovedDate);
db.AddInParameter(dbCommand, "IsSealed", DbType.Boolean, entity.IsSealed);
db.AddInParameter(dbCommand, "SealedBy", DbType.Int32, entity.SealedBy);
db.AddInParameter(dbCommand, "SealedDate", DbType.DateTime, entity.SealedDate);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
}
private string BuilderSeals(int sealRequestId)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table border='0' ><tbody>");
List <SealsEntity> list = app.GetList().FindAll(r => r.Status == Status.Active);
List <SealUnionRequestsEntity> listUnioSeals = app.GetSealUnionRequestsList(sealRequestId);
foreach (SealsEntity entity in list)
{
SealUnionRequestsEntity unionEntity = listUnioSeals.Find(r => r.SealID == entity.ID);
if (unionEntity != null)
{
sb.AppendFormat("<tr><td><span disabled=\"disabled\"><input type=\"checkbox\" disabled=\"disabled\" {0}> <label>{1}</label></span>",
unionEntity == null ? "" : "checked=\"checked\"", entity.SealName);
if (unionEntity != null && unionEntity.SealedDate > MinDate)
{
sb.AppendFormat("<span style='margin-left:20px'><span class=\"sealinfo\">Sealed By:</span> {0} <span class=\"sealinfo\">Sealed Date:</span> {1} </span>",
new App.UserApplication().GetUser(unionEntity.SealedBy).FirstName, unionEntity.SealedDate.ToString("MM/dd/yyyy"));
}
sb.Append("</td></tr>");
}
}
sb.Append("</tbody></table>");
return(sb.ToString());
}
/// <summary>
/// 修改 SealRequest 只有在 Open状态时，才可以修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public bool SealRequestsUpdate(SealRequestsEntity entity)
{
try
{
bool result = true;
#if !DEBUG
using (TransactionScope tran = new TransactionScope())
#endif
{
List <SealUnionRequestsEntity> list = mgr.GetSealUnionRequestsList(entity.ID);
List <SealUnionRequestsEntity> listOld = new List <SealUnionRequestsEntity>();
if (mgr.SealRequestsUpdate(entity))
{
foreach (SealsEntity sealsEntity in entity.SealList)
{
SealUnionRequestsEntity unionEntity = list.Find(r => r.SealRequestsID == entity.ID && r.SealID == sealsEntity.ID);
if (unionEntity == null)
{
int tmpId = mgr.InsertSealUnionRequests(new SealUnionRequestsEntity(sealsEntity, entity.ID));
if (tmpId < 1)
{
result = false;
}
}
else
{
listOld.Add(unionEntity);
}
}
}
foreach (SealUnionRequestsEntity sealsEntity in list)
{
if (listOld.Find(r => r.ID == sealsEntity.ID) == null)
{
mgr.DeleteSealUnionRequests(sealsEntity.ID);
}
}
#if !DEBUG
tran.Complete();
#endif
return(result);
}
}
catch (Exception ex)
{
WebLogAgent.Write(ex);
return(false);
}
}
public bool Update(SealUnionRequestsEntity entity)
{
throw new NotImplementedException();
}
public int InsertSealUnionRequests(SealUnionRequestsEntity entity)
{
return(unionRepository.Insert(entity));
}
