public void Add(cn.justwin.BLL.ProgressManagement.Version entity) { if (entity != null) { using (pm2Entities entities = new pm2Entities()) { plus_progress_version _version = new plus_progress_version { ProgressVersionId = entity.ProgressVersionId, ParentVersionId = entity.ParentVersionId, VersionCode = entity.VersionCode, VersionName = entity.VersionName, FlowState = new int?(entity.FlowState), InputDate = new DateTime?(entity.InputDate), IsLatest = new bool?(entity.IsLatest), Note = entity.Note, PT_yhmc = (from m in entities.PT_yhmc where m.v_yhdm == entity.InputUser select m).FirstOrDefault <PT_yhmc>(), plus_progress = (from m in entities.plus_progress where m.ProgressId == entity.ProgressId select m).FirstOrDefault <plus_progress>() }; entities.AddToplus_progress_version(_version); entities.SaveChanges(); } } }
public string AddModifyApply(cn.justwin.BLL.ProgressManagement.Version entity) { string str = Guid.NewGuid().ToString(); StringBuilder builder = new StringBuilder(); builder.Append("\r\n INSERT INTO plus_progress_version(ProgressVersionId,ProgressId,ParentVersionId,VersionName,\r\n\t VersionCode,FlowState,IsLatest,InputUser,InputDate,Note)\r\n VALUES (@newVerId,@progressId,@parVerId,@name,@version,'-1','0',@user,getdate(),@note)"); builder.AppendLine(); builder.Append("\r\n INSERT INTO Plus_BackProject(ProjectGuid,Start,Finish,Calendars)\r\n SELECT @newVerId,Start,Finish,Calendars FROM Plus_BackProject WHERE ProjectGuid=@parVerId"); builder.AppendLine(); builder.Append("\r\n INSERT INTO plus_task (UID_,ID_ ,NAME_ ,START_ ,FINISH_ ,DURATION_ ,WORK_ ,PERCENTCOMPLETE_ ,WEIGHT_ ,CONSTRAINTTYPE_ ,\r\n CONSTRAINTDATE_ ,MILESTONE_ ,SUMMARY_ ,CRITICAL_ ,PRIORITY_ ,NOTES_ ,DEPARTMENT_ ,PRINCIPAL_ ,PREDECESSORLINK_ ,FIXEDDATE_ ,\r\n PARENTTASKUID_ ,PROJECTUID_ ,ACTUALSTART_ ,ACTUALFINISH_ ,ACTUALDURATION_ ,ASSIGNMENTS_ ,WBS_ ,CRITICAL2_ )\r\n SELECT UID_ ,ID_ ,NAME_ ,START_ ,FINISH_ ,DURATION_ ,WORK_ ,PERCENTCOMPLETE_ , WEIGHT_ ,CONSTRAINTTYPE_ ,CONSTRAINTDATE_ ,\r\n MILESTONE_ ,SUMMARY_ ,CRITICAL_ ,PRIORITY_ ,NOTES_ ,DEPARTMENT_ ,PRINCIPAL_ , PREDECESSORLINK_ ,FIXEDDATE_ ,PARENTTASKUID_ ,\r\n @newVerId ,ACTUALSTART_ ,ACTUALFINISH_ ,ACTUALDURATION_ ,ASSIGNMENTS_ , WBS_ ,CRITICAL2_ FROM plus_task \r\n WHERE PROJECTUID_=@parVerId"); string inputUser = entity.InputUser; SqlParameter parameter = new SqlParameter { ParameterName = "@user" }; if (string.IsNullOrEmpty(inputUser)) { parameter.Value = DBNull.Value; } else { parameter.Value = inputUser; } SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@newVerId", str), new SqlParameter("@progressId", entity.ProgressId), new SqlParameter("@parVerId", entity.ProgressVersionId), new SqlParameter("@name", entity.VersionName), new SqlParameter("@version", entity.VersionCode), parameter, new SqlParameter("@note", entity.Note) }; SqlHelper.ExecuteNonQuery(CommandType.Text, builder.ToString(), commandParameters); return(str); }
public static cn.justwin.BLL.ProgressManagement.Version GetById(string verId) { cn.justwin.BLL.ProgressManagement.Version result; using (pm2Entities context = new pm2Entities()) { cn.justwin.BLL.ProgressManagement.Version pversion = ( from m in context.plus_progress_version where m.ProgressVersionId == verId select new cn.justwin.BLL.ProgressManagement.Version { ProgressVersionId = m.ProgressVersionId, ProgressId = m.plus_progress.ProgressId, VersionName = m.VersionName, VersionCode = m.VersionCode, InputUser = m.PT_yhmc.v_yhdm, Note = m.Note, FlowState = m.FlowState ?? -1, InputDate = (System.DateTime)m.InputDate, IsLatest = (bool)m.IsLatest, ParentVersionId = m.ParentVersionId }).FirstOrDefault <cn.justwin.BLL.ProgressManagement.Version>(); result = pversion; } return(result); }