package models
    var Insert_sys_user = ` 
        insert into sys_user
		(id,login_id,password,name,full_name,email,org_id,type,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag)
		values
		(?id,?login_id,?password,?name,?full_name,?email,?org_id,?type,?status,?domain,?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,
		email = ?email,
		org_id = ?org_id,
		type = ?type,
		status = ?status,
		domain = ?domain,
		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_user
		where id =?id
`

    var Selectone_sys_user = ` 
        select 
			id,login_id,password,name,full_name,email,org_id,type,status,domain,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,email,org_id,type,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
        from sys_user
`