예제 #1
0
 /// <summary> 
 /// 删除数据 
 /// </summary> 
 /// <param name="entity"></param> 
 /// <returns></returns> 
 public int Delete(PolicyReceiver entity)
 {
     string sql = "DELETE FROM tb_policy_receiver WHERE policy_sequence=@policy_sequence and receiver=@receiver and type=@type";
     using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
     {
         mycn.Open();
         MySqlCommand command = new MySqlCommand(sql, mycn);
         command.Parameters.AddWithValue("@policy_sequence", entity.policySequence);
         command.Parameters.AddWithValue("@receiver", entity.receiver);
         command.Parameters.AddWithValue("@type", entity.type);
         int i = command.ExecuteNonQuery();
         mycn.Close();
         mycn.Dispose();
         return i;
     }
 }
예제 #2
0
 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(PolicyReceiver entity)
 {
     string sql = "INSERT INTO tb_policy_receiver (policy_sequence,receiver,type) VALUE (@policy_sequence,@receiver,@type)";
     using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
     {
         mycn.Open();
         MySqlCommand command = new MySqlCommand(sql, mycn);
         command.Parameters.AddWithValue("@policy_sequence", entity.policySequence);
         command.Parameters.AddWithValue("@receiver", entity.receiver);
         command.Parameters.AddWithValue("@type", entity.type);
         int i = command.ExecuteNonQuery();
         mycn.Close();
         mycn.Dispose();
         return i;
     }
 }
예제 #3
0
        /// <summary> 
        /// 修改数据 
        /// </summary> 
        /// <param name="entity"></param> 
        /// <returns></returns> 
        public int Update(PolicyReceiver entity)
        {
            string sql = "UPDATE  tb_policy_receiver SET policy_sequence=@policy_sequence,receiver=@receiver where policy_sequence=@policy_sequence  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("@policy_sequence", entity.policySequence);
                command.Parameters.AddWithValue("@receiver", entity.receiver);
                command.Parameters.AddWithValue("@type", entity.type);
                int i = command.ExecuteNonQuery();
                mycn.Close();
                mycn.Dispose();
                return i;
            }
        }
예제 #4
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            //MessageBox.Show(this.lstAgentType.CheckedItems.Count.ToString());
            //return;
            if (String.IsNullOrEmpty(this.cbType.Text.Trim()))
            {
                MessageBox.Show("请选择类型!");
                this.txtSubject.Focus();
                return;
            }
            if (String.IsNullOrEmpty(this.txtSubject.Text.Trim()))
            {
                MessageBox.Show("请输入名称!");
                this.txtSubject.Focus();
                return;
            }
            if (String.IsNullOrEmpty(this.txtContent.Text.Trim()))
            {
                MessageBox.Show("请输入内容!");
                this.txtContent.Focus();
                return;
            }
            if (this.dtEndDate.Value.CompareTo(this.dtStartDate.Value) <= 0)
            {
                MessageBox.Show("有效期结束时间必须大于开始时间");

                return;
            }

            this.Cursor = Cursors.WaitCursor;
            Policy policy = new Policy();
            policy.sequence = this.txtSequence.Text.Trim();
            policy.type = this.cbType.Text;
            policy.subject = this.txtSubject.Text.Trim();
            policy.content = this.txtContent.Text.Trim();
            policy.sender = this.loginUser.name;
            policy.validateStartTime = this.dtStartDate.Value.ToString("yyyy-MM-dd");
            policy.validateEndTime = this.dtEndDate.Value.ToString("yyyy-MM-dd");
            policy.creatTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
            policy.isDelete = "N";
            policy.isValidate = "Y";
            policy.agentType = "";
            foreach (object item in this.chkAgentType.CheckedItems)
            {
                policy.agentType = policy.agentType + item.ToString()+";";
            }
          //  policy.agentType = this.cboAgentType.Text;
            if (this.lstAgentType.CheckedItems.Contains("所有渠道"))
            {
                policy.toAll = "Y";
            }
            else
            {
                policy.toAll = "N";
            }

            byte[] b = new byte[0];
            String fullpath = this.txtAttachmentLocation.Text;
            if (!String.IsNullOrEmpty(fullpath))
            {
                FileStream fs = new FileStream(fullpath, FileMode.Open, FileAccess.Read);
                byte[] attachmentBytes = new byte[fs.Length];

                fs.Read(attachmentBytes, 0, System.Convert.ToInt32(fs.Length));

                //  BinaryReader br = new BinaryReader(fs);
                // attachmentBytes = br.ReadBytes(Convert.ToInt32(fs.Length));
                fs.Close();
                // br.Close();

                if (attachmentBytes.Length > 0)
                {
                    policy.attachmentName = this.txtAttachmentName.Text;
                    policy.attachment = attachmentBytes;
                }

            }
            else
            {
                if (!String.IsNullOrEmpty(policy.sequence))
                {
                    Policy tempPolicy = this.policyDao.Get(Int32.Parse(policy.sequence));
                    policy.attachment = tempPolicy.attachment;
                    policy.attachmentName = tempPolicy.attachmentName;
                }
            }
            if (!String.IsNullOrEmpty(policy.sequence))
            {

                this.policyDao.Update(policy);

            }
            else
            {
                policyDao.Add(policy);

                policy = policyDao.GetBySubject(policy.subject);
            }

            policyReceiverDao.Delete(policy.sequence);


            for (int i = 0; i < lstAgentType.Items.Count; i++)
            {
                if (lstAgentType.GetItemChecked(i))
                {
                    PolicyReceiver policyReceiver = new PolicyReceiver();
                    policyReceiver.policySequence = policy.sequence;
                    policyReceiver.receiver = lstAgentType.Items[i].ToString();
                    policyReceiver.type = "渠道类型";
                    policyReceiverDao.Add(policyReceiver);
                }
            }


            for (int i = 0; i < lstGroup.Items.Count; i++)
            {
                if (lstGroup.GetItemChecked(i))
                {
                    PolicyReceiver policyReceiver = new PolicyReceiver();
                    policyReceiver.policySequence = policy.sequence;
                    policyReceiver.receiver = lstGroup.Items[i].ToString();
                    policyReceiver.type = "自定义组";
                    policyReceiverDao.Add(policyReceiver);
                }
            }

            this.prepareGrid(this.txtSearchCondition.Text);
            MessageBox.Show("操作完成");

            this.Cursor = Cursors.Default;
        }
예제 #5
0
        /// <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<PolicyReceiver> GetList(String policySequence)
        {
            string sql = "SELECT policy_sequence,receiver,type FROM tb_policy_receiver where policy_Sequence=@policy_Sequence";
            using (MySqlConnection mycn = new MySqlConnection(mysqlConnection))
            {
                mycn.Open();
                MySqlCommand command = new MySqlCommand(sql, mycn);
                command.Parameters.AddWithValue("@policy_Sequence", policySequence);
                MySqlDataReader reader = command.ExecuteReader();
                IList<PolicyReceiver> list = new List<PolicyReceiver>();
                PolicyReceiver policyReceiver = null;
                while (reader.Read())
                {
                    policyReceiver = new PolicyReceiver();

                    policyReceiver.policySequence = reader["policy_sequence"] == DBNull.Value ? null : reader["policy_sequence"].ToString();
                    policyReceiver.receiver = reader["receiver"] == DBNull.Value ? null : reader["receiver"].ToString();
                    policyReceiver.type = reader["type"] == DBNull.Value ? null : reader["type"].ToString();

                    list.Add(policyReceiver);
                }
                mycn.Close();
                return list;
            }
        }