protected void LoadData()
{
string rootFolder = Server.MapPath("~/Resources/Images/Advertisement/" + DataId.ToString());
if (!Directory.Exists(rootFolder))
{
Directory.CreateDirectory(rootFolder);
}
string[] files = Directory.GetFiles(rootFolder);
DataTable table = new DataTable();
table.Columns.Add("Name");
table.Columns.Add("Path");
table.Columns.Add("Link");
DataRow row;
foreach (string image in files)
{
// FileInfo finfo = new FileInfo(image);
int plashIndex = image.LastIndexOf("\\");
string fileName = image.Substring(plashIndex + 1);
string imageLink = "Resources/Images/Advertisement/" + DataId.ToString() + "/" + fileName;
int dotIndex = fileName.LastIndexOf('.');
string extension = fileName.Substring(dotIndex + 1).ToLower();
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString))
{
SqlCommand com = new SqlCommand();
com.Connection = con;
con.Open();
com.Parameters.AddWithValue("@DataId", DataId);
com.Parameters.AddWithValue("@Image", imageLink);
com.CommandText = "Select * from Advertisement where DataId=@DataId and Image=@Image";
string link = "";
string img = "";
using (SqlDataReader reader = com.ExecuteReader())
{
if (reader.Read())
{
link = reader["Link"].ToString();
img = reader["Image"].ToString();
if (extension == "jpg" || extension == "jpeg" || extension == "png" || extension == "gif")
{
row = table.NewRow();
row["Path"] = "~/" + img;
row["Name"] = fileName;
row["Link"] = link;
table.Rows.Add(row);
}
}
}
com.Dispose();
con.Close();
}
}
gvImage.DataSource = table;
gvImage.DataBind();
gvImage.SelectedIndex = -1;
}
public override int GetHashCode()
{
int hash = 1;
if (MapName.Length != 0)
{
hash ^= MapName.GetHashCode();
}
if (GridId != 0)
{
hash ^= GridId.GetHashCode();
}
if (DataId != 0)
{
hash ^= DataId.GetHashCode();
}
if (Direction != 0F)
{
hash ^= pbc::ProtobufEqualityComparers.BitwiseSingleEqualityComparer.GetHashCode(Direction);
}
if (_unknownFields != null)
{
hash ^= _unknownFields.GetHashCode();
}
return(hash);
}
internal override void Load(
DataObject obj,
object value,
object exValue,
LoadContext loadContext)
{
MetadataProperty property = this.Association.Property;
if (obj.IsPropertyModified(property))
{
return;
}
value = DataProperty.EscapeFromDBNull(value);
exValue = DataProperty.EscapeFromDBNull(exValue);
obj.LoadPropertyValue(property, value, exValue, loadContext);
DataId id = new DataId((string)value);
if (!id.IsEmpty)
{
MetadataAssociationRef metadataAssociationRef = this.Association.Selector == null ? this.Refs[0] : this.Refs.FindBySelectorValue(exValue);
if (metadataAssociationRef != null)
{
ObjectListLoaderByIds refLoader = this.RefLoaders[metadataAssociationRef.Index];
if (refLoader != null && refLoader.ObjectLoader.Count > 0)
{
refLoader.Add(id);
}
}
}
}
/// <summary>
/// キーIDから配列インデックスに変換する
/// </summary>
/// <param name="keyId">キーID</param>
/// <param name="index">変換したインデックス</param>
/// <returns>処理結果</returns>
bool TryConvertIndex(int keyId, out int index)
{
if (!DataId.EqualsUpper(keyId, _data[0].id))
{
Log.Error("IDの種類が異なります（KID:{0:X8}, Offset:{1:X8}）",
keyId, _data[0].id);
index = -1;
return false;
}
if (DataId.GetData(keyId) != DataId.GetIndex(Id))
{
Log.Error("マップIDが異なります（KID:{0:X8}, MID:{1:X8}）", keyId, Id);
index = -1;
return false;
}
index = DataId.GetIndex(keyId);
if (index <= 0 || index >= _data.Length)
{
Log.Error("インデックスが不正（KID:{0:X8}, Num:{1}）",
keyId, _data.Length - 1);
index = -1;
return false;
}
return true;
}
/// <summary>
/// 入力許可を設定
/// </summary>
/// <param name="keyId">キーID</param>
/// <param name="enable">入力許可の有無</param>
public void SetKeyEnable(int keyId, bool enable)
{
if (!DataId.EqualsUpper(keyId, KeyIdOffset.UI))
{
Log.Error("キーIDの種類が異なります（ID:{0:X8}）", keyId);
return;
}
int index = DataId.GetIndex(keyId);
if (index <= 0)
{
Log.Error("キーIDのインデックスが不正（ID:{0:X8}）", keyId);
return;
}
IKeyMap keyMap;
if (!_keyConfig.TryGetKeyMap(index, out keyMap))
{
return;
}
keyMap.SetKeyEnable(keyId, enable);
}
public Packet(byte[] dataStream)
{
dataId = (DataId)BitConverter.ToInt32(dataStream, 0);
int nameLength = BitConverter.ToInt32(dataStream, 4);
int msgLength = BitConverter.ToInt32(dataStream, 8);
if (nameLength > 0)
{
name = Encoding.UTF8.GetString(dataStream, 12, nameLength);
}
else
{
name = null;
}
if (msgLength > 0)
{
message = Encoding.UTF8.GetString(dataStream, 12 + nameLength, msgLength);
}
else
{
message = null;
}
}
public async Task TestForgetIdAsync()
{
var manager = CreateManager();
var turnContext = CreateTurnContext();
var dataId = new DataId(DataIdScopes.Batch, "batch ID");
Assert.IsNull(await manager.StateAccessor.GetAsync(turnContext));
await manager.ForgetIdAsync(turnContext, dataId);
var state = await manager.StateAccessor.GetAsync(turnContext);
Assert.AreEqual(0, state.DataIdsByScope.Count);
var actionIds = state.DataIdsByScope[DataIdScopes.Batch] = new HashSet <string> {
dataId.Value
};
await manager.ForgetIdAsync(turnContext, new DataId(DataIdScopes.Batch, "different batch ID"));
Assert.AreEqual(dataId.Value, actionIds.Single());
await manager.ForgetIdAsync(turnContext, dataId);
Assert.AreEqual(0, actionIds.Count);
await Assert.ThrowsExceptionAsync <ArgumentNullException>(async() => await manager.ForgetIdAsync(turnContext, null));
await Assert.ThrowsExceptionAsync <ArgumentNullException>(async() => await manager.ForgetIdAsync(null, dataId));
}
static double GetDataFromId(LatestDataLongResponsePayload payload, DataId dataId)
{
if (dataId == DataId.SequenceNumber)
{
return(payload.SequenceNumber);
}
if (dataId == DataId.Temperature)
{
return(payload.Temperature.Value);
}
if (dataId == DataId.RelativeHumidity)
{
return(payload.RelativeHumidity.Value);
}
if (dataId == DataId.AmbientLight)
{
return(payload.AmbientLight.Value);
}
if (dataId == DataId.BarometricPressure)
{
return(payload.BarometricPressure.Value);
}
if (dataId == DataId.SoundNoise)
{
return(payload.SoundNoise.Value);
}
if (dataId == DataId.eTVOC)
{
return(payload.eTVOC.Value);
}
if (dataId == DataId.eCO2)
{
return(payload.eCO2.Value);
}
if (dataId == DataId.DiscomfortIndex)
{
return(payload.DiscomfortIndex.Value);
}
if (dataId == DataId.HeatStroke)
{
return(payload.HeatStroke.Value);
}
if (dataId == DataId.VibrationInformation)
{
return(payload.VibrationInformation);
}
if (dataId == DataId.SIValue)
{
return(payload.SIValue.Value);
}
if (dataId == DataId.PGA)
{
return(payload.PGA.Value);
}
if (dataId == DataId.SeismicIntensity)
{
return(payload.SeismicIntensity.Value);
}
throw new NotSupportedException($"{nameof(dataId)}={dataId}");
}
public async Task TestDisableIdAsync()
{
var manager = CreateManager();
var turnContext = CreateTurnContext();
var dataId = new DataId(DataIdScopes.Card, "card ID");
Assert.IsNull(await manager.StateAccessor.GetAsync(turnContext));
await manager.DisableIdAsync(turnContext, dataId, TrackingStyle.TrackDisabled);
var state = await manager.StateAccessor.GetAsync(turnContext);
var actionIds = state.DataIdsByScope[DataIdScopes.Card];
Assert.AreEqual(dataId.Value, actionIds.Single());
await manager.DisableIdAsync(turnContext, new DataId(DataIdScopes.Card, "different card ID"));
Assert.AreEqual(dataId.Value, actionIds.Single());
await manager.DisableIdAsync(turnContext, dataId);
Assert.AreEqual(0, actionIds.Count);
await Assert.ThrowsExceptionAsync <ArgumentNullException>(async() => await manager.DisableIdAsync(turnContext, null));
await Assert.ThrowsExceptionAsync <ArgumentNullException>(async() => await manager.DisableIdAsync(null, dataId));
}
private DataParams GetDataParams(DataId dataId, string folder, IDataSource dataSource)
{
var fileName = String.Format("{0}{1}.csv", dataId.Symbol, (int)dataId.Period);
var path = Path.Combine(folder, "Data", dataId.Source, fileName);
var dataParams = new DataParams
{
DataSourceName = dataId.Source,
Symbol = dataId.Symbol,
Period = dataId.Period,
DataId = dataId,
Path = path,
StartDate = dataSource.StartDate,
EndDate = dataSource.EndDate,
IsUseStartDate = dataSource.IsUseStartDate,
IsUseEndDate = dataSource.IsUseEndDate,
MaximumBars = dataSource.MaximumBars,
MaxIntrabarBars = dataSource.MaxIntrabarBars,
MinimumBars = dataSource.MinimumBars,
IsCheckDataAtLoad = dataSource.IsCheckDataAtLoad,
IsCutOffBadData = dataSource.IsCutOffBadData,
IsCutOffSatSunData = dataSource.IsCutOffSatSunData,
IsFillInDataGaps = dataSource.IsFillInDataGaps,
IsCacheData = dataSource.IsCacheDataFiles,
IsLongData = false
};
return(dataParams);
}
protected void gvImage_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string name = gvImage.DataKeys[e.RowIndex].Value.ToString();
string fullFileName = "Resources/Images/Advertisement/" + DataId.ToString() + "/" + name;
File.Delete(Server.MapPath(fullFileName));
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString))
{
con.Open();
SqlCommand comDataIdExist = new SqlCommand();
comDataIdExist.Connection = con;
comDataIdExist.Parameters.AddWithValue("@DataId", DataId);
SqlCommand com = new SqlCommand();
com.Connection = con;
com.Parameters.AddWithValue("@DataId", DataId);
com.Parameters.AddWithValue("@Image", fullFileName);
com.CommandText = "Delete Advertisement where DataId=@DataId and Image=@Image";
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
LoadData();
}
/// <summary>
/// キーフィールドを追加し、キーを変更するハンドラを取得する
/// </summary>
/// <param name="field"></param>
/// <param name="handler"></param>
public void AddKeyField(IKeyFieldAccesser field, out IAlterKeyHandler handler)
{
int index = DataId.GetData(field.KeyId);
_fields.Add(field);
_alters[index].AddKeyField(field);
handler = _alters[index];
}
public void SetInBatch_SetsCorrectly()
{
var batch = CreateBatch();
DataId.SetInBatch(batch);
AssertIdsWereSetCorrectly(batch, batch);
}
private DataId GetDataId(Boolean refresh)
{
if (_data.IsNull() || refresh)
{
_data = TaxonManagerTest.GetSpeciesTaxonType();
}
return(_data);
}
public void SetInCarousel_SetsCorrectly()
{
var batch = CreateBatch();
var activity = batch[0];
DataId.SetInCarousel(activity.Attachments);
AssertIdsWereSetCorrectly(batch, activity);
}
public static void ToIntTest(int value)
{
var instance = new DataId(value);
var intValue = instance.ToInt();
// セットした値と取得した値が一致すること
Assert.AreEqual(intValue, value);
}
public void SetInCardAction_SetsCorrectly()
{
var batch = CreateBatch();
var action = ((AnimationCard)batch[0].Attachments[1].Content).Buttons[0];
DataId.SetInCardAction(action);
AssertIdsWereSetCorrectly(batch, action);
}
public void SetInAttachment_SetsCorrectly()
{
var batch = CreateBatch();
var attachment = batch[0].Attachments[0];
DataId.SetInAttachment(attachment);
AssertIdsWereSetCorrectly(batch, attachment);
}
public void SetInActivity_SetsCorrectly()
{
var batch = CreateBatch();
var activity = batch[0];
DataId.SetInActivity(activity);
AssertIdsWereSetCorrectly(batch, activity);
}
public override int GetHashCode()
{
int prime = 31;
int result = 1;
result = prime * result + (string.IsNullOrEmpty(DataId) ? 0 : DataId.GetHashCode());
result = prime * result + (string.IsNullOrEmpty(Group) ? 0 : Group.GetHashCode());
return(result);
}
public void AreNotEqual()
{
Assert.IsFalse(DataId.AreNotEqual(null, null));
Assert.IsTrue(DataId.AreNotEqual(GetDataId(), null));
Assert.IsTrue(DataId.AreNotEqual(null, GetDataId()));
Assert.IsTrue(DataId.AreNotEqual(GetDataId(), TaxonManagerTest.GetOneTaxon()));
Assert.IsFalse(DataId.AreNotEqual(GetDataId(), GetDataId()));
Assert.IsTrue(DataId.AreNotEqual(GetDataId(), ArtDatabanken.Data.ArtDatabankenService.TaxonManager.GetTaxonTypes()[2]));
}
protected void btnOk_Click(object sender, EventArgs e)
{
string sPath = string.Format("~/Resources/Images/Advertisement/{0}/", DataId.ToString());
string fullfile = fuHinhAnh.PostedFile.FileName;
string filename = Path.GetFileName(fullfile);
string link = "";
if (fuHinhAnh.PostedFile != null)
{
string extenfile = Path.GetExtension(fullfile).ToLower();
if (extenfile.ToLower() == ".jpeg" || extenfile.ToLower() == ".gif" || extenfile.ToLower() == ".jpg" || extenfile.ToLower() == ".png")
{
int file_append = 0;
while (File.Exists(Server.MapPath(sPath + filename)))
{
file_append++;
filename = Path.GetFileNameWithoutExtension(sPath + "\\" + filename)
+ file_append.ToString() + extenfile;
}
fuHinhAnh.PostedFile.SaveAs(Server.MapPath(sPath + filename));
lbThongBao.Text = "Cập nhật thành công.";
lbThongBao.Visible = true;
FileStream fstream = new FileStream(Server.MapPath(sPath + filename), FileMode.Open);
//ResizeFromStream(filename, 100, fstream);
using (SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PSCPortalConnectionString"].ConnectionString))
{
con.Open();
SqlCommand comDataIdExist = new SqlCommand();
comDataIdExist.Connection = con;
comDataIdExist.Parameters.AddWithValue("@DataId", DataId);
SqlCommand com = new SqlCommand();
com.Connection = con;
com.Parameters.AddWithValue("@DataId", DataId);
com.Parameters.AddWithValue("@Link", link);
com.Parameters.AddWithValue("@Image", "Resources/Images/Advertisement/" + DataId.ToString() + "/" + filename);
com.CommandText = "Insert Into Advertisement( DataId, Link, Image) Values (@DataId,@Link,@Image)";
com.ExecuteNonQuery();
com.Dispose();
con.Close();
}
LoadData();
}
else
{
lbThongBao.Text = "Cập nhật không thành công. Hình ảnh phải thuộc dạng : jpeg , gif , jpg .";
lbThongBao.Visible = true;
}
}
else
{
lbThongBao.Text = "Cập nhật không thành công. Bạn phải nhập hình ảnh";
lbThongBao.Visible = true;
}
}
public IDataSet LoadDataSet(string dataSourceName, string symbol, DataPeriod period)
{
DataId dataId = new DataId(dataSourceName, symbol, period);
IDataSource dataSource = LoadDataSource(dataId.Source);
DataParams dataParams = GetDataParams(dataId, UserFilesFolder, dataSource);
IDataSet dataSet = LoadCsvFile(dataParams);
dataSet.Properties = dataSource.InstrumentProperties[symbol];
return(dataSet);
}
public override string ToString()
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.AppendLine("<b>KeyId</b>: " + DataId.ToString(this._keyId));
stringBuilder.AppendLine("<b>inputState</b>: " + this.inputState);
stringBuilder.AppendLine("<b>pressTime</b>: " + this.pressTime);
stringBuilder.AppendLine("<b>useHoldThreshold</b>: " + this.useHoldThreshold);
stringBuilder.AppendLine("<b>holding</b>: " + this.holding);
stringBuilder.AppendLine("<b>holdTime</b>: " + this.holdTime);
return(stringBuilder.ToString());
}
public void SetInAdaptiveCard_SetsCorrectly()
{
var batch = CreateBatch();
var attachment = batch[0].Attachments[0];
object adaptiveCard = attachment.Content;
DataId.SetInAdaptiveCard(ref adaptiveCard);
attachment.Content = adaptiveCard;
AssertIdsWereSetCorrectly(batch, attachment);
}
public void SetInSubmitAction_SetsCorrectly()
{
var batch = CreateBatch();
var actions = ((AdaptiveCard)batch[0].Attachments[0].Content).Actions;
object submitAction = actions[0];
DataId.SetInSubmitAction(ref submitAction);
actions[0] = JObject.FromObject(submitAction).ToObject <AdaptiveSubmitAction>();
AssertIdsWereSetCorrectly(batch, actions[0]);
}
public void SetInActionData_SetsCorrectly()
{
var batch = CreateBatch();
var submitAction = (AdaptiveSubmitAction)((AdaptiveCard)batch[0].Attachments[0].Content).Actions[0];
object actionData = submitAction.Data;
DataId.SetInActionData(ref actionData);
submitAction.Data = actionData;
AssertIdsWereSetCorrectly(batch, submitAction);
}
public override bool Equals(object obj)
{
if (obj == null || obj.GetType() != GetType())
{
return(false);
}
if (this == obj)
{
return(true);
}
var othre = obj as CacheData;
return(DataId.Equals(othre.DataId) && Group.Equals(othre.Group));
}
/// <summary>
/// コンストラクタ
/// </summary>
public NeedAckInfo(PbConnection connection, DataId dataId,
PbSendData sendData, TimeSpan timeout)
{
DataId = dataId;
SendData = sendData;
Timeout = timeout;
this.connection = connection;
this.timer = new Timer(
Timer_Callback,
null,
timeout,
TimeSpan.FromMilliseconds(-1));
}
protected Boolean AreEqual(DataId data1, DataId data2)
{
if ((data1.IsNull() && data2.IsNotNull()) ||
(data1.IsNotNull() && data2.IsNull()))
{
return(false);
}
if (data1.IsNull() && data2.IsNull())
{
return(true);
}
return((data1.Id == data2.Id) &&
(data1.GetType().Name == data2.GetType().Name));
}
