//获取所有用户
public DataSet GetUsers()
{
string sql = SQLRule.GetUsers();
var _result = SQLHelper.GetAdmin(sql);
return(_result);
}
//通过Id获取用户
public DataSet GetUserInfoById(EntityAdmin entity)
{
// string sql = "select * from Admin where Id=" + entity.id;
string sql = SQLRule.GetUserInfoById(entity);
var _result = SQLHelper.GetAdmin(sql);
return(_result);
}
public MainWindow()
{
this.Loaded += new RoutedEventHandler(MainWindow_Loaded);
InitializeComponent();
this.DataContext = vm;
SelectConnection.ViewModel = vm;
this.selectRules.NewRuleButton.Click += new RoutedEventHandler(delegate(Object sender, RoutedEventArgs args)
{
String ruleName = "User-defined rule " + (dblint.AllExecutables.GetSQLRules().Count + 1);
SQLRule newRule = SQLRuleCollection.AddSQLRule(ruleName);
this.dblint.AllExecutables.AddExecutable(newRule);
this.updateSQLRuleSet();
});
this.selectRules.OnDeleteRule += new DeleteRuleHandler(delegate(Rule rule)
{
SQLRuleCollection.RemoveSQLRule(rule.Name);
this.dblint.AllExecutables.RemoveExecutable(rule.Executable);
this.updateSQLRuleSet();
});
this.selectRules.SaveConfigButon.Click += new RoutedEventHandler(delegate(Object sender, RoutedEventArgs args)
{
var saveConfigOptions = new SaveConfigOptions();
var res = saveConfigOptions.ShowDialog();
if (res.HasValue && res.Value == true)
{
this.saveConfig(saveConfigOptions);
}
});
this.selectRules.LoadConfigButon.Click += new RoutedEventHandler(delegate(Object sender, RoutedEventArgs args)
{
Microsoft.Win32.OpenFileDialog loadDialog = new Microsoft.Win32.OpenFileDialog();
loadDialog.DefaultExt = ".xml";
loadDialog.Filter = "XML Document (.xml)|*.xml";
bool?result = loadDialog.ShowDialog();
if (result == true)
{
this.loadConfig(loadDialog.FileName);
}
});
this.loadConfig(Settings.XMLCONFIG);
this.Closing += new System.ComponentModel.CancelEventHandler(MainWindow_Closing);
}
public bool mtDel(List <int> num)
{
return(SQLHelper.ExcuteSql(SQLRule.mtDel(num)));
}
//多行删除
public bool mutiDel(string id)
{
//string sql = "delete from Admin where Id in("+id+")";
return(SQLHelper.ExcuteSql(SQLRule.mutiDel(id)));
}
//模糊查询
public DataSet ByUserPwdAndUserName(EntityAdmin entity)
{
//string sql = "select * from Admin where UserName Like '%"+entity.username+"%' and UserPwd Like '%" + entity.userpwd + "%'";
return(SQLHelper.GetAdmin(SQLRule.ByUserPwdAndUserName(entity)));
}
public DataSet ByUserNameUser(EntityAdmin entity)
{
//string sql = "select * from Admin where UserName="+entity.username;
return(SQLHelper.GetAdmin(SQLRule.ByUserNameUser(entity)));
}
//修改保存
public bool UpdateUser(EntityAdmin entity)
{
// string sql = "Update Admin Set UserName="******",UserPwd="+entity.userpwd+"where Id="+entity.id+"";
return(SQLHelper.ExcuteSql(SQLRule.UpdateUser(entity)));
}
//删除
public bool DeleteUser(EntityAdmin entity)
{
//string sql = "delete from Admin where Id="+entity.id;
return(SQLHelper.ExcuteSql(SQLRule.DeleteUser(entity)));
}
//新增
public bool SaveUser(EntityAdmin entity)
{
// string sql = "Insert Admin(UserName,UserPwd,Name,Sex,Tel)" + "values('" + entity.username + "','" + entity.userpwd + "','User','男','12345678900')";
return(SQLHelper.ExcuteSql(SQLRule.SaveUser(entity)));
}
