// INSERT IGNORE INTO `table_name` (`email`, `phone`, `user_id`) VALUES ('*****@*****.**', '99999', '9999'); 避免重复
public static MobileItem GetMobile(string number)
{
var result = new MobileItem();
var section = NumberHelper.GetSectionNumber(number);
if (string.IsNullOrWhiteSpace(section))
{
return(result);
}
try
{
var reader = MySqlHelper.ExecuteReader(ConnectionString, "SELECT `number`,`city`,`type`,`city_code`,`postcode` FROM `zd_mobile` WHERE `number` = ?section LIMIT 1", new MySqlParameter("?section", section));
if (reader.HasRows)
{
reader.Read();
result.Number = reader.GetString(0);
result.City = reader.GetString(1);
result.Type = reader.GetString(2);
result.CityCode = reader.GetString(3);
result.PostCode = reader.GetString(4);
}
reader.Close();
}
catch (Exception)
{
}
finally
{
}
return(result);
}
public async Task <IActionResult> PutMobileItem([FromRoute] int id, [FromBody] MobileItem mobileItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != mobileItem.ItemId)
{
return(BadRequest());
}
_context.Entry(mobileItem).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MobileItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public void SendMobile(List <string> userNames, string Message)
{
ThreadPool.QueueUserWorkItem(state =>
{
try
{
foreach (var username in userNames)
{
var admin = mongodbQueryService.GetAdminConfigurationInternal(username);
if (admin != null)
{
var mobile = new MobileItem
{
MobileNumber = admin.MobileNumber,
MobileMessage = Message,
};
mobileService.Send(new List <MobileItem> {
mobile
});
}
}
}
catch (Exception ex)
{
ex.Handle("SendMessage");
throw;
}
});
}
private void SendMessage(string configName, string mobileMessage, string mailMessage)
{
ThreadPool.QueueUserWorkItem(state =>
{
try
{
var configitem = AlarmConfigurationBase.GetConfig().AlarmConfigurationByStatistics.Values.FirstOrDefault(c => c.ConfigName == configName);
if (configitem != null)
{
foreach (var groupName in configitem.AlarmReceiverGroupNames.Values)
{
var group = AlarmConfigurationBase.GetConfig().AlarmReceiverGroups.Values.FirstOrDefault(g => g.GroupName == groupName);
foreach (var r in group.AlarmReceivers)
{
var admin = mongodbQueryService.GetAdminConfigurationInternal(r.Value.Name);
if (admin != null)
{
if (group.EnableMobileMessage)
{
var mobile = new MobileItem
{
MobileNumber = admin.MobileNumber,
MobileMessage = mobileMessage,
};
mobileService.Send(new List <MobileItem> {
mobile
});
}
if (group.EnableMailMessage)
{
var mail = new MailItem
{
MailTitle = mailMessage,
MailBody = mailMessage,
MailAddress = admin.MailAddress,
};
mailService.Send(new List <MailItem> {
mail
});
}
}
}
}
}
}
catch (Exception ex)
{
ex.Handle("SendMessage");
throw;
}
});
}
public async Task <IActionResult> PostMobileItem([FromBody] MobileItem mobileItem)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.MobileItem.Add(mobileItem);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMobileItem", new { id = mobileItem.ItemId }, mobileItem));
}
public void RemoveFromCart(int MobileId)
{
if (items == null)
{
return;
}
var dao = new MobileDAO();
MobileItem Mobile = dao.GetMobileItem(MobileId);
if (items.ContainsKey(Mobile))
{
items.Remove(Mobile);
}
}
public void AddToCart(int MobileId)
{
var dao = new MobileDAO();
MobileItem Mobile = dao.GetMobileItem(MobileId);
if (items == null)
{
items = new Dictionary <MobileItem, int>();
}
if (items.ContainsKey(Mobile))
{
int quantity = items[Mobile];
items[Mobile] = ++quantity;
}
else
{
items[Mobile] = 1;
}
}
public ItemResult SyncItem(MobileItem mobileItem)
{
string status = string.Empty;
string message = string.Empty;
ItemResult itemResult = new ItemResult();
bool isValidVersion = true;
try
{
using (StageBitzDB dataContext = new StageBitzDB())
{
isValidVersion = Helper.IsValidAppVersion(mobileItem.Version, out status);
if (isValidVersion)
{
if (mobileItem != null)
{
//Check if this Item has already been created in MobileItem table
//If not create
InventoryMobileItem inventoryMobileItem = dataContext.InventoryMobileItems.Where(imi => imi.MobileItemId == mobileItem.DeviceItemId).FirstOrDefault();
if (inventoryMobileItem == null)
{
int userId = int.Parse(Utils.DecryptStringAES(mobileItem.Token));
//Check if the user can Create the Item
CompanyBL companyBL = new CompanyBL(dataContext);
FinanceBL financeBL = new FinanceBL(dataContext);
InventoryBL inventoryBL = new InventoryBL(dataContext);
if (companyBL.HasEditPermissionForInventoryStaff(mobileItem.CompanyId, userId, null))
{
//New Creation of Item
if (mobileItem.ItemId == 0)
{
//To create items in the hidden mode, if the limits have reached.
bool isFreeTrailCompany = companyBL.IsFreeTrialCompany(mobileItem.CompanyId);
CompanyPaymentPackage companyPaymentPackage = financeBL.GetCurrentPaymentPackageFortheCompanyIncludingFreeTrial(mobileItem.CompanyId);
InventoryPaymentPackageDetails inventoryPaymentPackageDetails = null;
if (companyPaymentPackage != null)
{
inventoryPaymentPackageDetails =
Utils.GetSystemInventoryPackageDetailByPaymentPackageTypeId(companyPaymentPackage.InventoryPaymentPackageTypeId);
}
CompanyCurrentUsage companyCurrentUsage = financeBL.GetCompanyCurrentUsage(mobileItem.CompanyId, null);
if (!financeBL.HasExceededInventoryLimit(isFreeTrailCompany, inventoryPaymentPackageDetails, companyCurrentUsage))
{
inventoryMobileItem = new InventoryMobileItem();
inventoryMobileItem.MobileItemId = mobileItem.DeviceItemId;
inventoryMobileItem.CreatedBy = userId;
inventoryMobileItem.CreatedDate = Utils.Now;
dataContext.InventoryMobileItems.AddObject(inventoryMobileItem);
Item item = new Item();
item.Name = mobileItem.Name;
item.IsManuallyAdded = true;
item.ItemTypeId = mobileItem.ItemTypeId;
item.Quantity = mobileItem.Quantity;
item.Description = mobileItem.Description;
item.CompanyId = mobileItem.CompanyId;
item.IsActive = true;
item.CreatedByUserId = item.LastUpdatedByUserId = userId;
item.CreatedDate = item.LastUpdatedDate = Utils.Now;
item.VisibilityLevelCodeId = Utils.GetCodeIdByCodeValue("InventoryVisibilityLevel", "ABOVE_SHAREDINVENTORY");
dataContext.Items.AddObject(item);
dataContext.SaveChanges();
itemResult.Id = item.ItemId;
status = "OK";
}
else
{
status = "LIMITREACHED";
message = "Inventory plan limit reached.";
}
}
else
{
//Edit existing one
Item exItem = inventoryBL.GetItem(mobileItem.ItemId);
if (exItem != null && exItem.IsActive)
{
Code userVisibilityCode = inventoryBL.GetUserInventoryVisibilityLevel(mobileItem.CompanyId, userId, null, false);
if (!inventoryBL.GetItemStatusInformationForUser(exItem, mobileItem.CompanyId, userId).IsReadOnly&& exItem.Code.SortOrder >= userVisibilityCode.SortOrder)
{
if (mobileItem.LastUpdateDate == exItem.LastUpdatedDate)
{
exItem.Name = mobileItem.Name;
exItem.ItemTypeId = mobileItem.ItemTypeId;
exItem.Description = mobileItem.Description;
exItem.Quantity = mobileItem.Quantity;
exItem.LastUpdatedByUserId = userId;
exItem.LastUpdatedDate = Utils.Now;
dataContext.SaveChanges();
status = "OK";
itemResult.Id = mobileItem.ItemId;
}
else
{
status = "ITEMEDITED";
message = "Item already edited.";
}
}
else
{
status = "NORIGHTS";
message = "Check settings with Company Administrator.";
}
}
else
{
status = "ITEMDELETED";
message = "Item no longer exists.";
}
}
}
else
{
status = "NOACCESS";
message = "Check settings with Company Administrator.";
}
}
else
{
itemResult.Id = inventoryMobileItem.ItemId;
status = "ITEMEXIST";
message = "Item already synced.";
}
}
}
else
{
status = "INVALIDAPP";
message = "Please update App.";
}
}
}
catch (Exception ex)
{
AgentErrorLog.HandleException(ex);
status = "ERROR";
message = "Oops! Unkown error. Sorry...";
}
itemResult.MobileId = mobileItem.DeviceItemId;
itemResult.Status = status;
itemResult.Message = message;
return(itemResult);
}
