/// <summary>
/// 获取对象模型
/// </summary>
/// <returns></returns>
private UfidaPMS.Models.Contract GetModel()
{
UfidaPMS.Models.Contract model = new Models.Contract();
model.contractdate = dtpCreateDate.Value;
model.contractno = tbContractNo.Text;
model.custmanager = cbCustManager.Text;
model.custname = cbCustName.Text;
model.department = cbDepartMent.Text;
model.remarks = tbRemarks.Text;
model.trade = cbTrade.Text;
model.SubContractList = new List <Models.SubContract>();
foreach (DataGridViewRow dgvr in dgvSubContractList.Rows)
{
SubContract s = new SubContract();
s.contractamount = Convert.ToInt32(dgvr.Cells["contractamount"].Value);
s.contractid = "";
s.makecondition = dgvr.Cells["makecondition"].Value.ToString();
try
{
s.productversion = dgvr.Cells["productversion"].Value.ToString();
}
catch
{
s.productversion = "";
}
s.subcontractid = "";
s.subcontractno = dgvr.Cells["SubContractNo"].Value.ToString();
s.subcontracttype = dgvr.Cells["ContractType"].Value.ToString();
model.SubContractList.Add(s);
}
return(model);
}
public ActionResult Save(SubcontractViewModel model)
{
var place = _context.SiteAdmin.SingleOrDefault(m => m.PlaceName == model.PlaceName);
if (place == null)
{
var viewmodel = new SubcontractViewModel()
{
SubContractId = 0,
ErrorMessage = "Please Select a place name from Drop down",
Isvalid = false,
PlaceName = "",
SubContractorName = "",
};
return(View("AddSub", viewmodel));
}
var add = new SubContract()
{
PlaceId = (int)place.Placeid,
SubContractId = model.SubContractId,
SubContractorName = model.SubContractorName
};
_context.Sub.Add(add);
_context.SaveChanges();
return(RedirectToAction("Index", "SubContractor"));
}
public void Post(int contractId)
{
var subContract = new SubContract(1, "1", DateTime.Today.AddDays(1), DateTime.Today.AddDays(1));
_db.SubContracts.Add(subContract);
_db.SaveChanges();
}
public void Create(SubContract subContract)
{
var maxRequestNumber = 0;
var jobID = subContract.JobID;
var ets = _db.SubContracts.Where(x => x.JobID == jobID).ToList();
if (ets.Count > 0)
{
foreach (var et in ets)
{
if (et.RequestNumber > maxRequestNumber)
{
maxRequestNumber = et.RequestNumber;
}
}
}
subContract.RequestNumber = maxRequestNumber + 1;
_db.SubContracts.Add(subContract);
try
{
//Check Validation Errors
var error = _db.GetValidationErrors();
_db.SaveChanges();
NewlyInsertedID = subContract.SubcontractID;
}
catch (DbEntityValidationException dbEx)
{
var s = dbEx.Message;
}
}
/// <summary>
/// 保存分包合同点击事件
/// 2017/04/11(ZhuGuanJun)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSaveContrat_Click(object sender, EventArgs e)
{
#region 检查
if (string.IsNullOrEmpty(ProjectId))
{
MessageHelper.ShowMsg(MessageID.W000000002, MessageType.Alert, "项目");
return;
}
//if (string.IsNullOrEmpty(txtA_No.Text))
//{
// MessageHelper.ShowMsg(MessageID.W000000001, MessageType.Alert, "主合同编号");
// return;
//}
//if (string.IsNullOrEmpty(txtA_Name.Text))
//{
// MessageHelper.ShowMsg(MessageID.W000000001, MessageType.Alert, "主合同名称");
// return;
//}
//if (string.IsNullOrEmpty(txtB_No.Text))
//{
// MessageHelper.ShowMsg(MessageID.W000000001, MessageType.Alert, "分包合同编号");
// return;
//}
if (string.IsNullOrEmpty(txtB_Name.Text))
{
MessageHelper.ShowMsg(MessageID.W000000001, MessageType.Alert, "分包合同名称");
return;
}
#endregion
#region 分包合同信息
SubContract entity = new SubContract();
entity.Desc = txtDesc.Text.ToString();
entity.Amount = txtAmount.Text.ToString();
entity.A_Name = txtA_Name.Text;
entity.A_No = txtA_No.Text;
entity.B_Name = txtB_Name.Text;
entity.B_No = txtB_No.Text;
entity.CompanyName = (ComboItem)cmbCompanyName.SelectedItem != null ? ((ComboItem)cmbCompanyName.SelectedItem).Value.ToString() : "";
entity.PID = ProjectId;
entity.SignDate = dtiSignDate.Value;
entity.ID = _id;
#endregion
JsonResult json = bll.SaveSubContract(entity, dicFile, out _id);
MessageHelper.ShowRstMsg(json.result);
if (json.result)
{
SubID = (string)json.data;//版本
}
DataBind();
}
/// <summary>
/// 获取分包合同信息、附件信息、里程碑信息、付款信息
/// 2017/04/13
/// </summary>
/// <param name="SubID">分包合同主表ID(版本id)</param>
/// <param name="subContract">返回合同信息</param>
/// <param name="files">返回附件集合</param>
/// <param name="LCB">返回里程碑集合</param>
/// <param name="SKXX">返回付款信息集合</param>
public void GetSubContractAll(string SubID, out SubContract subContract, out DataTable files, out DataTable LCB, out DataTable SKXX)
{
StringBuilder sqlSub = new StringBuilder();
StringBuilder sqlFile = new StringBuilder();
StringBuilder sqlLCB = new StringBuilder();
StringBuilder sqlSKXX = new StringBuilder();
List <QueryField> qlist = new List <QueryField>();
qlist.Add(new QueryField()
{
Name = "Status", Type = QueryFieldType.Numeric, Value = 1
});
qlist.Add(new QueryField()
{
Name = "SubID", Type = QueryFieldType.String, Value = SubID
});
#region 分包合同
sqlSub.Append(" select * from SubContract s");
//sqlSub.Append(" where Status=@status and substr(s.Id,1,37)||'1'=@SubID");
sqlSub.Append(" where Status=@status and substr(s.Id,1,36)=@SubID");
sqlSub.Append(" order by s.CREATED");
DataTable Sub = NHHelper.ExecuteDataTable(sqlSub.ToString(), qlist);
subContract = Sub == null ? new SubContract() : JsonHelper.TableToEntity <SubContract>(Sub);
#endregion
#region 附件
sqlFile.Append(" select * from SubContractFiles");
sqlFile.Append(" where SubID=@SubID and Status=@Status");
sqlFile.Append(" order by s.CREATED");
files = NHHelper.ExecuteDataTable(sqlFile.ToString(), qlist);
#endregion
#region 里程碑
sqlLCB.Append(" select s.*,d1.Name as FinishStatusName from SubContractLCB s");
sqlLCB.Append(" left join DictItem d1 on s.FinishStatus = d1.No and d1.DictNo=" + (int)DictCategory.Milestones_FinshStatus);
sqlLCB.Append(" where s.SubID=@SubID and s.Status=@Status");
sqlLCB.Append(" order by s.CREATED");
LCB = NHHelper.ExecuteDataTable(sqlLCB.ToString(), qlist);
#endregion
#region 收款信息
//sqlSKXX.Append(" select s.*,d1.Name as FinishStatusName,d2.Name as BatchNoName from SubContractSKXX s");
sqlSKXX.Append(" select s.*,d1.Name as FinishStatusName from SubContractSKXX s");
sqlSKXX.Append(" left join DictItem d1 on s.FinishStatus = d1.No and d1.DictNo=" + (int)DictCategory.Receivables_FinshStatus);
//sqlSKXX.Append(" left join DictItem d2 on s.BatchNo = d2.No and d2.DictNo=" + (int)DictCategory.Receivables_BatchNo);
sqlSKXX.Append(" where SubID=@SubID and Status=@Status");
sqlSKXX.Append(" order by s.CREATED");
SKXX = NHHelper.ExecuteDataTable(sqlSKXX.ToString(), qlist);
#endregion
}
/// <summary>
/// 分包合同点击事件
/// 2017/04/13(zhuguanjun)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void superGridControl3_RowClick(object sender, GridRowClickEventArgs e)
{
var rows = superGridControl3.PrimaryGrid.GetSelectedRows();
if (rows.Count != 1)
{
MessageBox.Show("请选择一行");
superGridControl1.PrimaryGrid.ClearSelectedColumns();
return;
}
btnClearSKXX_Click(null, null);
btnClearLCB_Click(null, null);
GridRow row = (GridRow)rows[0];
SubContract Sub = new SubContract();
DataTable file = new DataTable();
DataTable lcb = new DataTable();
DataTable skxx = new DataTable();
SubContract sub = new SubContract();
bll.GetSubContractAll(row.Cells["ID"].Value.ToString().Substring(0, 36), out sub, out file, out lcb, out skxx);
#region 合同信息
txtA_Name.Text = sub.A_Name;
txtAmount.Text = sub.Amount;
txtA_No.Text = sub.A_No;
txtB_Name.Text = sub.B_Name;
txtB_No.Text = sub.B_No;
cmbCompanyName.SelectedIndex = -1;
DataHelper.SetComboBoxSelectItemByValue(cmbCompanyName, sub.CompanyName);
//DataHelper.SetComboBoxSelectItemByValue(cmbCompanyName, sub.CompanyName);
txtDesc.Text = sub.Desc;
dtiSignDate.Value = sub.SignDate.Value;
CREATED = sub.CREATED;
_id = sub.ID; //实际id
SubID = sub.ID.Substring(0, 36); //版本id
#endregion
//附件信息
LoadFile();
LoadFileList();
#region 里程碑信息
superGridControl1.PrimaryGrid.DataSource = lcb;
#endregion
#region 收款信息
superGridControl2.PrimaryGrid.DataSource = skxx;
#endregion
}
protected void DataContent()
{
string database = Session["DatabaseName"].ToString();
string vsSql = "";
//Stopwatch stopwatch = new Stopwatch();
//stopwatch.Start();
string ListStr1 = @"<tr> <td class=""auto-style103"">
<a href=""{4}"" target=_blank ><img src="" ../img/Edit.png"" alt=""檢視單價分析"" style=""Width:27px"" ></a>
</td><td class=""auto-style105"">
<asp:Label ID=""Label738"" runat=""server"" Font-Names=""微軟正黑體"" Font-Size=""Medium"" >{2}</asp:Label>
</td><td class=""auto-style105"">
<asp:Label ID=""Label736"" runat=""server"" Font-Size=""Medium"" Height=""25px"">{0}</asp:Label>
</td><td class=""auto-style103"">
<asp:Label ID=""Label737"" runat=""server"" Font-Size=""Medium"" Height=""25px"" Width=""50px"">{1}</asp:Label>
</td> <td class=""auto-style106"">{3}</td>";
string selectedValue = "";
StringBuilder tmpStr1 = new StringBuilder();
var totalcount1 = CheckBoxList1.Items.Cast <ListItem>().Where(item => item.Selected).Count(); //CheckBoxList1被選擇之數量(欄位選擇)
var totalcount2 = CheckBoxList2.Items.Cast <ListItem>().Where(item => item.Selected).Count(); //CheckBoxList2被選擇之數量(變更次別)
int max = 0;
foreach (ListItem item1 in CheckBoxList1.Items)
{
if (item1.Selected == true)
{
selectedValue += item1.Value + ",";
if (max < int.Parse(item1.Value))
{
max = int.Parse(item1.Value);
}
}
}
DataTable vsDt = new DataTable();
vsSql = @"Select * From SubContract_Item Where SCID=" + SCID.Text + "";
vsDt = WebModel.LoadSetContentData(database, vsSql);
//vsDt.Columns.Add("BKID");
vsDt.Columns.Add("ChNumber" + LbLastEdition.Text);
DataRow DtRow;
ViewState["DtVs"] = vsDt;
if (ViewState["Dtvs_c"] != "" && ViewState["Dtvs_c"] != null)
{
DataTable Vsdt1 = (DataTable)ViewState["Dtvs_c"];
for (int i = 0; i < Vsdt1.Rows.Count; i++)
{
DataRow row = Vsdt1.Rows[i];
if (Vsdt1.Rows[i]["SC_MID"].ToString() == "0")
{
DtRow = vsDt.NewRow();
//DtRow["BKID"] = Vsdt1.Rows[i]["BKID"].ToString();
DtRow["SC_MID"] = Vsdt1.Rows[i]["SC_MID"].ToString();
DtRow["SCID"] = Vsdt1.Rows[i]["SCID"].ToString();
DtRow["ItemName"] = Vsdt1.Rows[i]["ItemName"].ToString();
DtRow["Unit"] = Vsdt1.Rows[i]["Unit"].ToString();
DtRow["BelongEWID"] = Vsdt1.Rows[i]["BelongEWID"].ToString() != "" ? Vsdt1.Rows[i]["BelongEWID"].ToString() : "0";
DtRow["BelongItem"] = Vsdt1.Rows[i]["BelongItem"].ToString();
DtRow["SCNumber"] = Vsdt1.Rows[i]["SCNumber"].ToString() != "" ? Vsdt1.Rows[i]["SCNumber"].ToString() : "0";
DtRow["ChNumber" + LbLastEdition.Text] = Vsdt1.Rows[i]["ChNumber" + LbLastEdition.Text].ToString();
DtRow["UnitPrice"] = Vsdt1.Rows[i]["UnitPrice"].ToString();
DtRow["ComplexPrice"] = Vsdt1.Rows[i]["ComplexPrice"].ToString() != "" ? decimal.Parse(Vsdt1.Rows[i]["ComplexPrice"].ToString()) : 0;
DtRow["LastComplexPrice"] = Vsdt1.Rows[i]["LastComplexPrice"].ToString() != "" ? decimal.Parse(Vsdt1.Rows[i]["LastComplexPrice"].ToString()) : 0;
DtRow["LastEdition"] = Vsdt1.Rows[i]["LastEdition"].ToString() != "" ? decimal.Parse(Vsdt1.Rows[i]["LastEdition"].ToString()) : 0;
DtRow["Note"] = Vsdt1.Rows[i]["Note"].ToString();
vsDt.Rows.Add(DtRow);
}
else
{
vsDt.Rows[i]["ChNumber" + LbLastEdition.Text] = row["ChNumber" + LbLastEdition.Text].ToString();
//DataTableBox.Rows[j]["Note" + DataName + ""] = Note;
}
}
//vsDt =(DataTable) ViewState["Dtvs_c"];
ViewState["DtVs"] = vsDt;
//Vsdt1.Clear();
}
//SubContract_Change追加預算的版次
DataTable Addvalue = SubContract.LoadContentData_CB(database, SCID.Text, selectedValue);
//DataRow DataTableDr = Addvalue.Rows.;
DataRow DataTableDr;
if (Addvalue.Rows.Count > 0)
{
if (Addvalue.Rows.Count < vsDt.Rows.Count)
{
int num = vsDt.Rows.Count - Addvalue.Rows.Count;
for (int j = Addvalue.Rows.Count; j < vsDt.Rows.Count; j++)
{
//DataTableDr = Addvalue.Rows[j];
DataTableDr = Addvalue.NewRow();
Addvalue.Columns["SCID"].AllowDBNull = true;
Addvalue.Columns["LastEdition"].AllowDBNull = true;
DataTableDr["SCID"] = SCID.Text;
DataTableDr["UnitPrice"] = vsDt.Rows[j]["UnitPrice"].ToString();
if (max == int.Parse(LbLastEdition.Text))
{
DataTableDr["ChNumber" + LbLastEdition.Text] = vsDt.Rows[j]["ChNumber" + LbLastEdition.Text].ToString();
}
//Addvalue.Columns.Add("ChNumber" + LbLastEdition.Text);vsDr["SCNumber" + LbLastEdition.Text];
Addvalue.Rows.Add(DataTableDr);
}
}
}
if (vsDt.Rows.Count > 0)
{
for (int i = 0; i < vsDt.Rows.Count; i++)
{
DataRow vsDr = vsDt.Rows[i];
//string BKID = vsDr["BKID"].ToString();
string SC_MID = vsDr["SC_MID"].ToString();
string ItemName = vsDr["ItemName"].ToString();
string Unit = vsDr["Unit"].ToString();
string BelongItem = vsDr["BelongItem"].ToString();
string BelongEWID = vsDr["BelongEWID"].ToString();
string UnitPrice = vsDr["UnitPrice"].ToString();
string SCNumber = vsDr["SCNumber"].ToString() != "" ? vsDr["SCNumber"].ToString() : "0";
string ComplexPrice = "";
if (vsDr["ComplexPrice"].ToString() != "")
{
ComplexPrice = decimal.Parse(vsDr["ComplexPrice"].ToString()).ToString("N0");
}
else if (vsDr["ComplexPrice"].ToString() == "")
{
ComplexPrice = (decimal.Parse(UnitPrice) * decimal.Parse(SCNumber)).ToString("N0");
}
string Note = vsDr["Note"].ToString();
string Link = "SubChangeDetail.aspx?EWID=" + BelongEWID + "&SC_MID=" + SC_MID + "&edition=" + LbLastEdition.Text;
tmpStr1.AppendLine(string.Format(ListStr1, ItemName, Unit, BelongItem, UnitPrice, Link));
foreach (ListItem item in CheckBoxList1.Items)
{
if (item.Selected == true)
{
if (item.Value == "0")
{
if (CheckBoxList2.Items[0].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", SCNumber));
}
if (CheckBoxList2.Items[1].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", ComplexPrice));
}
if (CheckBoxList2.Items[2].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", Note));
}
}
else if (Addvalue.Rows.Count > 0)
{
DataTableDr = Addvalue.Rows[i];
string SCNumber1 = "ChNumber" + LbLastEdition.Text + "";
if (vsDt.Columns[SCNumber1] != null && Addvalue.Columns["ChNumber" + LbLastEdition.Text] != null)
{
vsDt.Columns["LastEdition"].AllowDBNull = true;
//Addvalue.Rows[i]["ChNumber" + LbLastEdition.Text] = vsDt.Rows[i]["ChNumber" + LbLastEdition.Text].ToString();
//Addvalue.Rows[i]["LastEdition"] = vsDt.Rows[i]["LastEdition"].ToString();
if (vsDt.Rows[i]["ChNumber" + LbLastEdition.Text].ToString() != "")
{
Addvalue.Rows[i]["ChNumber" + LbLastEdition.Text] = vsDt.Rows[i]["ChNumber" + LbLastEdition.Text].ToString();
Addvalue.Rows[i]["LastEdition"] = vsDt.Rows[i]["LastEdition"].ToString();
}
if (Addvalue.Rows[i]["ChNumber" + LbLastEdition.Text] != "")
{
vsDt.Rows[i]["ChNumber" + LbLastEdition.Text] = Addvalue.Rows[i]["ChNumber" + LbLastEdition.Text].ToString();
vsDt.Rows[i]["LastEdition"] = Addvalue.Rows[i]["LastEdition"];
}
}
//vsDr = Addvalue.Rows[i];
string LbUnitPrice = DataTableDr["UnitPrice"].ToString() != "" ? DataTableDr["UnitPrice"].ToString() : "0";
string LbChNumber = DataTableDr["ChNumber" + item.Value + ""].ToString() != "" ? DataTableDr["ChNumber" + item.Value + ""].ToString() : "0";
string LbNote = DataTableDr["Note" + item.Value + ""].ToString();
string LbEComplex = (decimal.Parse(LbChNumber) * decimal.Parse(LbUnitPrice)).ToString("N0");
if (CheckBoxList2.Items[0].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", LbChNumber));
}
if (CheckBoxList2.Items[1].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", LbEComplex));
}
if (CheckBoxList2.Items[2].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", LbNote));
}
}
}
}
}
tmpStr1.AppendLine(string.Format("</tr>"));
}
ViewState["DtVs"] = vsDt;
Literal2.Text = tmpStr1.ToString();
//stopwatch.Stop();
//Console.WriteLine("Time elapsed: {0}", stopwatch.Elapsed);
//}
}
/// <summary>
/// 保存分包信息
/// 2017/04/13(zhuguanjun)
/// </summary>
/// <param name="entity">分包信息</param>
/// <param name="dicFile">上传文件集合</param>
/// <param name="_id"></param>
/// <returns></returns>
public JsonResult SaveSubContract(SubContract entity, Dictionary <int, string> dicFile, out string _id)
{
_id = string.Empty; //实际id
string SubID = string.Empty; //版本id
ISession s = NHHelper.GetCurrentSession();
try
{
s.BeginTransaction();
#region 保存分包信息
if (string.IsNullOrEmpty(entity.ID))
{
if (entity.Status == null)
{
entity.Status = 1;
}
entity.ID = Guid.NewGuid().ToString() + "-1";
entity.CREATED = DateTime.Now;
SubID = entity.ID; //原始版本id
_id = entity.ID; //实际id
s.Save(entity);
}
else
{
SubContract old = new Repository <SubContract>().Get(entity.ID);
old.UPDATED = DateTime.Now;
old.Status = 0;
s.Update(old);
string hisNo = entity.ID.Substring(37);
entity.ID = entity.ID.Substring(0, 36) + "-" + (int.Parse(hisNo) + 1).ToString();
_id = entity.ID; //实际id
SubID = entity.ID.Substring(0, 36) + "-1"; //原始版本id
entity.Status = 1;
entity.CREATED = old.CREATED;
s.Save(entity);
}
#endregion
#region 保存上传的附件信息
foreach (var item in dicFile)
{
SubContractFiles file = new SubContractFiles();
switch (item.Key)
{
case 1:
file.Name = "合同扫描件";
break;
case 2:
file.Name = "合同电子档";
break;
case 3:
file.Name = "工作说明书扫描件";
break;
case 4:
file.Name = "工作说明书电子档";
break;
case 5:
file.Name = "其他";
break;
}
file.Path = item.Value;
file.SubID = SubID;
file.Type = item.Key;
List <QueryField> qlist = new List <QueryField>();
qlist.Add(new QueryField()
{
Name = "SubID", Type = QueryFieldType.String, Value = SubID
}); //版本id
qlist.Add(new QueryField()
{
Name = "Status", Type = QueryFieldType.Numeric, Value = 1
});
qlist.Add(new QueryField()
{
Name = "Type", Type = QueryFieldType.Numeric, Value = item.Key
}); //附件类型
SubContractFiles old = new Repository <SubContractFiles>().FindSingle(qlist);
if (old != null && !string.IsNullOrEmpty(old.ID))
{
old.Path = file.Path;
old.UPDATED = DateTime.Now;
s.Update(old);
}
else
{
file.CREATED = DateTime.Now;
file.ID = Guid.NewGuid().ToString();
file.Status = 1;
s.Save(file);
}
}
#endregion
s.Transaction.Commit();
s.Close();
return(new JsonResult {
result = true, msg = "保存成功", data = SubID
});
}
catch (Exception ex)
{
s.Transaction.Rollback();
s.Close();
throw new Exception("保存实体失败", ex);
}
}
protected void DataContent()
{
string database = Session["DatabaseName"].ToString();
string vsSql = "";
//Stopwatch stopwatch = new Stopwatch();
//stopwatch.Start();
string ListStr1 = @"<tr><td class=""auto-style105"">
<asp:Label ID=""Label738"" runat=""server"" Font-Names=""微軟正黑體"" Font-Size=""Medium"" >{2}</asp:Label>
</td><td class=""auto-style105"">
<asp:Label ID=""Label736"" runat=""server"" Font-Size=""Medium"" Height=""25px"">{0}</asp:Label>
</td><td class=""auto-style103"">
<asp:Label ID=""Label737"" runat=""server"" Font-Size=""Medium"" Height=""25px"" Width=""50px"">{1}</asp:Label>
</td> <td class=""auto-style106"">{3}</td>";
string selectedValue = "";
StringBuilder tmpStr1 = new StringBuilder();
var totalcount1 = CheckBoxList1.Items.Cast <ListItem>().Where(item => item.Selected).Count(); //CheckBoxList1被選擇之數量(欄位選擇)
var totalcount2 = CheckBoxList2.Items.Cast <ListItem>().Where(item => item.Selected).Count(); //CheckBoxList2被選擇之數量(變更次別)
foreach (ListItem item1 in CheckBoxList1.Items)
{
if (item1.Selected == true)
{
selectedValue += item1.Value + ",";
}
}
DataTable vsDt = new DataTable();
vsSql = @"Select * From SubContract_Item Where SCID=" + LbSCID.Text + "";
vsDt = WebModel.LoadSetContentData(database, vsSql);
if (vsDt.Rows.Count > 0)
{
for (int i = 0; i < vsDt.Rows.Count; i++)
{
DataRow vsDr = vsDt.Rows[i];
string SC_MID = vsDr["SC_MID"].ToString();
string ItemName = vsDr["ItemName"].ToString();
string Unit = vsDr["Unit"].ToString();
string BelongItem = vsDr["BelongItem"].ToString();
string UnitPrice = vsDr["UnitPrice"].ToString();
string SCNumber = vsDr["SCNumber"].ToString() != "" ? vsDr["SCNumber"].ToString() : "0";
string ComplexPrice = vsDr["ComplexPrice"].ToString() != "" ? decimal.Parse(vsDr["ComplexPrice"].ToString()).ToString("N0") : "0";
string Note = vsDr["Note"].ToString();
tmpStr1.AppendLine(string.Format(ListStr1, ItemName, Unit, BelongItem, UnitPrice));
foreach (ListItem item in CheckBoxList1.Items)
{
if (item.Selected == true)
{
if (item.Value == "0")
{
if (CheckBoxList2.Items[0].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", SCNumber));
}
if (CheckBoxList2.Items[1].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", ComplexPrice));
}
if (CheckBoxList2.Items[2].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", Note));
}
}
else
{
DataTable Addvalue = SubContract.LoadContentData_CB(database, LbSCID.Text, selectedValue);
if (Addvalue.Rows.Count > 0)
{
DataRow vsDr1 = Addvalue.Rows[i];
string LbUnitPrice = vsDr1["UnitPrice"].ToString() != "" ? vsDr1["UnitPrice"].ToString() : "0";
string LbChNumber = vsDr1["ChNumber" + item.Value + ""].ToString() != "" ? vsDr1["ChNumber" + item.Value + ""].ToString() : "0";
string LbNote = vsDr1["Note" + item.Value + ""].ToString();
string LbEComplex = (decimal.Parse(LbChNumber) * decimal.Parse(LbUnitPrice)).ToString("N0");
if (CheckBoxList2.Items[0].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", LbChNumber));
}
if (CheckBoxList2.Items[1].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", LbEComplex));
}
if (CheckBoxList2.Items[2].Selected == true)
{
tmpStr1.AppendLine(string.Format("<td class=\"auto-style106\">{0}</td>", LbNote));
}
}
}
}
}
tmpStr1.AppendLine(string.Format("</tr>"));
}
Literal2.Text = tmpStr1.ToString();
//stopwatch.Stop();
//Console.WriteLine("Time elapsed: {0}", stopwatch.Elapsed);
}
}
/// <summary>
/// 保存分包信息
/// 2017/04/12(zhuguanjun)
/// </summary>
/// <param name="contract"></param>
/// <param name="dicFile"></param>
/// <param name="_id"></param>
/// <returns></returns>
public JsonResult SaveSubContract(SubContract contract, Dictionary <int, string> dicFile, out string _id)
{
return(new ContractDao().SaveSubContract(contract, dicFile, out _id));
}
/// <summary>
/// 获取分包合同信息、附件信息、里程碑信息、付款信息
/// 2017/04/13
/// </summary>
/// <param name="id">分包合同主表ID</param>
/// <param name="subContract">返回合同信息</param>
/// <param name="files">返回附件集合</param>
/// <param name="LCB">返回里程碑集合</param>
/// <param name="SKXX">返回付款信息集合</param>
public void GetSubContractAll(string id, out SubContract subContract, out DataTable files, out DataTable LCB, out DataTable SKXX)
{
new ContractDao().GetSubContractAll(id, out subContract, out files, out LCB, out SKXX);
}
public MySubContract(int subcontractID)
{
_subcontractID = subcontractID;
Value = _db.SubContracts.Find(_subcontractID);
}
