public void InsertTestMeter(string meterCode) { var meterEntity = new MeterEntity { F_MeterType = "WaterMeter", F_Factor = "贝林电子", F_MeterRate = 1, F_MeterCode = meterCode, F_OwnerId = "b566c9fd-cc74-4280-95e5-b513b86f365b", F_UserCard = meterCode }; var meterChargingEntity = new MeterChargingEntity { F_PriceModel = "95a3d254-af0b-4424-894c-3de53c85bdfb", F_MeterModel = "1", F_Balance = 0, F_StartValue = 0, F_CloseAmount = 0, F_AlarmAmount = 0, F_EnableAlarm = false, F_EnableClose = false, F_State = true }; SubmitForm(meterEntity, meterChargingEntity, ""); }
public ActionResult SubmitForm(MeterEntity meterEntity, MeterChargingEntity meterChargingEntity, string keyValue) { var companyId = OperatorProvider.Provider.GetCurrent().CompanyId; meterEntity.F_OwnerId = companyId; _meterApp.SubmitForm(meterEntity, meterChargingEntity, keyValue); return(Success("操作成功。")); }
public void SubmitForm(PayOrderEntity payOrderEntity, MeterChargingEntity meterChargingEntity) { using (var db = new RepositoryBase().BeginTrans()) { db.Insert(payOrderEntity); db.Update(meterChargingEntity); db.Commit(); } }
public ActionResult EnabledMeter(string keyValue) { var metertChargingEntity = new MeterChargingEntity { F_ArchiveId = keyValue, F_State = true }; _metertChargingApp.UpdateForm(metertChargingEntity); return(Success("客户启用成功。")); }
public void SubmitForm(MeterEntity meterEntity, MeterChargingEntity meterChargingEntity, string keyValue) { CheckEntity(meterEntity, keyValue); meterEntity.F_MeterNumber = meterEntity.F_MeterNumber ?? BitConverter.ToUInt16(Guid.Parse(meterEntity.F_OwnerId).ToByteArray().Take(2).ToArray(), 0) + "|" + (_service.IQueryable().Count() + 1); meterChargingEntity.F_CloseAmount = meterChargingEntity.F_CloseAmount ?? 0; meterChargingEntity.F_AlarmAmount = meterChargingEntity.F_AlarmAmount ?? 0; meterChargingEntity.F_Balance = meterChargingEntity.F_Balance ?? 0; meterChargingEntity.F_EnableAlarm = meterChargingEntity.F_EnableAlarm ?? false; meterChargingEntity.F_EnableClose = meterChargingEntity.F_EnableClose ?? false; meterChargingEntity.F_StartValue = meterChargingEntity.F_StartValue ?? 0; meterChargingEntity.F_State = meterChargingEntity.F_State ?? true; _service.SubmitForm(meterEntity, meterChargingEntity, keyValue); }
public void SubmitForm(MeterEntity meterEntity, MeterChargingEntity meterChargingEntity, string keyValue) { using (var db = new RepositoryBase().BeginTrans()) { if (!string.IsNullOrEmpty(keyValue)) { meterEntity.Modify(keyValue); db.Update(meterEntity); meterChargingEntity.F_ArchiveId = meterEntity.F_Id; db.Update(meterChargingEntity); } else { meterEntity.Create(); db.Insert(meterEntity); meterChargingEntity.F_ArchiveId = meterEntity.F_Id; db.Insert(meterChargingEntity); } db.Commit(); } }
public void UpdateForm(MeterChargingEntity meterChargingEntity) { _service.Update(meterChargingEntity); }
public void SubmitForm(RefundOrderEntity payOrderEntity, MeterChargingEntity meterChargingEntity) { payOrderEntity.Create(); _service.SubmitForm(payOrderEntity, meterChargingEntity); }
public void SubmitForm(ChangeMeterEntity changeMeterEntity, MeterEntity meterEntity, MeterChargingEntity meterChargingEntity, string meterCode, ReadTaskEntity readTaskEntity) { using (var db = new RepositoryBase().BeginTrans()) { try { changeMeterEntity.Create(); db.Insert(changeMeterEntity); meterEntity.Remove(); db.Update(meterEntity); db.Insert(new MeterEntity { F_CreatorTime = meterEntity.F_CreatorTime, F_DeleteMark = false, F_IDNumber = meterEntity.F_IDNumber, F_DeleteTime = null, F_DeleteUserId = null, F_MeterCode = meterCode, F_Id = changeMeterEntity.F_ArchiveId, F_UserCard = meterEntity.F_UserCard, F_OwnerId = meterEntity.F_OwnerId, F_MobilePhone = meterEntity.F_MobilePhone, F_CreatorUserId = meterEntity.F_CreatorUserId, F_CustomerAddress = meterEntity.F_CustomerAddress, F_CustomerName = meterEntity.F_CustomerName, F_Description = meterEntity.F_Description, F_Factor = meterEntity.F_Factor, F_LastModifyTime = meterEntity.F_LastModifyTime, F_LastModifyUserId = meterEntity.F_LastModifyUserId, F_MeterName = meterEntity.F_MeterName, F_MeterNumber = meterEntity.F_MeterNumber, F_MeterRate = meterEntity.F_MeterRate, F_MeterType = meterEntity.F_MeterType }); var newMeterChargingEntity = meterChargingEntity; newMeterChargingEntity.F_StartValue = changeMeterEntity.F_BaseDosage; newMeterChargingEntity.F_ArchiveId = changeMeterEntity.F_ArchiveId; db.Insert(newMeterChargingEntity); if (readTaskEntity != null) { readTaskEntity.F_WorkId = changeMeterEntity.F_Id; db.Insert(readTaskEntity); } db.Commit(); } catch (Exception ex) { } } }
public bool UpLoad(Stream stream, string companyId) { var dataItems = (Dictionary <string, object>) new ItemsDetailApp().GetDataItemList(); var count = 2; var ds = NPOIExcel.ImportExceltoDs(stream); if (ds == null) { return(false); } var dt = ds.Tables[0]; if (dt == null || dt.Rows.Count <= 0) { return(false); } foreach (DataRow item in dt.Rows) { try { var row = item; var price = new PriceEntity(); if (companyId == "030eca51-483a-47b6-ad46-b6164278ebcb") { var metercode = row[4] as string; if (string.IsNullOrEmpty(metercode)) { continue; } price = _priceApp.GetDefault(companyId); var customPara = new MeterCustomParameter { LINENO = "", BusinessID = row[5] as string, AreaID = row[6] as string, BookID = row[7] as string, InTabManIDs = row[8] as string, }; var meterEntity = new MeterEntity(); var meterChargingEntity = new MeterChargingEntity(); var meter = _service.FindEntity(x => x.F_MeterCode == metercode && x.F_DeleteMark != true && x.F_OwnerId == companyId); if (meter != null) { var meterCharging = new MeterChargingApp().GetForm(meter.F_Id); meterEntity = meter; meterChargingEntity = meterCharging; } meterEntity.F_MeterType = "WaterMeter"; meterEntity.F_Factor = "贝林电子"; meterEntity.F_MeterName = row[1] as string; meterEntity.F_MeterRate = 1; meterEntity.F_UserCard = (string)row[0]; meterEntity.F_MeterCode = (string)row[4]; meterEntity.F_CustomerName = (string)row[1]; meterEntity.F_IDNumber = row[0] as string; meterEntity.F_MobilePhone = row[3] as string; meterEntity.F_CustomerAddress = row[2] as string; meterEntity.F_Description = customPara.ToJson(); meterEntity.F_OwnerId = companyId; meterChargingEntity.F_PriceModel = price.F_Id; meterChargingEntity.F_MeterModel = "1"; SubmitForm(meterEntity, meterChargingEntity, meter == null ? "" : meter.F_Id); count++; } else { var metercode = row[7] as string; if (string.IsNullOrEmpty(metercode)) { continue; } var priceName = row[2] as string; price = _priceApp.GetForm(companyId, priceName); if (price == null) { throw new Exception("当前执行价格不存在"); } double rate; var meterEntity = new MeterEntity(); var meterChargingEntity = new MeterChargingEntity(); var meter = _service.FindEntity(x => x.F_MeterCode == metercode && x.F_DeleteMark != true && x.F_OwnerId == companyId); if (meter != null) { var meterCharging = new MeterChargingApp().GetForm(meter.F_Id); meterEntity = meter; meterChargingEntity = meterCharging; } meterEntity.F_MeterType = ((Dictionary <string, string>)dataItems["DeviceType"]).First(x => x.Value == (string)row[0]).Key; meterEntity.F_Factor = (string)row[3]; meterEntity.F_MeterName = row[4] as string; meterEntity.F_MeterRate = double.TryParse(row[5] as string, out rate) ? rate : 1; meterEntity.F_UserCard = (string)row[6]; meterEntity.F_MeterCode = (string)row[7]; meterEntity.F_CustomerName = (string)row[8]; meterEntity.F_IDNumber = row[9] as string; meterEntity.F_MobilePhone = (string)row[10]; meterEntity.F_CustomerAddress = row[11] as string; meterEntity.F_Description = row[12] as string; meterEntity.F_OwnerId = companyId; meterChargingEntity.F_PriceModel = price.F_Id; meterChargingEntity.F_MeterModel = ((Dictionary <string, string>)dataItems["MeterModel"]).First(x => x.Value == (string)row[1]).Key; SubmitForm(meterEntity, meterChargingEntity, meter == null ? "" : meter.F_Id); count++; } } catch (Exception ex) { throw new Exception("表格行" + count + "数据不正确," + ex.Message); } } return(count > 2); }
public void SubmitForm(PayOrderEntity payOrderEntity, MeterChargingEntity meterChargingEntity, ReadTaskEntity readTaskEntity) { payOrderEntity.Create(); CheckEntity(payOrderEntity); _service.SubmitForm(payOrderEntity, meterChargingEntity, readTaskEntity); }