/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LearnSite.Model.ShareDisk model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ShareDisk set ");
strSql.Append("Kown=@Kown,");
strSql.Append("Kyear=@Kyear,");
strSql.Append("Kgrade=@Kgrade,");
strSql.Append("Kclass=@Kclass,");
strSql.Append("Kgroup=@Kgroup,");
strSql.Append("Knum=@Knum,");
strSql.Append("Kname=@Kname,");
strSql.Append("Kfilename=@Kfilename,");
strSql.Append("Kfsize=@Kfsize,");
strSql.Append("Kfurl=@Kfurl,");
strSql.Append("Kftpe=@Kftpe,");
strSql.Append("Kfdate=@Kfdate");
strSql.Append(" where Kid=@Kid");
SqlParameter[] parameters =
{
new SqlParameter("@Kown", SqlDbType.Bit, 1),
new SqlParameter("@Kyear", SqlDbType.Int, 4),
new SqlParameter("@Kgrade", SqlDbType.Int, 4),
new SqlParameter("@Kclass", SqlDbType.Int, 4),
new SqlParameter("@Kgroup", SqlDbType.Int, 4),
new SqlParameter("@Knum", SqlDbType.NVarChar, 50),
new SqlParameter("@Kname", SqlDbType.NVarChar, 50),
new SqlParameter("@Kfilename", SqlDbType.NVarChar, 50),
new SqlParameter("@Kfsize", SqlDbType.Int, 4),
new SqlParameter("@Kfurl", SqlDbType.NVarChar, 200),
new SqlParameter("@Kftpe", SqlDbType.NVarChar, 50),
new SqlParameter("@Kfdate", SqlDbType.DateTime),
new SqlParameter("@Kid", SqlDbType.Int, 4)
};
parameters[0].Value = model.Kown;
parameters[1].Value = model.Kyear;
parameters[2].Value = model.Kgrade;
parameters[3].Value = model.Kclass;
parameters[4].Value = model.Kgroup;
parameters[5].Value = model.Knum;
parameters[6].Value = model.Kname;
parameters[7].Value = model.Kfilename;
parameters[8].Value = model.Kfsize;
parameters[9].Value = model.Kfurl;
parameters[10].Value = model.Kftpe;
parameters[11].Value = model.Kfdate;
parameters[12].Value = model.Kid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LearnSite.Model.ShareDisk model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ShareDisk(");
strSql.Append("Kown,Kyear,Kgrade,Kclass,Kgroup,Knum,Kname,Kfilename,Kfsize,Kfurl,Kftpe,Kfdate)");
strSql.Append(" values (");
strSql.Append("@Kown,@Kyear,@Kgrade,@Kclass,@Kgroup,@Knum,@Kname,@Kfilename,@Kfsize,@Kfurl,@Kftpe,@Kfdate)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Kown", SqlDbType.Bit, 1),
new SqlParameter("@Kyear", SqlDbType.Int, 4),
new SqlParameter("@Kgrade", SqlDbType.Int, 4),
new SqlParameter("@Kclass", SqlDbType.Int, 4),
new SqlParameter("@Kgroup", SqlDbType.Int, 4),
new SqlParameter("@Knum", SqlDbType.NVarChar, 50),
new SqlParameter("@Kname", SqlDbType.NVarChar, 50),
new SqlParameter("@Kfilename", SqlDbType.NVarChar, 50),
new SqlParameter("@Kfsize", SqlDbType.Int, 4),
new SqlParameter("@Kfurl", SqlDbType.NVarChar, 200),
new SqlParameter("@Kftpe", SqlDbType.NVarChar, 50),
new SqlParameter("@Kfdate", SqlDbType.DateTime)
};
parameters[0].Value = model.Kown;
parameters[1].Value = model.Kyear;
parameters[2].Value = model.Kgrade;
parameters[3].Value = model.Kclass;
parameters[4].Value = model.Kgroup;
parameters[5].Value = model.Knum;
parameters[6].Value = model.Kname;
parameters[7].Value = model.Kfilename;
parameters[8].Value = model.Kfsize;
parameters[9].Value = model.Kfurl;
parameters[10].Value = model.Kftpe;
parameters[11].Value = model.Kfdate;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LearnSite.Model.ShareDisk GetModel(int Kid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Kid,Kown,Kyear,Kgrade,Kclass,Kgroup,Knum,Kname,Kfilename,Kfsize,Kfurl,Kftpe,Kfdate from ShareDisk ");
strSql.Append(" where Kid=@Kid");
SqlParameter[] parameters =
{
new SqlParameter("@Kid", SqlDbType.Int, 4)
};
parameters[0].Value = Kid;
LearnSite.Model.ShareDisk model = new LearnSite.Model.ShareDisk();
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>
/// 得到一个对象实体
/// </summary>
public LearnSite.Model.ShareDisk DataRowToModel(DataRow row)
{
LearnSite.Model.ShareDisk model = new LearnSite.Model.ShareDisk();
if (row != null)
{
if (row["Kid"] != null && row["Kid"].ToString() != "")
{
model.Kid = int.Parse(row["Kid"].ToString());
}
if (row["Kown"] != null && row["Kown"].ToString() != "")
{
if ((row["Kown"].ToString() == "1") || (row["Kown"].ToString().ToLower() == "true"))
{
model.Kown = true;
}
else
{
model.Kown = false;
}
}
if (row["Kyear"] != null && row["Kyear"].ToString() != "")
{
model.Kyear = int.Parse(row["Kyear"].ToString());
}
if (row["Kgrade"] != null && row["Kgrade"].ToString() != "")
{
model.Kgrade = int.Parse(row["Kgrade"].ToString());
}
if (row["Kclass"] != null && row["Kclass"].ToString() != "")
{
model.Kclass = int.Parse(row["Kclass"].ToString());
}
if (row["Kgroup"] != null && row["Kgroup"].ToString() != "")
{
model.Kgroup = int.Parse(row["Kgroup"].ToString());
}
if (row["Knum"] != null)
{
model.Knum = row["Knum"].ToString();
}
if (row["Kname"] != null)
{
model.Kname = row["Kname"].ToString();
}
if (row["Kfilename"] != null)
{
model.Kfilename = row["Kfilename"].ToString();
}
if (row["Kfsize"] != null && row["Kfsize"].ToString() != "")
{
model.Kfsize = int.Parse(row["Kfsize"].ToString());
}
if (row["Kfurl"] != null)
{
model.Kfurl = row["Kfurl"].ToString();
}
if (row["Kftpe"] != null)
{
model.Kftpe = row["Kftpe"].ToString();
}
if (row["Kfdate"] != null && row["Kfdate"].ToString() != "")
{
model.Kfdate = DateTime.Parse(row["Kfdate"].ToString());
}
}
return(model);
}
