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