private XSDJ GetXSDJ()
{
strBiao biao = this.JieXiShuXing();
XSDJ xsdj = new XSDJ();
if (biao.str.Count > 0)
{
xsdj.Bdbs = biao.str[0];
if (biao.str.Count > 2)
{
xsdj.Bdmc = biao.str[1];
xsdj.Bdfz = biao.str[2];
}
}
for (int i = 0; i < biao.danju.Count; i++)
{
TempXSDJ item = new TempXSDJ();
item = this.GetTempXSDJ(biao.danju[i]);
if (item != null)
{
xsdj.Dj.Add(item);
}
}
return(xsdj);
}
protected int ValidHead(TempXSDJ XSDJtemp)
{
if (string.IsNullOrEmpty(XSDJtemp.Djh))
{
this.ErrorAdd("没有单据号", "", 0, false);
this.errorResolver.AbandonCount++;
return(2);
}
if (string.IsNullOrEmpty(XSDJtemp.Gfmc))
{
this.ErrorAdd("没有购方名称", XSDJtemp.Djh, 0, true);
return(1);
}
if ((this.Fplx == InvType.Special) && string.IsNullOrEmpty(XSDJtemp.Gfsh))
{
this.ErrorAdd("没有税号", XSDJtemp.Djh, 0, true);
return(1);
}
FPLX fplx = 2;
if (this.Fplx == InvType.Common)
{
fplx = 2;
}
else if (this.Fplx == InvType.Special)
{
fplx = 0;
}
else if (this.Fplx == InvType.transportation)
{
fplx = 11;
}
else if (this.Fplx == InvType.vehiclesales)
{
fplx = 12;
}
bool sFZJY = XSDJtemp.SFZJY == "0";
if (!this.check.CheckTaxCode(this.Fplx, XSDJtemp.Gfsh, sFZJY, fplx))
{
this.ErrorAdd("税号有错误", XSDJtemp.Djh, 0, true);
return(1);
}
return(0);
}
protected XSDJ GetXSDJ()
{
XSDJ xsdj = new XSDJ {
Bdbs = "SJJK0101",
Bdmc = "Excel数据导入",
Bdfz = "Excel数据导入"
};
DataTable table = this.ExcelLoad();
foreach (DataRow row in table.Rows)
{
string iD = Convert.ToString(row["DanJuHaoMa"]);
TempXSDJ tempXSDJ = this.GetTempXSDJ(iD, xsdj);
if (tempXSDJ == null)
{
tempXSDJ = new TempXSDJ {
Djh = iD,
Sphs = 0,
Gfmc = Convert.ToString(row["GouFangMingCheng"]),
Gfsh = Convert.ToString(row["GouFangShuiHao"]),
Gfdzdh = Convert.ToString(row["GouFangDiZhiDianHua"]),
Gfyhzh = Convert.ToString(row["GouFangYinHangZhangHao"]),
Bz = Convert.ToString(row["BeiZhu"]),
Fhr = Convert.ToString(row["FuHeRen"]),
Skr = Convert.ToString(row["ShouKuanRen"]),
Qdspmc = Convert.ToString(row["QingDanHangShangPinMingCheng"])
};
DateTime result = new DateTime(0x76c, 1, 1);
if (DateTime.TryParse(row["DanJuRiQi"].ToString(), out result))
{
tempXSDJ.Djrq = result;
}
else
{
tempXSDJ.Djrq = DateTime.Now.Date;
}
tempXSDJ.Xfyhzh = Convert.ToString(row["XiaoFangYinHangZhangHao"]);
tempXSDJ.Xfdzdh = Convert.ToString(row["XiaoFangDiZhiDianHua"]);
tempXSDJ.SFZJY = CommonTool.ToStringBool(row["ShenFenZhengJiaoYan"].ToString());
string str2 = Convert.ToString(row["HaiYangShiYou"]);
tempXSDJ.HYSY = CommonTool.ToBoolString(str2);
xsdj.Dj.Add(tempXSDJ);
}
TempXSDJ_MX item = new TempXSDJ_MX {
Hwmc = Convert.ToString(row["HuoWuMingCheng"]),
Jldw = Convert.ToString(row["JiLiangDanWei"]),
Gg = Convert.ToString(row["GuiGe"]),
Sl = CommonTool.TodoubleNew(Convert.ToString(row["ShuLiang"])),
Bhsje = CommonTool.TodoubleNew_x(row["BuHanShuiJinE"].ToString()),
Slv = CommonTool.ToSlv(row["ShuiLv"].ToString()),
Spsm = Convert.ToString(row["ShangPinShuiMu"]),
Zkje = new double?(CommonTool.TodoubleNew(row["ZheKouJinE"].ToString())),
Se = CommonTool.TodoubleNew_x(row["ShuiE"].ToString()),
Zkse = CommonTool.ToZKSE(row["ZheKouShuiE"].ToString()),
Zkl = CommonTool.ToZKL(row["ZheKouLv"].ToString()),
Dj = CommonTool.Todouble(row["DanJia"].ToString()),
Jgfs = CommonTool.ToStringBool(row["JiaGeFangShi"].ToString()),
HangShu = tempXSDJ.Mingxi.Count + 1,
DJBH = tempXSDJ.Djh
};
tempXSDJ.Mingxi.Add(item);
}
base.errorResolver.ImportTotal = xsdj.Dj.Count;
return(xsdj);
}
protected TempXSDJ GetTempXSDJ(strDanju danju)
{
int num;
if (danju.str.Count < 7)
{
for (num = danju.str.Count; num < 7; num++)
{
danju.str.Add("");
}
}
TempXSDJ pxsdj = new TempXSDJ {
Djh = danju.str[0]
};
int result = 0;
if (!int.TryParse(danju.str[1], out result))
{
throw new CustomException("传入txt格式不正确");
}
pxsdj.Sphs = result;
pxsdj.Gfmc = danju.str[2];
pxsdj.Gfsh = danju.str[3];
pxsdj.Gfdzdh = danju.str[4];
pxsdj.Gfyhzh = danju.str[5];
pxsdj.Bz = danju.str[6];
if (danju.str.Count > 7)
{
pxsdj.Fhr = danju.str[7];
}
if (danju.str.Count > 8)
{
pxsdj.Skr = danju.str[8];
}
if (danju.str.Count > 9)
{
pxsdj.Qdspmc = danju.str[9];
}
if ((danju.str.Count > 10) && !string.IsNullOrEmpty(danju.str[10]))
{
DateTime now = DateTime.Now;
DateTime.TryParse(danju.str[10], out now);
pxsdj.Djrq = now.Date;
}
if (danju.str.Count > 11)
{
pxsdj.Xfyhzh = danju.str[11];
}
if (danju.str.Count > 12)
{
pxsdj.Xfdzdh = danju.str[12];
}
if (danju.str.Count > 13)
{
pxsdj.SFZJY = CommonTool.ToStringBool(danju.str[13]);
}
if (danju.str.Count > 14)
{
pxsdj.HYSY = CommonTool.ToBoolString(danju.str[14]);
}
for (num = 0; num < danju.mingxi.Count; num++)
{
TempXSDJ_MX item = this.GetTempXSDJ_MX(danju.mingxi[num], pxsdj.Djh, num + 1);
if (item != null)
{
pxsdj.Mingxi.Add(item);
}
}
return(pxsdj);
}
