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