/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.Log DataRowToModel(DataRow row) { SmartLaw.Model.Log model=new SmartLaw.Model.Log(); if (row != null) { if(row["AutoID"]!=null && row["AutoID"].ToString()!="") { model.AutoID=long.Parse(row["AutoID"].ToString()); } if(row["OperationItem"]!=null) { model.OperationItem=row["OperationItem"].ToString(); } if(row["OperationTime"]!=null && row["OperationTime"].ToString()!="") { model.OperationTime=DateTime.Parse(row["OperationTime"].ToString()); } if(row["OperationDetail"]!=null) { model.OperationDetail=row["OperationDetail"].ToString(); } if(row["Operator"]!=null) { model.Operator=row["Operator"].ToString(); } if(row["Memo"]!=null) { model.Memo=row["Memo"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public SmartLaw.Model.Log GetModel(long AutoID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select AutoID,OperationItem,OperationTime,OperationDetail,Operator,Memo from log "); strSql.Append(" where AutoID=@AutoID"); MySqlParameter[] parameters = { new MySqlParameter("@AutoID", MySqlDbType.Int64) }; parameters[0].Value = AutoID; SmartLaw.Model.Log model=new SmartLaw.Model.Log(); DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }