/// <summary> /// 开始初始化 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSend_Click(object sender, EventArgs e) { if (strNewMarkedCode == "") { alarmSound.Alarm("请刷卡"); MessageBox.Show("请刷卡","天大天科",MessageBoxButtons.OK,MessageBoxIcon.Error); return; } CoalTraffic.Model.TT_InitialCard model = new CoalTraffic.Model.TT_InitialCard(); model.CardID = strNewFactoryCode.TrimEnd('|'); model.CardNO = strNewMarkedCode.TrimEnd('|'); model.CardType = "1"; //model.InitialTime = DateTime.Parse(txtEditTime.Text); model.InitialTime = DateTime.Now; model.IntialPerson = txtOperator.Text; if (bll.Add(strNewFactoryCode.TrimEnd('|'), strNewMarkedCode.TrimEnd('|'), model)) { #region 数据同步到各磅房---注释了消息队列发送语句 StringBuilder strAll = new StringBuilder(); string[] cardno = null; string[] cardcode = null; int i = 0; string strNewMarkedCardNo = strNewFactoryCode.TrimEnd('|'); string strNewMarkedCardCode = strNewMarkedCode.TrimEnd('|'); if (strNewMarkedCardNo != "") { //对数据库中没有的卡号,添加记录 cardno = strNewFactoryCode.Split('|'); cardcode = strNewMarkedCode.Split('|'); for (i = 0; i < cardno.Length; i++) { strAll.Append("insert into TT_InitialCard("); strAll.Append("CardID,CardNO,CardType,InitialTime,IntialPerson)"); strAll.Append(" values ("); strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CardType + "','" + model.InitialTime + "','" + model.IntialPerson + "');"); //往标识卡记录表里添加记录(数据不需要往下同步) } } MsmqManage mq = new MsmqManage(); string strMq = mq.AllStation + mq.Prefix + "TT_InitialCard" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strAll.ToString(); //mq.AddMsmq(strMq.ToString()); #endregion strNewFactoryCode = ""; strNewMarkedCode = ""; this.txtAdded.Text = "0"; this.txtActiveCount.Text = "100"; this.txtMarkedCode.Text = ""; alarmSound.Alarm("初始化成功!"); AlarmText.Text = "初始化成功!"; //MessageBox.Show("初始化成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { alarmSound.Alarm("初始化失败!"); AlarmText.Text = "初始化失败!"; //MessageBox.Show("初始化失败", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// 得到一个对象实体 /// </summary> public CoalTraffic.Model.TT_InitialCard GetModel(string CardID, string CardNO, string CardType, DateTime InitialTime, string IntialPerson) { StringBuilder strSql = new StringBuilder(); strSql.Append("select CardID,CardNO,CardType,InitialTime,IntialPerson from TT_InitialCard "); strSql.Append(" where CardID=@CardID and CardNO=@CardNO and CardType=@CardType and InitialTime=@InitialTime and IntialPerson=@IntialPerson "); SqlParameter[] parameters = { new SqlParameter("@CardID", SqlDbType.VarChar,50), new SqlParameter("@CardNO", SqlDbType.VarChar,50), new SqlParameter("@CardType", SqlDbType.Char,50), new SqlParameter("@InitialTime", SqlDbType.DateTime), new SqlParameter("@IntialPerson", SqlDbType.NVarChar,50)}; parameters[0].Value = CardID; parameters[1].Value = CardNO; parameters[2].Value = CardType; parameters[3].Value = InitialTime; parameters[4].Value = IntialPerson; CoalTraffic.Model.TT_InitialCard model = new CoalTraffic.Model.TT_InitialCard(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.CardID = ds.Tables[0].Rows[0]["CardID"].ToString(); model.CardNO = ds.Tables[0].Rows[0]["CardNO"].ToString(); model.CardType = ds.Tables[0].Rows[0]["CardType"].ToString(); if (ds.Tables[0].Rows[0]["InitialTime"].ToString() != "") { model.InitialTime = DateTime.Parse(ds.Tables[0].Rows[0]["InitialTime"].ToString()); } model.IntialPerson = ds.Tables[0].Rows[0]["IntialPerson"].ToString(); return model; } else { return null; } }