private List <XSDJMXModel> ConvertImportXSDJ(XSDJ XsdjImport)
{
List <XSDJMXModel> list = new List <XSDJMXModel>();
for (int i = 0; i < XsdjImport.Dj.Count; i++)
{
XSDJMXModel item = new XSDJMXModel {
BH = XsdjImport.Dj[i].Djh,
GFMC = XsdjImport.Dj[i].Gfmc,
GFSH = XsdjImport.Dj[i].Gfsh,
GFDZDH = XsdjImport.Dj[i].Gfdzdh,
GFYHZH = XsdjImport.Dj[i].Gfyhzh,
XSBM = "",
YDXS = false,
DJRQ = XsdjImport.Dj[i].Djrq.Date,
DJYF = XsdjImport.Dj[i].Djrq.Month,
DJZT = XsdjImport.Dj[i].DJZT,
KPZT = "N",
BZ = XsdjImport.Dj[i].Bz,
FHR = XsdjImport.Dj[i].Fhr,
SKR = XsdjImport.Dj[i].Skr,
QDHSPMC = XsdjImport.Dj[i].Qdspmc,
XFYHZH = XsdjImport.Dj[i].Xfyhzh,
XFDZDH = XsdjImport.Dj[i].Xfdzdh,
CFHB = false,
DJZL = XsdjImport.Dj[i].Djzl,
SFZJY = false,
HYSY = XsdjImport.Dj[i].HYSY
};
double num2 = 0.0;
for (int j = 0; j < XsdjImport.Dj[i].Mingxi.Count; j++)
{
XSDJ_MXModel model2 = new XSDJ_MXModel {
XSDJBH = XsdjImport.Dj[i].Mingxi[j].DJBH,
XH = Convert.ToInt16((int)(j + 1)),
SL = XsdjImport.Dj[i].Mingxi[j].Sl,
DJ = XsdjImport.Dj[i].Mingxi[j].Dj,
JE = Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Bhsje),
SLV = Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Slv),
SE = Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Se),
SPMC = XsdjImport.Dj[i].Mingxi[j].Hwmc,
SPSM = XsdjImport.Dj[i].Mingxi[j].Spsm,
GGXH = XsdjImport.Dj[i].Mingxi[j].Gg,
JLDW = XsdjImport.Dj[i].Mingxi[j].Jldw,
HSJBZ = (XsdjImport.Dj[i].Mingxi[j].Jgfs == "0") ? false : true,
DJHXZ = XsdjImport.Dj[i].Mingxi[j].Djhxz,
FPZL = XsdjImport.Dj[i].Mingxi[j].Fpzl.ToString(),
FPDM = "",
FPHM = 0,
SCFPXH = 0
};
num2 += Convert.ToDouble(XsdjImport.Dj[i].Mingxi[j].Bhsje);
item.ListXSDJ_MX.Add(model2);
}
item.JEHJ = num2;
list.Add(item);
}
return(list);
}
public void SaveImportXSDJ(List <XSDJMXModel> ListXSDJandMX, ErrorResolver Errors)
{
try
{
try
{
for (int i = 0; i < ListXSDJandMX.Count; i++)
{
XSDJMXModel model = ListXSDJandMX[i];
string str = string.Format("销售单据编号: {0} ", model.BH);
string errowInfo = this.AllowImport(model);
if (errowInfo != "0")
{
Errors.AddError(errowInfo, model.BH, 0, false);
Errors.AbandonCount++;
}
else
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("bh", model.BH);
if (this.baseDAO.queryValueSQL <int>("aisino.Fwkp.Wbjk.XSDJExist", dictionary) > 0)
{
int num3 = this.baseDAO.updateSQL("aisino.Fwkp.Wbjk.XSDJDeleteFast", dictionary);
}
switch (this.AddXSDJ(model))
{
case "0":
Errors.SaveCount++;
break;
}
}
}
}
catch
{
throw;
}
}
finally
{
}
}
public XSDJMXModel GetXSDJandMXs(string XSDJBH, bool MXAll, bool DanJia)
{
XSDJMXModel model = new XSDJMXModel();
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("BH", XSDJBH);
DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.XSDJGetModel", dictionary);
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
model.BH = GetSafeData.ValidateValue <string>(row, "BH");
model.GFMC = GetSafeData.ValidateValue <string>(row, "GFMC");
model.GFSH = GetSafeData.ValidateValue <string>(row, "GFSH");
model.GFDZDH = GetSafeData.ValidateValue <string>(row, "GFDZDH");
model.GFYHZH = GetSafeData.ValidateValue <string>(row, "GFYHZH");
model.XSBM = GetSafeData.ValidateValue <string>(row, "XSBM");
model.YDXS = GetSafeData.ValidateValue <bool>(row, "YDXS");
model.JEHJ = GetSafeData.ValidateValue <double>(row, "JEHJ");
model.DJRQ = GetSafeData.ValidateValue <DateTime>(row, "DJRQ");
model.DJYF = GetSafeData.ValidateValue <int>(row, "DJYF");
model.DJZT = GetSafeData.ValidateValue <string>(row, "DJZT");
model.KPZT = GetSafeData.ValidateValue <string>(row, "KPZT");
model.BZ = GetSafeData.ValidateValue <string>(row, "BZ");
model.FHR = GetSafeData.ValidateValue <string>(row, "FHR");
model.SKR = GetSafeData.ValidateValue <string>(row, "SKR");
model.QDHSPMC = GetSafeData.ValidateValue <string>(row, "QDHSPMC");
model.XFYHZH = GetSafeData.ValidateValue <string>(row, "XFYHZH");
model.XFDZDH = GetSafeData.ValidateValue <string>(row, "XFDZDH");
model.CFHB = GetSafeData.ValidateValue <bool>(row, "CFHB");
model.DJZL = GetSafeData.ValidateValue <string>(row, "DJZL");
model.SFZJY = GetSafeData.ValidateValue <bool>(row, "SFZJY");
model.HYSY = GetSafeData.ValidateValue <bool>(row, "HYSY");
}
else
{
return(null);
}
DataTable mXDJ = this.GetMXDJ(XSDJBH);
foreach (DataRow row in mXDJ.Rows)
{
XSDJ_MXModel item = new XSDJ_MXModel {
XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH"),
XH = GetSafeData.ValidateValue <int>(row, "XH"),
SL = GetSafeData.ValidateValue <double>(row, "SL"),
DJ = GetSafeData.ValidateValue <double>(row, "DJ"),
JE = GetSafeData.ValidateValue <double>(row, "JE"),
SLV = GetSafeData.ValidateValue <double>(row, "SLV"),
SE = GetSafeData.ValidateValue <double>(row, "SE"),
SPMC = GetSafeData.ValidateValue <string>(row, "SPMC"),
SPSM = GetSafeData.ValidateValue <string>(row, "SPSM"),
GGXH = GetSafeData.ValidateValue <string>(row, "GGXH"),
JLDW = GetSafeData.ValidateValue <string>(row, "JLDW"),
HSJBZ = GetSafeData.ValidateValue <bool>(row, "HSJBZ"),
DJHXZ = GetSafeData.ValidateValue <int>(row, "DJHXZ"),
FPZL = GetSafeData.ValidateValue <string>(row, "FPZL"),
FPDM = GetSafeData.ValidateValue <string>(row, "FPDM"),
FPHM = GetSafeData.ValidateValue <int>(row, "FPHM"),
SCFPXH = GetSafeData.ValidateValue <int>(row, "SCFPXH")
};
if (!DanJia)
{
bool flag = ((item.SLV == 0.05) && (model.DJZL == "s")) && model.HYSY;
if (item.DJHXZ == 4)
{
item.SL = 0.0;
item.DJ = 0.0;
}
else if (!flag && item.HSJBZ)
{
if (!(item.SL == 0.0))
{
item.DJ = item.JE / item.SL;
}
else
{
item.DJ = item.JE;
}
}
}
if (MXAll || string.IsNullOrEmpty(item.FPDM))
{
model.ListXSDJ_MX.Add(item);
}
}
return(model);
}
public string AddXSDJ(XSDJMXModel xsdj)
{
try
{
double num = 0.0;
foreach (XSDJ_MXModel model in xsdj.ListXSDJ_MX)
{
num += model.JE;
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("XSDJBH", model.XSDJBH);
dictionary.Add("XH", model.XH);
dictionary.Add("SL", model.SL);
dictionary.Add("DJ", model.DJ);
dictionary.Add("JE", model.JE);
dictionary.Add("SLV", model.SLV);
dictionary.Add("SE", model.SE);
dictionary.Add("SPMC", model.SPMC);
dictionary.Add("SPSM", model.SPSM);
dictionary.Add("GGXH", model.GGXH);
dictionary.Add("JLDW", model.JLDW);
dictionary.Add("HSJBZ", model.HSJBZ);
dictionary.Add("DJHXZ", model.DJHXZ);
dictionary.Add("FPZL", xsdj.DJZL);
dictionary.Add("FPDM", null);
dictionary.Add("FPHM", null);
dictionary.Add("SCFPXH", null);
if (this.baseDAO.updateSQL("aisino.Fwkp.Wbjk.XSDJMXAdd", dictionary) == 0)
{
break;
}
}
xsdj.JEHJ = num;
Dictionary <string, object> dictionary2 = new Dictionary <string, object>();
dictionary2.Add("BH", xsdj.BH);
dictionary2.Add("GFMC", xsdj.GFMC);
dictionary2.Add("GFSH", xsdj.GFSH);
dictionary2.Add("GFDZDH", xsdj.GFDZDH);
dictionary2.Add("GFYHZH", xsdj.GFYHZH);
dictionary2.Add("XSBM", xsdj.XSBM);
dictionary2.Add("YDXS", xsdj.YDXS);
dictionary2.Add("JEHJ", xsdj.JEHJ);
dictionary2.Add("DJRQ", xsdj.DJRQ);
dictionary2.Add("DJYF", xsdj.DJYF);
dictionary2.Add("DJZT", "Y");
dictionary2.Add("KPZT", "N");
dictionary2.Add("BZ", xsdj.BZ);
dictionary2.Add("FHR", xsdj.FHR);
dictionary2.Add("SKR", xsdj.SKR);
dictionary2.Add("QDHSPMC", xsdj.QDHSPMC);
dictionary2.Add("XFYHZH", xsdj.XFYHZH);
dictionary2.Add("XFDZDH", xsdj.XFDZDH);
dictionary2.Add("CFHB", xsdj.CFHB);
dictionary2.Add("DJZL", xsdj.DJZL);
dictionary2.Add("SFZJY", xsdj.SFZJY);
dictionary2.Add("HYSY", xsdj.HYSY);
if (this.baseDAO.updateSQL("aisino.Fwkp.Wbjk.XSDJAdds", dictionary2) > 0)
{
return("0");
}
return("error");
}
catch (Exception exception)
{
if ((exception.InnerException == null) || !exception.InnerException.Message.EndsWith("columns XSDJBH, XH are not unique"))
{
throw;
}
return("e1");
}
}
