public bool SaveItem(Xm_GhsjYsxx itemGhys, List <Item_File> itemFile,
Xm_Xmzj itemZj, Xm_Gcxx itemGcxx, Xm_Xmdw itemDw)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////项目规划设计信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_GhsjYsxx>(CommonManage.delWhere(itemGhys.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemGhys));
////文件
new BusiItemManage().SaveItemFile(itemGhys.ItemCode, WorkFlowNode.GHSJYS, itemFile, ref strSql);
////资金
new BusiItemManage().SaveItemMoney(itemGhys.ItemCode, WorkFlowNode.GHSJYS, itemZj, ref strSql);
////工程
new BusiItemManage().SaveItemGcxx(itemGhys.ItemCode, itemGcxx, ref strSql);
////单位
new BusiItemManage().SaveItemCompany(itemGhys.ItemCode, ItemCompanyType.GH, itemDw, ref strSql);
return(OracleHelper.ExecuteCommand(strSql));
}
public bool SaveItem(Xm_Xmxx itemInfo, Xm_Sb_Jbxx itemSb,
List <Item_File> itemFile, Xm_Xmzj itemZj, Xm_Gcxx itemGcxx)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
//// 项目主表
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Xmxx>(CommonManage.delWhere(itemInfo.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemInfo));
////项目申报信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Sb_Jbxx>(CommonManage.delWhere(itemSb.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemSb));
////文件
new BusiItemManage().SaveItemFile(itemInfo.ItemCode, WorkFlowNode.TB, itemFile, ref strSql);
////资金
new BusiItemManage().SaveItemMoney(itemInfo.ItemCode, WorkFlowNode.TB, itemZj, ref strSql);
////工程
new BusiItemManage().SaveItemGcxx(itemInfo.ItemCode, itemGcxx, ref strSql);
////GIS信息
return(OracleHelper.ExecuteCommand(strSql));
}
public bool SaveItem(Xm_Jsxx jsxx, Xm_Xmzj itemZj, List <Item_File> itemFile)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////项目决算
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Jsxx>(CommonManage.delWhere(jsxx.ITEMCODE)));
strSql.Add(SqlBuilder.BuildInsertSql(jsxx));
////资金
new BusiItemManage().SaveItemMoney(jsxx.ITEMCODE, WorkFlowNode.JueSuan, itemZj, ref strSql);
////文件
new BusiItemManage().SaveItemFile(jsxx.ITEMCODE, WorkFlowNode.JueSuan, itemFile, ref strSql);
////更新主表
if (jsxx.SCDASJ.HasValue)
{
tmpSql = "update xm_xmxx set JSSJ = to_date('{0}','yyyy-mm-dd') where ITEMCODE = '{1}'";
tmpSql = string.Format(tmpSql, jsxx.SCDASJ.Value.ToString("yyyy-MM-dd"), jsxx.ITEMCODE);
strSql.Add(tmpSql);
}
return(OracleHelper.ExecuteCommand(strSql));
}
public bool SaveItem(Xm_Xmxx itemInfo, Xm_Ky_Jbxx itemKy,
List <Item_File> itemFile, Xm_Xmzj itemZj, Xm_Gcxx itemGcxx, Xm_Xmdw itemDw)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
//// 项目主表
strSql.Add(SqlBuilder.BuildUpdateSql(itemInfo));
////项目可研信息
strSql.Add(SqlBuilder.BuildDeleteSql <Xm_Ky_Jbxx>(CommonManage.delWhere(itemKy.ItemCode)));
strSql.Add(SqlBuilder.BuildInsertSql(itemKy));
////文件
new BusiItemManage().SaveItemFile(itemInfo.ItemCode, WorkFlowNode.KY, itemFile, ref strSql);
////资金
new BusiItemManage().SaveItemMoney(itemInfo.ItemCode, WorkFlowNode.KY, itemZj, ref strSql);
////工程
new BusiItemManage().SaveItemGcxx(itemInfo.ItemCode, itemGcxx, ref strSql);
////单位
new BusiItemManage().SaveItemCompany(itemInfo.ItemCode, ItemCompanyType.KY, itemDw, ref strSql);
////GIS信息
return(OracleHelper.ExecuteCommand(strSql));
}
public bool UpdateBgxxData(Xm_Ss_Bgxx bgxx, ActionEnum gcxxAction, Xm_Gcxx gcxx, Xm_Xmzj xmzjgs, List <Item_File> files)
{
ArrayList sqls = new ArrayList();
string tmpSql;
sqls.Add(SqlBuilder.BuildUpdateSql(bgxx));
if (gcxx != null)
{
switch (gcxxAction)
{
case ActionEnum.Insert:
tmpSql = "delete from xm_gcxx where itemcode = '{0}' and stage = '{1}' and xh >= {2}";
tmpSql = string.Format(tmpSql, gcxx.ItemCode, (int)gcxx.Stage, gcxx.Xh);
sqls.Add(tmpSql);
sqls.Add(SqlBuilder.BuildInsertSql(gcxx));
break;
case ActionEnum.Update:
sqls.Add(SqlBuilder.BuildUpdateSql(gcxx));
break;
}
}
if (xmzjgs != null)
{
tmpSql = "delete from xm_xmzj where itemcode = '{0}' and stage = '{1}' and xh = '{2}'";
tmpSql = string.Format(tmpSql, xmzjgs.ItemCode, (int)xmzjgs.Stage, xmzjgs.Xh);
sqls.Add(tmpSql);
sqls.Add(SqlBuilder.BuildInsertSql(xmzjgs));
//清空项目所有的文件。
tmpSql = "delete from item_file where itemcode = '{0}' and stage = '{1}' and xh = '{2}' and filecode in ('{3}')";
tmpSql = string.Format(tmpSql, xmzjgs.ItemCode, (int)xmzjgs.Stage, xmzjgs.Xh, (int)FileCode.预算补充文件);
sqls.Add(tmpSql);
//插入基本信息的文件。
foreach (Item_File fileInfo in files)
{
sqls.Add(SqlBuilder.BuildInsertSql(fileInfo));
}
}
return(OracleHelper.ExecuteCommand(sqls));
}
