/// <summary>
/// 不需要更新直接插入即可
/// </summary>
/// <param name="extendColumnProjectData"></param>
public void SaveExtendColumnProjectData(ExtendColumnProjectData extendColumnProjectData)
{
extendColumnProjectData.InDateTime = DateTime.Now;
extendColumnProjectData.ModifyDateTime = DateTime.Now;
db.ExtendColumnProjectData.Add(extendColumnProjectData);
db.SaveChanges();
}
public APIResult SaveExtendColumnProjectData(ExtendColumnProjectData extendColumnProjectData)
{
try
{
List <ExtendColumnProjectDataDto> list = masterService.GetExtendColumnProjectData(extendColumnProjectData.ProjectId.ToString(), extendColumnProjectData.ColumnCode, extendColumnProjectData.ColumnValue);
if (list != null && list.Count > 0)
{
return(new APIResult()
{
Status = false, Body = "数据重复"
});
}
masterService.SaveExtendColumnProjectData(extendColumnProjectData);
return(new APIResult()
{
Status = true, Body = ""
});
}
catch (Exception ex)
{
return(new APIResult()
{
Status = false, Body = ex.Message.ToString()
});
}
}
public void DeleteExtendColumnProjectData(ExtendColumnProjectData extendColumnProjectData)
{
string sql = "DELETE ExtendColumnProjectData WHERE ProjectId = '" + extendColumnProjectData.ProjectId.ToString() + "'";
sql += " AND ColumnCode = '" + extendColumnProjectData.ColumnCode + "'";
sql += " AND ColumnValue = '" + extendColumnProjectData.ColumnValue + "'";
SqlParameter[] para = new SqlParameter[] { };
db.Database.ExecuteSqlCommand(sql, para);
}
public APIResult DeleteExtendColumnProjectData(ExtendColumnProjectData extendColumnProjectData)
{
try
{
masterService.DeleteExtendColumnProjectData(extendColumnProjectData);
return(new APIResult()
{
Status = true, Body = ""
});
}
catch (Exception ex)
{
return(new APIResult()
{
Status = false, Body = ex.Message.ToString()
});
}
}
