/// <summary>
/// 更新标书的状态
/// </summary>
/// <param name="strITBDocumentID">标书的IDKey</param>
/// <param name="State">状态，本处应该为3（开标阶段）</param>
/// <returns>错误信息</returns>
public string SetITBDocumentState(string strITBDocumentID, int State)
{
string strErrorMsg = string.Empty;
string UpdateSql = "UPDATE ITBDocument SET State = " + State + " WHERE ITBIDKey = '" + strITBDocumentID + "'";
strErrorMsg = _da.ExecuteDMLSQL(UpdateSql);
return(strErrorMsg);
}
public string UpdateFlowContractState(string sIDKey, string sTenderID, TenderState enState)
{
int nState = (int)enState;
string sError = string.Empty;
string UpdateSql = "Update Contract set State = " + nState + " where IDKey = '" + sIDKey + "'";
sError += _da.ExecuteDMLSQL(UpdateSql);
sError += pEntityUitlity.UpdateITBDocumentState(sTenderID, enState);
return(sError);
}
public string UpdateMRStatus(string sStatus, string sTenderID, string sName)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("Update TCStrategy SET Status = '" + sStatus + "' WHERE TenderID='" + sTenderID + "'; ");
sb.Append("Update MR_MRStrategy SET Status = '" + sStatus + "' WHERE TenderID='" + sTenderID + "'; ");
sb.Append("Update MR_MaterialRequisition SET Status = '" + sStatus + "' ");
sb.Append("where MRID = (Select MRID From MR_Material Inner Join MR_MRStrategy On MR_MRStrategy.MRMaterialID = MR_Material.MRMaterialID ");
sb.Append("where tenderid='" + sTenderID + "' And MR_MaterialRequisition.ReceiveBy='" + sName + "')");
return(_da.ExecuteDMLSQL(sb.ToString()));
}
/// <summary>
/// 回写招标计划表中的"发标时间"
/// </summary>
/// <returns>错误信息</returns>
public string SetTenderSendDate(string strTendorIDKey, string TendorSendDate)
{
string UpdateSql = "UPDATE TCStrategyPlan SET PlanBeginDate = '" + TendorSendDate + "' WHERE TenderID = '" + strTendorIDKey + "'";
return(_da.ExecuteDMLSQL(UpdateSql));
}