Boolean ImportFile(string strFilePath1)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
ImportDAL iObj = new ImportDAL();
try
{
DataSet ds = new DataSet();
ImportExcelReport tObj = new ImportExcelReport();
ds = tObj.importHTH(strFilePath1, _yrmo);
parseDataSet pObj = new parseDataSet();
pObj.parseHTH(ds, _yrmo);
counter = iObj.insertHTHHeadcounts(_yrmo);
importStat = true;
int _counter = iObj.getImportCount("HTH", _yrmo);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "Headcount", "International HTH Report Import", _yrmo, _counter);
}
catch (Exception ex)
{
iObj.Rollback("HTH", _yrmo);
throw ex;
}
finally
{
File.Delete(strFilePath1);
FileUpload1.FilePost.InputStream.Flush();
FileUpload1.FilePost.InputStream.Close();
FileUpload1.FilePost.InputStream.Dispose();
}
return(importStat);
}
public int ImportCrew(object dataTable, string shipNumber)
{
ImportDAL crewImportDAL = new ImportDAL();
//crewImportDAL.ImportCrew(dataTable, shipNumber);
return(crewImportDAL.ImportTemporaryCrew(dataTable, shipNumber));
}
/// <summary>
/// 从房产库查询数据构建BDC插入实例
/// </summary>
/// <param name="slbh"></param>
/// <returns></returns>
private static List <DOC_BINFILE> GetDoc_Binfile(string slbh, string fcslbh)
{
List <VolEleArcDtl> veads = ImportDAL.GetVolEleArcDtl(fcslbh);
List <DOC_BINFILE> list = new List <DOC_BINFILE>();
//if(null!=Res_list && Res_list.Count>0)
//{
// foreach (Result res in Res_list)
// {
Thread.Sleep(200);
foreach (VolEleArcDtl v in veads)
{
v.imgName = v.imgName.Replace(@"\\192.168.134.245\", "").Replace(@"\\192.168.100.202\", "").Replace(@"K:\", "").Replace(@"\\192.168.100.202 \", "");
v.imgName = v.imgName.Replace("\\", "/");
VolEleArc vea = GetVolEleArc(v.VolEleArc_ID);
DOC_BINFILE doc_binfile = new DOC_BINFILE();
doc_binfile.BINID = GetCID(slbh, vea.EleArcName);
if (doc_binfile.BINID != "")
{
doc_binfile.FTPATH = v.imgName;
doc_binfile.FILEID = Guid.NewGuid().ToString();
doc_binfile.FILENAME = vea.EleArcName;
doc_binfile.EXTNAME = GetExtName(v.imgName);
doc_binfile.ISCOMPRESSED = "否";
doc_binfile.ISENCRYPTED = "否";
list.Add(doc_binfile);
}
}
// }
//}
return(list);
}
Boolean ImportFile(string strFilePath1)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
ImportDAL iObj = new ImportDAL();
try
{
DataSet ds = new DataSet();
ImportExcelReport tObj = new ImportExcelReport();
ds = tObj.importDFNORF(strFilePath1);
parseDataSet pObj = new parseDataSet();
counter = pObj.parseDFnoRF(ds, _yrmo);
importStat = true;
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Claims Reconciliation", "RFDF", "DFnoRF Report Import", _yrmo, counter);
}
catch (Exception ex)
{
iObj.Rollback("DF", _yrmo);
throw ex;
}
finally
{
File.Delete(strFilePath1);
}
return(importStat);
}
private static void ImportQS(string base64Str, string sLBH, string userName)
{
string path = sLBH + "_完税凭证.jpg";
string cid = GetCID(sLBH, "完税凭证", "文件夹", userName);
DOC_BINFILE doc_binfile = new DOC_BINFILE();
string binid = GetCID(sLBH, "完税凭证", "文件", userName, cid);//att.CID;
doc_binfile.BINID = binid;
doc_binfile.FTPATH = path;
doc_binfile.FILEID = Guid.NewGuid().ToString();
doc_binfile.FILENAME = "完税凭证";
doc_binfile.EXTNAME = "jpg";//GetExtName(v.imgName);
doc_binfile.ISCOMPRESSED = "否";
doc_binfile.ISENCRYPTED = "否";
QSPicUploadToFtp(sLBH, base64Str, doc_binfile);
if (ImportDAL.ExistDoc_binfile(doc_binfile))
{
ImportDAL.UpDateDoc_binfile(doc_binfile);
}
else
{
ImportDAL.InsertDoc_binfile(doc_binfile);
}
}
public static BDCFilterResult ImportFromFC(string slbh, string userName)
{
BDCFilterResult res = new BDCFilterResult();
int count = 0;
FC_REWRITE_TAG tag = new FC_REWRITE_TAG();
string FCslbh = GetRealSLBH(slbh);
//string slbh = row[0].ToString();
try
{
if (CanImport(FCslbh))
{
ImportFCDA(slbh, FCslbh, userName, ref count);
tag.FILECOUNT = count.ToString();
//tag.FILENAME =doc_bin[0].BINID
tag.ID = Guid.NewGuid().ToString();
tag.SLBH = slbh;
tag.PUSHDATE = DateTime.Now;
tag.ISSUCCESS = "1";
tag.MESSAGE = "成功";
res.ConfirmType = 0;
res.IsSuccess = true;;
res.Message = tag.MESSAGE;
}
else
{
res.ConfirmType = 0;
res.IsSuccess = false;
res.Message = "图像尚未扫描入库！";
}
}
catch (Exception ex)
{
res.ConfirmType = 0;
res.IsSuccess = false;
res.Message = ex.Message;
tag.FILECOUNT = count.ToString();
//tag.FILENAME =doc_bin[0].BINID
tag.ID = Guid.NewGuid().ToString();
tag.SLBH = slbh;
tag.PUSHDATE = DateTime.Now;
tag.ISSUCCESS = "0";
tag.MESSAGE = "失败！" + ex.Message;
}
finally
{
if (null != tag && null != tag.ID)
{
ImportDAL.InsertLog(tag);
}
}
//IsSuccess = true;
return(res);
}
Boolean ImportFile(string strFilePath1)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
ImportDAL iObj = new ImportDAL();
try
{
DataSet ds = new DataSet();
ImportExcelReport tObj = new ImportExcelReport();
ds = tObj.importMCNM(strFilePath1, _yrmo);
parseDataSet pObj = new parseDataSet();
_counter = pObj.parseMCNM(ds, _yrmo);
importStat = true;
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "Headcount", "Retiree Medicare/Non-Medicare Report Import", _yrmo, _counter);
}
catch (Exception ex)
{
iObj.Rollback("RET_NM", _yrmo);
throw ex;
}
finally
{
File.Delete(strFilePath1);
}
return(importStat);
}
Boolean ImportFile(string strFilePath1)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
ImportDAL iObj = new ImportDAL();
try
{
DataSet ds = new DataSet();
ImportExcelReport tObj = new ImportExcelReport();
ds = tObj.importAnthemBill(strFilePath1);
parseDataSet pObj = new parseDataSet();
pObj.parseAnthem(ds, _yrmo);
counter = iObj.insertAnthemHeadcounts(_yrmo);
importStat = true;
int _counter = iObj.getImportCount("ANTH", _yrmo);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "billing_details", "Anthem Bill Import", _yrmo, _counter);
}
catch (Exception ex)
{
File.Delete(strFilePath1);
iObj.Rollback("ANTH", _yrmo);
throw ex;
}
finally
{
File.Delete(strFilePath1);
}
return(importStat);
}
protected bool importfile(string filepath)
{
bool status = false;
string yrmo = ddlYrmo.Text;
ImportText grImport = new ImportText();
try
{
grImport.ParseGRS(filepath);
grImport.importGRSRecords(yrmo);
status = true;
ImportDAL iobj = new ImportDAL();
int _cnt = iobj.getImportCount("GRS", yrmo);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "HeadCounts", "GRS Report Import", yrmo, _cnt);
}
catch (Exception e)
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("GRS", yrmo);
throw e;
}
finally
{
ImportTextDAL storeData = new ImportTextDAL();
storeData.deleteStage("GRS");
File.Delete(filepath);
}
return(status);
}
public Import GetById(int id)
{
Import ticket = ImportDAL.GetById(id);
calculate(ticket);
return(ticket);
}
protected bool importfile(string strFilePath1)
{
bool status = false;
string yrmo = ddlYrmo.Text;
//ImportText adpImport = new ImportText();
try
{
//adpImport.ParseADP(strFilePath1);
ImportCobra.importADPDetail(yrmo, strFilePath1);
status = true;
ImportDAL iobj = new ImportDAL();
int _cnt = iobj.getImportCount("ADP", yrmo);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "ADP_Details", "ADP Cobra Import", yrmo, _cnt);
}
catch (Exception e)
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("ADP", yrmo);
throw e;
}
finally
{
File.Delete(strFilePath1);
}
return(status);
}
internal static BDCFilterResult ImportQSPic(string base64Str, string sLBH, string userName)
{
BDCFilterResult res = new BDCFilterResult();
int count = 0;
FC_REWRITE_TAG tag = new FC_REWRITE_TAG();
//string slbh = row[0].ToString();
try
{
if (CanImportPic(sLBH))
{
ImportQS(base64Str, sLBH, userName);
tag.FILECOUNT = count.ToString();
//tag.FILENAME =doc_bin[0].BINID
tag.ID = Guid.NewGuid().ToString();
tag.SLBH = sLBH;
tag.PUSHDATE = DateTime.Now;
tag.ISSUCCESS = "1";
tag.MESSAGE = "成功";
res.ConfirmType = 0;
res.IsSuccess = true;;
res.Message = tag.MESSAGE;
}
else
{
res.ConfirmType = 0;
res.IsSuccess = false;
res.Message = "无完税信息！";
}
}
catch (Exception ex)
{
res.ConfirmType = 0;
res.IsSuccess = false;
res.Message = ex.Message;
tag.FILECOUNT = count.ToString();
//tag.FILENAME =doc_bin[0].BINID
tag.ID = Guid.NewGuid().ToString();
tag.SLBH = sLBH;
tag.PUSHDATE = DateTime.Now;
tag.ISSUCCESS = "0";
tag.MESSAGE = "失败！" + ex.Message;
}
finally
{
if (null != tag && null != tag.ID)
{
ImportDAL.InsertLog(tag);
}
}
//IsSuccess = true;
return(res);
}
public List <Import> GetAll(int productId)
{
List <Import> list = ImportDAL.GetAll(productId);
foreach (Import ticket in list)
{
calculate(ticket);
}
return(list);
}
protected void ddlYrmoList()
{
ImportDAL iobj = new ImportDAL();
string prevYRMO;
for (int i = 0; i < 6; i++)
{
prevYRMO = iobj.getPrevYRMO(i);
ddlYrmo.Items.Add(prevYRMO);
}
ddlYrmo.Items.Add("New Yrmo");
}
protected void btn_import_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
if (Page.IsValid)
{
string strFilePath1 = "";
lbl_error.Text = "";
if (FileUpload1.GotFile)
{
try
{
string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName);
if (fn.Contains(yrmo))
{
strFilePath1 = Server.MapPath("~/uploads/") + fn;
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.SaveAs(strFilePath1);
if (ImportFile(strFilePath1))
{
MultiView1.SetActiveView(view_result);
lbl_result.Text = "Imported successfully for year-month (YRMO): " + yrmo;
//auditImport(tbx_YRMO.Text.ToString(), "imp", counter);
}
}
else
{
lbl_error.Text = "The Year Month (YRMO) of the selected file does not match the selected YRMO";
}
}
catch (Exception ex)
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("RET_NM", yrmo);
lbl_error.Text = "Error in importing file.<br />" + ex.Message;
}
finally
{
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.InputStream.Flush();
FileUpload1.FilePost.InputStream.Close();
FileUpload1.FilePost.InputStream.Dispose();
}
}
}
}
protected void ddlYrmoList()
{
ImportDAL iobj = new ImportDAL();
string prevYRMO, filterexp;
for (int i = 0; i < 6; i++)
{
prevYRMO = iobj.getPrevYRMO(i);
ddlYrmo.Items.Add(prevYRMO);
}
ddlYrmo.Items.Add("New Yrmo");
filterexp = "yrmo='" + ddlYrmo.SelectedItem.Text + "'";
SqlDataSourceAdj.FilterExpression = filterexp;
}
private static string GetCID(string slbh, string fileName)
{
string cid = ImportDAL.GetCID(slbh);
if (cid == "")
{
WFM_ATTACHLST att = new WFM_ATTACHLST();
att.CID = Guid.NewGuid().ToString();
att.CNAME = fileName;
att.PID = ImportDAL.GetCID(slbh);
att.PNODE = slbh;
cid = ImportDAL.InserAttachlst(att);
}
return(cid);
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
lbl_error.Text = "";
try
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("ANTH_RX", yrmo);
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text;
lbl_error.Text = "";
try
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("HTH", yrmo);
ReconDAL.pastReconcileDelete(yrmo, "INTL");
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
protected void btn_reimport_Click(object sender, EventArgs e)
{
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
lbl_error.Text = "";
try
{
ClaimsRecon dObj = new ClaimsRecon();
dObj.DeleteNCAReconData(yrmo);
dObj.deleteForced(yrmo, "DFRF");
ImportDAL iObj = new ImportDAL();
iObj.Rollback("DF", yrmo);
MultiView1.SetActiveView(view_main);
}
catch (Exception ex)
{
lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message;
}
}
public string ImportCrewList(DataTable dt, ref string FailureMessage, ref int FailureCount, ref int SuccessCount)
{
string s = "";
ImportDAL importDal = new ImportDAL();
DataTable dtBL = new DataTable();
foreach (DataRow dr in dt.Rows)
{
string sr = dr[1].ToString();
string st = sr.Replace("\\", "");
}
s = importDal.ImportCrewList(dt, ref FailureMessage, ref FailureCount, ref SuccessCount);
return(s);
}
protected void btn_import_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
string strFilePath1 = "";
lbl_error.Text = "";
if (FileUpload1.GotFile)
{
try
{
string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName);
strFilePath1 = Server.MapPath("~/uploads/") + fn;
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.SaveAs(strFilePath1);
if (ImportFile(strFilePath1))
{
MultiView1.SetActiveView(view_result);
lbl_result.Text = "Imported successfully for year-month (YRMO): " + ddlYrmo.SelectedItem.Text;
}
}
catch (Exception ex)
{
ImportDAL iObj = new ImportDAL();
iObj.Rollback("DF", ddlYrmo.SelectedItem.Text);
lbl_error.Text = "Error in importing file.<br />" + ex.Message;
}
finally
{
if (File.Exists(strFilePath1))
{
File.Delete(strFilePath1);
}
FileUpload1.FilePost.InputStream.Flush();
FileUpload1.FilePost.InputStream.Close();
FileUpload1.FilePost.InputStream.Dispose();
}
}
}
}
DataSet ExecuteStoredProc(string spName, string yrmo, string plancode, string source)
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet(); ds.Clear();
ImportDAL iobj = new ImportDAL();
command = new SqlCommand(spName, connect);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@yrmo", SqlDbType.VarChar).Value = yrmo;
command.Parameters.Add("@plancode", SqlDbType.VarChar).Value = plancode;
if (source.Equals("ADJ") || source.Equals("COBDET"))
{
command.Parameters.Add("@prevyrmo", SqlDbType.VarChar).Value = iobj.getPrevYRMO(yrmo);
}
da.SelectCommand = command;
da.Fill(ds);
command.Dispose();
return(ds);
}
protected bool importfile(string filepath)
{
string yrmo = ddlYrmo.SelectedItem.Text.ToString();
bool status = false;
ImportText boaImport = new ImportText();
try
{
boaImport.parseBOA(filepath);
status = true;
ImportDAL iobj = new ImportDAL();
int _cnt = iobj.getImportCount("BOA", yrmo);
Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1;
Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Claims Reconciliation", "BOAStatement", "BOA Statement Import", yrmo, _cnt);
}
catch (Exception e)
{
status = false;
throw e;
}
return(status);
}
private static string GetCID(string slbh, string fileName, string fileType, string user, string pid)
{
string cid = ImportDAL.GetCID(slbh, fileName, fileType);
if (cid == "")
{
WFM_ATTACHLST att = new WFM_ATTACHLST();
att.CID = Guid.NewGuid().ToString();
att.CNAME = fileName;
if (fileType == "文件夹")
{
att.PID = ImportDAL.GetCID(slbh);
}
else
{
att.PID = pid;
}
att.PNODE = slbh;
cid = ImportDAL.InserAttachlst(att, fileType, user);
}
return(cid);
}
Boolean ImportFile(string strFilePath1)
{
string _yrmo = ddlYrmo.SelectedItem.Text;
bool importStat = false;
ImportDAL iObj = new ImportDAL();
try
{
DataSet ds = new DataSet();
ImportExcelReport tObj = new ImportExcelReport();
ds = tObj.importRXClaims(strFilePath1);
parseDataSet pObj = new parseDataSet();
counter = pObj.parseRXClaims(ds, _yrmo);
importStat = true;
}
catch (Exception ex)
{
File.Delete(strFilePath1);
iObj.Rollback("ANTH_RX", _yrmo);
throw ex;
}
return(importStat);
}
/// <summary>
/// 从房产库查询数据构建BDC插入实例
/// </summary>
/// <param name="slbh"></param>
/// <returns></returns>
private static List <DOC_BINFILE> GetDoc_Binfile(string slbh)
{
//string[] args = new string[1];
//args[0] = "China";
//object result= WebServiceHelper.InvokeWebService(WebSrvUrl, WebSrvMethon, args);
//List<Result> Res_list = (List<Result>)result;
List <VolEleArcDtl> veads = ImportDAL.GetVolEleArcDtl(slbh);
List <DOC_BINFILE> list = new List <DOC_BINFILE>();
//if(null!=Res_list && Res_list.Count>0)
//{
// foreach (Result res in Res_list)
// {
foreach (VolEleArcDtl v in veads)
{
v.imgName = v.imgName.Replace(@"\\192.168.100.202 \", "").Replace(@"K:\", "");
VolEleArc vea = GetVolEleArc(v.VolEleArc_ID);
DOC_BINFILE doc_binfile = new DOC_BINFILE();
doc_binfile.BINID = GetCID(slbh, vea.EleArcName);
if (doc_binfile.BINID != "")
{
doc_binfile.FTPATH = v.imgName;
doc_binfile.FILEID = Guid.NewGuid().ToString();
doc_binfile.FILENAME = vea.EleArcName;
doc_binfile.EXTNAME = "JPG";
doc_binfile.ISCOMPRESSED = "否";
doc_binfile.ISENCRYPTED = "否";
list.Add(doc_binfile);
}
}
// }
//}
return(list);
}
public int Create(Import ticket)
{
return(ImportDAL.Create(ticket));
}
private static VolEleArc GetVolEleArc(Guid?vid)
{
return(ImportDAL.GetVolEleArc(vid));
}
/// <summary>
/// 判断是否需要导入
/// </summary>
/// <param name="p"></param>
/// <returns></returns>
private static bool CanImport(string p)
{
return(ImportDAL.CanImport(p));
}
