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