public bool InsertCopyFromDevelopment(IList <SdpDetail> pmsSdpDetailIlist, string strPmsID, string strUser)
{
DateTime dateTime = PmsSysBiz.GetDBDateTime();
PmsCommonBiz pmsCommonBiz = new PmsCommonBiz();
try
{
m_PMSSqlConnection.BeginTransaction();
for (int i = 0; i < pmsSdpDetailIlist.Count; i++)
{
SdpDetail pmsSdpDetail = new SdpDetail();
pmsSdpDetail.Pmsid = strPmsID;
pmsSdpDetail.TaskName = pmsSdpDetailIlist[i].TaskName;
pmsSdpDetail.Phase = PmsCommonEnum.EnumSdpPhase.Test.ToString();
pmsSdpDetail.Role = pmsSdpDetailIlist[i].Role;
pmsSdpDetail.Resource = pmsSdpDetailIlist[i].Resource;
pmsSdpDetail.Taskno = int.Parse(pmsSdpDetailIlist[i].Taskno.ToString());
pmsSdpDetail.Plancost = double.Parse(pmsSdpDetailIlist[i].Plancost.ToString());
pmsSdpDetail.Actualcost = double.Parse(pmsSdpDetailIlist[i].Actualcost.ToString());
pmsSdpDetail.Completedpercent = double.Parse(pmsSdpDetailIlist[i].Completedpercent.ToString());
pmsSdpDetail.Planstartday = pmsSdpDetailIlist[i].Planstartday;
pmsSdpDetail.Planendday = pmsSdpDetailIlist[i].Planendday;
pmsSdpDetail.Actualstartday = pmsCommonBiz.ConvertDateTime("");
pmsSdpDetail.Actualendday = pmsCommonBiz.ConvertDateTime("");
pmsSdpDetail.PretaskNo = int.Parse(pmsSdpDetailIlist[i].PretaskNo.ToString());
pmsSdpDetail.Remark = pmsSdpDetailIlist[i].Remark;
pmsSdpDetail.Iseditable = "Y";
pmsSdpDetail.Deleteflag = "N";
pmsSdpDetail.Createdate = dateTime;
pmsSdpDetail.Createuser = strUser;
pmsSdpDetail.Maintaindate = dateTime;
pmsSdpDetail.Maintainuser = strUser;
int insertResult = InsertSdpDetail(pmsSdpDetail);
if (insertResult <= 0)
{
m_PMSSqlConnection.RollBackTransaction();
return(false);
}
}
m_PMSSqlConnection.CommitTransaction();
return(true);
}
catch (Exception ex)
{
m_PMSSqlConnection.RollBackTransaction();
m_Logger.Error("SdpDetailBiz/InsertFromCopyFromDevelopment:" + ex.Message.ToString());
return(false);
}
}
public void GetMinId(out string minId)
{
DateTime createDateTime = PmsSysBiz.GetDBDateTime();
string creatDate = PmsCommonBiz.FormatDate(createDateTime, "yyyyMMdd");
//获取minId
string tempMinIdPart = "MN" + creatDate;
IList <PmsMinHead> pmsMinHeadList = SelectPmsMinHeadByMinIdPart(tempMinIdPart);
if (pmsMinHeadList != null && pmsMinHeadList.Count > 0)
{
//取最大的记录加1
int maxCrIdNum = int.Parse(pmsMinHeadList[pmsMinHeadList.Count - 1].Mnid.Substring(9, 4));
int tempCrIdNum;
for (int j = 0; j < pmsMinHeadList.Count; j++)
{
tempCrIdNum = int.Parse(pmsMinHeadList[j].Mnid.Substring(9, 4));
if (maxCrIdNum < tempCrIdNum)
{
maxCrIdNum = tempCrIdNum;
}
}
maxCrIdNum = maxCrIdNum + 1;
string crIdNum = maxCrIdNum.ToString();
//不足四位补“0”
while (crIdNum.Length < 4)
{
crIdNum = "0" + crIdNum;
}
//do
//{
// crIdNum = "0" + crIdNum;
//} while (crIdNum.Length < 4);
minId = tempMinIdPart + crIdNum;
}
else
{
minId = tempMinIdPart + "0001";
}
}