/// <summary> /// 增加一条数据 /// </summary> public bool Add(IMeiWei.Model.ticket model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ticket("); strSql.Append("Id,TicketNumber,TicketAmount,LimitTime,CreateTime,CreateBy)"); strSql.Append(" values ("); strSql.Append("@Id,@TicketNumber,@TicketAmount,@LimitTime,@CreateTime,@CreateBy)"); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySqlDbType.Int64, 20), new MySqlParameter("@TicketNumber", MySqlDbType.Int32, 11), new MySqlParameter("@TicketAmount", MySqlDbType.Int32, 11), new MySqlParameter("@LimitTime", MySqlDbType.DateTime), new MySqlParameter("@CreateTime", MySqlDbType.DateTime), new MySqlParameter("@CreateBy", MySqlDbType.VarChar, 255) }; parameters[0].Value = model.Id; parameters[1].Value = model.TicketNumber; parameters[2].Value = model.TicketAmount; parameters[3].Value = model.LimitTime; parameters[4].Value = model.CreateTime; parameters[5].Value = model.CreateBy; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IMeiWei.Model.ticket DataRowToModel(DataRow row) { IMeiWei.Model.ticket model = new IMeiWei.Model.ticket(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = long.Parse(row["Id"].ToString()); } if (row["TicketNumber"] != null && row["TicketNumber"].ToString() != "") { model.TicketNumber = int.Parse(row["TicketNumber"].ToString()); } if (row["TicketAmount"] != null && row["TicketAmount"].ToString() != "") { model.TicketAmount = int.Parse(row["TicketAmount"].ToString()); } if (row["LimitTime"] != null && row["LimitTime"].ToString() != "") { model.LimitTime = DateTime.Parse(row["LimitTime"].ToString()); } if (row["CreateTime"] != null && row["CreateTime"].ToString() != "") { model.CreateTime = DateTime.Parse(row["CreateTime"].ToString()); } if (row["CreateBy"] != null) { model.CreateBy = row["CreateBy"].ToString(); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(IMeiWei.Model.ticket model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update ticket set "); strSql.Append("TicketNumber=@TicketNumber,"); strSql.Append("TicketAmount=@TicketAmount,"); strSql.Append("LimitTime=@LimitTime,"); strSql.Append("CreateTime=@CreateTime,"); strSql.Append("CreateBy=@CreateBy,"); strSql.Append("TicketReferenceId=@TicketReferenceId"); strSql.Append(" where Id=@Id"); MySqlParameter[] parameters = { new MySqlParameter("@TicketNumber", MySqlDbType.Int32, 11), new MySqlParameter("@TicketAmount", MySqlDbType.Int32, 11), new MySqlParameter("@LimitTime", MySqlDbType.DateTime), new MySqlParameter("@CreateTime", MySqlDbType.DateTime), new MySqlParameter("@CreateBy", MySqlDbType.VarChar, 255), new MySqlParameter("@TicketReferenceId", MySqlDbType.VarChar, 36), new MySqlParameter("@Id", MySqlDbType.Int64, 20) }; parameters[0].Value = model.TicketNumber; parameters[1].Value = model.TicketAmount; parameters[2].Value = model.LimitTime; parameters[3].Value = model.CreateTime; parameters[4].Value = model.CreateBy; parameters[5].Value = model.TicketReferenceId; parameters[6].Value = model.Id; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public IMeiWei.Model.ticket GetModel(long Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,TicketNumber,TicketAmount,LimitTime,CreateTime,CreateBy from ticket "); strSql.Append(" where Id=@Id "); MySqlParameter[] parameters = { new MySqlParameter("@Id", MySqlDbType.Int64, 20) }; parameters[0].Value = Id; IMeiWei.Model.ticket model = new IMeiWei.Model.ticket(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }