public const string mysqlConnection = DBConstant.mysqlConnection;//"User Id=root;Host=115.29.229.134;Database=chinaunion;password=c513324665;charset=utf8"; /// <summary> /// 添加数据 /// </summary> /// <returns></returns> public int Add(UserDefinedGroup entity) { string sql = "INSERT INTO tb_user_define_group (groupName,member,type) VALUE (@groupName,@member,@type)"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@groupName", entity.groupName); command.Parameters.AddWithValue("@member", entity.member); command.Parameters.AddWithValue("@type", entity.type); int i = command.ExecuteNonQuery(); mycn.Close(); return i; } }
/// <summary> /// 修改数据 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int Update(UserDefinedGroup entity) { string sql = "UPDATE tb_user_define_group SET groupName=@groupName,member=@member where groupName=@groupName and member=@member and type=@type"; //string sql = "UPDATE cimuser SET userNickName=@userNickName WHERE userid=@userid"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@groupName", entity.groupName); command.Parameters.AddWithValue("@member", entity.member); command.Parameters.AddWithValue("@type", entity.type); int i = command.ExecuteNonQuery(); mycn.Close(); return i; } }
/// <summary> /// 异步 开始事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void worker_DoWork(object sender, DoWorkEventArgs e) { //需要执行的代码 worker.ReportProgress(3, "开始导入信息...\r\n"); //导入代理商 GroupDao groupDao = new GroupDao(); Group group = new Group(); group.groupName = this.txtGroupName.Text.Trim(); group.description = group.groupName; groupDao.Delete(group); groupDao.Add(group); UserDefinedGroupDao userDefinedGroupDao = new UserDefinedGroupDao(); for (int i = 0; i < dgAgent.RowCount; i++) { UserDefinedGroup userDefinedGroup = new UserDefinedGroup(); userDefinedGroup.groupName = group.groupName; userDefinedGroup.member = dgAgent[0, i].Value.ToString(); userDefinedGroup.type = "代理商/渠道"; userDefinedGroupDao.Add(userDefinedGroup); worker.ReportProgress(4, "导入" + userDefinedGroup.member + "信息完成...\r\n"); } //dgInvoice.AutoResizeColumns(); worker.ReportProgress(5, "导入信息完成...\r\n"); //MessageBox.Show("数据上传完毕"); }
/// <summary> /// 根据主键查询 /// </summary> /// <param name="primaryKey"></param> /// <returns></returns> //public Agent Get(int primaryKey) //{ // string sql = "SELECT userid,userNickName FROM cimuser where userid=@userid"; // using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) // { // mycn.Open(); // MySqlCommand command = new MySqlCommand(sql, mycn); // command.Parameters.AddWithValue("@userid", primaryKey); // MySqlDataReader reader = command.ExecuteReader(); // Agent userBase = null; // if (reader.Read()) // { // userBase = new Agent(); // userBase.UserId = Convert.ToInt32(reader["userid"]); // userBase.UserNickName = reader["userNickName"] == DBNull.Value ? null : reader["userNickName"].ToString(); // } // return userBase; // } //} /// <summary> /// 查询集合 /// </summary> /// <returns></returns> public IList<UserDefinedGroup> GetList(String groupName) { string sql = "SELECT groupName,member,type FROM tb_user_define_group where groupName=@groupName"; using (MySqlConnection mycn = new MySqlConnection(mysqlConnection)) { mycn.Open(); MySqlCommand command = new MySqlCommand(sql, mycn); command.Parameters.AddWithValue("@groupName", groupName); MySqlDataReader reader = command.ExecuteReader(); IList<UserDefinedGroup> list = new List<UserDefinedGroup>(); UserDefinedGroup userDefinedGroup = null; while (reader.Read()) { userDefinedGroup = new UserDefinedGroup(); userDefinedGroup.groupName = reader["groupName"] == DBNull.Value ? null : reader["groupName"].ToString(); userDefinedGroup.member = reader["member"] == DBNull.Value ? null : reader["member"].ToString(); userDefinedGroup.type = reader["type"] == DBNull.Value ? null : reader["type"].ToString(); list.Add(userDefinedGroup); } mycn.Close(); return list; } }
private void btnSave_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(this.txtGroupName.Text.Trim())) { MessageBox.Show("请输入组名!"); this.txtGroupName.Focus(); return; } this.Cursor = Cursors.WaitCursor; Group group = new Group(); group.groupName = this.txtGroupName.Text.Trim(); group.description = this.txtDescription.Text.Trim(); userDefinedGroupDao.Delete(group.groupName); groupDao.Delete(group); groupDao.Add(group); foreach ( Object item in this.lstAssignType.Items) { UserDefinedGroup userDefinedGroup = new UserDefinedGroup(); userDefinedGroup.groupName = group.groupName; userDefinedGroup.member = item.ToString(); userDefinedGroup.type = "渠道类型"; userDefinedGroupDao.Add(userDefinedGroup); } foreach (Object item in this.lstAssignAgent.Items) { UserDefinedGroup userDefinedGroup = new UserDefinedGroup(); userDefinedGroup.groupName = group.groupName; userDefinedGroup.member = item.ToString().Substring(0, item.ToString().IndexOf(":")); userDefinedGroup.type = "代理商/渠道"; userDefinedGroupDao.Add(userDefinedGroup); } this.prepareGrid(this.txtKeyword.Text); MessageBox.Show("操作完成"); this.Cursor = Cursors.Default; }