/// <summary> /// 得到一个对象实体 /// </summary> public LearnSite.Model.NotSign GetModel(int Nid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Nid,Nnum,Ndate,Nyear,Nmonth,Nday,Nweek,Nnote,Ngrade,Nterm from NotSign "); strSql.Append(" where Nid=@Nid "); SqlParameter[] parameters = { new SqlParameter("@Nid", SqlDbType.Int, 4) }; parameters[0].Value = Nid; LearnSite.Model.NotSign model = new LearnSite.Model.NotSign(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Nid"].ToString() != "") { model.Nid = int.Parse(ds.Tables[0].Rows[0]["Nid"].ToString()); } model.Nnum = ds.Tables[0].Rows[0]["Nnum"].ToString(); if (ds.Tables[0].Rows[0]["Ndate"].ToString() != "") { model.Ndate = DateTime.Parse(ds.Tables[0].Rows[0]["Ndate"].ToString()); } if (ds.Tables[0].Rows[0]["Nyear"].ToString() != "") { model.Nyear = int.Parse(ds.Tables[0].Rows[0]["Nyear"].ToString()); } if (ds.Tables[0].Rows[0]["Nmonth"].ToString() != "") { model.Nmonth = int.Parse(ds.Tables[0].Rows[0]["Nmonth"].ToString()); } if (ds.Tables[0].Rows[0]["Nday"].ToString() != "") { model.Nday = int.Parse(ds.Tables[0].Rows[0]["Nday"].ToString()); } model.Nweek = ds.Tables[0].Rows[0]["Nweek"].ToString(); model.Nnote = ds.Tables[0].Rows[0]["Nnote"].ToString(); if (ds.Tables[0].Rows[0]["Ngrade"].ToString() != "") { model.Ngrade = int.Parse(ds.Tables[0].Rows[0]["Ngrade"].ToString()); } if (ds.Tables[0].Rows[0]["Nterm"].ToString() != "") { model.Nterm = int.Parse(ds.Tables[0].Rows[0]["Nterm"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(LearnSite.Model.NotSign model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NotSign("); strSql.Append("Nnum,Ndate,Nyear,Nmonth,Nday,Nweek,Nnote,Ngrade,Nterm)"); strSql.Append(" values ("); strSql.Append("@Nnum,@Ndate,@Nyear,@Nmonth,@Nday,@Nweek,@Nnote,@Ngrade,@Nterm)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Nnum", SqlDbType.NVarChar, 50), new SqlParameter("@Ndate", SqlDbType.DateTime), new SqlParameter("@Nyear", SqlDbType.Int, 4), new SqlParameter("@Nmonth", SqlDbType.Int, 4), new SqlParameter("@Nday", SqlDbType.Int, 4), new SqlParameter("@Nweek", SqlDbType.NVarChar, 50), new SqlParameter("@Nnote", SqlDbType.NVarChar), new SqlParameter("@Ngrade", SqlDbType.Int, 4), new SqlParameter("@Nterm", SqlDbType.Int, 4) }; parameters[0].Value = model.Nnum; parameters[1].Value = model.Ndate; parameters[2].Value = model.Nyear; parameters[3].Value = model.Nmonth; parameters[4].Value = model.Nday; parameters[5].Value = model.Nweek; parameters[6].Value = model.Nnote; parameters[7].Value = model.Ngrade; parameters[8].Value = model.Nterm; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public void Update(LearnSite.Model.NotSign model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update NotSign set "); strSql.Append("Nnum=@Nnum,"); strSql.Append("Ndate=@Ndate,"); strSql.Append("Nyear=@Nyear,"); strSql.Append("Nmonth=@Nmonth,"); strSql.Append("Nday=@Nday,"); strSql.Append("Nweek=@Nweek,"); strSql.Append("Nnote=@Nnote"); strSql.Append("Ngrade=@Ngrade"); strSql.Append("Nterm=@Nterm"); strSql.Append(" where Nid=@Nid "); SqlParameter[] parameters = { new SqlParameter("@Nid", SqlDbType.Int, 4), new SqlParameter("@Nnum", SqlDbType.NVarChar, 50), new SqlParameter("@Ndate", SqlDbType.DateTime), new SqlParameter("@Nyear", SqlDbType.Int, 4), new SqlParameter("@Nmonth", SqlDbType.Int, 4), new SqlParameter("@Nday", SqlDbType.Int, 4), new SqlParameter("@Nweek", SqlDbType.NVarChar, 50), new SqlParameter("@Nnote", SqlDbType.NVarChar), new SqlParameter("@Ngrade", SqlDbType.Int, 4), new SqlParameter("@Nterm", SqlDbType.Int, 4) }; parameters[0].Value = model.Nid; parameters[1].Value = model.Nnum; parameters[2].Value = model.Ndate; parameters[3].Value = model.Nyear; parameters[4].Value = model.Nmonth; parameters[5].Value = model.Nday; parameters[6].Value = model.Nweek; parameters[7].Value = model.Nnote; parameters[8].Value = model.Ngrade; parameters[9].Value = model.Nterm; DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); }