public static DataSet GetUpdatedData(Int64 KeyID, Int64 CID, Int64 AID, Int32 RID, Int32 RSNID, DateTime ModifiedOn, Int32 UserID) { String msg = ""; DataTable dt = new DataTable(); DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "[Sbsp_GetUpdatedData]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = UserID; cmd.Parameters.Add("@ModifiedOn", SqlDbType.DateTime).Value = ModifiedOn; cmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = RID; cmd.Parameters.Add("@ReasonID", SqlDbType.Int).Value = RSNID; cmd.Parameters.Add("@KeyID", SqlDbType.BigInt).Value = KeyID; cmd.Parameters.Add("@CID", SqlDbType.BigInt).Value = CID; cmd.Parameters.Add("@AID", SqlDbType.BigInt).Value = AID; ds = DataAccess.GetDataSet(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("GetOptimizeData - " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(ds); }
/// <summary> /// Set Report Dates /// </summary> /// <returns></returns> /// public static String SetOldReportDatesData() { String msg = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_SetReportDates"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@enddate", SqlDbType.SmallDateTime).Value = DateTime.Now.Date.AddDays(-3); DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { msg = ex.Message; LogAPI.WriteLog("UpdateProfileAndAccessTokenData - " + ex.Message); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("UpdateProfileAndAccessTokenData - " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(msg); }
/// <summary> /// Update user profile and adevertising token ///<param name="ProfileId">ProfileId</param> ///<param name="AccessToken">AccessToken</param> ///<param name="RefreshToken">RefreshToken</param> ///<param name="TokenType">TokenType</param> ///<param name="ExpiresIn">ExpiresIn</param> /// </summary> /// <returns></returns> public static String UpdateAccessTokenData(int UserID, String AccessToken, String RefreshToken, String TokenType, int ExpiresIn) { String msg = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_UpdateAccessToken"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mppUserId", SqlDbType.Int).Value = UserID; cmd.Parameters.Add("@accessToken", SqlDbType.VarChar).Value = AccessToken; cmd.Parameters.Add("@refreshToken", SqlDbType.VarChar).Value = RefreshToken; cmd.Parameters.Add("@tokenType", SqlDbType.VarChar, 20).Value = TokenType; cmd.Parameters.Add("@countryCode", SqlDbType.Int).Value = 1; cmd.Parameters.Add("@expiresIn", SqlDbType.Int).Value = ExpiresIn; cmd.Parameters.Add("@tokendate", SqlDbType.SmallDateTime).Value = DateTime.Now; cmd.Parameters.Add("@date", SqlDbType.SmallDateTime).Value = DateTime.Now.Date.AddDays(-3); DataAccess.ExecuteCommand(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("UpdateAccessTokenData- MppUserID" + UserID + ": " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(msg); }
public static string UpdateBestSrchTermCampaigns(DataTable dt) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateBestSrchTerm"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UpdateNewCampDt", dt); DataAccess.ExecuteScalarCommand(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateBestSrchTermCampaigns-" + ex.Message); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateBestSrchTermCampaigns-" + ex.Message); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Get the sellers to update their inventory ///<param name="Type">Type</param> /// </summary> /// <returns></returns> public static DataTable GetReportData(ReportStatus?Type, int MaxCount) { String msg = ""; DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_ReportManagement"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@date", SqlDbType.SmallDateTime).Value = DateTime.Now.Date.AddDays(-3); cmd.Parameters.AddWithValue("@type", SqlDbType.Int).Value = (int)Type; cmd.Parameters.AddWithValue("@count", SqlDbType.Int).Value = MaxCount; dt = DataAccess.GetTable(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("GetReportData - " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(dt); }
/// <summary> /// Update AdGroups ///<param name="adgtbl">adgtbl</param> ///<param name="userid">userid</param> ///<param name="reportid">reportid</param> /// </summary> /// <returns></returns> public static String UpdateAdGroupData(DataTable adgtbl, Int32 userid, Int32 reportid) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateAdGroups"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tblAdgroups", adgtbl); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userid; cmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@RecordType", SqlDbType.Int).Value = (int)RecordType.AdGroup; DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateAdGroupData-" + reportid + ": " + ex.Message, userid.ToString()); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateAdGroupData-" + reportid + ": " + ex.Message, userid.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// get best customer search campaigns for creation /// </summary> /// <returns></returns> public static DataSet GetBestSrchTermCampaignsToCreate() { String msg = ""; DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_GetBestSrchTermCampaignsToCreate"; cmd.CommandType = CommandType.StoredProcedure; ds = DataAccess.GetDataSetForBulk(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("GetBestSrchTermCampaignsToCreate - " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(ds); }
/// <summary> /// Update user profile and adevertising token ///<param name="ProfileId">ProfileId</param> ///<param name="AccessToken">AccessToken</param> ///<param name="RefreshToken">RefreshToken</param> ///<param name="TokenType">TokenType</param> ///<param name="ExpiresIn">ExpiresIn</param> /// </summary> /// <returns></returns> public static String UpdateProfileData(int UserID, string ProfileId, String SellerStringId) { String msg = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_UpdateSellerProfile"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@mppUserId", SqlDbType.Int).Value = UserID; cmd.Parameters.Add("@profileId", SqlDbType.VarChar, 100).Value = ProfileId; cmd.Parameters.Add("@sellerStringId", SqlDbType.VarChar, 100).Value = SellerStringId; cmd.Parameters.Add("@modifiedby", SqlDbType.VarChar, 30).Value = "User"; cmd.Parameters.Add("@date", SqlDbType.SmallDateTime).Value = DateTime.Now.Date.AddDays(-3); DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { msg = ex.Message; LogAPI.WriteLog("UpdateProfileData-Profile ID" + ProfileId + ": " + ex.Message); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("UpdateProfileData-Profile ID" + ProfileId + ": " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(msg); }
/// <summary> /// Update the notification of statup email /// </summary> /// <returns></returns> public static String UpdateFirstEmailNotify(Int32 UserID, Int16 status) { String msg = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "UPDATE MppUser set DataImportAlert=@Status,StartDate=@Date,ModifiedOn=@ModifiedOn where MppUserID=@UserID"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = UserID; cmd.Parameters.Add("@Status", SqlDbType.Bit).Value = status; cmd.Parameters.Add("@Date", SqlDbType.SmallDateTime).Value = DateTime.Today; cmd.Parameters.Add("@ModifiedOn", SqlDbType.DateTime).Value = DateTime.Now; DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { msg = ex.Message; LogAPI.WriteLog("UpdateFirstEmailNotify - " + ex.Message, UserID.ToString()); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("UpdateFirstEmailNotify - " + ex.Message, UserID.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(msg); }
/// <summary> /// Update api attempts ///<param name="reportid">reportid</param> ///<param name="reporttype">reporttype</param> /// </summary> /// <returns></returns> public static String UpdateAPIAttemptStatusData(Int32 reportid, int reporttype) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateFailedAttemptStatus"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ReportId", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@Type", SqlDbType.Int).Value = reporttype; cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = DateTime.Now; DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateAPIStatusData-" + reportid + ": " + ex.Message); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateAPIStatusData-" + reportid + ": " + ex.Message); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update UserSkuData ///<param name="reportid">reportid</param> /// </summary> /// <returns></returns> public static String UpdateUserSkuData(Int32 userid, int count, Int64 campId, int status) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateSkuCount"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userid; cmd.Parameters.Add("@Count", SqlDbType.Int).Value = count; cmd.Parameters.Add("@campId", SqlDbType.BigInt).Value = campId; cmd.Parameters.Add("@status", SqlDbType.TinyInt).Value = status; DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateUserSkuData-" + ex.Message, userid.ToString()); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateUserSkuData-" + ex.Message, userid.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update search term Inventory(sales,clicks,spend) ///<param name="Inventorytbl">Inventorytbl</param> ///<param name="userid">userid</param> ///<param name="reportid">reportid</param> ///<param name="status">status</param> /// </summary> /// <returns></returns> public static String UpdateSearchTermInventoryData(DataTable Inventorytbl, Int32 userid, Int32 reportid, ReportStatus status) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateSearchtermInventory"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tblSearchterm", Inventorytbl); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userid; cmd.Parameters.Add("@ReportId", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@Status", SqlDbType.Int).Value = status; cmd.Parameters.Add("@RecordType", SqlDbType.Int).Value = (int)RecordType.SearchTerm; DataAccess.ExecuteScalarCommandForBulk(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateSearchTermInventoryData-" + reportid + ": " + ex.Message, userid.ToString()); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateSearchTermInventoryData-" + reportid + ": " + ex.Message, userid.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update keywords bids or Create negative keywords /// <param name="ReportID">ReportID</param> ///<param name="tbl">tbl</param> ///<param name="Type">Type</param> /// </summary> /// <returns></returns> public static String UpdateOptimizeLogData(Int32 ReportID, DataTable tbl, RecordType Type) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_CreateOptimizeLogReport"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tblOptimizelog", tbl); cmd.Parameters.AddWithValue("@ReportID", ReportID); cmd.Parameters.AddWithValue("@Type", (int)Type); cmd.Parameters.Add("@Date", SqlDbType.SmallDateTime).Value = DateTime.Today; DataAccess.ExecuteScalarCommandForBulk(cmd); return(res); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateOptimizeLogData-" + ReportID + ": " + ex.Message); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateOptimizeLogData-" + ReportID + ": " + ex.Message); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update user optimization processed or not /// <param name="ReportID">ReportID</param> /// </summary> /// <returns></returns> public static String UpdateOptimizeLocalReportProcess(Int32 ReportID, Int32 Status) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"UPDATE Reports set IsLocallyProcessed = @Status, ModifiedOn = @Date where ReportID = @ReportID"; cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@ReportID", ReportID); cmd.Parameters.AddWithValue("@Status", Status); cmd.Parameters.Add("@Date", SqlDbType.SmallDateTime).Value = DateTime.Today; DataAccess.ExecuteScalarCommandForBulk(cmd); return(res); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateOptimizeLocalReportProcess-" + ReportID + ": " + ex.Message); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateOptimizeLocalReportProcess-" + ReportID + ": " + ex.Message); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
public static DataTable GetOptimizeData(RecordType Type) { String msg = ""; DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_GetOptimizedKeysToUpdateOnAmz"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@type", SqlDbType.Int).Value = (int)Type; cmd.Parameters.AddWithValue("@date", SqlDbType.SmallDateTime).Value = DateTime.Today; dt = DataAccess.GetTable(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("GetOptimizeData - " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(dt); }
public static DataTable GetActiveCamapignsByUsers() { String msg = ""; DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"SELECT distinct top 1 t.MppUserID, STUFF((SELECT distinct ',' + CAST(t1.RecordID AS VARCHAR(200)) FROM Campaigns t1 WHERE t.MppUserID = t1.MppUserID AND t1.Active = 1 AND t1.TempSKUCheck = 0 FOR XML PATH(''), TYPE ).value('.', 'NVARCHAR(MAX)') ,1,1,'') Records FROM MppUser t WHERE t.ProfileAccess=1 and t.Active=1 and EXISTS(SELECT * from Campaigns where t.MppUserID = MppUserID AND Active=1 AND TempSKUCheck = 0);"; cmd.CommandType = CommandType.Text; dt = DataAccess.GetTable(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("GetUserForOneTimeSkuLoad - " + msg); } finally { if (cmd != null) { cmd.Dispose(); } } return(dt); }
/// <summary> /// Update Ads ///<param name="adstbl">adstbl</param> ///<param name="userid">userid</param> ///<param name="reportid">reportid</param> /// </summary> /// <returns></returns> public static String UpdateAdsData(DataTable adtbl, Int32 userid) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateAds"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tblAds", adtbl); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userid; cmd.Parameters.Add("@Date", SqlDbType.SmallDateTime).Value = DateTime.Now.Date; DataAccess.ExecuteScalarCommandForBulk(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateAdsData- " + ex.Message, userid.ToString()); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateAdsData- " + ex.Message, userid.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Get Active Campaigns formula ///<param name="UserId">UserId</param> /// </summary> /// <returns></returns> public static DataSet GetOptimizeSearchTermsAndFormula(int UserId) { String msg = ""; DataSet ds = new DataSet(); SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "Sbsp_GetOptimizeSearchTermsAndFormula"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", SqlDbType.Int).Value = UserId; cmd.Parameters.AddWithValue("@enddate", SqlDbType.SmallDateTime).Value = DateTime.Now.Date.AddDays(-3); ds = DataAccess.GetDataSetForBulk(cmd); } catch (Exception ex) { msg = ex.Message; LogAPI.WriteLog("GetOptimizeSearchTermsAndFormula - " + msg, UserId.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(ds); }
/// <summary> /// 创建空间图层 /// </summary> /// <param name="tableStructureNode">VCT表结构节点</param> /// <param name="featureCodeNode">VCT要素编码节点</param> private FeatureLayer CreateFeatureLayer(TableStructureNode tableStructureNode, FeatureCodeNode featureCodeNode) { try { FeatureLayer featureLayer = null; ///获取要素集 IFeatureDataset featureDataset = m_pIDataset as IFeatureDataset; //从配置文件读取图形类型 string sGeometryType = ""; Metadata.MetaTable pMetaTalbe = Metadata.MetaDataFile.MetaTabls[tableStructureNode.TableName] as Metadata.MetaTable; if (pMetaTalbe != null) { sGeometryType = Metadata.MetaDataFile.GraphConfig.GetGraphTypeMark(pMetaTalbe.Type); } else { LogAPI.WriteLog("未能获取【" + tableStructureNode.TableName + "】的图形类型!"); return null; } ///创建点实体 if (sGeometryType == "Point") { featureLayer = new PointLayer(); } ///创建线实体 else if (sGeometryType == "Line") { featureLayer = new LineLayer(); } ///创建面实体 else if (sGeometryType == "Polygon") { featureLayer = new PolygonLayer(); } else if (sGeometryType == "Annotation") { featureLayer = new AnnotationLayer(); } if (featureLayer != null) { featureLayer.StructureNode = tableStructureNode; IFeatureClass pFcls = CreateFeatureClass(featureDataset, tableStructureNode, featureCodeNode); featureLayer.Table = pFcls as ITable; featureLayer.UpdateFieldIndex(); return featureLayer; } } catch(Exception ex) { LogAPI.WriteErrorLog(ex); } return null; }
/// <summary> /// 根据表名称获取配置表结构 /// </summary> /// <param name="sTableName"></param> /// <returns></returns> public static MetaTable GetMetaTalbleByName(string sTableName) { try { return(m_pMetaTables[sTableName] as MetaTable); } catch (Exception ex) { LogAPI.WriteLog("未能获取【" + sTableName + "】的配置表结构,请检查该表是否在配置表中!"); return(null); } }
/// <summary> /// 根据表名称获取要素代码 /// </summary> /// <param name="sTableName"></param> /// <returns></returns> public static string GetFeatureCodeByName(string sTableName) { try { return((m_pMetaTables[sTableName] as MetaTable).FeatureCode); } catch (Exception ex) { LogAPI.WriteLog("未能获取【" + sTableName + "】的要素代码,请检查该表是否在配置表中!"); return(""); } }
public string GetFiledALisNameByCode(string strCode) { try { foreach (MetaDataField item in MetaDataFields) { if (item.Code == strCode) { return(item.Name); } } } catch (Exception ex) { LogAPI.WriteLog("未能获取" + m_strTableName + "下的字段【" + strCode + "】的字段名称!"); } return(""); }
/// <summary> /// 验证指定的要素是否在裁切范围内 /// </summary> /// <param name="pFeatureGeometry"></param> /// <returns></returns> public virtual bool FeatureInCutRegion(IGeometry pFeatureGeometry) { try { if (pFeatureGeometry == null) return false; IRelationalOperator pRelation = m_CutGeometry as IRelationalOperator; if (pRelation.Crosses(pFeatureGeometry) || pRelation.Contains(pFeatureGeometry) || pRelation.Touches(pFeatureGeometry)|| pRelation.Overlaps(pFeatureGeometry) || pRelation.Within(pFeatureGeometry) || pRelation.Equals(pFeatureGeometry)) return true; return false; } catch (Exception ex) { LogAPI.WriteLog("判断裁切范围时出错,系统将不对【" + StructureNode.TableName + "】进行裁切!\r\n"); return false; } }
/// <summary> /// Update Products Inventory ///<param name="Inventorytbl">Inventorytbl</param> ///<param name="userid">userid</param> ///<param name="reportid">reportid</param> ///<param name="recordtype">recordtype</param> ///<param name="status">status</param> /// </summary> /// <returns></returns> public static String UpdateProductInventoryData(DataTable Inventorytbl, Int32 userid, Int32 reportid, int recordtype, ReportStatus status, out String emailtoNotify) { String res = ""; emailtoNotify = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateProductInventory"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tblProducts", Inventorytbl); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userid; cmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@Status", SqlDbType.Int).Value = status; cmd.Parameters.Add("@RecordType", SqlDbType.Int).Value = recordtype; SqlParameter UserNotify = new SqlParameter("@Email", SqlDbType.VarChar, 100); UserNotify.Direction = ParameterDirection.Output; cmd.Parameters.Add(UserNotify); DataAccess.ExecuteScalarCommandForBulk(cmd); emailtoNotify = Convert.ToString(UserNotify.Value); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateProductInventoryData-" + reportid + ": " + ex.Message, userid.ToString()); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateProductInventoryData-" + reportid + ": " + ex.Message, userid.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update Campaigns ///<param name="camptbl">camptbl</param> ///<param name="userid">userid</param> ///<param name="reportid">reportid</param> /// </summary> /// <returns></returns> public static String UpdateCampaignData(DataTable camptbl, Int32 userid, Int32 reportid, out String emailtoNotify) { String res = ""; emailtoNotify = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Sbsp_UpdateCampaigns"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@tblCampaigns", camptbl); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = userid; cmd.Parameters.Add("@ReportID", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@RecordType", SqlDbType.Int).Value = (int)RecordType.Campaign; cmd.Parameters.Add("@Date", SqlDbType.SmallDateTime).Value = DateTime.Today.AddDays(-3); SqlParameter UserNotify = new SqlParameter("@Email", SqlDbType.VarChar, 100); UserNotify.Direction = ParameterDirection.Output; cmd.Parameters.Add(UserNotify); DataAccess.ExecuteScalarCommand(cmd); emailtoNotify = Convert.ToString(UserNotify.Value); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateCampaignData-" + reportid + ": " + ex.Message, userid.ToString()); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateCampaignData-" + reportid + ": " + ex.Message, userid.ToString()); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update Report Status ///<param name="reportid">reportid</param> ///<param name="reporttype">reporttype</param> ///<param name="status">status</param> ///<param name="responsestatus">responsestatus</param> /// </summary> /// <returns></returns> public static String UpdateReportStatusData(Int32 IsSnapType, Int32 reportid, int reporttype, ReportStatus statustype, ResponseStatus responsestatus) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = "UpdateReportDataStatus"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ReportId", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@StatusType", SqlDbType.Int).Value = (int)statustype; cmd.Parameters.Add("@IsSnap", SqlDbType.Int).Value = (int)IsSnapType; cmd.Parameters.Add("@Status", SqlDbType.Int).Value = (int)responsestatus; cmd.Parameters.Add("@Type", SqlDbType.Int).Value = reporttype; cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = DateTime.Now; DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateReportStatusData-" + reportid + ": " + ex.Message); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateReportStatusData-" + reportid + ": " + ex.Message); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
/// <summary> /// Update products from snap shot report ///<param name="snapid">snapid</param> ///<param name="reportid">reportid</param> ///<param name="reporttype">reporttype</param> /// </summary> /// <returns></returns> public static String UpdateSnapStatusData(String snapid, Int32 reportid, int reporttype, ResponseStatus responsestatus) { String res = ""; SqlCommand cmd = new SqlCommand(); try { cmd.CommandText = @"Update ReportType set Snap_ReportId=@Snap_ReportId,SnapAttempt=0,ApiAttempt=0,SnapStatus=@Status,SnapReqDate=@Date,ModifiedOn=@Date where ReportId=@ReportId and RecordType=@Type"; cmd.CommandType = CommandType.Text; cmd.Parameters.Add("@ReportId", SqlDbType.Int).Value = reportid; cmd.Parameters.Add("@Snap_ReportId", SqlDbType.VarChar).Value = snapid; cmd.Parameters.Add("@Status", SqlDbType.Int).Value = (int)responsestatus; cmd.Parameters.Add("@Type", SqlDbType.Int).Value = reporttype; cmd.Parameters.Add("@Date", SqlDbType.DateTime).Value = DateTime.Now; DataAccess.ExecuteCommand(cmd); } catch (SqlException ex) { res = ex.Message; LogAPI.WriteLog("UpdateSnapStatusData-" + reportid + ": " + ex.Message); } catch (Exception ex) { res = ex.Message; LogAPI.WriteLog("UpdateSnapStatusData-" + reportid + ": " + ex.Message); } finally { if (cmd != null) { cmd.Dispose(); } } return(res); }
public IGeometry GetSubGeometry() { try { if (m_pIFeature == null) return null; if (m_CutGeometry == null) return (m_pIFeature as IFeature).Shape; IGeometry pFeatureShape = (m_pIFeature as IFeature).Shape; ITopologicalOperator pTop = m_CutGeometry as ITopologicalOperator; //if (pFeatureShape.GeometryType == esriGeometryType.esriGeometryLine||pFeatureShape.GeometryType == esriGeometryType.esriGeometryPolyline) // return pTop.Intersect(pFeatureShape, esriGeometryDimension.esriGeometry0Dimension); //else if (pFeatureShape.GeometryType == esriGeometryType.esriGeometryPolygon) //{ // return pTop.Intersect(pFeatureShape, esriGeometryDimension.esriGeometry2Dimension); //} return pTop.Intersect(pFeatureShape, pFeatureShape.Dimension); } catch(Exception ex) { LogAPI.WriteLog("裁剪要素【"+(m_pIFeature.Table as IDataset).BrowseName+"】时出错!\r\n"); return null; } }
/// <summary> /// 创建空间参考 /// </summary> /// <param name="headNode">VCT头节点</param> private ISpatialReference CreateProjection(HeadNode headNode) { try { string sPrjInfo = ""; //根据投影参数中的长半轴值,来判断是什么坐标系统(北京54,西安80,WGS-84,其他地方坐标系) //北京54 double dMajorAxis = headNode.MajorMax.Y; //读取参考椭球的名称 (名称,长半轴,扁率的倒数) string sProjection = headNode.Spheroid.Split(',')[0]; dMajorAxis = Math.Abs(dMajorAxis - 6378245); //if (fabs( m_dSemiMajorAxis - 6378245) < 0.0001) if (dMajorAxis < 0.0001) { sPrjInfo = string.Format("PROJCS[\"{0}\",GEOGCS[\"GCS_Beijing_1954\",DATUM[\"D_Beijing_1954\"" + ",SPHEROID[\"{1}\",6378140.0,298.257]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]]," + "PROJECTION[\"Gauss_Kruger\"],PARAMETER[\"False_Easting\",{2}],PARAMETER[\"False_Northing\",0.0]," + "PARAMETER[\"Central_Meridian\",{3}],PARAMETER[\"Scale_Factor\",1.0],PARAMETER[\"Latitude_Of_Origin\",0.0]," + "UNIT[\"Meter\",1.0]]", sProjection, "Gauss-Krueger", headNode.Excursion, headNode.Parametetor.OriginLongtitude); } //西安80 else { // sPrjInfo = string.Format("PROJCS["%s\",GEOGCS[\"GCS_Xian_1980\",DATUM[\"D_Xian_1980\",SPHEROID[\"%s\",6378140.0,298.257]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]],PROJECTION[\"Gauss_Kruger\"],PARAMETER[\"False_Easting\",%s],PARAMETER[\"False_Northing\",0.0],PARAMETER[\"Central_Meridian\",%f],PARAMETER[\"Scale_Factor\",1.0],PARAMETER[\"Latitude_Of_Origin\",0.0],UNIT[\"Meter\",1.0]]", m_strProjection, m_strSpheroid, sPianYi, m_lMeridian); sPrjInfo = string.Format("PROJCS[\"{0}\",GEOGCS[\"GCS_Xian_1980\",DATUM[\"D_Xian_1980\"," + "SPHEROID[\"{1}\",6378140.0,298.257]],PRIMEM[\"Greenwich\",0.0],UNIT[\"Degree\",0.0174532925199433]]," + "PROJECTION[\"Gauss_Kruger\"],PARAMETER[\"False_Easting\",{2}],PARAMETER[\"False_Northing\",0.0]," + "PARAMETER[\"Central_Meridian\",{3}],PARAMETER[\"Scale_Factor\",1.0],PARAMETER[\"Latitude_Of_Origin\",0.0]," + "UNIT[\"Meter\",1.0]]", sProjection, "Gauss-Krueger", headNode.Parametetor.EastOffset, headNode.Parametetor.OriginLongtitude); } //将坐标信息写入到Prj文件 string sPrjFilename = Application.StartupPath + "tempPrj.prj"; FileStream fs = File.Create(sPrjFilename); StreamWriter sw = new StreamWriter(fs); sw.Write(sPrjInfo); sw.Close(); fs.Close(); //根据Prj文件生成空间参考 ISpatialReferenceFactory ipSpatialFactory = new SpatialReferenceEnvironmentClass(); ISpatialReference pSpatialReference = ipSpatialFactory.CreateESRISpatialReferenceFromPRJFile(sPrjFilename); pSpatialReference.SetDomain(headNode.MajorMin.X,headNode.MajorMax.X,headNode.MajorMin.Y,headNode.MajorMax.Y);// //设置精度,防止cut失败 //设置六位小数精度。以保证导出时也是六位 ISpatialReferenceTolerance ipSrTolerance = pSpatialReference as ISpatialReferenceTolerance; ipSrTolerance.XYTolerance = 0.000001; ipSrTolerance.MTolerance = 0.001; ipSrTolerance.ZTolerance = 0.001; ISpatialReferenceResolution ipSrResolution = pSpatialReference as ISpatialReferenceResolution; ipSrResolution.MResolution = 0.001; ipSrResolution.set_XYResolution(true, 0.000001); ipSrResolution.set_ZResolution(true, 0.001); //删除生成的Prj文件 File.Delete(sPrjFilename); //ISpatialReference pSpatialReference; //ISpatialReferenceFactory pSpatialreferenceFactory; //pSpatialreferenceFactory = new SpatialReferenceEnvironmentClass(); //IGeographicCoordinateSystem pGeographicCoordinateSystem; //pGeographicCoordinateSystem = pSpatialreferenceFactory.CreateGeographicCoordinateSystem((int)esriSRGeoCS3Type.esriSRGeoCS_Xian1980); //pSpatialReference = pGeographicCoordinateSystem as ISpatialReference; //pSpatialReference.SetFalseOriginAndUnits(-180, -90, 1000000);// return pSpatialReference; } catch (Exception ex) { LogAPI.WriteLog("创建空间参考失败,系统默认创建空的空间参考!\r\n"); LogAPI.WriteErrorLog(ex); ISpatialReference pSpatialReference = new UnknownCoordinateSystemClass(); pSpatialReference.SetDomain(headNode.MajorMin.X, headNode.MajorMax.X, headNode.MajorMin.Y, headNode.MajorMax.Y);// return pSpatialReference; } }