/// <summary> /// 删除一个影类 /// 返回 true 表示成功; /// 返回 false 表示该类不存在 /// </summary> /// <param name="uType"></param> /// <returns></returns> public bool DeleteData(Renting_Management_System.Models.ImageTypeMod _imageType) { type = new Renting_Management_System.Models.ImageTypeMod(); type = SelectData(_imageType.ImageTypeCode); if (type != null) { da = new DBConnection(); StringBuilder deleteStr = new StringBuilder(); deleteStr.Append("Delete From [ImageType] "); deleteStr.Append("Where 影类代码 = '"); deleteStr.Append(_imageType.ImageTypeCode); deleteStr.Append("'"); da.DeleteQuery(deleteStr.ToString()); return true; } else return false; }
/// <summary> /// 添加一个影类 /// 返回 true 表示成功 /// 返回 false 表示数据已存在 /// </summary> /// <param name="uType"></param> /// <returns></returns> public bool AddData(Renting_Management_System.Models.ImageTypeMod _imageType) { type = new Renting_Management_System.Models.ImageTypeMod(); type = SelectData(_imageType.ImageTypeCode); if (type == null) { da = new DBConnection(); StringBuilder insertStr = new StringBuilder(); insertStr.Append("Insert Into [ImageType] (影类代码,影类名称) "); insertStr.Append("Values ('"); insertStr.Append(_imageType.ImageTypeCode + "','"); insertStr.Append(_imageType.ImageTypeName); 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="uType"></param> /// <returns></returns> public bool ModifyData(Renting_Management_System.Models.ImageTypeMod _imageType) { type = new Renting_Management_System.Models.ImageTypeMod(); type = SelectData(_imageType.ImageTypeCode); if (type != null) { da = new DBConnection(); StringBuilder modifyStr = new StringBuilder(); modifyStr.Append("Update [ImageType] "); modifyStr.Append("Set 影类名称 = '"); modifyStr.Append(_imageType.ImageTypeName + "'"); modifyStr.Append("Where 影类代码 = '"); modifyStr.Append(_imageType.ImageTypeCode + "'"); da.UpdateQuery(modifyStr.ToString()); return true; } else return false; }
/// <summary> /// 获取一个影像类 /// </summary> /// <param name="_userTypeCode"></param> /// <returns></returns> public Renting_Management_System.Models.ImageTypeMod SelectData(string _imageTypeCode) { da = new DBConnection(); DataSet ds = new DataSet(); StringBuilder selectStr = new StringBuilder(); selectStr.Append("Select * From [ImageType] "); selectStr.Append("Where 影类代码 = '"); selectStr.Append(_imageTypeCode); selectStr.Append("'"); ds = da.SelectQuery(selectStr.ToString()); if (ds.Tables[0].Rows.Count == 0) { return null; } else { type = new Renting_Management_System.Models.ImageTypeMod(); type.ImageTypeCode = ds.Tables[0].Rows[0][0].ToString().Trim(); type.ImageTypeName = ds.Tables[0].Rows[0][1].ToString().Trim(); return type; } }