/// <summary> /// 设置合同状态,返回1成功,其它失败 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="heTongId">合同编号</param> /// <param name="status">合同状态</param> /// <returns></returns> public int SheZhiHeTongStatus(string companyId, string heTongId, EyouSoft.Model.EnumType.ConStructure.ContractStatus status) { DbCommand cmd = _db.GetStoredProcCommand("proc_HeTong_SheZhiStatus"); _db.AddInParameter(cmd, "@CompanyId", DbType.AnsiStringFixedLength, companyId); _db.AddInParameter(cmd, "@HeTongId", DbType.AnsiStringFixedLength, heTongId); _db.AddInParameter(cmd, "@Status", DbType.Byte, status); _db.AddInParameter(cmd, "@DingDanId", DbType.AnsiStringFixedLength, ""); _db.AddOutParameter(cmd, "RetCode", DbType.Int32, 4); int sqlExceptionCode = 0; try { DbHelper.RunProcedure(cmd, _db); } catch (System.Data.SqlClient.SqlException e) { sqlExceptionCode = 0 - e.Number; } if (sqlExceptionCode < 0) { return(sqlExceptionCode); } return(Convert.ToInt32(_db.GetParameterValue(cmd, "RetCode"))); }
/// <summary> /// 设置合同状态,返回1成功,其它失败 /// </summary> /// <param name="companyId">公司编号</param> /// <param name="heTongId">合同编号</param> /// <param name="status">合同状态</param> /// <returns></returns> public int SheZhiHeTongStatus(string companyId, string heTongId, EyouSoft.Model.EnumType.ConStructure.ContractStatus status) { if (string.IsNullOrEmpty(companyId) || string.IsNullOrEmpty(heTongId)) { return(0); } int dalRetCode = dal.SheZhiHeTongStatus(companyId, heTongId, status); if (dalRetCode == 1) { SysStructure.BSysLogHandle.Insert("改变合同状态,合同编号:" + heTongId + ",当前状态:" + status + "。"); } return(dalRetCode); }
/// <summary> /// 合同号(使用,销号,作废) /// </summary> /// <param name="ContractStatus">合同号状态</param> /// <param name="Ids">合同号ids</param> /// <returns>0或负值:失败,1成功,2合同号不在状态</returns> public int ChangeContractStatus(EyouSoft.Model.EnumType.ConStructure.ContractStatus ContractStatus, params string[] Ids) { if (Ids.Length > 0) { int result = dal.ChangeContractStatus(ContractStatus, Ids); if (result == 1) { StringBuilder sId = new StringBuilder(); for (int i = 0; i < Ids.Length; i++) { sId.AppendFormat("'{0}',", Ids[i]); } sId.Remove(sId.Length - 1, 1); SysStructure.BSysLogHandle.Insert("更新合同号信息:编号为:" + sId.ToString()); } return(result); } return(0); }
/// <summary> /// 合同号(使用,销号,作废) /// </summary> /// <param name="ContractStatus">合同号状态</param> /// <param name="Ids">合同号ids</param> /// <returns>0或负值:失败,1成功,2合同号不在状态</returns> public int ChangeContractStatus(EyouSoft.Model.EnumType.ConStructure.ContractStatus ContractStatus, params string[] Ids) { StringBuilder sId = new StringBuilder(); for (int i = 0; i < Ids.Length; i++) { sId.AppendFormat("{0},", Ids[i]); } sId.Remove(sId.Length - 1, 1); DbCommand dc = this._db.GetStoredProcCommand("proc_ContractStatusChange"); this._db.AddInParameter(dc, "ContractStatus", DbType.Byte, (int)ContractStatus); this._db.AddInParameter(dc, "Ids", DbType.AnsiString, sId.ToString()); this._db.AddOutParameter(dc, "Result", DbType.Int32, 4); EyouSoft.Toolkit.DAL.DbHelper.RunProcedure(dc, this._db); object Result = this._db.GetParameterValue(dc, "Result"); if (!Result.Equals(null)) { return(int.Parse(Result.ToString())); } return(0); }