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