/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_PAPERDETAIL model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into OT_PAPERDETAIL("); strSql.Append("PD_ID,PD_SID,PD_QID,PD_NUM,PD_POINT)"); strSql.Append(" values ("); strSql.Append("@PD_ID,@PD_SID,@PD_QID,@PD_NUM,@PD_POINT)"); SqlParameter[] parameters = { new SqlParameter("@PD_ID", SqlDbType.VarChar,64), new SqlParameter("@PD_SID", SqlDbType.VarChar,64), new SqlParameter("@PD_QID", SqlDbType.VarChar,64), new SqlParameter("@PD_NUM", SqlDbType.Int,4), new SqlParameter("@PD_POINT", SqlDbType.Decimal,9)}; parameters[0].Value = model.PD_ID; parameters[1].Value = model.PD_SID; parameters[2].Value = model.PD_QID; parameters[3].Value = model.PD_NUM; parameters[4].Value = model.PD_POINT; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_SESSION model) { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into OT_SESSION("); strSql.Append("SE_ID,SE_TID,SE_CTIME,SE_NAME,SE_CONTENT,SE_TTIME,SE_DTIME,SE_DELFLAG)"); strSql.Append(" values ("); strSql.Append("@SE_ID,@SE_TID,@SE_CTIME,@SE_NAME,@SE_CONTENT,@SE_TTIME,@SE_DTIME,@SE_DELFLAG)"); SqlParameter[] parameters = { new SqlParameter("@SE_ID", SqlDbType.VarChar,64), new SqlParameter("@SE_TID", SqlDbType.VarChar,50), new SqlParameter("@SE_CTIME", SqlDbType.DateTime), new SqlParameter("@SE_NAME", SqlDbType.NVarChar,500), new SqlParameter("@SE_CONTENT", SqlDbType.Text), new SqlParameter("@SE_TTIME", SqlDbType.DateTime), new SqlParameter("@SE_DTIME", SqlDbType.VarChar,50), new SqlParameter("@SE_DELFLAG", SqlDbType.Int,4)}; parameters[0].Value = model.SE_ID; parameters[1].Value = model.SE_TID; parameters[2].Value = model.SE_CTIME; parameters[3].Value = model.SE_NAME; parameters[4].Value = model.SE_CONTENT; parameters[5].Value = model.SE_TTIME; parameters[6].Value = model.SE_DTIME; parameters[7].Value = model.SE_DELFLAG; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
private static void Write(string gameFile, string textsFile, string outputFile) { Initialize(); switch (Path.GetExtension(gameFile)) { case ".udlg": { Dictionary <string, string> texts = ReadTexts(textsFile); aqq model = Dialogs.SetSubtitles(gameFile, texts); FileManager.Save(model, outputFile, false); break; } case ".k": { Dictionary <string, string> texts = ReadTexts(textsFile); aj8 model = Knowledge.SetSubtitles(gameFile, texts); FileManager.Save(model, outputFile, true); break; } case ".item": { Dictionary <string, string> texts = ReadTexts(textsFile); bqj model = Items.SetSubtitles(gameFile, texts); FileManager.Save(model, outputFile, true); break; } case ".uz": { Dictionary <string, string> texts = ReadTexts(textsFile); cfs model = Zone.SetSubtitles(gameFile, texts); FileManager.Save(model, outputFile, true); break; } case ".uzl": { Dictionary <string, string> texts = ReadTexts(textsFile); cy3 model = ZoneLayer.SetSubtitles(gameFile, texts); FileManager.Save(model, outputFile, true); break; } } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_ESSAY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into OT_ESSAY("); strSql.Append("ES_ID,ES_TYPE,ES_TITLE,ES_CONTENT,ES_ANSWER,ES_HARD,ES_DELFLAG,ES_CTIME,ES_TID)"); strSql.Append(" values ("); strSql.Append("@ES_ID,@ES_TYPE,@ES_TITLE,@ES_CONTENT,@ES_ANSWER,@ES_HARD,@ES_DELFLAG,@ES_CTIME,@ES_TID)"); SqlParameter[] parameters = { new SqlParameter("@ES_ID", SqlDbType.VarChar,64), new SqlParameter("@ES_TYPE", SqlDbType.VarChar,50), new SqlParameter("@ES_TITLE", SqlDbType.Text), new SqlParameter("@ES_CONTENT", SqlDbType.Text), new SqlParameter("@ES_ANSWER", SqlDbType.Text), new SqlParameter("@ES_HARD", SqlDbType.Int,4), new SqlParameter("@ES_DELFLAG", SqlDbType.Int,4), new SqlParameter("@ES_CTIME", SqlDbType.DateTime), new SqlParameter("@ES_TID", SqlDbType.VarChar,50)}; parameters[0].Value = model.ES_ID; parameters[1].Value = model.ES_TYPE; parameters[2].Value = model.ES_TITLE; parameters[3].Value = model.ES_CONTENT; parameters[4].Value = model.ES_ANSWER; parameters[5].Value = model.ES_HARD; parameters[6].Value = model.ES_DELFLAG; parameters[7].Value = model.ES_CTIME; parameters[8].Value = model.ES_TID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_PAPERDETAIL model) { StringBuilder strSql=new StringBuilder(); strSql.Append("update OT_PAPERDETAIL set "); strSql.Append("PD_SID=@PD_SID,"); strSql.Append("PD_QID=@PD_QID,"); strSql.Append("PD_NUM=@PD_NUM,"); strSql.Append("PD_POINT=@PD_POINT"); strSql.Append(" where PD_ID=@PD_ID "); SqlParameter[] parameters = { new SqlParameter("@PD_SID", SqlDbType.VarChar,64), new SqlParameter("@PD_QID", SqlDbType.VarChar,64), new SqlParameter("@PD_NUM", SqlDbType.Int,4), new SqlParameter("@PD_POINT", SqlDbType.Decimal,9), new SqlParameter("@PD_ID", SqlDbType.VarChar,64)}; parameters[0].Value = model.PD_SID; parameters[1].Value = model.PD_QID; parameters[2].Value = model.PD_NUM; parameters[3].Value = model.PD_POINT; parameters[4].Value = model.PD_ID; int rows=DbHelperSQL.ExecuteSql(strSql.ToString(),parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_PAPERDETAIL model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_PAPERDETAIL model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_ESSAY model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_ESSAY model) { return dal.Update(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_QUESTION model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_QUESTION model) { return dal.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_ESSAY model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update OT_ESSAY set "); strSql.Append("ES_TYPE=@ES_TYPE,"); strSql.Append("ES_TITLE=@ES_TITLE,"); strSql.Append("ES_CONTENT=@ES_CONTENT,"); strSql.Append("ES_ANSWER=@ES_ANSWER,"); strSql.Append("ES_HARD=@ES_HARD,"); strSql.Append("ES_DELFLAG=@ES_DELFLAG,"); strSql.Append("ES_CTIME=@ES_CTIME,"); strSql.Append("ES_TID=@ES_TID"); strSql.Append(" where ES_ID=@ES_ID "); SqlParameter[] parameters = { new SqlParameter("@ES_TYPE", SqlDbType.VarChar,50), new SqlParameter("@ES_TITLE", SqlDbType.Text), new SqlParameter("@ES_CONTENT", SqlDbType.Text), new SqlParameter("@ES_ANSWER", SqlDbType.Text), new SqlParameter("@ES_HARD", SqlDbType.Int,4), new SqlParameter("@ES_DELFLAG", SqlDbType.Int,4), new SqlParameter("@ES_CTIME", SqlDbType.DateTime), new SqlParameter("@ES_TID", SqlDbType.VarChar,50), new SqlParameter("@ES_ID", SqlDbType.VarChar,64)}; parameters[0].Value = model.ES_TYPE; parameters[1].Value = model.ES_TITLE; parameters[2].Value = model.ES_CONTENT; parameters[3].Value = model.ES_ANSWER; parameters[4].Value = model.ES_HARD; parameters[5].Value = model.ES_DELFLAG; parameters[6].Value = model.ES_CTIME; parameters[7].Value = model.ES_TID; parameters[8].Value = model.ES_ID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return true; } else { return false; } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(cfs.Model.OT_SESSION model) { return dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(cfs.Model.OT_SESSION model) { return dal.Update(model); }