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