protected override void Refresh(object o)
{
Services.ZhuanYeServicesClient service = new Services.ZhuanYeServicesClient();
string result = service.ZhuanYeQuery();
DataList = JsonConvert.DeserializeObject<DataTable>(result);
service.Close();
}
/// <summary>
/// 插入专业信息表
/// </summary>
/// <returns></returns>
private bool InsertZhuanYe()
{
try
{
SetErrorMsg("正在导入基础专业信息");
List<ZhuanYeModel> list = DbfHelper.GetList<ZhuanYeModel>(DbfSql.ZhuanYeSql);
if (list != null)
{
//广东考生号只有10位
string ksh = NewStudents.First().KSH.Trim();
string year = ksh.Length > 10 ? ksh.Substring(0, 2) : DateTime.Now.Year.ToString().Substring(2, 2);
Services.ZhuanYeServicesClient zhuanye = new Services.ZhuanYeServicesClient();
string result = zhuanye.ZhuanYeQuery();
List<ZhuanYeModel> zhuanyeList = JsonConvert.DeserializeObject<List<ZhuanYeModel>>(result);
const string pattern = @"(.*?)\((.*?)\)";
foreach (var item in list)
{
//生成专业方向
item.Zymc = item.Zymc.Replace("（", "(").Replace("）", ")");
Match match = Regex.Match(item.Zymc, pattern, RegexOptions.IgnoreCase);
if (match.Success)
{
item.Zymc = match.Groups[1].Value;
item.Zyfx = match.Groups[2].Value;
}
item.Sfdm = year;
var query = zhuanyeList.Where(r => r.Sfdm == item.Sfdm && r.Pcdm == item.Pcdm && r.Kldm == item.Kldm
&& r.Jhxz == item.Jhxz && r.Tddw == item.Tddw && r.Zydh == item.Zydh);
//如果专业存在就不在添加
if (query == null || query.Count() == 0)
zhuanye.ZhuanYeAdd(item);
}
zhuanye.Close();
return true;
}
else
{
ErrorMsg = "没有争取获取录取专业信息";
return false;
}
}
catch (Exception ex)
{
ErrorMsg = ex.Message;
return false;
}
}