/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.PARTYBUILD_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PARTYBUILD_INFO set "); strSql.Append("CLASSNO=@CLASSNO,"); strSql.Append("STUNO=@STUNO,"); strSql.Append("TERMNO=@TERMNO,"); strSql.Append("STATUS=@STATUS,"); strSql.Append("APPLICATIONTM=@APPLICATIONTM,"); strSql.Append("EXCELLENTTM=@EXCELLENTTM,"); strSql.Append("PREPARATIONTM=@PREPARATIONTM,"); strSql.Append("MEMBERTM=@MEMBERTM,"); strSql.Append("MEMO=@MEMO"); strSql.Append(" where RCD_ID=@RCD_ID"); SqlParameter[] parameters = { new SqlParameter("@CLASSNO", SqlDbType.Int, 4), new SqlParameter("@STUNO", SqlDbType.VarChar, 10), new SqlParameter("@TERMNO", SqlDbType.Int, 4), new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@APPLICATIONTM", SqlDbType.DateTime), new SqlParameter("@EXCELLENTTM", SqlDbType.DateTime), new SqlParameter("@PREPARATIONTM", SqlDbType.DateTime), new SqlParameter("@MEMBERTM", SqlDbType.DateTime), new SqlParameter("@MEMO", SqlDbType.VarChar, 200), new SqlParameter("@RCD_ID", SqlDbType.Decimal, 9) }; parameters[0].Value = model.CLASSNO; parameters[1].Value = model.STUNO; parameters[2].Value = model.TERMNO; parameters[3].Value = model.STATUS; parameters[4].Value = model.APPLICATIONTM; parameters[5].Value = model.EXCELLENTTM; parameters[6].Value = model.PREPARATIONTM; parameters[7].Value = model.MEMBERTM; parameters[8].Value = model.MEMO; parameters[9].Value = model.RCD_ID; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.PARTYBUILD_INFO DataRowToModel(DataRow row) { Student.Model.PARTYBUILD_INFO model = new Student.Model.PARTYBUILD_INFO(); if (row != null) { if (row["RCD_ID"] != null && row["RCD_ID"].ToString() != "") { model.RCD_ID = decimal.Parse(row["RCD_ID"].ToString()); } if (row["CLASSNO"] != null && row["CLASSNO"].ToString() != "") { model.CLASSNO = int.Parse(row["CLASSNO"].ToString()); } if (row["STUNO"] != null) { model.STUNO = row["STUNO"].ToString(); } if (row["TERMNO"] != null && row["TERMNO"].ToString() != "") { model.TERMNO = int.Parse(row["TERMNO"].ToString()); } if (row["STATUS"] != null && row["STATUS"].ToString() != "") { model.STATUS = int.Parse(row["STATUS"].ToString()); } if (row["APPLICATIONTM"] != null && row["APPLICATIONTM"].ToString() != "") { model.APPLICATIONTM = DateTime.Parse(row["APPLICATIONTM"].ToString()); } if (row["EXCELLENTTM"] != null && row["EXCELLENTTM"].ToString() != "") { model.EXCELLENTTM = DateTime.Parse(row["EXCELLENTTM"].ToString()); } if (row["PREPARATIONTM"] != null && row["PREPARATIONTM"].ToString() != "") { model.PREPARATIONTM = DateTime.Parse(row["PREPARATIONTM"].ToString()); } if (row["MEMBERTM"] != null && row["MEMBERTM"].ToString() != "") { model.MEMBERTM = DateTime.Parse(row["MEMBERTM"].ToString()); } if (row["MEMO"] != null) { model.MEMO = row["MEMO"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public decimal Add(Student.Model.PARTYBUILD_INFO model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PARTYBUILD_INFO("); strSql.Append("CLASSNO,STUNO,TERMNO,STATUS,APPLICATIONTM,EXCELLENTTM,PREPARATIONTM,MEMBERTM,MEMO)"); strSql.Append(" values ("); strSql.Append("@CLASSNO,@STUNO,@TERMNO,@STATUS,@APPLICATIONTM,@EXCELLENTTM,@PREPARATIONTM,@MEMBERTM,@MEMO)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@CLASSNO", SqlDbType.Int, 4), new SqlParameter("@STUNO", SqlDbType.VarChar, 10), new SqlParameter("@TERMNO", SqlDbType.Int, 4), new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@APPLICATIONTM", SqlDbType.DateTime), new SqlParameter("@EXCELLENTTM", SqlDbType.DateTime), new SqlParameter("@PREPARATIONTM", SqlDbType.DateTime), new SqlParameter("@MEMBERTM", SqlDbType.DateTime), new SqlParameter("@MEMO", SqlDbType.VarChar, 200) }; parameters[0].Value = model.CLASSNO; parameters[1].Value = model.STUNO; parameters[2].Value = model.TERMNO; parameters[3].Value = model.STATUS; parameters[4].Value = model.APPLICATIONTM; parameters[5].Value = model.EXCELLENTTM; parameters[6].Value = model.PREPARATIONTM; parameters[7].Value = model.MEMBERTM; parameters[8].Value = model.MEMO; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToDecimal(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.PARTYBUILD_INFO GetModel(decimal RCD_ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RCD_ID,CLASSNO,STUNO,TERMNO,STATUS,APPLICATIONTM,EXCELLENTTM,PREPARATIONTM,MEMBERTM,MEMO from PARTYBUILD_INFO "); strSql.Append(" where RCD_ID=@RCD_ID"); SqlParameter[] parameters = { new SqlParameter("@RCD_ID", SqlDbType.Decimal) }; parameters[0].Value = RCD_ID; Student.Model.PARTYBUILD_INFO model = new Student.Model.PARTYBUILD_INFO(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }