/// <summary> /// 获取话题列表 /// </summary> /// <param name="gradeId"></param> /// <param name="subjectId"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="totalCount"></param> /// <returns></returns> public static List <dto_Topic> GetTopics(int gradeId, int subjectId, int pageIndex, int pageSize, out int totalCount) { string tcsql = "T_Topic where Deleted = 0 and Blocked = 0 "; List <MySqlParameter> pl = new List <MySqlParameter>(); if (gradeId != 0) { tcsql += "and GradeId = @GradeId "; pl.Add(new MySqlParameter("@GradeId", gradeId)); } if (subjectId != 0) { tcsql += "and SubjectId = @SubjectId "; pl.Add(new MySqlParameter("@SubjectId", subjectId)); } List <dto_Topic> model = null; using (MySqlDataReader dr = MySqlDBHelper.GetPageReader(Util.GetConnectString(BBSConnString), "Id, UserId, Invites, Title, TopicContent, TopicText, CreateDate, Good, Hit, ReplyCount, GradeId, SubjectId, Ip", tcsql, "CreateDate desc", pageSize, pageIndex, out totalCount, pl.ToArray())) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <dto_Topic>(dr); } } return(model); }
public static void UpdateCardAmount(float amount, float updateAmount, int id, int type, out int uSuccess) { StringBuilder sb = new StringBuilder(); MySqlParameter[] pars = new MySqlParameter[3]; pars[0] = new MySqlParameter("@Id", MySqlDbType.Int32); pars[1] = new MySqlParameter("@Amount", MySqlDbType.Float); if (type == 1) { sb.AppendFormat(" {0} ", "update card set Amount=@Amount,IncomeAmount=@IncomeAmount where Id=@Id"); pars[2] = new MySqlParameter("@IncomeAmount", MySqlDbType.Float); } else if (type == 2) { sb.AppendFormat(" {0} ", "update card set Amount=@Amount,ExpenditureAmount=@ExpenditureAmount where Id=@Id"); pars[2] = new MySqlParameter("@ExpenditureAmount", MySqlDbType.Float); } else if (type == 3) { sb.AppendFormat(" {0} ", "update card set Amount=@Amount,BorrowAmount=@BorrowAmount where Id=@Id"); pars[2] = new MySqlParameter("@BorrowAmount", MySqlDbType.Float); } else if (type == 4) { sb.AppendFormat(" {0} ", "update card set Amount=@Amount,LoanAmount=@LoanAmount where Id=@Id"); pars[2] = new MySqlParameter("@LoanAmount", MySqlDbType.Float); } pars[0].Value = id; pars[1].Value = amount; pars[2].Value = updateAmount; uSuccess = MySqlDBHelper.ExecuteCommand(sb.ToString(), pars); }
public static IDBHelper CreateErpInstance() { IDBHelper _iDBHelper; string dbType = Util.DalConst.ErpDBType; switch (dbType) { case "MySql": _iDBHelper = new MySqlDBHelper(); break; case "SqlServer": _iDBHelper = new SqlDBHelper(); break; case "Oracle": _iDBHelper = new OracleHelper(); break; default: _iDBHelper = new SqlDBHelper(); break; } return(_iDBHelper); }
/// <summary> /// 购票数据上传 /// </summary> /// <param name="datetime"></param> /// <param name="gameName"></param> public static void Ticket(string datetime, string gameName) { LogManager.WriteLog("购买数据开始处理"); try { string sql = @"SELECT ProductName, CertificateName, oi.CertificateNo,CellPhone,AreaName,RowNum,SeatNum,TicketId FROM himall_orderseats os INNER JOIN himall_orders o ON os.OrderId = o.Id INNER JOIN himall_orderitems oi ON o.Id = oi.OrderId WHERE ProductName = '" + gameName + "' and OrderDate > '" + datetime + @"'"; //string sql = @"select DISTINCT oi.Id,oi.CertificateName,oi.CertificateNo,oi.CertificatePic,oi.ProductName , // os.TicketId,os.GameId,os.AreaName,os.RowNum,os.SeatNum,o.CellPhone // from himall_orders o // INNER JOIN himall_orderitems oi on o.id = oi.OrderId // INNER JOIN himall_orderseats os on oi.CertificateNo = os.CertificateNo // WHERE OrderDate > '" + DateTime.Now.ToString("yyyy-MM-dd") + @"' AND `OrderStatus` = 2 LIMIT 10"; DataTable dataTable = MySqlDBHelper.ExecuteDataTable(ticketCon, sql); if (dataTable.Rows.Count > 0) { LogManager.WriteLog("本次上次购买数据数量为" + dataTable.Rows.Count + "条"); Ticket ticket = new Ticket() { verification = verification, dataVoList = new List <TicketInfo>() }; foreach (DataRow item in dataTable.Rows) { ticket.dataVoList.Add(new TicketInfo() { activityId = serverGameName, purchaserName = item["CertificateName"].ToString(), purchaserIdCardNo = item["CertificateNo"].ToString(), purchaserTel = item["CellPhone"].ToString(), purchaserSeatNo = item["AreaName"].ToString() + item["RowNum"].ToString() + "排" + item["SeatNum"].ToString() + "号", ticketNo = item["TicketId"].ToString(), }); } string url = URL + "/api/ticket"; string ticketdata = Newtonsoft.Json.JsonConvert.SerializeObject(ticket); string msg = HttpPost(url, ticketdata); LogManager.WriteLog("购买数据上传完成"); LogManager.WriteLog("购买数据上传返回结果:" + msg); } else { LogManager.WriteLog("无购买数据上传"); } } catch (Exception ex) { LogManager.WriteLog("购买数据上传异常" + ex.Message); } }
public static void InsertOrUpdatetoExpenses(ExpensesInfo info, out int iSuccess) { StringBuilder sb = new StringBuilder(); ExpensesInfo expenses = GetExpensesById(info.Id); if (expenses.Id > 0) { sb.Append(" update Expenses set OwnerId=@OwnerId,OwnerName=@OwnerName,SpendType=@SpendType,HowToUse=@HowToUse, "); sb.Append(" Price = @Price,Number = @Number,Amount=@Amount,SpendDate=@SpendDate,SpendMode=@SpendMode,ConsumerId=@ConsumerId,ConsumerName=@ConsumerName,Content=@Content"); sb.Append(" where Id=@Id"); } else { sb.Append(" insert into Expenses (OwnerId,OwnerName,CardId,CardNumber,BankCardNumber,SpendType,HowToUse,Price,Number,Amount,SpendDate,SpendMode,ConsumerId,ConsumerName,Content) "); sb.Append(" Values(@OwnerId,@OwnerName,@CardId,@CardNumber,@BankCardNumber, @SpendType,@HowToUse,@Price,@Number,@Amount,@SpendDate,@SpendMode,@ConsumerId,@ConsumerName,@Content)"); } MySqlParameter[] pars = new MySqlParameter[] { new MySqlParameter("@Id", MySqlDbType.Int32), new MySqlParameter("@OwnerId", MySqlDbType.Int32), new MySqlParameter("@OwnerName", MySqlDbType.String), new MySqlParameter("@CardId", MySqlDbType.Int32), new MySqlParameter("@CardNumber", MySqlDbType.String), new MySqlParameter("@BankCardNumber", MySqlDbType.String), new MySqlParameter("@SpendType", MySqlDbType.Int32), new MySqlParameter("@HowToUse", MySqlDbType.String), new MySqlParameter("@Price", MySqlDbType.Float), new MySqlParameter("@Number", MySqlDbType.Int32), new MySqlParameter("@Amount", MySqlDbType.Float), new MySqlParameter("@SpendDate", MySqlDbType.DateTime), new MySqlParameter("@SpendMode", MySqlDbType.Int32), new MySqlParameter("@ConsumerId", MySqlDbType.Int32), new MySqlParameter("@ConsumerName", MySqlDbType.String), new MySqlParameter("@Content", MySqlDbType.String) }; pars[0].Value = info.Id; pars[1].Value = info.OwnerId; pars[2].Value = info.OwnerName; pars[3].Value = info.CardId; pars[4].Value = info.CardNumber; pars[5].Value = info.BankCardNumber; pars[6].Value = info.SpendType; pars[7].Value = info.HowToUse; pars[8].Value = info.Price; pars[9].Value = info.Number; pars[10].Value = info.Amount; pars[11].Value = info.SpendDate; pars[12].Value = info.SpendMode; pars[13].Value = info.ConsumerId; pars[14].Value = info.ConsumerName; pars[15].Value = info.ConsumerName; iSuccess = MySqlDBHelper.ExecuteCommand(sb.ToString(), pars); if (expenses.Id > 0) { iSuccess = -1; } }
public static void Ticket(int sessionId, string gameName) { LogManager.WriteLog("购买数据开始处理"); try { string sql = "SELECT * FROM white_names where session_id = '" + sessionId + "' and isupload = 0 "; DataTable dataTable = MySqlDBHelper.ExecuteDataTable(PoliceDataFactory.entranceCon, sql); bool flag = dataTable.Rows.Count > 0; if (flag) { LogManager.WriteLog("本次上次购买数据数量为" + dataTable.Rows.Count + "条"); Ticket ticket = new Ticket { verification = verification, dataVoList = new List <TicketInfo>() }; foreach (object obj in dataTable.Rows) { DataRow item = (DataRow)obj; ticket.dataVoList.Add(new TicketInfo { activityId = gameName, purchaserName = item["buy_name"].ToString(), purchaserIdCardNo = item["id_no"].ToString(), purchaserTel = item["purchaser_tel"].ToString(), purchaserSeatNo = string.Concat(new string[] { item["area"].ToString(), item["row"].ToString(), "排", item["seat"].ToString(), "号" }), ticketNo = item["ticket_no"].ToString() }); } string url = URL + "/api/ticket"; string ticketdata = JsonConvert.SerializeObject(ticket); LogManager.WriteLog("购买上传数据:" + ticketdata); string msg = PoliceDataFactory.HttpPost(url, ticketdata, null); LogManager.WriteLog("购买数据上传完成"); LogManager.WriteLog("购买数据上传返回结果:" + msg); LogManager.WriteLog("更新上传数据状态"); string updatesql = "update white_names set isupload=1 where session_id = '" + sessionId + "'"; MySqlDBHelper.ExecuteNonQuery(PoliceDataFactory.entranceCon, CommandType.Text, updatesql); } else { LogManager.WriteLog("无购买数据上传"); } } catch (Exception ex) { LogManager.WriteLog("购买数据上传异常" + ex.Message); } }
/// <summary> /// 删除一条记录 /// </summary> /// <param name="mySqlTransaction"></param> /// <param name="id"></param> /// <param name="iSuccess"></param> public static void DeleteUser(MySqlTransaction mySqlTransaction, int id, out int iSuccess) { StringBuilder sb = new StringBuilder(); sb.Append(" delete from user where id = @id "); MySqlParameter par = new MySqlParameter("@id", MySqlDbType.Int32); par.Value = id; iSuccess = MySqlDBHelper.ExecuteCommand(mySqlTransaction, sb.ToString(), par); }
public static void DeleteCashIncome(int id, out int iSuccess) { StringBuilder sb = new StringBuilder(); sb.Append(" delete from cashincome where Id = @Id "); MySqlParameter par = new MySqlParameter("@Id", MySqlDbType.Int32); par.Value = id; iSuccess = MySqlDBHelper.ExecuteCommand(sb.ToString(), par); }
public static CashIncomeCollection GetCashInCome(List <QueryElement> list) { CashIncomeCollection coll = new CashIncomeCollection(); StringBuilder sb = new StringBuilder(); sb.AppendFormat(" {0} ", "select * from cashincome where 1=1"); if (list.Count > 0) { MySqlParameter[] pars = new MySqlParameter[list.Count]; for (int i = 0; i < list.Count; i++) { QueryElement query = list[i]; if (query.QueryElementType == MySqlDbType.DateTime) { sb.AppendFormat("{0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname + i); pars[i] = new MySqlParameter("@" + query.Queryname + i, query.QueryElementType); } else { sb.AppendFormat("{0} {1} {2} @{3} ", query.QueryLogic, query.Queryname, query.QueryOperation, query.Queryname); pars[i] = new MySqlParameter("@" + query.Queryname, query.QueryElementType); } if (query.QueryOperation.Equals("like")) { pars[i].Value = "%" + query.Queryvalue + "%"; } else { pars[i].Value = query.Queryvalue; } } using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString(), pars)) { while (reader.Read()) { coll.Add(new CashIncomeInfo(reader)); } } } else { using (MySqlDataReader reader = MySqlDBHelper.GetReader(sb.ToString())) { while (reader.Read()) { coll.Add(new CashIncomeInfo(reader)); } } } return(coll); }
/// <summary> /// 搜索用户,只返回前10个 /// </summary> /// <param name="keyWords"></param> /// <returns></returns> public static List <T_User> SearchUser(string keyWords) { List <T_User> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString), "select Id, UserName, TrueName, Mobile, ProvinceId, CityId, DistrictId, SchoolId, GradeId, ClassId from T_User where concat(UserName, TrueName) like '%" + keyWords + "%' limit 20")) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_User>(dr); } } return(model); }
public static List <dto_Topic> GetTopics(int[] topicIds) { List <dto_Topic> list = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BBSConnString), "select Id, UserId, Invites, Title, TopicContent, TopicText, CreateDate, Good, Hit, ReplyCount, GradeId, SubjectId, Deleted, Blocked, Ip from T_Topic where Id in (" + string.Join(",", topicIds) + ")")) { if (dr != null && dr.HasRows) { list = MySqlDBHelper.ConvertDataReaderToEntityList <dto_Topic>(dr); } } return(list); }
public static dto_Reply GetReplyById(int id) { dto_Reply result = null; string sql = "select Id, UserId, TopicId, ReplyContent, CreateDate, Good from T_Reply where Id = @Id "; using (var reader = MySqlHelper.ExecuteReader(Util.GetConnectString(BBSConnString), sql.ToString(), "@Id".ToInt32InPara(id))) { if (reader != null && reader.HasRows) { result = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Reply>(reader); } } return(result); }
/// <summary> /// 根据大题Id获取其所有小题信息(不包含选项) /// </summary> /// <param name="pId"></param> /// <returns></returns> public static List <dto_CQuestion> GetChildQuestions(int pId) { List <dto_CQuestion> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString), "select id, pid, ptypeid, typeid, typename, quesbody, quesanswer, quesparse from T_CQuestions where pid = @pid order by id", "@pid".ToInt32InPara(pId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <dto_CQuestion>(dr); } } return(model); }
/// <summary> /// 根据试题Id获取其试题信息(不包含任何小题、选项) /// </summary> /// <param name="qId"></param> /// <returns></returns> public static dto_Question GetQuestion(int courseId, int qId) { dto_Question model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString), "select id, courseid, ptypeid, typeid, typename, difftype, diff, haschildren, quesbody, quesanswer, quesparse, pid, usagetimes from T_Questions where courseid = @courseid and id = @id", "@courseid".ToInt32InPara(courseId), "@id".ToInt32InPara(qId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_Question>(dr); } } return(model); }
/// <summary> /// 根据试题Id获取其选项信息 /// </summary> /// <param name="qId"></param> /// <returns></returns> public static T_QuesOptions GetQuesOption(int qId) { T_QuesOptions model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString), "select id, optiona, optionb, optionc, optiond, optione, optionf, optiong from T_QuesOptions where id = @id", "@id".ToInt32InPara(qId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_QuesOptions>(dr); } } return(model); }
/// <summary> /// 搜索用户,只返回前10个 /// </summary> /// <param name="keyWords"></param> /// <returns></returns> public static List <T_User> SearchUser(string keyWords, int exceptUserId) { List <T_User> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString), "select Id, UserName, TrueName, Psd, Mobile, FirstLoginDate, CreateDate, ZyPsd, ZyPrice, ProvinceId, CityId, DistrictId, SchoolId, GradeId, ClassId from T_User where concat(UserName, TrueName) like '%" + keyWords + "%' and Id <> @ExceptUserId limit 20", "@ExceptUserId".ToInt32InPara(exceptUserId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_User>(dr); } } return(model); }
public static List <T_KnowledgePoints> GetKnowledgePoints(int courseId) { List <T_KnowledgePoints> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString), "select Id, CourseId, Name, Ordinal, ParentId, Type from T_KnowledgePoints a where a.CourseId = @CourseId order by ParentId, Ordinal", "@CourseId".ToInt32InPara(courseId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_KnowledgePoints>(dr); } } return(model); }
public static List <T_CatalogNodes> GetCatalogNodes(int textbookId) { List <T_CatalogNodes> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString), "select Id, Name, Ordinal, ParentId, TextBookId, Type from T_CatalogNodes a where a.TextBookId = @TextBookId order by ParentId, Ordinal", "@TextBookId".ToInt32InPara(textbookId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_CatalogNodes>(dr); } } return(model); }
/// <summary> /// 获取作业结构 /// </summary> /// <param name="zyId"></param> /// <returns></returns> public static List <T_ZyStruct> GetZyStruct(int zyId) { List <T_ZyStruct> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString), "select Id, ZyId, BqNum, SqNum, QuesType, QuesAnswer, CreateDate from T_ZyStruct where ZyId = @ZyId", "@ZyId".ToInt32InPara(zyId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_ZyStruct>(dr); } } return(model); }
public static T_UserExtend GetUserExtend(int userId) { T_UserExtend model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString), "select UserId, Locked from T_UserExtend where UserId = @UserId", "@UserId".ToInt32InPara(userId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_UserExtend>(dr); } } return(model); }
public static dto_ModifyRequest GetModifyRequest(int userId) { dto_ModifyRequest model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString), "select Id, UserId, FromSchoolId, ToSchoolId, Reason, Status, CreateDate from T_ModifyRequest where UserId = @UserId and Status = 0 limit 1", "@UserId".ToInt32InPara(userId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <dto_ModifyRequest>(dr); } } return(model); }
public static T_User GetUser(int Id) { T_User model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString), "select Id, UserName, TrueName, Psd, Mobile, FirstLoginDate, CreateDate, ZyPsd, ZyPrice, ProvinceId, CityId, DistrictId, SchoolId, GradeId, ClassId from T_User where Id = @Id", "@Id".ToInt32InPara(Id))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_User>(dr); } } return(model); }
/// <summary> /// 根据大题Id一次获取所有小题的选项 /// </summary> /// <param name="pId"></param> /// <returns></returns> public static List <T_QuesOptions> GetAllChildQuesOptions(int pId) { List <T_QuesOptions> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(QuesConnString), "select id, optiona, optionb, optionc, optiond, optione, optionf, optiong, pid from T_QuesOptions where pid = @pid", "@pid".ToInt32InPara(pId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_QuesOptions>(dr); } } return(model); }
public static List <dto_Answer> GetAnswers(int zyId) { List <dto_Answer> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString), "select Id, ZyId, ZyType, StudentId, AnswerJson, AnswerImg, Submited, CreateDate from T_Answer where ZyId = @ZyId and Submited = 1", "@ZyId".ToInt32InPara(zyId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <dto_Answer>(dr); } } return(model); }
/// <summary> /// 查询作业 /// </summary> /// <param name="id"></param> /// <returns></returns> public static T_Zy GetZy(int id) { T_Zy model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(ZyConnString), "select Id, UserId, ZyName, CourseId, SubjectId, CreateDate, Ip, IMEI, MobileBrand, SystemType, Browser, OpenDate, DueDate, Type, Status from T_Zy where Id = @Id", "@Id".ToInt32InPara(id))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_Zy>(dr); } } return(model); }
/// <summary> /// 获取被关注用户列表 /// </summary> /// <param name="userId"></param> /// <returns></returns> public static List <dto_RelateUser> GetBeRelatedUser(int userId) { List <dto_RelateUser> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(UserConnString), "select Id, UserId, RUserId, CreateDate from T_UserRelate where RUserId = @RUserId", "@RUserId".ToInt32InPara(userId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <dto_RelateUser>(dr); } } return(model); }
public static T_School GetSchool(int schoolId) { T_School model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BaseConnString), "select SchoolId, SchoolName from T_School where SchoolId = @SchoolId", "@SchoolId".ToInt32InPara(schoolId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntitySingle <T_School>(dr); } } return(model); }
public static List <T_School> GetSchools(int districtId) { List <T_School> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BaseConnString), "select SchoolId, SchoolName from T_School where DistrictId = @DistrictId", "@DistrictId".ToInt32InPara(districtId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_School>(dr); } } return(model); }
public static List <T_District> GetDistricts(int cityId) { List <T_District> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BaseConnString), "select DistrictId, DistrictName from T_District where CityId = @CityId", "@CityId".ToInt32InPara(cityId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_District>(dr); } } return(model); }
public static List <T_City> GetCities(int provinceId) { List <T_City> model = null; using (MySqlDataReader dr = MySqlHelper.ExecuteReader(Util.GetConnectString(BaseConnString), "select CityId, CityName from T_City where ProvinceId = @ProvinceId", "@ProvinceId".ToInt32InPara(provinceId))) { if (dr != null && dr.HasRows) { model = MySqlDBHelper.ConvertDataReaderToEntityList <T_City>(dr); } } return(model); }
private void btnSave_Click(object sender, EventArgs e) { DateTime st = DateTime.Now; //DBHelper dh = new DBHelper(tbConnStr.Text); MySqlDBHelper dh = new MySqlDBHelper(SensitiveData.ConnectionString); DBCommandResult r = dh.AddUniverse(u); if (r.ResultCode < 0) { MessageBox.Show(r.ResultMsg, String.Format("Universe not saved - Code:{0}", r.ResultCode)); return; } else { Universe ru = (Universe)r.Tag; foreach (Galaxy g in u.Galaxies) { g.UniverseId = ru._id; r = dh.AddGalaxy(g); if (r.ResultCode < 0) { MessageBox.Show(r.ResultMsg, String.Format("Galaxy not saved - Code:{0}", r.ResultCode)); return; } else { Galaxy rg = (Galaxy)r.Tag; foreach (Star s in g.Stars) { s.GalaxyId = rg._id; r = dh.AddStar(s); if (r.ResultCode < 0) { MessageBox.Show(r.ResultMsg, String.Format("Star not saved - Code:{0}", r.ResultCode)); return; } else { Star rs = (Star)r.Tag; foreach (StarOrbitalBody sob in s.OrbitalBodies) { sob.StarId = rs._id; r = dh.AddOrbitalBody(sob); if (r.ResultCode < 0) { MessageBox.Show(r.ResultMsg, String.Format("Orbital Body not saved - Code:{0}", r.ResultCode)); return; } else { StarOrbitalBody rsob = (StarOrbitalBody)r.Tag; rs.OrbitalBodies.Add(rsob); } } rg.Stars.Add(rs); } } ru.Galaxies.Add(rg); } } u = ru; } MessageBox.Show((DateTime.Now - st).TotalMilliseconds.ToString(), "Data saved successfully"); ShowStats(); }