/// <summary>
///
/// </summary>
private void ReadICCard()
{
try
{
SendUIMsg(UIMsg.Display, "正在获取IC卡设备信息(请插入IC卡)，请稍后......");
InterfaceClass.HN.PublicFunctions.Card card = new InterfaceClass.HN.PublicFunctions.Card();
InterfaceClass.HN.PublicFunctions.ICCard icCard = new InterfaceClass.HN.PublicFunctions.ICCard(baseInterfaceHN);
card = icCard.ReadICCard();
SaveICCardInfo(card);
Parameter parameter = new Parameter(ReadCardUIMsg.setICCaradInfo, card);
SendUIMsg(ReadCardUIMsg.setICCaradInfo, parameter);
SendUIMsg(UIMsg.Close);
this._CardNumbers = card.CardNo;
SendUIMsg(ReadCardUIMsg.closeReadCard);
}
catch (Exception ex)
{
SendUIMsg(UIMsg.Close);
SendUIMsg(UIMsg.MsgError, ex.Message);
}
}
/// <summary>
///
/// </summary>
/// <param name="card"></param>
private void SetICCardInfo(InterfaceClass.HN.PublicFunctions.Card card)
{
this.txtBox_CardNo.Text = card.CardNo;
this.txtBox_CenterID.Text = card.CenterID;
this.txtBox_IndiID.Text = card.IndiID;
this.txtBox_InsrCode.Text = card.InsrCode;
this.txtBox_Birthday.Text = card.Birthday;
this.txtBox_Name.Text = card.Name;
this.txtBox_PersType.Text = card.PersType.ToString().Trim();
this.txtBox_Idcard.Text = card.Idcard;
this.txtBox_Sex.Text = card.Sex.ToString().Trim();
this.txtBox_IndiSta.Text = card.IndiSta.ToString().Trim();
this.txtBox_OfficialCode.Text = card.OfficialCode;
this.txtBox_TotalSalary.Text = card.TotalSalary.ToString().Trim();
this.txtBox_CorpID.Text = card.CorpID;
this.txtBox_CorpName.Text = card.CorpName;
this.txtBox_CorpCode.Text = card.CorpCode;
this.txtBox_CorpStaCode.Text = card.CorpStaCode;
this.txtBox_LastBalance.Text = card.LastBalance.ToString().Trim();
}
/// <summary>
/// 存储IC卡信息
/// </summary>
/// <param name="card"></param>
private void SaveICCardInfo(InterfaceClass.HN.PublicFunctions.Card card)
{
try
{
string unitName = string.Empty;
string userName = string.Empty;
QueryAndSetUserInfo(this._userID, ref unitName, ref userName);
string SQLString = string.Format(@"IF NOT EXISTS ( SELECT *
FROM HIS_InterfaceHN.dbo.ICInfo
WHERE card_no = N'{0}' )
BEGIN
INSERT INTO [HIS_InterfaceHN].[dbo].[ICInfo]
( [card_no] ,
[center_id] ,
[indi_id] ,
[insr_code] ,
[birthday] ,
[name] ,
[pers_type] ,
[idcard] ,
[sex] ,
[indi_sta] ,
[official_code] ,
[total_salary] ,
[corp_id] ,
[corp_name] ,
[corp_code] ,
[corp_sta_code] ,
[last_balance]
)
VALUES (N'{0}'--, nvarchar(50),>
,N'{1}'--, nvarchar(10),>
,N'{2}'--, nvarchar(12),>
,N'{3}'--, nvarchar(20),>
,N'{4}'--, datetime,>
,N'{5}'--, nvarchar(20),>
,N'{6}'--, nvarchar(2),>
,N'{7}'--, nvarchar(18),>
,N'{8}'--, char(1),>
,N'{9}'--, char(1),>
,N'{10}'--, nvarchar(3),>
,N'{11}'--, numeric(18,4),>
,N'{12}'--, nvarchar(12),>
,N'{13}'--, nvarchar(100),>
,N'{14}'--, nvarchar(20),>
,N'{15}'--, char(1),>
,N'{16}'--, numeric(18,4),>
,N'{17}'--, nvarchar(50),>
,GETDATE()--, datetime,>
);
END
INSERT INTO HIS_InterfaceHN.dbo.ICInfoLogin
( card_no, LoginUser, LoginTime )
VALUES ( N'{0}', -- card_no - nvarchar(50)
N'{18}', -- LoginUser - nvarchar(50)
getdate() -- LoginTime - datetime
);", card.CardNo, card.CenterID, card.IndiID, card.InsrCode, card.Birthday, card.Name, card.PersType, card.Idcard, card.Sex,
card.IndiSta, card.OfficialCode, card.TotalSalary, card.CorpID, card.CorpName, card.CorpStaCode, card.LastBalance, userName);
int temp = Alif.DBUtility.DbHelperSQL.ExecuteSql(SQLString);
if (temp == 1)
{
SendUIMsg(UIMsg.WriteMsg, "成功保存IC卡信息！！！");
return;
}
}
catch (Exception ex)
{
throw new Exception("存储IC卡信息失败,失败原因：" + ex.Message);
}
}
