/// <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();
}
