/// <summary>
/// 获取所有用户
/// </summary>
/// <returns></returns>
public List<Model_用户> GetAllUser()
{
sql = "select * from " + DBTablesName.T_USER + " where username not in ('root','admin') order by delete_mark";
List<Model_用户> list = new List<Model_用户>();
DataSet ds = db.Query(sql);
if (ds != null)
{
DataTable dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
Model_用户 m = new Model_用户();
DataRow d = dt.Rows[i];
m.ID = Convert.ToInt32(d[0].ToString());
m.序号 = i + 1;
m.用户名 = d[1].ToString();
m.真实姓名 = d[2].ToString();
m.手机号码 = d[4].ToString();
m.用户权限 = RollbackAuthority(d[5].ToString());
m.日期 = Convert.ToDateTime(d[6].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
m.用户说明 = d[7].ToString();
m.是否使用 = Convert.ToInt32(d[8].ToString()) == 0 ? "正使用" : "停用";
list.Add(m);
}
}
return list;
}
/// <summary>
/// 根据账号获取用户信息
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
public Model_用户 GetUserInfo(string username)
{
Model_用户 m = new Model_用户();
sql = "select * from " + DBTablesName.T_USER + " where username='******'";
DataSet ds = db.Query(sql);
DataRow d = ds.Tables[0].Rows[0];
m.真实姓名 = d[2].ToString();
m.用户权限 = RollbackAuthority(d[5].ToString());
m.权限值 = Int32.Parse(d[5].ToString());
m.用户说明 = d[7].ToString();
return m;
}
/// <summary>
/// 根据ID获取一个用户
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Model_用户 GetUserInfo(int id)
{
Model_用户 m = new Model_用户();
sql = "select * from " + DBTablesName.T_USER + " where userid=" + id;
DataSet ds = db.Query(sql);
DataRow d = ds.Tables[0].Rows[0];
m.用户名 = d[1].ToString();
m.真实姓名 = d[2].ToString();
m.用户权限 = RollbackAuthority(d[5].ToString());
m.用户说明 = d[7].ToString();
return m;
}
public bool Update(Model_用户 m)
{
sql = "update " + DBTablesName.T_USER + " set realname='" + m.真实姓名 + "',authority=" + m.权限值 + ",comments='" + m.用户说明 + "' where userid=" + m.ID;
return db.Excute(sql);
}
private void InitData(int i)
{
Model_用户 m = new Model_用户();
m = vm.GetUserInfo(i);
TextBox_用户名.Text = m.用户名;
TextBox_真实姓名.Text = m.真实姓名;
ComboBox_用户权限.Text = m.用户权限;
TextBox_用户说明.Text = m.用户说明;
}
/// <summary>
/// 设置用户数据
/// </summary>
/// <returns></returns>
private Model_用户 SetUserInfo()
{
Model_用户 m = new Model_用户();
m.ID = id;
m.真实姓名 = TextBox_真实姓名.Text.Trim();
m.权限值 = ComboBox_用户权限.SelectedIndex - 1;
m.用户说明 = TextBox_用户说明.Text.Trim();
return m;
}
private void Button_登陆_Click(object sender, RoutedEventArgs e)
{
if (!vsy.GetRunningFlag())
{
TextBlock_登陆警告信息.Text = "出于安全考虑，您无法进入系统，详细请联系开发商！";
#if (!DEBUG)
return;
#endif
}
string bookname = ComboBox_账套.Text.ToString();
string id = ComboBox_账套.SelectedValue.ToString();
CommonInfo.账薄号 = id;
CommonInfo.账套信息 = bookname;
string UserName = TextBox_登陆用户名.Text.Trim();
string Password = Secure.TranslatePassword(PasswordBox_登陆密码.SecurePassword);
if (vm.ValidateAccount(UserName, Password))
{
Model.DataGrid.Model_用户 m = new Model.DataGrid.Model_用户();
m = vm.GetUserInfo(UserName);
CommonInfo.真实姓名 = m.真实姓名;
CommonInfo.用户名 = UserName;
CommonInfo.用户权限 = m.用户权限;
CommonInfo.权限值 = m.权限值;
CommonInfo.登录密码 = Password;
CommonInfo.制表单位 = xr.ReadXML("单位");
//先记录一些信息
Model_操作日志 mr = new Model_操作日志();
mr = vmr.GetOperateLog();
if (ComboBox_账套.SelectedIndex == 0)
{
if (m.权限值 >= 2)
{
Win_账套页面 w = new Win_账套页面(this.Left, this.Top);
w.Show();
this.Close();
}
else
{
TextBlock_登陆警告信息.Text = "您的权限不够，无法新建账套！";
return;
}
}
else
{
CommonInfo.制度索引 = vmb.GetStandardIndex();
CommonInfo.是否初始化年初数 = new ViewModel_年初金额().IsSaved();
CommonInfo.当前期 = vmb.GetPeriod();
CommonInfo.年 = vmb.GetYear();
//这里写日志信息
mr.日志 = "登录了账套：" + bookname;
vmr.Insert(mr);
xw.WriteXML("账套信息", bookname);
MainWindow mw = new MainWindow();
mw.Show();
this.Close();
}
}
else
{
TextBlock_登陆警告信息.Text = "账号或密码错误。";
}
}
private void Button_登陆_Click(object sender, RoutedEventArgs e)
{
if (!vsy.GetRunningFlag())
{
TextBlock_登陆警告信息.Text = "出于安全考虑，您无法进入系统，详细请联系开发商！";
#if (!DEBUG)
return;
#endif
}
string bookname = ComboBox_账套.Text.ToString();
string id = ComboBox_账套.SelectedValue.ToString();
CommonInfo.账薄号 = id;
CommonInfo.账套信息 = bookname;
string UserName = TextBox_登陆用户名.Text.Trim();
string Password = Secure.TranslatePassword(PasswordBox_登陆密码.SecurePassword);
if (vm.ValidateAccount(UserName,Password))
{
Model.DataGrid.Model_用户 m = new Model.DataGrid.Model_用户();
m = vm.GetUserInfo(UserName);
CommonInfo.真实姓名 = m.真实姓名;
CommonInfo.用户名 = UserName;
CommonInfo.用户权限 = m.用户权限;
CommonInfo.权限值 = m.权限值;
CommonInfo.登录密码 = Password;
CommonInfo.制表单位 = xr.ReadXML("单位");
//先记录一些信息
Model_操作日志 mr = new Model_操作日志();
mr = vmr.GetOperateLog();
if (ComboBox_账套.SelectedIndex==0)
{
if (m.权限值 >= 2)
{
Win_账套页面 w = new Win_账套页面(this.Left, this.Top);
w.Show();
this.Close();
}
else
{
TextBlock_登陆警告信息.Text = "您的权限不够，无法新建账套！";
return;
}
}
else
{
CommonInfo.制度索引 = vmb.GetStandardIndex();
CommonInfo.是否初始化年初数 = new ViewModel_年初金额().IsSaved();
CommonInfo.当前期 = vmb.GetPeriod();
CommonInfo.年 = vmb.GetYear();
//这里写日志信息
mr.日志 = "登录了账套：" + bookname;
vmr.Insert(mr);
xw.WriteXML("账套信息", bookname);
MainWindow mw = new MainWindow();
mw.Show();
this.Close();
}
}
else
{
TextBlock_登陆警告信息.Text = "账号或密码错误。";
}
}
private Model_用户 SetData()
{
Model_用户 m = new Model_用户();
m.用户名 = TextBox_用户名.Text.Trim();
m.密码 = Secure.TranslatePassword(TextBox_用户密码.SecurePassword);
m.真实姓名 = TextBox_真实姓名.Text.Trim();
m.权限值 = ComboBox_用户权限.SelectedIndex - 1;
m.创建日期 = DateTime.Now;
m.用户说明 = TextBox_用户说明.Text.Trim();
return m;
}
