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() + "������ú̿�����쳣"); } }
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); } }