public void LicenseRequest_Can_Seperate_DataRowDetail()
{
Int32 rownum = 1;
string[] rowDatas = _personRequest1.Split(',');
LicenseFileDetail detail = new LicenseFileDetail()
{
SEQ = Convert.ToInt32(rowDatas[0]).ToString("0000"),
LICENSE_NO = rowDatas[1],
LICENSE_ACTIVE_DATE = LicenseFileHelper.PhaseToDateNull(rowDatas[2]), // issueDate,
LICENSE_EXPIRE_DATE = LicenseFileHelper.PhaseToDateNull(rowDatas[3]), // expireDate,
LICENSE_FEE = LicenseFileHelper.PhaseToMoney(rowDatas[4]),
CITIZEN_ID = GetDataField(rowDatas, 5),
TITLE_NAME = GetDataField(rowDatas, 6),
NAME = GetDataField(rowDatas, 7),
SURNAME = GetDataField(rowDatas, 8),
ADDR1 = GetDataField(rowDatas, 9),
ADDR2 = GetDataField(rowDatas, 10),
AREA_CODE = GetDataField(rowDatas, 11),
EMAIL = GetDataField(rowDatas, 12),
CUR_ADDR = GetDataField(rowDatas, 13),
TEL_NO = GetDataField(rowDatas, 14),
CUR_AREA_CODE = GetDataField(rowDatas, 15),
AR_ANSWER = GetDataField(rowDatas, 16),
OLD_COMP_CODE = GetDataField(rowDatas, 17),
};
Assert.AreEqual(detail.SEQ, "0001");
Assert.AreEqual(detail.LICENSE_NO, "");
Assert.AreEqual(detail.LICENSE_ACTIVE_DATE, null);
Assert.AreEqual(detail.LICENSE_EXPIRE_DATE, null);
Assert.AreEqual(detail.LICENSE_FEE, 300m);
Assert.AreEqual(detail.CITIZEN_ID, "3330500032353");
Assert.AreEqual(detail.TITLE_NAME, "นาง");
Assert.AreEqual(detail.NAME, "กวินทรา");
Assert.AreEqual(detail.SURNAME, "งีเกาะ");
Assert.AreEqual(detail.ADDR1, "181 ม.1");
Assert.AreEqual(detail.ADDR2, "");
Assert.AreEqual(detail.AREA_CODE, "33051300");
Assert.AreEqual(detail.EMAIL, "");
Assert.AreEqual(detail.CUR_ADDR, "181 ม.1");
Assert.AreEqual(detail.TEL_NO, "0845853736");
Assert.AreEqual(detail.CUR_AREA_CODE, "33051300");
Assert.AreEqual(detail.AR_ANSWER, "");
Assert.AreEqual(detail.OLD_COMP_CODE, "");
}
public void LicenseRequest_Can_Seperate_DataRowHeader()
{
IAS.DAL.Interfaces.IIASPersonEntities ctx = DAL.DALFactory.GetPersonContext();
String groupNo = "130923142524097";
String fileName = "test.csv";
String[] rowDatas = _header.Split(',');
DateTime dateNow = DateTime.Now;
String licenseTypeCode = GetDataField(rowDatas, 3);
AG_IAS_APPROVE_DOC_TYPE comp = ctx.AG_IAS_APPROVE_DOC_TYPE.Where(w => w.APPROVE_DOC_TYPE == licenseTypeCode && w.ITEM_VALUE == "Y").FirstOrDefault();
LicenseFileHeader header = new LicenseFileHeader()
{
IMPORT_ID = Convert.ToInt64(groupNo.Trim()),
IMPORT_DATETIME = dateNow,
FILE_NAME = fileName,
PETTITION_TYPE = _petitionTypeCode,
LICENSE_TYPE_CODE = GetDataField(rowDatas, 3),
COMP_CODE = GetDataField(rowDatas, 1),
COMP_NAME = GetDataField(rowDatas, 2),
LICENSE_TYPE = GetDataField(rowDatas, 3),
SEND_DATE = LicenseFileHelper.PhaseToDate(GetDataField(rowDatas, 4)),
TOTAL_AGENT = LicenseFileHelper.PhaseToAmount(GetDataField(rowDatas, 5)),
TOTAL_FEE = LicenseFileHelper.PhaseToMoney(GetDataField(rowDatas, 6)),
ERR_MSG = "",
APPROVE_COMPCODE = comp == null ? null : comp.APPROVER
};
Assert.AreEqual(header.IMPORT_ID, 130923142524097);
Assert.AreEqual(header.IMPORT_DATETIME, dateNow);
Assert.AreEqual(header.PETTITION_TYPE, _petitionTypeCode);
Assert.AreEqual(header.LICENSE_TYPE_CODE, "01");
Assert.AreEqual(header.COMP_CODE, "1023");
Assert.AreEqual(header.COMP_NAME, "บริษัท ไอเอ็นจีประกันชีวิต จำกัด");
Assert.AreEqual(header.LICENSE_TYPE, "01");
Assert.AreEqual(header.SEND_DATE, new DateTime(Convert.ToInt32(2555 - 543), 8, 8));
Assert.AreEqual(header.TOTAL_AGENT, 10);
Assert.AreEqual(header.TOTAL_FEE, 3000m);
Assert.AreEqual(header.ERR_MSG, "");
Assert.AreEqual(header.APPROVE_COMPCODE, "111");
}
private static LicenseFileHeader CreateLicenseFileHeader(IAS.DAL.Interfaces.IIASPersonEntities ctx, LicenseFileHeader header, String lineData, CompressFileDetail compress, string approveCom)
{
String[] rowDatas = lineData.Split(',');
String licenseTypeCode = GetDataField(rowDatas, 3);
// AG_IAS_APPROVE_DOC_TYPE comp = ctx.AG_IAS_APPROVE_DOC_TYPE.Where(w => w.APPROVE_DOC_TYPE == licenseTypeCode && w.ITEM_VALUE == "Y").FirstOrDefault();
header.IMPORT_DATETIME = DateTime.Now;
header.LICENSE_TYPE_CODE = licenseTypeCode;
header.COMP_CODE = GetDataField(rowDatas, 1);
header.COMP_NAME = GetDataField(rowDatas, 2);
header.LICENSE_TYPE = licenseTypeCode;
header.SEND_DATE = LicenseFileHelper.PhaseToDate(GetDataField(rowDatas, 4));
header.TOTAL_AGENT = LicenseFileHelper.PhaseToAmount(GetDataField(rowDatas, 5));
header.TOTAL_FEE = LicenseFileHelper.PhaseToMoney(GetDataField(rowDatas, 6));
header.ERR_MSG = "";
if (string.IsNullOrEmpty(approveCom))
{
approveCom = null;
}
header.APPROVE_COMPCODE = approveCom == null ? null : approveCom;
AG_IAS_PETITION_TYPE_R petitionType = ctx.AG_IAS_PETITION_TYPE_R.SingleOrDefault(a => a.PETITION_TYPE_CODE == header.PettitionTypeCodeRequest);
header.PetitionTypeR = petitionType;
AG_IAS_LICENSE_TYPE_R licenseType = ctx.AG_IAS_LICENSE_TYPE_R.SingleOrDefault(a => a.LICENSE_TYPE_CODE == header.LicenseTypeCodeRequest);
header.LicenseTypeR = licenseType;
header.CompressFileDetail = compress;
return(header);
}
private static LicenseFileDetail CreateLicenseFileDetail(IAS.DAL.Interfaces.IIASPersonEntities ctx, String rawData, Int32 rownum)
{
//IMPORT_ID = recHead.IMPORT_ID,
//COMP_CODE = recHead.COMP_CODE,
//ERR_MSG = errMsg,
//PETITION_TYPE = petitionTypeCode,
string[] rowDatas = rawData.Split(',');
Int32 seq = Convert.ToInt32(rowDatas[0]);
LicenseFileDetail detail = new LicenseFileDetail(ctx)
{
Sequence = seq.ToString("0000"),
SEQ = rownum.ToString("0000"), // seq.ToString("0000"),
LICENSE_NO = rowDatas[1],
LICENSE_ACTIVE_DATE = LicenseFileHelper.PhaseToDateNull(rowDatas[2]), // issueDate,
LICENSE_EXPIRE_DATE = LicenseFileHelper.PhaseToDateNull(rowDatas[3]), // expireDate,
LICENSE_FEE = LicenseFileHelper.PhaseToMoney(rowDatas[4]),
CITIZEN_ID = GetDataField(rowDatas, 5),
TITLE_NAME = GetDataField(rowDatas, 6),
NAME = GetDataField(rowDatas, 7),
SURNAME = GetDataField(rowDatas, 8),
ADDR1 = GetDataField(rowDatas, 9),
ADDR2 = GetDataField(rowDatas, 10),
AREA_CODE = GetDataField(rowDatas, 11),
EMAIL = GetDataField(rowDatas, 12),
CUR_ADDR = GetDataField(rowDatas, 13),
TEL_NO = GetDataField(rowDatas, 14),
CUR_AREA_CODE = GetDataField(rowDatas, 15),
AR_ANSWER = LicenseFileHelper.PhaseARDate(GetDataField(rowDatas, 16)),
OLD_COMP_CODE = GetDataField(rowDatas, 17),
SPECIAL_TYPE_CODE = GetDataField(rowDatas, 18),
START_DATE = LicenseFileHelper.PhaseStartDate(GetDataField(rowDatas, 19))
};
return(detail);
}
private void Initialize()
{
OnSysteminfo = new RelayCommand(() =>
{
LicenseSource.Mac = MacHelper.GetMacAddress();
LicenseSource.CPU = Win32Helper.GetCpuID();
});
OnSignFile = new RelayCommand(() =>
{
this.ViewConfirm("确定生成新的公/私钥文件至Key文件夹，操作会覆盖替换原文件（是/否）？", () =>
{
if (LicenseFileHelper.SavePemKeyFile(PublicKeyFilePath, PrivateKeyFilePath))
{
AppEvent.ProcessStart.SendAction <TParam <string, Action> >(this, new TParam <string, Action>()
{
Param1 = System.IO.Path.GetDirectoryName(PublicKeyFilePath)
});
}
else
{
this.ViewMessage("密钥文件保存失败");
}
});
});
OnGenerateLic = new RelayCommand(() =>
{
if (LicenseSource.Product.IsEmpty() || LicenseSource.Edition.IsEmpty() || LicenseSource.Email.IsEmpty() || LicenseSource.Mobile.IsEmpty() ||
LicenseSource.Mac.IsEmpty() || LicenseSource.CPU.IsEmpty() || LicenseSource.UseTimes.IsEmpty() || LicenseSource.ExpirationTime.IsEmpty() || LicenseSource.IsTrial.IsEmpty())
{
this.ViewMessage("请输入内容(标识、邮箱、手机，Mac地址，CPU，使用次数，过期时间等信息)");
return;
}
var licenseModel = new LicenseModel()
{
Product = LicenseSource.Product,
Edition = LicenseSource.Edition,
Email = LicenseSource.Email,
Mobile = LicenseSource.Mobile,
Mac = LicenseSource.Mac,
CPU = LicenseSource.CPU,
UseTimes = LicenseSource.UseTimes,
ExpirationTime = LicenseSource.ExpirationTime,
IsTrial = LicenseSource.IsTrial
};
var filePath = string.Format(LicenseFilePathFormat, (LicenseSource.Mac + LicenseSource.CPU).Replace("-", ""));
if (LicenseFileHelper.SavePemLicenseFile(licenseModel, filePath, PrivateKeyFilePath))
{
this.ViewMessage("授权文件保存成功", () =>
{
AppEvent.ProcessStart.SendAction <TParam <string, Action> >(this, new TParam <string, Action>()
{
Param1 = System.IO.Path.GetDirectoryName(filePath)
});
});
}
else
{
this.ViewMessage("授权文件保存失败");
}
});
OnVerifyLic = new RelayCommand(() =>
{
if (LicenseSource.Mac.IsEmpty() || LicenseSource.CPU.IsEmpty())
{
this.ViewMessage("信息错误");
return;
}
var filePath = string.Format(LicenseFilePathFormat, (LicenseSource.Mac + LicenseSource.CPU).Replace("-", ""));
if (!File.Exists(filePath))
{
this.ViewMessage("未找到授权文件");
return;
}
var model = LicenseFileHelper.GetPemLicense(filePath, PublicKeyFilePath);
if (model.IsNull())
{
this.ViewMessage("授权文件错误");
return;
}
this.ViewMessage("授权文件校验通过");
});
OnOpenFileDic = new RelayCommand(() =>
{
AppEvent.ProcessStart.SendAction <TParam <string, Action> >(this, new TParam <string, Action>()
{
Param1 = System.IO.Path.GetDirectoryName(PublicKeyFilePath),
Param2 = null
});
});
}
public void LicenseHelper_Can_PhaseToDate()
{
DateTime date = LicenseFileHelper.PhaseToDate("08/08/2555");
Assert.AreEqual(date, new DateTime(Convert.ToInt32(2555 - 543), 8, 8));
}
