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);
}
public bool UpdateJlData(ActionEnum action, Xm_Xmdw xmdw, List<Xm_Ss_Gcjl_Jlry> jlrys, List<Xm_Ss_Gcjl_Jlht> jlhts, List<Item_File> jlhtFiles)
{
ArrayList sqls = new ArrayList();
string tmpSql;
switch (action)
{
case ActionEnum.Insert:
sqls.Add(SqlBuilder.BuildInsertSql(xmdw));
break;
case ActionEnum.Update:
sqls.Add(SqlBuilder.BuildUpdateSql(xmdw));
//清空项目所有的文件。
tmpSql = "delete from item_file where itemcode = '{0}' and nodeid = '{1}' and filecode in ('{2}')";
tmpSql = string.Format(tmpSql, xmdw.ItemCode, (int)WorkFlowNode.ShiShi, "20");
sqls.Add(tmpSql);
Dictionary<string, string> delJlInfoCondition = new Dictionary<string, string>();
delJlInfoCondition.Add("itemcode", xmdw.ItemCode);
//清空所有监理人员记录。
sqls.Add(SqlBuilder.BuildDeleteSql<Xm_Ss_Gcjl_Jlry>(delJlInfoCondition));
//清空所有监理合同记录。
sqls.Add(SqlBuilder.BuildDeleteSql<Xm_Ss_Gcjl_Jlht>(delJlInfoCondition));
break;
}
//插入基本信息的文件。
foreach (Item_File fileInfo in jlhtFiles)
{
sqls.Add(SqlBuilder.BuildInsertSql(fileInfo));
}
foreach (var jlry in jlrys)
{
sqls.Add(SqlBuilder.BuildInsertSql(jlry));
}
foreach (var jlht in jlhts)
{
sqls.Add(SqlBuilder.BuildInsertSql(jlht));
}
return OracleHelper.ExecuteCommand(sqls);
}
public bool UpdateZtbData(ActionEnum action, Xm_Ss_Ztb_Jbxx ztbJbxx, Xm_Xmdw xmdw, List<Xm_Ss_Ztb_Zbqk> zbqks, List<Xm_Ss_Ztb_Sght> sghts, List<Item_File> fileInfos)
{
List<string> sgdwNames = (from record in sghts
select record.CBF).Distinct().ToList();
List<Xm_Xmdw> sgdws = new List<Xm_Xmdw>();
foreach (var item in sgdwNames)
{
sgdws.Add(new Xm_Xmdw() { ItemCode = ztbJbxx.ItemCode, Type = ItemCompanyType.SG, Name = item });
}
ArrayList sqls = new ArrayList();
string tmpSql;
switch (action)
{
case ActionEnum.Insert:
sqls.Add(SqlBuilder.BuildInsertSql(ztbJbxx));
sqls.Add(SqlBuilder.BuildInsertSql(xmdw));
break;
case ActionEnum.Update:
sqls.Add(SqlBuilder.BuildUpdateSql(ztbJbxx));
sqls.Add(SqlBuilder.BuildUpdateSql(xmdw));
//清空项目所有的文件。
tmpSql = "delete from item_file where itemcode = '{0}' and nodeid = '{1}' and filecode in ('16','17','18','19')";
tmpSql = string.Format(tmpSql, ztbJbxx.ItemCode, (int)WorkFlowNode.ShiShi);
sqls.Add(tmpSql);
//清空所有中标情况记录。
tmpSql = "delete from xm_ss_ztb_zbqk where itemcode = '{0}'";
tmpSql = string.Format(tmpSql, ztbJbxx.ItemCode);
sqls.Add(tmpSql);
//清空所有施工合同记录。
tmpSql = "delete from xm_ss_ztb_sght where itemcode = '{0}'";
tmpSql = string.Format(tmpSql, ztbJbxx.ItemCode);
sqls.Add(tmpSql);
//清空所有施工单位记录。
tmpSql = "delete from xm_xmdw where itemcode = '{0}' and TYPE = '{1}'";
tmpSql = string.Format(tmpSql, ztbJbxx.ItemCode, (int)ItemCompanyType.SG);
sqls.Add(tmpSql);
break;
}
tmpSql = "update xm_xmxx set KBSJ = to_date('{0}','yyyy-mm-dd hh24:mi:ss') where ITEMCODE = '{1}'";
tmpSql = string.Format(tmpSql, ztbJbxx.KBSJ, ztbJbxx.ItemCode);
sqls.Add(tmpSql);
//插入基本信息的文件。
foreach (Item_File fileInfo in fileInfos)
{
sqls.Add(SqlBuilder.BuildInsertSql(fileInfo));
}
foreach (var zbqk in zbqks)
{
sqls.Add(SqlBuilder.BuildInsertSql(zbqk));
}
foreach (var sght in sghts)
{
sqls.Add(SqlBuilder.BuildInsertSql(sght));
}
foreach (var sgdw in sgdws)
{
sqls.Add(SqlBuilder.BuildInsertSql(sgdw));
}
return OracleHelper.ExecuteCommand(sqls);
}
public bool AddCddw(Xm_Xmdw cddw)
{
ArrayList sqls = new ArrayList();
sqls.Add(SqlBuilder.BuildInsertSql(cddw));
return OracleHelper.ExecuteCommand(sqls);
}
/// <summary>
/// 保存项目单位信息
/// </summary>
/// <param name="company"></param>
/// <returns></returns>
public void SaveItemCompany(string itemCode, ItemCompanyType comType, Xm_Xmdw itemCompany, ref ArrayList strSql)
{
string tmpSql = string.Empty;
tmpSql = "delete from xm_xmdw where itemCode in ({0}) and type = {1}";
tmpSql = string.Format(tmpSql, itemCode, ((int)comType).ToString());
strSql.Add(tmpSql);
if (itemCompany != null)
{
tmpSql = "insert into xm_xmdw (itemcode, type, name, code, linkphone, linkman)"
+ " values ('{0}','{1}','{2}','{3}','{4}','{5}')";
tmpSql = string.Format(tmpSql, itemCompany.ItemCode, ((int)itemCompany.Type).ToString(),
itemCompany.Name, itemCompany.Code, itemCompany.LinkPhone, itemCompany.LinkMan);
strSql.Add(tmpSql);
}
}
/// <summary>
/// 保存项目单位信息
/// </summary>
/// <param name="itemCompany"></param>
/// <returns></returns>
public bool SaveItemCompany(Xm_Xmdw itemCompany)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
if (itemCompany != null)
{
tmpSql = "delete from xm_xmdw where itemCode in ({0}) and type = {1}";
tmpSql = string.Format(tmpSql, itemCompany.ItemCode, ((int)itemCompany.Type).ToString());
strSql.Add(tmpSql);
strSql.Add(SqlBuilder.BuildInsertSql(itemCompany));
return OracleHelper.ExecuteCommand(strSql);
}
return false;
}
public bool UpdateYsxx(Xm_Ysxx ysxx, Xm_Xmdw xmdw, List<Item_File> fileInfos, WorkFlowNode ysType)
{
ArrayList sqls = new ArrayList();
Dictionary<string, string> deleteCondition = new Dictionary<string, string>();
string tmpSql;
sqls.Add(SqlBuilder.BuildUpdateSql(ysxx));
tmpSql = "update xm_xmxx set YSWH = '{0}' where ITEMCODE = '{1}'";
tmpSql = string.Format(tmpSql, ysxx.YSWH, ysxx.ITEMCODE);
sqls.Add(tmpSql);
if (xmdw != null)
{
//清空技术复合单位记录。
deleteCondition.Clear();
deleteCondition.Add("itemcode", ysxx.ITEMCODE);
deleteCondition.Add("TYPE", ((int)ItemCompanyType.JSFH).ToString());
sqls.Add(SqlBuilder.BuildDeleteSql<Xm_Xmdw>(deleteCondition));
//添加技术复合单位记录。
sqls.Add(SqlBuilder.BuildInsertSql(xmdw));
}
//清空项目所有的文件。
tmpSql = "delete from item_file where itemcode = '{0}' and nodeid = '{1}'";
tmpSql = string.Format(tmpSql, ysxx.ITEMCODE, (int)ysType);
sqls.Add(tmpSql);
//插入基本信息的文件。
foreach (Item_File fileInfo in fileInfos)
{
sqls.Add(SqlBuilder.BuildInsertSql(fileInfo));
}
return OracleHelper.ExecuteCommand(sqls);
}
/// <summary>
/// 保存验收信息
/// </summary>
/// <param name="node"></param>
/// <param name="ysxx"></param>
/// <param name="itemFile"></param>
/// <param name="xmdw"></param>
/// <param name="gcxx"></param>
/// <returns></returns>
public bool SaveItem(WorkFlowNode node, Xm_Ysxx ysxx, List<Item_File> itemFile, Xm_Xmdw xmdw, Xm_Gcxx gcxx)
{
ArrayList strSql = new ArrayList();
string tmpSql = string.Empty;
////文件
new BusiItemManage().SaveItemFile(ysxx.ITEMCODE, node, itemFile, ref strSql);
////预算信息
strSql.Add(SqlBuilder.BuildUpdateSql(ysxx));
if (node == WorkFlowNode.ZhongYan)
{
////工程信息
new BusiItemManage().SaveItemGcxx(ysxx.ITEMCODE, gcxx, ref strSql);
////单位信息
new BusiItemManage().SaveItemCompany(ysxx.ITEMCODE, ItemCompanyType.JSFH, xmdw, ref strSql);
////更新主表信息(验收时间、验收文号)
tmpSql = "update xm_xmxx set YSSJ = to_date('{1}','yyyy-mm-dd'), YsWh = '{2}' where ITEMCODE = '{0}'";
tmpSql = string.Format(tmpSql, ysxx.ITEMCODE,
ysxx.ZYSJ.HasValue ? ysxx.ZYSJ.Value.ToString("yyyy-MM-dd") : string.Empty, ysxx.YSWH);
strSql.Add(tmpSql);
}
return OracleHelper.ExecuteCommand(strSql);
}