private void btnSend_Click(object sender, EventArgs e)
{
if (arraylist.Count <= 0)
{
alarmSound.Alarm("请 刷 标 识 卡");
txtMarkedCode.Text = "";
return;
}
else
{
CoalTraffic.Model.TT_MarkedCard model = new CoalTraffic.Model.TT_MarkedCard();
model.MarkedCardState = "0";//标示卡验证状态
StringBuilder strAll = new StringBuilder();
for (int i = 0; i < arraylist.Count; i++)
{
#region 验证标识卡
strAll.Append("update TT_MarkedCard set ");
strAll.Append("MarkedCardState='0'");
strAll.Append(" where MarkedCardCode='" + arraylist[i] + "';");
#endregion
}
int sucess = DbHelperSQL.ExecuteSql(strAll.ToString());
if (sucess > 0)
{
alarmSound.Alarm("验 证 卡 成 功");
skNumber = 0;
txtAdded.Text = "0";
arraylist.Clear();//清空集合
txtMarkedCode.Select();
txtMarkedCode.ReadOnly = false;
}
}
}
/// <summary>
/// 激活卡事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSend_Click(object sender, EventArgs e)
{
if (arraylist.Count <=0)
{
alarmSound.Alarm("请 刷 标 识 卡");
txtMarkedCode.Text = "";
return;
}
else
{
CoalTraffic.Model.TT_MarkedCard model = new CoalTraffic.Model.TT_MarkedCard();
model.CoalKindCode = this.cbxCoalKind.SelectedValue.ToString();//煤矿种类编号
model.CollCode = this.cbxColl.SelectedValue.ToString();//煤矿编号
model.DepartName = this.txtDepartName.Text.Trim();//部门名称
model.Operator = this.txtOperator.Text.Trim();//操作人
model.MarkedCardState = "1";//标示卡状态
//model.MarkedCardNo = skMarkedCardNO;//标示卡内码
//model.MarkedCardCode = skMarkedCardNO;//标示卡外码
model.SendCardDate = DateTime.Now;//刷卡时间
StringBuilder strAll = new StringBuilder();
for (int i = 0; i < arraylist.Count; i++)
{
#region 更新购买卡表
strAll.Append("update TT_MarkedCard set ");
strAll.Append("CollCode='" + model.CollCode + "',");
strAll.Append("CoalKindCode='" + model.CoalKindCode + "',");
strAll.Append("MarkedCardState='1',");
strAll.Append("SendCardDate='" + model.SendCardDate + "',");
strAll.Append("Operator='" + model.Operator + "',");
strAll.Append("DepartName='" + model.DepartName + "'");
strAll.Append(" where MarkedCardCode='" + arraylist[i] + "'");
#endregion
#region 插入发卡记录表
strAll.Append("insert into TT_MarkedCardSendRecord(");
strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,SendCardDate,Operator,DepartName,SendType)");
strAll.Append(" values (");
strAll.Append("'" + arraylist[i] + "','" + arraylist[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "','激活');");
#endregion
}
int sucess = DbHelperSQL.ExecuteSql(strAll.ToString());
if (sucess > 0)
{
alarmSound.Alarm("发 卡 成 功");
skNumber = 0;
txtAdded.Text = "0";
arraylist.Clear();//清空集合
txtMarkedCode.Select();
txtMarkedCode.ReadOnly = false;
}
}
}
private void btnSend_Click(object sender, EventArgs e)
{
if (strFactoryCode == "")
{
alarmSound.Alarm("请刷标识卡");
return;
}
strFactoryCode = commclass.SCardNo;
strMarkedCode = commclass.SCardCode;
CoalTraffic.Model.TT_MarkedCard model = new CoalTraffic.Model.TT_MarkedCard();
model.CoalKindCode = this.cbxCoalKind.SelectedValue.ToString();
model.CollCode = this.cbxColl.SelectedValue.ToString();
model.DepartName = this.txtDepartName.Text.Trim();
model.Operator = this.txtOperator.Text.Trim();
model.MarkedCardState = "1";
model.MarkedCardNo = strFactoryCode.TrimEnd('|');
model.MarkedCardCode = strMarkedCode.TrimEnd('|');
model.SendCardDate = DateTime.Now;
if (bll.Update(model))
{
List<string> list=new List<string>();
list.Add(this.cbxColl.Text);
list.Add(this.cbxCoalKind.Text);
list.Add(this.txtAdded.Text.Trim());
list.Add(this.txtOperator.Text);
list.Add(model.SendCardDate.ToString());
list.Add(this.txtDepartName.Text);
alarmSound.Alarm("标识卡激活成功,正在打印激活单据");
new Report.MarkedCardPrint(list, "激活").ShowDialog();
btnReset_Click(sender, e);
}
else
alarmSound.Alarm("标识卡激活失败!");
}
private void btnSend_Click(object sender, EventArgs e)
{
strFactoryCode = commclass.SCardNo;
strMarkedCode = commclass.SCardCode;
if (strFactoryCode == "")
{
alarmSound.Alarm("请刷标识卡");
return;
}
CoalTraffic.Model.TT_MarkedCard model = new CoalTraffic.Model.TT_MarkedCard();
model.CoalKindCode = this.cbxCoalKind.SelectedValue.ToString();
model.CollCode = this.cbxColl.SelectedValue.ToString();
model.DepartName = this.txtDepartName.Text.Trim();
model.Operator = this.txtOperator.Text.Trim();
model.MarkedCardState = "1";
model.MarkedCardNo = strFactoryCode.TrimEnd('|');
model.MarkedCardCode = strMarkedCode.TrimEnd('|');
model.SendCardDate = DateTime.Now;
if (bll.Update(model))
{
#region 数据同步到各磅房
string[] cardno = model.MarkedCardNo.Split('|');
string[] cardcode = model.MarkedCardCode.Split('|');
StringBuilder strAll = new StringBuilder("");
int i = 0;
//更新已有的卡
for (i = 0; i < cardno.Length; i++)
{
strAll.Append("update TT_MarkedCard set ");
strAll.Append("CollCode='" + model.CollCode + "',");
strAll.Append("CoalKindCode='" + model.CoalKindCode + "',");
strAll.Append("MarkedCardState='1',");
strAll.Append("SendCardDate='" + model.SendCardDate + "',");
strAll.Append("Operator='" + model.Operator + "',");
strAll.Append("DepartName='" + model.DepartName + "'");
strAll.Append(" where MarkedCardCode='" + cardcode[i] + "';");
//往标识卡记录表里添加记录（数据不需要往下同步）
}
MsmqManage mq = new MsmqManage();
string strMq = mq.AllStation + mq.Prefix + "TT_MarkedCard" + mq.Prefix + mq.EditFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strAll.ToString();
mq.AddMsmq(strMq.ToString());
//mq.AddMsmq(strAll.ToString());
#endregion
//保存打印信息
List<string> list = new List<string>();
list.Add(this.cbxColl.Text);
list.Add(this.cbxCoalKind.Text);
list.Add(this.txtAdded.Text.Trim());
list.Add(this.txtOperator.Text);
list.Add(model.SendCardDate.ToString());
list.Add(this.txtDepartName.Text);
strFactoryCode = "";
strMarkedCode = "";
this.txtAdded.Text = "0";
this.txtMarkedCode.Text = "";
SetActiveCount();
new Report.MarkedCardPrint(list, "激活").ShowDialog();
}
else
alarmSound.Alarm("标识卡激活失败!");
//对目前类中的数据进行初始化
clearCommclass();
}
private void btnSend_Click(object sender, EventArgs e)
{
if (strFactoryCode == "")
{
alarmSound.Alarm("请刷标识卡");
return;
}
CoalTraffic.Model.TT_MarkedCard model = new CoalTraffic.Model.TT_MarkedCard();
model.CoalKindCode = this.cbxCoalKind.SelectedValue.ToString();
model.CollCode = this.cbxColl.SelectedValue.ToString();
model.DepartName = this.txtDepartName.Text.Trim();
model.Operator = this.txtOperator.Text.Trim();
model.MarkedCardState = "1";
model.MarkedCardNo = strExistFactoryCode.TrimEnd('|');
model.MarkedCardCode = strExistMarkedCode.TrimEnd('|');
model.SendCardDate = DateTime.Now;
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 (model.MarkedCardNo != "")
{
cardno = model.MarkedCardNo.Split('|');
cardcode = model.MarkedCardCode.Split('|');
for (i = 0; i < cardno.Length; i++)
{
strAll.Append("update TT_MarkedCard set ");
strAll.Append("CollCode='" + model.CollCode + "',");
strAll.Append("CoalKindCode='" + model.CoalKindCode + "',");
strAll.Append("MarkedCardState='1',");
strAll.Append("SendCardDate='" + model.SendCardDate + "',");
strAll.Append("Operator='" + model.Operator + "',");
strAll.Append("DepartName='" + model.DepartName + "'");
strAll.Append(" where MarkedCardCode='" + cardcode[i] + "';");
//往标识卡记录表里添加记录（数据不需要往下同步）
}
}
if (strNewMarkedCardNo != "")
{
//对数据库中没有的卡号，添加记录
cardno = strNewMarkedCardNo.Split('|');
cardcode = strNewMarkedCardCode.Split('|');
for (i = 0; i < cardno.Length; i++)
{
strAll.Append("insert into TT_MarkedCard(");
strAll.Append("MarkedCardNo,MarkedCardCode,CollCode,CoalKindCode,MarkedCardState,SendCardDate,Operator,DepartName)");
strAll.Append(" values (");
strAll.Append("'" + cardno[i] + "','" + cardcode[i] + "','" + model.CollCode + "','" + model.CoalKindCode + "','1','" + model.SendCardDate + "','" + model.Operator + "','" + model.DepartName + "');");
//往标识卡记录表里添加记录（数据不需要往下同步）
}
}
MsmqManage mq = new MsmqManage();
string strMq = mq.AllStation + mq.Prefix + "TT_MarkedCard" + mq.Prefix + mq.AddFlg + mq.Prefix + DateTime.Now.ToString("yyyy-MM-dd hh:mm;ss") + mq.Prefix + strAll.ToString();
mq.AddMsmq(strMq.ToString());//通过消息队列将数据上传到服务器
#endregion
List<string> list=new List<string>();
list.Add(this.cbxColl.Text);
list.Add(this.cbxCoalKind.Text);
list.Add(this.txtAdded.Text.Trim());
list.Add(this.txtOperator.Text);
list.Add(model.SendCardDate.ToString());
list.Add(this.txtDepartName.Text);
//清空数据，使其可以刷另一张卡
strNewFactoryCode = "";
strNewMarkedCode = "";
strFactoryCode = "";
strExistFactoryCode = "";
strExistMarkedCode = "";
this.txtAdded.Text = "0";
this.txtBuyCount.Text = "10";
this.txtMarkedCode.Text = "";
alarmSound.Alarm("标识卡发放成功,即将打印购买凭证!");
new Report.MarkedCardPrint(list, "购买").ShowDialog();
}
else
alarmSound.Alarm("标识卡发放失败!");
}
