Example #1
0
        /// <summary>
        /// 添加记录到数据库
        /// </summary>
        /// <param name="recordObj"></param>
        /// <returns></returns>
        public static int AddRecord(DBRecord recordObj)
        {
            try
            {
                StringBuilder sb = new StringBuilder();
                sb.Append("INSERT INTO review_record_tbl(tfs_id, group_name, coder, code_date, reviewer, review_date, code_line, content)");
                sb.Append("VALUES(?tfs_id,?group_name,?coder,?code_date,?reviewer,?review_date,?code_line,?content)");
                MySqlParameter[] parameters =
                {
                    new MySqlParameter("?tfs_id",      MySqlDbType.Int32),
                    new MySqlParameter("?group_name",  MySqlDbType.String),
                    new MySqlParameter("?coder",       MySqlDbType.String),
                    new MySqlParameter("?code_date",   MySqlDbType.Date),
                    new MySqlParameter("?reviewer",    MySqlDbType.String),
                    new MySqlParameter("?review_date", MySqlDbType.Date),
                    new MySqlParameter("?code_line",   MySqlDbType.Int32),
                    new MySqlParameter("?content",     MySqlDbType.String)
                };

                parameters[0].Value = recordObj.m_iTfsID;
                parameters[1].Value = recordObj.m_strGroupName;
                parameters[2].Value = recordObj.m_strCoder;
                parameters[3].Value = recordObj.m_strCodeDate;
                parameters[4].Value = recordObj.m_strReviewer;
                parameters[5].Value = recordObj.m_strReviewDate;
                parameters[6].Value = recordObj.m_iReviewLine;
                parameters[7].Value = recordObj.m_strContent;

                return(SQLHelper.ExecuteNonQuery(sb.ToString(), CommandType.Text, parameters));
            }
            catch (System.Exception ex)
            {
                throw ex;
            }
        }
Example #2
0
        /// <summary>
        /// 确定按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ok_button_Click(object sender, EventArgs e)
        {
            // 内容检查
            if (ReviewCheck() == false)
            {
                return;
            }

            try
            {
                // 注释信息
                string strTemp = review_tfs_textBox.Text.Trim();
                this.Cursor = System.Windows.Forms.Cursors.WaitCursor;

                // 信息添加到数据库
                DBRecord dbRecord = new DBRecord();
                dbRecord.m_iTfsID        = MainForm.m_tagTFSWindowInfo.m_iID;
                dbRecord.m_strGroupName  = MainForm.m_tagTFSWindowInfo.m_strGroupName;
                dbRecord.m_strCoder      = MainForm.m_tagTFSWindowInfo.m_strCheckin;
                dbRecord.m_strCodeDate   = MainForm.m_tagTFSWindowInfo.m_strCheckinDate;
                dbRecord.m_strReviewer   = review_name_textBox.Text.Trim();
                dbRecord.m_strReviewDate = DateTime.Now.ToShortDateString();
                dbRecord.m_iReviewLine   = int.Parse(review_line_textBox.Text);
                dbRecord.m_strContent    = strTemp;
                DatabaseInterface.AddRecord(dbRecord);

                // 发送邮件
                if (review_mail_checkBox.CheckState == CheckState.Checked)
                {
                    SendMail();
                }

                // 设置Review标签
                string        strTFSContent = MainForm.m_tagTFSWindowInfo.m_strContent;
                StringBuilder strContent    = new StringBuilder(4096);
                strContent.Append(strTFSContent);
                if (strTFSContent.Length > 0 && strTFSContent[0] != '*')
                {
                    WinAPI.SendMessage(MainForm.m_tagTFSWindowInfo.m_hContentCtrl, WinAPI.WM_SETTEXT, strContent.Capacity, strContent);
                    WinAPI.SendMessage(MainForm.m_tagTFSWindowInfo.m_hContentCtrl, WinAPI.WM_CHAR, (IntPtr)'*', IntPtr.Zero);
                }

                this.Cursor = System.Windows.Forms.Cursors.Arrow;
                this.Close();
            }
            catch (System.Exception ex)
            {
                this.Cursor = System.Windows.Forms.Cursors.Arrow;
                MainForm.ErrorMessage(ex.ToString());
            }
        }