/// <summary> /// 更新一条数据 /// </summary> public bool Update(abc.Model.Model.SYS_DatabaseUpgrade model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SYS_DatabaseUpgrade set "); strSql.Append("Line=SQL2012Line,"); strSql.Append("UpdateTime=SQL2012UpdateTime"); strSql.Append(" where FileName=SQL2012FileName "); SqlParameter[] parameters = { new SqlParameter("SQL2012Line", SqlDbType.Decimal, 9), new SqlParameter("SQL2012UpdateTime", SqlDbType.DateTime), new SqlParameter("SQL2012FileName", SqlDbType.VarChar, 200) }; parameters[0].Value = model.Line; parameters[1].Value = model.UpdateTime; parameters[2].Value = model.FileName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(abc.Model.Model.SYS_DatabaseUpgrade model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SYS_DatabaseUpgrade("); strSql.Append("FileName,Line,UpdateTime)"); strSql.Append(" values ("); strSql.Append("SQL2012FileName,SQL2012Line,SQL2012UpdateTime)"); SqlParameter[] parameters = { new SqlParameter("SQL2012FileName", SqlDbType.VarChar, 200), new SqlParameter("SQL2012Line", SqlDbType.Decimal, 9), new SqlParameter("SQL2012UpdateTime", SqlDbType.DateTime) }; parameters[0].Value = model.FileName; parameters[1].Value = model.Line; parameters[2].Value = model.UpdateTime; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public abc.Model.Model.SYS_DatabaseUpgrade DataRowToModel(DataRow row) { abc.Model.Model.SYS_DatabaseUpgrade model = new abc.Model.Model.SYS_DatabaseUpgrade(); if (row != null) { if (row["FileName"] != null) { model.FileName = row["FileName"].ToString(); } if (row["Line"] != null && row["Line"].ToString() != "") { model.Line = decimal.Parse(row["Line"].ToString()); } if (row["UpdateTime"] != null && row["UpdateTime"].ToString() != "") { model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public abc.Model.Model.SYS_DatabaseUpgrade GetModel(string FileName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 FileName,Line,UpdateTime from SYS_DatabaseUpgrade "); strSql.Append(" where FileName=SQL2012FileName "); SqlParameter[] parameters = { new SqlParameter("SQL2012FileName", SqlDbType.VarChar, 200) }; parameters[0].Value = FileName; abc.Model.Model.SYS_DatabaseUpgrade model = new abc.Model.Model.SYS_DatabaseUpgrade(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }