public string InsertLogistics(DataTable dt)
{
string strSql = @"Insert into MR_SDT_Logistics_Tracking (IDKey,SDTNO,Recvby,RecvDate,PONO,TotalValue,SOContractNo,ServerSupplier)
Values('" + System.Guid.NewGuid().ToString() + "','" + dt.Rows[0]["MR_SDT_Logistics.SDTNo"].ToString() + "','" + dt.Rows[0]["MR_SDT_Logistics.receivedBy"].ToString() + "','" + Convert.ToDateTime(dt.Rows[0]["MR_SDT_Logistics.receivedDate"]).ToString("yyyy-MM-dd") + "','" + dt.Rows[0]["MR_SDT_Logistics.POID"].ToString()
+ "'," + Convert.ToDecimal(dt.Rows[0]["MR_SDT_Logistics.TotalValueStand"]).ToString("f8") + ",'" + dt.Rows[0]["MR_SDT_Logistics.SOContractNo"].ToString() + "','" + dt.Rows[0]["MR_SDT_Logistics.VendorID"].ToString() + "')";
return(_da.ExecuteDMLSQL(strSql));
}
public string InsertMaterialVendor(string sItemCode, string sMaterialName, string sVendorID, string sComment, string sVendorName)
{
string errorMessage = "";
string sSql = "insert into WH_MaterialVendor(MaterialVendorID,ItemCode,VendorID,MaterialName,Comment,VendorName) values ('" + System.Guid.NewGuid().ToString() + "'," +
"'" + sItemCode + "','" + sVendorID + "','" + sMaterialName + "','" + sComment + "','" + sVendorName + "')";
errorMessage = _da.ExecuteDMLSQL(sSql);
return(errorMessage);
}
public string UpdateNoFlowTenderState(string sIDkey, int nState)
{
string sError = string.Empty;
string UpdateSql = "Update Contract set State = " + nState + " where IDKey = '" + sIDkey + "'";
sError += _da.ExecuteDMLSQL(UpdateSql);
UpdateSql = "UPDATE ServiceRequistion SET SRState = " + nState + " FROM ServiceRequistion SR JOIN ContractRequistion CR ON SR.IDKey = CR.SRIDKey AND CR.ContractID ='" + sIDkey + "'";
sError += _da.ExecuteDMLSQL(UpdateSql);
return(sError);
}
/// <summary>
/// 更新SR的状态
/// </summary>
/// <param name="strITBDocumentID">标书的IDKey</param>
/// <param name="State">状态，本处应该为3（开标阶段）</param>
/// <returns>错误信息</returns>
public void SetTenderState(string strITBDocumentID)
{
string strSql = "SELECT TenderID FROM ITBDocument WHERE ITBIDKey = '" + strITBDocumentID + "'";
string sTendorID = _da.GetDataTable(strSql).Rows[0][0].ToString();
string strErrorMsg = string.Empty;
if (sTendorID != "")
{
ceu.UpdateStrategyState(sTendorID, TenderState.State_ITBTechOpen);
string UpdateSql = "UPDATE ITBDocument SET State = " + (int)TenderState.State_ITBTechOpen + " WHERE ITBIDKey = '" + strITBDocumentID + "'";
strErrorMsg = _da.ExecuteDMLSQL(UpdateSql);
}
}
/// <summary>
/// 按照对应的SRID或者SRIDKey来更新的技术评标的状态
/// </summary>
/// <param name="SRIDOrSRIDKey">SRID或者SRIDKey</param>
/// <param name="srState">SR状态</param>
/// <param name="iState">0为使用SRID进行更新,1为使用SRIDKey进行更新,2为使用本身的IDKey进行更新</param>
public void UpdateCommEvaluationState(string SRIDOrSRIDKey, TenderState srState, int iState)
{
string UpdateSql = string.Empty;
switch (iState)
{
case 0:
{
UpdateSql = "UPDATE CommEvaluation SET CommEvaluation.State = " + (int)srState + @" WHERE CommEvaluation.IDKey in (SELECT CommEvaluation.IDKey FROM CommEvaluation , TCStrategy , ServiceRequistion
WHERE TCStrategy.SRIDKey = ServiceRequistion.IDKey AND TCStrategy.TenderID = CommEvaluation.TenderID
AND ServiceRequistion.SRID = '" + SRIDOrSRIDKey + "')";
break;
}
case 1:
{
UpdateSql = "UPDATE CommEvaluation SET CommEvaluation.State = " + (int)srState + @" WHERE CommEvaluation.IDKey in (SELECT CommEvaluation.IDKey FROM CommEvaluation , TCStrategy , ServiceRequistion
WHERE TCStrategy.SRIDKey = ServiceRequistion.IDKey AND TCStrategy.TenderID = CommEvaluation.TenderID
AND ServiceRequistion.IDKey = '" + SRIDOrSRIDKey + "')";
break;
}
case 2:
{
UpdateSql = @"UPDATE CommEvaluation SET CommEvaluation.State = " + (int)srState + " WHERE CommEvaluation.IDKey = '" + SRIDOrSRIDKey + "'";
break;
}
}
if (UpdateSql.Length > 0)
{
_da.ExecuteDMLSQL(UpdateSql);
}
}
/// <summary>
/// 更新提交表中记录的状态
/// </summary>
/// <param name="iState">目标状态</param>
/// <param name="strPutInIDKey">需要更新的记录ID</param>
/// <returns></returns>
public string UpDatePutInState(int iState, string strPutInIDKey)
{
string strErrorMsg = string.Empty;
string UpdateSql = "UPDATE PutIn Set state = " + iState + " WHERE IDKey = '" + strPutInIDKey + "'";
strErrorMsg = _da.ExecuteDMLSQL(UpdateSql);
return(strErrorMsg);
}
public void ResumptionLastExchangeRate(string pkName)
{
DataTable dt = new DataTable();
string sSql = "Select CurrencyIDFrom, CurrencyIDTo From BI_CurrencyExchangeRate Where IDKey = '" + pkName + "' And Status = '0'";
dt = da.GetDataTable(sSql);
if (dt != null && dt.Rows.Count > 0)
{
string strCurrencyIDFrom = string.Empty;
string strCurrencyIDTo = string.Empty;
strCurrencyIDFrom = dt.Rows[0][0].ToString();
strCurrencyIDTo = dt.Rows[0][1].ToString();
StringBuilder sb = new StringBuilder();
sb.Append("Update BI_CurrencyExchangeRate Set Status = '0' ");
sb.Append(" Where Status = '1' And CurrencyIDFrom='" + strCurrencyIDFrom + "' And CurrencyIDTo ='" + strCurrencyIDTo + "'");
sb.Append(" And DateFrom = ( Select Top 1 DateFrom From BI_CurrencyExchangeRate B Where CurrencyIDFrom = '" + strCurrencyIDFrom + "' And CurrencyIDTo = '" + strCurrencyIDTo + "' And Status = '1' Order By DateFrom DESC)");
da.ExecuteDMLSQL(sb.ToString());
}
}
/// <summary>
/// 继承了基类的保存方法，并使用了排他方式进行更新其他的记录
/// </summary>
/// <returns></returns>
public override string Save()
{
// 错误信息
string ErrorMessage = string.Empty;
if (CurDataTable.Rows.Count > 0)
{
ErrorMessage = base.Save();
// 如果此行为有效密封标,则将其他数据有效性置为否
if (Convert.ToInt32(CurDataTable.Rows[0]["TI_SealConfig.IsValid"]) == 1)
{
string UpdateSql = "UPDATE TI_SealConfig SET IsValid = 0 WHERE IDKey <> '" + Convert.ToString(CurDataTable.Rows[0]["TI_SealConfig.IDKey"]) + "'";
if (ErrorMessage == "")
{
ErrorMessage += _da.ExecuteDMLSQL(UpdateSql);
}
}
}
return(ErrorMessage);
}
// /// <summary>
// /// 通过招标公告的ID来获得:服务申请编号,合同模式,采办策略编号,项目名称
// /// </summary>
// /// <param name="publishID"></param>
// /// <returns></returns>
// public Hashtable GetDetailByPublishID ( string publishID )
// {
// string SelectSql = "SELECT TCStrategy.SRID , TCStrategy.ContractMode , TCStrategy.ProjectName , TCStrategy.TenderID FROM TCStrategy JOIN BidPlacard on TCStrategy.TenderID = BidPlacard.TenderID WHERE BidPlacard.PublishID = '"+publishID+"'";
//
// Hashtable hashtable = new Hashtable();
//
// using ( System.Data.SqlClient.SqlDataReader dr = _da.GetDataReader ( SelectSql ) )
// {
// while ( dr.Read() )
// {
// hashtable.Add ( "SRID" , Convert.ToString ( dr["SRID"] ));
// hashtable.Add ( "ContractMode" , Convert.ToString ( dr["ContractMode"] ) );
// hashtable.Add ( "ProjectName" , Convert.ToString ( dr["ProjectName"] ) );
// hashtable.Add ( "TenderID" , Convert.ToString ( dr["TenderID"] ));
// }
// }
//
// return hashtable ;
// }
/// <summary>
/// 更新招标公告的状态
/// </summary>
/// <param name="TenderState"></param>
/// <param name="IDKey"></param>
/// <returns></returns>
public string UpdateState(DataEntity.TenderState state, string PublishID)
{
int nTenderState = (int)state;
return(_da.ExecuteDMLSQL("UPDATE BidPlacard Set State = " + nTenderState + " WHERE PublishID = '" + PublishID + "'"));
}
/// <summary>
/// 更新SR的状态
/// </summary>
/// <param name="State">状态</param>
/// <param name="IDKey">SR主键</param>
public void UpdateTenderState(string IDKey, string State)
{
_da.ExecuteDMLSQL("UPDATE ServiceRequistion SET SRState = '" + State + "'WHERE ServiceRequistion.IDKey = '" + IDKey + "'");
}
/// <summary>
/// 更新物资子表状态
/// </summary>
/// <param name="sMRID"></param>
/// <param name="sStatus"></param>
/// <returns></returns>
public string UpdateMaterialList(string sMRID, string sStatus)
{
string sSql = "Update MR_Material SET Status = '" + sStatus + "' where MRID = '" + sMRID + "'";
return(_da.ExecuteDMLSQL(sSql));
}
