public TicketEsTime Get(int EsID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select EsID,TicketID,Week,QaAdjust,DevAdjust,GrapTime,DocTime,TrainingTime,TotalTimes,EsByUserId,CreatedTime,Remark,IsPM from EsDetail ");
strSql.Append(" where EsID=@EsID ");
Database db = DatabaseFactory.CreateDatabase();
using (DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString()))
{
try
{
db.AddInParameter(dbCommand, "EsID", DbType.Int32, EsID);
TicketEsTime model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = TicketEsTime.ReaderBind(dataReader);
}
}
return(model);
}
catch (Exception ex)
{
WebLogAgent.Write(string.Format("[SQLText:{0},{1}Messages:\r\n{2}]", strSql.ToString(), base.FormatParameters(dbCommand.Parameters), ex.Message));
return(null);
}
}
}
