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