internal WSTableSource Clone(MetaFunctions _Func, byte?_UserRole = null)
{
WSTableSource src = new WSTableSource(ReturnType, SecurityZone, NAME, _Func, _UserRole == null ? UserRole : (byte)_UserRole, false, AccessLevel, AVAILABLE_FORMATS, ALIACES);
src.PrintStatus = PrintStatus;
src.ShowMessageInaccessible = ShowMessageInaccessible;
src.AllowOwnerAccess = AllowOwnerAccess;
src.BaseFilter = BaseFilter == null ? null : BaseFilter.JString.ToJson();
src.DeletableFilter = DeletableFilter == null ? null : DeletableFilter.JString.ToJson();
src.EditableFilter = EditableFilter == null ? null : EditableFilter.JString.ToJson();
src.CreatableFilter = CreatableFilter == null ? null : CreatableFilter.JString.ToJson();
src.ReadableFilter = ReadableFilter == null ? null : ReadableFilter.JString.ToJson();
src.DefaultSchemaDeepness = DefaultSchemaDeepness;
src._IsReadableBySchema = _IsReadableBySchema;
src._IsCreatableBySchema = _IsCreatableBySchema;
src._IsEditableBySchema = _IsEditableBySchema;
src._IsDeletableBySchema = _IsDeletableBySchema;
src.Params = Params.Select(x => x is WSTableParam ? ((WSTableParam)x).Clone() : x.Clone());
//PrimParams = PrimParams == null ? null : PrimParams.Select(c => c.Clone());
src.DeleteFlag = DeleteFlag == null ? null : DeleteFlag.Clone();
//Json = Json;
//CoreSchema = CoreSchema;
src./*_*/ SecurityZone = SecurityZone;
src.BaseSchema = BaseSchema == null?null:(WSEntitySchema)BaseSchema.Clone(src);
//src._IsReady = null;
return(src);
}
public List <Grammar> GetAll(string search, int?sortColumn, string sortOrder, int skip, int take
, DeleteFlag deleteFlag, out int total, out int filtered)
{
total = filtered = 0;
try
{
IQueryable <Grammar> grammars = DBContext.Grammars.Where(g => g.DeleteFlag == deleteFlag);
total = grammars.Count();
if (!string.IsNullOrEmpty(search))
{
grammars = grammars.Where(g => g.Content.Contains(search) || g.GrammarTags.Any(gm => gm.Tag.Content.Contains(search)));
}
filtered = grammars.Count();
switch (sortColumn)
{
case 1:
grammars = sortOrder == "asc" ? grammars.OrderBy(g => g.Content) : grammars.OrderByDescending(g => g.Content);
break;
default:
break;
}
return(grammars.Skip(skip).Take(take).ToList());
}
catch (Exception exception)
{
return(null);
}
}
public List <Tag> GetAll(DeleteFlag deleteFlag)
{
try
{
List <Tag> tags = DBContext.Tags.Where(t => t.DeleteFlag == deleteFlag).ToList();
return(tags);
}
catch (Exception exception)
{
return(null);
}
}
public Account GetById(int id, DeleteFlag deleteFlag)
{
try
{
Account account = DBContext.Accounts.SingleOrDefault(a => a.Id == id && a.DeleteFlag == deleteFlag);
return(account);
}
catch (Exception exception)
{
return(null);
}
}
public Grammar GetById(int id, DeleteFlag deleteFlag)
{
try
{
Grammar grammar = DBContext.Grammars.SingleOrDefault(g => g.Id == id && g.DeleteFlag == deleteFlag);
return(grammar);
}
catch (Exception exception)
{
return(null);
}
}
public async Task <bool> Delete(IPortPlug port, MessageStorageItem item, DeleteFlag deleteFlag = DeleteFlag.SpecifiedByIndex)
{
bool result = false;
if (item == null || !item.IsValid)
{
return(result);
}
if (await setFormat(port))
{
var deleteParam = new CommandParameter($"{item.Index},{deleteFlag.ToValueString()}", Constants.BasicSuccessfulResponse);
var deleteCmd = new ParamATCommand(ATCommand.MessageDelete.Command(), deleteParam);
await deleteCmd.ExecuteAsync(port);
result = deleteCmd.Succeeded();
}
return(result);
}
public List <Tag> GetAll(string search, int?sortColumn, string sortOrder, int skip, int take
, DeleteFlag deleteFlag, out int total, out int filtered)
{
total = filtered = 0;
try
{
IQueryable <Tag> tags = DBContext.Tags.Where(t => t.DeleteFlag == deleteFlag);
total = tags.Count();
if (!string.IsNullOrEmpty(search))
{
tags = tags.Where(t => t.Content.Contains(search));
}
filtered = tags.Count();
switch (sortColumn)
{
case 1:
tags = sortOrder == "asc" ? tags.OrderBy(t => t.Content) : tags.OrderByDescending(t => t.Content);
break;
case 2:
tags = sortOrder == "asc" ? tags.OrderBy(t => t.GrammarTags.Count) : tags.OrderByDescending(t => t.GrammarTags.Count);
break;
default:
break;
}
return(tags.Skip(skip).Take(take).ToList());
}
catch (Exception exception)
{
return(null);
}
}
protected override string GetValue(Enum vEnum)
{
switch (vEnum)
{
case number: return(Number);
case name: return(Name);
case working_sartdate: return(WorkingSartdate);
case working_enddate: return(WorkingEnddate);
case holiday_flag: return(HolidayFlag.ToString());
case working_start: return(WorkingStart);
case working_end: return(WorkingEnd);
case break_time: return(BreakTime.ToString());
case their_working: return(TheirWorking.ToString());
case nomal_working: return(NomalWorking.ToString());
case guests_nomal_working: return(GuestsNomalWorking.ToString());
case guests_over_working: return(GuestsOverWorking.ToString());
case guests_working: return(GuestsWorking.ToString());
case update_date: return(UpdateDate);
case delete_flag: return(DeleteFlag?.ToString());
default: return("");
}
}
/// <summary>
/// AT+CMGD. Deletes the specified SMS message from the current read/delete storage.
/// </summary>
/// <param name="index">The index of the message to delete.</param>
/// <param name="delflag">The delete flag, this controls the behaviour of the delete command.</param>
public void DeleteMessage(int index, DeleteFlag delflag)
{
lock (this)
{
this.VerifyValidConnection();
string[] str = new string[5];
str[0] = "Deleting message with index ";
str[1] = index.ToString();
str[2] = ", using delflag ";
str[3] = delflag.ToString();
str[4] = "...";
this.LogIt(LogLevel.Info, string.Concat(str));
int num = (int)delflag;
string str1 = string.Concat("AT+CMGD=", index.ToString(), ",", num.ToString());
this.ExecAndReceiveMultiple(str1);
}
}
/// <summary>
/// 删除短信
/// </summary>
/// <param name="index">短信在存储卡中的位置</param>
/// <param name="flag">删除选项</param>
public void DeleteMessage(int index, DeleteFlag flag)
{
lock (mt) ExecTask(string.Format("AT+CMGD={0},{1}\r", index, (int)flag), "");
}
public List <Account> GetByUsernamePassword(string username, string password, DeleteFlag deleteFlag)
{
try
{
List <Account> accounts = new List <Account>();
if (!string.IsNullOrEmpty(username) && !string.IsNullOrEmpty(password))
{
accounts = DBContext.Accounts.Where(a => a.Username == username &&
a.Password == password &&
a.DeleteFlag == deleteFlag
).ToList();
}
return(accounts);
}
catch (Exception exception)
{
return(null);
}
}
