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);
}
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 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);
}
private string AddMXtoYL(XSDJ_MXModel mingxi)
{
Dictionary <string, object> dictionary = new Dictionary <string, object>();
dictionary.Add("XSDJBH", mingxi.XSDJBH);
dictionary.Add("XH", mingxi.XH);
dictionary.Add("SL", mingxi.SL);
dictionary.Add("DJ", mingxi.DJ);
dictionary.Add("JE", mingxi.JE);
dictionary.Add("SLV", mingxi.SLV);
dictionary.Add("SE", mingxi.SE);
dictionary.Add("SPMC", mingxi.SPMC);
dictionary.Add("SPSM", mingxi.SPSM);
dictionary.Add("GGXH", mingxi.GGXH);
dictionary.Add("JLDW", mingxi.JLDW);
dictionary.Add("HSJBZ", mingxi.HSJBZ);
dictionary.Add("DJHXZ", mingxi.DJHXZ);
if (this.baseDAO.updateSQL("aisino.Fwkp.Wbjk.XSDJMXAddYL", dictionary) > 0)
{
return("OK");
}
return("eMX");
}
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 listView1_MouseClick(object sender, MouseEventArgs e)
{
try
{
ListViewItem itemAt = this.listView1.GetItemAt(e.X, e.Y);
if (itemAt.Name != "MX")
{
FPGenerateResult tag = (FPGenerateResult)itemAt.Tag;
if (tag.DJZL != "j")
{
int num2;
int index = itemAt.Index + 1;
if ((index < this.listView1.Items.Count) && (this.listView1.Items[index].Name == "MX"))
{
for (num2 = 0; num2 < (tag.ListXSDJ_MX.Count + 1); num2++)
{
this.listView1.Items.RemoveAt(index);
}
}
else
{
ListViewItem item = new ListViewItem {
ForeColor = Color.Red,
Name = "MX",
Font = new Font("宋体", 10f)
};
item.SubItems.Add("序号");
item.SubItems.Add("货物名称");
item.SubItems.Add("规格型号");
item.SubItems.Add("单位");
item.SubItems.Add("数量");
item.SubItems.Add("单价");
item.SubItems.Add("金额");
item.SubItems.Add("税额");
item.SubItems.Add("税率");
this.listView1.Items.Insert(index, item);
for (num2 = 0; num2 < tag.ListXSDJ_MX.Count; num2++)
{
decimal num4;
XSDJ_MXModel model = tag.ListXSDJ_MX[num2];
ListViewItem item3 = new ListViewItem {
Name = "MX",
ForeColor = Color.Blue,
Font = new Font("宋体", 10f)
};
int num3 = num2 + 1;
item3.SubItems.Add(num3.ToString());
item3.SubItems.Add(model.SPMC);
item3.SubItems.Add(model.GGXH);
item3.SubItems.Add(model.JLDW);
string text = (model.SL == 0.0) ? "" : (num4 = (decimal)model.SL).ToString();
item3.SubItems.Add(text);
string str2 = (model.DJ == 0.0) ? "" : (num4 = (decimal)model.DJ).ToString();
item3.SubItems.Add(str2);
item3.SubItems.Add(model.JE.ToString("F"));
item3.SubItems.Add(model.SE.ToString("F"));
string str3 = "";
if (model.SLV == 0.0)
{
str3 = "0%";
}
else if (((tag.DJZL == "s") && (model.SLV == 0.05)) && tag.HYSY)
{
str3 = "中外合作油气田";
}
else if (!((model.SLV != 0.015) || tag.HYSY))
{
str3 = model.SLV.ToString("0.0%");
}
else
{
str3 = model.SLV.ToString("0%");
}
item3.SubItems.Add(str3);
this.listView1.Items.Insert((index + 1) + num2, item3);
}
}
}
}
}
catch (Exception exception)
{
HandleException.HandleError(exception);
}
}
