/// <summary> /// 创建概括性大项目信息 /// </summary> /// <param name="projectinfo"></param> /// <returns></returns> public YC.SQLServerDAL.ProjectInfo CreateProjectInfo(YC.SQLServerDAL.ProjectInfo projectinfo) { if (projectinfo != null) { projectinfo.ProjectId = Guid.NewGuid(); dbContext.ProjectInfo.InsertOnSubmit(projectinfo); dbContext.SubmitChanges(); } return(projectinfo); }
/// <summary> /// 创建子项目信息 /// </summary> /// <param name="subprojectinfo"></param> /// <returns></returns> public YC.SQLServerDAL.SubProjectInfo NewSubProjectInfo(YC.SQLServerDAL.SubProjectInfo subprojectinfo) { if (subprojectinfo != null) { subprojectinfo.SubProId = Guid.NewGuid(); dbContext.SubProjectInfo.InsertOnSubmit(subprojectinfo); dbContext.SubmitChanges(); } return(subprojectinfo); }
/// <summary> /// 获取已认证并登记进微信企业号中的人员数。 /// </summary> /// <returns></returns> //public int GetIsQYUser_Sum() //{ // return dbContext.Stuff.Where(o => o.IsQYUser == true).Count(); //} #endregion public YC.SQLServerDAL.Stuff NewStuff(YC.SQLServerDAL.Stuff user) { if (user != null) { if (!ExistUser(user.JobNumber)) { user.SId = Guid.NewGuid(); dbContext.Stuff.InsertOnSubmit(user); dbContext.SubmitChanges(); } } return(user); }
/// <summary> /// 创建新公司(此公司为安装设备的所在单位) /// </summary> /// <returns></returns> public YC.SQLServerDAL.Corporation NewCorporation(YC.SQLServerDAL.Corporation corp) { if (corp != null) { if (!ExistCorp(corp.CorpName)) { corp.CorpId = Guid.NewGuid(); corp.CreateDate = DateTime.Now; dbContext.Corporation.InsertOnSubmit(corp); dbContext.SubmitChanges(); } } return(corp); }
/// <summary> /// 在数据库中新增计量单位对象。 /// </summary> /// <param name="name">计量单位名称。</param> /// <returns></returns> public YC.SQLServerDAL.Jldw CreateJldw(string name) { var jldw = new YC.SQLServerDAL.Jldw(); jldw.JLDWID = Guid.NewGuid(); jldw.Name = name; jldw.OrderIndex = 0; if (!ExistJldw(jldw.Name)) { dbContext.Jldw.InsertOnSubmit(jldw); dbContext.SubmitChanges(); } return(jldw); }
/// <summary> /// 新增单位体系信息 /// </summary> /// <param name="dwtx"></param> /// <returns></returns> public YC.SQLServerDAL.Dwtx NewDwtx(YC.SQLServerDAL.Dwtx dwtx) { if (dwtx != null) { dbContext.Dwtx.InsertOnSubmit(dwtx); dbContext.SubmitChanges(); } return(dwtx); }
/// <summary> /// 新增订单详细信息 /// </summary> /// <param name="odinfo"></param> /// <returns></returns> public YC.SQLServerDAL.OrderDetailInfo NewOrderDetailInfo(YC.SQLServerDAL.OrderDetailInfo odinfo) { if (odinfo != null) { odinfo.ODId = Guid.NewGuid(); dbContext.OrderDetailInfo.InsertOnSubmit(odinfo); dbContext.SubmitChanges(); } return(odinfo); }
/// <summary> /// 新增物料信息 /// </summary> /// <param name="odinfo"></param> /// <returns></returns> public YC.SQLServerDAL.ODMaterialdetail NewODMaterialdetail(YC.SQLServerDAL.ODMaterialdetail odmaterial) { if (odmaterial != null) { odmaterial.ODMId = Guid.Empty; odmaterial.ODMId = Guid.NewGuid(); dbContext.ODMaterialdetail.InsertOnSubmit(odmaterial); dbContext.SubmitChanges(); } return(odmaterial); }