public XSDJ_MXModel GetMXModel(string XSDJBH, string XH)
{
XSDJ_MXModel model = new XSDJ_MXModel();
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("XSDJBH", XSDJBH);
dictionary.Add("XH", XH);
DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.XSDJMXGetModel", dictionary);
if (table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
model.XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH");
model.XH = GetSafeData.ValidateValue <int>(row, "XH");
model.SL = GetSafeData.ValidateValue <double>(row, "SL");
model.DJ = GetSafeData.ValidateValue <double>(row, "DJ");
model.JE = GetSafeData.ValidateValue <double>(row, "JE");
model.SLV = GetSafeData.ValidateValue <double>(row, "SLV");
model.SE = GetSafeData.ValidateValue <double>(row, "SE");
model.SPMC = GetSafeData.ValidateValue <string>(row, "SPMC");
model.SPSM = GetSafeData.ValidateValue <string>(row, "SPSM");
model.GGXH = GetSafeData.ValidateValue <string>(row, "GGXH");
model.JLDW = GetSafeData.ValidateValue <string>(row, "JLDW");
model.HSJBZ = GetSafeData.ValidateValue <bool>(row, "HSJBZ");
model.DJHXZ = GetSafeData.ValidateValue <int>(row, "DJHXZ");
model.FPZL = GetSafeData.ValidateValue <string>(row, "FPZL");
model.FPDM = GetSafeData.ValidateValue <string>(row, "FPDM");
model.FPHM = GetSafeData.ValidateValue <int>(row, "FPHM");
model.SCFPXH = GetSafeData.ValidateValue <int>(row, "SCFPXH");
}
return(model);
}
public BMSPSMModel GetModel(string BM, string SZ = "")
{
DataTable bMSPSM = this.bmkhDAL.GetBMSPSM(BM, SZ);
BMSPSMModel model = new BMSPSMModel();
if (bMSPSM.Rows.Count > 0)
{
DataRow row = bMSPSM.Rows[0];
string str = string.Empty;
str = GetSafeData.ValidateValue <string>(row, "SZ");
model.SZ = (str == null) ? "" : str;
str = GetSafeData.ValidateValue <string>(row, "MC");
model.MC = (str == null) ? "" : str;
str = GetSafeData.ValidateValue <string>(row, "BM");
model.BM = (str == null) ? "" : str;
model.SLV = GetSafeData.ValidateValue <double>(row, "SLV");
model.ZSL = GetSafeData.ValidateValue <double>(row, "ZSL");
model.SLJS = GetSafeData.ValidateValue <byte>(row, "SLJS");
str = GetSafeData.ValidateValue <string>(row, "JSDW");
model.JSDW = (str == null) ? "" : str;
model.SE = GetSafeData.ValidateValue <double>(row, "SE");
model.FHDBZ = GetSafeData.ValidateValue <bool>(row, "FHDBZ");
model.MDXS = GetSafeData.ValidateValue <double>(row, "MDXS");
}
return(model);
}
public BMBaseModel GetModel(string BM)
{
DataTable kH = this.bmkhDAL.GetKH(BM);
BMKHModel model = new BMKHModel();
if (kH.Rows.Count > 0)
{
DataRow row = kH.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
model.JM = GetSafeData.ValidateValue <string>(row, "JM");
model.KJM = GetSafeData.ValidateValue <string>(row, "KJM");
model.SH = GetSafeData.ValidateValue <string>(row, "SH");
model.DZDH = GetSafeData.ValidateValue <string>(row, "DZDH");
model.YHZH = GetSafeData.ValidateValue <string>(row, "YHZH");
model.YJDZ = GetSafeData.ValidateValue <string>(row, "YJDZ");
model.BZ = GetSafeData.ValidateValue <string>(row, "BZ");
model.YSKM = GetSafeData.ValidateValue <string>(row, "YSKM");
model.DQBM = GetSafeData.ValidateValue <string>(row, "DQBM");
model.DQMC = GetSafeData.ValidateValue <string>(row, "DQMC");
model.DQKM = GetSafeData.ValidateValue <string>(row, "DQKM");
model.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
model.SFZJY = GetSafeData.ValidateValue <bool>(row, "SFZJY");
}
return(model);
}
public BMBaseModel GetModel(string BM)
{
DataTable sPFL = this.bmspflDAL.GetSPFL(BM);
BMSPModel model = new BMSPModel();
if (sPFL.Rows.Count > 0)
{
DataRow row = sPFL.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
model.JM = GetSafeData.ValidateValue <string>(row, "JM");
model.KJM = GetSafeData.ValidateValue <string>(row, "KJM");
model.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
model.SLV = GetSafeData.ValidateValue <double>(row, "SLV");
model.SPSM = GetSafeData.ValidateValue <string>(row, "SPSM");
model.GGXH = GetSafeData.ValidateValue <string>(row, "GGXH");
model.JLDW = GetSafeData.ValidateValue <string>(row, "JLDW");
model.DJ = GetSafeData.ValidateValue <double>(row, "DJ");
model.HSJBZ = GetSafeData.ValidateValue <bool>(row, "HSJBZ");
model.XSSRKM = GetSafeData.ValidateValue <string>(row, "XSSRKM");
model.YJZZSKM = GetSafeData.ValidateValue <string>(row, "YJZZSKM");
model.XSTHKM = GetSafeData.ValidateValue <string>(row, "XSTHKM");
model.HYSY = GetSafeData.ValidateValue <bool>(row, "HYSY");
model.XTHASH = GetSafeData.ValidateValue <string>(row, "XTHASH");
model.XTCODE = GetSafeData.ValidateValue <string>(row, "XTCODE");
model.ISHIDE = GetSafeData.ValidateValue <string>(row, "ISHIDE");
}
return(model);
}
public void ChooseYHZCMCForFYXM()
{
DataTable table = new DAL.BMFYXMManager().QueryFYXMYHZCIsAndYHZCMCIsEmpty();
if (table != null)
{
DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager();
List <string> sqlID = new List <string>();
List <Dictionary <string, object> > param = new List <Dictionary <string, object> >();
for (int i = 0; i < table.Rows.Count; i++)
{
Dictionary <string, object> item = new Dictionary <string, object>();
string str = GetSafeData.ValidateValue <string>(table.Rows[i], "BM");
string bm = GetSafeData.ValidateValue <string>(table.Rows[i], "SPFL");
string str3 = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZC");
string sPFLMCBYBM = manager2.GetSPFLMCBYBM(bm);
string str5 = "";
object[] objArray = ServiceFactory.InvokePubService("Aisino.Fwkp.Bmgl.GetSLV_BY_BM", new object[] { bm });
if ((objArray != null) && (objArray.Length > 0))
{
string[] strArray = (objArray[0] as DataTable).Rows[0]["ZZSTSGL"].ToString().Split(new char[] { '，', '、', '；', ',', ';' });
if (strArray.Length > 0)
{
str5 = strArray[0];
if ((!Flbm.IsDK() && (strArray.Length == 1)) && strArray[0].Contains("1.5%"))
{
str3 = "否";
str5 = "";
}
if ((!Flbm.IsDK() && (strArray.Length > 1)) && strArray[0].Contains("1.5%"))
{
str5 = strArray[1];
}
}
else
{
str3 = "否";
}
}
else
{
str3 = "否";
}
item.Add("BM", str);
item.Add("SPFL", bm);
item.Add("SPFLMC", sPFLMCBYBM);
item.Add("YHZC", str3);
item.Add("YHZCMC", str5);
sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.UpdateFYXMSPFL");
param.Add(item);
}
new DAL.BMSPFLManager().UpdateSPFLTable(sqlID, param, false);
}
}
public BMXZQYModel GetModel(string BM)
{
DataTable bMXZQY = this.bmkhDAL.GetBMXZQY(BM);
BMXZQYModel model = new BMXZQYModel();
if (bMXZQY.Rows.Count > 0)
{
DataRow row = bMXZQY.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
}
return(model);
}
public void checkspspfl()
{
DataTable table = new DAL.BMSPManager().QuerySPSPFLLNotEmptyAndNotXT();
if (table != null)
{
DAL.BMSPFLManager manager2 = new DAL.BMSPFLManager();
List <string> sqlID = new List <string>();
List <Dictionary <string, object> > param = new List <Dictionary <string, object> >();
for (int i = 0; i < table.Rows.Count; i++)
{
Dictionary <string, object> item = new Dictionary <string, object>();
string str = GetSafeData.ValidateValue <string>(table.Rows[i], "BM");
string bm = GetSafeData.ValidateValue <string>(table.Rows[i], "SPFL");
string str3 = GetSafeData.ValidateValue <string>(table.Rows[i], "LSLVBS");
string str4 = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZC");
string str5 = GetSafeData.ValidateValue <string>(table.Rows[i], "YHZCMC");
string sPFLMCBYBM = string.Empty;
item.Add("BM", str);
if (manager2.CanUseThisSPFLBM(bm, true, false))
{
item.Add("SPFL", bm);
sPFLMCBYBM = manager2.GetSPFLMCBYBM(bm);
item.Add("SPFLMC", sPFLMCBYBM);
if (manager2.CanUseThisYHZC(bm))
{
item.Add("YHZC", str4);
item.Add("YHZCMC", str5);
item.Add("LSLVBS", str3);
}
else
{
item.Add("YHZC", "否");
item.Add("YHZCMC", "");
item.Add("LSLVBS", "");
}
}
else
{
item.Add("SPFL", "");
item.Add("SPFLMC", "");
item.Add("YHZC", "");
item.Add("YHZCMC", "");
item.Add("LSLVBS", "");
}
sqlID.Add("aisino.Fwkp.Bmgl.BMSPFL.UpdateSPSPFL");
param.Add(item);
}
new DAL.BMSPFLManager().UpdateSPFLTable(sqlID, param, false);
}
}
private void CFHMXLoad(string BH)
{
DataTable cFHmx = this.djcfBLL.GetCFHmx(BH);
this.dataGridMXCFH.Rows.Clear();
for (int i = 0; i < cFHmx.Rows.Count; i++)
{
DataRow row = cFHmx.Rows[i];
string str = GetSafeData.ValidateValue <string>(row, "XSDJBH");
string str2 = GetSafeData.ValidateValue <string>(row, "SPMC");
double num2 = GetSafeData.ValidateValue <double>(row, "SL");
double num3 = GetSafeData.ValidateValue <double>(row, "DJ");
double num4 = GetSafeData.ValidateValue <double>(row, "JE");
double num5 = GetSafeData.ValidateValue <double>(row, "SLV");
double num6 = GetSafeData.ValidateValue <double>(row, "SE");
int num7 = GetSafeData.ValidateValue <int>(row, "DJHXZ");
string str3 = ((decimal)num2).ToString();
if (num5 == 0.0)
{
string str4 = this.billBL.ShowSLV(this.bill, (i + 1).ToString(), "0");
if (str4.Equals("免税") || str4.Equals("不征税"))
{
this.dataGridMXCFH.Rows.Add(new object[] { i + 1, str, str2, str3, num3, num4, str4, num6, num7 });
}
else
{
this.dataGridMXCFH.Rows.Add(new object[] { i + 1, str, str2, str3, num3, num4, num5, num6, num7 });
}
}
else if (this.bill.HYSY && (num5 == 0.05))
{
this.dataGridMXCFH.Rows.Add(new object[] { i + 1, str, str2, str3, num3, num4, "中外合作油气田", num6, num7 });
}
else if (this.bill.JZ_50_15 && (num5 == 0.015))
{
this.dataGridMXCFH.Rows.Add(new object[] { i + 1, str, str2, str3, num3, num4, "减按1.5%计算", num6, num7 });
}
else
{
this.dataGridMXCFH.Rows.Add(new object[] { i + 1, str, str2, str3, num3, num4, num5, num6, num7 });
}
}
}
public BMBaseModel GetModel(string BM)
{
DataTable gHDW = this.bmghdwDAL.GetGHDW(BM);
BMGHDWModel model = new BMGHDWModel();
if (gHDW.Rows.Count > 0)
{
DataRow row = gHDW.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
model.JM = GetSafeData.ValidateValue <string>(row, "JM");
model.SH = GetSafeData.ValidateValue <string>(row, "SH");
model.DZDH = GetSafeData.ValidateValue <string>(row, "DZDH");
model.YHZH = GetSafeData.ValidateValue <string>(row, "YHZH");
model.IDCOC = GetSafeData.ValidateValue <string>(row, "IDCOC");
model.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
}
return(model);
}
public BMBaseModel GetModel(string BM)
{
DataTable fYXM = this.bmfyxmDAL.GetFYXM(BM);
BMFYXMModel model = new BMFYXMModel();
if (fYXM.Rows.Count > 0)
{
DataRow row = fYXM.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
model.JM = GetSafeData.ValidateValue <string>(row, "JM");
model.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
model.SPFL = GetSafeData.ValidateValue <string>(row, "SPFL");
model.YHZC = GetSafeData.ValidateValue <string>(row, "YHZC");
model.SPFLMC = GetSafeData.ValidateValue <string>(row, "SPFLMC");
model.YHZCMC = GetSafeData.ValidateValue <string>(row, "YHZCMC");
}
return(model);
}
public BMBaseModel GetModel(string BM)
{
DataTable kH = this.bmsfhrDAL.GetKH(BM);
BMXHDWModel model = new BMXHDWModel();
if (kH.Rows.Count > 0)
{
DataRow row = kH.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
model.JM = GetSafeData.ValidateValue <string>(row, "JM");
model.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
model.SH = GetSafeData.ValidateValue <string>(row, "SH");
model.DZDH = GetSafeData.ValidateValue <string>(row, "DZDH");
model.YHZH = GetSafeData.ValidateValue <string>(row, "YHZH");
model.YZBM = GetSafeData.ValidateValue <string>(row, "YZBM");
model.WJ = GetSafeData.ValidateValue <int>(row, "WJ");
}
return(model);
}
public List <XSDJ_MXModel> GetMergedMX(List <string> listBH)
{
int num;
Dictionary <string, object> dictionary = new Dictionary <string, object>();
List <object> list = new List <object>();
for (num = 0; num < listBH.Count; num++)
{
list.Add(listBH[num]);
}
dictionary.Add("BH", list);
DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.HBGetMXForMerge", dictionary);
int count = table.Rows.Count;
List <XSDJ_MXModel> list2 = new List <XSDJ_MXModel>();
for (num = 0; num < table.Rows.Count; num++)
{
DataRow row = table.Rows[num];
XSDJ_MXModel item = new XSDJ_MXModel {
XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH"),
XH = num + 1,
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")
};
list2.Add(item);
}
return(list2);
}
public BMBaseModel GetModel(string BM)
{
DataTable kH = this.bmclDAL.GetKH(BM);
BMCLModel model = new BMCLModel();
if (kH.Rows.Count > 0)
{
DataRow row = kH.Rows[0];
model.BM = GetSafeData.ValidateValue <string>(row, "BM");
model.MC = GetSafeData.ValidateValue <string>(row, "MC");
model.JM = GetSafeData.ValidateValue <string>(row, "JM");
model.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
model.CPXH = GetSafeData.ValidateValue <string>(row, "CPXH");
model.CD = GetSafeData.ValidateValue <string>(row, "CD");
model.SCCJMC = GetSafeData.ValidateValue <string>(row, "SCCJMC");
model.WJ = GetSafeData.ValidateValue <int>(row, "WJ");
model.SPFL = GetSafeData.ValidateValue <string>(row, "SPFL");
model.YHZC = GetSafeData.ValidateValue <string>(row, "YHZC");
model.SPFLMC = GetSafeData.ValidateValue <string>(row, "SPFLMC");
model.YHZCMC = GetSafeData.ValidateValue <string>(row, "YHZCMC");
}
return(model);
}
public XXFPPaper GetInvPaper(string FPZL, string FPDM, string FPHM, bool GetInvQD)
{
XXFPPaper paper2;
try
{
double sLV;
Dictionary <string, object> dictionary2;
int num2;
XXFP_MXModel model;
string str3;
double num3;
string str4;
double num4;
string str5;
double num5;
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("FPZL", FPZL);
dictionary.Add("FPDM", FPDM);
dictionary.Add("FPHM", FPHM);
DataTable table = this.baseDAO.querySQLDataTable("aisino.Fwkp.Wbjk.GetInfoXXFP", dictionary);
XXFPPaper paper = new XXFPPaper();
if (table.Rows.Count > 0)
{
string str;
byte[] buffer;
DataRow row = table.Rows[0];
paper.FPZL = GetSafeData.ValidateValue <string>(row, "FPZL");
paper.FPDM = GetSafeData.ValidateValue <string>(row, "FPDM");
paper.FPHM = (long)GetSafeData.ValidateValue <int>(row, "FPHM");
if ((paper.FPZL == "s") || (paper.FPZL == "c"))
{
paper.XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH");
paper.XFMC = GetSafeData.ValidateValue <string>(row, "XFMC");
paper.XFSH = GetSafeData.ValidateValue <string>(row, "XFSH");
paper.GFMC = GetSafeData.ValidateValue <string>(row, "GFMC");
paper.GFSH = GetSafeData.ValidateValue <string>(row, "GFSH");
paper.GFYHZH = GetSafeData.ValidateValue <string>(row, "GFYHZH");
paper.GFDZDH = GetSafeData.ValidateValue <string>(row, "GFDZDH");
paper.XFDZDH = GetSafeData.ValidateValue <string>(row, "XFDZDH");
paper.XFYHZH = GetSafeData.ValidateValue <string>(row, "XFYHZH");
str = GetSafeData.ValidateValue <string>(row, "BZ");
if ((str == null) || (str == ""))
{
str = "";
}
else
{
buffer = Convert.FromBase64String(str);
if ((buffer != null) && (buffer.Length >= 1))
{
str = ToolUtil.GetString(buffer);
}
else
{
str = "";
}
}
paper.BZ = str;
paper.SKR = GetSafeData.ValidateValue <string>(row, "SKR");
paper.FHR = GetSafeData.ValidateValue <string>(row, "FHR");
paper.KPRQ = GetSafeData.ValidateValue <DateTime>(row, "KPRQ");
paper.KPR = GetSafeData.ValidateValue <string>(row, "KPR");
paper.HJSE = GetSafeData.ValidateValue <double>(row, "HJSE");
paper.HJJE = GetSafeData.ValidateValue <double>(row, "HJJE");
paper.SLV = GetSafeData.ValidateValue <double>(row, "SLV");
paper.ZFBZ = GetSafeData.ValidateValue <bool>(row, "ZFBZ");
paper.QDBZ = GetSafeData.ValidateValue <bool>(row, "QDBZ");
}
else if (paper.FPZL == "f")
{
paper.XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH");
paper.HJJE = GetSafeData.ValidateValue <double>(row, "HJJE");
paper.SLV = GetSafeData.ValidateValue <double>(row, "SLV");
paper.HJSE = GetSafeData.ValidateValue <double>(row, "HJSE");
paper.GFMC = GetSafeData.ValidateValue <string>(row, "GFMC");
paper.GFSH = GetSafeData.ValidateValue <string>(row, "GFSH");
paper.SHRMC = GetSafeData.ValidateValue <string>(row, "GFDZDH");
paper.SHRSH = GetSafeData.ValidateValue <string>(row, "CM");
paper.FHRMC = GetSafeData.ValidateValue <string>(row, "XFDZDH");
paper.FHRSH = GetSafeData.ValidateValue <string>(row, "TYDH");
paper.XFMC = GetSafeData.ValidateValue <string>(row, "XFMC");
paper.XFSH = GetSafeData.ValidateValue <string>(row, "XFSH");
paper.QYJYMD = GetSafeData.ValidateValue <string>(row, "XFYHZH");
paper.CZCH = GetSafeData.ValidateValue <string>(row, "QYD");
paper.CCDW = GetSafeData.ValidateValue <string>(row, "YYZZH");
paper.KPR = GetSafeData.ValidateValue <string>(row, "KPR");
paper.FHR = GetSafeData.ValidateValue <string>(row, "FHR");
paper.SKR = GetSafeData.ValidateValue <string>(row, "SKR");
paper.ZGSWMC = GetSafeData.ValidateValue <string>(row, "GFYHZH");
paper.ZGSWDM = GetSafeData.ValidateValue <string>(row, "HYBM");
paper.JQBH = GetSafeData.ValidateValue <string>(row, "JQBH");
paper.ZFBZ = GetSafeData.ValidateValue <bool>(row, "ZFBZ");
string s = GetSafeData.ValidateValue <string>(row, "YSHWXX");
if ((s == null) || (s == ""))
{
paper.YSHWXX = "";
}
else
{
buffer = Convert.FromBase64String(s);
if ((buffer != null) && (buffer.Length >= 1))
{
s = ToolUtil.GetString(buffer);
}
else
{
s = "";
}
}
paper.YSHWXX = s;
str = GetSafeData.ValidateValue <string>(row, "BZ");
if ((str == null) || (str == ""))
{
paper.BZ = "";
}
else
{
buffer = Convert.FromBase64String(str);
if ((buffer != null) && (buffer.Length >= 1))
{
str = ToolUtil.GetString(buffer);
}
else
{
str = "";
}
}
paper.BZ = str;
}
else if (paper.FPZL == "j")
{
paper.XSDJBH = GetSafeData.ValidateValue <string>(row, "XSDJBH");
paper.HJJE = GetSafeData.ValidateValue <double>(row, "HJJE");
paper.SLV = GetSafeData.ValidateValue <double>(row, "SLV");
paper.HJSE = GetSafeData.ValidateValue <double>(row, "HJSE");
paper.GFMC = GetSafeData.ValidateValue <string>(row, "GFMC");
paper.GFSH = GetSafeData.ValidateValue <string>(row, "GFSH");
paper.SFZHM = GetSafeData.ValidateValue <string>(row, "XSBM");
paper.CLLX = GetSafeData.ValidateValue <string>(row, "GFDZDH");
paper.CPXH = GetSafeData.ValidateValue <string>(row, "XFDZ");
paper.CD = GetSafeData.ValidateValue <string>(row, "KHYHMC");
paper.SCCJMC = GetSafeData.ValidateValue <string>(row, "SCCJMC");
paper.HGZH = GetSafeData.ValidateValue <string>(row, "CM");
paper.JKZMSH = GetSafeData.ValidateValue <string>(row, "TYDH");
paper.SJDH = GetSafeData.ValidateValue <string>(row, "QYD");
paper.FDJH = GetSafeData.ValidateValue <string>(row, "ZHD");
paper.CLSBDH = GetSafeData.ValidateValue <string>(row, "XHD");
paper.XFMC = GetSafeData.ValidateValue <string>(row, "XFMC");
paper.XFSH = GetSafeData.ValidateValue <string>(row, "XFSH");
paper.DH = GetSafeData.ValidateValue <string>(row, "XFDH");
paper.ZH = GetSafeData.ValidateValue <string>(row, "KHYHZH");
paper.DZ = GetSafeData.ValidateValue <string>(row, "XFDZDH");
paper.KHYH = GetSafeData.ValidateValue <string>(row, "XFYHZH");
paper.DW = GetSafeData.ValidateValue <string>(row, "YYZZH");
paper.XCRS = GetSafeData.ValidateValue <string>(row, "MDD");
paper.KPR = GetSafeData.ValidateValue <string>(row, "KPR");
paper.ZGSWMC = GetSafeData.ValidateValue <string>(row, "GFYHZH");
paper.ZGSWDM = GetSafeData.ValidateValue <string>(row, "HYBM");
paper.JQBH = GetSafeData.ValidateValue <string>(row, "JQBH");
paper.ZFBZ = GetSafeData.ValidateValue <bool>(row, "ZFBZ");
paper.ZYSPMC = row["ZYSPMC"].ToString().Trim();
paper.SPSM = row["SPSM_BM"].ToString().Trim();
paper.SKR = row["SKR"].ToString().Trim();
str = GetSafeData.ValidateValue <string>(row, "BZ");
if ((str == null) || (str == ""))
{
paper.BZ = "";
}
else
{
buffer = Convert.FromBase64String(str);
if ((buffer != null) && (buffer.Length >= 1))
{
str = ToolUtil.GetString(buffer);
}
else
{
str = "";
}
}
paper.BZ = str;
}
}
bool flag = false;
bool flag2 = false;
ArrayList list = this.baseDAO.querySQL("aisino.Fwkp.Wbjk.FPCCGetFaPiaoMX", dictionary);
if (list.Count > 0)
{
sLV = 0.0;
dictionary2 = new Dictionary <string, object>();
for (num2 = 0; num2 < list.Count; num2++)
{
dictionary2 = list[num2] as Dictionary <string, object>;
model = new XXFP_MXModel {
SPMC = dictionary2["SPMC"].ToString(),
GGXH = dictionary2["GGXH"].ToString(),
JLDW = dictionary2["JLDW"].ToString()
};
str3 = dictionary2["SL"].ToString();
num3 = 0.0;
model.SL = new double?(double.TryParse(str3, out num3) ? num3 : 0.0);
str4 = dictionary2["DJ"].ToString();
num4 = 0.0;
model.DJ = new double?(double.TryParse(str4, out num4) ? num4 : 0.0);
model.JE = Convert.ToDouble(dictionary2["JE"]);
str5 = dictionary2["SLV"].ToString();
num5 = 0.0;
model.SLV = double.TryParse(str5, out num5) ? num5 : 0.0;
model.SE = Convert.ToDouble(dictionary2["SE"]);
model.SPSM = dictionary2["SPSM"].ToString();
model.FPHXZ = Convert.ToInt32(dictionary2["FPHXZ"]);
model.HSJBZ = Convert.ToBoolean(dictionary2["HSJBZ"]);
paper.ListInvWare.Add(model);
if ((num2 > 0) && !(sLV == model.SLV))
{
flag = true;
}
sLV = model.SLV;
model.FLBM = dictionary2["FLBM"].ToString().Trim();
model.XSYH = false;
if (dictionary2["XSYH"].ToString().Trim() == "1")
{
model.XSYH = true;
}
}
}
ArrayList list2 = this.baseDAO.querySQL("aisino.Fwkp.Wbjk.FPCCGetFaPiaoQD", dictionary);
if (list2.Count > 0)
{
sLV = 0.0;
dictionary2 = new Dictionary <string, object>();
for (num2 = 0; num2 < list2.Count; num2++)
{
dictionary2 = list2[num2] as Dictionary <string, object>;
model = new XXFP_MXModel {
SPMC = dictionary2["SPMC"].ToString(),
GGXH = dictionary2["GGXH"].ToString(),
JLDW = dictionary2["JLDW"].ToString()
};
str3 = dictionary2["SL"].ToString();
num3 = 0.0;
model.SL = new double?(double.TryParse(str3, out num3) ? num3 : 0.0);
str4 = dictionary2["DJ"].ToString();
num4 = 0.0;
model.DJ = new double?(double.TryParse(str4, out num4) ? num4 : 0.0);
model.JE = Convert.ToDouble(dictionary2["JE"]);
str5 = dictionary2["SLV"].ToString();
num5 = 0.0;
model.SLV = double.TryParse(str5, out num5) ? num5 : 0.0;
model.SE = Convert.ToDouble(dictionary2["SE"]);
model.SPSM = dictionary2["SPSM"].ToString();
model.FPHXZ = Convert.ToInt32(dictionary2["FPHXZ"]);
model.HSJBZ = Convert.ToBoolean(dictionary2["HSJBZ"]);
model.FLBM = dictionary2["FLBM"].ToString().Trim();
model.XSYH = false;
if (dictionary2["XSYH"].ToString().Trim() == "1")
{
model.XSYH = true;
}
model.LSLVBS = dictionary2["LSLVBS"].ToString().Trim();
if (GetInvQD)
{
paper.ListInvWare.Add(model);
}
if ((num2 > 0) && !(sLV == model.SLV))
{
flag2 = true;
}
sLV = model.SLV;
}
}
if (flag || flag2)
{
paper.MULSLV = true;
}
paper2 = paper;
}
catch (Exception)
{
string message = string.Format("FPZL={0},FPDM={1},FPHM={2}", FPZL, FPDM, FPHM);
HandleException.Log.Error(message);
throw;
}
return(paper2);
}
private void ReFirstNodes(string tableName, DataTable topNodeTable, int maxLenOfTopNodes, bool padFlag)
{
try
{
int num3;
int num = 0;
int result = 0;
switch (tableName)
{
case "BM_KH":
num = 0;
result = 0;
foreach (DataRow row in topNodeTable.Rows)
{
BMKHModel customer = new BMKHModel();
BMKHManager manager = new BMKHManager();
customer.SJBM = GetSafeData.ValidateValue <string>(row, "SJBM");
string s = GetSafeData.ValidateValue <string>(row, "BM");
if (padFlag)
{
customer.BM = s.PadLeft(maxLenOfTopNodes, '0');
}
else
{
int num4 = num + 1;
customer.BM = customer.SJBM + num4.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
customer.MC = GetSafeData.ValidateValue <string>(row, "MC");
customer.JM = GetSafeData.ValidateValue <string>(row, "JM");
customer.KJM = GetSafeData.ValidateValue <string>(row, "KJM");
customer.SH = GetSafeData.ValidateValue <string>(row, "SH");
customer.DZDH = GetSafeData.ValidateValue <string>(row, "DZDH");
customer.YHZH = GetSafeData.ValidateValue <string>(row, "YHZH");
customer.YJDZ = GetSafeData.ValidateValue <string>(row, "YJDZ");
customer.BZ = GetSafeData.ValidateValue <string>(row, "BZ");
customer.YSKM = GetSafeData.ValidateValue <string>(row, "YSKM");
customer.DQBM = GetSafeData.ValidateValue <string>(row, "DQBM");
customer.DQMC = GetSafeData.ValidateValue <string>(row, "DQMC");
customer.DQKM = GetSafeData.ValidateValue <string>(row, "DQKM");
customer.SFZJY = GetSafeData.ValidateValue <bool>(row, "SFZJY");
customer.WJ = GetSafeData.ValidateValue <int>(row, "WJ");
if (!int.TryParse(s, out result))
{
result++;
}
for (string str2 = manager.UpdateSubNodesSJBM(customer, s); "e1" == str2; str2 = manager.UpdateSubNodesSJBM(customer, s))
{
if (padFlag)
{
result++;
customer.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
int num6 = num + 1;
customer.BM = customer.SJBM + num6.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
return;
case "BM_SP":
num = 0;
result = 0;
foreach (DataRow row2 in topNodeTable.Rows)
{
BMSPModel merchandise = new BMSPModel();
BMSPManager manager2 = new BMSPManager();
merchandise.SJBM = GetSafeData.ValidateValue <string>(row2, "SJBM");
string str3 = GetSafeData.ValidateValue <string>(row2, "BM");
if (padFlag)
{
merchandise.BM = str3.PadLeft(maxLenOfTopNodes, '0');
}
else
{
int num8 = num + 1;
merchandise.BM = merchandise.SJBM + num8.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
merchandise.MC = GetSafeData.ValidateValue <string>(row2, "MC");
merchandise.JM = GetSafeData.ValidateValue <string>(row2, "JM");
merchandise.KJM = GetSafeData.ValidateValue <string>(row2, "KJM");
merchandise.SLV = GetSafeData.ValidateValue <double>(row2, "SLV");
merchandise.SPSM = GetSafeData.ValidateValue <string>(row2, "SPSM");
merchandise.GGXH = GetSafeData.ValidateValue <string>(row2, "GGXH");
merchandise.JLDW = GetSafeData.ValidateValue <string>(row2, "JLDW");
merchandise.DJ = GetSafeData.ValidateValue <double>(row2, "DJ");
merchandise.HSJBZ = GetSafeData.ValidateValue <bool>(row2, "HSJBZ");
merchandise.XSSRKM = GetSafeData.ValidateValue <string>(row2, "XSSRKM");
merchandise.YJZZSKM = GetSafeData.ValidateValue <string>(row2, "YJZZSKM");
merchandise.XSTHKM = GetSafeData.ValidateValue <string>(row2, "XSTHKM");
merchandise.HYSY = GetSafeData.ValidateValue <bool>(row2, "HYSY");
merchandise.XTHASH = GetSafeData.ValidateValue <string>(row2, "XTHASH");
merchandise.XTCODE = GetSafeData.ValidateValue <string>(row2, "XTCODE");
merchandise.ISHIDE = GetSafeData.ValidateValue <string>(row2, "ISHIDE");
merchandise.WJ = GetSafeData.ValidateValue <int>(row2, "WJ");
if (!int.TryParse(str3, out result))
{
result++;
}
for (string str4 = manager2.UpdateSubNodesSJBM(merchandise, str3); "e1" == str4; str4 = manager2.UpdateSubNodesSJBM(merchandise, str3))
{
if (padFlag)
{
result++;
merchandise.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
int num10 = num + 1;
merchandise.BM = merchandise.SJBM + num10.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
return;
case "BM_SFHR":
num = 0;
result = 0;
foreach (DataRow row3 in topNodeTable.Rows)
{
BMSFHRModel model3 = new BMSFHRModel();
BMSFHRManager manager3 = new BMSFHRManager();
model3.SJBM = GetSafeData.ValidateValue <string>(row3, "SJBM");
string str5 = GetSafeData.ValidateValue <string>(row3, "BM");
if (padFlag)
{
model3.BM = str5.PadLeft(maxLenOfTopNodes, '0');
}
else
{
int num12 = num + 1;
model3.BM = model3.SJBM + num12.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
model3.MC = GetSafeData.ValidateValue <string>(row3, "MC");
model3.JM = GetSafeData.ValidateValue <string>(row3, "JM");
model3.SH = GetSafeData.ValidateValue <string>(row3, "SH");
model3.DZDH = GetSafeData.ValidateValue <string>(row3, "DZDH");
model3.YHZH = GetSafeData.ValidateValue <string>(row3, "YHZH");
model3.YZBM = GetSafeData.ValidateValue <string>(row3, "YZBM");
model3.WJ = GetSafeData.ValidateValue <int>(row3, "WJ");
if (!int.TryParse(str5, out result))
{
result++;
}
for (string str6 = manager3.UpdateSubNodesSJBM(model3, str5); "e1" == str6; str6 = manager3.UpdateSubNodesSJBM(model3, str5))
{
if (padFlag)
{
result++;
model3.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
int num14 = num + 1;
model3.BM = model3.SJBM + num14.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
return;
case "BM_FYXM":
num = 0;
result = 0;
foreach (DataRow row4 in topNodeTable.Rows)
{
BMFYXMModel feiyong = new BMFYXMModel();
BMFYXMManager manager4 = new BMFYXMManager();
feiyong.SJBM = GetSafeData.ValidateValue <string>(row4, "SJBM");
string str7 = GetSafeData.ValidateValue <string>(row4, "BM");
if (padFlag)
{
feiyong.BM = str7.PadLeft(maxLenOfTopNodes, '0');
}
else
{
int num16 = num + 1;
feiyong.BM = feiyong.SJBM + num16.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
feiyong.MC = GetSafeData.ValidateValue <string>(row4, "MC");
feiyong.JM = GetSafeData.ValidateValue <string>(row4, "JM");
feiyong.WJ = GetSafeData.ValidateValue <int>(row4, "WJ");
if (!int.TryParse(str7, out result))
{
result++;
}
for (string str8 = manager4.UpdateSubNodesSJBM(feiyong, str7); "e1" == str8; str8 = manager4.UpdateSubNodesSJBM(feiyong, str7))
{
if (padFlag)
{
result++;
feiyong.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
int num18 = num + 1;
feiyong.BM = feiyong.SJBM + num18.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
return;
case "BM_GHDW":
num = 0;
result = 0;
foreach (DataRow row5 in topNodeTable.Rows)
{
BMGHDWModel purchase = new BMGHDWModel();
BMGHDWManager manager5 = new BMGHDWManager();
purchase.SJBM = GetSafeData.ValidateValue <string>(row5, "SJBM");
string str9 = GetSafeData.ValidateValue <string>(row5, "BM");
if (padFlag)
{
purchase.BM = str9.PadLeft(maxLenOfTopNodes, '0');
}
else
{
num3 = num + 1;
purchase.BM = purchase.SJBM + num3.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
purchase.MC = GetSafeData.ValidateValue <string>(row5, "MC");
purchase.JM = GetSafeData.ValidateValue <string>(row5, "JM");
purchase.SH = GetSafeData.ValidateValue <string>(row5, "SH");
purchase.DZDH = GetSafeData.ValidateValue <string>(row5, "DZDH");
purchase.YHZH = GetSafeData.ValidateValue <string>(row5, "YHZH");
purchase.IDCOC = GetSafeData.ValidateValue <string>(row5, "IDCOC");
purchase.WJ = GetSafeData.ValidateValue <int>(row5, "WJ");
if (!int.TryParse(str9, out result))
{
result++;
}
for (string str10 = manager5.UpdateSubNodesSJBM(purchase, str9); "e1" == str10; str10 = manager5.UpdateSubNodesSJBM(purchase, str9))
{
if (padFlag)
{
result++;
purchase.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
num3 = num + 1;
purchase.BM = purchase.SJBM + num3.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
return;
case "BM_CL":
num = 0;
result = 0;
foreach (DataRow row6 in topNodeTable.Rows)
{
BMCLModel car = new BMCLModel();
BMCLManager manager6 = new BMCLManager();
car.SJBM = GetSafeData.ValidateValue <string>(row6, "SJBM");
string str11 = GetSafeData.ValidateValue <string>(row6, "BM");
if (padFlag)
{
car.BM = str11.PadLeft(maxLenOfTopNodes, '0');
}
else
{
num3 = num + 1;
car.BM = car.SJBM + num3.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
car.MC = GetSafeData.ValidateValue <string>(row6, "MC");
car.JM = GetSafeData.ValidateValue <string>(row6, "JM");
car.CPXH = GetSafeData.ValidateValue <string>(row6, "CPXH");
car.CD = GetSafeData.ValidateValue <string>(row6, "CD");
car.SCCJMC = GetSafeData.ValidateValue <string>(row6, "SCCJMC");
car.WJ = GetSafeData.ValidateValue <int>(row6, "WJ");
if (!int.TryParse(str11, out result))
{
result++;
}
for (string str12 = manager6.UpdateSubNodesSJBM(car, str11); "e1" == str12; str12 = manager6.UpdateSubNodesSJBM(car, str11))
{
if (padFlag)
{
result++;
car.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
num3 = num + 1;
car.BM = car.SJBM + num3.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
return;
case "BM_XHDW":
break;
default:
return;
}
num = 0;
result = 0;
foreach (DataRow row7 in topNodeTable.Rows)
{
BMXHDWModel model7 = new BMXHDWModel();
BMXHDWManager manager7 = new BMXHDWManager();
model7.SJBM = GetSafeData.ValidateValue <string>(row7, "SJBM");
string str13 = GetSafeData.ValidateValue <string>(row7, "BM");
if (padFlag)
{
model7.BM = str13.PadLeft(maxLenOfTopNodes, '0');
}
else
{
num3 = num + 1;
model7.BM = model7.SJBM + num3.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
model7.MC = GetSafeData.ValidateValue <string>(row7, "MC");
model7.JM = GetSafeData.ValidateValue <string>(row7, "JM");
model7.SH = GetSafeData.ValidateValue <string>(row7, "SH");
model7.DZDH = GetSafeData.ValidateValue <string>(row7, "DZDH");
model7.YHZH = GetSafeData.ValidateValue <string>(row7, "YHZH");
model7.YZBM = GetSafeData.ValidateValue <string>(row7, "YZBM");
model7.WJ = GetSafeData.ValidateValue <int>(row7, "WJ");
if (!int.TryParse(str13, out result))
{
result++;
}
for (string str14 = manager7.UpdateSubNodesSJBM(model7, str13); "e1" == str14; str14 = manager7.UpdateSubNodesSJBM(model7, str13))
{
if (padFlag)
{
result++;
model7.BM = result.ToString().PadLeft(maxLenOfTopNodes, '0');
}
else
{
num++;
num3 = num + 1;
model7.BM = model7.SJBM + num3.ToString().PadLeft(topNodeTable.Rows.Count.ToString().Length + 2, '0');
}
}
num++;
}
}
catch (Exception)
{
}
}
private void ReNode(string tableName, string SJBM)
{
try
{
int num;
DataRow row2;
DataRow row3;
DataRow row4;
DataRow row5;
DataRow row6;
DataRow row7;
DataRow row8;
DataRow[] rowArray = this.baseDAO.querySQLDataTable("SELECT * FROM " + tableName).Select("SJBM = '" + SJBM + "'");
bool flag = false;
foreach (DataRow row in rowArray)
{
if (GetSafeData.ValidateValue <string>(row, "BM").Length > 0x10)
{
flag = true;
break;
}
}
if (!flag)
{
goto Label_0CE4;
}
switch (tableName)
{
case "BM_KH":
num = 0;
num = 0;
goto Label_0322;
case "BM_SP":
num = 0;
num = 0;
goto Label_056E;
case "BM_SFHR":
num = 0;
num = 0;
goto Label_06FC;
case "BM_FYXM":
num = 0;
num = 0;
goto Label_083E;
case "BM_GHDW":
num = 0;
num = 0;
goto Label_09CC;
case "BM_CL":
num = 0;
num = 0;
goto Label_0B47;
case "BM_XHDW":
num = 0;
num = 0;
goto Label_0CD5;
default:
return;
}
Label_0129:
row2 = rowArray[num];
BMKHModel customer = new BMKHModel();
BMKHManager manager = new BMKHManager();
string yuanBM = GetSafeData.ValidateValue <string>(row2, "BM");
int num4 = num + 1;
int length = rowArray.Length;
customer.BM = SJBM + num4.ToString().PadLeft(length.ToString().Length + 1, '0');
customer.MC = GetSafeData.ValidateValue <string>(row2, "MC");
customer.JM = GetSafeData.ValidateValue <string>(row2, "JM");
customer.KJM = GetSafeData.ValidateValue <string>(row2, "KJM");
customer.SH = GetSafeData.ValidateValue <string>(row2, "SH");
customer.DZDH = GetSafeData.ValidateValue <string>(row2, "DZDH");
customer.YHZH = GetSafeData.ValidateValue <string>(row2, "YHZH");
customer.YJDZ = GetSafeData.ValidateValue <string>(row2, "YJDZ");
customer.BZ = GetSafeData.ValidateValue <string>(row2, "BZ");
customer.YSKM = GetSafeData.ValidateValue <string>(row2, "YSKM");
customer.DQBM = GetSafeData.ValidateValue <string>(row2, "DQBM");
customer.DQMC = GetSafeData.ValidateValue <string>(row2, "DQMC");
customer.DQKM = GetSafeData.ValidateValue <string>(row2, "DQKM");
customer.SJBM = GetSafeData.ValidateValue <string>(row2, "SJBM");
customer.SFZJY = GetSafeData.ValidateValue <bool>(row2, "SFZJY");
customer.WJ = GetSafeData.ValidateValue <int>(row2, "WJ");
string str3 = manager.UpdateSubNodesSJBM(customer, yuanBM);
while ("e1" == str3)
{
num++;
int num6 = num + 1;
int num7 = rowArray.Length;
customer.BM = SJBM + num6.ToString().PadLeft(num7.ToString().Length + 1, '0');
str3 = manager.UpdateSubNodesSJBM(customer, yuanBM);
}
if ("0" == str3)
{
this.ReNode(tableName, customer.BM);
}
num++;
Label_0322:
if (num < rowArray.Length)
{
goto Label_0129;
}
return;
Label_033C:
row3 = rowArray[num];
BMSPModel merchandise = new BMSPModel();
BMSPManager manager2 = new BMSPManager();
string str4 = GetSafeData.ValidateValue <string>(row3, "BM");
int num8 = num + 1;
int num9 = rowArray.Length;
merchandise.BM = SJBM + num8.ToString().PadLeft(num9.ToString().Length + 1, '0');
merchandise.MC = GetSafeData.ValidateValue <string>(row3, "MC");
merchandise.JM = GetSafeData.ValidateValue <string>(row3, "JM");
merchandise.KJM = GetSafeData.ValidateValue <string>(row3, "KJM");
merchandise.SJBM = GetSafeData.ValidateValue <string>(row3, "SJBM");
merchandise.SLV = GetSafeData.ValidateValue <double>(row3, "SLV");
merchandise.SPSM = GetSafeData.ValidateValue <string>(row3, "SPSM");
merchandise.GGXH = GetSafeData.ValidateValue <string>(row3, "GGXH");
merchandise.JLDW = GetSafeData.ValidateValue <string>(row3, "JLDW");
merchandise.DJ = GetSafeData.ValidateValue <double>(row3, "DJ");
merchandise.HSJBZ = GetSafeData.ValidateValue <bool>(row3, "HSJBZ");
merchandise.XSSRKM = GetSafeData.ValidateValue <string>(row3, "XSSRKM");
merchandise.YJZZSKM = GetSafeData.ValidateValue <string>(row3, "YJZZSKM");
merchandise.XSTHKM = GetSafeData.ValidateValue <string>(row3, "XSTHKM");
merchandise.HYSY = GetSafeData.ValidateValue <bool>(row3, "HYSY");
merchandise.XTHASH = GetSafeData.ValidateValue <string>(row3, "XTHASH");
merchandise.XTCODE = GetSafeData.ValidateValue <string>(row3, "XTCODE");
merchandise.ISHIDE = GetSafeData.ValidateValue <string>(row3, "ISHIDE");
merchandise.WJ = GetSafeData.ValidateValue <int>(row3, "WJ");
string str5 = manager2.UpdateSubNodesSJBM(merchandise, str4);
while ("e1" == str5)
{
num++;
int num10 = num + 1;
int num11 = rowArray.Length;
merchandise.BM = SJBM + num10.ToString().PadLeft(num11.ToString().Length + 1, '0');
str5 = manager2.UpdateSubNodesSJBM(merchandise, str4);
}
if ("0" == str5)
{
this.ReNode(tableName, merchandise.BM);
}
num++;
Label_056E:
if (num < rowArray.Length)
{
goto Label_033C;
}
return;
Label_0588:
row4 = rowArray[num];
BMSFHRModel model3 = new BMSFHRModel();
BMSFHRManager manager3 = new BMSFHRManager();
string str6 = GetSafeData.ValidateValue <string>(row4, "BM");
int num12 = num + 1;
int num13 = rowArray.Length;
model3.BM = SJBM + num12.ToString().PadLeft(num13.ToString().Length + 1, '0');
model3.MC = GetSafeData.ValidateValue <string>(row4, "MC");
model3.JM = GetSafeData.ValidateValue <string>(row4, "JM");
model3.SJBM = GetSafeData.ValidateValue <string>(row4, "SJBM");
model3.SH = GetSafeData.ValidateValue <string>(row4, "SH");
model3.DZDH = GetSafeData.ValidateValue <string>(row4, "DZDH");
model3.YHZH = GetSafeData.ValidateValue <string>(row4, "YHZH");
model3.YZBM = GetSafeData.ValidateValue <string>(row4, "YZBM");
model3.WJ = GetSafeData.ValidateValue <int>(row4, "WJ");
string str7 = manager3.UpdateSubNodesSJBM(model3, str6);
while ("e1" == str7)
{
num++;
int num14 = num + 1;
int num15 = rowArray.Length;
model3.BM = SJBM + num14.ToString().PadLeft(num15.ToString().Length + 1, '0');
str7 = manager3.UpdateSubNodesSJBM(model3, str6);
}
if ("0" == str7)
{
this.ReNode(tableName, model3.BM);
}
num++;
Label_06FC:
if (num < rowArray.Length)
{
goto Label_0588;
}
return;
Label_0716:
row5 = rowArray[num];
BMFYXMModel feiyong = new BMFYXMModel();
BMFYXMManager manager4 = new BMFYXMManager();
string str8 = GetSafeData.ValidateValue <string>(row5, "BM");
int num16 = num + 1;
int num3 = rowArray.Length;
feiyong.BM = SJBM + num16.ToString().PadLeft(num3.ToString().Length + 1, '0');
feiyong.MC = GetSafeData.ValidateValue <string>(row5, "MC");
feiyong.JM = GetSafeData.ValidateValue <string>(row5, "JM");
feiyong.SJBM = GetSafeData.ValidateValue <string>(row5, "SJBM");
feiyong.WJ = GetSafeData.ValidateValue <int>(row5, "WJ");
string str9 = manager4.UpdateSubNodesSJBM(feiyong, str8);
while ("e1" == str9)
{
num++;
num3 = num + 1;
num3 = rowArray.Length;
string introduced65 = num3.ToString();
feiyong.BM = SJBM + introduced65.PadLeft(num3.ToString().Length + 1, '0');
str9 = manager4.UpdateSubNodesSJBM(feiyong, str8);
}
if ("0" == str9)
{
this.ReNode(tableName, feiyong.BM);
}
num++;
Label_083E:
if (num < rowArray.Length)
{
goto Label_0716;
}
return;
Label_0858:
row6 = rowArray[num];
BMGHDWModel purchase = new BMGHDWModel();
BMGHDWManager manager5 = new BMGHDWManager();
string str10 = GetSafeData.ValidateValue <string>(row6, "BM");
num3 = num + 1;
num3 = rowArray.Length;
string introduced66 = num3.ToString();
purchase.BM = SJBM + introduced66.PadLeft(num3.ToString().Length + 1, '0');
purchase.MC = GetSafeData.ValidateValue <string>(row6, "MC");
purchase.JM = GetSafeData.ValidateValue <string>(row6, "JM");
purchase.SH = GetSafeData.ValidateValue <string>(row6, "SH");
purchase.DZDH = GetSafeData.ValidateValue <string>(row6, "DZDH");
purchase.YHZH = GetSafeData.ValidateValue <string>(row6, "YHZH");
purchase.IDCOC = GetSafeData.ValidateValue <string>(row6, "IDCOC");
purchase.SJBM = GetSafeData.ValidateValue <string>(row6, "SJBM");
purchase.WJ = GetSafeData.ValidateValue <int>(row6, "WJ");
string str11 = manager5.UpdateSubNodesSJBM(purchase, str10);
while ("e1" == str11)
{
num++;
num3 = num + 1;
num3 = rowArray.Length;
string introduced67 = num3.ToString();
purchase.BM = SJBM + introduced67.PadLeft(num3.ToString().Length + 1, '0');
str11 = manager5.UpdateSubNodesSJBM(purchase, str10);
}
if ("0" == str11)
{
this.ReNode(tableName, purchase.BM);
}
num++;
Label_09CC:
if (num < rowArray.Length)
{
goto Label_0858;
}
return;
Label_09E6:
row7 = rowArray[num];
BMCLModel car = new BMCLModel();
BMCLManager manager6 = new BMCLManager();
string str12 = GetSafeData.ValidateValue <string>(row7, "BM");
num3 = num + 1;
num3 = rowArray.Length;
string introduced68 = num3.ToString();
car.BM = SJBM + introduced68.PadLeft(num3.ToString().Length + 1, '0');
car.MC = GetSafeData.ValidateValue <string>(row7, "MC");
car.JM = GetSafeData.ValidateValue <string>(row7, "JM");
car.SJBM = GetSafeData.ValidateValue <string>(row7, "SJBM");
car.CPXH = GetSafeData.ValidateValue <string>(row7, "CPXH");
car.CD = GetSafeData.ValidateValue <string>(row7, "CD");
car.SCCJMC = GetSafeData.ValidateValue <string>(row7, "SCCJMC");
car.WJ = GetSafeData.ValidateValue <int>(row7, "WJ");
string str13 = manager6.UpdateSubNodesSJBM(car, str12);
while ("e1" == str13)
{
num++;
num3 = num + 1;
num3 = rowArray.Length;
string introduced69 = num3.ToString();
car.BM = SJBM + introduced69.PadLeft(num3.ToString().Length + 1, '0');
str13 = manager6.UpdateSubNodesSJBM(car, str12);
}
if ("0" == str13)
{
this.ReNode(tableName, car.BM);
}
num++;
Label_0B47:
if (num < rowArray.Length)
{
goto Label_09E6;
}
return;
Label_0B61:
row8 = rowArray[num];
BMXHDWModel model7 = new BMXHDWModel();
BMXHDWManager manager7 = new BMXHDWManager();
string str14 = GetSafeData.ValidateValue <string>(row8, "BM");
num3 = num + 1;
num3 = rowArray.Length;
string introduced70 = num3.ToString();
model7.BM = SJBM + introduced70.PadLeft(num3.ToString().Length + 1, '0');
model7.MC = GetSafeData.ValidateValue <string>(row8, "MC");
model7.JM = GetSafeData.ValidateValue <string>(row8, "JM");
model7.SJBM = GetSafeData.ValidateValue <string>(row8, "SJBM");
model7.SH = GetSafeData.ValidateValue <string>(row8, "SH");
model7.DZDH = GetSafeData.ValidateValue <string>(row8, "DZDH");
model7.YHZH = GetSafeData.ValidateValue <string>(row8, "YHZH");
model7.YZBM = GetSafeData.ValidateValue <string>(row8, "YZBM");
model7.WJ = GetSafeData.ValidateValue <int>(row8, "WJ");
string str15 = manager7.UpdateSubNodesSJBM(model7, str14);
while ("e1" == str15)
{
num++;
num3 = num + 1;
num3 = rowArray.Length;
string introduced71 = num3.ToString();
model7.BM = SJBM + introduced71.PadLeft(num3.ToString().Length + 1, '0');
str15 = manager7.UpdateSubNodesSJBM(model7, str14);
}
if ("0" == str15)
{
this.ReNode(tableName, model7.BM);
}
num++;
Label_0CD5:
if (num < rowArray.Length)
{
goto Label_0B61;
}
return;
Label_0CE4 :;
foreach (DataRow row9 in this.baseDAO.querySQLDataTable("SELECT * FROM " + tableName + " WHERE SJBM ='" + SJBM + "'").Rows)
{
string sJBM = GetSafeData.ValidateValue <string>(row9, "BM");
this.ReNode(tableName, sJBM);
}
}
catch (Exception)
{
}
}
protected override object[] doService(object[] param)
{
try
{
bool flag = false;
string tableName = ((string)param[0]).Trim();
DataTable topNodeTable = this.baseDAO.querySQLDataTable("SELECT * FROM " + tableName + " WHERE SJBM IS NULL OR SJBM = ''");
if ((topNodeTable != null) && (topNodeTable.Rows.Count != 0))
{
int maxLenOfTopNodes = 0;
string str2 = "";
if (topNodeTable.Rows.Count > 0)
{
str2 = GetSafeData.ValidateValue <string>(topNodeTable.Rows[0], "BM");
}
foreach (DataRow row in topNodeTable.Rows)
{
string str3 = GetSafeData.ValidateValue <string>(row, "BM");
if (str3.Length > maxLenOfTopNodes)
{
maxLenOfTopNodes = str3.Length;
}
if (str2.Length != str3.Length)
{
flag = true;
}
}
if (maxLenOfTopNodes > 6)
{
this.ReFirstNodes(tableName, topNodeTable, maxLenOfTopNodes, false);
}
else if (flag)
{
this.ReFirstNodes(tableName, topNodeTable, maxLenOfTopNodes, true);
}
else
{
return(new object[] { "true" });
}
bool flag2 = false;
DataTable table2 = new DataTable();
flag2 = false;
foreach (DataRow row2 in this.baseDAO.querySQLDataTable("SELECT * FROM " + tableName).Rows)
{
if (GetSafeData.ValidateValue <string>(row2, "BM").Length > 0x10)
{
flag2 = true;
}
}
if (flag2)
{
this.ReNode(tableName, "");
}
}
return(new object[] { "true" });
}
catch (Exception)
{
return(new object[] { "false" });
}
}
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);
}
private void tool_xuanze_Click(object sender, EventArgs e)
{
DataGridViewSelectedRowCollection rows = this.aisinoGrid.SelectedRows;
if (rows.Count <= 0)
{
MessageManager.ShowMsgBox("INP-431403");
}
else
{
for (int i = 0; i < rows.Count; i++)
{
string sQDH = rows[i].Cells["SQDH"].Value.ToString();
if (this.sqdDal.Select(sQDH) != null)
{
XmlDocument document = new XmlDocument();
XmlDeclaration newChild = document.CreateXmlDeclaration("1.0", "GBK", null);
document.PreserveWhitespace = false;
document.AppendChild(newChild);
XmlElement element = document.CreateElement("INFO");
document.AppendChild(element);
if (HySqdTianKai.isFLBM)
{
XmlElement element2 = document.CreateElement("BMB_BBH");
element2.InnerText = this.aisinoGrid.SelectedRows[i].Cells["FLBMBBBH"].Value.ToString();
element.AppendChild(element2);
}
XmlElement element3 = document.CreateElement("XXBLX");
element3.InnerText = this.aisinoGrid.SelectedRows[i].Cells["BBBZ"].Value.ToString();
element.AppendChild(element3);
XmlElement element4 = document.CreateElement("BH");
element4.InnerText = this.aisinoGrid.SelectedRows[i].Cells["XXBBH"].Value.ToString();
element.AppendChild(element4);
XmlElement element5 = document.CreateElement("SQDMC");
element5.InnerText = this.aisinoGrid.SelectedRows[i].Cells["SQDH"].Value.ToString();
element.AppendChild(element5);
XmlElement element6 = document.CreateElement("TKRQ");
element6.InnerText = string.Format("{0:yyyy-MM-dd}", Convert.ToDateTime(this.aisinoGrid.SelectedRows[i].Cells["TKRQ"].Value.ToString()));
element.AppendChild(element6);
XmlElement element7 = document.CreateElement("FPLX_DM");
element7.InnerText = "009";
element.AppendChild(element7);
XmlElement sFJXSEZC = document.CreateElement("SFJXSEZC");
XmlElement sQF = document.CreateElement("SQF");
XmlElement element10 = document.CreateElement("KJLY");
XmlElement element11 = document.CreateElement("YQKJLY");
XmlElement element12 = document.CreateElement("KJLYSM");
element11.InnerText = "";
string reason = this.aisinoGrid.SelectedRows[i].Cells["SQXZ"].Value.ToString();
if (reason.Length > 10)
{
reason = reason.Substring(0, 10);
}
element12.InnerText = reason;
element10.InnerText = this.ParseReason(sQF, sFJXSEZC, reason);
element.AppendChild(sFJXSEZC);
element.AppendChild(sQF);
element.AppendChild(element10);
element.AppendChild(element11);
element.AppendChild(element12);
XmlElement element13 = document.CreateElement("YFPDM");
element13.InnerText = this.aisinoGrid.SelectedRows[i].Cells["FPDM"].Value.ToString();
element.AppendChild(element13);
XmlElement element14 = document.CreateElement("YFPHM");
element14.InnerText = this.aisinoGrid.SelectedRows[i].Cells["FPHM"].Value.ToString();
element.AppendChild(element14);
XmlElement element15 = document.CreateElement("XSFDM");
element15.InnerText = this.aisinoGrid.SelectedRows[i].Cells["XFSH"].Value.ToString();
element.AppendChild(element15);
XmlElement element16 = document.CreateElement("XSFMC");
element16.InnerText = this.aisinoGrid.SelectedRows[i].Cells["XFMC"].Value.ToString();
element.AppendChild(element16);
XmlElement element17 = document.CreateElement("GMFDM");
element17.InnerText = this.aisinoGrid.SelectedRows[i].Cells["GFSH"].Value.ToString();
element.AppendChild(element17);
XmlElement element18 = document.CreateElement("GMFMC");
element18.InnerText = this.aisinoGrid.SelectedRows[i].Cells["GFMC"].Value.ToString();
element.AppendChild(element18);
double num2 = 0.0;
double num3 = 0.0;
XmlElement element19 = document.CreateElement("HJJE");
num2 = Convert.ToDouble(this.aisinoGrid.SelectedRows[i].Cells["HJJE"].Value.ToString());
element19.InnerText = string.Format("{0:0.00}", num2);
element.AppendChild(element19);
XmlElement element20 = document.CreateElement("SL");
element20.InnerText = this.aisinoGrid.SelectedRows[i].Cells["SL"].Value.ToString();
element.AppendChild(element20);
XmlElement element21 = document.CreateElement("SE");
num3 = Convert.ToDouble(this.aisinoGrid.SelectedRows[i].Cells["HJSE"].Value.ToString());
element21.InnerText = string.Format("{0:0.00}", num3);
element.AppendChild(element21);
XmlElement element22 = document.CreateElement("JSHJ");
element22.InnerText = string.Format("{0:0.00}", num2 + num3);
element.AppendChild(element22);
XmlElement element23 = document.CreateElement("XSFSWJG_DM");
element.AppendChild(element23);
XmlElement element24 = document.CreateElement("XSFSWJG_MC");
element.AppendChild(element24);
XmlElement element25 = document.CreateElement("GMFSWJG_DM");
element.AppendChild(element25);
XmlElement element26 = document.CreateElement("GMFSWJG_MC");
element.AppendChild(element26);
XmlElement element27 = document.CreateElement("SHRSBH");
element27.InnerText = this.aisinoGrid.SelectedRows[i].Cells["SHRSH"].Value.ToString();
element.AppendChild(element27);
XmlElement element28 = document.CreateElement("SHRMC");
element28.InnerText = this.aisinoGrid.SelectedRows[i].Cells["SHRMC"].Value.ToString();
element.AppendChild(element28);
XmlElement element29 = document.CreateElement("FHRSBH");
element29.InnerText = this.aisinoGrid.SelectedRows[i].Cells["FHRSH"].Value.ToString();
element.AppendChild(element29);
XmlElement element30 = document.CreateElement("FHRMC");
element30.InnerText = this.aisinoGrid.SelectedRows[i].Cells["FHRMC"].Value.ToString();
element.AppendChild(element30);
XmlElement element31 = document.CreateElement("YSHWXX");
element31.InnerText = this.aisinoGrid.SelectedRows[i].Cells["YSHWXX"].Value.ToString();
element.AppendChild(element31);
XmlElement element32 = document.CreateElement("JQBH");
element32.InnerText = this.aisinoGrid.SelectedRows[i].Cells["JQBH"].Value.ToString();
element.AppendChild(element32);
XmlElement element33 = document.CreateElement("CZCH");
element33.InnerText = this.aisinoGrid.SelectedRows[i].Cells["CZCH"].Value.ToString();
element.AppendChild(element33);
XmlElement element34 = document.CreateElement("CCDW");
element34.InnerText = this.aisinoGrid.SelectedRows[i].Cells["CCDW"].Value.ToString();
element.AppendChild(element34);
XmlElement element35 = document.CreateElement("FYXMJJE");
element.AppendChild(element35);
DataTable table = this.sqdMxDal.SelectList(this.aisinoGrid.SelectedRows[i].Cells["SQDH"].Value.ToString());
for (int j = 0; j < table.Rows.Count; j++)
{
DataRow row = table.Rows[j];
XmlElement element36 = document.CreateElement("ZB");
element35.AppendChild(element36);
XmlElement element37 = document.CreateElement("FYXM");
element37.InnerText = GetSafeData.ValidateValue <string>(row, "SPMC");
element36.AppendChild(element37);
XmlElement element38 = document.CreateElement("JE");
element38.InnerText = GetSafeData.ValidateValue <decimal>(row, "JE").ToString("0.00");
element36.AppendChild(element38);
XmlElement element39 = document.CreateElement("MXSE");
element39.InnerText = GetSafeData.ValidateMxseValue(row, "SE");
element36.AppendChild(element39);
if (HySqdTianKai.isFLBM)
{
XmlElement element40 = document.CreateElement("SPBM");
element40.InnerText = GetSafeData.ValidateValue <string>(row, "FLBM");
element36.AppendChild(element40);
XmlElement element41 = document.CreateElement("ZXBM");
element41.InnerText = GetSafeData.ValidateValue <string>(row, "QYSPBM");
element36.AppendChild(element41);
XmlElement element42 = document.CreateElement("YHZCBS");
element42.InnerText = GetSafeData.ValidateValue <string>(row, "SFXSYHZC");
element36.AppendChild(element42);
XmlElement element43 = document.CreateElement("ZZSTSGL");
element43.InnerText = GetSafeData.ValidateValue <string>(row, "YHZCMC");
element36.AppendChild(element43);
XmlElement element44 = document.CreateElement("LSLBS");
element44.InnerText = GetSafeData.ValidateValue <string>(row, "LSLBS");
element36.AppendChild(element44);
}
}
document.PreserveWhitespace = true;
this._result = document.InnerXml;
}
}
base.DialogResult = DialogResult.OK;
}
}
