/// <summary>
 /// 删除一个用户类
 /// 返回 true 表示成功;
 /// 返回 false 表示该类不存在
 /// </summary>
 /// <param name="_userType"></param>
 /// <returns></returns>
 public bool DeleteData(Renting_Management_System.Models.UserTypeMod _userType)
 {
     type = new Renting_Management_System.Models.UserTypeMod();
     type = SelectData(_userType.UserTypeCode);
     if (type != null)
     {
         da = new DBConnection();
         StringBuilder deleteStr = new StringBuilder();
         deleteStr.Append("Delete From [UserType]");
         deleteStr.Append("Where 用户类代码 = '");
         deleteStr.Append(_userType.UserTypeCode);
         deleteStr.Append("'");
         da.DeleteQuery(deleteStr.ToString());
         return true;
     }
     else
         return false;
 }
 /// <summary>
 /// 添加一个用户类
 /// 返回 true 表示成功
 /// 返回 false 表示数据已存在
 /// </summary>
 /// <param name="_userType"></param>
 /// <returns></returns>
 public bool AddData(Renting_Management_System.Models.UserTypeMod _userType)
 {
     type = new Renting_Management_System.Models.UserTypeMod();
     type = SelectData(_userType.UserTypeCode);
     if (type == null)
     {
         da = new DBConnection();
         StringBuilder insertStr = new StringBuilder();
         insertStr.Append("Insert Into [UserType] (用户类代码,用户类名称)");
         insertStr.Append("Values ('");
         insertStr.Append(_userType.UserTypeCode + "','");
         insertStr.Append(_userType.UserTypeName);
         insertStr.Append("')");
         da.InsertQuery(insertStr.ToString());
         return true;
     }
     else
         return false;
 }
 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("请选择相应的表再进行添加");
     }
 }
 /// <summary>
 /// 修改一个用户类名称
 /// 返回 true 表示成功
 /// 返回 false 表示该类不存在
 /// </summary>
 /// <param name="_userType"></param>
 /// <returns></returns>
 public bool ModifyData(Renting_Management_System.Models.UserTypeMod _userType)
 {
     type = new Renting_Management_System.Models.UserTypeMod();
     type = SelectData(_userType.UserTypeCode);
     if (type != null)
     {
         da = new DBConnection();
         StringBuilder modifyStr = new StringBuilder();
         modifyStr.Append("Update [UserType]");
         modifyStr.Append("Set 用户类名称 = '");
         modifyStr.Append(_userType.UserTypeName + "'");
         modifyStr.Append("Where 用户类代码 = '");
         modifyStr.Append(_userType.UserTypeCode + "'");
         da.UpdateQuery(modifyStr.ToString());
         return true;
     }
     else
         return false;
 }
 /// <summary>
 /// 获取一个用户类
 /// </summary>
 /// <param name="_userTypeCode"></param>
 /// <returns></returns>
 public Renting_Management_System.Models.UserTypeMod SelectData(string _userTypeCode)
 {
     da = new DBConnection();
     DataSet ds = new DataSet();
     StringBuilder selectStr = new StringBuilder();
     selectStr.Append("Select * From [UserType] ");
     selectStr.Append("Where 用户类代码 = '");
     selectStr.Append(_userTypeCode);
     selectStr.Append("'");
     ds = da.SelectQuery(selectStr.ToString());
     if (ds.Tables[0].Rows.Count == 0)
     {
         return null;
     }
     else
     {
         type = new Renting_Management_System.Models.UserTypeMod();
         type.UserTypeCode = ds.Tables[0].Rows[0][0].ToString().Trim();
         type.UserTypeName = ds.Tables[0].Rows[0][1].ToString().Trim();
         return type;
     }
 }