/// <summary>
/// 获取最大值，最小值，平均值
/// </summary>
/// <param name="dm"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <param name="dataStatus"></param>
/// <returns></returns>
private double GetValueOnStatus(string dm, DateTime start, DateTime end, DataStatus dataStatus)
{
double ReturnValue = double.MinValue;
try {
DateTime DT = DateTime.Now;
int tPeriod = (int)end.Subtract(start).TotalSeconds;
System.UInt32 eDNAPoint = 0;
int Index = 0;
GetKey(dm, start, end, tPeriod, ref eDNAPoint, ref Index, dataStatus);
StringBuilder szStatus = new StringBuilder(20);
StringBuilder szTime = new StringBuilder(30);
double pdValue = 0;
int ptTime = 0;
while (Index == 0)
{
Index = History.DnaGetNextHistUTC(eDNAPoint, ref pdValue, ref ptTime, szStatus, 20);
if (Index == 0)
{
//保留时间
//RealTime.UCTToStringTime(ptTime, szTime, 30);
if (szStatus.ToString().StartsWith("OK"))
{
ReturnValue = pdValue;
break;
}
}
}
}
catch {
//
}
return(ReturnValue);
}
public DataStatus Delete(DataSource ds, params DataColumn[] columns)
{
DataStatus status = OnDeleteBefor(ds, ref columns);
if (status == DataStatus.Success)
{
try
{
DeleteImpl(ds, columns);
status = OnDeleteAfter(ds);
//if (DeleteImpl(ds, columns) > 0)
//{
// status = OnDeleteAfter(ds);
//}
//else
//{
// OnDeleteFailed(ds);
// status = DataStatus.Failed;
//}
}
catch (Exception)
{
OnDeleteFailed(ds);
status = DataStatus.Failed;
//throw;
}
}
return(status);
}
public FrmGroupAddress(DataStatus status)
{
InitializeComponent();
foreach (var it in Enum.GetNames(typeof(KNXPriority)))
{
this.cmbPriority.Items.Add(it);
}
foreach (var it in MyCache.NodeActions)
{
this.treeViewDefaultActions.Nodes.Add(it);
}
AddressStatus = status;
if (DataStatus.Modify == AddressStatus)
{
this.txtID.Enabled = false;
//this.txtName.Enabled = false;
this.txtWriteAddress.Enabled = false;
//this.btnDPTName.Enabled = false;
//this.tvDPTName.Enabled = false;
}
//else if (DataStatus.Add == AddressStatus)
//{
foreach (var it in MyCache.NodeTypes)
{
this.tvDPTName.Nodes.Add(it);
}
this.tvDPTName.Height = 300;
this.tvDPTName.Visible = false;
this.tvDPTName.NodeMouseDoubleClick += new System.Windows.Forms.TreeNodeMouseClickEventHandler(tvDPTName_NodeMouseDoubleClick);
this.Controls.Add(this.tvDPTName);
//}
}
//private bool _processing;
//private Thread _tcpThread;
#endregion
private void OnStatus(DataStatus status, string message = "")
{
if (Verbose)
{
Log.FatalFormat("OnStatus {0} {1}", status, message);
}
// Application.Current.Dispatcher.Invoke(new Action(() => { /* Your code here */ }));
//if (StatusEvent != null) StatusEvent(this, new StatusEventArgs {Status = status, Message = message});
if (StatusEvent == null)
{
return;
}
var args = new StatusEventArgs {
Status = status, Message = message
};
Application.Current.Dispatcher.BeginInvoke(DispatcherPriority.Normal, new Action(() =>
{
if (Verbose)
{
Log.FatalFormat("OnStatus 2");
}
StatusEvent(this, args);
}));
}
public DataStatus Insert(DataSource ds, ColumnMode mode, params DataColumn[] columns)
{
DataStatus status = OnInsertBefor(ds, mode, ref columns);
if (status == DataStatus.Success)
{
try
{
if (InsertImpl(ds, mode, columns))
{
status = OnInsertAfter(ds);
}
else
{
OnInsertFailed(ds);
status = DataStatus.Failed;
}
}
#if (DEBUG)
catch (Exception ex)
#else
catch (Exception)
#endif
{
OnInsertFailed(ds);
status = DataStatus.Failed;
//throw;
}
}
return(status);
}
public DataStatus Update(DataSource ds, ColumnMode mode, DataColumn[] columns, DataWhereQueue ps)
{
DataStatus status = OnUpdateBefor(ds, mode, ref columns);
if (status == DataStatus.Success)
{
try
{
if (UpdateImpl(ds, mode, columns, ps) > 0)
{
status = OnUpdateAfter(ds);
}
else
{
OnUpdateFailed(ds);
status = DataStatus.Failed;
}
}
catch (Exception)
{
OnUpdateFailed(ds);
status = DataStatus.Failed;
//throw;
}
}
return(status);
}
public DataMember(Member b) : base(b)
{
Status = new DataStatus()
{
Id = Status.Id, Name = Status.Name
};
}
/// <summary>
/// Convert a status into a log message. Prepends the caller so you know who gave the status
/// </summary>
/// <param name="status">Status.</param>
/// <param name="caller">Caller.</param>
public void LogStatus(DataStatus status, string caller)
{
Action<string, LogLevel> Slog = (message, level) =>
{
Log("#" + caller + "#: " + message, level);
};
if (status == DataStatus.ClosedSocketError)
Slog("Client endpoint closed socket", LogLevel.Warning);
else if (status == DataStatus.ClosedStreamError)
Slog("Stream closed by itself", LogLevel.Warning);
else if (status == DataStatus.DataFormatError)
Slog("Data was in an unrecognized format!", LogLevel.Warning);
else if (status == DataStatus.EndOfStream)
Slog("Somehow, the end of the stream data was reached", LogLevel.Warning);
else if (status == DataStatus.InternalError)
Slog("Something broke within the WebSocket library!", LogLevel.Error);
else if (status == DataStatus.OversizeError)
Slog("Data too large; not accepting", LogLevel.Warning);
else if (status == DataStatus.SocketExceptionError)
Slog("The socket encountered an exception", LogLevel.Error);
else if (status == DataStatus.UnknownError)
Slog("An unknown error occurred in the WebSocket library!", LogLevel.Error);
else if (status == DataStatus.UnsupportedError)
Slog("Tried to use an unsupported WebSocket feature!", LogLevel.Warning);
else if (status == DataStatus.CancellationRequest)
Slog("Connection was cancelled on request", LogLevel.Warning);
}
public NetworkDataObject(byte[] hash, DataStatus status = DataStatus.NoData)
{
mHash = new byte[hash.Length];
Array.Copy(hash, mHash, hash.Length);
mDataStatus = status;
}
public FrmGroupAddress(DataStatus status)
{
InitializeComponent();
foreach (var it in Enum.GetNames(typeof(KNXPriority)))
{
this.cmbPriority.Items.Add(it);
}
foreach (var it in MyCache.NodeActions)
{
this.treeViewDefaultActions.Nodes.Add(it);
}
AddressStatus = status;
if (DataStatus.Modify == AddressStatus)
{
this.txtID.Enabled = false;
//this.txtName.Enabled = false;
this.txtWriteAddress.Enabled = false;
//this.btnDPTName.Enabled = false;
//this.tvDPTName.Enabled = false;
}
//else if (DataStatus.Add == AddressStatus)
//{
foreach (var it in MyCache.NodeTypes)
{
this.tvDPTName.Nodes.Add(it);
}
this.tvDPTName.Height = 300;
this.tvDPTName.Visible = false;
this.tvDPTName.NodeMouseDoubleClick += new System.Windows.Forms.TreeNodeMouseClickEventHandler(tvDPTName_NodeMouseDoubleClick);
this.Controls.Add(this.tvDPTName);
//}
}
public DataReply(DataStatus status, string messageText)
{
Status = status;
Messages = new [] { new DataMessage {
Text = messageText
} };
}
public NetworkDataObject(byte[] hash, DataStatus status = DataStatus.NoData)
{
mHash = new byte[hash.Length];
Array.Copy(hash, mHash, hash.Length);
mDataStatus = status;
}
public DataStatus InsertOrReplace(DataSource ds, ColumnMode mode, params DataColumn[] columns)
{
DataStatus status = OnInsertBefor(ds, mode, ref columns);
if (status == DataStatus.Success)
{
try
{
if (InsertOrReplaceImpl(ds, mode, columns))
{
OnInsertAfter(ds);
status = DataStatus.Success;
}
else
{
OnInsertFailed(ds);
status = DataStatus.Failed;
}
}
catch (Exception)
{
OnInsertFailed(ds);
status = DataStatus.Failed;
}
}
return(status);
}
public void Login(string Url, string driverPath, string userName, string Password)
{
//If password is null replace empty value
Password = Password != null ? Password : "";
//预上线环境账号
ChromeOptions CROptions = new ChromeOptions();
CROptions.AddArgument("-start-maximized");
CROptions.AddArgument("--disable-gpu");
if (!DataStatus.ProcessModel)
{
string ChromeXpathpath = Directory.GetCurrentDirectory().ToString() + "\\tools\\ChromeXpath.crx";
CROptions.AddExtension(ChromeXpathpath);
}
driver = new ChromeDriver(driverPath, CROptions);
DataStatus.SetWebDriver(driver);
driver.Url = Url;
JWait.WaitForAjaxComplete(driver, 30);
if (!JWait.WaitUntil(() =>
{
element = driver.FindElement(By.XPath("//input[@placeholder='用户名']"));
element.Clear();
element.SendKeys(userName);
element = driver.FindElement(By.XPath("//input[@placeholder='密码']"));
element.Clear();
element.SendKeys(Password);
element = driver.FindElement(By.XPath("//button[contains(text(),'登录')]"));
element.Click();
SwitchWebpage(driver.WindowHandles.Count);
}, 30))
{
throw new Exception("✘：【登录失败】");
}
}
private ICellStyle GetStyle(DataStatus status, IWorkbook workbook)
{
if (_styles == null)
{
_styles = new Dictionary <DataStatus, ICellStyle>();
}
ICellStyle style;
if (_styles.TryGetValue(status, out style))
{
return(style);
}
style = workbook.CreateCellStyle();
var representation = Mapping.StatusRepresentations.FirstOrDefault(r => r.Status == status);
if (representation == null)
{
_styles.Add(status, style);
return(style);
}
style.FillPattern = FillPattern.SolidForeground;
style.FillForegroundColor = GetClosestColour(representation.Colour);
if (representation.Border)
{
style.BorderBottom = style.BorderTop = style.BorderLeft = style.BorderRight
= BorderStyle.Thin;
style.BottomBorderColor = style.TopBorderColor = style.LeftBorderColor = style.RightBorderColor
= IndexedColors.Black.Index;
}
var font = workbook.CreateFont();
switch (representation.FontWeight)
{
case FontWeight.Normal:
break;
case FontWeight.Bold:
font.IsBold = true;
break;
case FontWeight.Italics:
font.IsItalic = true;
break;
case FontWeight.BoldItalics:
font.IsBold = true;
font.IsItalic = true;
break;
default:
throw new ArgumentOutOfRangeException();
}
style.SetFont(font);
_styles.Add(status, style);
return(style);
}
public DataReply(DataStatus status, DataMessage[] messages)
{
Status = status;
if (messages.Length > 0)
{
Messages = messages;
}
}
protected internal virtual void SetResult(DataStatus status, Action action, object value = null)
{
if (status == DataStatus.Success && action != null)
{
action();
}
SetResult((int)status, value);
}
//public Member GetMember(DataSource ds)
//{
// MemberId = ExecuteScalar<OAuth2Member, int>(ds, "MemberId", P("Type", Type) & P("UserId", UserId));
// if (MemberId > 0)
// return Member.GetById(ds, MemberId);
// return null;
//}
//public DataStatus BindMember(DataSource ds, long memberId)
//{
// MemberId = memberId;
// return Update(ds, ColumnMode.Include, "MemberId");
//}
//public Member BindMember(DataSource ds, string memberName)
//{
// Member member = Member.GetByName(ds, memberName);
// if (member != null)
// {
// if (BindMember(ds, member.Id) == DataStatus.Success)
// return member;
// }
// return null;
//}
public static DataStatus Register(DataSource ds, string type, string userId, Member member, RegisterType rt)
{
if (!string.IsNullOrEmpty(type) && !string.IsNullOrEmpty(userId))
{
ds.Begin();
try
{
Member temp = Member.GetByType(ds, member, rt);
if (temp == null)
{
DataStatus status = member.Insert(ds);
if (status != DataStatus.Success)
{
ds.Commit();
return(status);
}
else
{
temp = member;
}
}
else
{
if (rt != RegisterType.Mobile && !string.Equals(temp.Password, member.Password.MD5()))
{
ds.Commit();
return(DataStatus.Exist);
}
}
OAuth2Member user = new OAuth2Member()
{
Type = type,
UserId = userId,
MemberId = temp.Id
};
if (user.Update(ds, ColumnMode.Include, "MemberId") != DataStatus.Success)
{
if (user.Insert(ds) != DataStatus.Success)
{
throw new Exception();
}
}
ds.Commit();
return(DataStatus.Success);
}
catch (Exception)
{
ds.Rollback();
return(DataStatus.Failed);
}
}
else
{
return(DataStatus.ExistOther);
}
}
public IEnumerable<Category> Query(string siteId, string code = null, DataStatus? status = DataStatus.Normal)
{
var query = repoCategory.Query(o => o.SiteId == siteId && o.Status == status);
if (!string.IsNullOrEmpty(code))
query = query.Where(o => o.Code == code);
if (status.HasValue)
query = query.Where(o => o.Status == status.Value);
query = query.OrderBy(o => o.ShowOrder);
return query.ToArray();
}
public void Bind()
{
try
{
//string target = Request.Form["Target"];
//if (string.IsNullOrEmpty(target))
// target = GetUrl("/");
string type = Request.Form["Oauth2Type"];
string userId = Request.Form["Oauth2UserId"];
M.RegisterType rt = (M.RegisterType) int.Parse(Request.Form["RegisterType"]);
M.Member member = DbTable.Load <M.Member>(Request.Form);
if (rt == M.RegisterType.Mobile)
{
if (!V.MobileHash.Equals(DataSource, member.Mobile, V.MobileHash.Register, Request.Form["Captcha"]))
{
SetResult((int)M.LoginStatus.CaptchaError);
return;
}
member.VerMob = true;
}
string password = member.Password;
member.ParentId = Utility.GetReference(this, DataSource);
member.Approved = true;
member.CreationDate = DateTime.Now;
DataStatus status = M.OAuth2Member.Register(DataSource, type, userId, member, rt);
if (status == DataStatus.Success)
{
M.LoginStatus state = M.OAuth2Member.Login(DataSource, type, userId, ClientIp, out member);
if (state == M.LoginStatus.Success)
{
PassportAuthentication.SetAuthCookie(true, false, member);
OnLogined(member.Id);
SetResult(true);
}
else
{
SetResult((int)state);
}
}
else
{
SetResult((int)status);
}
}
catch (Exception)
{
SetResult(false);
}
}
public void Update(object NewValues)
{
var issc = NewValues as InformationStorageSetContainer;
if (issc != null)
{
foreach (var item in issc.FileIIS.GetKeys())
{
var value = issc.FileIIS.getByKey(item);
if(value != null)
FileIIS.setByKey(item, value);
}
}
Status = DataStatus.Updated;
}
protected virtual void ModifiedProperty()
{
switch (this.Status)
{
case DataStatus.NoChanged:
this.Status = DataStatus.Changed;
break;
case DataStatus.New:
break;
case DataStatus.Changed:
break;
case DataStatus.Deleted:
break;
}
}
/// <summary>
/// Geths the datasource for the grid and binds it
/// </summary>
private void LoadDataStatus()
{
//Get the connection manger
ConnectionManager = SessionManager.GetConnectionManager(this);
DataStatus dataStatus = new DataStatus(ConnectionManager);
//Use the year selected in the combo
dataStatus.Year = int.Parse(cmbYear.Items[cmbYear.SelectedIndex].Text);
//Get the dataset
SourceDS = dataStatus.GetAll(true);
//Binds the grid
grdDataStatus.DataSource = SourceDS;
grdDataStatus.DataMember = SourceDS.Tables[0].TableName;
grdDataStatus.Rebind();
}
private static void GetChecksum(Byte[] sentence, ref Byte checksum, ref DataStatus dataStatus)
{
if (CRLFAppended)
{
b0 = (Byte)(sentence[sentence.Length - 4] >= 65 ? sentence[sentence.Length - 4] - 55 : sentence[sentence.Length - 4] - 48);
b1 = (Byte)(sentence[sentence.Length - 3] >= 65 ? sentence[sentence.Length - 3] - 55 : sentence[sentence.Length - 3] - 48);
}
else
{
b0 = (Byte)(sentence[sentence.Length - 2] >= 65 ? sentence[sentence.Length - 2] - 55 : sentence[sentence.Length - 2] - 48);
b1 = (Byte)(sentence[sentence.Length - 1] >= 65 ? sentence[sentence.Length - 1] - 55 : sentence[sentence.Length - 1] - 48);
}
checksum = (Byte)((b0 << 4) + b1);
if (!VerifyChecksum(sentence, checksum))
{
dataStatus = DataStatus.InvalidChecksum;
}
}
/// <summary>
/// 修改可用预存款
/// </summary>
/// <param name="ds"></param>
/// <param name="id"></param>
/// <param name="value"></param>
/// <returns></returns>
public static DataStatus ModifyMoney(DataSource ds, long id, Money value, string title, int type = 0, string targetId = null)
{
if (value == 0)
{
return(DataStatus.Success);
}
ds.Begin();
try
{
DataStatus status = (new MoneyRecord()
{
MemberId = id,
Title = title,
Type = type,
TargetId = targetId,
Value = value,
CreationDate = DateTime.Now
}).Insert(ds);
if (status != DataStatus.Success)
{
throw new Exception();
}
DataWhereQueue where = P("Id", id);
if (value < 0)
{
where = WN("Money", -value, "OldMoney", ">=") & where;
}
status = (new MemberInfo()
{
Id = id
}).Update(ds, ColumnMode.Include, Cs(MODC("Money", value)), where);
if (status != DataStatus.Success)
{
throw new Exception();
}
ds.Commit();
return(DataStatus.Success);
}
catch (Exception)
{
ds.Rollback();
return(DataStatus.Rollback);
}
}
/// <summary>
/// 修改冻结预存款，将自动扣除可用预存款
/// </summary>
/// <param name="ds"></param>
/// <param name="id"></param>
/// <param name="value"></param>
/// <returns></returns>
public static DataStatus ModifyFreezeMoney(DataSource ds, long id, Money value, string title, int type = 0, string targetId = null)
{
if (value == 0)
{
return(DataStatus.Success);
}
ds.Begin();
try
{
DataStatus status = (new MoneyRecord()
{
MemberId = id,
Title = string.Concat(title, "[冻结]"),
Type = type,
TargetId = targetId,
Value = -value,
CreationDate = DateTime.Now
}).Insert(ds);
if (status != DataStatus.Success)
{
throw new Exception();
}
status = (new MemberInfo()
{
Id = id
}).Update(ds, ColumnMode.Include, MODC("Money", -value), MODC("FreezeMoney", value));
if (status != DataStatus.Success)
{
throw new Exception();
}
ds.Commit();
return(DataStatus.Success);
}
catch (Exception)
{
ds.Rollback();
return(DataStatus.Rollback);
}
}
public ProductEntity SetIsHasImage(int entityId, bool hasImage, DataStatus dataStatus, int updateUser, string des)
{
var parames = new List <SqlParameter>
{
new SqlParameter("@IsHasImage", hasImage),
new SqlParameter("@Id", entityId),
new SqlParameter("@UpdatedDate", DateTime.Now),
new SqlParameter("@UpdatedUser", updateUser),
new SqlParameter("@Status", (int)dataStatus),
};
const string sql = "UPDATE [dbo].[Product] SET [IsHasImage] = @IsHasImage, [UpdatedUser] = @UpdatedUser ,[UpdatedDate] = @UpdatedDate , [Status]= @Status WHERE Id = @Id;";
var i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnection(), CommandType.Text, sql, parames.ToArray());
if (i > 0)
{
return(GetItem(entityId));
}
return(null);
}
public BaseEntity()
{
CreateDate = DateTime.Now;
Status = DataStatus.Inserted;
}
internal static VmInsightsOnboardingStatusData DeserializeVmInsightsOnboardingStatusData(JsonElement element)
{
ResourceIdentifier id = default;
string name = default;
ResourceType type = default;
SystemData systemData = default;
Optional <string> resourceId = default;
Optional <OnboardingStatus> onboardingStatus = default;
Optional <DataStatus> dataStatus = default;
Optional <IList <DataContainer> > data = default;
foreach (var property in element.EnumerateObject())
{
if (property.NameEquals("id"))
{
id = new ResourceIdentifier(property.Value.GetString());
continue;
}
if (property.NameEquals("name"))
{
name = property.Value.GetString();
continue;
}
if (property.NameEquals("type"))
{
type = new ResourceType(property.Value.GetString());
continue;
}
if (property.NameEquals("systemData"))
{
systemData = JsonSerializer.Deserialize <SystemData>(property.Value.ToString());
continue;
}
if (property.NameEquals("properties"))
{
if (property.Value.ValueKind == JsonValueKind.Null)
{
property.ThrowNonNullablePropertyIsNull();
continue;
}
foreach (var property0 in property.Value.EnumerateObject())
{
if (property0.NameEquals("resourceId"))
{
resourceId = property0.Value.GetString();
continue;
}
if (property0.NameEquals("onboardingStatus"))
{
if (property0.Value.ValueKind == JsonValueKind.Null)
{
property0.ThrowNonNullablePropertyIsNull();
continue;
}
onboardingStatus = new OnboardingStatus(property0.Value.GetString());
continue;
}
if (property0.NameEquals("dataStatus"))
{
if (property0.Value.ValueKind == JsonValueKind.Null)
{
property0.ThrowNonNullablePropertyIsNull();
continue;
}
dataStatus = new DataStatus(property0.Value.GetString());
continue;
}
if (property0.NameEquals("data"))
{
if (property0.Value.ValueKind == JsonValueKind.Null)
{
property0.ThrowNonNullablePropertyIsNull();
continue;
}
List <DataContainer> array = new List <DataContainer>();
foreach (var item in property0.Value.EnumerateArray())
{
array.Add(DataContainer.DeserializeDataContainer(item));
}
data = array;
continue;
}
}
continue;
}
}
return(new VmInsightsOnboardingStatusData(id, name, type, systemData, resourceId.Value, Optional.ToNullable(onboardingStatus), Optional.ToNullable(dataStatus), Optional.ToList(data)));
}
public void Receive(string strInput)
{
// only receive data match address
if (strInput.StartsWith(sAddr))
{
string[] split_data = strInput.Split(' ');
List<string> data = new List<string>();
foreach (string str in split_data)
{
if(!String.IsNullOrEmpty(str))
{
data.Add(str);
}
}
if (data.Count >= 4)
{
tTimeout.Enabled = false;
eDataStatus = DataStatus.Available;
if (data.Contains("=")) //diagnostic data or calibration data
{
int parse_index;
try{
parse_index = Int32.Parse(data[1]);
}
catch
{
parse_index = 0;
}
for (int i = 0; i < iParaCount; i++)
{
if (parse_index == iParaIndex[i])
{
int out_value = 0;
bool IsGetValue = true;
try
{
out_value = Int32.Parse(data[3]);
}
catch
{
IsGetValue = false;
}
if (IsGetValue)
{
ParaResult result = new ParaResult();
if (out_value >= iLowerLimit[i] && out_value <= iUpperLimit[i])
{
result.para_result = ParaStatus.Pass;
result.para_value = out_value;
}
else
{
result.para_result = ParaStatus.Warning;
result.para_value = out_value;
}
iParaResult[i] = result;
if (parse_index == 76)
{
this.sSerialNum = result.para_value.ToString();
}
}
}
}
}
if (data.Count >= 5) // regular data
{
for (int i = 1; i < 5; i++)
{
double out_value = 0.0;
try
{
out_value = Double.Parse(data[i]);
}
catch
{
out_value = 0;
}
if (out_value >= dRegLowLimit[i-1] && out_value <= dRegUpLimit[i-1])
{
iRegResult[i-1].para_result = ParaStatus.Pass;
iRegResult[i-1].para_value = out_value;
}
else
{
iRegResult[i-1].para_result = ParaStatus.Warning;
iRegResult[i-1].para_value = out_value;
}
switch (i)
{
case 1:
dPressure = out_value;
break;
case 2:
dTemp = out_value;
break;
case 3:
dVolFlowRate = out_value;
break;
case 4:
dPreMassFlowRate = dMassFlowRate;
dMassFlowRate = out_value;
break;
}
}
}
}
}
}
public ObjectResult StatusCode(DataStatus status)
=> status.Code switch
{
(uint)DataStatus.Codes.Good => Ok(status),
/// <summary>
/// ��ȡ���ֵ����Сֵ��ƽ��ֵ
/// </summary>
/// <param name="dm"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <param name="dataStatus"></param>
/// <returns></returns>
private double GetValueOnStatus(string dm, DateTime start, DateTime end, DataStatus dataStatus)
{
double ReturnValue = double.MinValue;
try {
DateTime DT = DateTime.Now;
int tPeriod = (int)end.Subtract(start).TotalSeconds;
System.UInt32 eDNAPoint = 0;
int Index = 0;
GetKey(dm, start, end, tPeriod, ref eDNAPoint, ref Index, dataStatus);
StringBuilder szStatus = new StringBuilder(20);
StringBuilder szTime = new StringBuilder(30);
double pdValue = 0;
int ptTime = 0;
while (Index == 0) {
Index = History.DnaGetNextHistUTC(eDNAPoint, ref pdValue, ref ptTime, szStatus, 20);
if (Index == 0) {
//����ʱ��
//RealTime.UCTToStringTime(ptTime, szTime, 30);
if (szStatus.ToString().StartsWith("OK")) {
ReturnValue = pdValue;
break;
}
}
}
}
catch {
//
}
return ReturnValue;
}
public void ResetDataStatus()
{
eDataStatus = DataStatus.NotAvailable;
}
public void ResetPara()
{
//dDiagResult = {0,0,0,0iParaIndex
for (int i = 0; i < iParaCount; i++)
{
iParaResult[i].Reset();
}
for (int i = 0; i < iRegCount; i++)
{
iRegResult[i].Reset();
}
eDataStatus = DataStatus.NotAvailable;
}
public NetworkDataObject(DataStatus status = DataStatus.NoData)
{
mDataStatus = status;
}
private void TIMEOUT_TICK(Object myObject, EventArgs myEventArgs)
{
eDataStatus = DataStatus.Timeout;
tTimeout.Enabled = false;
}
public static IEnumerable<Category> GetCategories(string code = null, DataStatus? status = DataStatus.Normal, string language = null)
{
var query = CategoryProvider.Query(CurrentSite.SiteId, code, status);
return query.ToArray();
}
public void LogStatus(DataStatus status, string caller)
{
connection.LogStatus(status, caller);
}
public void Submit()
{
try
{
M.RegisterType type = (M.RegisterType) int.Parse(Request.Form["RegisterType"]);
PassportSection section = PassportSection.GetSection();
M.Member member = DbTable.Load <M.Member>(Request.Form);
if (type == M.RegisterType.Mobile)
{
if (section.VerifyMobile)
{
if (!V.MobileHash.Equals(DataSource, member.Mobile, V.MobileHash.Register, Request.Form["SmsCaptcha"]))
{
SetResult((int)M.LoginStatus.SmsCaptchaError);
return;
}
member.VerMob = true;
}
}
if (!IsWap)
{
if (section.RegisterWithCaptcha)
{
if (!Captcha.CheckCaptcha(Request.Form["CaptchaName"], Request.Form["Captcha"]))
{
SetResult((int)M.LoginStatus.CaptchaError);
return;
}
}
}
string password = member.Password;
if (member.ParentId == 0)
{
bool convertResult = long.TryParse(Request.QueryString["ParentId"], out member.ParentId);
if (!convertResult)
{
member.ParentId = Utility.GetReference(this, DataSource);
}
}
member.Approved = section.DefaultApproved;
member.CreationDate = DateTime.Now;
DataStatus status = member.Insert(DataSource);
if (status == DataStatus.Success)
{
int errCount;
string name;
switch (type)
{
case M.RegisterType.Email: name = member.Email; break;
case M.RegisterType.Mobile: name = member.Mobile.ToString(); break;
default: name = member.Name; break;
}
M.LoginStatus state = M.Member.Login(DataSource, name, password, ClientIp, out errCount, out member);
if (state == M.LoginStatus.Success)
{
Web.PassportAuthentication.SetAuthCookie(true, false, member);
}
SetResult((int)state);
}
else
{
SetResult((int)status);
}
}
catch (Exception)
{
SetResult(false);
}
}
public void SendToPort(PressRequestType requestType, PressDataType dataType)
{
eDataStatus = DataStatus.NotAvailable;
tTimeout.Enabled = true;
if (Globals.Tags.IsTouchScreen.Value.Bool)
{
mPort.Write(sAddr + sRequestType[(int)requestType] + sDataType[(int)dataType] + "\r");
}
}
public NetworkDataObject(DataStatus status = DataStatus.NoData)
{
mDataStatus = status;
}
protected abstract void InsertModifyHistory(TEntity entity, DataStatus status, Guid?userId);
public BaseEntity()
{
Status = DataStatus.Inserted;
CreatedDate = DateTime.Now;
}
public void RequestData()
{
eDataStatus = DataStatus.NotAvailable;
tTimeout.Enabled = true;
if (Globals.Tags.IsTouchScreen.Value.Bool)
{
mPort.Write(sAddr + "\r");
}
}
///// <summary>
///// ����ʱ�����ij��ı��stdev
///// EDNA��Ҫ��
///// </summary>
///// <param name="tagname"></param>
///// <param name="stime"></param>
///// <param name="etime"></param>
///// <returns></returns>
//public double GetStdevAtPeriod(string tagname, DateTime stime, DateTime etime)
//{
// return 0;
//}
/// tagname��һ���ַ������ �ö��ŷָ�
/// ǰ��IJ�������ʷ���� ��վ����+���������
/// ����Ϊ�����(��վ����+������+�������)
//public bool WriteSnapValue(string tagname, string value)
//{
// string[] strs = tagname.Split(',');
// DateTime s = DateTime.Now;
// DateTime atime = DateTime.Parse("1970-1-1 08:00:00");
// int Start = (int)s.Subtract(atime).TotalSeconds;
// StringBuilder szError = new StringBuilder(20);
// //DI�� 0x1003 false 0x1043 true �����ֵΪTRUE FALSE
// //AI�� 0x0003
// ushort state = 0x0003;
// if (value == "TRUE") state = 0x1043;
// else if (value == "FALSE") state = 0x1003;
// int j = History.DnaHistQueueAppendValue(strs[0], strs[1], Start, state, value, szError, 20);
// if (j == 0)
// {
// int k = History.DnaHistFlushAppendValues(strs[0], strs[1], szError, 20);
// if (k == 0)
// {
// return true;
// }
// else
// {
// return false;
// }
// }
// return false;
//}
/// <summary>
/// ��ȡKey��ʶ
/// </summary>
/// <param name="dm"></param>
/// <param name="start"></param>
/// <param name="end"></param>
/// <param name="tPeriod"></param>
/// <returns></returns>
private void GetKey(string dm, DateTime start, DateTime end, int tPeriod, ref System.UInt32 eDNAKey, ref int isOk, DataStatus dataStatus)
{
DateTime atime = DateTime.Parse("1970-1-1 08:00:00");
int Start = (int)start.Subtract(atime).TotalSeconds;
int End = (int)end.Subtract(atime).TotalSeconds;
StringBuilder szStatus = new StringBuilder(20);
StringBuilder szTime = new StringBuilder(30);
if (dataStatus == DataStatus.Normal) {
isOk = History.DnaGetHistSnapUTC(dm, Start, End, tPeriod, ref eDNAKey);
}
else if (dataStatus == DataStatus.Avg) {
isOk = History.DnaGetHistAvgUTC(dm, Start, End, tPeriod, ref eDNAKey);
}
else if (dataStatus == DataStatus.Min) {
isOk = History.DnaGetHistMinUTC(dm, Start, End, tPeriod, ref eDNAKey);
}
else if (dataStatus == DataStatus.Max) {
isOk = History.DnaGetHistMaxUTC(dm, Start, End, tPeriod, ref eDNAKey);
}
}
/// <summary>
/// 显示数据信息饼状图具体信息
/// </summary>
/// <param name="subcenter"></param>
/// <param name="time_from"></param>
/// <param name="time_to"></param>
/// <returns></returns>
public static List <DataStatus> StatDataStatus(int subcenter, DateTime time_from, DateTime time_to)
{
List <DataStatus> retList = new List <DataStatus>();
List <DataStatus> errorStatusList = new List <DataStatus>();
List <VoltageDbData> voltageStatusList = new List <VoltageDbData>();
List <DateTime> dataTimeList = new List <DateTime>();
//1.1获取所有站点信息
List <Station> stationInfoList = new List <Station>();
if (StationHelper.stationInfoList == null || StationHelper.stationInfoList.Count == 0)
{
StationHelper.getStationInfoList();
}
//过滤 只统计接收的站点
for (int i = 0; i < StationHelper.stationInfoList.Count; i++)
{
if (StationHelper.stationInfoList[i].stationType != StationTypes.rain2Station)
{
stationInfoList.Add(StationHelper.stationInfoList[i]);
}
}
//1.2 获取数据信息
if (dataStsList != null)
{
errorStatusList.AddRange(dataStsList);
}
if (voltageList != null)
{
voltageStatusList.AddRange(voltageList);
}
//2.1统计时间段
for (DateTime dataTime = time_from; dataTime <= time_to; dataTime = dataTime.AddHours(1))
{
dataTimeList.Add(dataTime);
}
//2.2
//3.1 统计异常数据信息 STATE为0
if (errorStatusList != null)
{
for (int i = 0; i < errorStatusList.Count; i++)
{
errorStatusList[i].state = "0";
}
retList.AddRange(errorStatusList);
}
//2.统计缺数信息
int total = dataTimeList.Count * stationInfoList.Count;
int voltageCount = voltageStatusList.Count;
string stationid = "";
List <voltage> tmpVoltageList = new List <voltage>();
List <DateTime> tmpDataTimeList = new List <DateTime>();
//3.1 循环，按站点分组，并取出
for (int i = 0; i < voltageStatusList.Count; i++)
{
tmpDataTimeList.Add(voltageStatusList[i].datatime);
if ((voltageStatusList[i].stationid != stationid && stationid.Length > 0 && i >= 1) || i == voltageStatusList.Count - 1)
{
//取出该站点该段时间内的缺少的数据
for (int j = 0; j < dataTimeList.Count; j++)
{
if (!tmpDataTimeList.Contains(dataTimeList[j]))
{
DataStatus dataStatus = new DataStatus();
dataStatus.stationid = voltageStatusList[i - 1].stationid;
dataStatus.stationName = StationHelper.stationInfoDic[voltageStatusList[i - 1].stationid].stationName;
dataStatus.datatime = dataTimeList[j];
dataStatus.state = "-1";
retList.Add(dataStatus);
}
}
//更新站点和时间信息
tmpDataTimeList.Clear();
tmpDataTimeList.Add(voltageStatusList[i].datatime);
}
stationid = voltageStatusList[i].stationid;
}
//3.统计正常数据条数
//TODO 暂时不统计正常数据
return(retList);
}
public void Receive(string strInput)
{
int equal_pos = strInput.IndexOf('=');
int header_pos = strInput.IndexOf(sAddr);
int str_length = equal_pos - header_pos;
if (equal_pos != -1 && header_pos != -1 && str_length > 0)
{
string toComp = strInput.Substring(header_pos, str_length);
for (int i = 0; i < sDataType.Length; i++)
{
if (toComp == sAddr + sRequestType[0] + sDataType[i])
{
eDataStatus = DataStatus.Available;
tTimeout.Enabled = false;
string d1 = strInput.Substring(equal_pos + 1,8);
if (i == 7)
{
dResult[i] = Hex16ToDecimal10(d1, true);
sSerialNum = dResult[i].ToString();
}
else
{
dResult[i] = HexToDouble(d1,true);
}
pResult[i].para_value = dResult[i];
if (dResult[i] >= dMinValue[i] && dResult[i] <= dMaxValue[i])
{
pResult[i].para_result = ParaStatus.Pass;
}
else
{
pResult[i].para_result = ParaStatus.Warning;
}
switch(i)
{
case 0:
dPrePressure = dPressure;
dPressure = dResult[i];
if (PressureData.Count > MAX_DATA_SIZE)
{
PressureData.Clear();
}
else
{
PressureData.Add(dResult[i]);
}
break;
case 1:
dTemp = dResult[i];
break;
case 2:
dSpan = dResult[i];
break;
case 3:
dOffset = dResult[i];
break;
}
break;
}
}
}
}
/// <summary>
/// 查询站点数据状态信息
/// </summary>
/// <param name="subcenter"></param>
/// <param name="time_from"></param>
/// <param name="time_to"></param>
/// <returns></returns>
public static DataStatus ListDataStatus(int subcenter, DateTime time_from, DateTime time_to)
{
//异常数据信息
//工况信息 用于统计缺数
//List<voltage> voltageList = new List<voltage>();
DataStatus result = new DataStatus();
//1.组合查询参数
Dictionary <string, object> param = new Dictionary <string, object>();
Dictionary <string, string> paramInner = new Dictionary <string, string>();
paramInner["subcenter"] = subcenter.ToString();
paramInner["datatime"] = time_from.ToString();
paramInner["strttime"] = time_from.ToString();
paramInner["endtime"] = time_to.ToString();
string dataStsUrl = suffix + "/datasts/getDatasts";
string voltageUrl = suffix + "/voltage/getSharpVoltage";
//string dataStsUrl = "http://127.0.0.1:8088/datasts/getDatasts";
//string voltageUrl = "http://127.0.0.1:8088/voltage/getSharpVoltage";
string jsonStr = HttpHelper.SerializeDictionaryToJsonString(paramInner);
param["datasts"] = jsonStr;
param["voltage"] = jsonStr;
//2.1查询数据状态信息
try
{
string resultJson = HttpHelper.Post(dataStsUrl, param);
dataStsList = (List <DataStatus>)HttpHelper.JsonDeserialize <List <DataStatus> >(resultJson, new List <DataStatus>());
}
catch (Exception e)
{
Debug.WriteLine("查询数据状态信息失败");
throw e;
}
//2.2 查询工况信息
try
{
string resultJson = HttpHelper.Post(voltageUrl, param);
voltageList = (List <VoltageDbData>)HttpHelper.JsonDeserialize <List <VoltageDbData> >(resultJson, new List <VoltageDbData>());
}
catch (Exception e)
{
Debug.WriteLine("查询数据状态信息失败");
throw e;
}
//3.获取站点信息
List <Station> stationInfoList = new List <Station>();
if (StationHelper.stationInfoList == null || StationHelper.stationInfoList.Count == 0)
{
StationHelper.getStationInfoList();
}
for (int i = 0; i < StationHelper.stationInfoList.Count; i++)
{
if (StationHelper.stationInfoList[i].stationType != StationTypes.rain2Station)
{
stationInfoList.Add(StationHelper.stationInfoList[i]);
}
}
//4.统计应收数据、警告数据、缺数
int hours = (time_to - time_from).Hours + 1;
int deserverdNum = stationInfoList.Count * hours;
int lackNum = deserverdNum - voltageList.Count;
int errorNum = dataStsList.Count;
int realNum = voltageList.Count - dataStsList.Count;
result.deserverNum = deserverdNum;
result.errorNum = errorNum;
result.lackNum = lackNum;
result.realNum = realNum;
return(result);
}
