/// <summary>
/// 更新预算审核信息
/// </summary>
/// <param name="itemInfo"></param>
/// <returns></returns>
public bool UpdateYsSH(Xm_GhsjYsxx itemInfo, bool updateMain)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
tmpSql = "update xm_ghsjysxx set YSPFDW = '{3}', YSPFSJ = to_date('{1}','yyyy-mm-dd'), YSXDWH = '{2}', SFTZ = {4} where itemCode in ({0})";
tmpSql = string.Format(tmpSql, itemInfo.ItemCode, itemInfo.Yspfsj.Value.ToString("yyyy-MM-dd"), itemInfo.Ysxdwh, itemInfo.Yspfdw, itemInfo.Sftz.ToString());
strSql.Add(tmpSql);
if (updateMain)
{
tmpSql = "update xm_xmxx set ZJPFSJ = to_date('{1}','yyyy-mm-dd'), ZJPFWH = '{2}' where itemCode in ({0})";
tmpSql = string.Format(tmpSql, itemInfo.ItemCode, itemInfo.Yspfsj.Value.ToString("yyyy-MM-dd"), itemInfo.Ysxdwh);
strSql.Add(tmpSql);
}
return OracleHelper.ExecuteCommand(strSql);
}
/// <summary>
/// 保存规划设计信息
/// </summary>
/// <param name="itemGHYS"></param>
/// <param name="strSql"></param>
public void SaveItem_GHSJ(Xm_GhsjYsxx itemGHYS, ref ArrayList strSql)
{
string tmpSql = string.Empty;
tmpSql = "delete from xm_ghsjysxx where itemcode = '{0}'";
tmpSql = string.Format(tmpSql, itemGHYS.ItemCode);
strSql.Add(tmpSql);
}
/// <summary>
/// 更新规划设计审核信息
/// </summary>
/// <param name="itemInfo"></param>
/// <returns></returns>
public bool UpdateGhSH(Xm_GhsjYsxx itemInfo)
{
string strSql = "update xm_ghsjysxx set GHPFDW = '{2}', GHPFSJ = to_date('{1}','yyyy-mm-dd') where itemCode in ({0})";
strSql = string.Format(strSql, itemInfo.ItemCode, itemInfo.Ghpfsj.Value.ToString("yyyy-MM-dd"), itemInfo.Ghpfdw);
return OracleHelper.ExecuteCommand(strSql);
}
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);
}
