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