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