/// <summary>
/// 是否存在该合同号
/// </summary>
/// <param name="model">合同号段model</param>
/// <returns></returns>
public bool ExistsNum(Model.ConStructure.MContractNum model)
{
if (model != null && !string.IsNullOrEmpty(model.CompanyId) && !string.IsNullOrEmpty(model.ContractCode))
{
return(dal.ExistsNum(model));
}
return(false);
}
/// <summary>
/// 是否存在该合同号
/// </summary>
/// <param name="model">合同号model：CompanyId,ContractNum</param>
/// <returns></returns>
public bool ExistsNum(Model.ConStructure.MContractNum model)
{
string StrSql = " SELECT Count(1) FROM tbl_ContractNum WHERE CompanyId=@CompanyId and ContractCode=@ContractCode AND IsDelete='0' ";
DbCommand dc = this._db.GetSqlStringCommand(StrSql);
this._db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId);
this._db.AddInParameter(dc, "ContractCode", DbType.String, model.ContractCode);
return(EyouSoft.Toolkit.DAL.DbHelper.Exists(dc, _db));
}
