public bool UpdateJsxxData(ActionEnum action, Xm_Jsxx jsxx, List<Item_File> fileInfos)
{
ArrayList sqls = new ArrayList();
string tmpSql;
switch (action)
{
case ActionEnum.Insert:
sqls.Add(SqlBuilder.BuildInsertSql(jsxx));
break;
case ActionEnum.Update:
sqls.Add(SqlBuilder.BuildUpdateSql(jsxx));
//清空项目所有的文件。
tmpSql = "delete from item_file where itemcode = '{0}' and nodeid = '{1}'";
tmpSql = string.Format(tmpSql, jsxx.ITEMCODE, (int)WorkFlowNode.JueSuan);
sqls.Add(tmpSql);
break;
}
tmpSql = "update xm_xmxx set JSSJ = to_date('{0}','yyyy-mm-dd hh24:mi:ss') where ITEMCODE = '{1}'";
tmpSql = string.Format(tmpSql, jsxx.SCDASJ, jsxx.ITEMCODE);
sqls.Add(tmpSql);
//插入文件。
foreach (Item_File fileInfo in fileInfos)
{
sqls.Add(SqlBuilder.BuildInsertSql(fileInfo));
}
return OracleHelper.ExecuteCommand(sqls);
}
public bool SaveItem(Xm_Jsxx jsxx, Xm_Xmzj itemZj, List<Item_File> itemFile)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////项目决算
strSql.Add(SqlBuilder.BuildDeleteSql<Xm_Jsxx>(CommonManage.delWhere(jsxx.ITEMCODE)));
strSql.Add(SqlBuilder.BuildInsertSql(jsxx));
////资金
new BusiItemManage().SaveItemMoney(jsxx.ITEMCODE, WorkFlowNode.JueSuan, itemZj, ref strSql);
////文件
new BusiItemManage().SaveItemFile(jsxx.ITEMCODE, WorkFlowNode.JueSuan, itemFile, ref strSql);
////更新主表
if (jsxx.SCDASJ.HasValue)
{
tmpSql = "update xm_xmxx set JSSJ = to_date('{0}','yyyy-mm-dd') where ITEMCODE = '{1}'";
tmpSql = string.Format(tmpSql, jsxx.SCDASJ.Value.ToString("yyyy-MM-dd"), jsxx.ITEMCODE);
strSql.Add(tmpSql);
}
return OracleHelper.ExecuteCommand(strSql);
}