public VegetableSpeciesMaster_vsm_Info GetRecord_Previous(Model.Base.DataBaseCommandInfo commandInfo) { VegetableSpeciesMaster_vsm_Info vegetableSpeciesMasterInfo = null; if (commandInfo != null && commandInfo.KeyInfoList != null && commandInfo.KeyInfoList[0] != null && commandInfo.KeyInfoList[0].KeyValue != "") { try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { VegetableSpeciesMaster_vsm vegetableSpecies = (from t in db.VegetableSpeciesMaster_vsm where t.vsm_iSeq < Convert.ToInt32(commandInfo.KeyInfoList[0].KeyValue) orderby t.vsm_iSeq descending select t).FirstOrDefault(); if (vegetableSpecies != null) { vegetableSpeciesMasterInfo = Common.General.CopyObjectValue <VegetableSpeciesMaster_vsm, VegetableSpeciesMaster_vsm_Info>(vegetableSpecies); } } } catch (Exception Ex) { throw Ex; } } return(vegetableSpeciesMasterInfo); }
public bool DeleteRecord(Model.IModel.IModelObject KeyObject) { bool isSuccess = false; VegetableSpeciesMaster_vsm_Info keyObject = KeyObject as VegetableSpeciesMaster_vsm_Info; if (keyObject != null) { try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { VegetableSpeciesMaster_vsm vegetableSpeciesMaster = db.VegetableSpeciesMaster_vsm.FirstOrDefault(t => t.vsm_RecordID == keyObject.vsm_RecordID); if (vegetableSpeciesMaster != null) { db.VegetableSpeciesMaster_vsm.DeleteOnSubmit(vegetableSpeciesMaster); db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } } return(isSuccess); }
public VegetableSpeciesMaster_vsm_Info GetRecord_Last() { VegetableSpeciesMaster_vsm_Info vegetableSpeciesMasterInfo = null; try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { IEnumerable <VegetableSpeciesMaster_vsm> query = db.VegetableSpeciesMaster_vsm.OrderByDescending(t => t.vsm_iSeq); if (query != null && query.Count() > 0) { VegetableSpeciesMaster_vsm vegetableSpeciesMaster = query.First(); if (vegetableSpeciesMaster != null) { vegetableSpeciesMasterInfo = Common.General.CopyObjectValue <VegetableSpeciesMaster_vsm, VegetableSpeciesMaster_vsm_Info>(vegetableSpeciesMaster); } } } } catch (Exception Ex) { throw Ex; } return(vegetableSpeciesMasterInfo); }
/// <summary> /// 新增蔬菜品种主档记录 /// </summary> /// <param name="infoObject"></param> /// <returns></returns> public bool InsertRecord(VegetableSpeciesMaster_vsm_Info infoObject) { bool isSuccess = false; if (infoObject != null) { try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { VegetableSpeciesMaster_vsm vegetableSpeciesMaster = Common.General.CopyObjectValue <VegetableSpeciesMaster_vsm_Info, VegetableSpeciesMaster_vsm>(infoObject); db.VegetableSpeciesMaster_vsm.InsertOnSubmit(vegetableSpeciesMaster); this.InsertVegetableSpeciesTransactionTime(db, infoObject.VegetableSpeciesTransactionTimes); this.InsertVegetableSpeciesMasterCost(db, infoObject.VegetableSpeciesMasterCosts); this.InsertVegetableSpeciesPerdictYield(db, infoObject.VegetableSpeciesPerdictYields); this.InsertVegetableSpeciesSuitPlantTime(db, infoObject.VegetableSpeciesSuitPlantTimes); db.SubmitChanges(); isSuccess = true; } } catch (Exception Ex) { throw Ex; } } return(isSuccess); }
/// <summary> /// 更新蔬菜品种主档记录 /// </summary> /// <param name="infoObject"></param> /// <returns></returns> public bool UpdateRecord(VegetableSpeciesMaster_vsm_Info infoObject) { bool isSuccess = false; if (infoObject != null) { try { using (VPMSDBDataContext db = new VPMSDBDataContext()) { VegetableSpeciesMaster_vsm vegetableSpeciesMaster = db.VegetableSpeciesMaster_vsm.FirstOrDefault(t => t.vsm_RecordID == infoObject.vsm_RecordID); if (vegetableSpeciesMaster != null) { vegetableSpeciesMaster.vsm_cName = infoObject.vsm_cName; vegetableSpeciesMaster.vsm_cTypeNum = infoObject.vsm_cTypeNum; vegetableSpeciesMaster.vsm_cByClassificationNum = infoObject.vsm_cByClassificationNum; vegetableSpeciesMaster.vsm_iNurseryStage = infoObject.vsm_iNurseryStage; vegetableSpeciesMaster.vsm_iGrowingPeriod = infoObject.vsm_iGrowingPeriod; vegetableSpeciesMaster.vsm_iPickingPeriod = infoObject.vsm_iPickingPeriod; vegetableSpeciesMaster.vsm_iAcreYield = infoObject.vsm_iAcreYield; vegetableSpeciesMaster.vsm_iPlastochron = infoObject.vsm_iPlastochron; vegetableSpeciesMaster.vsm_cRemark = infoObject.vsm_cRemark; vegetableSpeciesMaster.vsm_dLastDate = DateTime.Now; vegetableSpeciesMaster.vsm_cLast = infoObject.vsm_cLast; this.UpdateVegetableSpeciesTransactionTime(db, infoObject.VegetableSpeciesTransactionTimes); db.SubmitChanges(); isSuccess = true; } } } catch (Exception Ex) { throw Ex; } } return(isSuccess); }