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