private MENURes insert(MENUREq dataReq, string conStr = null)
{
var res = new MENURes();
try
{
var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU()
{
MENUCODE = dataReq.MENUCODE
}, null, conStr);
if (lst == null || (lst != null && lst.Count == 0))
{
var req = new STMENU()
{
MENUCODE = dataReq.MENUCODE,
MENUNAME = dataReq.MENUNAME,
INPID = dataReq.INPID,
};
var state = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Insert(req, null, conStr);
res._result._code = "200";
res._result._message = "บันทึกข้อมูลเรียบร้อยแล้ว";
res._result._status = "OK";
}
else
{
var obj = lst.FirstOrDefault();
if (obj.FLAG.Equals("2"))
{
throw new Exception("รหัสหน้าจอนี้มีอยู่แล้ว แต่ถูกปิดการใช้งาน");
}
else
{
throw new Exception("รหัสหน้าจอซ้ำ");
}
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var newList = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU()
{
MENUCODE = null
}, null, conStr);
res.MENULST = newList;
}
return(res);
}
public int Delete(STMENU d, SqlTransaction transac = null, string conStr = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@MENUCODE", d.MENUCODE);
string cmd = "Delete from STMENU " +
"Where MENUCODE = @MENUCODE ;";
var res = ExecuteNonQuery(transac, cmd, param, conStr);
return(res);
}
private MENURes active(MENUREq dataReq, int flag, string conStr = null)
{
var res = new MENURes();
try
{
var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU()
{
MENUCODE = dataReq.MENUCODE
}, null, conStr);
if (lst != null && lst.Count > 0)
{
var obj = lst.FirstOrDefault();
var req = new STMENU()
{
MENUCODE = obj.MENUCODE,
MENUNAME = obj.MENUNAME,
FLAG = flag.ToString(),
INPID = dataReq.INPID,
};
var state = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Update(req, null, conStr);
res._result._code = "200";
res._result._message = "บันทึกข้อมูลเรียบร้อยแล้ว";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Not Found";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var newList = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU()
{
MENUCODE = dataReq.MENUCODE
}, null, conStr);
res.MENULST = newList;
}
return(res);
}
public int Update(STMENU d, SqlTransaction transac = null, string conStr = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@MENUCODE", d.MENUCODE);
param.Add("@MENUNAME", d.MENUNAME);
param.Add("@FLAG", d.FLAG);
param.Add("@INPID", d.INPID);
string cmd = "Update STMENU set MENUNAME = @MENUNAME , FLAG = @FLAG, INPID = @INPID, INPDT = GETDATE() " +
"Where MENUCODE = @MENUCODE ;";
var res = ExecuteNonQuery(transac, cmd, param, conStr);
return(res);
}
public int Insert(STMENU d, SqlTransaction transac = null, string conStr = null)
{
DynamicParameters param = new DynamicParameters();
param.Add("@MENUCODE", d.MENUCODE);
param.Add("@MENUNAME", d.MENUNAME);
param.Add("@FLAG", "1");
param.Add("@INPID", d.INPID);
string cmd = "INSERT INTO STMENU (MENUCODE, MENUNAME, FLAG, INPID, INPDT) " +
"VALUES (@MENUCODE, @MENUNAME, @FLAG, @INPID, GETDATE());";
var res = ExecuteNonQuery(transac, cmd, param, conStr);
return(res);
}
private MENURes delete(MENUREq dataReq, string conStr = null)
{
var res = new MENURes();
try
{
var lst = ASSETKKF_ADO.Mssql.Asset.STPERMISSIONSAdo.GetInstant().Get(new STPERMISSIONS()
{
MENUCODE = dataReq.MENUCODE
}, null, conStr);
if (lst == null || (lst != null && lst.Count == 0))
{
var req = new STMENU()
{
MENUCODE = dataReq.MENUCODE,
MENUNAME = dataReq.MENUNAME,
FLAG = dataReq.FLAG,
INPID = dataReq.INPID,
};
var state = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Delete(req, null, conStr);
res._result._code = "200";
res._result._message = "ลบข้อมูลเรียบร้อยแล้ว";
res._result._status = "OK";
}
else
{
throw new Exception("ไม่สามารถลบข้อมูลได้ เนื่องจากหน้าจอนี้ถูกกำหนดสิทธิ์การใช้งานแล้ว");
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
finally
{
var newList = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().Search(new STMENU()
{
MENUCODE = dataReq.MENUCODE
}, null, conStr);
res.MENULST = newList;
}
return(res);
}
private MENURes getMenu(MENUREq dataReq, string conStr = null)
{
var res = new MENURes();
try
{
var req = new STMENU()
{
MENUCODE = dataReq.MENUCODE,
MENUNAME = dataReq.MENUNAME,
FLAG = dataReq.FLAG,
INPID = dataReq.INPID,
};
var lst = ASSETKKF_ADO.Mssql.Asset.STMENUAdo.GetInstant().ListActive(new STMENU()
{
MENUCODE = dataReq.MENUCODE
}, null, conStr);
res.MENULST = lst;
if (lst != null && lst.Count > 0)
{
res._result._code = "200";
res._result._message = "";
res._result._status = "OK";
}
else
{
res._result._code = "404";
res._result._message = "ไม่พบข้อมูล";
res._result._status = "Not Found";
}
}
catch (Exception ex)
{
res._result._code = "500 ";
res._result._message = ex.Message;
res._result._status = "Internal Server Error";
}
return(res);
}
public List <STMENU> ListActive(STMENU d, SqlTransaction transac = null, string conStr = null)
{
DynamicParameters param = new DynamicParameters();
sql = "Select * from STMENU Where FLAG = '1' ";
if (!String.IsNullOrEmpty(d.MENUCODE))
{
sql += " and MENUCODE = @MENUCODE ";
param.Add("@MENUCODE", d.MENUCODE);
}
if (!String.IsNullOrEmpty(d.MENUNAME))
{
sql += " and MENUNAME = @MENUNAME ";
param.Add("@MENUNAME", d.MENUNAME);
}
var res = Query <STMENU>(sql, param, conStr).ToList();
return(res);
}
