private ArrayList BitumenDetachSql(bitumenExpenditureClass info, DataTable tempDetachDt)
{
CostCountDB costCountDB = new CostCountDB();
ArrayList sqlStr = new ArrayList();
double dSum = 0;
string sumMoney = info.money.ToString();
tempDetachDt.Columns.Add("比例");
for (int i = 0; i < tempDetachDt.Rows.Count; i++)
{
dSum += Double.Parse(tempDetachDt.Rows[i]["工时"].ToString());
}
for (int i = 0; i < tempDetachDt.Rows.Count; i++)
{
info.pId = tempDetachDt.Rows[i]["pId"].ToString();
info.eiId = tempDetachDt.Rows[i]["eiId"].ToString();
info.money = (StrtoDouble(sumMoney) * (StrtoDouble(tempDetachDt.Rows[i]["工时"].ToString()) / dSum)).ToString();
info.isFromDetach = "1";
sqlStr.Add(costCountDB.insertExpenditure(info));
}
ArrayList fields = new ArrayList();
ArrayList values = new ArrayList();
ArrayList conds = new ArrayList();
fields.Add("isDetach");
values.Add("1");
conds.Add("id=" + info.id);
sqlStr.Add(costCountDB.UpdateTeble("bitumenWaitDetachExpenditure", fields, values, conds));
return(sqlStr);
}
// 向datatable中加行
// 向表中添加一行然后返回表用于放到逻辑层进行判断用以确定是存入费用表还是待摊费用表
private DataTable AddDateTable()
{
if ((!cmbEquipmentName.Text.Trim().Equals("")) && (!cmbEquipmentName.Text.Trim().Equals("")))
{
bitumenExpenditureClass info = new bitumenExpenditureClass();
info = GetValueExpenditure();
DataRow row = tempDataTable.NewRow();
ExpenditureToDataRow(info, ref row);
tempDataTable.Rows.Add(row);
}
else
{
bitumenWaitDetachExpenditureClass waitDetachInfo = new bitumenWaitDetachExpenditureClass();
waitDetachInfo = GetValueWaitDetachExpenditure();
DataRow row1 = tempDataTable.NewRow();
WaitDetachExpenditureToDataRow(waitDetachInfo, ref row1);
tempDataTable.Rows.Add(row1);
}
return(tempDataTable);
}
//窗体上的值装入实体类expenditureClass
private bitumenExpenditureClass GetValueExpenditure()
{
bitumenExpenditureClass recInfo = new bitumenExpenditureClass();
recInfo.ekId = cmbExpenditureSort.SelectedValue == null ? null : cmbExpenditureSort.SelectedValue.ToString();
recInfo.enId = cmbExpenditureName.SelectedValue == null ? null : cmbExpenditureName.SelectedValue.ToString();
recInfo.ecId = cmbExpenditureDetail.SelectedValue == null ? null : cmbExpenditureDetail.SelectedValue.ToString();
recInfo.eiId = cmbEquipmentName.SelectedValue == null ? null : cmbEquipmentName.SelectedValue.ToString();
recInfo.expenditureDepict = cmbExpenditureDepict.Text;
recInfo.year = cmbYear.Text;
recInfo.month = cmbMonth.Text;
recInfo.pId = cmbProductName.SelectedValue == null ? null : cmbProductName.SelectedValue.ToString();
recInfo.unitPrice = cmbExpenditureUnitPrice.Text;
recInfo.number = upDownExpenditureQuantity.Value.ToString();
recInfo.money = cmbExpenditureMoney.Text;
recInfo.inputDate = dateTimePicker1.Value.ToString();
recInfo.inputMan = "测试";
recInfo.convert = cmbConvertQuotiety.Text;
recInfo.remark = richTextRemark.Text;
return(recInfo);
}
/*
* 方法名称：ExpenditureToDataRow
* 方法功能描述：实体类信息转换为DataRow
* 参数:
*
*
* 创建人：付中华
* 创建时间：2009-03-25
*
* 修改人：
* 修改时间：
* 修改内容：
*
*/
public void ExpenditureToDataRow(bitumenExpenditureClass info, ref DataRow dr)
{
dr["id"] = info.id == null ? "" : info.id;
dr["ekId"] = info.ekId == null ? "" : info.ekId;
dr["enId"] = info.enId == null ? "" : info.enId;
dr["ecId"] = info.ecId == null ? "" : info.ecId;
dr["expenditureDepict"] = info.expenditureDepict == null ? "" : info.expenditureDepict;
dr["year"] = info.year == null ? "" : info.year;
dr["month"] = info.month == null ? "" : info.month;
dr["eiId"] = info.eiId == null ? "" : info.eiId;
dr["pId"] = info.pId == null ? "" : info.pId;
dr["number"] = info.number == null ? "" : info.number;
dr["unitPrice"] = info.unitPrice == null ? "" : info.unitPrice;
dr["money"] = info.money == null ? "" : info.money;
dr["inputDate"] = info.inputDate == null ? "" : info.inputDate;
dr["inputMan"] = info.inputMan == null ? "" : info.inputMan;
dr["convert"] = info.convert == null ? "" : info.convert;
dr["remark"] = info.remark == null ? "" : info.remark;
dr["费用类别"] = cmbExpenditureSort.Text;
dr["费用名称"] = cmbExpenditureName.Text;
dr["费用明细"] = cmbExpenditureDetail.Text;
dr["设备名称"] = cmbEquipmentName.Text;
dr["产品名称"] = cmbProductName.Text;
}
public bool ExBitumenDetachData(DataGridView grid, DataTable DetachDt, bool isSelected)
{
ArrayList sqlStr = new ArrayList();
if (isSelected == false)
{
for (int i = 0; i < grid.Rows.Count; i++)
{
//确定分配基数,分滩是否能确定设备
DataTable tempDetachDt = new DataTable();
tempDetachDt.Columns.Add("pId");
tempDetachDt.Columns.Add("设备编号");
tempDetachDt.Columns.Add("eiId");
tempDetachDt.Columns.Add("工时");
if (grid.Rows[i].Cells["eiId"].Value.ToString().Trim().Equals(""))
{
tempDetachDt = DetachDt;
}
else
{
for (int j1 = 0; j1 < DetachDt.Rows.Count; j1++)
{
if (DetachDt.Rows[j1]["eiId"].ToString().Trim().Equals(grid.Rows[i].Cells["eiId"].Value.ToString().Trim()))
{
DataRow row = tempDetachDt.NewRow();
row["pid"] = DetachDt.Rows[j1]["pid"].ToString();
row["设备编号"] = DetachDt.Rows[j1]["设备编号"].ToString();
row["eiId"] = DetachDt.Rows[j1]["eiId"].ToString();
row["工时"] = DetachDt.Rows[j1]["工时"].ToString();
tempDetachDt.Rows.Add(row);
}
}
}
///////////////////////////////////
bitumenExpenditureClass info = new bitumenExpenditureClass();
info.id = grid.Rows[i].Cells["Id"].Value.ToString();
info.ekId = grid.Rows[i].Cells["ekId"].Value.ToString();
info.enId = grid.Rows[i].Cells["enId"].Value.ToString();
info.ecId = grid.Rows[i].Cells["ecId"].Value.ToString();
info.expenditureDepict = grid.Rows[i].Cells["费用描述"].Value.ToString();
info.year = grid.Rows[i].Cells["年"].Value.ToString();
info.month = grid.Rows[i].Cells["月"].Value.ToString();
info.eiId = grid.Rows[i].Cells["eiId"].Value.ToString();
info.pId = grid.Rows[i].Cells["pId"].Value.ToString();
info.number = grid.Rows[i].Cells["数量"].Value.ToString();
info.unitPrice = grid.Rows[i].Cells["单价"].Value.ToString();
info.money = grid.Rows[i].Cells["金额"].Value.ToString();
info.inputDate = grid.Rows[i].Cells["录入时间"].Value.ToString();
info.inputMan = grid.Rows[i].Cells["录入人"].Value.ToString();
info.assessor = grid.Rows[i].Cells["审核人"].Value.ToString();
info.checkupMan = grid.Rows[i].Cells["审批人"].Value.ToString();
info.convert = grid.Rows[i].Cells["折算系数"].Value.ToString();
info.isAuto = grid.Rows[i].Cells["自动还是手工"].Value.ToString();
info.remark = grid.Rows[i].Cells["备注"].Value.ToString();
ArrayList list = BitumenDetachSql(info, tempDetachDt);
foreach (string s in list)
{
sqlStr.Add(s);
}
}
}
else
{
for (int i = 0; i < grid.Rows.Count; i++)
{
if ((grid.Rows[i].Cells["Column1"].Value != null) && (grid.Rows[i].Cells["Column1"].Value.Equals(true)))
//确定分配基数,分滩是否能确定设备
{
DataTable tempDetachDt = new DataTable();
tempDetachDt.Columns.Add("pId");
tempDetachDt.Columns.Add("设备编号");
tempDetachDt.Columns.Add("eiId");
tempDetachDt.Columns.Add("工时");
if (grid.Rows[i].Cells["eiId"].Value.ToString().Trim().Equals(""))
{
tempDetachDt = DetachDt;
}
else
{
for (int j1 = 0; j1 < DetachDt.Rows.Count; j1++)
{
if (DetachDt.Rows[j1]["eiId"].ToString().Trim().Equals(grid.Rows[i].Cells["eiId"].Value.ToString().Trim()))
{
DataRow row = tempDetachDt.NewRow();
row["pid"] = DetachDt.Rows[j1]["pid"].ToString();
row["设备编号"] = DetachDt.Rows[j1]["设备编号"].ToString();
row["eiId"] = DetachDt.Rows[j1]["eiId"].ToString();
row["工时"] = DetachDt.Rows[j1]["工时"].ToString();
tempDetachDt.Rows.Add(row);
}
}
}
///////////////////////////////////
bitumenExpenditureClass info = new bitumenExpenditureClass();
info.id = grid.Rows[i].Cells["Id"].Value.ToString();
info.ekId = grid.Rows[i].Cells["ekId"].Value.ToString();
info.enId = grid.Rows[i].Cells["enId"].Value.ToString();
info.ecId = grid.Rows[i].Cells["ecId"].Value.ToString();
info.expenditureDepict = grid.Rows[i].Cells["费用描述"].Value.ToString();
info.year = grid.Rows[i].Cells["年"].Value.ToString();
info.month = grid.Rows[i].Cells["月"].Value.ToString();
info.eiId = grid.Rows[i].Cells["eiId"].Value.ToString();
info.pId = grid.Rows[i].Cells["pId"].Value.ToString();
info.number = grid.Rows[i].Cells["数量"].Value.ToString();
info.unitPrice = grid.Rows[i].Cells["单价"].Value.ToString();
info.money = grid.Rows[i].Cells["金额"].Value.ToString();
info.inputDate = grid.Rows[i].Cells["录入时间"].Value.ToString();
info.inputMan = grid.Rows[i].Cells["录入人"].Value.ToString();
info.assessor = grid.Rows[i].Cells["审核人"].Value.ToString();
info.checkupMan = grid.Rows[i].Cells["审批人"].Value.ToString();
info.convert = grid.Rows[i].Cells["折算系数"].Value.ToString();
info.isAuto = grid.Rows[i].Cells["自动还是手工"].Value.ToString();
info.remark = grid.Rows[i].Cells["备注"].Value.ToString();
ArrayList list = BitumenDetachSql(info, tempDetachDt);
foreach (string s in list)
{
sqlStr.Add(s);
}
}
}
}
if (sqlStr.Count > 0)
{
if (sqlHelperObj.ExecuteTransaction(sqlStr))
{
return(true);
}
}
return(false);
}