| | |
| | | return true; |
| | | } |
| | | |
| | | private bool ValidateCode(object value, out string err) |
| | | { |
| | | err = null; |
| | | string segment = string.IsNullOrEmpty(Data.Id) ? "" : $" AND id!='{Data.Id}'"; |
| | | string sql = $"SELECT 1 FROM user WHERE code='{TbCode.Text}'{segment};"; |
| | | if (sqliteHelper.HasData(sql)) |
| | | { |
| | | err = string.Format(LangUtil.Get("App.MustBeUnique"), LangUtil.Get("HMI.User.Code")); |
| | | return false; |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | private bool ValidateForm() |
| | | { |
| | | bool flag = FormGroupHelper.ValidateForm(formPanel); |
| | | if (flag) |
| | | { |
| | | Data.Code = TbCode.Text; |
| | | Data.Username = TbUsername.Text; |
| | | Data.Name = TbName.Text; |
| | | Data.Password = TbPassword.Text; |
| | | Data.Password = TbPassword.Password; |
| | | } |
| | | |
| | | return flag; |
| | |
| | | public bool? Open(UserData data) |
| | | { |
| | | Data = data; |
| | | TbCode.Text = Data.Code; |
| | | TbUsername.Text = Data.Username; |
| | | TbName.Text = Data.Name; |
| | | TbPassword.Text = Data.Password; |
| | | TbPassword.Password = Data.Password; |
| | | |
| | | Roles = UserRoleRelHelper.SelectUserRoleData(sqliteHelper, Data.Username); |
| | | |
| | |
| | | |
| | | public void InsertData(UserData data) |
| | | { |
| | | string sql = $@"INSERT INTO user (username,password,name) |
| | | string sql = $@"INSERT INTO user (code, username,password,name) |
| | | VALUES |
| | | ('{data.Username}','{data.Password}','{data.Name}');"; |
| | | ('{data.Code}', '{data.Username}','{data.Password}','{data.Name}');"; |
| | | UserRoleRelHelper.SaveUserRoleRel(sqliteHelper, Roles, data, sql, null); |
| | | } |
| | | |
| | | public void UpdateData(UserData data) |
| | | { |
| | | string sql = $@"UPDATE user SET username='{data.Username}',password='{data.Password}',name='{data.Name}' |
| | | string sql = $@"UPDATE user SET code='{data.Code}', username='{data.Username}',password='{data.Password}',name='{data.Name}' |
| | | WHERE id='{data.Id}';"; |
| | | UserRoleRelHelper.SaveUserRoleRel(sqliteHelper, Roles, data, sql, null); |
| | | } |