public ChapterEntity Update(int id, ChapterEntity obj)
{
ChapterEntity chapter = new ChapterEntity();
try
{
MySqlCommand cmd = db.connection.CreateCommand();
cmd.CommandText = "UPDATE " + Constants.USER_TABLE_NAME + " SET '" + Constants.USER_COLUMN_NAME_FIRST_NAME + "' = " + obj.Name + ", '" + Constants.USER_COLUMN_NAME_LAST_NAME + "' " + obj.CourseId +
"WHERE " + Constants.USER_COLUMN_NAME_ID + " = " + obj.Id;
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
chapter.Id = reader.GetInt32(0);
chapter.CourseId = reader.GetInt32(2);
chapter.Name = reader.GetString(1);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
db.connection.Close();
}
return(chapter);
}
public int SaveChapter(ChapterEntity entity, string loginName)
{
if (string.IsNullOrEmpty(entity.ChapterId))
{
using (IDbConnection conn = DBContext.GetConnection(DataBaseName.AccountTrianDB, ReadOrWriteDB.Write))
{
string query = string.Format(@"INSERT INTO Train_Chapter
(ChapterId
,ClassId
,ChapterTitle
,ChapterContent
,VideoUrl
,VideoTitle
,ChapterNum
,Remark
,Status
,CreateTime
,CreateUser
,UpdateTime
,UpdateUser)
VALUES
('{0}'
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,'{5}'
,'{6}'
,'{7}'
,'{8}'
,getdate()
,'{9}'
,getdate()
,'{10}')",
Guid.NewGuid().ToString(), entity.ClassId, entity.ChapterTitle, entity.ChapterContent, entity.VideoUrl, entity.VideoTitle,
entity.ChapterNum, entity.Remark, 1, loginName, loginName);
return(conn.Execute(query));
}
}
else
{
using (IDbConnection conn = DBContext.GetConnection(DataBaseName.AccountTrianDB, ReadOrWriteDB.Write))
{
string query = string.Format(@" UPDATE Train_Chapter
SET ClassId='{0}'
,ChapterTitle='{1}'
,ChapterContent='{2}'
,VideoUrl='{3}'
,VideoTitle='{4}'
,ChapterNum='{5}'
,Remark='{6}'
,UpdateTime = getdate()
,UpdateUser = '******'
WHERE ChapterId='{8}'",
entity.ClassId, entity.ChapterTitle, entity.ChapterContent, entity.VideoUrl, entity.VideoTitle, entity.ChapterNum,
entity.Remark, loginName, entity.ChapterId);
return(conn.Execute(query));
}
}
}
public ChapterEntity FindById(int id)
{
ChapterEntity chapter = new ChapterEntity();
try
{
MySqlCommand cmd = db.connection.CreateCommand();
cmd.CommandText = "SELECT * FROM " + Constants.USER_TABLE_NAME + " WHERE " + Constants.USER_COLUMN_NAME_ID + " = " + id;
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
chapter.Id = reader.GetInt32(0);
chapter.CourseId = reader.GetInt32(2);
chapter.Name = reader.GetString(1);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
db.connection.Close();
}
return(chapter);
}
/// <summary>
/// 打开管卡地图
/// </summary>
private void OpenGameLevelMapView()
{
m_GameLevelMapView = UIViewUtil.Instance.OpenWindow(UIViewType.GameLevelMap).GetComponent <UIGameLevelMapView>();
m_GameLevelMapView.OnClickGameLevelItem = OnClickGameLevelMapViewViewDetailsItem;
DataTransfer data = new DataTransfer();
ChapterEntity entity = ChapterDBModel.Instance.Get(1);
data.SetData(ConstDefine.ChapterId, entity.Id);
data.SetData(ConstDefine.ChapterName, entity.ChapterName);
data.SetData(ConstDefine.ChapterBG, entity.BG_Pic);
List <GameLevelEntity> entityList = GameLevelDBModel.Instance.GetNeedEntityById(entity.Id);
if (entityList != null || entityList.Count > 0)
{
List <DataTransfer> dataArr = new List <DataTransfer>();
for (int i = 0; i < entityList.Count; i++)
{
DataTransfer dataChild = new DataTransfer();
dataArr.Add(dataChild);
dataArr[i].SetData(ConstDefine.GameLevelId, entityList[i].Id);
dataArr[i].SetData(ConstDefine.GameLevelIsBoss, entityList[i].isBoss);
dataArr[i].SetData(ConstDefine.GameLevelName, entityList[i].Name);
dataArr[i].SetData(ConstDefine.GameLevelPosInMap, entityList[i].GetPosInMap());
dataArr[i].SetData(ConstDefine.GameLevelIcon, entityList[i].Ico);
}
data.SetData(ConstDefine.GameLevelArr, dataArr);
}
m_GameLevelMapView.SetUI(data);
}
//Add
internal string AddSql(ChapterEntity data)
{
string colNames = "";
string colValue = "";
colNames += " Id ";
colValue += " " + this.GetNewId() + " ";
colNames += ",Name_Ar";
colValue += ",@Name_Ar";
colNames += ",Name_En";
colValue += ",@Name_En";
colNames += ",PartId";
colValue += "," + data.BookPartData.Id + "";
colNames += ",Cont";
colValue += ",@Cont";
colNames += ",RowId";
colValue += ",'" + data.RowId + "'";
colNames += ",DateMade";
colValue += ",'" + this.dbHelper.GetServerDate().ToDateVal().FormatDate("MM/dd/yyyy HH:mm") + "'";
colNames += ",MadeById";
colValue += "," + data.MadeById + "";
//-------------------------------
string sql = " INSERT INTO Chapters ( " + colNames + " ) VALUES ( " + colValue + " ) ";
return(sql);
}
public int Add(ChapterEntity data)
{
string sql = this.AddSql(data);
System.Data.SqlClient.SqlParameter NameArParam = new System.Data.SqlClient.SqlParameter();
NameArParam.ParameterName = "Name_Ar";
NameArParam.DbType = DbType.String;
NameArParam.Direction = ParameterDirection.Input;
NameArParam.Value = data.Name_Ar;
System.Data.SqlClient.SqlParameter NameEnParam = new System.Data.SqlClient.SqlParameter();
NameEnParam.ParameterName = "Name_En";
NameEnParam.DbType = DbType.String;
NameEnParam.Direction = ParameterDirection.Input;
NameEnParam.Value = data.Name_En;
System.Data.SqlClient.SqlParameter ContParam = new System.Data.SqlClient.SqlParameter();
ContParam.ParameterName = "Cont";
ContParam.DbType = DbType.String;
ContParam.Direction = ParameterDirection.Input;
ContParam.Value = data.Cont;
int x = this.dbHelper.whriteData(sql, new List <IDataParameter>()
{
ContParam, NameArParam, NameEnParam
});
return(x);
}
public List <ChapterEntity> GetList(int partId)
{
List <ChapterEntity> lst = null;
DataTable table;
string sql = this.GetSql();
sql += " WHERE PartId = " + partId + " ";
table = this.dbHelper.retriveData(sql);
if (table != null && table.Rows.Count > 0)
{
lst = new List <ChapterEntity>();
foreach (DataRow row in table.Rows)
{
ChapterEntity data = new ChapterEntity();
this.SetData(row, data);
lst.Add(data);
}
}
return(lst);
}
public async Task <ChapterDomain> CreateAsync(ChapterDomain chapterDomain)
{
ChapterEntity chapterEntity = Mapper.Map <ChapterEntity>(chapterDomain);
EntityEntry <ChapterEntity> entity = await DbSet.AddAsync(chapterEntity);
return(Mapper.Map <ChapterDomain>(entity.Entity));
}
public List <ChapterEntity> FindAllChapterByCourse(int CourseId)
{
List <ChapterEntity> chapterEntities = new List <ChapterEntity>();
try
{
MySqlCommand cmd = db.connection.CreateCommand();
cmd.CommandText = $"SELECT * FROM {Constants.CHAPTER_TABLE_NAME} WHERE {Constants.CHAPTER_COLUMN_NAME_COURSE_ID} = {CourseId}";
IDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ChapterEntity chapterEntity = new ChapterEntity();
chapterEntity.Id = reader.GetInt32(0);
chapterEntity.Name = reader.GetString(1);
chapterEntity.CourseId = reader.GetInt32(2);
chapterEntities.Add(chapterEntity);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
db.connection.Close();
}
return(chapterEntities);
}
public void OpenGameLevelMapView(Transform windowUiPanelContainerTrans)
{
//读取本地配置表
//默认读取第一章
ChapterEntity chapterEntity = ChapterDBModel.GetInstance.GetEntityById(1);
TransferData data = null;
if (chapterEntity != null)
{
data = new TransferData();
{
data.SetValue <string>("ChapterName", chapterEntity.ChapterName);
data.SetValue <int>("ChapterId", chapterEntity.Id);
data.SetValue <string>("ChapterMapBg", chapterEntity.BG_Pic);
}
}
//读取关卡
List <GameLevelEntity> gameLevelEntities = GameLevelDBModel.GetInstance.GetListByChapterId(chapterEntity.Id);
if (gameLevelEntities != null || gameLevelEntities.Count > 0)
{
data.SetValue <List <GameLevelEntity> >("GameLevelList", gameLevelEntities);
}
m_uIGameLevelMapView = WindowUIMgr.Instance.OpenWindow(WindowUIType.GameLevelMap).GetComponent <UIGameLevelMapView>();
m_uIGameLevelMapView.transform.SetParent(windowUiPanelContainerTrans);
m_uIGameLevelMapView.transform.localScale = Vector3.one * 0.8f;
m_uIGameLevelMapView.transform.localPosition = Vector3.zero;
m_uIGameLevelMapView.transform.localRotation = Quaternion.identity;
m_uIGameLevelMapView.SetUI(data, OnClickGameLevelCallback, windowUiPanelContainerTrans);
}
public static void InsertChapter(ChapterEntity chapter)
{
using (var db = new DataContext())
{
db.Chapter.Add(chapter);
db.SaveChanges();
}
}
private void OpenMainQuestView()
{
//加载panel部分
mUIPanelQuestView = UIViewManagerNGUI.Instance.OpenWindowUI(UIPanelType.MainQuest, true).GetComponent <UIPanelMainQuestView>();
mUIPanelQuestDetailView = mUIPanelQuestView.transform.GetComponentInChildren <UIPanelMainQuestDetailView>();
ReadExcelDataUtil excel = new ReadExcelDataUtil();
ChapterEntity chapterEntity = ChapterDBModel.Instance.Get(1);
excel.SetValue(Constant.EXCEL_ChapterId, chapterEntity.Id);
excel.SetValue(Constant.EXCEL_ChapterName, chapterEntity.ChapterName);
mUIPanelQuestView.SetUI(excel);
//读取item详情（本地excel）部分
//获取了GameQuest.xls里的全部内容，现在开始整理归类
List <GameQuestEntity> questEntityList = GameQuestDBModel.Instance.GetAllData();
#region 为item按章节分组的过程，并添加进dic中
if (dic.Count == 0)
{
int tempChapterCount = 1; //临时变量，用于分组使用
int tempIndex = 0;
for (int i = 0; i < questEntityList.Count; i++)
{
if (questEntityList[i].ChapterID != tempChapterCount) //章节发生了改变
{
List <GameQuestEntity> questEntityPage = new List <GameQuestEntity>();
tempIndex = i;
for (int j = 0; j < tempIndex; j++)
{
questEntityPage.Add(questEntityList[j]);
}
dic.Add(tempChapterCount, questEntityPage);//《页码，item详情》
tempChapterCount++;
}
}
List <GameQuestEntity> questEntityLastPage = new List <GameQuestEntity>(); //循环结束，把最后一篇的内容加到dic中
for (int j = tempIndex; j < questEntityList.Count; j++)
{
tempIndex = questEntityList.Count;
questEntityLastPage.Add(questEntityList[j]);
}
dic.Add(tempChapterCount, questEntityLastPage);//《页码，item详情》
}
#endregion
//先加载panel，完毕后再加载item
mUIPanelQuestView.OnViewLoadDone = () =>
{
//把做好的dic传给PanelView，view上可以直接使用
mUIPanelQuestView.SetInfosDic(dic);
//打开主线面板时，默认显示第一篇的关卡内容
mUIPanelQuestView.SetQuestItem(1);
};
mUIPanelQuestView.OnItemClick = OnQuestItemClick; //这一步是点击一个item后，panel要做的事
}
private void SetData(DataRow Row, ChapterEntity data)
{
data.Id = Row["Id"].ToString().ToIntVal();
data.Name_Ar = Row["Name_Ar"].ToString();
data.Name_En = Row["Name_En"].ToString();
data.BookPartData.Id = Row["PartId"].ToString().ToIntVal();
data.Cont = Row["Cont"].ToString();
data.RowId = Row["RowId"].ToString();
data.DateMade = Row["DateMade"].ToString().ToDateVal();
data.MadeById = Row["MadeById"].ToString().ToIntVal();
}
public ChapterEntity GetOpenBook()
{
var book = _bookReposistory.Where(c => c.BookOpened && c.Chapters.Where(ch => ch.ChapterOpened).Any()).AsQueryable().Include(b => b.Chapters).FirstOrDefault();
var content = book.Chapters.Where(c => c.ChapterOpened).FirstOrDefault();
var chapterEntity = new ChapterEntity
{
Content = content.Content,
BookName = book.BookTitle
};
return(chapterEntity);
}
private static ChapterEntity MySqlRead2Chapter(MySqlDataReader reader)
{
var chapter = new ChapterEntity
{
ChapterId = reader.GetString("ChapterId"),
ArticleId = reader.GetString("ArticleId"),
Content = reader.GetString("Content"),
Summary = reader.GetString("Summary"),
SerialNumber = reader.GetInt32("SerialNumber"),
Title = reader.GetString("Title"),
CreatTime = reader.GetDateTime("CreatTime")
};
return(chapter);
}
public ActionResult SaveChapter(ChapterEntity entity, string loginName)
{
try
{
var result = new ClassBC().SaveChapter(entity, CurrentUserInfo.Account);
if (result == 0)
{
return(Json(string.Empty));
}
return(Json("保存成功"));
}
catch (Exception ex)
{
return(Json(string.Empty));
}
}
public static int InsertChapter(ChapterEntity chapter)
{
if (chapter == null)
{
return(0);
}
//INSERT INTO Persons (LastName, Address) VALUES ('Wilson', 'Champs-Elysees')
var sql = $"INSERT INTO chapter (ChapterId,ArticleId,Content,Summary,SerialNumber,Title,CreatTime) " +
$"VALUES ('{chapter.ChapterId}','{chapter.ArticleId}','{chapter.Content}','{chapter.Summary}','{chapter.SerialNumber}','{chapter.Title}','{chapter.CreatTime}')";
using (var cmd = new MySqlCommand(sql, HyMySqlHelper.MySqlConnection))
{
var num = cmd.ExecuteNonQuery();
return(num);
}
}
//Update
public string UpdateSql(int id, ChapterEntity data)
{
string sql = "UPDATE Chapters SET ";
sql += " Name_Ar = @Name_Ar ";
sql += ",Name_En = @Name_En ";
sql += ",PartId = " + data.BookPartData.Id + " ";
sql += ",Cont = @Cont ";
//---------------
sql += ",DateMade = '" + this.dbHelper.GetServerDate().ToDateVal().FormatDate("MM/dd/yyyy HH:mm") + "'";
sql += ",MadeById = " + data.MadeById + "";
sql += " WHERE Id = " + id + " ";
return(sql);
}
public static int UpdateChapterByChapterId(ChapterEntity chapter)
{
int a = 0;
using (var db = new DataContext())
{
ChapterEntity chapterEntity = db.Chapter
.Where(b => b.ChapterId.Equals(chapter.ChapterId)).FirstOrDefault();
if (chapterEntity != null)
{
chapterEntity = chapter;
}
a = db.SaveChanges();
}
return(a);
}
// Update is called once per frame
void Update()
{
if (Input.GetKeyUp(KeyCode.B))
{
GameEntry.DataTable.LoadDataTable <ChapterDBModel>("Assets/DownLoad/DataTable/Chapter.bytes", 0, 132);
}
if (Input.GetKeyUp(KeyCode.C))
{
ChapterDBModel chapterDBModel = GameEntry.DataTable.GetDataTable <ChapterDBModel>();
ChapterEntity chapterEntity = chapterDBModel.Get(1);
Debug.Log(chapterEntity.ChapterName);
chapterEntity = chapterDBModel.Get(2);
Debug.Log(chapterEntity.ChapterName);
}
if (Input.GetKeyUp(KeyCode.D))
{
GameEntry.DataTable.DestroyDataTable <ChapterDBModel>();
}
}
public bool GetData()
{
bool x = false;
ChapterEntity data = delGetData(this.Id);
if (!data.IsNull_Ex())
{
x = true;
this.Id = data.Id;
this.DateMade = data.DateMade;
this.MadeById = data.MadeById;
this.Name_Ar = data.Name_Ar;
this.Name_En = data.Name_En;
this.BookPartData.Id = data.BookPartData.Id;
this.Cont = data.Cont;
this.RowId = data.RowId;
}
return(x);
}
public static int UpdateChapterByChapterId(string chapterId, string chapterTitle, string chapterContextHtml, string chapterSummary, int v)
{
int a = 0;
using (var db = new DataContext())
{
ChapterEntity chapterEntity = db.Chapter
.Where(b => b.ChapterId.Equals(chapterId)).FirstOrDefault();
if (chapterEntity != null)
{
chapterEntity.Title = chapterTitle;
chapterEntity.Content = chapterContextHtml;
chapterEntity.Summary = chapterSummary;
chapterEntity.SerialNumber = v;
}
a = db.SaveChanges();
}
return(a);
}
public ChapterEntity GetData(string rowId)
{
ChapterEntity data = null;
DataTable table;
string sql = this.GetSql();
sql += " WHERE RowId = '" + rowId + "' ";
table = this.dbHelper.retriveData(sql);
if (table != null && table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
data = new ChapterEntity();
this.SetData(row, data);
}
return(data);
}
public ChapterEntity Create(ChapterEntity obj)
{
try
{
MySqlCommand cmd = db.connection.CreateCommand();
cmd.CommandText = "INSERT INTO " + Constants.CHAPTER_TABLE_NAME + " (" + Constants.CHAPTER_COLUMN_NAME_NAME + ", " + Constants.CHAPTER_COLUMN_NAME_COURSE_ID + ") VALUES (@name, @user_id)";
cmd.Parameters.AddWithValue("@name", obj.Name);
cmd.Parameters.AddWithValue("@user_id", obj.CourseId);
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
finally
{
db.connection.Close();
}
return(obj);
}
public async Task <ChapterDomain> GetAsync(string category)
{
ChapterEntity chapter = await DbSet.SingleOrDefaultAsync(chapter => chapter.Category == category);
return(Mapper.Map <ChapterDomain>(chapter));
}
public int SaveChapter(ChapterEntity entity, string loginName)
{
ClassDA da = new ClassDA();
return(da.SaveChapter(entity, loginName));
}
