/// <summary>
/// 得到一个对象实体
/// </summary>
/// <param name="Asid"></param>
/// <param name="Afid"></param>
/// <returns></returns>
public LearnSite.Model.Autonomic GetModel(int Asid, int Afid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Aid,Asid,Anum,Aname,Ayid,Afid,Atype,Afilename,Aurl,Alength,Ascore,Adate,Aip,Avote,Aegg,Acheck,Aself,Agood,Ayear,Agrade,Aclass,Aterm,Ahit,Aoffice,Aflash,Aerror from Autonomic ");
strSql.Append(" where Asid=@Asid and Afid=@Afid ");
SqlParameter[] parameters =
{
new SqlParameter("@Asid", SqlDbType.Int, 4),
new SqlParameter("@Afid", SqlDbType.Int, 4)
};
parameters[0].Value = Asid;
parameters[1].Value = Afid;
LearnSite.Model.Autonomic model = new LearnSite.Model.Autonomic();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据作品记录
/// Asid,Anum,Aname,Ayid,Afid,Atype,Afilename,Aurl,Alength,Adate,Aip,Ayear,Agrade,Aclass,Aterm,Aoffice
/// </summary>
public int AddAutonomic(LearnSite.Model.Autonomic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Autonomic(");
strSql.Append("Asid,Anum,Aname,Ayid,Afid,Atype,Afilename,Aurl,Alength,Adate,Aip,Ayear,Agrade,Aclass,Aterm,Aoffice)");
strSql.Append(" values (");
strSql.Append("@Asid,@Anum,@Aname,@Ayid,@Afid,@Atype,@Afilename,@Aurl,@Alength,@Adate,@Aip,@Ayear,@Agrade,@Aclass,@Aterm,@Aoffice)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Asid", SqlDbType.Int, 4),
new SqlParameter("@Anum", SqlDbType.NVarChar, 50),
new SqlParameter("@Aname", SqlDbType.NVarChar, 50),
new SqlParameter("@Ayid", SqlDbType.Int, 4),
new SqlParameter("@Afid", SqlDbType.Int, 4),
new SqlParameter("@Atype", SqlDbType.NVarChar, 50),
new SqlParameter("@Afilename", SqlDbType.NVarChar, 50),
new SqlParameter("@Aurl", SqlDbType.NVarChar, 200),
new SqlParameter("@Alength", SqlDbType.Int, 4),
new SqlParameter("@Adate", SqlDbType.DateTime),
new SqlParameter("@Aip", SqlDbType.NVarChar, 50),
new SqlParameter("@Ayear", SqlDbType.Int, 4),
new SqlParameter("@Agrade", SqlDbType.Int, 4),
new SqlParameter("@Aclass", SqlDbType.Int, 4),
new SqlParameter("@Aterm", SqlDbType.Int, 4),
new SqlParameter("@Aoffice", SqlDbType.Bit, 1)
};
parameters[0].Value = model.Asid;
parameters[1].Value = model.Anum;
parameters[2].Value = model.Aname;
parameters[3].Value = model.Ayid;
parameters[4].Value = model.Afid;
parameters[5].Value = model.Atype;
parameters[6].Value = model.Afilename;
parameters[7].Value = model.Aurl;
parameters[8].Value = model.Alength;
parameters[9].Value = model.Adate;
parameters[10].Value = model.Aip;
parameters[11].Value = model.Ayear;
parameters[12].Value = model.Agrade;
parameters[13].Value = model.Aclass;
parameters[14].Value = model.Aterm;
parameters[15].Value = model.Aoffice;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LearnSite.Model.Autonomic DataRowToModel(DataRow row)
{
LearnSite.Model.Autonomic model = new LearnSite.Model.Autonomic();
if (row != null)
{
if (row["Aid"] != null && row["Aid"].ToString() != "")
{
model.Aid = int.Parse(row["Aid"].ToString());
}
if (row["Asid"] != null && row["Asid"].ToString() != "")
{
model.Asid = int.Parse(row["Asid"].ToString());
}
if (row["Anum"] != null)
{
model.Anum = row["Anum"].ToString();
}
if (row["Aname"] != null)
{
model.Aname = row["Aname"].ToString();
}
if (row["Ayid"] != null && row["Ayid"].ToString() != "")
{
model.Ayid = int.Parse(row["Ayid"].ToString());
}
if (row["Afid"] != null && row["Afid"].ToString() != "")
{
model.Afid = int.Parse(row["Afid"].ToString());
}
if (row["Atype"] != null)
{
model.Atype = row["Atype"].ToString();
}
if (row["Afilename"] != null)
{
model.Afilename = row["Afilename"].ToString();
}
if (row["Aurl"] != null)
{
model.Aurl = row["Aurl"].ToString();
}
if (row["Alength"] != null && row["Alength"].ToString() != "")
{
model.Alength = int.Parse(row["Alength"].ToString());
}
if (row["Ascore"] != null && row["Ascore"].ToString() != "")
{
model.Ascore = int.Parse(row["Ascore"].ToString());
}
if (row["Adate"] != null && row["Adate"].ToString() != "")
{
model.Adate = DateTime.Parse(row["Adate"].ToString());
}
if (row["Aip"] != null)
{
model.Aip = row["Aip"].ToString();
}
if (row["Avote"] != null && row["Avote"].ToString() != "")
{
model.Avote = int.Parse(row["Avote"].ToString());
}
if (row["Aegg"] != null && row["Aegg"].ToString() != "")
{
model.Aegg = int.Parse(row["Aegg"].ToString());
}
if (row["Acheck"] != null && row["Acheck"].ToString() != "")
{
if ((row["Acheck"].ToString() == "1") || (row["Acheck"].ToString().ToLower() == "true"))
{
model.Acheck = true;
}
else
{
model.Acheck = false;
}
}
if (row["Aself"] != null)
{
model.Aself = row["Aself"].ToString();
}
if (row["Agood"] != null && row["Agood"].ToString() != "")
{
if ((row["Agood"].ToString() == "1") || (row["Agood"].ToString().ToLower() == "true"))
{
model.Agood = true;
}
else
{
model.Agood = false;
}
}
if (row["Ayear"] != null && row["Ayear"].ToString() != "")
{
model.Ayear = int.Parse(row["Ayear"].ToString());
}
if (row["Agrade"] != null && row["Agrade"].ToString() != "")
{
model.Agrade = int.Parse(row["Agrade"].ToString());
}
if (row["Aclass"] != null && row["Aclass"].ToString() != "")
{
model.Aclass = int.Parse(row["Aclass"].ToString());
}
if (row["Aterm"] != null && row["Aterm"].ToString() != "")
{
model.Aterm = int.Parse(row["Aterm"].ToString());
}
if (row["Ahit"] != null && row["Ahit"].ToString() != "")
{
model.Ahit = int.Parse(row["Ahit"].ToString());
}
if (row["Aoffice"] != null && row["Aoffice"].ToString() != "")
{
if ((row["Aoffice"].ToString() == "1") || (row["Aoffice"].ToString().ToLower() == "true"))
{
model.Aoffice = true;
}
else
{
model.Aoffice = false;
}
}
if (row["Aflash"] != null && row["Aflash"].ToString() != "")
{
if ((row["Aflash"].ToString() == "1") || (row["Aflash"].ToString().ToLower() == "true"))
{
model.Aflash = true;
}
else
{
model.Aflash = false;
}
}
if (row["Aerror"] != null && row["Aerror"].ToString() != "")
{
if ((row["Aerror"].ToString() == "1") || (row["Aerror"].ToString().ToLower() == "true"))
{
model.Aerror = true;
}
else
{
model.Aerror = false;
}
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LearnSite.Model.Autonomic model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update Autonomic set ");
strSql.Append("Asid=@Asid,");
strSql.Append("Anum=@Anum,");
strSql.Append("Aname=@Aname,");
strSql.Append("Ayid=@Ayid,");
strSql.Append("Afid=@Afid,");
strSql.Append("Atype=@Atype,");
strSql.Append("Afilename=@Afilename,");
strSql.Append("Aurl=@Aurl,");
strSql.Append("Alength=@Alength,");
strSql.Append("Ascore=@Ascore,");
strSql.Append("Adate=@Adate,");
strSql.Append("Aip=@Aip,");
strSql.Append("Avote=@Avote,");
strSql.Append("Aegg=@Aegg,");
strSql.Append("Acheck=@Acheck,");
strSql.Append("Aself=@Aself,");
strSql.Append("Agood=@Agood,");
strSql.Append("Ayear=@Ayear,");
strSql.Append("Agrade=@Agrade,");
strSql.Append("Aclass=@Aclass,");
strSql.Append("Aterm=@Aterm,");
strSql.Append("Ahit=@Ahit,");
strSql.Append("Aoffice=@Aoffice,");
strSql.Append("Aflash=@Aflash,");
strSql.Append("Aerror=@Aerror");
strSql.Append(" where Aid=@Aid");
SqlParameter[] parameters =
{
new SqlParameter("@Asid", SqlDbType.Int, 4),
new SqlParameter("@Anum", SqlDbType.NVarChar, 50),
new SqlParameter("@Aname", SqlDbType.NVarChar, 50),
new SqlParameter("@Ayid", SqlDbType.Int, 4),
new SqlParameter("@Afid", SqlDbType.Int, 4),
new SqlParameter("@Atype", SqlDbType.NVarChar, 50),
new SqlParameter("@Afilename", SqlDbType.NVarChar, 50),
new SqlParameter("@Aurl", SqlDbType.NVarChar, 200),
new SqlParameter("@Alength", SqlDbType.Int, 4),
new SqlParameter("@Ascore", SqlDbType.Int, 4),
new SqlParameter("@Adate", SqlDbType.DateTime),
new SqlParameter("@Aip", SqlDbType.NVarChar, 50),
new SqlParameter("@Avote", SqlDbType.Int, 4),
new SqlParameter("@Aegg", SqlDbType.SmallInt, 2),
new SqlParameter("@Acheck", SqlDbType.Bit, 1),
new SqlParameter("@Aself", SqlDbType.NVarChar, 200),
new SqlParameter("@Agood", SqlDbType.Bit, 1),
new SqlParameter("@Ayear", SqlDbType.Int, 4),
new SqlParameter("@Agrade", SqlDbType.Int, 4),
new SqlParameter("@Aclass", SqlDbType.Int, 4),
new SqlParameter("@Aterm", SqlDbType.Int, 4),
new SqlParameter("@Ahit", SqlDbType.Int, 4),
new SqlParameter("@Aoffice", SqlDbType.Bit, 1),
new SqlParameter("@Aflash", SqlDbType.Bit, 1),
new SqlParameter("@Aerror", SqlDbType.Bit, 1),
new SqlParameter("@Aid", SqlDbType.Int, 4)
};
parameters[0].Value = model.Asid;
parameters[1].Value = model.Anum;
parameters[2].Value = model.Aname;
parameters[3].Value = model.Ayid;
parameters[4].Value = model.Afid;
parameters[5].Value = model.Atype;
parameters[6].Value = model.Afilename;
parameters[7].Value = model.Aurl;
parameters[8].Value = model.Alength;
parameters[9].Value = model.Ascore;
parameters[10].Value = model.Adate;
parameters[11].Value = model.Aip;
parameters[12].Value = model.Avote;
parameters[13].Value = model.Aegg;
parameters[14].Value = model.Acheck;
parameters[15].Value = model.Aself;
parameters[16].Value = model.Agood;
parameters[17].Value = model.Ayear;
parameters[18].Value = model.Agrade;
parameters[19].Value = model.Aclass;
parameters[20].Value = model.Aterm;
parameters[21].Value = model.Ahit;
parameters[22].Value = model.Aoffice;
parameters[23].Value = model.Aflash;
parameters[24].Value = model.Aerror;
parameters[25].Value = model.Aid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
