/// <summary> /// 获取申报项目数据 /// </summary> /// <param name="itemCode"></param> /// <returns></returns> public Xm_Sb_Jbxx GetItemInfo(string itemCode) { Xm_Sb_Jbxx ItemInfo = null; string strSql = "select * from xm_sb_jbxx a left join xm_xmzj b " + " on a.itemcode = b.itemcode and b.stage = {1}" + " where a.itemcode = '{0}'"; strSql = string.Format(strSql, itemCode, ((int)ItemStage.ShenBo).ToString()); DataTable dt = OracleHelper.ExecuteDataTable(strSql); if (dt.Rows.Count == 1) { ItemInfo = (Xm_Sb_Jbxx) new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(Xm_Sb_Jbxx)); ItemInfo.Xmzj = (Xm_Xmzj) new DataTableOperation().ConvertFromDataRowToEntity(dt.Rows[0], typeof(Xm_Xmzj)); //ItemInfo.Zjze = dt.Rows[0]["Zjze"].ToString(); //ItemInfo.Sbgzf = dt.Rows[0]["Sbgzf"].ToString(); //ItemInfo.Tdpzgcf = dt.Rows[0]["Tdpzgcf"].ToString(); //ItemInfo.Ntslgcf = dt.Rows[0]["Ntslgcf"].ToString(); //ItemInfo.Dlgcf = dt.Rows[0]["Dlgcf"].ToString(); //ItemInfo.Qtgcf = dt.Rows[0]["Qtgcf"].ToString(); //ItemInfo.Bkyjf = dt.Rows[0]["Bkyjf"].ToString(); //ItemInfo.Qtfy = dt.Rows[0]["Qtfy"].ToString(); } return(ItemInfo); }
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)); }