public static void Add(ResourceTemp resTemp)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == resTemp.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_Task task = null;
if (resTemp.BudTask != null)
{
task = (from m in entities.Bud_Task
where m.TaskId == resTemp.BudTask.Id
select m).FirstOrDefault <Bud_Task>();
}
Res_ResourceTemp temp = new Res_ResourceTemp {
Id = Guid.NewGuid().ToString(),
Amount = resTemp.Amount,
PrjId = resTemp.PrjId,
Quantity = resTemp.Quantity,
UnitPrice = resTemp.UnitPrice,
ResourceCode = resTemp.ResourceCode,
ResourceName = resTemp.ResourceName,
Bud_Task = task,
Res_Resource = resource
};
entities.AddToRes_ResourceTemp(temp);
entities.SaveChanges();
}
}
public static void Add(ResourceTemp resTemp)
{
using (pm2Entities entities = new pm2Entities())
{
Res_Resource resource = (from m in entities.Res_Resource
where m.ResourceId == resTemp.ResourceId
select m).FirstOrDefault <Res_Resource>();
Bud_Task task = null;
if (resTemp.BudTask != null)
{
task = (from m in entities.Bud_Task
where m.TaskId == resTemp.BudTask.Id
select m).FirstOrDefault <Bud_Task>();
}
//null, resTemp.ResourceCode,
// ,[ResourceId]
//,[TaskId]
//,[ResourceCode]
// ,'{1}'-- < ResourceId, nvarchar(500),>
//,'{2}'-- < TaskId, nvarchar(500),>
//,'{3}'-- < ResourceCode, nvarchar(500),>
string strs = string.Format(@"INSERT INTO [Res_ResourceTemp]
([Id]
,[ResourceName]
,[UnitPrice]
,[Quantity]
,[Amount]
,[PrjId]
,[Brand]
,[Specification]
,[ModelNumber])
VALUES
('{0}'--<Id, nvarchar(500),>
,'{1}'--<ResourceName, nvarchar(1000),>
,{2}--<UnitPrice, decimal(18,3),>
,{3}--<Quantity, decimal(18,3),>
,{4}--<Amount, decimal(18,3),>
,'{5}'--<PrjId, nvarchar(500),>
,'{6}'--<Brand, nvarchar(500),>
,'{7}'--<Specification, nvarchar(500),>
,'{8}'--<ModelNumber, nvarchar(500),>
)" , Guid.NewGuid().ToString(), resTemp.ResourceName, resTemp.UnitPrice, resTemp.Quantity, resTemp.Amount, resTemp.PrjId, resTemp.Brand, resTemp.Specification, resTemp.ModelNumber);
//Res_ResourceTemp temp = new Res_ResourceTemp {
// Id = Guid.NewGuid().ToString(),
// Amount = resTemp.Amount,
// PrjId = resTemp.PrjId,
// Quantity = resTemp.Quantity,
// UnitPrice = resTemp.UnitPrice,
// ResourceCode = resTemp.ResourceCode,
// ResourceName = resTemp.ResourceName,
// Bud_Task = task,
// Res_Resource = resource,
// Brand = resTemp.Brand,
// Specification = resTemp.Specification,
// ModelNumber = resTemp.ModelNumber
//};
//entities.AddToRes_ResourceTemp(temp);
//entities.SaveChanges();
publicDbOpClass.ExecSqlString(strs);
}
}
private void AddDrop(DataTable dt, int sheetIndxe, GridView gv)
{
GridViewRow gridViewRow = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Normal);
Bud_Task bud_Task = new Bud_Task();
DataTable dataTable = new DataTable();
if (sheetIndxe == 0)
{
dataTable = bud_Task.GetDescription("Bud_ContractTask");
DataRow dataRow = dataTable.NewRow();
dataRow["name"] = "Rank";
dataRow["value"] = "级别";
dataTable.Rows.Add(dataRow);
DataRow dataRow2 = dataTable.NewRow();
dataRow2["name"] = "TaskCode";
dataRow2["value"] = "任务编码";
dataTable.Rows.Add(dataRow2);
DataRow dataRow3 = dataTable.NewRow();
dataRow3["name"] = "TaskName";
dataRow3["value"] = "任务名称";
dataTable.Rows.Add(dataRow3);
DataRow dataRow4 = dataTable.NewRow();
dataRow4["name"] = "Total";
dataRow4["value"] = "小计";
dataTable.Rows.Add(dataRow4);
DataRow dataRow5 = dataTable.NewRow();
dataRow5["name"] = "ConstructionPeriod";
dataRow5["value"] = "工期";
dataTable.Rows.Add(dataRow5);
}
else
{
if (sheetIndxe == 1)
{
dataTable = bud_Task.GetResource();
DataRow dataRow6 = dataTable.NewRow();
dataRow6["name"] = "UnitPrice";
dataRow6["value"] = "单价";
dataTable.Rows.Add(dataRow6);
DataRow dataRow7 = dataTable.NewRow();
dataRow7["name"] = "Quantity";
dataRow7["value"] = "数量";
dataTable.Rows.Add(dataRow7);
DataRow dataRow8 = dataTable.NewRow();
dataRow8["name"] = "Amount";
dataRow8["value"] = "合计金额";
dataTable.Rows.Add(dataRow8);
DataRow dataRow9 = dataTable.NewRow();
dataRow9["name"] = "TaskCode";
dataRow9["value"] = "清单编码";
dataTable.Rows.Add(dataRow9);
}
}
DataRow dataRow10 = dataTable.NewRow();
dataRow10["name"] = "Invalid";
dataRow10["value"] = "无效列";
dataTable.Rows.Add(dataRow10);
DataRow dataRow11 = dataTable.NewRow();
dataRow11["name"] = "SerialNo";
dataRow11["value"] = "序号";
dataTable.Rows.Add(dataRow11);
DataRow dataRow12 = dataTable.NewRow();
dataRow12["value"] = "选择列";
dataTable.Rows.InsertAt(dataRow12, 0);
for (int i = 0; i < dt.Columns.Count + 2; i++)
{
TableCell tableCell = new TableCell();
tableCell.Attributes["align"] = "left";
tableCell.Attributes["colspan"] = "1";
DropDownList dropDownList = new DropDownList
{
ID = "drop" + sheetIndxe.ToString() + i,
DataSource = dataTable,
DataTextField = "value",
DataValueField = "name"
};
dropDownList.DataBind();
dropDownList.Items[0].Attributes["style"] = "color:Red";
if (sheetIndxe == 0)
{
dropDownList.Items[1].Text = dropDownList.Items[1].Text + "*";
dropDownList.Items[2].Text = dropDownList.Items[2].Text + "*";
dropDownList.Items[3].Text = dropDownList.Items[3].Text + "*";
}
else
{
if (sheetIndxe == 1)
{
dropDownList.Items[2].Text = dropDownList.Items[2].Text + "*";
dropDownList.Items[5].Text = dropDownList.Items[5].Text + "*";
dropDownList.Items[12].Text = dropDownList.Items[12].Text + "*";
dropDownList.Items[14].Text = dropDownList.Items[14].Text + "*";
dropDownList.Items[15].Text = dropDownList.Items[15].Text + "*";
dropDownList.Items[16].Text = dropDownList.Items[16].Text + "*";
dropDownList.Items[17].Text = dropDownList.Items[17].Text + "*";
}
}
if (i == 0 || i == 1)
{
dropDownList.Style.Add("display", "none");
}
if (i >= 2)
{
DataColumn dataColumn = dt.Columns[i - 2];
ListItem listItem = dropDownList.Items.FindByText(dataColumn.ColumnName.Trim());
if (listItem != null)
{
listItem.Selected = true;
}
else
{
listItem = dropDownList.Items.FindByText(dataColumn.ColumnName.Trim() + "*");
if (listItem != null)
{
listItem.Selected = true;
}
}
}
tableCell.Controls.Add(dropDownList);
gridViewRow.Cells.Add(tableCell);
this.SaveDropDownListState(sheetIndxe, i, dropDownList);
}
if (dt.Rows.Count > 0)
{
gv.Controls[0].Controls.AddAt(1, gridViewRow);
}
}
