/// <summary>
/// 得到一个对象实体
/// </summary>
public SmartLaw.Model.SysCode DataRowToModel(DataRow row)
{
SmartLaw.Model.SysCode model=new SmartLaw.Model.SysCode();
if (row != null)
{
if(row["SYSCodeID"]!=null)
{
model.SYSCodeID=row["SYSCodeID"].ToString();
}
if(row["SYSCodeContext"]!=null)
{
model.SYSCodeContext=row["SYSCodeContext"].ToString();
}
if(row["LastModifytime"]!=null && row["LastModifytime"].ToString()!="")
{
model.LastModifytime=DateTime.Parse(row["LastModifytime"].ToString());
}
if(row["ISValid"]!=null && row["ISValid"].ToString()!="")
{
if((row["ISValid"].ToString()=="1")||(row["ISValid"].ToString().ToLower()=="true"))
{
model.ISValid=true;
}
else
{
model.ISValid=false;
}
}
if(row["Memo"]!=null)
{
model.Memo=row["Memo"].ToString();
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SmartLaw.Model.SysCode GetModel(string SYSCodeID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select SYSCodeID,SYSCodeContext,LastModifytime,ISValid,Memo from T_SYSCODE");
strSql.Append(" where SYSCodeID=@SYSCodeID limit 1");
MySqlParameter[] parameters = {
new MySqlParameter("@SYSCodeID", MySqlDbType.VarChar,50) };
parameters[0].Value = SYSCodeID;
SmartLaw.Model.SysCode model=new SmartLaw.Model.SysCode();
DataSet ds=DbHelperMySQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
