コード例 #1
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            #region
            //------------�жϺ���-����-2010-3-12-----
            if (1 == CMainForm.IsHaveRed)
            {
                if (!CMainForm.IsRightPosition)
                {
                    alarmSound.Alarm("����������");
                    return;
                }
            }
            //----------------------------------------
            #endregion

            CoalTraffic.Model.TT_LoadWeight model = new CoalTraffic.Model.TT_LoadWeight();

            if (strCurrentMenu != "Person")
            {
                model.LoadWeight = Convert.ToDecimal(lblDigital.Text);
                model.NetWeight = Convert.ToDecimal(lblDigital.Text) - Convert.ToDecimal(txtEmptyWeight.Text.Trim());
            }
            else
            {
                #region ��֤���ݵ���ȷ��
                if (txtHandDigital.Text.Trim() != "" && CommonMethod.IsDecimal(CommonMethod.ToDBC(txtHandDigital.Text.Trim())))
                {
                    if (Convert.ToDecimal(CommonMethod.ToDBC(txtHandDigital.Text.Trim())) < Convert.ToDecimal(lblDigital.Text.Trim()))
                    {
                        alarmSound.Alarm("��������س���������С�ڰ�������");
                        txtHandDigital.Text = "";
                        return;
                    }
                    else
                    {
                        model.LoadWeight = Convert.ToDecimal(CommonMethod.ToDBC(this.txtHandDigital.Text.Trim()));
                        model.NetWeight = Convert.ToDecimal(CommonMethod.ToDBC(this.txtHandDigital.Text.Trim())) - Convert.ToDecimal(txtEmptyWeight.Text.Trim());
                    }
                }
                else
                {
                    alarmSound.Alarm("��������س�������ʽ����");
                    txtHandDigital.Text = "";
                    return;
                }
                #endregion
            }
            if (model.NetWeight > 0.00m)
            {

                #region ��ȡ��ú����ص���Ϣ���Լ�ú��������Ϣ��
                SqlParameter[] parameter =
                {
                    new SqlParameter("@CollCode", SqlDbType.VarChar,10),
                    new SqlParameter("@CoalKindCode", SqlDbType.VarChar,4)
                };

                parameter[0].Value = strCollCode;//����ú����
                parameter[1].Value = strCoalKindCode;//ú�ֱ��
                DataSet dstColieryAccount = DbHelperSQL.RunProcedure("PT_ColieryAccountJudge", parameter, "ColieryAccount");
                #endregion

                string strLeastValue = dstColieryAccount.Tables["ColieryAccount"].Rows[0]["ReturnValue"].ToString();

                if (strLeastValue == "0") //0���������ɹ���
                {
                    #region ��Ƶץͼ
                    if (CoalTraffic.DBUtility.StaticParameter.IsVideo == "1")
                    {
                        if (byteFrontImage == null && byteBackImage == null && byteUpImage == null && byteRoomImage == null)
                        {
                            strFrontImage = Guid.NewGuid().ToString().Replace("-", "");
                            strBackImage = Guid.NewGuid().ToString().Replace("-", "");
                            strUpImage = Guid.NewGuid().ToString().Replace("-", "");
                            strRoomImage = Guid.NewGuid().ToString().Replace("-", "");

                            byteFrontImage = this.videoFrontImage.CapturePic();
                            byteBackImage = this.videoBackImage.CapturePic();
                            byteUpImage = this.videoUpImage.CapturePic();
                            byteRoomImage = this.videoRoomImage.CapturePic();
                        }
                    }
                    #endregion

                    #region ʵ�����س�
                    string strWeightCode = strRoomCode + DateTime.Now.ToString("yyyyMMddHHmmss");
                    model.WeightCode = strWeightCode;
                    model.TrafficCode = strWeightCode;
                    model.NavicertCode = strNavicertCode;
                    model.MarkedCardCode = strMardedCardCode;
                    model.RemoteCardCode = strRemoteCode;

                    model.CollCode = strCollCode;
                    model.CollName = this.cmbCollName.Text.Trim();
                    model.CoalKindCode = this.cmbCoalKind.SelectedValue.ToString();
                    model.CoalKindName = this.cmbCoalKind.Text.Trim();
                    //model.CoalKindName = this.txtKindName.Text.Trim();
                    model.CarOwnerName = strCarOwnerName;

                    model.CarNo = txtCarNo.Text;
                    model.CarType = txtCarType.Text;
                    model.EmptyWeight = Convert.ToDecimal(txtEmptyWeight.Text);

                    model.OverWeight = 0;
                    model.RoomCode = strRoomCode;
                    model.RoomName = strRoomName;
                    model.BangType = strBangType;
                    model.Operator = CoalTraffic.DBUtility.StaticParameter.UserName;

                    model.WeightTime = DateTime.Now;
                    model.RandomCode = CommonMethod.getRandom(4);
                    model.CustomerName = "��úȥ��";
                    model.IsFirstSite = "1";
                    model.TaxType = "�س�������˰";

                    model.FrontImage = strFrontImage;
                    model.BackImage = strBackImage;
                    model.UpImage = strUpImage;
                    model.RoomImage = strRoomImage;
                    model.FrontImageContent = byteFrontImage;

                    model.BackImageContent = byteBackImage;
                    model.UpImageContent = byteUpImage;
                    model.RoomImageContent = byteRoomImage;
                    model.TaxObject = ini.IniReadValue("GFSet", "TaxObject");
                    model.EmptyCode = strEmptyCode;
                    #endregion
                    string isConnection = ini.IniReadValue("Connection", "isConnection");
                    string R = bll.Add(model);
                    if (R != "")
                    {
                        #region �������Ƥ���쳣��ѡ�У����޸ĸ�׼�˿���״̬Ϊ������
                        if (cbLock.Checked == true)
                        {
                            string strUpdateSQL = "update [CoalTraffic].[dbo].[TT_Navicert] set [NavicertState]='4' where [NavicertCode]='" + model.NavicertCode + "'";
                            int result = DbHelperSQL.ExecuteSql(strUpdateSQL);//�����޸�׼�˿�״̬��Ϣ
                            if (isConnection == "0")
                            {
                                mqServer.AddMsmq(mq.AllStation + mq.Prefix + "TT_Navicert" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strUpdateSQL);
                            }
                            else
                            {
                                mq.AddNewSqlText(mq.AllStation + mq.Prefix + "TT_Navicert" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strUpdateSQL);
                            }
                            //#region �ж�ʹ��������Ϣ���䷽���ʹ���
                            //string conType = ini.IniReadValue("Type", "CONType");
                            //if (conType == "MSMQ")//��Ϣ��������
                            //{
                            //    mq.AddNewSqlText(mq.AllStation + mq.Prefix + "TT_Navicert" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strUpdateSQL);
                            //}
                            //else if (conType == "tcp")
                            //{
                            //    string roomid = ini.IniReadValue("RoomSetting", "RoomCode");
                            //    string sqlroomip = "select roomip from tt_room where roomcode='0'";
                            //    DataTable dtip = DbHelperSQL.TQuery(sqlroomip);
                            //    TcpSend tcp = new TcpSend();
                            //    string roomType = ini.IniReadValue("SysInfo", "FormType");
                            //    string roomip = ini.IniReadValue("Connection", "LServer");
                            //    string sql = mq.AllStation + mq.Prefix + "TT_Navicert" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strUpdateSQL;
                            //    tcp.AddNewSqlText(sql, roomType, roomid, roomip,dtip.Rows[0][0].ToString());
                            //}
                            //else
                            //{
                            //    MessageBox.Show("����ͬ��ʧ�ܣ���������ȷ��ͨ��Э������");
                            //}
                            //#endregion
                        }
                        #endregion

                        if (R != "-1")
                        {
                            #region ��ӳɹ���������ͬ��
                            try
                            {

                                string strSql1 = "PT_LoadWeight '" + model.WeightCode + "','" + model.TrafficCode + "','" + model.NavicertCode + "','" + model.MarkedCardCode + "','" + model.RemoteCardCode + "',"
                                 + "'" + model.CollCode + "','" + model.CollName + "','" + model.CoalKindCode + "','" + model.CoalKindName + "','" + model.CarOwnerName + "',"
                                 + "'" + model.CarNo + "','" + model.CarType + "','" + model.LoadWeight + "','" + model.EmptyWeight + "','" + model.NetWeight + "',"
                                 + "'" + model.OverWeight + "','" + model.RoomCode + "','" + model.RoomName + "','" + model.BangType + "','" + model.Operator + "',"
                                 + "'" + model.WeightTime + "','" + model.RandomCode + "','" + model.CustomerName + "','" + model.TaxType + "','" + model.TaxObject + "',"
                                 + "'" + model.IsFirstSite + "','" + model.FrontImage + "','" + model.BackImage + "','" + model.UpImage + "','" + model.RoomImage + "',"
                                 + "null,null,null,null,'" + model.EmptyCode + "'";
                                //isConnection = "0";
                                if (isConnection == "0")
                                {
                                    mqServer.AddMsmq(mq.AllStation + mq.Prefix + "TT_LoadWeight" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strSql1);
                                }
                                else
                                {
                                    mq.AddNewSqlText(mq.AllStation + mq.Prefix + "TT_LoadWeight" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strSql1);//ԭ����ͨ����Ϣ���н��з�����Ϣ
                                }
                                #region �ж�ʹ��������Ϣ���䷽���ʹ���----2013.06.06��д������ɣ����й�
                                //string conType = ini.IniReadValue("Config", "ConType"); //ͨ��Э������
                                //if (conType == "MSMQ")//��Ϣ��������
                                //{
                                //    mq.AddNewSqlText(mq.AllStation + mq.Prefix + "TT_LoadWeight" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strSql);
                                //}
                                //else if (conType == "tcp")
                                //{
                                //    string sqlcontent = "'"+mq.AllStation + mq.Prefix + "TT_LoadWeight" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strSql+"'";
                                //    string roomid = ini.IniReadValue("RoomSetting", "RoomCode");
                                //    string Serverroomip = "select roomip from tt_room where roomcode='0'";
                                //    DataTable dtip = DbHelperSQL.TQuery(Serverroomip);
                                //    //TcpSend tcp = new TcpSend();
                                //    string roomType = ini.IniReadValue("SysInfo", "FormType");
                                //    string roomip = ini.IniReadValue("Connection", "LServer");
                                //    //tcp.AddNewSqlText(mq.AllStation + mq.Prefix + "TT_LoadWeight" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strSql, roomType, roomid, roomip, dtip.Rows[0][0].ToString());
                                //    SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@SqlContent", sqlcontent), new SqlParameter("@RoomType", roomType), new SqlParameter("@FromRoomCode", roomid), new SqlParameter("@ToRoomCode", dtip.Rows[0][0].ToString()), new SqlParameter("@LocalIP", roomip), new SqlParameter("ServerIP", dtip.Rows[0][0].ToString()), new SqlParameter("@SendTime", DateTime.Now.ToString()) };
                                //    //DbHelperSQL.ExecuteSql("insert into dbo.TcpORMsmq (SqlContent, RoomType, FromRoomCode, ToRoomCode, LocalIP, ServerIP, SendTime) values(" + sqlcontent + "," + roomType + "," + roomid + "," + roomip + "," + dtip.Rows[0][0].ToString() + ","+DateTime.Now.ToString()+")");
                                //    DbHelperSQL.ExecuteSql("insert into dbo.TcpORMsmq (SqlContent, RoomType, FromRoomCode, ToRoomCode, LocalIP, ServerIP, SendTime) values(@SqlContent,@RoomType,@FromRoomCode,@ToRoomCode,@LocalIP,@ServerIP,@SendTime)", paras);
                                //}
                                //else
                                //{
                                //    MessageBox.Show("����ͬ��ʧ�ܣ���������ȷ��ͨ��Э������");
                                //}
                                #endregion

                                #region ͬ��ͼƬ��Ϣ��������
                                //����ͼƬ
                                string strIsSendPicToRoom = CoalTraffic.DBUtility.StaticParameter.IsSendPicToRoom;
                                int iSend = mq.ServerStation;
                                //�Ƿ��Ͱ���
                                if (strIsSendPicToRoom == "1")
                                    iSend = mq.CheckStation;
                                string strPic = "";
                                if (model.FrontImageContent != null)
                                {
                                    strPic = iSend + mq.Prefix + "Sys_FileSave" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix
                                        + model.FrontImage + ",jpg," + Convert.ToBase64String(model.FrontImageContent, 0, model.FrontImageContent.Length);
                                    if (isConnection == "0")
                                    {
                                        mqServer.AddMsmq(strPic);
                                    }
                                    else
                                    {
                                        mq.AddNewSqlText(strPic);
                                    }
                                }
                                if (model.BackImageContent != null)
                                {
                                    strPic = iSend + mq.Prefix + "Sys_FileSave" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix
                                        + model.BackImage + ",jpg," + Convert.ToBase64String(model.BackImageContent, 0, model.BackImageContent.Length);
                                    if (isConnection == "0")
                                    {
                                        mqServer.AddMsmq(strPic);
                                    }
                                    else
                                    {
                                        mq.AddNewSqlText(strPic);
                                    }
                                }
                                if (model.UpImageContent != null)
                                {
                                    strPic = iSend + mq.Prefix + "Sys_FileSave" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix
                                        + model.UpImage + ",jpg," + Convert.ToBase64String(model.UpImageContent, 0, model.UpImageContent.Length);
                                    if (isConnection == "0")
                                    {
                                        mqServer.AddMsmq(strPic);
                                    }
                                    else
                                    {
                                        mq.AddNewSqlText(strPic);
                                    }
                                }
                                if (model.RoomImageContent != null)
                                {
                                    strPic = iSend + mq.Prefix + "Sys_FileSave" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix
                                        + model.RoomImage + ",jpg," + Convert.ToBase64String(model.RoomImageContent, 0, model.RoomImageContent.Length);
                                    if (isConnection == "0")
                                    {
                                        mqServer.AddMsmq(strPic);
                                    }
                                    else
                                    {
                                        mq.AddNewSqlText(strPic);
                                    }
                                }
                                #endregion
                                /********************************************************/
                                //Add By ����ӭ ��BSʵʱ��ط�������Ϣ���з����س�������Ϣ
                                /********************************************************/
                                string loadMessage = model.EmptyWeight.ToString() + "," + model.LoadWeight.ToString() + "," + model.NetWeight.ToString() + "," + model.OverWeight.ToString() + "," + model.TaxAmount.ToString() + "," + model.FundAmount.ToString() + "," + model.Operator.ToString() + "," + model.WeightTime.ToString()
                                + "," + model.CarNo.ToString() + "," + model.CarOwnerName.ToString() + "," + model.RoomName.ToString() + "," + model.CollName.ToString() + "," + model.CoalKindName.ToString() + "," +
                                model.NavicertCode.ToString() + "," + model.MarkedCardCode.ToString() + "," + model.RemoteCardCode.ToString() + "," + model.WeightCode.ToString();//������Ϣ��ʽ���ճ�����,�س�����,����,����,˰��,����,������,����ʱ��,���ƺ�,��������,��������,ú������,ú������,׼�˿���,��ʶ����,Զ�̿���,��������
                                RealTimeMonitor monitor = new RealTimeMonitor();//������Ϣ
                                //monitor.SendLoadWeightMessage(loadMessage);//��ʱע�ͣ�������
                                /********************************************************/

                            }
                            catch { }
                            #endregion

                            string strErro = "";
                            if (ini.IniReadValue("RoomSetting", "IsHaveMarkedCard") == "1")
                            {
                                strErro = "�����ձ�ʶ��";
                            }

                            if (ini.IniReadValue("SysInfo", "FormType") == "2")//��Ʊվ
                            {
                                alarmSound.Alarm("�����ɹ�,���ȷ����ӡ�س�������" + strErro + "");
                                CommonMethod.MessageBox("�����ɹ�,���ȷ����ӡ�س�������" + strErro + "!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                            }
                            else//����վ
                            {
                                alarmSound.Alarm("�����ɹ�,���ȷ����ӡ�س�������");
                                CommonMethod.MessageBox("�����ɹ�,���ȷ����ӡ�س�������", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
                            }

                            //�������ó�ر�־λ
                            this.isks = true;

                            #region ��ӡ�������
                            Assembly assembly = System.Reflection.Assembly.GetExecutingAssembly();
                            string strFileName = "";

                            strFileName = CoalTraffic.DBUtility.StaticParameter.ReportFile;

                            Type type = assembly.GetType("CoalTraffic.Report." + strFileName + "LoadWeightPrint");
                            object obj = Activator.CreateInstance(type, strWeightCode, true);
                            Form formToShow = (Form)obj;
                            formToShow.ShowDialog();
                            #endregion

                            #region ������ʾ
                            if (cbLock.Checked == true)
                            {
                                alarmSound.Alarm("�� ׼ �� �� �� �� �� �� ������ �� �� Ʊ վ �� �� �� �� �� ��");
                                MessageBox.Show("�� ׼ �� �� �� �� �� �� ������ �� �� Ʊ վ �� �� �� �� �� ��", "������", MessageBoxButtons.OK, MessageBoxIcon.Information);
                            }
                            #endregion

                        }
                        else
                        {
                            alarmSound.Alarm("�˻�����Ѳ��㱾���Ŀۿ��֪ͨ" + cmbCollName.Text.Trim() + "��������");
                        }
                    }
                    else
                    {
                        if (isConnection == "0")
                        {
                            //ini.IniWriteValue("Connection", "isConnection", CommonMethod.ToDBC("1"));
                            //MessageBox.Show("ϵͳ��������Ͽ����ӣ������µ�½ϵͳ��");
                            MessageBox.Show("ϵͳ��������Ͽ����ӣ�����ϵ���Ļ�����");
                            Application.ExitThread();
                            Application.Exit();
                        }
                        else
                        {
                            this.alarmSound.Alarm("��վ�����ݿ��쳣");
                            InsertState = 0;
                            InsertBadReCordInfo("�쳣", txtCarNo.Text.Trim(), strRoomName + "�����ݿ��쳣");
                        }

                    }
                }

                #region ���ݷ���ֵ��ú������жϣ��ܷ���й���
                else if (strLeastValue == "1")
                {
                    alarmSound.Alarm("ú������������,���ܼ�������");
                }
                else if (strLeastValue == "2")
                {
                    alarmSound.Alarm("��ú��������ú��,���ܼ�������");
                    InsertState = 0;
                    InsertBadReCordInfo("�쳣", txtCarNo.Text.Trim(), strCollName + "������" + strCoalKindName);
                }
                else if (strLeastValue == "-1")
                {
                    alarmSound.Alarm("��ú�󲻴���,���ܼ�������");
                    InsertState = 0;
                    InsertBadReCordInfo("�쳣", txtCarNo.Text.Trim(), "���Ϊ��" + strCollCode + "��ú�󲻴���");
                }
                #endregion

                btnOK.Enabled = false;
                ClearAll();
                //if (StaticParameter.CardType == "IC")
                //    icCard.FactoryCodeInitValue = "";
            }
            else
            {
                alarmSound.Alarm("ú̿�����쳣");
                InsertState = 0;
                InsertBadReCordInfo("�쳣", txtCarNo.Text.Trim(), "���ƺ�Ϊ��" + txtCarNo.Text.Trim() + "������ú̿�����쳣");
            }
        }
コード例 #2
0
 private void lblDigital_TextChanged(object sender, EventArgs e)
 {
     string IsNorBang = ini.IniReadValue("BcComSetting", "IsNorBang");
     if (IsNorBang == "1")
     {
         RealTimeMonitor monitor = new RealTimeMonitor();
         monitor.SendBangChengMessage(lblDigital.Text);
     }
 }