public void LoadLocalData()
{
if (this.InvokeRequired)
{
LoadDelegate ld = new LoadDelegate(LoadLocalData);
this.Invoke(ld);
}
else
{
CustomerServer.GetCustomerAndRegion(ref _ht_Sender, ref _ht_Receiv, ref _ht_Region);
FrmParent.ParentForm._AllRegion = RegionServer.GetAllRegion();
_storage_Scan = StorageServer.GetAllStorageScan();
_UCSenderInfo = new UCCustomerInfo(true);
_UCRecevInfo = new UCCustomerInfo(false);
_UCSenderInfo.Parent = this;
_UCRecevInfo.Parent = this;
_UCSenderInfo.Dock = DockStyle.None;
_UCRecevInfo.Dock = DockStyle.None;
_UCSenderInfo.Visible = false;
_UCRecevInfo.Visible = false;
_UCSenderInfo.Load();
_UCRecevInfo.Load();
}
}
public ActionResult SaveServer(CustomerServer server)
{
var servers = _context.CustomerServers.Where(s => s.CustomerId == server.CustomerId);
var serverViewModel = new ServerViewModel
{
Servers = servers,
CustomerId = server.CustomerId
};
if (server.Id == 0)
{
_context.CustomerServers.Add(server);
_context.SaveChanges();
return(View("_ServerInfo", serverViewModel));
}
var customer = _context.Customers.Single(c => c.Id == server.CustomerId);
var serverInDb = _context.CustomerServers.SingleOrDefault(s => s.Id == server.Id);
serverInDb.ServerName = server.ServerName;
serverInDb.PublicIpAddress = server.PublicIpAddress;
serverInDb.PrivateIpAddress = server.PrivateIpAddress;
serverInDb.Port = server.Port;
serverInDb.UserName = server.UserName;
serverInDb.Password = server.Password;
_context.SaveChanges();
return(View("_ServerInfo", serverViewModel));
}
/// <summary>
/// 窗体加载时 初始化时钟 并且 打开菜单窗体
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmParent_Load(object sender, EventArgs e)
{
if (!Init())
{
Application.Exit();
return;
}
LoadLocalData();
//tmTime_Tick(sender, e);
tmUpload.Interval = 3000;
//if (! UCNodeScan._IsCameraActive)
// UCNodeScan._IsCameraActive = UnitechDSDll.OpenCamera(pbPreview.Handle, 3, 3, 400, 300, 1024, 768);
OpenForm(PageState.Main);
CheckInputPnl(false);
CustomerServer.AddCustomersCountyId();
HuadongTmsOrderServer.AddTMSOrderOptAt();
BaseServer.AddTable_c2lp_optRecord();
BaseServer.AddTable_c2lp_consignor();
BaseServer.AddTable_c2lp_storage_scan();
BaseServer.AddNode_ParentStorageId();
BaseServer.AddLinkType();
BaseServer.AddLinkRegex();
BaseServer.AddConsignorId();
BaseServer.AddColunmForScanRecord();
BaseServer.AddColunmForScanRecord1();
BaseServer.AddColunmForScanRecord2();
}
/// <summary>
/// 窗体加载时 初始化时钟 并且 打开菜单窗体
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmParent_Load(object sender, EventArgs e)
{
//tmTime_Tick(sender, e);
tmUpload.Interval = 3000;
if (!UCNodeScan._IsCameraActive)
{
UCNodeScan._IsCameraActive = UnitechDSDll.OpenCamera(pbPreview.Handle, 3, 3, 400, 300, 1024, 768);
}
OpenForm(PageState.Main);
CheckInputPnl(false);
CustomerServer.AddCustomersCountyId();
HuadongTmsOrderServer.AddTMSOrderOptAt();
}
/// <summary>
/// 根据区域显示下游客户
/// </summary>
/// <param name="zoneOption">区域id</param>
/// <returns></returns>
public ResultModel <List <Model_Customer> > GetDownstreamQZList(string zoneOption = null)
{
ResultModel <List <Model_Customer> > result = new ResultModel <List <Model_Customer> >();
try
{
result.Data = CustomerServer.CustomerDownstreamQZ(zoneOption);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 新增或更新客户信息
/// </summary>
/// <param name="customerInfo">客户信息</param>
/// <param name="bindReceiverOrg">与第三方运单收货单位关联的名称</param>
/// <returns></returns>
public ResultModel <bool> UpdateCustomer(Model_Customer customerInfo, string bindReceiverOrg)
{
ResultModel <bool> result = new ResultModel <bool>();
try
{
result.Data = CustomerServer.UpdateCustomer(customerInfo, bindReceiverOrg);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 新增和修改客户信息更新时间
/// </summary>
/// <param name="customerInfo"></param>
/// <returns></returns>
public ResultModel <Model_Customer> GetCustomerUpdateTime(Model_Customer customerInfo)
{
ResultModel <Model_Customer> result = new ResultModel <Model_Customer>();
try
{
result.Data = CustomerServer.GetCustomerUpdateTime(customerInfo);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 根据省市县或是客户名称查询收货单位总数
/// </summary>
/// <param name="customer"></param>
/// <returns></returns>
public ResultModel <int> GetConsigneeCountyCount(Model_Customer customer)
{
ResultModel <int> result = new ResultModel <int>();
try
{
result.Data = CustomerServer.GetConsigneeCountyCount(customer);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 根据省市县或是客户名称查询收货单位
/// </summary>
/// <param name="customer"></param>
/// <param name="pageIndexAndCount"></param>
/// <returns></returns>
public ResultModel <List <Model_Customer> > GetConsigneeCounty(Model_Customer customer, string pageIndexAndCount = null)
{
ResultModel <List <Model_Customer> > result = new ResultModel <List <Model_Customer> >();
try
{
result.Data = CustomerServer.GetConsigneeCounty(customer, pageIndexAndCount);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 根据客户角色获取客户列表
/// </summary>
/// <param name="role">客户角色</param>
/// <param name="provinceId">可选参数[所在省份 region Id,为0时默认查询所有省份]</param>
/// <param name="cityId">可选参数[所在省份 region Id,为0时默认查询所有城市]</param>
/// <param name="pageIndexAndCount">可选参数[分页参数,无需分页则不填,格式为"页索引.每页数量".例如:1.50,表示每页显示50条,当前查询第1页]</param>
/// <returns></returns>
public ResultModel <List <Model_Customer> > GetCustomerListByRole(Enum_Role role, int provinceId = 0, int cityId = 0, string pageIndexAndCount = null)
{
ResultModel <List <Model_Customer> > result = new ResultModel <List <Model_Customer> >();
try
{
result.Data = CustomerServer.GetCustomerListByRoles(role, provinceId, cityId, pageIndexAndCount);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 登录验证
/// </summary>
/// <param name="userName">用户名</param>
/// <param name="password">密码</param>
/// <returns></returns>
public ResultModel <Model_Customer> Login(string userName, string password)
{
ResultModel <Model_Customer> result = new ResultModel <Model_Customer>();
try
{
result.Data = CustomerServer.CheckCustomerUser(userName, password);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 编辑客户信息
/// </summary>
/// <param name="customerInfo">客户信息</param>
/// <returns></returns>
public ResultModel <Model_Customer> EditCustomer(Model_Customer customerInfo)
{
ResultModel <Model_Customer> result = new ResultModel <Model_Customer>();
try
{
result.Data = CustomerServer.CustomerNew(customerInfo);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
/// <summary>
/// 查询客户信息总数
/// </summary>
/// <param name="role">客户角色</param>
/// <param name="provinceId">可选参数[所在省份 region Id,为0时默认查询所有省份]</param>
/// <param name="cityId">可选参数[所在省份 region Id,为0时默认查询所有城市]</param>
/// <returns></returns>
public ResultModel <int> GetCustomerListByRoleCount(Enum_Role role, int provinceId = 0, int cityId = 0)
{
ResultModel <int> result = new ResultModel <int>();
try
{
result.Data = CustomerServer.GetCustomerListByRoleCount(role, provinceId, cityId);
}
catch (Exception ex)
{
result.Code = 1;
result.Message = ex.Message;
}
return(result);
}
private void LoadCustomer()
{
try
{
_AllCustomer = CustomerServer.GetAllCustomer(null);
if (_AllCustomer.Count == 0)
{
throw new Exception("设备中没有任何客户信息,请联系后台添加后重新同步信息!");
}
}
catch (Exception ex)
{
throw new Exception("加载客户信息失败:" + ex.Message);
}
}
/// <summary>
/// 窗体加载时 初始化时钟 并且 打开菜单窗体
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void FrmParent_Load(object sender, EventArgs e)
{
//tmTime_Tick(sender, e);
tmUpload.Interval = 3000;
//if (!UCNodeScan._IsCameraActive)
// UCNodeScan._IsCameraActive = UnitechDSDll.OpenCamera(pbPreview.Handle, 3, 3, 400, 300, 1024, 768);
OpenForm(PageState.Main);
CheckInputPnl(false);
CustomerServer.AddCustomersCountyId();
//CustomerServer.GetCustomerAndRegion(ref _ht_Sender, ref _ht_Receiv, ref _ht_Region);
//UCSenderInfo.Load();
//UCRecevInfo.Load();
//UCSenderInfo.Visible = true;
//UCRecevInfo.Visible = true;
}
/// <summary>
/// 拼接客户数据字符串
/// </summary>
/// <param name="storages">客户数据数组</param>
/// <returns></returns>
private static void GetCustomersStr(PDA_Model_Customer[] customers, out string insertSql, out string updateSql)
{
insertSql = string.Empty;
StringBuilder valueSql = new StringBuilder("insert into c2lp_customer (Id,fullName,contactPerson,contactTel,contactAddress,provinceId,cityId,role,countyId) values ");
StringBuilder updateValueSql = new StringBuilder();
string updateModelSql = "update c2lp_customer set fullName = '{0}',contactPerson='{1}',contactTel='{2}',contactAddress='{3}',provinceId='{4}',cityId='{5}',role='{6}',countyId='{7}' where id = '{8}';";
bool hasInsert = false;
if (customers != null && customers.Length > 0)
{
//所有客户的ID
List <string> cIdList = customers.ToList().Select(l => l.idk__BackingField.ToString()).ToList();
List <int> needUpdateIdList = CustomerServer.GetUpdateCustomerIdList(cIdList);
foreach (PDA_Model_Customer c in customers)
{
int role = 1;
if (c.rolek__BackingField == 2)
{
role = 2;
}
else if (c.rolek__BackingField == 3)
{
role = 3;
}
if (needUpdateIdList.Contains(c.idk__BackingField))
{
updateValueSql.AppendLine(string.Format(updateModelSql, c.fullNamek__BackingField, c.contactPersonk__BackingField,
c.contactTelk__BackingField, c.contactAddressk__BackingField, c.provinceIdk__BackingField, c.cityIdk__BackingField, role, c.countyIdk__BackingField, c.idk__BackingField));
}
else
{
valueSql.AppendFormat("('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}'),", c.idk__BackingField, c.fullNamek__BackingField, c.contactPersonk__BackingField,
c.contactTelk__BackingField, c.contactAddressk__BackingField, c.provinceIdk__BackingField, c.cityIdk__BackingField, role, c.countyIdk__BackingField);
hasInsert = true;
}
}
valueSql.Length -= 1;
valueSql.Append(";");
}
if (hasInsert)
{
insertSql = valueSql.ToString();
}
updateSql = updateValueSql.ToString();
}
/// <summary>
/// 更新客户信息
/// </summary>
/// <param name="result">客户信息数据</param>
private static void UpdateCustomer(int pid, int maxId, int currCount)
{
//if (maxId == 0)
//{
// CustomerServer.ClearCustomers();
// RegistSyncEvent("已清空原有客户信息...");
//}
//ResultModelOfArrayOfModel_Customerd4FqxSXX result = Common._PdaServer.GetCustomersFromMaxId(pid, true, maxId, true);
ResultModelOfArrayOfPDA_Model_Customerd4FqxSXX result = Common._PdaServer.GetNewCustomers(pid, true, DateTime.Parse(Common._LastSyncTime), true, maxId, true);
if (result.Code != 0)
{
throw new Exception(result.Message);
}
try
{
if (result.Data.Length == 0)
{
RegistSyncEvent("已经没有需要更新的客户信息了.");
return;
}
string insertSql = string.Empty;
string updateSql = string.Empty;
GetCustomersStr(result.Data, out insertSql, out updateSql);
CustomerServer.UpdateCustomers(ref insertSql, ref updateSql);
string info = "新增客户{0}条,更新客户{1}条,当前第{2}批";
RegistSyncEvent(string.Format(info, insertSql, updateSql, currCount + 1));
_isReLoadLocalInfo += int.Parse(insertSql) + int.Parse(updateSql);
if (result.Data.Count() != 0)
{
Thread.Sleep(500);//递归分页获取
currCount += 1;
UpdateCustomer(pid, result.Data.Last().idk__BackingField, currCount);
}
}
catch (Exception ex)
{
throw new Exception("更新客户信息失败:" + ex.Message);
}
}
/// <summary>
/// 更新客户信息
/// </summary>
/// <param name="result">客户信息数据</param>
private static void UpdateCustomer(int pid, int maxId, int currCount)
{
if (maxId == 0)
{
CustomerServer.ClearCustomers();
RegistSyncEvent("已清空原有客户信息...");
}
ResultModelOfArrayOfModel_Customerd4FqxSXX result = Common._PdaServer.GetCustomersFromMaxId(pid, true, maxId, true);
if (result.Code != 0)
{
throw new Exception(result.Message);
}
try
{
if (result.Data.Length == 0)
{
RegistSyncEvent("已经没有客户信息了.");
return;
}
string valueStr = GetCustomersStr(result.Data);
int count = CustomerServer.UpdateCustomers(valueStr);
string info = "新增客户{0}条,当前第{1}批";
RegistSyncEvent(string.Format(info, result.Data.Count().ToString(), currCount + 1));
if (result.Data.Count() != 0)
{
Thread.Sleep(500);//递归分页获取
currCount += 1;
UpdateCustomer(pid, result.Data.Last().Idk__BackingField, currCount);
}
}
catch (Exception ex)
{
throw new Exception("更新客户信息失败:" + ex.Message);
}
}
