public int InsertItarmCrListCo(ItarmCrListCo itarmCrListCo)
{
int returnSerial = 0;
try
{
object obj = m_PMSSqlConnection.Insert("InsertItarmCrListCo", itarmCrListCo);
if (obj != null)
{
returnSerial = (int)obj;
}
}
catch (Exception ex)
{
m_Logger.Error("ItArmCrListBiz/InsertItarmCrListCo" + ex.ToString());
}
return(returnSerial);
}
public bool InsertFormalCrNo(string formalCrNo, string tempCrNo, out string infor)
{
infor = string.Empty;
try
{
//临时CR改为正式的CR有两种情况：协同CR,正常CR
if (formalCrNo.Length > 11)
{
IList <ItarmCrListCo> itarmCrListCo = m_PMSSqlConnection.QueryForList <ItarmCrListCo>("SelectItarmCrListCo", new Hashtable {
{ "CrId", formalCrNo }
});
if (itarmCrListCo != null && itarmCrListCo.Count > 0 && itarmCrListCo.FirstOrDefault().CrId != string.Empty)
{
//FormalCrNo exists 只需要删除临时的CrNo，不需要插入正式的CrNo
if (!DeleteItarmCrList(tempCrNo, out infor))
{
m_PMSSqlConnection.RollBackTransaction();
return(false);
}
}
else
{
//取出临时CR的信息
IList <ItarmCrList> itarmCrList = m_PMSSqlConnection.QueryForList <ItarmCrList>("SelectItarmCrList", tempCrNo);
if (itarmCrList != null && itarmCrList.Count > 0)
{
ItarmCrListCo ItarmCrListCoInsert = new ItarmCrListCo();
if (formalCrNo.IndexOf('_') != -1)
{
if (formalCrNo.Split('_')[0] != string.Empty)//formalCrNo以‘_’开始的情况
{
ItarmCrListCoInsert.RelatedcrId = formalCrNo.Split('_')[0];
}
else
{
ItarmCrListCoInsert.RelatedcrId = formalCrNo;
}
}
else
{
ItarmCrListCoInsert.RelatedcrId = formalCrNo;
}
ItarmCrListCoInsert.RelatedcrName = string.Empty;
ItarmCrListCoInsert.RelatedSite = itarmCrList.FirstOrDefault().Site;
ItarmCrListCoInsert.CrId = formalCrNo;
ItarmCrListCoInsert.CrName = itarmCrList.FirstOrDefault().CrName;
ItarmCrListCoInsert.Pm = itarmCrList.FirstOrDefault().Pm;
ItarmCrListCoInsert.System = itarmCrList.FirstOrDefault().System;
ItarmCrListCoInsert.Creator = itarmCrList.FirstOrDefault().Creator;
ItarmCrListCoInsert.CreateDate = itarmCrList.FirstOrDefault().CreateDate;
m_PMSSqlConnection.Insert("InsertItarmCrListCo", ItarmCrListCoInsert);
}
if (!DeleteItarmCrList(tempCrNo, out infor))
{
m_PMSSqlConnection.RollBackTransaction();
return(false);
}
}
}
else
{
IList <ItarmCrList> itarmCrListCo = m_PMSSqlConnection.QueryForList <ItarmCrList>("SelectItarmCrList", formalCrNo);
if (itarmCrListCo != null && itarmCrListCo.Count > 0 && itarmCrListCo.FirstOrDefault().CrId != string.Empty)
{
//FormalCrNo exists 只需要删除临时的CrNo，不需要插入正式的CrNo
if (!DeleteItarmCrList(tempCrNo, out infor))
{
m_PMSSqlConnection.RollBackTransaction();
return(false);
}
}
else
{
IList <ItarmCrList> listItarmCrList = m_PMSSqlConnection.QueryForList <ItarmCrList>("SelectItarmCrList", tempCrNo);
if (listItarmCrList != null && listItarmCrList.Count > 0)
{
listItarmCrList.FirstOrDefault().CrId = formalCrNo;
m_PMSSqlConnection.Update("UpdateItarmCrList", listItarmCrList.FirstOrDefault());
}
if (!DeleteItarmCrList(tempCrNo, out infor))
{
m_PMSSqlConnection.RollBackTransaction();
return(false);
}
}
}
return(true);
}
catch (Exception ex)
{
m_Logger.Error("CRNoUpdateBiz/UpDateCrIdPmsId:" + ex.Message.ToString());
infor = "Insert failed!";
return(false);
}
}
public int InsertFromItarmRequirement(string oldCrId, string newCrId)
{
ItarmCrList itarmCrListInsert = new ItarmCrList();
ItarmCrListCo itarmCrListCoInsert = new ItarmCrListCo();
ItarmCrListBiz itarmCrListBiz = new ItarmCrListBiz();
PmsItarmMappingBiz pmsItarmMappingBiz = new PmsItarmMappingBiz();
string creator = "Itarm";
DateTime createDate = System.DateTime.Now;
int returnSerial = 0;
try
{
#region Deal Requirement
IList <SdpSys> sdpSysList = m_ITARMSqlConnection.QueryForList <SdpSys>("SelectRequirementList", newCrId);
if (sdpSysList != null && sdpSysList.Count > 0)
{
// 插到itarm_CR_List
m_PMSSqlConnection.BeginTransaction();
#region Insert itarm_cr_list
if (sdpSysList[0].CrId.ToString().Trim().Length > 15)
{
itarmCrListInsert.CrId = sdpSysList[0].CrId.ToString().Trim().Substring(0, 15);
}
else
{
itarmCrListInsert.CrId = sdpSysList[0].CrId.ToString().Trim();
}
if (sdpSysList[0].CRName.ToString().Trim().Length > 500)
{
itarmCrListInsert.CrName = sdpSysList[0].CRName.ToString().Trim().Substring(0, 500);
}
else
{
itarmCrListInsert.CrName = sdpSysList[0].CRName.ToString().Trim();
}
if (sdpSysList[0].Site.ToString().Trim().Length > 20)
{
itarmCrListInsert.Site = sdpSysList[0].Site.ToString().Trim().Substring(0, 20);
}
else
{
itarmCrListInsert.Site = sdpSysList[0].Site.ToString().Trim();
}
itarmCrListInsert.Creator = creator;
itarmCrListInsert.CreateDate = createDate;
if (sdpSysList[0].SystemName.ToString().Trim().Length > 100)
{
itarmCrListInsert.System = sdpSysList[0].SystemName.ToString().Trim().Substring(0, 100);
}
else
{
itarmCrListInsert.System = sdpSysList[0].SystemName.ToString().Trim();
}
if (sdpSysList[0].PM.ToString().Trim().Length > 100)
{
itarmCrListInsert.Pm = sdpSysList[0].PM.ToString().Trim().Substring(0, 100);
}
else
{
itarmCrListInsert.Pm = sdpSysList[0].PM.ToString().Trim();
}
int returnInsertResult = itarmCrListBiz.InsertItarmCrList(itarmCrListInsert);
if (returnInsertResult <= 0)
{
m_PMSSqlConnection.RollBackTransaction();
return(returnSerial);
}
#endregion
// 并更新PMS_Itarm_Mapping
#region Update PMS_ITARM_Mapping
bool mappingResult = pmsItarmMappingBiz.UpdatePmsItarmMappingCrId(oldCrId, newCrId);
if (mappingResult == false)
{
m_PMSSqlConnection.RollBackTransaction();
return(returnSerial);
}
#endregion
m_PMSSqlConnection.CommitTransaction();
returnSerial = 1;
}
#endregion
}
catch (Exception ex)
{
m_Logger.Error("ItArmCrListBiz/InsertFromItarmCr" + ex.ToString());
return(returnSerial);
}
try
{
#region Deal Requirement_Co
IList <SdpSys> sdpSysList = m_ITARMSqlConnection.QueryForList <SdpSys>("SelectRequirementCoList", newCrId);
if (sdpSysList != null && sdpSysList.Count > 0)
{
// 插到itarm_CR_List
m_PMSSqlConnection.BeginTransaction();
#region Insert itarm_cr_list
if (sdpSysList[0].CrId.ToString().Trim().Length > 15)
{
itarmCrListCoInsert.CrId = sdpSysList[0].CrId.ToString().Trim().Substring(0, 15);
}
else
{
itarmCrListCoInsert.CrId = sdpSysList[0].CrId.ToString().Trim();
}
if (sdpSysList[0].CrId_co.ToString().Trim().Length > 15)
{
itarmCrListCoInsert.RelatedcrId = sdpSysList[0].CrId_co.ToString().Trim().Substring(0, 15);
}
else
{
itarmCrListCoInsert.RelatedcrId = sdpSysList[0].CrId_co.ToString().Trim();
}
if (sdpSysList[0].CRName.ToString().Trim().Length > 500)
{
itarmCrListCoInsert.CrName = sdpSysList[0].CRName.ToString().Trim().Substring(0, 500);
}
else
{
itarmCrListCoInsert.CrName = sdpSysList[0].CRName.ToString().Trim();
}
if (sdpSysList[0].CRName_co.ToString().Trim().Length > 100)
{
itarmCrListCoInsert.RelatedcrName = sdpSysList[0].CRName_co.ToString().Trim().Substring(0, 100);
}
else
{
itarmCrListCoInsert.RelatedcrName = sdpSysList[0].CRName_co.ToString().Trim();
}
if (sdpSysList[0].Site.ToString().Trim().Length > 20)
{
itarmCrListCoInsert.RelatedSite = sdpSysList[0].Site.ToString().Trim().Substring(0, 20);
}
else
{
itarmCrListCoInsert.RelatedSite = sdpSysList[0].Site.ToString().Trim();
}
itarmCrListCoInsert.Creator = creator;
itarmCrListCoInsert.CreateDate = createDate;
if (sdpSysList[0].SystemName.ToString().Trim().Length > 100)
{
itarmCrListCoInsert.System = sdpSysList[0].SystemName.ToString().Trim().Substring(0, 100);
}
else
{
itarmCrListCoInsert.System = sdpSysList[0].SystemName.ToString().Trim();
}
if (sdpSysList[0].PM.ToString().Trim().Length > 100)
{
itarmCrListCoInsert.Pm = sdpSysList[0].PM.ToString().Trim().Substring(0, 100);
}
else
{
itarmCrListCoInsert.Pm = sdpSysList[0].PM.ToString().Trim();
}
int returnInsertResult = itarmCrListBiz.InsertItarmCrListCo(itarmCrListCoInsert);
if (returnInsertResult <= 0)
{
m_PMSSqlConnection.RollBackTransaction();
return(returnSerial);
}
#endregion
// 并更新PMS_Itarm_Mapping
#region Update PMS_ITARM_Mapping
bool mappingResult = pmsItarmMappingBiz.UpdatePmsItarmMappingCrId(oldCrId, newCrId);
if (mappingResult == false)
{
m_PMSSqlConnection.RollBackTransaction();
return(returnSerial);
}
#endregion
m_PMSSqlConnection.CommitTransaction();
returnSerial = 1;
}
#endregion
return(returnSerial);
}
catch (Exception ex)
{
m_Logger.Error("ItArmCrListBiz/InsertFromItarmCrCo" + ex.ToString());
return(returnSerial);
}
}
