public string ShowOrderNumberByTid(int tid, string priority) { TicketsOrderEntity model = listOrder.Find(x => x.TicketID == tid); bool existOrderNumber = model != null ? true : false; return(existOrderNumber == true?model.OrderNum.ToString() : priority); }
/// <summary> /// Update a record /// </summary> public bool Update(TicketsOrderEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update TicketsOrder set "); strSql.Append("ProjectID=@ProjectID,"); strSql.Append("TicketID=@TicketID,"); strSql.Append("OrderNum=@OrderNum"); strSql.Append(" where TicketOrderID=@TicketOrderID "); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { db.AddInParameter(dbCommand, "TicketOrderID", DbType.Int32, model.TicketOrderID); db.AddInParameter(dbCommand, "ProjectID", DbType.Int32, model.ProjectID); db.AddInParameter(dbCommand, "TicketID", DbType.Int32, model.TicketID); db.AddInParameter(dbCommand, "OrderNum", DbType.Int32, model.OrderNum); int rows = db.ExecuteNonQuery(dbCommand); if (rows > 0) { return(true); } else { return(false); } } }
protected void btnSave_Click(object sender, EventArgs e) { string[] tickets = hidNewOrder.Value.Split(",".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); int projectID = 0; List <BrokenRuleMessage> listMsgs = new List <BrokenRuleMessage>(); if (tickets.Length > 0) { if (RemoveTicketsOrder(out projectID)) { for (int i = 0; i < tickets.Length; i++) { int id = 0; if (int.TryParse(tickets[i], out id) && id != 0) { TicketsOrderEntity model = TicketsOrderFactory.CreateTicketsOrderEntity(UserInfo.ID, ObjectFactory.GetInstance <ISystemDateTime>()); model.ProjectID = projectID; model.TicketID = id; model.OrderNum = i + 1; ticketApp.InsertTicketsOrder(model); RecordMsg(listMsgs, ticketApp.BrokenRuleMessages); } } if (listMsgs.Count > 0) { ShowFailMessageToClient(listMsgs); } else { InitControls(); ShowSuccessMessageToClient(false, false); } } else { ShowFailMessageToClient(); } } }
/// <summary> /// Get an object entity /// </summary> public TicketsOrderEntity Get(int TicketID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from TicketsOrder "); strSql.Append(" where TicketID=@TicketID "); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { db.AddInParameter(dbCommand, "TicketID", DbType.Int32, TicketID); TicketsOrderEntity model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = TicketsOrderEntity.ReaderBind(dataReader); } } return(model); } }
/// <summary> /// Add a record /// </summary> public int Insert(TicketsOrderEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into TicketsOrder("); strSql.Append("ProjectID,TicketID,OrderNum)"); strSql.Append(" values ("); strSql.Append("@ProjectID,@TicketID,@OrderNum)"); strSql.Append(";select ISNULL( SCOPE_IDENTITY(),0);"); Database db = DatabaseFactory.CreateDatabase(); using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString())) { try { db.AddInParameter(dbCommand, "ProjectID", DbType.Int32, model.ProjectID); db.AddInParameter(dbCommand, "TicketID", DbType.Int32, model.TicketID); db.AddInParameter(dbCommand, "OrderNum", DbType.Int32, model.OrderNum); int result; object obj = db.ExecuteScalar(dbCommand); if (!int.TryParse(obj.ToString(), out result)) { return(0); } return(result); } catch (Exception ex) { WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]", strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message)); return(0); } } }