public LoginForm()
{
InitializeComponent();
_userType = new Renting_Management_System.DAL.UserTypeDAL();
DataSet ds = new DataSet();
ds = _userType.GetAll();
UserTypecomboBox.DataSource = ds.Tables[0];
UserTypecomboBox.DisplayMember = ds.Tables[0].Columns[1].ColumnName;
UserTypecomboBox.ValueMember = ds.Tables[0].Columns[0].ColumnName;
UserTypecomboBox.SelectedValue = "";
}
public AddingUserForm()
{
InitializeComponent();
userTypeDAL = new Renting_Management_System.DAL.UserTypeDAL();
certificateTypeDAL = new Renting_Management_System.DAL.CertificateTypeDAL();
ds = new DataSet();
ds = userTypeDAL.GetAll();
comboBox_UserType.DataSource = ds.Tables[0];
comboBox_UserType.DisplayMember = ds.Tables[0].Columns[1].ColumnName;
comboBox_UserType.ValueMember = ds.Tables[0].Columns[0].ColumnName;
comboBox_UserType.SelectedValue = "";
ds = certificateTypeDAL.GetAll();
comboBox_CertificateType.DataSource = ds.Tables[0];
comboBox_CertificateType.DisplayMember = ds.Tables[0].Columns[1].ColumnName;
comboBox_CertificateType.ValueMember = ds.Tables[0].Columns[0].ColumnName;
comboBox_CertificateType.SelectedValue = "";
}
private void Add_btn_Click(object sender, EventArgs e)
{
if (this.usertype.Enabled==false)
{
userType = new Renting_Management_System.DAL.UserTypeDAL();
userTypeMod = new Renting_Management_System.Models.UserTypeMod();
userTypeMod.UserTypeCode = txtID.Text.Trim();
userTypeMod.UserTypeName = txtName.Text.Trim();
userType.AddData(userTypeMod);
ds.Clear();
ds = userType.GetAll();
s1 = new BindingSource();
s1.DataSource = ds;
s1.DataMember = ds.Tables[0].TableName;
bindingNavigator1.BindingSource = s1;
dataGridView1.DataSource = s1;
sq1.Refresh(ds);
MessageBox.Show("添加成功");
}
else if (this.Certificatetype.Enabled==false)
{
certificateType = new Renting_Management_System.DAL.CertificateTypeDAL();
certificateTypeMod = new Renting_Management_System.Models.CertificateTypeMod();
certificateTypeMod.CertificateTypeCode = txtID.Text.Trim();
certificateTypeMod.CertificateTypeName = txtName.Text.Trim();
certificateType.AddData(certificateTypeMod);
ds.Clear();
ds = certificateType.GetAll();
s1 = new BindingSource();
s1.DataSource = ds;
s1.DataMember = ds.Tables[0].TableName;
bindingNavigator1.BindingSource = s1;
dataGridView1.DataSource = s1;
sq1.Refresh(ds);
MessageBox.Show("添加成功");
}
else if(this.customertype.Enabled==false)
{
customerType=new Renting_Management_System.DAL.CustomerTypeDAL();
customerTypeMod=new Renting_Management_System.Models.CustomerTypeMod();
customerTypeMod.CustomerTypeCode=txtID.Text.Trim();
customerTypeMod.CustomerTypeName=txtName.Text.Trim();
customerType.AddData(customerTypeMod);
ds.Clear();
ds=customerType.GetAll();
s1 = new BindingSource();
s1.DataSource = ds;
s1.DataMember = ds.Tables[0].TableName;
bindingNavigator1.BindingSource = s1;
dataGridView1.DataSource = s1;
sq1.Refresh(ds);
MessageBox.Show("添加成功");
}
else if (this.Imagetype.Enabled == false)
{
imageType = new Renting_Management_System.DAL.ImageTypeDAL();
imageTypeMod = new Renting_Management_System.Models.ImageTypeMod();
imageTypeMod.ImageTypeCode = txtID.Text.Trim();
imageTypeMod.ImageTypeName = txtName.Text.Trim();
imageType.AddData(imageTypeMod);
ds.Clear();
ds = imageType.GetAll();
s1 = new BindingSource();
s1.DataSource = ds;
s1.DataMember = ds.Tables[0].TableName;
bindingNavigator1.BindingSource = s1;
dataGridView1.DataSource = s1;
sq1.Refresh(ds);
MessageBox.Show("添加成功");
}
else
{
MessageBox.Show("请选择相应的表再进行添加");
}
}
private void usertype_Click(object sender, EventArgs e)
{
userType = new Renting_Management_System.DAL.UserTypeDAL();
ds.Clear();
ds = userType.GetAll();
s1 = new BindingSource();
s1.DataSource = ds;
s1.DataMember = ds.Tables[0].TableName;
dataGridView1.DataSource = s1;
this.usertype.Enabled = false;
this.customertype.Enabled = true;
this.Imagetype.Enabled = true;
this.Certificatetype.Enabled = true;
}
private void CodeLibrary_Load(object sender, EventArgs e)
{
userType = new Renting_Management_System.DAL.UserTypeDAL();
ds = new DataSet();
s1 = new BindingSource();
ds = userType.GetAll();
s1.DataSource = ds;
s1.DataMember = ds.Tables[0].TableName;
bindingNavigator1.BindingSource = s1;
dataGridView1.DataSource = s1;
//this.dataGridView1.Columns[0].Width = 80;
//this.dataGridView1.Columns[1].Width = 298;
}
