/// <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);
        }