/// <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)); }
/// <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 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="itemCode"></param> /// <returns></returns> public Xm_GhsjYsxx GetItemInfo(string itemCode) { Xm_GhsjYsxx ItemInfo = null; string strSql = "select * from Xm_GhsjYsxx a " + " left join xm_xmzj b on a.itemcode = b.itemcode and b.stage = {1}" + " left join xm_xmdw c on a.itemcode = c.itemcode and c.type = {2}" + " where a.itemcode = '{0}'"; strSql = string.Format(strSql, itemCode, ((int)ItemStage.GuiHua).ToString(), ((int)ItemCompanyType.GH).ToString()); DataTable dt = OracleHelper.ExecuteDataTable(strSql); if (dt.Rows.Count > 0) { ItemInfo = (Xm_GhsjYsxx) new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(Xm_GhsjYsxx)); ItemInfo.Xmzj = (Xm_Xmzj) new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(Xm_Xmzj)); ItemInfo.GhDw = (Xm_Xmdw) new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(Xm_Xmdw)); } return(ItemInfo); }
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)); }