public static _List <string> getValIntiligent(string k, _Dictionary <string, string> dic)
{
_List <string> retkeyval = new _List <string>();
bool notfound = true;
string containkey = "0";
string retkey = k;
string retval = "";
if (dic.ContainsKey(k))
{
notfound = false;
retval = dic[k];
containkey = "1";
}
if (notfound)
{
// _v1
Match m1 = Regex.Match(k, @"(.+)\s*\(v(\d)\)", RegexOptions.IgnoreCase);
if (m1.Success)
{
string newkey = m1.Groups[1].ToString().Trim() + "-" + m1.Groups[2].ToString();
if (dic.ContainsKey(newkey) && notfound)
{
notfound = false;
retval = dic[newkey];
retkey = newkey;
containkey = "2";
}
//lgstr.deb("matched " + k + ":" + newkey+": "+notfound.ToString());
newkey = m1.Groups[1].ToString().Trim();
if (dic.ContainsKey(newkey) && notfound)
{
notfound = false;
retval = dic[newkey];
retkey = newkey;
containkey = "3";
}
//lgstr.deb("matched " + k + ":" + newkey + ": " + notfound.ToString());
}
}
if (notfound)
{
//FDDIV
Match m1 = Regex.Match(k, @"[FT]DD\s*(\w+)", RegexOptions.IgnoreCase);
string newkey = m1.Groups[1].ToString().Trim();
if (dic.ContainsKey(newkey))
{
notfound = false;
retval = dic[newkey];
retkey = newkey;
containkey = "4";
}
}
retkeyval.Add(containkey);
retkeyval.Add(retkey);
retkeyval.Add(retval);
retkeyval.Add(k);
return(retkeyval);
}
public _Dictionary <string, string> PICSFormatMnemonicsChangeSupport(Dictionary <string, object> dataPICS)
{
_Dictionary <string, string> PICSSupportFormattedA = new _Dictionary <string, string>();
foreach (KeyValuePair <string, object> tempPICS in dataPICS)
{
string patt = @"(12)\#(.+)";
Match mc = Regex.Match(tempPICS.Key, patt);
if (mc.Success)
{
_List <string> abc = (_List <string>)tempPICS.Value;
if (abc[1] != "")
{
if (abc[0] == "Y")
{
PICSSupportFormattedA.Add(abc[1], "True");
}
else
{
PICSSupportFormattedA.Add(abc[1], "False");
}
}
}
}
return(PICSSupportFormattedA);
}
// End
public static string TCVsTF(string complexCondStr, _Dictionary <string, string> CondVsTF)
{
string res = "";
var regex = new Regex(@"C(?:\%\d+\%)?[\w-_]+", RegexOptions.IgnoreCase);
string resTemp = regex.Replace(complexCondStr, m => convertBoolHelper(m.ToString(), CondVsTF));
string boolstrverify = resTemp.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match mc = Regex.Match(boolstrverify, @"\w+");
if (!(mc.Success))
{
if (resTemp.Trim() != "")
{
res = evalBooleanExpr(resTemp).ToString();
lgstr.deb("{TCvsTF} More than 1 conditions found and being evaluated for" + complexCondStr + ", Res: " + res);
}
}
else
{
res = resTemp;
}
lgstr.inf("{TCvsTF} " + String.Format(" In: {0} \tRes: {1}", complexCondStr, res));
return(res);
}
/// <summary>
/// 贸易方式下拉数据,仓单状态下拉数据
/// </summary>
/// <param name="dictionary"></param>
/// <param name="dictionaryNo"></param>
/// <returns></returns>
public DataTable GetDatadictionaryList(_Dictionary dictionary)
{
DataTable dt = new DataTable();
StringBuilder strSqlWhere = new StringBuilder();
if (dictionary == _Dictionary.Status)
{
strSqlWhere.Append(" SELECT [dictionary_value] as list_no ,[dictionary_name] ");
strSqlWhere.Append(" FROM [ILIMS_BasicData].[dbo].[b_datadictionary] ");
strSqlWhere.AppendFormat(" WHERE dictionary_no ={0} ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
strSqlWhere.Append(" and is_valid=1 ");
}
else
{
strSqlWhere.Append(" SELECT [list_no] ,[dictionary_name] ");
strSqlWhere.Append(" FROM [ILIMS_BasicData].[dbo].[b_datadictionary] ");
strSqlWhere.AppendFormat(" WHERE dictionary_no={0} ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
strSqlWhere.Append(" and is_valid=1 ");
}
DataSet ds = new DataSet();
ds = DBHelper.ExecuteDataSet(strSqlWhere.ToString());
if (ds != null || ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
/// <summary>
/// 页面状态转换方法
/// </summary>
/// <param name="Value">实际值</param>
/// <param name="DispalyName">需转换字段名</param>
/// <returns></returns>
public static string GetStatusName(_Dictionary dictionary, string ActualValue)
{
string strDisplay = string.Empty;
strDisplay = facade.GetDisplayName(dictionary, ActualValue);
return(strDisplay);
}
public static string convertToBoolExprMnemonic(_Dictionary <string, string> PICSoutput, string strinput)
{
string strop = strinput;
//string pattern = @"\b\PICSoutputd+#[AEG]\.\d[\d\-\/\.a-z]+\b";
string pattern = @"\d+#\b[ADEGX]\.\d[\d\-\/\.a-z]+\b";
Regex itemRegex = new Regex(pattern, RegexOptions.IgnoreCase);
strop = itemRegex.Replace(strinput, m => convertBoolHelper(m.ToString(), PICSoutput));
lgstr.inf("{convertToBoolExprMnemonic} " + strinput + " => " + strop);
return(strop);
}
public void gettable_tcno_spec_id_band(string spec)
{
//tc_band_sheet = new TwoKeyDictionary<string, string, string>();
tc_band_id = new TwoKeyDictionary <string, string, string>();
tc_band_status = new TwoKeyDictionary <string, string, string>();
tc_bandapplicability = new _Dictionary <string, string>();
tc_des = new _Dictionary <string, string>();
try
{
dbobj.tablename = "v_comb_serv_info";
string Conditionstring = String.Format("(spec = \"{0}\" and ver_gcf_ptcrb_op = \"{1}\")", spec, gcfver);
List <string> colnames = new List <string>()
{
"testcase", "band", "id", "bandapplicability", "tcstatus", "sheetname", "Description"
};
DataTable retdt = dbobj.getdatatble(colnames, Conditionstring);
foreach (DataRow row in retdt.Rows)
{
string tcno = row[0].ToString().Replace(" ", "").ToLower();
if (tc_band_id.ContainsKey(tcno, row[1].ToString()))
{
//lgstr.cri(String.Format("{GenericParser:gettable_tcno_spec_id_band} duplicate of {0} and {1} found in spec {2} ", row[0].ToString(), row[1].ToString(), spec));
lgstr.cri("{ FORMUpload:gettable_tcno_spec_id_band} duplicate tc/band combination. TC: " + tcno + " Band: " + row[1].ToString());
}
if (!tc_bandapplicability.ContainsKey(tcno))
{
tc_bandapplicability[tcno] = row[3].ToString();
}
if (!tc_des.ContainsKey(tcno))
{
tc_des[tcno] = row[6].ToString();
}
tc_band_id[tcno, row[1].ToString()] = row[2].ToString();
tc_band_status[tcno, row[1].ToString()] = row[4].ToString();
//tc_band_sheet[tcno, row[1].ToString()] = row[5].ToString();
}
//lgstr.inf("tc_bandapplicability");
//lgstr.inf(tc_bandapplicability.ToString());
//lgstr.inf("tcbandstatus");
//lgstr.inf(tc_band_status.ToString());
}
catch (Exception ex)
{
Debug.Print("Exception from gettable : " + ex.ToString());
lg.war("{FORMUpload:gettable_tcno_spec_id_band} Exception: " + ex.Message.ToString());
}
//return tc_band_id;
}
/// <summary>
/// 获取状态字典显示值
/// </summary>
/// <param name="ActualValue"></param>
/// <returns></returns>
public string GetDisplayName(_Dictionary dictionary, string ActualValue)
{
string strDispName = string.Empty;
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" SELECT * FROM [ILIMS_BasicData].[dbo].[b_datadictionary] ");
strSqlWhere.Append(" WHERE 1=1 ");
switch (dictionary)
{
case _Dictionary.ParaExchrate:
strSqlWhere.AppendFormat(" AND dictionary_no='{0}' ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
strSqlWhere.AppendFormat(" AND dictionary_name='{0}'", ActualValue);
break;
default:
if (!string.IsNullOrWhiteSpace(dictionary.ToString()))
{
strSqlWhere.AppendFormat(" AND dictionary_no='{0}' ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
}
strSqlWhere.AppendFormat(" AND list_no='{0}'", ActualValue);
break;
}
DataSet ds = new DataSet();
ds = DBHelper.ExecuteDataSet(strSqlWhere.ToString());
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
switch (dictionary)
{
case _Dictionary.ParaExchrate:
if (row["list_no"] != DBNull.Value)
{
strDispName = row["list_no"].ToString();
}
break;
default:
if (row["dictionary_name"] != DBNull.Value)
{
strDispName = row["dictionary_name"].ToString();
}
break;
}
}
}
return(strDispName);
}
public static void combinedCond(_Dictionary <string, string> c_logic_map, _Dictionary <string, string> pics_support)
{
_List <string> cval = new _List <string>();
foreach (KeyValuePair <string, string> temp in c_logic_map)
{
cval.Add(temp.Key);
}
foreach (string C in cval)
{
lgstr.inf("Key Find: " + C + " Val: " + c_logic_map[C]);
string evlstr = condCompl(C, c_logic_map, pics_support);
lgstr.inf("Key Eval: " + C + " Val: " + evlstr);
//lgstr.inf(c_logic_map.ToString());
}
}
private static _Dictionary <string, string> dbquery(string tablename, List <string> colnames, string conditiondict)
{
_Dictionary <string, string> returnval = new _Dictionary <string, string>();
dbobj.tablename = tablename;
DataTable retdt = dbobj.getdatatble(colnames, conditiondict);
foreach (DataRow row in retdt.Rows)
{
//returnval[row[0].ToString(),row[1].ToString()] = row[2].ToString();
//Debug.Print(row[0].ToString());
returnval.Add(row[0].ToString(), row[1].ToString());
}
return(returnval);
}
public _Dictionary <string, string> PICSFormatChangeSupport(Dictionary <string, object> dataPICS)
{
// datapics 0 element is support and 1 for pnemonic.
_Dictionary <string, string> PICSSupportFormatted = new _Dictionary <string, string>();
foreach (KeyValuePair <string, object> tempPICS in dataPICS)
{
_List <string> abc = (_List <string>)tempPICS.Value;
//string[] def = abc.ToArray();
if (abc[0].ToLower().Trim() == "y")
{
PICSSupportFormatted.Add(tempPICS.Key, "True");
}
else
{
PICSSupportFormatted.Add(tempPICS.Key, "False");
}
}
return(PICSSupportFormatted);
}
/// <summary>
/// this will take a pics item as input and generate true false statement.
///
/// </summary>
/// <param name="picsitem"></param>
/// <param name="pics_support">
/// (NOT(7#A.4.3-4a/1) AND 7#A.4.1-1/1 AND 7#A.4.3-3a/1)
/// </param>
/// <returns>
/// (NOT(False) AND True AND True)
/// </returns>
public static string logicstrProcess(string picsitem, _Dictionary <string, string> pics_support)
{
string dbg = " In: " + picsitem;
string boolstr = picsitem;
boolstr = convertToBoolExpr(pics_support, picsitem);
dbg += "\tBoolExpr: " + boolstr;
string boolstrverify = boolstr.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match m = Regex.Match(boolstrverify, @"\w+");
if (!(m.Success))
{
boolstr = evalBooleanExpr(boolstr).ToString();
dbg += "\tEvalRes: " + boolstr;
lgstr.deb("{cond_process} " + dbg);
}
else
{
lgstr.war("{cond_process} InvPart: " + boolstrverify + dbg);
}
return(boolstr);
}
// colname is the key ID is value.
public _Dictionary <string, string> getfulltable(string tablename, string colname, string valID = "ID")
{
_Dictionary <string, string> alldata_table = new _Dictionary <string, string>();
try
{
dbobj.tablename = tablename;
List <string> colnames = new List <string>()
{
colname, valID
};
DataTable retdt = dbobj.getdatatble(colnames, "");
foreach (DataRow row in retdt.Rows)
{
alldata_table[row[0].ToString()] = row[1].ToString();
}
}
catch (Exception ex)
{
Debug.Print("Exception from gettable : " + ex.ToString());
}
return(alldata_table);
}
/// <summary>
/// 获取显示值
/// </summary>
/// <param name="ActualValue"></param>
/// <returns></returns>
public string GetDisplayName(_Dictionary dictionary,string ActualValue)
{
return this.LogicDal.GetDisplayName(dictionary,ActualValue);
}
/// <summary>
/// 页面状态转换方法
/// </summary>
/// <param name="Value">实际值</param>
/// <param name="DispalyName">需转换字段名</param>
/// <returns></returns>
public static string GetStatusName(_Dictionary dictionary,string ActualValue)
{
string strDisplay = string.Empty;
strDisplay = facade.GetDisplayName(dictionary, ActualValue);
return strDisplay;
}
/// <summary>
/// 贸易方式下拉数据,仓单状态下拉数据
/// </summary>
/// <param name="dictionary"></param>
/// <returns></returns>
public DataTable GetDatadictionaryList(_Dictionary dictionary)
{
var data=this.LogicDal.GetDatadictionaryList(dictionary);
return data;
}
//public static Logging lg;
//public static void mainprocess(string filePICSFullPath, _List<string> specTVAFiles, _List<string> specCVLFiles, Logging lg, MySqlDb dbobj, FormUpload frm)
public static void mainprocess(string filePICSFullPath, _List <string> specTRLFiles, Logging lg, MySqlDb dbobj, FormUpload frm)
{
frm.SetProgress(0);
frm.apendlog("Started PICS process", 4);
lg.deb(" ++++ PICS Process started ++++ ");
lg.deb("PICS User File : " + filePICSFullPath);
lg.deb("List of CSV files on server spec data: \n\t\t" + specTRLFiles.ToString());
progressint = Convert.ToInt32(progress);
//lg.inf("progress: " + progress.ToString() + " t : " + DateTime.Now.ToString("h:mm:ss tt"));
// START
string curDir = System.Environment.CurrentDirectory;
string outputfilename = Path.Combine(curDir, "combinedOutput.csv");
string file_picsmapping = Path.Combine(curDir, "_picsmapping.csv");
string file_picsstatus = Path.Combine(curDir, "_picsstatus.csv");
string icebandall = "";
string icebandulca = "";
string ice4x4MIMO = "";
GenericParser gp = new GenericParser(@filePICSFullPath);
List <string> excelsheetlist = MySqlDb.GetExcelsheetslist(@filePICSFullPath);
Debug.Print("all sheet name: " + string.Join(" , ", excelsheetlist));
gp.lg = lg;
List <int> x = new List <int> {
1, 6
};
//itemno vs [support, pnemonic]
Dictionary <string, object> PICSoutput = gp.readwholepics();
//
//lg.inf("PICS file Data: itemno vs [support,pnemonic]");
//lg.inf(PICSoutput.ToString());
TwoKeyDictionary <string, string, string> pics_reco_dic = new TwoKeyDictionary <string, string, string>();
_Dictionary <string, string> pics_reco_table;
_Dictionary <string, string> PICSFormattedSupportOutput = gp.PICSFormatChangeSupport(PICSoutput);
//lg.deb("PICS file Data. calculated to True/False with #");
//lg.deb(PICSFormattedSupportOutput.ToString());
_Dictionary <string, string> PICSmnemonicDic = gp.PICSFormatMnemonicsChangeSupport(PICSoutput);
StringProcess.PICSmnemonicDic = PICSmnemonicDic;
lg.inf("PICSmnemonicDic only for spec 12 = 102 230 :\n" + PICSmnemonicDic.ToString());
picsSupBandList = gp.PICSSupportedBands(PICSFormattedSupportOutput, PICSoutput);
lg.inf("picsSupBandList :\n" + picsSupBandList.ToString());
progress = 2;
//lg.inf("progress: " + progress.ToString() + "t : " + DateTime.Now.ToString("h:mm:ss tt"));
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
Dictionary <string, object> RFBandListD = gp.RFBandTableD(PICSFormattedSupportOutput);
Dictionary <string, object> RFBandListE = gp.RFBandTableE(PICSFormattedSupportOutput, PICSoutput);
TwoKeyDictionary <string, string, string> user_bs_rb_pics = new TwoKeyDictionary <string, string, string>();
dbobj.tablename = "user_bs_rb_pics";
DataTable dt = dbobj.getdatatble();
Debug.Print("Reading Data Table");
foreach (DataRow dr in dt.Rows)
{
user_bs_rb_pics[dr["bandsupport"].ToString(), dr["requiredband"].ToString()] = dr["id"].ToString();
}
//lg.inf("user_bs_rb_pics" + user_bs_rb_pics.ToString());
// user_picsver | picsver -> picssupportedbandlist -> id#gcfver
// write user_picsver and get id. this will return picsversionid too.
string idpicsver = frm.insertpicsver(picsSupBandList.toCommaList());
DataTable icebanddt = dbobj.getDtFromSqlSt(String.Format("Select icebands, icebands_ulca, 4x4_mimo from user_picsver where id = {0}", idpicsver));
foreach (DataRow row in icebanddt.Rows)
{
//returnval[row[0].ToString(),row[1].ToString()] = row[2].ToString();
//Debug.Print(row[0].ToString());
icebandall = row[0].ToString();
icebandulca = row[1].ToString();
ice4x4MIMO = row[2].ToString();
break;
}
lg.inf("customer band from db: (all) " + icebandall);
lg.inf("customer band from db:(ulca) " + icebandulca);
frm.getbandicesupport(icebandall);
//string servDir = @"\\sd-ct-opiot.sn.intel.com\Dropbox\tools\TPG\sampleinput\Specs";
//New Code End
progress = 3;
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
int specfilescount = specTRLFiles.Count();
double progressinc = 97 / specfilescount;
for (int i = 0; i < specfilescount; i++)
{
//lg.inf("progress: " + progress.ToString() + " t : " + DateTime.Now.ToString("h:mm:ss tt"));
string status = "Processing : " + specTRLFiles[i];
frm.SetLabelstat(status);
//string fileNameTVA = specTVAFiles[i];
//string fileNameCVL = specCVLFiles[i];
string filenameTRL = specTRLFiles[i];
string fileTRLPath = Path.Combine(servDir, filenameTRL);
gp.clearVar();
// Getting a portion of string:
string patt = @"(.+?)_\w+";
var mc = Regex.Match(filenameTRL, patt);
string spec = mc.Groups[1].ToString();
//string fileCVLPath = Path.Combine(servDir, fileNameCVL);
//string fileTVAPath = Path.Combine(servDir, fileNameTVA);
lg.deb("{MainProcess} Processing -> spec: " + spec + "\tfiles: " + filenameTRL.ToString());
frm.apendlog("Processing spec = " + spec, 4);
//_Dictionary<string, string> condVsLogicDic = gp.getdictionaryRowCol(1, 0, fileCVLPath);
// this function will change condDict make adding hash. (not sure)
// itemProcess is not needed for new algo
//itemProcess(condVsLogicDic, spec);
//lg.inf("{MainProcess} Condition vs. logical exp from server csv for Spec: " + spec);
//lg.inf(condVsLogicDic.ToString());
//this will convert item to true false as per PICS
// Here, we are changing the conDict according to spec. It is different only for Spec:102.230.
//combinedCond(condVsLogicDic, PICSFormattedSupportOutput);
//lg.deb(@"{MainProcess} Condition vs T/F after using PICS for Spec: " + spec);
//lg.deb(condVsLogicDic.ToString());
// filter spec string to address spec confusion for 51.010
//string spec = spec;
//if (spec.StartsWith("51.010"))
//{
// spec = "51.010";
//}
//lg.inf("tempdebug: spec: " + spec +" new spec: "+ spec);
frm.SetLabelstat(status + " db query to get test configuration");
// Database query to get all the info for the spec. from tcconfig table
frm.gettable_tcno_spec_id_band(spec);
//TwoKeyDictionary<string, string, string> tc_band_sheet = frm.tc_band_sheet;
_Dictionary <string, string> tc_des = frm.tc_des;
TwoKeyDictionary <string, string, string> tc_band_id = frm.tc_band_id;
TwoKeyDictionary <string, string, string> tc_band_status = frm.tc_band_status;
_Dictionary <string, string> tc_bandapplicability = frm.tc_bandapplicability;
//lg.deb("sheetname from db"+tc_band_sheet.ToString());
//lg.deb("testconfig from DB");
//lg.deb(tc_band_id.ToString());
//lg.deb("tc_bandapplicability from DB");
//lg.deb(tc_bandapplicability.ToString());
//lg.deb("tc_band_status from DB");
//lg.deb(tc_band_status.ToString());
_Dictionary <string, string> TCvsApp = new _Dictionary <string, string>();
_Dictionary <string, string> TCvsAppFiltered = new _Dictionary <string, string>();
_Dictionary <string, string> csvTCvsRel = new _Dictionary <string, string>();
_Dictionary <string, object> TCvsBand = new _Dictionary <string, object>();
TwoKeyDictionary <string, string, string> bsrbidxdic = new TwoKeyDictionary <string, string, string>();
if (File.Exists(fileTRLPath))
{
_Dictionary <string, string> dict_logic = new _Dictionary <string, string>();
_Dictionary <string, string> dict_logic_TF = new _Dictionary <string, string>();
_Dictionary <string, string> dict_rel = new _Dictionary <string, string>();
_Dictionary <string, string> dict_de = new _Dictionary <string, string>();
_Dictionary <string, string> dict_pnemonic = new _Dictionary <string, string>();
StringProcess.specDash1 = spec;
StringProcess.readconfigpics();
//StringProcess.
gp.dict_de = dict_de;
gp.dict_logic = dict_logic;
gp.dict_logic_TF = dict_logic_TF;
gp.dict_pnemonic = dict_pnemonic;
gp.dict_rel = dict_rel;
GenericParser.picssupport = PICSFormattedSupportOutput;
//this will generate logic to TF
gp.processlogic(fileTRLPath);
if (GenericParser.missingpicsitem.Count > 0)
{
lg.inf("{MainProcess} Missing Item in pics file:");
lg.war(GenericParser.missingpicsitem.ToString());
}
lg.inf("{MainProcess} TC vs True False TRL + pics file:");
lg.inf(dict_logic_TF.ToString());
lg.inf("{MainProcess} TC vs Logic from TRL:");
lg.inf(dict_logic.ToString());
//_Dictionary<string, string> csvTCvsCond;
//_Dictionary<string, string> dict_de;
//frm.SetLabelstat(status + " process tc vs cond");
//csvTCvsCond = new _Dictionary<string, string>(gp.getdictionaryRowCol(1, 0, fileTVAPath,true));
//frm.SetLabelstat(status + " process tc vs rel");
//csvTCvsRel = new _Dictionary<string, string>(gp.getdictionaryRowCol(2, 0, fileTVAPath,true));
//frm.SetLabelstat(status + " process tc vs Band cond");
//dict_de = new _Dictionary<string, string>(gp.getdictionaryRowCol(3, 0, fileTVAPath,true));
//lg.inf("{MainProcess} TC vs Condion from server csv file:");
//lg.inf(csvTCvsCond.ToString());
// This loop iterates over the configurations obtained from the database
progress += progressinc * 0.1;
progressint = Convert.ToInt32(progress);
double progressinc2 = progressinc * 0.8;
int tccount = tc_band_id.getCount();
double progressinc3 = progressinc2 / tccount;
//lg.inf(String.Format("progress: {0} ,progressinc: {1}, progressinc2: {2},progressinc3: {3} tccount: {4}", progress, progressinc, progressinc2, progressinc3, tccount));
StringProcess.mismatchedbandbandsupporthelper.Clear();
//read new csv file here
//string picslogic = "";
foreach (KeyValuePair <string, Dictionary <string, string> > temp in tc_band_id)
{// reading database test case - band vs id start
string ms1 = DateTime.Now.Millisecond.ToString();
string s1 = DateTime.Now.Second.ToString();
string tc = temp.Key.Replace(" ", "").ToLower();
string oldTC = tc;
string picstmpstr = "";
string picsBand = "";
string picsRel = "Rel: NF";
string picsTCReco = "";
_Dictionary <string, string> band_id = new _Dictionary <string, string>(temp.Value);
_List <string> bandsPerTC = new _List <string>(band_id.Keys.ToList());
lg.inf("{MainProcess} List of bands from db for TestCase: " + tc);
lg.inf(bandsPerTC.ToString());
// Start: For Remving V1 or V2 from TC
string TCvsAppFilteredTempSingle = "";
string pattTC = @"(.*)\s\(v\d+\)";
Match mcTC = Regex.Match(tc, pattTC);
if (mcTC.Success)
{
tc = mcTC.Groups[1].ToString().Trim();
lg.war("TC Converted from old " + oldTC + " to " + tc);
frm.apendlog("TC Converted from old " + oldTC + " to " + tc);
}
// End: For Remving V1 or V2 from TC
// for spec 37.901 to match test case after the dash everything should be removed
if (spec == "37.901")
{
tc = tc.Split('-')[0];
}
//var tctemplist = dict_logic_TF.Keys.Where(t => t.Trim().Replace(" ", "").ToLower() == tc.Trim().Replace(" ", "").ToLower());
string tcapplicability = "";
foreach (string tctemp in dict_logic_TF.Keys)
{
if (tctemp.Trim().Replace(" ", "").ToLower() == tc.Trim().Replace(" ", "").ToLower())
{
tcapplicability = dict_logic_TF[tctemp];
if (dict_rel.ContainsKey(tctemp))
{
picsRel = dict_rel[tctemp];
}
//if (dict_logic.ContainsKey(tctemp))
// picslogic = dict_logic[tctemp];
break;
}
}
// checking if csvTCvsCond has the tc(after removing v1/v2)
if (tcapplicability != "")
{
//string tcapplicability = dict_logic_TF[tc].Trim();
if (tcapplicability == "R")
{
TCvsApp.Add(tc, "R");
picsTCReco = "TC: R";
}
else if (tcapplicability == "m")
{
TCvsApp.Add(tc, "R");
picsTCReco = "TC: R";
}
else if (tcapplicability != "")
{
string dbgexception = " TC = " + tc;
//string condCurTC = "";
string resCurTC = tcapplicability;
try
{
// Pass it through a function: addressing special case 51.010-4...
//condCurTC = csvTCvsCond[tc];
//dbgexception += "\tcondCurTC = " + condCurTC;
// Pass it through a function:
//resCurTC = tcapplicability;//dict_logic_TF[tc];
//resCurTC = StringProcess.TCVsTF(condCurTC, condVsLogicDic);
dbgexception += "\tresCurTC = " + resCurTC;
//lg.deb("Result from condition map: " + resCurTC + "for TestCase: " + tc);
if (!TCvsApp.ContainsKey(tc))
{
TCvsApp.Add(tc, resCurTC);
}
TCvsAppFilteredTempSingle = gp.TCvsAppRefined(resCurTC);
if (!TCvsAppFiltered.ContainsKey(tc))
{
TCvsAppFiltered.Add(tc, TCvsAppFilteredTempSingle);
}
dbgexception += "\tresCurTCFiltered = " + TCvsAppFilteredTempSingle;
picsTCReco = "TC: " + TCvsAppFilteredTempSingle;
}
catch (Exception ex)
{
lg.err("{MainProcess} Exception: " + ex.Message + "\n\t\t\t" + dbgexception);
picsTCReco = "TC: X";
frm.apendlog(ex.Message, 2);
}
}
}
else
{ // tc is not in the dictionary. csvTCvsCond.ContainsKey(tc)
if (spec == "tty")
{
picsTCReco = "TC: R";
}
else
{
picsTCReco = "TC: -";
lg.war("{MainProcess} CSVOutputTCApp KeyNotFound = " + tc);
frm.apendlog("TC missing : " + tc, 3);
}
}
_List <string> bandListDE = new _List <string>();
//_List<string> keyInTCvsRel = new _List<string>(csvTCvsRel.Keys.ToList());
//if (csvTCvsRel.ContainsKey(tc))
// picsRel = csvTCvsRel[tc];
if (spec == "36.521-1")
{
if (dict_de.ContainsKey(tc))
{
patt = @"([DE])\d+";
var mc1 = Regex.Match(dict_de[tc], patt);
string res = mc1.Groups[1].ToString();
if (res == "D")
{
List <string> bandListD = new List <string>();
if (RFBandListD.ContainsKey(dict_de[tc]))
{
bandListD = (List <string>)RFBandListD[dict_de[tc]];
}
TCvsBand.Add(tc, bandListD);
foreach (string bandVal in bandListD)
{
bandListDE.Add(bandVal);
}
}
else if (res == "E")
{
List <string> bandListE = new List <string>();
if (RFBandListE.ContainsKey(dict_de[tc]))
{
bandListE = (List <string>)RFBandListE[dict_de[tc]];
}
TCvsBand.Add(tc, bandListE);
foreach (string bandVal in bandListE)
{
bandListDE.Add(bandVal);
}
}
}
else
{
lg.war("{MainProcess} CSVOutputTCBand KeyNotFound = " + tc);
frm.apendlog("TC missing :: " + tc, 3);
}
lg.inf("DE Check: " + tc + " band list: " + bandListDE.ToString());
//frm.apendlog("bandlist error " + tc, 1);
}
_Dictionary <string, string> band_status = new _Dictionary <string, string>(frm.tc_band_status[oldTC]);
lg.inf(" " + band_status.ToString());
bandHO = frm.rb_order_ho_str.Split(',');
bandOther = frm.rb_order_other_str.Split(',');
_Dictionary <string, string> band_rb = processRequiredBand(band_status, tc_bandapplicability[oldTC]);
foreach (KeyValuePair <string, string> kvp in band_id)
{
string band_id_key = kvp.Key;
string band_id_val = kvp.Value;
string band_rb_val = "E";
_List <string> modifiedband = StringProcess.getValIntiligent(band_id_key, band_rb);
band_rb_val = modifiedband[2];
if (modifiedband[0] != "1")
{
lg.inf("bandchange" + modifiedband.ToString());
}
string pics_reco_str = picstmpstr;
picsBand = "";
bool isSuppBand = StringProcess.bandSupportHelper(band_id_key, picsSupBandList);
if ((frm.testcat == "rf") || (frm.testcat == "att") || (frm.testcat == "vzw") || (frm.testcat == "cmcc"))
{
band_rb_val = "";
}
if (spec == "36.521-1")
{
//string PICSRecoBand = "";
bool PICSRecoBand = StringProcess.bandSupportHelper(band_id_key, bandListDE);
//lg.cri("After call: " + tc + " band list: " + bandListDE.ToString());
if (PICSRecoBand)
{
//picsBand = "Band: R";
picsBand = "";
}
else
{
picsBand = "Band: NR";
}
if (tc.StartsWith("8") | tc.StartsWith("9"))
{
picsBand = "";
}
//if ((tc_band_sheet[tc, band_id_key] == "LTE_UL_CA") || ((tc_band_sheet[tc, band_id_key] == "64QAM")))
string desc = tc_des[tc].ToLower();
if (desc.Contains("64qam") || desc.Contains("dl ca and ul ca"))
{
string pattULCA = @"CA_(\d+[A-E])";
Match mcULCA = Regex.Match(band_id_key, pattULCA);
if (mcULCA.Success)
{
string band_id_key_mod = "UL" + band_id_key;
if (picsSupBandList.Contains(band_id_key_mod))
{
isSuppBand = true;
}
}
}
}
picsRel = picsRel.Replace(",", " ");
if (picsTCReco != "")
{
if (pics_reco_str == "")
{
pics_reco_str += picsTCReco;
}
else
{
pics_reco_str += ", " + picsTCReco;
}
}
if (picsRel != "")
{
if (pics_reco_str == "")
{
pics_reco_str += picsRel;
}
else
{
pics_reco_str += ", " + picsRel;
}
}
if (picsBand != "")
{
if (pics_reco_str == "")
{
pics_reco_str += picsBand;
}
else
{
pics_reco_str += ", " + picsBand;
}
}
//if (picsRel.ToLower().Contains("only"))
// pics_reco_str += ",Rel:NR";
//r(?:el)?(?:ease)?[-\s]?\d+\s*(?:to|and)\s*r(?:el)?(?:ease)?[-\s]?(\d+)\s*only
//\s*r(?:el)?(?:ease)?[-\s]?(\d+)\s*only
// rel 2 to rel 6
// string relpatt = @"(?:r(?:el)?(?:ease)?[-\s]?\d+\s*(?:to|and)\s*)?r(?:el)?(?:ease)?[-\s]?(\d+)\s*only";
// Match relm = Regex.Match(picsRel, relpatt,RegexOptions.IgnoreCase);
// if (relm.Success)
// {
// int rel = int.Parse(relm.Groups[1].ToString());
// if ((rel < 90) && (rel < int.Parse(uerelease)))
// {
// pics_reco_str += ", Rel:NR";
// }
//
// }
string PICSSuppBand = "NS";
if (isSuppBand)
{
PICSSuppBand = "S";
}
string idstr = "-1";
if (user_bs_rb_pics.ContainsKey(PICSSuppBand, band_rb_val))
{
idstr = user_bs_rb_pics[PICSSuppBand, band_rb_val];
}
else
{
lg.cri("no key found: picssupband" + PICSSuppBand + " requiredband " + band_rb_val + "\n" + user_bs_rb_pics.ToString());
frm.apendlog("pics support band and requiredband process failed for band:" + band_id_key, 1);
}
if (!bsrbidxdic.ContainsKey(oldTC, band_id_key))
{
bsrbidxdic[oldTC, band_id_key] = idstr;
}
// user_picsstatus | picsstatus
//
//string idstr = FormUpload.getid_Reco(pics_reco_table, PICSOutputStr);
if (!pics_reco_dic.ContainsKey(oldTC, band_id_val))
{
pics_reco_dic[oldTC, band_id_val] = pics_reco_str;
}
GenericParser.writetocsv(file_picsstatus, pics_reco_str + "\t");
pics_reco_str = String.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}", band_id_key, oldTC, band_id_val, pics_reco_str, PICSSuppBand, idstr);
GenericParser.writetocsv(outputfilename, pics_reco_str);
lg.deb("FinalOutput: " + tc + " Result: " + pics_reco_str);
}
progress += progressinc3;
if (progressint < Convert.ToInt32(progress))
{
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
}
progressint = Convert.ToInt32(progress);
}// reading database test case - band vs id end
lg.war("Missing Bands from 'picsSupBandList':\n\t\t " + string.Join(" ", StringProcess.mismatchedbandbandsupporthelper));
// GET user_picsstatus table here. as a dictionary.
dbobj.tablename = "user_picsstatus";
file_picsstatus = file_picsstatus.Replace(@"\", @"/");
dbobj.insertfile(file_picsstatus, "picsstatus");
pics_reco_table = frm.getfulltable("user_picsstatus", "picsstatus");
//lg.deb("PICS Reco String table from DB");
//lg.deb(pics_reco_table.ToString());
//lg.deb("rb_sb");
//lg.deb(bsrbidxdic.ToString());
//lg.deb("tcr: " + pics_reco_table["TC: R, REL-8"]);
foreach (KeyValuePair <string, Dictionary <string, string> > temp in tc_band_id)
{
string tc = temp.Key.Replace(" ", "");
_Dictionary <string, string> band_id = new _Dictionary <string, string>(temp.Value);
foreach (KeyValuePair <string, string> kvp in band_id)
{
string picsrecoid = "-1";
string bsrbidx = "-1";
string band_id_key = kvp.Key;
string band_id_val = kvp.Value;
string pics_reco_str = pics_reco_dic[tc, band_id_val];
string picslogic = "";
if (dict_logic.ContainsKey(tc))
{
picslogic = dict_logic[tc];
}
else
{
picslogic = "";
lg.war("logicstring error" + tc);
}
//------converting REL to Rel - start---------
foreach (KeyValuePair <string, string> kvp1 in pics_reco_table)
{
string picsstringdb = kvp1.Key;
if (picsstringdb.ToLower().Trim() == pics_reco_str.ToLower().Trim())
{
picsrecoid = kvp1.Value;
}
}
//if (pics_reco_table.ContainsKey(pics_reco_str))
//{
// picsrecoid = pics_reco_table[pics_reco_str];
//}
//else
if (picsrecoid == "-1")
{
lg.cri("No Key for " + pics_reco_str);
lg.deb(pics_reco_table.ToString());
}
if (bsrbidxdic.ContainsKey(tc, band_id_key))
{
bsrbidx = bsrbidxdic[tc, band_id_key];
}
else
{
lg.cri(String.Format("Missing ID for BS: {0} and RB : {1}", tc, band_id_key));
lg.deb(bsrbidxdic.ToString());
}
string picsbs = frm.band_vs_icesupport[band_id_key];
if (spec == "36.521-1")
{
//if ((tc_band_sheet[tc, band_id_key] == "LTE_ UL_CA") || ((tc_band_sheet[tc, band_id_key] == "64QAM")))
string desc = tc_des[tc].ToLower();
if (desc.Contains("64qam") || desc.Contains("dl ca and ul ca"))
{
string band_id_key_mod = band_id_key.ToUpper().Replace("CA_", "");
if (BandProcess.containstheword(icebandulca, band_id_key_mod))
{
picsbs = "S";
}
else
{
picsbs = "NS";
}
}
if (desc.Contains("x4") || desc.Contains("4 rx"))
{
string band_id_key_mod = band_id_key.ToUpper().Replace("CA_", "");
if (BandProcess.containstheword(ice4x4MIMO, band_id_key_mod))
{
picsbs = "S";
}
else
{
picsbs = "NS";
}
}
}
string map_str = String.Format("{0}\t{1}\t{2}\t{3}\t{4}\t{5}\t", idpicsver, bsrbidx, picsrecoid, band_id_val, picsbs, picslogic);
GenericParser.writetocsv(file_picsmapping, map_str);
}
}
progress += progressinc * 0.1;
progressint = Convert.ToInt32(progress);
//lg.inf("progress: " + progress.ToString() + "t : " + DateTime.Now.ToString("h:mm:ss tt"));
frm.SetProgress(progressint);
dbobj.tablename = "user_picsmappingtable";
file_picsmapping = file_picsmapping.Replace(@"\", @"/");
frm.SetLabelstat(status + " uploading pics information to db");
dbobj.insertfile(file_picsmapping, String.Format("`{0}`,`{1}`,`{2}`,`{3}`,`{4}`,`{5}`", "id#pics", "id#bsrb", "id#picsstat", "id#v_comb_serv_info", "icebs", "PICSLogic"));
frm.SetLabelstat(status + " Uploading pics Complete");
}
else
{
lg.cri("{MainProcess} File Does not exist ! =>" + filenameTRL);
Debug.Print("File " + filenameTRL + " NOT found!");
frm.apendlog("File " + filenameTRL + " NOT found!", 1);
}
//////lg.inf("{MainProcess} TC (from db) vs App: RAW");
//////lg.inf("======================");
//////lg.inf(TCvsApp.ToString());
//////lg.deb("{MainProcess} TC (from db) vs App: FILTERED");
//////lg.deb("======================");
//////lg.deb(TCvsAppFiltered.ToString());
//////lg.cri("Band Support: Verification:");
//////lg.cri(TCBandSupport.ToString());
// End of the Loop:
}
progress = 100;
progressint = Convert.ToInt32(progress);
frm.SetProgress(progressint);
frm.SetLabelstat("Idle");
// END
}
private static _Dictionary <string, string> processRequiredBand(_Dictionary <string, string> band_status_in, string bandapplicability)
{
_Dictionary <string, string> band_rb = new _Dictionary <string, string>();
_Dictionary <string, string> band_status = new _Dictionary <string, string>();
foreach (KeyValuePair <string, string> keyval in band_status_in)
{
string b = keyval.Key;
string bpatt = @"[FT]DD\s*(\w+)";
Match bc = Regex.Match(keyval.Key, bpatt);
if (bc.Success)
{
b = bc.Groups[1].ToString();
}
band_status[b] = keyval.Value;
}
//this might be used for required band.
//_List<string> bandOther = new _List<string> { "CA_4A-12A", "CA_2A-12A", "CA_4A-7A",
// "CA_4A-29A", "CA_2A-29A", "CA_4A-5A", "CA_4A-4A", "CA_2A-4A", "CA_2A-5A",
// "CA_2A-30A", "CA_5A-30A", "CA_4A-30A",
// "CA_30A-29A", "CA_12A-30A", "CA_4A-17A", "CA_2A-17A",
// "CA_5A-29A", "CA_7A-7A", "CA_66A-66A", "CA_66B", "CA_66C", "CA_66A-29A","4", "17", "14", "25", "2", "5", "7", "12", "13", "30", "II", "V","IV", "1900", "850"};
//_List<string> bandHO = new _List<string> { "E04-UII", "E04-UV", "E04-UIV", "E17-UII", "E17-UV", "E17-UIV", "E14-UII", "E14-UV", "E14-UIV", "E25-UII", "E25-UV", "E25-UIV", "E02-UII", "E02-UV", "E02-UIV", "E05-UII", "E05-UV", "E05-UIV", "E07-UII", "E07-UV", "E07-UIV", "E12-UII", "E12-UV", "E12-UIV", "E13-UII", "E13-UV", "E13-UIV", "E30-UII", "E30-UV", "E30-UIV", "UII-E04", "UII-E17", "UII-E14", "UII-E25", "UII-E02", "UII-E05", "UII-E07", "UII-E12", "UII-E13", "UII-E30", "UV-E04", "UV-E17", "UV-E14", "UV-E25", "UV-E02", "UV-E05", "UV-E07", "UV-E12", "UV-E13", "UV-E30", "UIV-E04", "UIV-E17", "UIV-E14", "UIV-E25", "UIV-E02", "UIV-E05", "UIV-E07", "UIV-E12", "UIV-E13", "UIV-E30" };
_List <string> intersectprioritybandlist = new _List <string>();
_List <string> statuslist = new _List <string> {
"A", "B", "P"
};
_List <string> bandlist = new _List <string>(band_status.Keys.ToList <string>());
lgstr.deb("bandlist" + bandlist.ToString());
_List <string> finalbandlist = getListSupportedBand(bandlist);
foreach (string bl in bandlist)
{
//string b = bl;
////_Dictionary<string, string> bb = new _Dictionary<string, string>();
//string bpatt = @"FDD\s*(\w+)";
//Match bc = Regex.Match(bl, bpatt);
//if (bc.Success)
//{
// b = bc.Groups[1].ToString();
//}
band_rb[bl] = "N";
}
if (bandapplicability.ToLower() == "all")
{
foreach (string d in finalbandlist)
{
band_rb[d] = "Y";
}
}
else
{
// filtered with testcase status. generate list for ABP
foreach (string d in finalbandlist)
{
var val = statuslist.Find(x => x == band_status[d]);
if (val != null)
{
intersectprioritybandlist.Add(d); //list of bands which are common within priority bands as per PTCRB
}
}
if (bandapplicability.ToLower() == "single")
{
foreach (string g in bandOther)
{
var gval = intersectprioritybandlist.Find(y => y == g.Trim());
if (gval != null)
{
band_rb[gval] = "Y";
break;
}
}
}
else if (bandapplicability.ToLower() == "irat-single")
{
foreach (string g in bandHO)
{
var gval = intersectprioritybandlist.Find(y => y == g.Trim());
if (gval != null)
{
band_rb[gval] = "Y";
break;
}
}
}
}
lgstr.inf("band_rb: " + band_rb.ToString());
return(band_rb);
}
/// <summary>
/// 贸易方式下拉数据,仓单状态下拉数据
/// </summary>
/// <param name="dictionary"></param>
/// <param name="dictionaryNo"></param>
/// <returns></returns>
public DataTable GetDatadictionaryList(_Dictionary dictionary)
{
DataTable dt = new DataTable();
StringBuilder strSqlWhere = new StringBuilder();
if (dictionary==_Dictionary.Status)
{
strSqlWhere.Append(" SELECT [dictionary_value] as list_no ,[dictionary_name] ");
strSqlWhere.Append(" FROM [ILIMS_BasicData].[dbo].[b_datadictionary] ");
strSqlWhere.AppendFormat(" WHERE dictionary_no ={0} ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
strSqlWhere.Append(" and is_valid=1 ");
}
else
{
strSqlWhere.Append(" SELECT [list_no] ,[dictionary_name] ");
strSqlWhere.Append(" FROM [ILIMS_BasicData].[dbo].[b_datadictionary] ");
strSqlWhere.AppendFormat(" WHERE dictionary_no={0} ",Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
strSqlWhere.Append(" and is_valid=1 ");
}
DataSet ds = new DataSet();
ds = DBHelper.ExecuteDataSet(strSqlWhere.ToString());
if (ds!=null||ds.Tables.Count>0)
{
dt = ds.Tables[0];
}
return dt;
}
/// <summary>
/// 获取状态字典显示值
/// </summary>
/// <param name="ActualValue"></param>
/// <returns></returns>
public string GetDisplayName(_Dictionary dictionary,string ActualValue)
{
string strDispName = string.Empty;
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" SELECT * FROM [ILIMS_BasicData].[dbo].[b_datadictionary] ");
strSqlWhere.Append(" WHERE 1=1 ");
switch (dictionary)
{
case _Dictionary.ParaExchrate:
strSqlWhere.AppendFormat(" AND dictionary_no='{0}' ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
strSqlWhere.AppendFormat(" AND dictionary_name='{0}'", ActualValue);
break;
default:
if (!string.IsNullOrWhiteSpace(dictionary.ToString()))
{
strSqlWhere.AppendFormat(" AND dictionary_no='{0}' ", Enum.Parse(typeof(_Dictionary), dictionary.ToString()).GetHashCode());
}
strSqlWhere.AppendFormat(" AND list_no='{0}'", ActualValue);
break;
}
DataSet ds = new DataSet();
ds = DBHelper.ExecuteDataSet(strSqlWhere.ToString());
if (ds!=null&&ds.Tables.Count>0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
switch (dictionary)
{
case _Dictionary.ParaExchrate:
if (row["list_no"] != DBNull.Value)
{
strDispName = row["list_no"].ToString();
}
break;
default:
if (row["dictionary_name"] != DBNull.Value)
{
strDispName = row["dictionary_name"].ToString();
}
break;
}
}
}
return strDispName;
}
// Start to process C dictionary: Adding the spec number with Item
//public static void itemProcess()
public static void itemProcess(_Dictionary <string, string> CDictRaw, string specDash1)
{
/*
* XmlDocument xmlDoc = new XmlDocument();
* string curDir = System.Environment.CurrentDirectory;
* string fullPath = Path.Combine(curDir, "Config_PICS.xml");
* xmlDoc.Load(fullPath);
* //lgstr.info(fullPath);
*
* // Let's convert dash1 spec into dash2 spec from the config file:
* // Start:
* XmlNodeList spectospecalltogether = xmlDoc.GetElementsByTagName("spectospec");
* XmlElement spectospec = (XmlElement)spectospecalltogether[0];
* XmlNodeList smallElementDash1 = spectospec.GetElementsByTagName("specdash1");
* XmlNodeList smallElementDash2 = spectospec.GetElementsByTagName("specdash2");
* _Dictionary<string, string> specToSpec = new _Dictionary<string, string>();
* for (int i = 0; i < smallElementDash1.Count; i++)
* {
* string K = smallElementDash1[i].InnerText.Trim();
* string V = smallElementDash2[i].InnerText.Trim();
* specToSpec[K] = V;
* }
* // End:
* lgstr.inf("specdash1\n"+specDash1);
* lgstr.inf("spectospec\n"+specToSpec.ToString());
*
*
*
*
* XmlNodeList specrefalltogether = xmlDoc.GetElementsByTagName("specref");
* XmlElement specref = (XmlElement)specrefalltogether[0];
* Debug.Print(specref.InnerXml);
* //lgstr.cri(specref.InnerXml);
* //XmlNode xmln = bigElement[0].Inner;
* XmlNodeList smallElementSpec = specref.GetElementsByTagName("specrefIN");
* XmlNodeList smallElementRefID = specref.GetElementsByTagName("ref_id");
* XmlNodeList smallElementSpecID = specref.GetElementsByTagName("spec_id");
*
* TwoKeyDictionary<string, string, string> specRefMap = new TwoKeyDictionary<string, string, string>();
* for (int i = 0; i < smallElementSpec.Count; i++)
* {
* string K1 = smallElementSpec[i].InnerText.Trim();
* string K2 = smallElementRefID[i].InnerText.Trim();
* string V = smallElementSpecID[i].InnerText.Trim();
* specRefMap[K1, K2] = V;
*
* }
*
* XmlNodeList allp = xmlDoc.GetElementsByTagName("mappingspec");
* _Dictionary<string, string> specIDMap = new _Dictionary<string, string>();
* foreach (XmlNode pl in allp)
* {
* string specno = pl.ChildNodes[0].InnerText.Trim();
* string id = pl.ChildNodes[1].InnerText.Trim();
* specIDMap[specno] = id;
* }
*
* lgstr.inf("specidmap\n"+specIDMap.ToString());
*
* xmlDoc = null;
* lgstr.inf("specrefmap\n"+specRefMap.ToString());
*/
//processedif = re.sub(r'(?<!#)\bA\.', s + r'#A.', processedif)
//rpatt = r'(\[\d+\]\s*)'c
string spec = specToSpec[specDash1];
_List <string> newKey = new _List <string>();
foreach (KeyValuePair <string, string> temp in CDictRaw)
{
// Filtering C string. All the invalid conditions are removerd (e.g., Note 1, etc.)
newKey.Add(temp.Key);
}
foreach (string C in newKey)
{
string fullLogic = CDictRaw[C];
//string patt1 = @"\bA\.\d\S*\b";
string patt = @"C(?:\%\d+\%)?[\w-_]+";
Match var = Regex.Match(C, patt);
string specialpatt = @"C%(\d+)%\S+";
Match varSpecial = Regex.Match(C, specialpatt);
if (varSpecial.Success)
{
string patt2 = @"(?<!#)\b[ABDGX]\.\d\S*\b";
var regex2 = new Regex(patt2, RegexOptions.IgnoreCase);
Match mc2 = Regex.Match(fullLogic, patt2);
string item2 = varSpecial.Groups[1].ToString();
if (mc2.Success)
{
fullLogic = regex2.Replace(fullLogic, m => item2 + "#" + m);
}
CDictRaw[C] = fullLogic;
}
else if (var.Success)
{
// Replacing references
string patt1 = @"(\[[\d\.\-]+\])\s*\b([ABDGX]\.\d\S*)\b";
var regex1 = new Regex(patt1, RegexOptions.IgnoreCase);
//fullLogic = regex1.Replace(fullLogic, m => item1 + "#" + m);
MatchCollection mcc = Regex.Matches(fullLogic, patt1);
foreach (Match temp in mcc)
{
string item1 = temp.Groups[1].ToString();
string item2 = specRefMap[spec, item1];
//fullLogic = regex1.Replace(fullLogic, m => item1 + "#" + m.Groups[2]);
fullLogic = fullLogic.Replace(item1, item2 + "#");
}
//string item1 = Regex.Match(fullLogic,patt1);
// Adding spec no and hash
string patt2 = @"(?<!#)\b[ABDGX]\.\d\S*\b";
var regex2 = new Regex(patt2, RegexOptions.IgnoreCase);
Match mc2 = Regex.Match(fullLogic, patt2);
if (mc2.Success)
{
string item2 = specIDMap[spec];
fullLogic = regex2.Replace(fullLogic, m => item2 + "#" + m);
}
CDictRaw[C] = fullLogic;
}
else
{
CDictRaw.Remove(C);
}
}
}
// public static string condSimple(string condVal, _Dictionary<string, string> pics_support)
// {
// // this method must return true or false only.
// string boolstr = condVal;
// string strPatt = @"if([(\bA\.\S+|\bB\.\S+|\bD\.\S+|\bG\.\S+|\bX\.\S+|AND|OR|NOT|\s+)]+)then\s+[roam]\s+else\s+n\/a";
// Match matchPartGr = Regex.Match(condVal, strPatt, RegexOptions.IgnoreCase);
// if (matchPartGr.Success)
// {
// boolstr = logicstrProcess(matchPartGr.Groups[1].ToString(), pics_support);
// }
// else
// {
// lgstr.err(" {condSimple} LogicalExprError: " + condVal);
// }
// lgstr.inf(" {condSimple} " + condVal + " => " + boolstr);
// return boolstr;
// }
public static string condCompl(string cstring, _Dictionary <string, string> c_logic_map, _Dictionary <string, string> pics_support)
{
//update c_logic map
//
string logicstring = c_logic_map[cstring];
//lgstr.deb("\t{condCompl} eval start for " + String.Format("[{0}] -> {1}", cstring,logicstring));
string outstr = "";
string condResRecur = "";
string condResRecur2 = "";
//Debug.Print(cstring);
//Debug.Print("xxxx: " + logicstring);
if (logicstring.ToLower() == "true")
{
outstr = "True";
}
else if (logicstring.ToLower() == "false")
{
outstr = "False";
}
else if ((logicstring.Trim().ToLower() == "void") || (logicstring.Trim().ToLower() == @"n/a") || (logicstring.Trim().ToLower().Contains("ffs")))
{
// lgstr.inf("Void Information: " + logicstring);
outstr = "False";
}
else
{
var regex = new Regex(@"(and|or|not)", RegexOptions.IgnoreCase);
logicstring = regex.Replace(logicstring, m => m.ToString().ToUpper());
//simple pattern need to correct
string pattSimple = @"^if(?:(?:\d+#\S+)|AND|OR|NOT|\(|\)|\s)+then\s+[RAM]\s+else\s+n\/a";
Match mcSimple = Regex.Match(logicstring, pattSimple, RegexOptions.IgnoreCase);
string pattMnemonic = @"if((?:(?:O_\S+)|AND|OR|NOT|\(|\)|\s)+)then";
Match mcMnemonic = Regex.Match(logicstring, pattMnemonic, RegexOptions.IgnoreCase);
//string pattMnemonic = @"if(?:(?:O_\S+)|AND|OR|NOT|\(|\)|\s)+then\s+[RAM]\s+else\s+n\/a";
//@"if\s*(.+)\s+then\s+o\s+else\s+(?:\()?(?:\s+)?if\s*(.+)\s+then(.+)"; //07-25-2017
string pattComplGen = @"if\s * (.+)\s + then\s + o\s +else\s + (?:\() ? (?:\s +)?if\s *\(?\s * (.+?)\s *\)?\s + then(.+)";
Match mcComplGen = Regex.Match(logicstring, pattComplGen, RegexOptions.IgnoreCase);
string pattComplCTPSExtra = @"if((?:(?:c\S+)|(?:\d+#\S+)|AND|OR|NOT|\(|\)|\s)+)then\s+[MORA]\s+else\s+n\/a";
Match mcComplCTPSxtra = Regex.Match(logicstring, pattComplCTPSExtra, RegexOptions.IgnoreCase);
if (mcSimple.Success)
{
//outstr = condSimple(logicstring, pics_support);
lgstr.inf("\t{condCompl} pattern mcComplGen # " + logicstring);
}
else if (mcComplGen.Success)
{
// if the logic string is a complex type
condResRecur = mcComplGen.Groups[1].ToString();
condResRecur2 = mcComplGen.Groups[2].ToString();
lgstr.inf("\t{condCompl} pattern mcComplGen # " + condResRecur + " # " + condResRecur2 + " # " + logicstring);
// After processing condResRecur, get true/false
if (condResRecur != "")
{
string pattIn = @"C(?:\%\d+\%)?[\w-_]+";
var mcIn = Regex.Matches(condResRecur, pattIn);
//string tempres ;
foreach (var mcInTemp in mcIn)
{
string tempres = c_logic_map[mcInTemp.ToString()];
lgstr.inf("\t{condCompl}" + condResRecur + " match: " + mcInTemp.ToString() + " 1stResult: " + tempres);
if ((tempres != "True") && (tempres != "False"))
{
lgstr.inf("\tRecursive call: " + mcInTemp.ToString());
tempres = condCompl(mcInTemp.ToString(), c_logic_map, pics_support);
}
condResRecur = condResRecur.Replace(mcInTemp.ToString(), tempres);
string boolstrverify = condResRecur.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match m = Regex.Match(boolstrverify, @"\w+");
if (!(m.Success))
{
lgstr.inf("\t{condCompl} part1Change1: " + condResRecur + " match: " + m.ToString());
if (tempres.Trim() != "")
{
condResRecur = evalBooleanExpr(tempres).ToString();
}
}
lgstr.inf("\t{condCompl} part1change2:" + condResRecur);
}
}
if (condResRecur.ToLower() == "true")
{
outstr = "True";
}
else if (condResRecur.ToLower() == "false")
{
//evaluate 2nd part
outstr = logicstrProcess(condResRecur2, pics_support);
}
else
{
//return the problematic string.
lgstr.cri("\t{condcompl} Improper Condition" + condResRecur);
outstr = condResRecur;
}
}
else if (mcComplCTPSxtra.Success)
{
condResRecur = mcComplCTPSxtra.Groups[1].ToString();
lgstr.inf("\t{condcompl} pattern mcComplCTPSxtra # " + condResRecur + " # " + logicstring);
if (condResRecur != "")
{
string pattIn = @"C(?:\%\d+\%)?[\w-_]+";
string pattItem = @"\d+#\b[AEG]\.\d[\d\-\/\.a-z]+\b";
var mcIn = Regex.Matches(condResRecur, pattIn);
var mcItem = Regex.Matches(condResRecur, pattItem);
foreach (var mcItemTemp in mcItem)
{
string tempres = convertToBoolExpr(pics_support, mcItemTemp.ToString());
//condResRecur = convertToBoolExpr(pics_support, condResRecur);
condResRecur = condResRecur.Replace(mcItemTemp.ToString(), tempres);
lgstr.inf("\t{condcompl} tempres: " + tempres + "#" + condResRecur);
//logicstring = convertToBoolExpr(pics_support, logicstring);
}
lgstr.inf("\t{condCompl} replace item with TF# " + condResRecur);
//c_logic_map[cstring] = logicstring;
//string tempres ;
foreach (var mcInTemp in mcIn)
{
lgstr.inf("\tregexmatch" + mcInTemp.ToString());
if (!c_logic_map.ContainsKey(mcInTemp.ToString()))
{
lgstr.inf(c_logic_map.ToString());
}
string tempres = c_logic_map[mcInTemp.ToString()];
lgstr.inf("\t{condCompl}" + condResRecur + "C match: " + mcInTemp.ToString() + " 1stResult: " + tempres);
if ((tempres != "True") && (tempres != "False"))
{
lgstr.inf("\trecursive call: " + mcInTemp.ToString());
tempres = condCompl(mcInTemp.ToString(), c_logic_map, pics_support);
}
condResRecur = condResRecur.Replace(mcInTemp.ToString(), tempres);
string boolstrverify = condResRecur.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match m = Regex.Match(boolstrverify, @"\w+");
if (!(m.Success))
{
lgstr.inf("\t{condCompl} part1Change1: " + condResRecur + " match: " + m.ToString());
if (tempres.Trim() != "")
{
condResRecur = evalBooleanExpr(tempres).ToString();
}
}
//lgstr.inf(" {condCompl} part1change2:" + condResRecur);
}
lgstr.inf("\t{condCompl} Final val TF# " + condResRecur);
outstr = condResRecur;
}
}
else if (mcMnemonic.Success)
{
condResRecur = mcMnemonic.Groups[1].ToString();
lgstr.inf("\t{condcompl} pattern mcMnemonic # " + condResRecur + " # " + logicstring);
if (condResRecur != "")
{
string patMnemonic = @"\bO_\S+\b";
var mcItem = Regex.Matches(condResRecur, patMnemonic);
Regex itemRegex = new Regex(patMnemonic, RegexOptions.IgnoreCase);
condResRecur = itemRegex.Replace(condResRecur, m => convertBoolHelper(m.ToString(), PICSmnemonicDic));
lgstr.inf("\t{condCompl} mnemonic replace item with TF# " + condResRecur);
string boolstrverify = condResRecur.Replace("AND", "").Replace("OR", "").Replace("NOT", "").Replace("True", "").Replace("False", "");
Match mtmp = Regex.Match(boolstrverify, @"\w+");
if (!(mtmp.Success))
{
lgstr.inf("\t{condCompl} pnemonic: " + condResRecur + " match: " + mtmp.ToString());
if (condResRecur.Trim() != "")
{
condResRecur = evalBooleanExpr(condResRecur).ToString();
}
}
outstr = condResRecur;
}
lgstr.inf("\t{condCompl} final: " + condResRecur + " match: " + outstr);
}
else
{
lgstr.err("\t{condCompl} no matching pattern: " + logicstring);
outstr = "False";
}
}
// For End:
c_logic_map[cstring] = outstr;
return(outstr);
}
// it returns a dictionary from a csv file with key and value column index passed.
public _Dictionary <string, string> getdictionaryRowCol(int val_id, int key_id = 0, string CSVName = "", bool remspacefrmkey = false)
{
lg.deb("FILE: " + CSVName);
_Dictionary <string, string> dictcsv = new _Dictionary <string, string>();
using (var fs = File.OpenRead(CSVName))
{
using (var reader = new StreamReader(fs))
{
while (!reader.EndOfStream)
{
_List <string> valTot = new _List <string>();
var line = reader.ReadLine();
if (line != "")
{
var values = line.Split('\t');
int colidx = 0;
foreach (string val in values)
{
string val2 = val.Replace("\"", "");
if ((colidx == key_id) && (remspacefrmkey))
{
val2 = val2.Replace(" ", "");
}
valTot.Add(val2);
colidx++;
}
string dctkey = valTot[key_id];
string fn = Path.GetFileName(CSVName);
if (fn.Contains("TVA"))
{
dctkey = dctkey.ToLower();
}
if ((values.Count() > val_id) && (values.Count() > key_id))
{
try
{
if (dictcsv.ContainsKey(dctkey))
{
lg.war("\t{gp:getdictionary} duplicate entry in " + CSVName + " " + valTot[key_id] + " " + valTot[val_id]);
}
else
{
dictcsv.Add(dctkey, valTot[val_id]);
}
}
catch
{
lg.err("\t{gp:getdictionary} " + valTot[key_id] + " \n\t\t\t" + valTot[val_id]);
}
}
else
{
//lg.war("{gp:getdictionary} "+ line);
if (values.Count() > key_id)
{
dictcsv.Add(dctkey, @"N/A");
}
}
}
}
}
}
return(dictcsv);
}
private void FormUpload_Load(object sender, EventArgs e)
{
XmlDocument xmlDoc = new XmlDocument();
string curDir = System.Environment.CurrentDirectory;
string fullPath = Path.Combine(curDir, "Config_PICS.xml");
xmlDoc.Load(fullPath);
XmlNodeList requiredbandtag = xmlDoc.GetElementsByTagName("requiredband");
XmlElement allrequiredband = (XmlElement)requiredbandtag[0];
XmlNodeList rb_order_ho = allrequiredband.GetElementsByTagName("handover");
XmlNodeList rb_order_other = allrequiredband.GetElementsByTagName("others");
rb_order_ho_str = rb_order_ho[0].InnerText.Trim();
rb_order_other_str = rb_order_other[0].InnerText.Trim();
XmlNodeList logleveltag = xmlDoc.GetElementsByTagName("colindexpicsfile");
XmlElement colidx = (XmlElement)logleveltag[0];
XmlNodeList uereleaseinf = xmlDoc.GetElementsByTagName("UERelease");
string uerelease = uereleaseinf[0].InnerText.Trim();
PICSParseProcessing.uerelease = uerelease;
XmlNodeList cvltvaloctag = xmlDoc.GetElementsByTagName("cvltvafileslocation");
string cvltvalocation = cvltvaloctag[0].InnerText.Trim();
PICSParseProcessing.servDir = cvltvalocation;
lg.inf("CVL TVA location: " + cvltvalocation);
//Debug.Print("location:"+cvltvalocation);
XmlNodeList smallElementDash1 = colidx.GetElementsByTagName("cols");
XmlNodeList smallElementDash2 = colidx.GetElementsByTagName("idx");
colidxmapingdic = new _Dictionary <string, string>();
for (int i = 0; i < smallElementDash1.Count; i++)
{
string K = smallElementDash1[i].InnerText.Trim();
string V = smallElementDash2[i].InnerText.Trim();
colidxmapingdic[K] = V;
}
allchkbox = new CheckBox[testcategory.Count()];
int n = 0;
foreach (string testcat in testcategory)
{
CheckBox chkbx = new CheckBox();
chkbx.AutoSize = true;
//180 - 245-
if (n < 3)
{
chkbx.Location = new System.Drawing.Point(140 + 62 * n, 75);
}
else
{
chkbx.Location = new System.Drawing.Point(140 + 62 * (n - 3), 100);
}
chkbx.Name = "chkBox" + testcat;
chkbx.Size = new System.Drawing.Size(50, 20);
//chkbx.TabIndex = 31;
chkbx.Text = testcat;
chkbx.UseVisualStyleBackColor = true;
allchkbox[n] = chkbx;
chkbx.CheckedChanged += new System.EventHandler(this.chkchangeevent);
n++;
this.Controls.Add(chkbx);
}
}
private void chkchangeevent(object sender, EventArgs e)
{
List <string> commonverlist = new List <string>();
List <string> curList = new List <string>();
CheckBox cur_chkbx = (CheckBox)sender;
Debug.Print("Current chkbox" + cur_chkbx.Name);
tc_cat_selected.Clear();
commonverlist.Clear();
bool first = true;
foreach (string testcat in testcategory)
{
CheckBox chkbx = (CheckBox)this.Controls["chkBox" + testcat];
if (chkbx.Checked)
{
Debug.Print("check cat: " + testcat);
tc_cat_selected.Add(testcat);
if (!dbobj.getconnectionstat())
{
dbobj.DatabaseName = testcat.ToLower() + "testplandb";
dbobj.connectToDatabase();
}
else
{
dbobj.DatabaseName = testcat.ToLower() + "testplandb";
dbobj.changedb();
}
if (dbobj.getconnectionstat())
{
versiontable = getfulltable("gcfptcrbver", "ver_gcf_ptcrb_op");
curList = versiontable.Keys.ToList();
//if (curList.Count == 0)
//{
// Debug.Print("curlist empty");
// commonList.Clear();
//}
//else
if (curList.Count != 0)
{
if (first)
{
commonverlist = curList;
first = false;
}
else
{
List <string> commonlistclone = new List <string>(commonverlist);
commonverlist.Clear();
Debug.Print("Commonlistclone: " + string.Join(",", commonlistclone));
foreach (string specver in curList)
{
Debug.Print("specver" + specver);
if (commonlistclone.Contains(specver))
{
commonverlist.Add(specver);
}
//comboBoxGcfver.Items.Add(gcfv);
//checkBoxComboBox1.Items.Add(gcfv);
}
}
}
}
}
}
//comboBoxGcfver.Items.Clear();
checkBoxComboBox1.Items.Clear();
//comboBoxGcfver.Text = "";
foreach (string specver in commonverlist)
{
//comboBoxGcfver.Items.Add(specver);
checkBoxComboBox1.Items.Add(specver);
}
//lg.deb("Common Versions: " + String.Join(",",commonList));
}
/// <summary>
/// 获取显示值
/// </summary>
/// <param name="ActualValue"></param>
/// <returns></returns>
public string GetDisplayName(_Dictionary dictionary, string ActualValue)
{
return(this.LogicDal.GetDisplayName(dictionary, ActualValue));
}
private void uploadDatabase()
{
EnableButton(false);
int testcatcount = 0;
//string PICSFileName = "XMM7480_PICS_V1.4.xlsx";
_List <string> fileSpecDataList = new _List <string>();
// File name prefix: Example: 34.121-1_CVL.csv, 34.121-1_TVA_RF.csv, etc.
fileSpecDataList.Add("34.123-1"); //fileindex 0
fileSpecDataList.Add("36.523-1"); //fileindex 1
fileSpecDataList.Add("36.521-1"); //fileindex 2
fileSpecDataList.Add("36.521-3"); //fileindex 3
fileSpecDataList.Add("34.121-1"); //fileindex 4
fileSpecDataList.Add("51.010-2"); //fileindex 5
// Chad's specs:
fileSpecDataList.Add("31.121-1"); //fileindex 6
fileSpecDataList.Add("31.124-1"); //fileindex 7
fileSpecDataList.Add("34.229-1"); //fileindex 8
fileSpecDataList.Add("51.010-4"); //fileindex 9 used in new code
fileSpecDataList.Add("102 230-1"); //fileindex 10
fileSpecDataList.Add("37.571-1"); //fileindex 11
fileSpecDataList.Add("37.571-2"); //fileindex 12
fileSpecDataList.Add("34.171"); //fileindex 13
fileSpecDataList.Add("37.901"); //fileindex 14
fileSpecDataList.Add("tty"); //fileindex 15
fileSpecDataList.Add("at-command"); //fileindex 16
fileSpecDataList.Add("34.122"); //fileindex 17
string[] onever = allver.Split(',');
Debug.Print("Database Name: ");
Debug.Print(dbobj.DatabaseName);
foreach (string ver in onever)
{
gcfver = ver.Trim();
foreach (string testcat in tc_cat_selected)
{
testcatcount++;
SetLabelstat2(string.Format("{0} {1} {2} [{3}/{4}]", picsver, gcfver, testcat, testcatcount, (tc_cat_selected.Count * onever.Count())));
dbnameprefix = testcat.ToString().ToLower();
GenericParser.filereset.Clear();
if (!dbobj.getconnectionstat())
{
dbobj.DatabaseName = dbnameprefix + "testplandb";
dbobj.connectToDatabase();
}
else
{
dbobj.DatabaseName = dbnameprefix + "testplandb";
dbobj.changedb();
}
if (dbobj.getconnectionstat())
{
apendlog("Connected to : " + dbnameprefix + "testplandb");
versiontable = getfulltable("gcfptcrbver", "ver_gcf_ptcrb_op");
}
else
{
MessageBox.Show("no db connection");
}
_List <string> specTRLFiles = new _List <string>();
//_List<string> specTVAFiles = new _List<string>();
//_List<string> specCVLFiles = new _List<string>();
lg.inf("Select :(database) " + dbnameprefix);
lg.inf("all spec files" + fileSpecDataList.ToString());
switch (dbnameprefix)
{
case "rf":
List <int> rffiles = new List <int>()
{
2, 4, 5
};
foreach (int psf in rffiles)
{
if ((psf == 4) || (psf == 5))
{
specTRLFiles.Add(fileSpecDataList[psf] + "_TRL_RF.txt");
}
else
{
specTRLFiles.Add(fileSpecDataList[psf] + "_TRL.txt");
}
}
//specTVAFiles.Add(fileSpecDataList[2] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[2] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[4] + "_TVA_RF.csv");
//specCVLFiles.Add(fileSpecDataList[4] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[5] + "_TVA_RF.csv");
//specCVLFiles.Add(fileSpecDataList[5] + "_CVL.csv");
break;
case "rrm":
List <int> rrmfiles = new List <int>()
{
3, 4, 17
};
foreach (int psf in rrmfiles)
{
if (psf == 4)
{
specTRLFiles.Add(fileSpecDataList[psf] + "_TRL_RRM.txt"); // only 2 has no RF in file
}
else
{
specTRLFiles.Add(fileSpecDataList[psf] + "_TRL.txt");
}
}
//specTVAFiles.Add(fileSpecDataList[3] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[3] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[4] + "_TVA_RRM.csv");
//specCVLFiles.Add(fileSpecDataList[4] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[17] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[17] + "_CVL.csv");
break;
case "ctps":
List <int> psfiles = new List <int>()
{
0, 1, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16
};
//List<int> psfiles = new List<int>() { 7};
foreach (int psf in psfiles)
{
if (psf == 5)
{
specTRLFiles.Add(fileSpecDataList[psf] + "_TRL_CTPS.txt");
}
else
{
specTRLFiles.Add(fileSpecDataList[psf] + "_TRL.txt");
}
}
//specTVAFiles.Add(fileSpecDataList[1] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[1] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[0] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[0] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[5] + "_TVA_CTPS.csv");
//specCVLFiles.Add(fileSpecDataList[5] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[6] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[6] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[7] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[7] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[8] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[8] + "_CVL.csv");
//
////specTVAFiles.Add(fileSpecDataList[9] + "_TVA.csv");
////specCVLFiles.Add(fileSpecDataList[9] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[10] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[10] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[11] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[11] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[12] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[12] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[13] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[13] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[14] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[14] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[15] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[15] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[16] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[16] + "_CVL.csv");
break;
case "att":
//specTVAFiles.Add(fileSpecDataList[2] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[2] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[4] + "_TVA_RF.csv");
//specCVLFiles.Add(fileSpecDataList[4] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[5] + "_TVA_RF.csv");
//specCVLFiles.Add(fileSpecDataList[5] + "_CVL.csv");
break;
default:
break;
case "vzw":
//specTVAFiles.Add(fileSpecDataList[1] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[1] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[0] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[0] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[5] + "_TVA_CTPS.csv");
//specCVLFiles.Add(fileSpecDataList[5] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[6] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[6] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[7] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[7] + "_CVL.csv");
//
//specTVAFiles.Add(fileSpecDataList[8] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[8] + "_CVL.csv");
//specTVAFiles.Add(fileSpecDataList[9] + "_TVA.csv");
//specCVLFiles.Add(fileSpecDataList[9] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[10] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[10] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[11] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[11] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[12] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[12] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[13] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[13] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[14] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[14] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[15] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[15] + "_CVL.csv");
// specTVAFiles.Add(fileSpecDataList[16] + "_TVA.csv");
// specCVLFiles.Add(fileSpecDataList[16] + "_CVL.csv");
break;
}
//PICSParseProcessing.mainprocess(this.textBoxPath.Text, specTVAFiles, specCVLFiles, lg, dbobj, this);
PICSParseProcessing.mainprocess(this.textBoxPath.Text, specTRLFiles, lg, dbobj, this);
}
}
/*
*
*/
apendlog("Processing complete");
EnableButton(true);
SetLabelstat("Idle");
SetLabelstat2("Task Completed. ");
}
static void Main(string[] args)
{
/*
* TwoKeyDictionary<string, string, string> readconf = new TwoKeyDictionary<string, string, string>();
* MISC.readconfig_2kdict("conf\\GCF_BI_IRAT_TC.conf",readconf);
* Debug.Print(readconf.ToString());
* Dictionary<
* string,string> ab = readconf["36.523-1"];
* _Dictionary<string,string> abc = new _Dictionary<string, string>(ab);
* Debug.Print(abc.ToString());
* Dictionary<string, List<string>> t1 = MISC.readconfiglist("conf\\PTCRB_IRAT_band.conf",'\t');
* foreach (KeyValuePair<string , List<string>> kvp in t1)
* {
* Debug.Print(kvp.Key);
* Debug.Print("\t\t"+string.Join(",",kvp.Value));
* }
*/
Logging lg = new Logging("log.log", 0);
MISC.lgstr = lg;
_Dictionary <string, string> configdic = MISC.readconfig(@"conf\\config.conf");
string[] excelfilearr_env = configdic["ecfile"].Split(',');
string[] sheetnamearr_env = configdic["ecsheet"].Split(',');
string printlevelforenvcondition = configdic["envdebprint"];
string bandsupportfile = configdic["bandsupportfile"];
string bandsupportproject = configdic["bandsupportproject"];
bool sheetspecwise = Convert.ToBoolean(configdic["sheetspecwise"]);
string[] gcfsheetarr = configdic["gcfsheetarr"].Split(',');
string[] gcfarrBI = configdic["gcfbandlistforBI"].Split(',');
string[] gcfarrBIM = configdic["gcfbandlistforBIM"].Split(',');
string[] gcfarrBIW = configdic["gcfbandlistforBIW"].Split(',');
string[] ptcrbspecarr = configdic["ptcrbspecarr"].Trim().Split(',');
string[] ptcrbarrBI = configdic["ptcrbbandlistforBI"].Trim().Split(',');
string[] ptcrbarrBIW = configdic["ptcrbbandlistforBIW"].Trim().Split(',');
_Dictionary <string, string> bandlistdic = MISC.readconfig(bandsupportfile);
Debug.Print(bandlistdic.ToString());
Dictionary <string, string[]> prjsupbandlist = MISC.prjsupbl(bandlistdic, bandsupportproject);
_List <string> allband = new _List <string>();
_List <string> ulcaband = new _List <string>();
foreach (KeyValuePair <string, string[]> kvp in prjsupbandlist)
{
if (kvp.Key.ToUpper() == "ULCA")
{
ulcaband.AddRange(kvp.Value);
}
else
{
allband.AddRange(kvp.Value);
}
lg.deb("key: " + kvp.Key + " val: " + String.Join(" ", kvp.Value));
}
lg.inf("All together" + allband.ToString());
MISC.PICSBandSupportList = allband;
Dictionary <string, List <string> > spec_tc_env = new Dictionary <string, List <string> >();
for (int xl = 0; xl < excelfilearr_env.Count(); xl++)
{
string excelfile_env = excelfilearr_env[xl];
string sheetname_env = sheetnamearr_env[xl];
string[] filenamepart = excelfile_env.Split('_');
string spec = filenamepart[0];// +"."+ filenamepart[1];
Debug.Print("spec:" + spec + ":");
spec_tc_env.Add(spec, new List <string>());
ParseExcel envpe = new ParseExcel(excelfile_env);
envpe.lgx = lg;
DataTable dt_env = envpe.GetExcelData(sheetname_env + "$");
envpe.processenv(dt_env, spec_tc_env, printlevelforenvcondition);
}
foreach (KeyValuePair <string, List <string> > kvp in spec_tc_env)
{
lg.war("spec: " + kvp.Key);
lg.war("bandlist extreme" + String.Join("#", kvp.Value.ToArray()));
}
//ParseExcel envcond = new ParseExcel(excelfile_env);
Console.WriteLine("This program will parse and process GCF/PTCRB file.");
Console.WriteLine("First argument is g/p g=> GCF, p=> PTCRB.");
Console.WriteLine("Second argument is file name");
Console.WriteLine("========================================================\n\n");
if (args.Length != 2)
{
Console.WriteLine("Please add exactly two argument ");
}
else
{
string file = args[1];
if (File.Exists(file))
{
if (args[0].ToLower() == "g")
{
//code for gcf here.
Console.WriteLine("Now GCF file processing ...");
ParseExcel.BIlist = gcfarrBI;
ParseExcel.BIlistW = gcfarrBIW;
ParseExcel.BIlistM = gcfarrBIM;
ParseExcel pex = new ParseExcel(file, "g");
pex.lgx = lg;
pex.cleanupfolder();
//List<string> sheetlist = pex.GetExcelsheetslist();
foreach (string sh in gcfsheetarr)
{
lg.inf("processing Sheet: " + sh);
DataTable dt = pex.GetExcelData(sh + "$");
pex.processgcffile(dt, spec_tc_env);
}
pex.writeoutput();
Console.WriteLine("Processing done");
}
else if (args[0].ToLower() == "p")
{
//code for ptcrb here.
Console.WriteLine("Now PTCRB file processing ...");
ParseExcel.BIlist = ptcrbarrBI;
ParseExcel.BIlistW = ptcrbarrBIW;
ParseExcel pex = new ParseExcel(file, "p");
pex.lgx = lg;
pex.cleanupfolder();
DataTable dt = pex.GetExcelData("Sheet$");
pex.processptcrbfile(dt, spec_tc_env, ptcrbspecarr);
pex.writeoutput();
Console.WriteLine("Processing done");
}
else
{
Console.WriteLine("Please use letter g/p as the first argument ");
}
}
else
{
Console.WriteLine("The file path is invalid");
Debug.Print("file not found");
lg.cri("file not found");
}
}
}
/// <summary>
/// 贸易方式下拉数据,仓单状态下拉数据
/// </summary>
/// <param name="dictionary"></param>
/// <returns></returns>
public DataTable GetDatadictionaryList(_Dictionary dictionary)
{
var data = this.LogicDal.GetDatadictionaryList(dictionary);
return(data);
}
