private void btnOK_Click(object sender, EventArgs e)
{
CoalTraffic.Model.TT_EmptyWeight model = new CoalTraffic.Model.TT_EmptyWeight();
if (txtCarNo.Text.Trim() != "" && txtCarOwnerName.Text.Trim() != "" && txtCarOwnerPhone.Text.Trim() != "" && txtCarOwnerIDCard.Text.Trim() != "" && lblDigital.Text.Trim() != "0.00")
{
if (txtCarOwnerIDCard.Text.Trim().Length == 15 || txtCarOwnerIDCard.Text.Trim().Length == 18)
{
if (CommonMethod.isValidICCard(CommonMethod.ToDBC(txtCarOwnerIDCard.Text.Trim())))
{
if (RbLoadWeight.Checked)
{
decimal DLimitWeight = decimal.Parse(ini.IniReadValue("RoomSetting", "WeightThreshold"));
decimal DOverWeight = 0.00m;
if (strCurrentMenu != "Person")
{
DOverWeight = Math.Abs(Convert.ToDecimal(lblDigital.Text.Trim()) - Convert.ToDecimal(txtEmptyWeight.Text.Trim()));
}
else
{
#region 验证数据的正确性
if (txtManDigital.Text.Trim() != "" && CommonMethod.IsDecimal(CommonMethod.ToDBC(txtManDigital.Text.Trim())))
{
if (Convert.ToDecimal(CommonMethod.ToDBC(txtManDigital.Text.Trim())) >= Convert.ToDecimal(lblDigital.Text.Trim()))
{
DOverWeight = Math.Abs(Convert.ToDecimal(CommonMethod.ToDBC(txtManDigital.Text.Trim())) - Convert.ToDecimal(txtEmptyWeight.Text.Trim()));
}
else
{
alarmSound.Alarm("你输入的重车重量不能小于磅秤重量");
txtManDigital.Text = "";
return;
}
}
else
{
alarmSound.Alarm("你输入的重车重量格式不对");
txtManDigital.Text = "";
return;
}
#endregion
}
if (DOverWeight > DLimitWeight)
{
alarmSound.Alarm("空车重量异常，该车辆可能改装");
InsertState = 0;
InsertBadReCordInfo("异常", txtCarNo.Text.Trim(), "车牌号为：" + txtCarNo.Text.Trim() + "车辆的空车重量异常，该车辆登记时重量为:" + txtEmptyWeight.Text.Trim() + "现在重量为:" + txtManDigital.Text.Trim() + "");
return;
}
}
#region 空车过磅实体
model.BangTime = DateTime.Now;
model.BangType = strBangType;
model.CarCode = strCarCode;
model.EmptyCode = strRoomCode + DateTime.Now.ToString("yyyyMMddHHmmss");
if (strBangType == "自动")
{
model.EmptyWeight = Convert.ToDecimal(this.lblDigital.Text);
}
else
{
model.EmptyWeight = Convert.ToDecimal(CommonMethod.ToDBC(this.txtManDigital.Text.Trim()));
}
if (StaticParameter.IsVideo == "1")
{
if (byteFrontImage == null)
{
strFrontImage = Guid.NewGuid().ToString().Replace("-", "");
byteFrontImage = this.dHVideo.CapturePic();
}
model.FrontImage = strFrontImage;
model.FrontImageContent = byteFrontImage;
}
else
{
model.FrontImage = "";
model.FrontImageContent = null;
}
model.NavicertCode = strNavicertCode;
model.Operator = StaticParameter.UserName;
model.RemoteCardCode = strReadRemoteCode;
model.RoomCode = strRoomCode;
model.Carno = CommonMethod.ToDBC(txtCarNo.Text.Trim());
model.Caronername = CommonMethod.ToDBC(txtCarOwnerName.Text.Trim());
model.CarowneridCard = CommonMethod.ToDBC(txtCarOwnerIDCard.Text.Trim());
model.Carownerphone = CommonMethod.ToDBC(txtCarOwnerPhone.Text.Trim());
model.Randomcode = CommonMethod.getRandom(4);
#endregion
string strEmptyCode = bll.Add(model);
if (strEmptyCode != "")
{
alarmSound.Alarm("空车过磅成功");
CommonMethod.MessageBox("空车过磅成功!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//冯磊 2010-05-13 屏蔽了空车过磅打印功能
//alarmSound.Alarm("空车过磅成功，点击确定打印空车过磅单");
//CommonMethod.MessageBox("空车过磅成功，点击确定打印空车过磅单!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
//Assembly assembly = System.Reflection.Assembly.GetExecutingAssembly();
//string strFileName = "";
//if (StaticParameter.ReportFile == "FuYuan.")
//{
// strFileName = "ZiChang.";
//}
//else
//{
// strFileName = StaticParameter.ReportFile;
//}
//Type type = assembly.GetType("CoalTraffic.Report." + strFileName + "EmptyWeightPrintByEmpty");
//object obj = Activator.CreateInstance(type, strEmptyCode, true); Form formToShow = (Form)obj; formToShow.ShowDialog();
#region 将数据上传到服务器
try
{
//CoalTraffic.DBUtility.MSMQClient mq = new MSMQClient();
string strSql = "PT_EmptyWeight '" + model.EmptyCode + "','" + model.CarCode + "','" + model.RemoteCardCode
+ "','" + model.NavicertCode + "','" + model.EmptyWeight + "','" + model.BangType + "','"
+ model.RoomCode + "','" + model.FrontImage + "','" + model.Operator + "','" + model.BangTime
+ "',null,'" + model.Carno + "','" + model.Caronername + "','" + model.CarowneridCard
+ "','" + model.Carownerphone + "','" + model.Randomcode + "'";
MC.AddNewSqlText(MC.AllStation + MC.Prefix + "TT_EmptyWeight" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix + strSql);
//发送图片
string strIsSendPicToRoom = StaticParameter.IsSendPicToRoom;
int iSend = MC.ServerStation;
//是否发送磅房
if (strIsSendPicToRoom == "1")
iSend = MC.AllStation;
string strPic = "";
if (model.FrontImageContent != null)
{
strPic = iSend + MC.Prefix + "Sys_FileSave" + MC.Prefix + MC.AddFlg + MC.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + MC.Prefix
+ model.FrontImage + ",jpg," + Convert.ToBase64String(model.FrontImageContent, 0, model.FrontImageContent.Length);
MC.AddNewSqlText(strPic);
}
/********************************************************/
//Add By 鲍永迎 向BS实时监控服务器消息队列发送空车过磅消息
/********************************************************/
string strRoomName = ini.IniReadValue("RoomSetting", "RoomName");
string emptyMessage = strRoomName + "," + model.CarCode + "," + model.NavicertCode + "," + model.EmptyWeight.ToString() + "," + model.BangTime.ToString();//定义消息格式：磅房名称,车辆信息编号，准运卡号，空车重量，过磅时间
RealTimeMonitor monitor = new RealTimeMonitor();//发送消息
monitor.SendEmptyWeightMessage(emptyMessage);
/********************************************************/
}
catch { }
#endregion
ClearAllControls();
ClearUserControl();
}
else
{
alarmSound.Alarm("该站的数据库异常");
InsertState = 0;
InsertBadReCordInfo("异常", txtCarNo.Text.Trim(), ini.IniReadValue("RoomSetting", "RoomName") + "的数据库异常");
}
}
else
{
alarmSound.Alarm("你输入的车主身份证号格式不正确");
}
}
else
{
alarmSound.Alarm("你输入的车主身份证号长度不正确");
}
}
else
{
alarmSound.Alarm("请确保信息的完整性");
}
}
private void btnOK_Click(object sender, EventArgs e)
{
CoalTraffic.Model.TT_EmptyWeight model = new CoalTraffic.Model.TT_EmptyWeight();
if (txtCarNo.Text.Trim() != "" && txtCarOwnerName.Text.Trim() != "" && txtCarOwnerPhone.Text.Trim() != "" && txtCarOwnerIDCard.Text.Trim() != "" && lblDigital.Text.Trim() != "0.00")
{
if (txtCarOwnerIDCard.Text.Trim().Length == 15 || txtCarOwnerIDCard.Text.Trim().Length == 18)
{
if (CommonMethod.isValidICCard(CommonMethod.ToDBC(txtCarOwnerIDCard.Text.Trim())))
{
if (RbLoadWeight.Checked)
{
decimal DLimitWeight = decimal.Parse(ini.IniReadValue("RoomSetting", "WeightThreshold"));
decimal DOverWeight = 0.00m;
if (strCurrentMenu != "Person")
{
DOverWeight = Math.Abs(Convert.ToDecimal(lblDigital.Text.Trim()) - Convert.ToDecimal(txtEmptyWeight.Text.Trim()));
}
else
{
#region ��֤���ݵ���ȷ��
if (txtManDigital.Text.Trim() != "" && CommonMethod.IsDecimal(CommonMethod.ToDBC(txtManDigital.Text.Trim())))
{
if (Convert.ToDecimal(CommonMethod.ToDBC(txtManDigital.Text.Trim())) >= Convert.ToDecimal(lblDigital.Text.Trim()))
{
DOverWeight = Math.Abs(Convert.ToDecimal(CommonMethod.ToDBC(txtManDigital.Text.Trim())) - Convert.ToDecimal(txtEmptyWeight.Text.Trim()));
}
else
{
alarmSound.Alarm("��������س���������С�ڰ�������");
txtManDigital.Text = "";
return;
}
}
else
{
alarmSound.Alarm("��������س�������ʽ����");
txtManDigital.Text = "";
return;
}
#endregion
}
if (DOverWeight > DLimitWeight)
{
alarmSound.Alarm("�ճ������쳣���ó������ܸ�װ");
InsertState = 0;
InsertBadReCordInfo("�쳣", txtCarNo.Text.Trim(), "���ƺ�Ϊ��" + txtCarNo.Text.Trim() + "�����Ŀճ������쳣���ó����Ǽ�ʱ����Ϊ:" + txtEmptyWeight.Text.Trim() + "��������Ϊ:" + txtManDigital.Text.Trim() + "");
return;
}
}
#region �ճ�����ʵ��
model.BangTime = DateTime.Now;
model.BangType = strBangType;
model.CarCode = strCarCode;
model.EmptyCode = strRoomCode + DateTime.Now.ToString("yyyyMMddHHmmss");
if (strBangType == "�Զ�")
{
model.EmptyWeight = Convert.ToDecimal(this.lblDigital.Text);
}
else
{
model.EmptyWeight = Convert.ToDecimal(CommonMethod.ToDBC(this.txtManDigital.Text.Trim()));
}
if (StaticParameter.IsVideo == "1")
{
if (byteFrontImage == null)
{
strFrontImage = Guid.NewGuid().ToString().Replace("-", "");
byteFrontImage = this.dHVideo.CapturePic();
}
model.FrontImage = strFrontImage;
model.FrontImageContent = byteFrontImage;
}
else
{
model.FrontImage = "";
model.FrontImageContent = null;
}
model.NavicertCode = strNavicertCode;
model.Operator = StaticParameter.UserName;
model.RemoteCardCode = strReadRemoteCode;
model.RoomCode = strRoomCode;
model.Carno = CommonMethod.ToDBC(txtCarNo.Text.Trim());
model.Caronername = CommonMethod.ToDBC(txtCarOwnerName.Text.Trim());
model.CarowneridCard = CommonMethod.ToDBC(txtCarOwnerIDCard.Text.Trim());
model.Carownerphone = CommonMethod.ToDBC(txtCarOwnerPhone.Text.Trim());
model.Randomcode = CommonMethod.getRandom(4);
#endregion
string isConnection = ini.IniReadValue("Connection", "isConnection");
string strEmptyCode = bll.Add(model);
#region ��������ʱ������ͬ��sql��䵽��������sql��䱾��ִ��
if (isConnection == "0")
{
string Sql = "PT_EmptyWeight '" + model.EmptyCode + "','" + model.CarCode + "','" + model.RemoteCardCode
+ "','" + model.NavicertCode + "','" + model.EmptyWeight + "','" + model.BangType + "','"
+ model.RoomCode + "','" + model.FrontImage + "','" + model.Operator + "','" + model.BangTime
+ "',null,'" + model.Carno + "','" + model.Caronername + "','" + model.CarowneridCard
+ "','" + model.Carownerphone + "','" + model.Randomcode + "'";
string sqlInsertLog = "insert [NetWorkDisconnectionLog] (ID, SQLcontext, datetime, IP) values (@ID,@SQLcontext,@datetime,@IP)";
SqlParameter[] sqlpars = new SqlParameter[]
{
new SqlParameter("@ID",DateTime.Now.ToString("yyyyMMddHHmmss")),
new SqlParameter("@SQLcontext",Sql.ToString()),
new SqlParameter("@datetime",DateTime.Now.ToString()),
new SqlParameter("@IP",ini.IniReadValue("Connection","LServer"))
};
DbHelperSQL.ExecuteSql(sqlInsertLog,sqlpars); //����ͬ��sql���
DbHelperSQL.ExecuteSql2(Sql.ToString(), "1");//sql��䱾��ִ��
}
#endregion
if (strEmptyCode != "")
{
alarmSound.Alarm("�ճ������ɹ�");
CommonMethod.MessageBox("�ճ������ɹ�!", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
#region ����ʱ����ӿճ�����sql���
try
{
string Sql = "PT_EmptyWeight '" + model.EmptyCode + "','" + model.CarCode + "','" + model.RemoteCardCode
+ "','" + model.NavicertCode + "','" + model.EmptyWeight + "','" + model.BangType + "','"
+ model.RoomCode + "','" + model.FrontImage + "','" + model.Operator + "','" + model.BangTime
+ "',null,'" + model.Carno + "','" + model.Caronername + "','" + model.CarowneridCard
+ "','" + model.Carownerphone + "','" + model.Randomcode + "'";
if (isConnection == "1")
{
string id = DateTime.Now.ToString("yyyyMMddHHmmss");
StringBuilder sbsqlcontext = new StringBuilder();
sbsqlcontext.Append("insert into NetWorkDisconnection (ID, SQLcontext, DateTime) values(@id,@sqlcontext,@datetime)");
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@id",id),
new SqlParameter("@sqlcontext",Sql.ToString()),
new SqlParameter("@datetime",DateTime.Now)
};
DbHelperSQL.ExecuteSql(sbsqlcontext.ToString(), parameters);
}
}
catch { }
#endregion
ClearAllControls();
ClearUserControl();
}
else
{
if (isConnection == "0")
{
ini.IniWriteValue("Connection", "isConnection", CommonMethod.ToDBC("1"));
MessageBox.Show("ϵͳ��������Ͽ����ӣ�����ϵ���Ļ�����");
Application.ExitThread();
Application.Exit();
}
else
{
alarmSound.Alarm("��վ�����ݿ��쳣");
InsertState = 0;
InsertBadReCordInfo("�쳣", txtCarNo.Text.Trim(), ini.IniReadValue("RoomSetting", "RoomName") + "�����ݿ��쳣");
}
}
}
else
{
alarmSound.Alarm("������ij������֤�Ÿ�ʽ����ȷ");
}
}
else
{
alarmSound.Alarm("������ij������֤�ų��Ȳ���ȷ");
}
}
else
{
alarmSound.Alarm("��ȷ����Ϣ��������");
}
}
