public static string GetServerAddress()
{
using (LinqToSQLModel.MainDBDataContext db = new LinqToSQLModel.MainDBDataContext())
{
return db.Connection.DataSource;
}
}
public static DateTime GetServerDatetime()
{
using (LinqToSQLModel.MainDBDataContext db = new LinqToSQLModel.MainDBDataContext())
{
DateTime oReturn = DateTime.MinValue;
var oServerNow = db.ExecuteQuery(typeof(DateTime), "SELECT GETDATE()");
foreach (DateTime oNow in oServerNow)
{
oReturn = oNow;
}
return oReturn;
}
}
List<Model.HBPMS.ProductionRelated.ProjectCommonQuery_Info> DAL.IDAL.HBPMS.ProductionRelated.IProjectCommonQueryDA.SearchRecord(Model.HBPMS.ProductionRelated.ProjectCommonQuery_Info oInfo)
{
if (oInfo != null)
{
try
{
List<Model.HBPMS.ProductionRelated.ProjectCommonQuery_Info> oReturn = new List<Model.HBPMS.ProductionRelated.ProjectCommonQuery_Info>();
using (LinqToSQLModel.MainDBDataContext db = new LinqToSQLModel.MainDBDataContext())
{
var oResult = //from spl in db.ShiftProjList_spl
from ppj in db.PrintProject_ppj //on spl.spl_PPJID equals ppj.ppj_RecordID
join swl in db.ScheduleProjList_swl
on ppj.ppj_SWLID equals swl.swl_RecordID
where (string.IsNullOrEmpty(oInfo.SearchMachineID) ? true : swl.swl_cMachineNO.Equals(oInfo.SearchMachineID))
&& (string.IsNullOrEmpty(oInfo.SearchSONO) ? true : swl.swl_cSONO.Contains(oInfo.SearchSONO))
&& (string.IsNullOrEmpty(oInfo.SearchItemNO) ? true : swl.swl_cItemNO.Contains(oInfo.SearchItemNO))
&& (string.IsNullOrEmpty(oInfo.SearchProdName) ? true : swl.swl_cProdName.Contains(oInfo.SearchProdName))
&& (string.IsNullOrEmpty(oInfo.SearchItemName) ? true : swl.swl_cItemName.Contains(oInfo.SearchItemName))
&& (string.IsNullOrEmpty(oInfo.SearchProjStatus) ? true : swl.swl_cProjStatus.Equals(oInfo.SearchProjStatus))
&& (oInfo.SearchDateBegin == DateTime.MinValue ? true : ppj.ppj_dProjBeginTime > oInfo.SearchDateBegin)
&& (oInfo.SearchDateEnd == DateTime.MinValue ? true : ppj.ppj_dProjBeginTime <= oInfo.SearchDateEnd.AddDays(1))
/*lunlin 2014-3-5*/
&& (oInfo.SearchDateOfShipmentStart == DateTime.MinValue ? true : swl.swl_dDateOfShipment > oInfo.SearchDateOfShipmentStart)
&& (oInfo.SearchDateOfShipmentEnd == DateTime.MinValue ? true : swl.swl_dDateOfShipment <= oInfo.SearchDateOfShipmentEnd)
&& (oInfo.SearchDemandStart == DateTime.MinValue ? true : swl.swl_dRequestCompleteDate > oInfo.SearchDemandStart)
&& (oInfo.SearchDemandEnd == DateTime.MinValue ? true : swl.swl_dRequestCompleteDate <= oInfo.SearchDemandEnd)
/*lunlin 2014-3-5*/
orderby ppj.ppj_dProjBeginTime//spl.spl_dBeginTime
select new Model.HBPMS.ProductionRelated.ProjectCommonQuery_Info
{
//swl_cProdName = swl.swl_cProdName,
//swl_cSONO = swl.swl_cSONO,
//swl_cItemNO = swl.swl_cItemNO,
//swl_cItemName = swl.swl_cItemName,
//ppj_dProjBeginTime = spl.spl_dBeginTime,
//ppj_dProdEndTime = spl.spl_dEndTime,
//ppj_iActualPrepairTime = spl.spl_iPrepairTime,
//ppj_iStopTime = spl.spl_iStopTime,
//ppj_iProdRunTime = spl.spl_iRunTime,
//ppj_iActualProdNum = spl.spl_iQTY,
//swl_cProjStatus = swl.swl_cProjStatus,
//swl_cMachineNO = swl.swl_cMachineNO
cProjectNO = "",
cSONO = swl.swl_cSONO,
cRefSONo = "",
cDCSheetNO = swl.swl_cItemNO,
cProductDesc = swl.swl_cProdName,
cProductSize = "",
cDCSheetName = swl.swl_cItemName,
cProductType = "",
cEditionDesc = swl.swl_cEdition,
iSheetProdQty = swl.swl_iSheetProdQty,
iPlanProdQty = swl.swl_iPlanProdQty,
iRealYield = ppj.ppj_iActualProdNum,
iWADQTY = 0,
iAccountWastageQty = 0,
iAccountDefectiveQty = ppj.ppj_iCountDefectiveQty,
iAccountWasteQty = ppj.ppj_iCountWastNum,
iFrontProcessDefectiveQty = 0,
iAccountEligibleQty = ppj.ppj_iActualProdNum - ppj.ppj_iCountDefectiveQty - ppj.ppj_iCountWastNum,
dBeginTime = ppj.ppj_dProjBeginTime,
dProductBeginTime = ppj.ppj_dProdBeginTime,
dEndTime = ppj.ppj_dProdEndTime,
cTotalRunTime = Common.Util.DateUtil.Convert(ppj.ppj_iProjRunTime.HasValue ? ppj.ppj_iProjRunTime.Value : 0),
cTotalStopTime = Common.Util.DateUtil.Convert(ppj.ppj_iStopTime.HasValue ? ppj.ppj_iStopTime.Value : 0),
cTotalReadyTime = Common.Util.DateUtil.Convert(ppj.ppj_iActualPrepairTime.HasValue ? ppj.ppj_iActualPrepairTime.Value : 0),
cNextGroup = swl.swl_cNextGroup,
cNextArea = swl.swl_cNextArea
};
if (oResult != null)
{
foreach (Model.HBPMS.ProductionRelated.ProjectCommonQuery_Info oEarchResult in oResult)
{
oReturn.Add(oEarchResult);
}
}
}
return oReturn;
}
catch (Exception Ex)
{
throw Ex;
}
}
return null;
}
