/// <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); }