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