/// <summary>
/// 确定设置
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButton1_Click(object sender, EventArgs e)
{
//确定时创建子目到清单
_Entity_SubInfo info = new _Entity_SubInfo();
DataRowView view = this.bindingSource1.Current as DataRowView;
ChangeDECJ(view);
if (view != null)
{
using (var calculator = new Calculator(CurrentBusiness, Activitie))
{
GLODSOFT.QDJJ.BUSINESS._Methods.SetSubheadingsInfo(info, view.Row, this.Activitie.Property.Libraries.FixedLibrary.FullName);
info.LB = "子目-降效";
_Mothods_MFixed fix = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, this.m_MFixed);
var createdMeasure = fix.Create(-1, info);
DataRow[] rows = this.Activitie.StructSource.ModelQuantity.Select(string.Format("ZMID={0} and SSLB={1}", info.ID, info.SSLB));
foreach (DataRow item in rows)
{
item["DEDJ"] = item["SCDJ"];
}
//fix.Calculate();
//var method = GLODSOFT.QDJJ.BUSINESS._Methods.CreateIntaceMet(this.CurrentBusiness, this.Activitie, createdMeasure);
//method.Calculate();
calculator.Entities.Add(info);
this.DialogResult = DialogResult.OK;
}
CurrentBusiness.FastCalculate();
}
}
private void CreateZJF(_Business m_Currentbus, _Entity_SubInfo item, DataRow row, Calculator calculator)
{
if (calculator == null)
{
calculator = new Calculator(m_Currentbus, Parent);
}
_SubSegmentsSource sorce = null;
GLODSOFT.QDJJ.BUSINESS._Methods_Fixed fix = null;
if (item.SSLB == 0)
{
sorce = this.Parent.StructSource.ModelSubSegments;
fix = new _Methods_Fixed(m_Currentbus, this.Parent, item);
}
else
{
sorce = this.Parent.StructSource.ModelMeasures;
fix = new _Mothods_MFixed(m_Currentbus, this.Parent, item);
}
DataRow[] rows = sorce.Select(string.Format("PID={0} and LB='子目-增加费'", item.ID));
if (IsEsixt(rows, row["Code"].ToString()))
{
List <_Entity_SubInfo> list = new List <_Entity_SubInfo>();
_Entity_SubInfo info = new _Entity_SubInfo();
info.OLDXMBM = row["Code"].ToString();
info.XMBM = row["Code"].ToString();
info.XMMC = row["Name"].ToString();
info.LB = "子目-增加费";
info.GCL = 1;
list.Add(info);
fix.Create(list);
calculator.Entities.Add(info);
}
fix.Begin(null);
calculator.Entities.Add(item);
}
/// <summary>
/// 确定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButton2_Click(object sender, EventArgs e)
{
DataRowView info0 = this.textEdit1.Tag as DataRowView;
if (info0 == null)
{
return;
}
_Entity_SubInfo info = new _Entity_SubInfo();
_ObjectSource.GetObject(info, info0.Row);
_Mothods_MFixed fix = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, info);
_Entity_SubInfo sinfo = new _Entity_SubInfo();
//_FixedListInfo info1 = null;
_Methods_Subheadings subfix = new _Methods_Subheadings(this.CurrentBusiness, this.Activitie, null);
if (info != null)
{
using (var calculator = new Calculator(CurrentBusiness, Activitie))
{
foreach (DataRowView item in this.bindingSource1)
{
_ObjectSource.GetObject(sinfo, item.Row);
// subfix.Current = sinfo;
// subfix.Begin();
var entity = fix.Create(-1, sinfo);
entity.BEIZHU = sinfo.BEIZHU;
DataRow[] rows1 = this.Activitie.StructSource.ModelQuantity.Select(string.Format("ZMID={0} and SSLB={1}", sinfo.ID, sinfo.SSLB));
for (int i = 0; i < rows1.Length; i++)
{
rows1[i].Delete();
}
DataRow[] rows = this.Activitie.StructSource.ModelQuantity.Select(string.Format("ZMID={0} and SSLB={1}", item["ID"], item["SSLB"]));
for (int i = 0; i < rows.Length; i++)
{
rows[i]["QDID"] = sinfo.PID;
rows[i]["ZMID"] = sinfo.ID;
rows[i]["SSLB"] = sinfo.SSLB;
}
//item["SC"] = false;
DataRow r = this.Activitie.StructSource.ModelSubSegments.GetRowByOther(item["ID"].ToString());
if (r != null)
{
_Entity_SubInfo sinfo1 = new _Entity_SubInfo();
_ObjectSource.GetObject(sinfo1, r);
subfix.Current = sinfo1;
subfix.Begin(null);
calculator.Entities.Add(sinfo1);
calculator.CalculateFinish += new EventHandler(delegate(object o, EventArgs handler)
{
r["SC"] = false;
});
}
}
calculator.Entities.Add(info);
}
this.Close();
}
}
/// <summary>
/// 特殊计算
/// </summary>
private void SpecialCalculate()
{
if (this.splitContainerControl1.PanelVisibility == SplitPanelVisibility.Both)
{
string m_deh = this.lblDEH.Text; //定额号
decimal m_tzl = Convert.ToDecimal(this.lblTZL.Text); //调整量
decimal m_jbl = Convert.ToDecimal(this.lblJBL.Text); //基本量
decimal m_sjz = Convert.ToDecimal(this.txtSJZ.Text); //实际值
if (m_sjz != m_jbl)
{
int xs = Math.Abs((int)((m_sjz - m_jbl) / m_tzl)); //（实际值-基本量） = 正整数倍数
decimal b = Math.Abs((m_sjz - m_jbl)); //（实际值-基本量）= 差数
decimal c = (xs * m_tzl); //（基本量*调整量） = 实际差数
decimal d = b - c; //（实际差数-差数）= 余数
if (d > 0 && d < m_jbl) //余数在调整量之间时进位
{
xs = xs + 1;
}
_SubSegmentsSource m_SubSegmentsSource = null;
if (this.m_Methods_Subheadings.Current.SSLB == 0)
{
m_SubSegmentsSource = this.Activitie.StructSource.ModelSubSegments;
}
else
{
m_SubSegmentsSource = this.Activitie.StructSource.ModelMeasures;
}
DataRow dr = m_SubSegmentsSource.GetRowByOther(this.m_Methods_Subheadings.Current.PID.ToString());
if (dr != null)
{
_Entity_SubInfo m_Entity_SubInfo = new _Entity_SubInfo();
_ObjectSource.GetObject(m_Entity_SubInfo, dr);
_Methods_Fixed m_Methods_Fixed = null;
if (m_Entity_SubInfo.SSLB.Equals(0))
{
m_Methods_Fixed = new _Methods_Fixed(this.CurrentBusiness, this.Activitie, m_Entity_SubInfo);
}
else
{
m_Methods_Fixed = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, m_Entity_SubInfo);
}
DataRow de_dr = this.Activitie.Property.Libraries.FixedLibrary.LibraryDataSet.Tables["定额表"].Select(string.Format("DINGEH='{0}'", m_deh)).FirstOrDefault();
if (de_dr != null)
{
_Entity_SubInfo m_ZM_Entity_SubInfo = new _Entity_SubInfo();
GLODSOFT.QDJJ.BUSINESS._Methods.SetSubheadingsInfo(m_ZM_Entity_SubInfo, de_dr, this.Activitie.Property.Libraries.FixedLibrary.FullName);
m_ZM_Entity_SubInfo.XMBM += " *" + xs + "";
m_Methods_Fixed.Create(this.m_Methods_Subheadings.Current.Sort, m_ZM_Entity_SubInfo);
this.m_IFHS = true;
}
}
//SubSegmentForm m_ParentForm = this.AParentForm as SubSegmentForm;
//if (m_ParentForm != null)
//{
// m_ParentForm.BindSubSegmentList();
//}
this.m_IFHS = true;
}
}
}
/// <summary>
/// 第一个石灰转换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit1_Click(object sender, EventArgs e)
{
if (radioGroup1.SelectedIndex == 1)
{
ArrayList m_ArrayList = this.GetAllSub(string.Format("ZCLB='W' AND YSBH IN({0})", _Constant.石灰转换定额范围));
DataRow new_info = GetSSH();
foreach (DataRow item in m_ArrayList)
{
decimal yxhl = 0m;
decimal xhl = 0m;
DataRow sshkg = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W'AND YSBH='10900'", item["SSLB"], item["ID"])).FirstOrDefault();
DataRow ssht = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W'AND YSBH='10901'", item["SSLB"], item["ID"])).FirstOrDefault();
if (sshkg != null)
{
yxhl += _ConvertUnit.Convert(sshkg["DW"].ToString(), "千克") * ToolKit.ParseDecimal(sshkg["XHL"]);
xhl += _ConvertUnit.Convert(sshkg["DW"].ToString(), "千克") * ToolKit.ParseDecimal(sshkg["XHL"]) * 1.3m;
sshkg.Delete();
}
if (ssht != null)
{
yxhl += _ConvertUnit.Convert(ssht["DW"].ToString(), "千克") * ToolKit.ParseDecimal(ssht["XHL"]);
xhl += _ConvertUnit.Convert(ssht["DW"].ToString(), "千克") * ToolKit.ParseDecimal(ssht["XHL"]) * 1.3m;
ssht.Delete();
}
new_info["YSXHL"] = xhl;
new_info["XHL"] = xhl;
new_info["CTIME"] = DateTime.Now;
new_info["SSLB"] = item["SSLB"];
new_info["EnID"] = item["EnID"];
new_info["UnID"] = item["UnID"];
new_info["ZMID"] = item["ID"];
new_info["QDID"] = item["PID"];
new_info["PID"] = DBNull.Value;
this.Activitie.StructSource.ModelQuantity.Add(new_info);
DataRow rg = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB='{0}' AND ZMID={1} AND LB='{2}'", item["SSLB"], item["ID"], "人工"), "YSBH").FirstOrDefault();
if (rg != null)
{
rg["XHL"] = ToolKit.ParseDecimal(rg["XHL"]) - (yxhl * 0.001m) * 0.478m;
}
DataRow sui = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB='{0}' AND ZMID={1} AND YSBH='{2}'", item["SSLB"], item["ID"], "11610"), "YSBH").FirstOrDefault();
if (sui != null)
{
sui["XHL"] = ToolKit.ParseDecimal(sui["XHL"]) - (yxhl * 0.001m) * 0.043m;
}
_Entity_SubInfo m_Entity_SubInfo = new _Entity_SubInfo();
_ObjectSource.GetObject(m_Entity_SubInfo, item);
_Methods_Subheadings m_Methods_Subheadings = new _Methods_Subheadings(this.CurrentBusiness, this.Activitie, m_Entity_SubInfo);
m_Methods_Subheadings.Begin(null);
}
MsgBox.Alert("【" + m_ArrayList.Count + "】条子目 生石灰-转换-熟石灰");
}
else
{
int m_index = 0;
ArrayList m_ArrayList = this.GetAllSub("ZCLB='W' AND YSBH='10905'");
foreach (DataRow item in m_ArrayList)
{
_Entity_SubInfo m_QD_Entity_SubInfo = null;
_Entity_SubInfo m_Entity_SubInfo = new _Entity_SubInfo();
_ObjectSource.GetObject(m_Entity_SubInfo, item);
if (m_Entity_SubInfo.SSLB == 0)
{
m_QD_Entity_SubInfo = new _Entity_SubInfo();
DataRow dr_qd = this.Activitie.StructSource.ModelSubSegments.GetRowByOther(m_Entity_SubInfo.PID.ToString());
if (dr_qd != null)
{
_ObjectSource.GetObject(m_QD_Entity_SubInfo, dr_qd);
_Methods_Fixed m_Methods_Fixed = new _Methods_Fixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
_Entity_SubInfo f_Entity_SubInfo = GetZMByID(m_Entity_SubInfo.OLDXMBM);
if (f_Entity_SubInfo != null)
{
item.Delete();
f_Entity_SubInfo.BEIZHU = GLODSOFT.QDJJ.BUSINESS._Methods.GetDEbeizhu("GCSZ", ++m_index, m_Methods_Fixed.Current.OLDXMBM);
m_Methods_Fixed.Create(m_Entity_SubInfo.Sort - 1, f_Entity_SubInfo);
}
}
}
else
{
m_QD_Entity_SubInfo = new _Entity_SubInfo();
DataRow dr_qd = this.Activitie.StructSource.ModelMeasures.GetRowByOther(m_Entity_SubInfo.PID.ToString());
if (dr_qd != null)
{
_ObjectSource.GetObject(m_QD_Entity_SubInfo, dr_qd);
_Mothods_MFixed m_Mothods_MFixed = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
_Entity_SubInfo c_Entity_SubInfo = GetZMByID(m_Entity_SubInfo.OLDXMBM);
if (c_Entity_SubInfo != null)
{
item.Delete();
c_Entity_SubInfo.BEIZHU = GLODSOFT.QDJJ.BUSINESS._Methods.GetDEbeizhu("GCSZ", ++m_index, m_Mothods_MFixed.Current.OLDXMBM);
m_Mothods_MFixed.Create(m_Entity_SubInfo.Sort - 1, c_Entity_SubInfo);
}
}
}
}
MsgBox.Alert("【" + m_ArrayList.Count + "】条子目 熟石灰-转换-生石灰");
}
}
/// <summary>
/// 第四个混凝土转换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit4_Click(object sender, EventArgs e)
{
int m_index = 0;
if (APP.Application.Global.DataTamp.工程设置.Tables.Count == 0)
{
return;
}
if (this.radioGroup4.SelectedIndex == 1)
{
//普通转换商品
DataRow[] deh_drs = APP.Application.Global.DataTamp.工程设置.Tables["混凝土转换"].Select("LB='定额编号'");
int count = 0;
using (var calculator = new Calculator(CurrentBusiness, Activitie))
{
foreach (DataRow deh_item in deh_drs)
{
_Entity_SubInfo m_QD_Entity_SubInfo = new _Entity_SubInfo();
_Methods_Fixed m_QD_Methods_Fixed = null;
ArrayList zm_ArrayList = this.GetAllHNTSub(deh_item["PTHNT"].ToString());
foreach (DataRow zm_item in zm_ArrayList)
{
_Entity_SubInfo new_Entity_SubInfo = null;
if (zm_item["SSLB"].Equals(0))
{
DataRow qd_dr = this.Activitie.StructSource.ModelSubSegments.GetRowByOther(zm_item["PID"].ToString());
_ObjectSource.GetObject(m_QD_Entity_SubInfo, qd_dr);
m_QD_Methods_Fixed = new _Methods_Fixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
new_Entity_SubInfo = this.GetZMByID(deh_item["SPHNT"].ToString());
}
else
{
DataRow qd_dr = this.Activitie.StructSource.ModelMeasures.GetRowByOther(zm_item["PID"].ToString());
_ObjectSource.GetObject(m_QD_Entity_SubInfo, qd_dr);
m_QD_Methods_Fixed = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
new_Entity_SubInfo = this.GetZMByID(deh_item["SPHNT"].ToString());
}
if (new_Entity_SubInfo != null)
{
DataRow[] phb_glj_drs = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W'", zm_item["SSLB"], zm_item["ID"]), "BH");
foreach (DataRow phb_glj_item in phb_glj_drs)
{
DataRow cl_dr = APP.Application.Global.DataTamp.工程设置.Tables["混凝土转换"].Select(string.Format("LB='材料' AND PTHNT='{0}'", phb_glj_item["YSBH"])).FirstOrDefault();
if (cl_dr != null)
{
string[] m_mrth = deh_item["MRZTH"].ToString().Split('|');
if (m_mrth.Length == 2)
{
if (!m_mrth[1].Equals(cl_dr["SPHNT"]))
{
new_Entity_SubInfo.XMBM += "换";
new_Entity_SubInfo.XMMC += "//换：" + m_mrth[1] + "," + cl_dr["SPHNT"];
}
new_Entity_SubInfo.DECJ = new_Entity_SubInfo.DECJ.Replace(m_mrth[1].ToString(), cl_dr["SPHNT"].ToString());
new_Entity_SubInfo.BEIZHU = GLODSOFT.QDJJ.BUSINESS._Methods.GetDEbeizhu("GCSZ", ++m_index, m_QD_Methods_Fixed.Current.OLDXMBM);
continue;
}
}
}
m_QD_Methods_Fixed.Create(ToolKit.ParseInt(zm_item["Sort"]) - 1, new_Entity_SubInfo);
new_Entity_SubInfo.GCL = (int)double.Parse(zm_item["GCL"].ToString());
new_Entity_SubInfo.HL = (int)double.Parse(zm_item["HL"].ToString());
this.Activitie.StructSource.ModelSubSegments.UpDate(new_Entity_SubInfo);
zm_item.Delete();
count++;
}
calculator.Entities.Add(new_Entity_SubInfo);
}
}
MsgBox.Alert("【" + count + "】条子目 （普通混凝土）转换（商品混凝土）成功");
}
}
else
{
DataTable hntzh = APP.Application.Global.DataTamp.工程设置.Tables["混凝土转换"];
if (hntzh == null)
{
return;
}
//商品转换普通
DataRow[] deh_drs = APP.Application.Global.DataTamp.工程设置.Tables["混凝土转换"].Select("LB='定额编号'");
int count = 0;
using (var calculator = new Calculator(CurrentBusiness, Activitie))
{
foreach (DataRow deh_item in deh_drs)
{
_Entity_SubInfo m_QD_Entity_SubInfo = new _Entity_SubInfo();
_Methods_Fixed m_QD_Methods_Fixed = null;
ArrayList zm_ArrayList = this.GetAllHNTSub(deh_item["SPHNT"].ToString());
foreach (DataRow zm_item in zm_ArrayList)
{
_Entity_SubInfo new_Entity_SubInfo = null;
if (zm_item["SSLB"].Equals(0))
{
DataRow qd_dr = this.Activitie.StructSource.ModelSubSegments.GetRowByOther(zm_item["PID"].ToString());
_ObjectSource.GetObject(m_QD_Entity_SubInfo, qd_dr);
m_QD_Methods_Fixed = new _Methods_Fixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
new_Entity_SubInfo = this.GetZMByID(deh_item["PTHNT"].ToString());
}
else
{
DataRow qd_dr = this.Activitie.StructSource.ModelMeasures.GetRowByOther(zm_item["PID"].ToString());
_ObjectSource.GetObject(m_QD_Entity_SubInfo, qd_dr);
m_QD_Methods_Fixed = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
new_Entity_SubInfo = this.GetZMByID(deh_item["PTHNT"].ToString());
}
if (new_Entity_SubInfo != null)
{
DataRow[] phb_glj_drs = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W'", zm_item["SSLB"], zm_item["ID"]), "BH");
foreach (DataRow phb_glj_item in phb_glj_drs)
{
DataRow cl_dr = APP.Application.Global.DataTamp.工程设置.Tables["混凝土转换"].Select(string.Format("LB='材料' AND SPHNT='{0}'", phb_glj_item["YSBH"])).FirstOrDefault();
if (cl_dr != null)
{
string[] m_mrth = deh_item["MRZTH"].ToString().Split('|');
if (m_mrth.Length == 2)
{
if (!m_mrth[0].Equals(cl_dr["PTHNT"]))
{
new_Entity_SubInfo.XMBM += "换";
new_Entity_SubInfo.XMMC += "//换：" + m_mrth[0] + "," + cl_dr["PTHNT"];
}
new_Entity_SubInfo.DECJ = new_Entity_SubInfo.DECJ.Replace(m_mrth[0].ToString(), cl_dr["PTHNT"].ToString());
new_Entity_SubInfo.BEIZHU = GLODSOFT.QDJJ.BUSINESS._Methods.GetDEbeizhu("GCSZ", ++m_index, m_QD_Methods_Fixed.Current.OLDXMBM);
continue;
}
}
}
var entity = m_QD_Methods_Fixed.Create(ToolKit.ParseInt(zm_item["Sort"]) - 1, new_Entity_SubInfo);
zm_item.Delete();
count++;
calculator.Entities.Add(entity);
}
}
}
}
MsgBox.Alert("【" + count + "】条子目 （商品混凝土）转换（普通混凝土）成功");
}
}
/// <summary>
/// 第三个模板应用
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit3_Click(object sender, EventArgs e)
{
if (radioGroup3.SelectedIndex == 1)
{
DataRow qd_dr = this.btnEdit1.Tag as DataRow;
if (qd_dr != null)
{
ArrayList m_ArrayList = this.GetAllMBSub();
if (m_ArrayList.Count > 0)
{
_Entity_SubInfo m_QD_Entity_SubInfo = new _Entity_SubInfo();
_ObjectSource.GetObject(m_QD_Entity_SubInfo, qd_dr);
_Mothods_MFixed m_Mothods_MFixed = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
_Entity_SubInfo m_ZM_Entity_SubInfo = new _Entity_SubInfo();
foreach (DataRow item in m_ArrayList)
{
item["SC"] = false;
_ObjectSource.GetObject(m_ZM_Entity_SubInfo, item);
m_ZM_Entity_SubInfo.SC = true;
m_Mothods_MFixed.Create(-1, m_ZM_Entity_SubInfo);
DataRow[] csxm_drs = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1}", m_ZM_Entity_SubInfo.SSLB, m_ZM_Entity_SubInfo.ID));
foreach (DataRow csxm_glj_item in csxm_drs)
{
csxm_glj_item.Delete();
}
DataRow[] fbfx_drs = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1}", item["SSLB"], item["ID"]));
foreach (DataRow fbfx_glj_item in fbfx_drs)
{
fbfx_glj_item["QDID"] = m_ZM_Entity_SubInfo.PID;
fbfx_glj_item["ZMID"] = m_ZM_Entity_SubInfo.ID;
fbfx_glj_item["SSLB"] = m_ZM_Entity_SubInfo.SSLB;
}
}
}
MsgBox.Alert("【" + m_ArrayList.Count + "】条子目 模板到措施成功");
}
}
else
{
DialogResult dl = MessageBox.Show("您确认将模板还原到分部分项？", "提示", MessageBoxButtons.YesNo);
if (dl == DialogResult.No)
{
return;
}
DataRow[] drs = this.Activitie.StructSource.ModelMeasures.Select("TX='模板'");
if (drs.Length > 0)
{
_Methods_Fixed m_Methods_Fixed = new _Methods_Fixed(this.CurrentBusiness, this.Activitie, null);
_Entity_SubInfo m_Entity_SubInfo = new _Entity_SubInfo();
foreach (DataRow item in drs)
{
_Entity_SubInfo info = null;
DataRow qd_dr = this.Activitie.StructSource.ModelSubSegments.GetRowByOther(item["QDBH"].ToString());
DataRow zm_dr = this.Activitie.StructSource.ModelSubSegments.Select(string.Format("QDBH='{0}' and XMBM='{1}'", item["QDBH"], item["XMBM"])).FirstOrDefault();
if (qd_dr != null)
{
info = new _Entity_SubInfo();
_ObjectSource.GetObject(info, qd_dr);
m_Methods_Fixed.Current = info;
}
if (info != null)
{
if (zm_dr == null)
{
m_Entity_SubInfo.SC = true;
_ObjectSource.GetObject(m_Entity_SubInfo, item);
m_Methods_Fixed.Create(-1, m_Entity_SubInfo);
DataRow[] fbfx_drs = this.Activitie.StructSource.ModelQuantity.Select(string.Format("ZMID={0} and SSLB={1}", m_Entity_SubInfo.ID, m_Entity_SubInfo.SSLB));
foreach (DataRow fbfx_glj_item in fbfx_drs)
{
fbfx_glj_item.Delete();
}
}
else
{
zm_dr["SC"] = true;
_ObjectSource.GetObject(m_Entity_SubInfo, zm_dr);
}
DataRow[] csxm_drs = this.Activitie.StructSource.ModelQuantity.Select(string.Format("ZMID={0} and SSLB={1}", item["ID"], item["SSLB"]));
foreach (DataRow csxm_drs_item in csxm_drs)
{
csxm_drs_item["QDID"] = m_Entity_SubInfo.PID;
csxm_drs_item["ZMID"] = m_Entity_SubInfo.ID;
csxm_drs_item["SSLB"] = m_Entity_SubInfo.SSLB;
}
}
item.Delete();
}
MsgBox.Alert("【" + drs.Length + "】条子目 模板到分部成功");
}
}
}
/// <summary>
/// 第二个砂浆转换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit2_Click(object sender, EventArgs e)
{
APP.UserPriceLibrary.AllQuantityUnit = this.Activitie.StructSource.ModelQuantity;
APP.UserPriceLibrary.UnName = this.Activitie.Name;
APP.UserPriceLibrary.Range = 1;
if (this.radioGroup2.SelectedIndex == 1)
{
ArrayList m_ArrayList = this.GetAllSub("ZCLB='W' AND YSBH='J06016' AND XHL <> 0");
int count = m_ArrayList.Count;
//抹灰工程
foreach (DataRow item in m_ArrayList)
{
DataRow[] mh = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W' AND YSBH IN({2})", item["SSLB"], item["ID"], _Constant.抹灰工程定额范围));
if (mh.Length > 0)
{
DataRow rg = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W' AND LB='人工'", item["SSLB"], item["ID"]), "YSBH").FirstOrDefault();
DataRow jx = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W' AND BH='J06016'", item["SSLB"], item["ID"]), "YSBH").FirstOrDefault();
decimal rgxhl = 0m;
foreach (DataRow dr in mh)
{
if (!dr["MC"].ToString().Contains("(预拌砂浆)"))
{
dr.BeginEdit();
dr["MC"] = dr["MC"].ToString() + "(预拌砂浆)";
APP.UserPriceLibrary.Update("MC", dr["MC", DataRowVersion.Current], dr);
dr.EndEdit();
}
}
//修改消耗量
foreach (DataRow mhs in mh)
{
rgxhl += ToolKit.ParseDecimal(mhs["XHL"]) * 1.1m * _ConvertUnit.Convert(mhs["DW"].ToString(), "立方米");
}
if (rg != null)
{
rg["XHL"] = ToolKit.ParseDecimal(rg["XHL"]) - rgxhl;
}
if (jx != null)
{
jx["XHL"] = 0m;
}
}
//砌筑工程
DataRow[] qz = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W' AND YSBH IN ({2}) ", item["SSLB"], item["ID"], _Constant.筑工程定额范围));
if (qz.Count() > 0)
{
DataRow rg = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W' AND LB='人工'", item["SSLB"], item["ID"]), "YSBH").FirstOrDefault();
DataRow jx = this.Activitie.StructSource.ModelQuantity.Select(string.Format("SSLB={0} AND ZMID={1} AND ZCLB='W' AND BH='J06016'", item["SSLB"], item["ID"]), "YSBH").FirstOrDefault();
decimal rgxhl = 0m;
//修改名称
DataRow dr = qz.FirstOrDefault();
if (dr != null)
{
if (!dr["MC"].ToString().Contains("(预拌砂浆)"))
{
dr.BeginEdit();
dr["MC"] = dr["MC"].ToString() + "(预拌砂浆)";
APP.UserPriceLibrary.Update("MC", dr["MC", DataRowVersion.Current], dr);
dr.EndEdit();
}
}
foreach (DataRow qzs in qz)
{
rgxhl += ToolKit.ParseDecimal(qzs["XHL"]) * 0.69m * _ConvertUnit.Convert(qzs["DW"].ToString(), "立方米");
}
if (rg != null)
{
rg["XHL"] = ToolKit.ParseDecimal(rg["XHL"]) - rgxhl;
}
if (jx != null)
{
jx["XHL"] = 0m;
}
}
string m_NewSubheadings = item["EnID"] + "," + item["UnID"] + "," + item["SSLB"] + "," + item["ID"] + "|";
if (!APP.UserPriceLibrary.SubheadingsInfo.Contains(m_NewSubheadings))
{
APP.UserPriceLibrary.SubheadingsInfo += m_NewSubheadings;
}
}
_Methods_Subheadings m_Methods_Subheadings = new _Methods_Subheadings(this.Activitie);
m_Methods_Subheadings.BatchCalculate();
MsgBox.Alert("【" + count + "】条子目 现场制拌砂浆-转换-预拌砂浆");
}
else
{
int m_index = 0;
ArrayList m_ArrayList = this.GetAllSub("ZCLB='W' AND YSBH='J06016' AND XHL=0");
foreach (DataRow item in m_ArrayList)
{
_Entity_SubInfo m_QD_Entity_SubInfo = null;
_Entity_SubInfo m_Entity_SubInfo = new _Entity_SubInfo();
_ObjectSource.GetObject(m_Entity_SubInfo, item);
if (m_Entity_SubInfo.SSLB == 0)
{
m_QD_Entity_SubInfo = new _Entity_SubInfo();
DataRow dr_qd = this.Activitie.StructSource.ModelSubSegments.GetRowByOther(m_Entity_SubInfo.PID.ToString());
if (dr_qd != null)
{
_ObjectSource.GetObject(m_QD_Entity_SubInfo, dr_qd);
_Methods_Fixed m_Methods_Fixed = new _Methods_Fixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
_Entity_SubInfo f_Entity_SubInfo = GetZMByID(m_Entity_SubInfo.OLDXMBM);
if (f_Entity_SubInfo != null)
{
item.Delete();
f_Entity_SubInfo.BEIZHU = GLODSOFT.QDJJ.BUSINESS._Methods.GetDEbeizhu("GCSZ", ++m_index, m_Methods_Fixed.Current.OLDXMBM);
m_Methods_Fixed.Create(m_Entity_SubInfo.Sort - 1, f_Entity_SubInfo);
}
}
}
else
{
m_QD_Entity_SubInfo = new _Entity_SubInfo();
DataRow dr_qd = this.Activitie.StructSource.ModelMeasures.GetRowByOther(m_Entity_SubInfo.PID.ToString());
if (dr_qd != null)
{
_ObjectSource.GetObject(m_QD_Entity_SubInfo, dr_qd);
_Mothods_MFixed m_Mothods_MFixed = new _Mothods_MFixed(this.CurrentBusiness, this.Activitie, m_QD_Entity_SubInfo);
_Entity_SubInfo c_Entity_SubInfo = GetZMByID(m_Entity_SubInfo.OLDXMBM);
if (c_Entity_SubInfo != null)
{
item.Delete();
c_Entity_SubInfo.BEIZHU = GLODSOFT.QDJJ.BUSINESS._Methods.GetDEbeizhu("GCSZ", ++m_index, m_Mothods_MFixed.Current.OLDXMBM);
m_Mothods_MFixed.Create(m_Entity_SubInfo.Sort - 1, c_Entity_SubInfo);
}
}
}
}
MsgBox.Alert("【" + m_ArrayList.Count + "】条子目 预拌砂浆-转换-现场制拌砂浆");
}
}