/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.baseconfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update baseconfig set "); strSql.Append(" version=@ version,"); strSql.Append("startTime=@startTime,"); strSql.Append("expTime=@expTime,"); strSql.Append("companyName=@companyName"); strSql.Append(" where version=@ version and startTime=@startTime and expTime=@expTime and companyName=@companyName "); MySqlParameter[] parameters = { new MySqlParameter("@ version", MySqlDbType.VarChar, 32), new MySqlParameter("@startTime", MySqlDbType.DateTime), new MySqlParameter("@expTime", MySqlDbType.DateTime), new MySqlParameter("@companyName", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.version; parameters[1].Value = model.startTime; parameters[2].Value = model.expTime; parameters[3].Value = model.companyName; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.baseconfig model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into baseconfig("); strSql.Append(" version,startTime,expTime,companyName)"); strSql.Append(" values ("); strSql.Append("@ version,@startTime,@expTime,@companyName)"); MySqlParameter[] parameters = { new MySqlParameter("@ version", MySqlDbType.VarChar, 32), new MySqlParameter("@startTime", MySqlDbType.DateTime), new MySqlParameter("@expTime", MySqlDbType.DateTime), new MySqlParameter("@companyName", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.version; parameters[1].Value = model.startTime; parameters[2].Value = model.expTime; parameters[3].Value = model.companyName; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.baseconfig GetModel(string version, DateTime startTime, DateTime expTime, string companyName) { StringBuilder strSql = new StringBuilder(); strSql.Append("select version,startTime,expTime,companyName from baseconfig "); strSql.Append(" where version=@ version and startTime=@startTime and expTime=@expTime and companyName=@companyName "); MySqlParameter[] parameters = { new MySqlParameter("@ version", MySqlDbType.VarChar, 32), new MySqlParameter("@startTime", MySqlDbType.DateTime), new MySqlParameter("@expTime", MySqlDbType.DateTime), new MySqlParameter("@companyName", MySqlDbType.VarChar, 255) }; parameters[0].Value = version; parameters[1].Value = startTime; parameters[2].Value = expTime; parameters[3].Value = companyName; Maticsoft.Model.baseconfig model = new Maticsoft.Model.baseconfig(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.baseconfig DataRowToModel(DataRow row) { Maticsoft.Model.baseconfig model = new Maticsoft.Model.baseconfig(); if (row != null) { if (row[" version"] != null) { model.version = row[" version"].ToString(); } if (row["startTime"] != null && row["startTime"].ToString() != "") { model.startTime = DateTime.Parse(row["startTime"].ToString()); } if (row["expTime"] != null && row["expTime"].ToString() != "") { model.expTime = DateTime.Parse(row["expTime"].ToString()); } if (row["companyName"] != null) { model.companyName = row["companyName"].ToString(); } } return(model); }