public int DataCreate(RolesModifyReq req)
{
int count = 0;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
string sql = @"
INSERT ROLES (NAME,MODE,CDATE,CUSER,MDATE,MUSER)
VALUES (@NAME,@MODE,GETDATE(),@CUSER,GETDATE(),@MUSER) SET @SN = SCOPE_IDENTITY();
";
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
Db.AddInParameter(cmd, "NAME", DbType.String, req.ROLES.NAME);
Db.AddInParameter(cmd, "MODE", DbType.String, req.ROLES.MODE);
Db.AddInParameter(cmd, "CDATE", DbType.String, req.ROLES.CDATE);
Db.AddInParameter(cmd, "CUSER", DbType.String, req.ROLES.CUSER);
Db.AddInParameter(cmd, "MDATE", DbType.String, req.ROLES.MDATE);
Db.AddInParameter(cmd, "MUSER", DbType.String, req.ROLES.MUSER);
Db.AddOutParameter(cmd, "SN", DbType.Int32, 1);
count = Db.ExecuteNonQuery(cmd);
req.ROLES.SN = Db.GetParameterValue(cmd, "SN") as Int32? ?? null;
}
return(count);
}
public string RolesUpdate(RolesModifyReq req)
{
RolesModifyRes res = new RolesModifyRes();
if (Session["ID"] == null)
{
res.ReturnStatus = new ReturnStatus(ReturnCode.SESSION_TIMEOUT);
}
else
{
try
{
Log("Req=" + JsonConvert.SerializeObject(req));
req.ROLES.MUSER = Session["ID"].ToString();
int i = new Roles("SCC").DataUpdate(req);
res = new RolesModifyRes
{
ROLES = new Roles("SCC").ModificationQuery(req.ROLES.SN),
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(RolesModifyReq req)
{
int count = 0;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
string sql = @"
DELETE FROM ROLES
WHERE SN=@SN;
";
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
Db.AddInParameter(cmd, "SN", DbType.String, req.ROLES.SN);
count = Db.ExecuteNonQuery(cmd);
}
return(count);
}
public string RolesCreate()
{
Stream stream = Request.InputStream;
stream.Seek(0, SeekOrigin.Begin);
string input = new StreamReader(stream).ReadToEnd();
Log(input);
RolesModifyReq req = new RolesModifyReq();
JsonConvert.PopulateObject(input, req);
RolesModifyRes res = new RolesModifyRes();
if (Session["ID"] == null)
{
res.ReturnStatus = new ReturnStatus(ReturnCode.SESSION_TIMEOUT);
}
else
{
try
{
Log("Req=" + JsonConvert.SerializeObject(req));
req.ROLES.CUSER = Session["ID"].ToString();
req.ROLES.MUSER = Session["ID"].ToString();
int i = new Roles("SCC").DataCreate(req);
res = new RolesModifyRes
{
ROLES = new Roles("SCC").ModificationQuery(req.ROLES.SN),
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);
}
public int DataUpdate(RolesModifyReq req)
{
int count = 0;
using (DbCommand cmd = Db.CreateConnection().CreateCommand())
{
string sql = @"
UPDATE ROLES
SET NAME=@NAME,MODE=@MODE,MDATE=GETDATE(),MUSER=@MUSER
WHERE SN=@SN;
";
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
Db.AddInParameter(cmd, "SN", DbType.String, req.ROLES.SN);
Db.AddInParameter(cmd, "NAME", DbType.String, req.ROLES.NAME);
Db.AddInParameter(cmd, "MODE", DbType.String, req.ROLES.MODE);
Db.AddInParameter(cmd, "MUSER", DbType.String, req.ROLES.MUSER);
count = Db.ExecuteNonQuery(cmd);
}
return(count);
}
