public Dictionary <int, List <int> > upload_RelaHSCIQ(string newfile, string fileName, string action, JObject json_formdata)
{
Sql.RelaHSCCIQ bc = new Sql.RelaHSCCIQ();
DataTable dtExcel = GetExcelData_Table(Server.MapPath(newfile), 0);
//DataTable dtExcel = GetExcelData_Table(newfile, 0);
List <string> stringList = new List <string>();
//停用人
string stopman = "";
//存放成功信息
List <int> repeatListsuccess = new List <int>();
//存放失败条数
List <int> repeatListerror = new List <int>();
//记住insert成功的条数
int count = 0;
//返回信息
Dictionary <int, List <int> > dcInts = new Dictionary <int, List <int> >();
for (int i = 0; i < dtExcel.Rows.Count; i++)
{
for (int j = 0; j < dtExcel.Columns.Count; j++)
{
stringList.Add(dtExcel.Rows[i][j].ToString());
}
//HS
string HSCODE = stringList[0];
//CIQ
string CIQCODE = stringList[1];
string REMARK = stringList[2];
//string ENABLED = stringList[4] == "是" ? "1" : "0";
string ENABLED = "1";
//维护人
string CREATEMANNAME = json_formdata.Value <string>("CREATEMANNAME");
//启用时间
string STARTDATE = json_formdata.Value <string>("STARTDATE") == "" ? DateTime.MinValue.ToShortDateString() : json_formdata.Value <string>("STARTDATE");
//停用日期
string ENDDATE = json_formdata.Value <string>("ENDDATE") == ""
? DateTime.MaxValue.ToShortDateString()
: json_formdata.Value <string>("ENDDATE");
if (ENABLED == "1")
{
stopman = "";
}
else
{
FormsIdentity identity = HttpContext.Current.User.Identity as FormsIdentity;
string userName = identity.Name;
JObject json_user = Extension.Get_UserInfo(userName);
stopman = (string)json_user.GetValue("ID");
}
//导入判断条件
List <int> inlist = bc.CheckRepeat("", HSCODE, CIQCODE);
string check_repeat = bc.Check_Repeat(inlist);
if (check_repeat == "")
{
bc.insert_rela_hs_ciq_excel(HSCODE, CIQCODE, ENABLED, REMARK, stopman, STARTDATE, ENDDATE);
count = count + 1;
}
else
{
repeatListerror.Add(i + 2);
}
//清除
stringList.Clear();
}
repeatListsuccess.Add(count);
dcInts.Add(1, repeatListsuccess);
dcInts.Add(2, repeatListerror);
return(dcInts);
}
