public IEnumerable<UnitInfo> SearchUnitUnPaged(UnitSearchJsonPatch json)
{
try
{
if (json == null)
throw new ArgumentException("json or pageinfo is null ");
IList<Core.Business.UnitInfo> unitInfolist = new List<Core.Business.UnitInfo>();
SqlServerUtility sql = new SqlServerUtility();
if (!string.IsNullOrEmpty(json.Name))
{
sql.AddParameter("@name", SqlDbType.NVarChar, json.Name);
}
if (!string.IsNullOrEmpty(json.Alias))
{
sql.AddParameter("@alias", SqlDbType.NVarChar, json.Alias);
}
if (json.Province != null)
{
sql.AddParameter("@province", SqlDbType.UniqueIdentifier, json.Province.Value);
}
if (json.City != null)
{
sql.AddParameter("@city", SqlDbType.UniqueIdentifier, json.City.Value);
}
if (json.IsCorp != null)
{
sql.AddParameter("@iscorp", SqlDbType.Int, json.IsCorp.Value);
}
if (json.UnitType != null)
{
sql.AddParameter("@unittype", SqlDbType.UniqueIdentifier, json.UnitType.Value);
}
if (json.TradeSort != null)
{
sql.AddParameter("@tradesort", SqlDbType.UniqueIdentifier, json.TradeSort.Value);
}
if (json.StartAuditingDate != null)
{
sql.AddParameter("@startauditdate", SqlDbType.DateTime, json.StartAuditingDate.Value);
}
if (json.EndAuditingDate != null)
{
sql.AddParameter("@endauditdate", SqlDbType.DateTime, json.EndAuditingDate.Value);
}
if (json.State != null)
{
sql.AddParameter("@state", SqlDbType.Int, json.State.Value);
}
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUnitUnPaged");
if (reader != null)
{
while (reader.Read())
{
Core.Business.UnitInfo unitInfo = new Core.Business.UnitInfo();
if (!reader.IsDBNull(0)) unitInfo.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) unitInfo.UnitName = reader.GetString(1);
if (!reader.IsDBNull(2)) unitInfo.Alias = reader.GetString(2);
if (!reader.IsDBNull(3)) unitInfo.ProvinceID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) unitInfo.CityID = reader.GetGuid(4);
if (!reader.IsDBNull(5)) unitInfo.Address = reader.GetString(5);
if (!reader.IsDBNull(6)) unitInfo.Postalcode = reader.GetString(6);
if (!reader.IsDBNull(7)) unitInfo.Tel = reader.GetString(7);
if (!reader.IsDBNull(8)) unitInfo.Fax = reader.GetString(8);
if (!reader.IsDBNull(9)) unitInfo.Website = reader.GetString(9);
if (!reader.IsDBNull(10)) unitInfo.Email = reader.GetString(10);
if (!reader.IsDBNull(11)) unitInfo.UnitType = reader.GetGuid(11);
if (!reader.IsDBNull(12)) unitInfo.Ownership = reader.GetString(12);
if (!reader.IsDBNull(13)) unitInfo.DrtificialPerson = reader.GetString(13);
if (!reader.IsDBNull(14)) unitInfo.DrtificialPersonDutyID = reader.GetGuid(14);
if (!reader.IsDBNull(15)) unitInfo.DrtificialPersonTel = reader.GetString(15);
if (!reader.IsDBNull(16)) unitInfo.LinkDepartdement = reader.GetString(16);
if (!reader.IsDBNull(17)) unitInfo.Linkman = reader.GetString(17);
if (!reader.IsDBNull(18)) unitInfo.LinkmanDutyID = reader.GetGuid(18);
if (!reader.IsDBNull(19)) unitInfo.LinkmanTel = reader.GetString(19);
if (!reader.IsDBNull(20)) unitInfo.ChargeDepartMent = reader.GetString(20);
if (!reader.IsDBNull(21)) unitInfo.BankAccountName = reader.GetString(21);
if (!reader.IsDBNull(22)) unitInfo.BankName = reader.GetString(22);
if (!reader.IsDBNull(23)) unitInfo.BankAccount = reader.GetString(23);
if (!reader.IsDBNull(24)) unitInfo.Certificate = reader.GetString(24);
if (!reader.IsDBNull(25)) unitInfo.Rel_certificate = reader.GetString(25);
if (!reader.IsDBNull(26)) unitInfo.WorkCode = reader.GetString(26);
if (!reader.IsDBNull(27)) unitInfo.Synopsis = reader.GetString(27);
if (!reader.IsDBNull(28)) unitInfo.InstrumentSection = reader.GetString(28);
if (!reader.IsDBNull(29)) unitInfo.VindicatorCount = reader.GetInt32(29);
if (!reader.IsDBNull(30)) unitInfo.Subjection = reader.GetInt32(30);
if (!reader.IsDBNull(31)) unitInfo.TradeSortID = reader.GetGuid(31);
if (!reader.IsDBNull(32)) unitInfo.IsModification = reader.GetInt32(32);
if (!reader.IsDBNull(33)) unitInfo.IsCooperantUnit = reader.GetInt32(33);
if (!reader.IsDBNull(34)) unitInfo.Operation = reader.GetString(34);
if (!reader.IsDBNull(35)) unitInfo.Remark = reader.GetString(35);
if (!reader.IsDBNull(36)) unitInfo.InstrumentCount = reader.GetInt32(36);
if (!reader.IsDBNull(37)) unitInfo.InfoDutyDepartment = reader.GetString(37);
if (!reader.IsDBNull(38)) unitInfo.AuditingState = reader.GetInt32(38);
if (!reader.IsDBNull(39)) unitInfo.Assessor = reader.GetString(39);
if (!reader.IsDBNull(40)) unitInfo.AuditingDate = reader.GetDateTime(40);
if (!reader.IsDBNull(41)) unitInfo.CreatDate = reader.GetDateTime(41);
if (!reader.IsDBNull(42)) unitInfo.UpdateDate = reader.GetDateTime(42);
if (!reader.IsDBNull(43)) unitInfo.Annex = reader.GetInt32(43);
if (!reader.IsDBNull(44)) unitInfo.UnitInWorkPerson = reader.GetGuid(44);
if (!reader.IsDBNull(45)) unitInfo.UnitApplicationUserType = reader.GetInt32(45);
if (!reader.IsDBNull(46)) unitInfo.Count = reader.GetInt64(46);
unitInfo.MarkOld();
unitInfolist.Add(unitInfo);
}
reader.Close();
}
return unitInfolist;
}
catch (Exception ex)
{
throw ex;
}
}
public int GetTotalCount(UnitSearchJsonPatch json)
{
try
{
if (json == null)
throw new ArgumentException("json or pageinfo is null ");
SqlServerUtility sql = new SqlServerUtility();
if (!string.IsNullOrEmpty(json.Name))
{
sql.AddParameter("@name", SqlDbType.NVarChar, json.Name);
}
if (!string.IsNullOrEmpty(json.Alias))
{
sql.AddParameter("@alias", SqlDbType.NVarChar, json.Alias);
}
if (json.Province != null)
{
sql.AddParameter("@province", SqlDbType.UniqueIdentifier, json.Province.Value);
}
if (json.City != null)
{
sql.AddParameter("@city", SqlDbType.UniqueIdentifier, json.City.Value);
}
if (json.IsCorp != null)
{
sql.AddParameter("@iscorp", SqlDbType.Int, json.IsCorp.Value);
}
if (json.UnitType != null)
{
sql.AddParameter("@unittype", SqlDbType.UniqueIdentifier, json.UnitType.Value);
}
if (json.TradeSort != null)
{
sql.AddParameter("@tradesort", SqlDbType.UniqueIdentifier, json.TradeSort.Value);
}
if (json.StartAuditingDate != null)
{
sql.AddParameter("@startauditdate", SqlDbType.DateTime, json.StartAuditingDate.Value);
}
if (json.EndAuditingDate != null)
{
sql.AddParameter("@endauditdate", SqlDbType.DateTime, json.EndAuditingDate.Value);
}
if (json.State != null)
{
sql.AddParameter("@state", SqlDbType.Int, json.State.Value);
}
int totalCount = 0;
SqlDataReader reader = sql.ExecuteSPReader("usp_GetUnitTotalCount");
if (reader != null && !reader.IsClosed && reader.Read())
{
if (!reader.IsDBNull(0)) totalCount = reader.GetInt32(0);
reader.Close();
}
return totalCount;
}
catch (Exception ex)
{
throw ex;
}
}
