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