예제 #1
0
 public ReturnClass.ReturnDataTable delete_action(bl_Action bl)
 {
     string str = "delete FROM ddl_list where DDL_List_ID=@DDL_List_ID";
     MySqlParameter[] pm = new MySqlParameter[]{
          new MySqlParameter("DDL_List_ID",bl.DDL_List_ID)
     };
     rd = db.executeSelectQuery(str,pm);
     return rd;
 }
예제 #2
0
    public ReturnClass.ReturnDataTable select_admin_info(bl_Action bl)
    {
        string str = @"select lo.UserID, emp.Name_en, emp.state_id,emp.base_department_id, emp.NewOfficeCode, 
                    emp.district_id,lo.RollID from login lo
                    inner join employee_table emp on emp.emp_id=lo.LoginID
                    where lo.UserID=@user";
        MySqlParameter[] pm = new MySqlParameter[]{
            new MySqlParameter("user",bl.Userid)
        };
        rd = db.executeSelectQuery(str, pm);
        return rd;

    }
예제 #3
0
 public ReturnClass.ReturnBool insertAction(bl_Action bl)
 {
     string str = "insert into ddl_list(DDL_List_ID,DDL_Name_Value,DisplayName_en,Remarks,DisplayOrder,Category) values(@Ddl_id,@DDL_Name_Value,@ActionName,@Remarks,@DisplayOrder,@Category)";
     MySqlParameter[] pm = new MySqlParameter[]{
          new MySqlParameter("Ddl_id",bl.Ddl_id),
         new MySqlParameter("DDL_Name_Value",bl.DDL_Name_Value),
         new MySqlParameter("ActionName",bl.Actionname),
         new MySqlParameter("Remarks",bl.Remark),
         new MySqlParameter("DisplayOrder",bl.DisplayOrder),
         new MySqlParameter("Category",bl.Category)
        
     };
     rb = db.executeInsertQuery(str, pm);
     return rb;
 }