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