package models
    var Insert_sys_user = "insert into sys_user(`id`,`login_id`,`password`,`name`,`full_name`,`mobile`,`email`,`org_id`,`type`,`status`,`domain`,`option_a`,`option_b`,`create_by`,`create_time`,`last_update_by`,`last_update_date`,`del_flag`) values (?id,?login_id,?password,?name,?full_name,?mobile,?email,?org_id,?type,?status,?domain,?option_a,?option_b,?create_by,?create_time,?last_update_by,?last_update_date,?del_flag)"

    var Update_sys_user = "update sys_user set `login_id` = ?login_id,`password` = ?password,`name` = ?name,`full_name` = ?full_name,`mobile` = ?mobile,`email` = ?email,`org_id` = ?org_id,`type` = ?type,`status` = ?status,`domain` = ?domain,`option_a` = ?option_a,`option_b` = ?option_b,`create_by` = ?create_by,`create_time` = ?create_time,`last_update_by` = ?last_update_by,`last_update_date` = ?last_update_date,`del_flag` = ?del_flag where id = ?id"

    var Deleteone_sys_user = "delete from sys_userwhere id =?id"

    var Selectone_sys_user = "select `id`,`login_id`,`password`,`name`,`full_name`,`mobile`,`email`,`org_id`,`type`,`status`,`domain`,`option_a`,`option_b`,`create_by`,`create_time`,`last_update_by`,`last_update_date`,`del_flag` from sys_user where id = ?id"

    var Selectall_sys_user = "select `id`,`login_id`,`password`,`name`,`full_name`,`mobile`,`email`,`org_id`,`type`,`status`,`domain`,`option_a`,`option_b`,`create_by`,`create_time`,`last_update_by`,`last_update_date`,`del_flag` from sys_user"