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