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