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