public int DataUpdate(PhraseModifyReq req)
{
int count = 0;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
string sql = @"
UPDATE PHRASE
SET PHRASE_GROUP=@PHRASE_GROUP,PHRASE_KEY=@PHRASE_KEY,PHRASE_VALUE=@PHRASE_VALUE,PHRASE_DESC=@PHRASE_DESC,SORT=@SORT,MODE=@MODE,MDATE=GETDATE(),MUSER=@MUSER
WHERE SN=@SN;
";
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
Db.AddInParameter(cmd, "SN", DbType.String, req.PHRASE.SN);
Db.AddInParameter(cmd, "PHRASE_GROUP", DbType.String, req.PHRASE.PHRASE_GROUP);
Db.AddInParameter(cmd, "PHRASE_KEY", DbType.String, req.PHRASE.PHRASE_KEY);
Db.AddInParameter(cmd, "PHRASE_VALUE", DbType.String, req.PHRASE.PHRASE_VALUE);
Db.AddInParameter(cmd, "PHRASE_DESC", DbType.String, req.PHRASE.PHRASE_DESC);
Db.AddInParameter(cmd, "SORT", DbType.String, req.PHRASE.SORT);
Db.AddInParameter(cmd, "MODE", DbType.String, req.PHRASE.MODE);
Db.AddInParameter(cmd, "MUSER", DbType.String, req.PHRASE.MUSER);
count = Db.ExecuteNonQuery(cmd);
}
return(count);
}
public int DataCreate(PhraseModifyReq req)
{
int count = 0;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
Int64?PHRASE_SN = new Sequence("SCC").GetSeqBigInt("PHRASE");
string sql = @"
INSERT PHRASE (SN,PHRASE_GROUP,PHRASE_KEY,PHRASE_VALUE,PHRASE_DESC,SORT,MODE,CDATE,CUSER,MDATE,MUSER)
VALUES (@SN,@PHRASE_GROUP,@PHRASE_KEY,@PHRASE_VALUE,@PHRASE_DESC,@SORT,@MODE,GETDATE(),@CUSER,GETDATE(),@MUSER);
";
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
Db.AddInParameter(cmd, "SN", DbType.Int32, PHRASE_SN);
Db.AddInParameter(cmd, "PHRASE_GROUP", DbType.String, req.PHRASE.PHRASE_GROUP);
Db.AddInParameter(cmd, "PHRASE_KEY", DbType.String, req.PHRASE.PHRASE_KEY);
Db.AddInParameter(cmd, "PHRASE_VALUE", DbType.String, req.PHRASE.PHRASE_VALUE);
Db.AddInParameter(cmd, "PHRASE_DESC", DbType.String, req.PHRASE.PHRASE_DESC);
Db.AddInParameter(cmd, "SORT", DbType.String, req.PHRASE.SORT);
Db.AddInParameter(cmd, "MODE", DbType.String, req.PHRASE.MODE);
Db.AddInParameter(cmd, "CUSER", DbType.String, req.PHRASE.CUSER);
Db.AddInParameter(cmd, "MUSER", DbType.String, req.PHRASE.MUSER);
count = Db.ExecuteNonQuery(cmd);
req.PHRASE.SN = (int?)PHRASE_SN;
}
return(count);
}
public string PhraseQuery(PhraseModifyReq req)
{
PhraseModifyRes res = new PhraseModifyRes();
if (Session["ID"] == null)
{
res.ReturnStatus = new ReturnStatus(ReturnCode.SESSION_TIMEOUT);
}
else
{
try
{
Log("Req=" + JsonConvert.SerializeObject(req));
res = new PhraseModifyRes
{
PHRASE = new KYL_CMS.Models.BusinessLogic.Phrase("SCC").ModificationQuery(req.PHRASE.SN),
ReturnStatus = new ReturnStatus(ReturnCode.SUCCESS)
};
}
catch (Exception ex)
{
Log("Err=" + ex.Message);
Log(ex.StackTrace);
res.ReturnStatus = new ReturnStatus(ReturnCode.SERIOUS_ERROR);
}
}
var json = JsonConvert.SerializeObject(res);
Log("Res=" + json);
return(json);
}
public string PhraseUpdate(PhraseModifyReq req)
{
PhraseModifyRes res = new PhraseModifyRes();
if (Session["ID"] == null)
{
res.ReturnStatus = new ReturnStatus(ReturnCode.SESSION_TIMEOUT);
}
else
{
try
{
Log("Req=" + JsonConvert.SerializeObject(req));
req.PHRASE.MUSER = Session["ID"].ToString();
PhraseModifyReq oldData = new PhraseModifyReq();
oldData.PHRASE = new Phrase("SCC").ModificationQuery(req.PHRASE.SN);
if (oldData.PHRASE.PHRASE_KEY != req.PHRASE.PHRASE_KEY && new Interview("KYL").CheckPharseUsed(oldData))
{
res = new PhraseModifyRes
{
ReturnStatus = new ReturnStatus(ReturnCode.ITEM_USED)
};
}
else
{
int i = new Phrase("SCC").DataUpdate(req);
res = new PhraseModifyRes
{
PHRASE = req.PHRASE,
ReturnStatus = new ReturnStatus(ReturnCode.EDIT_SUCCESS)
};
}
}
catch (Exception ex)
{
Log("Err=" + ex.Message);
Log(ex.StackTrace);
res.ReturnStatus = new ReturnStatus(ReturnCode.SERIOUS_ERROR);
}
}
var json = JsonConvert.SerializeObject(res);
Log("Res=" + json);
return(json);
}
public int DataDelete(PhraseModifyReq req)
{
int count = 0;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
string sql = @"
DELETE FROM PHRASE
WHERE SN=@SN;
";
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
Db.AddInParameter(cmd, "SN", DbType.String, req.PHRASE.SN);
count = Db.ExecuteNonQuery(cmd);
}
return(count);
}
public string PhraseCreate()
{
Stream stream = Request.InputStream;
stream.Seek(0, SeekOrigin.Begin);
string input = new StreamReader(stream).ReadToEnd();
Log(input);
PhraseModifyReq req = new PhraseModifyReq();
JsonConvert.PopulateObject(input, req);
PhraseModifyRes res = new PhraseModifyRes();
if (Session["ID"] == null)
{
res.ReturnStatus = new ReturnStatus(ReturnCode.SESSION_TIMEOUT);
}
else
{
try
{
Log("Req=" + JsonConvert.SerializeObject(req));
req.PHRASE.CUSER = Session["ID"].ToString();
req.PHRASE.MUSER = Session["ID"].ToString();
int i = new KYL_CMS.Models.BusinessLogic.Phrase("SCC").DataCreate(req);
res = new PhraseModifyRes
{
PHRASE = req.PHRASE,
ReturnStatus = new ReturnStatus(ReturnCode.ADD_SUCCESS)
};
}
catch (Exception ex)
{
Log("Err=" + ex.Message);
Log(ex.StackTrace);
res.ReturnStatus = new ReturnStatus(ReturnCode.SERIOUS_ERROR);
}
}
var json = JsonConvert.SerializeObject(res);
Log("Res=" + json);
return(json);
}
