public static bool isMathcCable(int cableid, DateTime date)
{
Cablehistory[] historys = CablehistoryDao.FindAll(new EqExpression("Cableid", cableid));
if (historys.Length > 0)
{
for (int i = 0; i < historys.Length; i++)
{
if (historys[i].Startdate == null || historys[i].Enddate == null)
{
continue;
}
DateTime start = DateTime.Parse(historys[i].Startdate.ToString()); //合同起始日期
DateTime end = DateTime.Parse(historys[i].Enddate.ToString()); //合同结束日期
if (isMath(date, start, end))
{
return(true);
}
else
{
continue;
}
}
return(false);
}
else
{
return(false);
}
}
public static Cablehistory[] getHistoryById(int id)
{
try
{
Cablehistory[] historys = CablehistoryDao.FindAll(new Order("Createtime", false), new EqExpression("Cableid", id), new EqExpression("Isdeleted", (int)EnmIsdeleted.使用中));
return(historys);
}
catch (Exception ex)
{
Log.Error(ex.Message);
MessageHelper.ShowMessage("E999", ex.Message);
return(null);
}
}
public static int isNewCable(int id)
{
try
{
Cablehistory[] his = CablehistoryDao.FindAll(new EqExpression("Cableid", id));
return(his.Length);
}
catch (Exception ex)
{
Log.Error(ex.Message);
return(-1);
}
}
public static bool IsCableByCableNumber(int cableid, int customerid)
{
Cablehistory his = CablehistoryDao.FindFirst(new EqExpression("Cableid", cableid),
new EqExpression("Customerid", customerid));
if (his != null)
{
return(true);
}
else
{
return(false);
}
}
public static Nullable <DateTime> getMigrateDate(int cableid, int cusid)
{
Cablehistory history = CablehistoryDao.FindFirst(new EqExpression("Cableid", cableid),
new EqExpression("Customerid", cusid),
new NotNullExpression("Default1"));
if (history != null)
{
//DateTime date = DateTime.Parse(history.Default1).Date;
return(history.Default1.Value.Date);
}
else
{
return(null);
}
}
