/// <summary> /// 更新一条数据 /// </summary> public bool Update(Student.Model.STU_MATERIALS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update STU_MATERIALS set "); strSql.Append("EXECNO=@EXECNO,"); strSql.Append("MATERIALNO=@MATERIALNO,"); strSql.Append("IF_TURNOVER=@IF_TURNOVER,"); strSql.Append("TURNOVERTM=@TURNOVERTM"); strSql.Append(" where TURNOVERNO=@TURNOVERNO"); SqlParameter[] parameters = { new SqlParameter("@EXECNO", SqlDbType.Decimal, 9), new SqlParameter("@MATERIALNO", SqlDbType.Decimal, 9), new SqlParameter("@IF_TURNOVER", SqlDbType.Int, 4), new SqlParameter("@TURNOVERTM", SqlDbType.DateTime), new SqlParameter("@TURNOVERNO", SqlDbType.Int, 4) }; parameters[0].Value = model.EXECNO; parameters[1].Value = model.MATERIALNO; parameters[2].Value = model.IF_TURNOVER; parameters[3].Value = model.TURNOVERTM; parameters[4].Value = model.TURNOVERNO; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.STU_MATERIALS DataRowToModel(DataRow row) { Student.Model.STU_MATERIALS model = new Student.Model.STU_MATERIALS(); if (row != null) { if (row["TURNOVERNO"] != null && row["TURNOVERNO"].ToString() != "") { model.TURNOVERNO = int.Parse(row["TURNOVERNO"].ToString()); } if (row["EXECNO"] != null && row["EXECNO"].ToString() != "") { model.EXECNO = decimal.Parse(row["EXECNO"].ToString()); } if (row["MATERIALNO"] != null && row["MATERIALNO"].ToString() != "") { model.MATERIALNO = decimal.Parse(row["MATERIALNO"].ToString()); } if (row["IF_TURNOVER"] != null && row["IF_TURNOVER"].ToString() != "") { model.IF_TURNOVER = int.Parse(row["IF_TURNOVER"].ToString()); } if (row["TURNOVERTM"] != null && row["TURNOVERTM"].ToString() != "") { model.TURNOVERTM = DateTime.Parse(row["TURNOVERTM"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public int Add(Student.Model.STU_MATERIALS model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into STU_MATERIALS("); strSql.Append("EXECNO,MATERIALNO,IF_TURNOVER,TURNOVERTM)"); strSql.Append(" values ("); strSql.Append("@EXECNO,@MATERIALNO,@IF_TURNOVER,@TURNOVERTM)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@EXECNO", SqlDbType.Decimal, 9), new SqlParameter("@MATERIALNO", SqlDbType.Decimal, 9), new SqlParameter("@IF_TURNOVER", SqlDbType.Int, 4), new SqlParameter("@TURNOVERTM", SqlDbType.DateTime) }; parameters[0].Value = model.EXECNO; parameters[1].Value = model.MATERIALNO; parameters[2].Value = model.IF_TURNOVER; parameters[3].Value = model.TURNOVERTM; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Student.Model.STU_MATERIALS GetModel(int TURNOVERNO) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TURNOVERNO,EXECNO,MATERIALNO,IF_TURNOVER,TURNOVERTM from STU_MATERIALS "); strSql.Append(" where TURNOVERNO=@TURNOVERNO"); SqlParameter[] parameters = { new SqlParameter("@TURNOVERNO", SqlDbType.Int, 4) }; parameters[0].Value = TURNOVERNO; Student.Model.STU_MATERIALS model = new Student.Model.STU_MATERIALS(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }