private void ShowEditInfo(TemperatureEntity entity)
{
txtCode.Text = entity.TemperatureCode;
txtName.Text = entity.TemperatureName;
if (entity.LowerLimit.HasValue)
{
spinLower.Value = (decimal)entity.LowerLimit.Value;
}
else
{
spinLower.EditValue = null;
}
if (entity.UpperLimit.HasValue)
{
spinUpper.Value = (decimal)entity.UpperLimit.Value;
}
else
{
spinUpper.EditValue = null;
}
if (entity.AllowEdit == "N")
{
this.lblMsgInfo.Text = "系统预定义属性，不允许删除与修改。";
this.btnSave.Enabled = this.btnSaveClose.Enabled = false;
}
}
/// <summary>
/// 删除
/// </summary>
private void DoDeleteSelected()
{
TemperatureEntity removeEntity = SelectedUnitRow;
if (removeEntity == null)
{
MsgBox.Warn("没有要删除的数据。");
return;
}
if (removeEntity.AllowEdit == "N")
{
MsgBox.Warn("这是系统预定义数据，不允许删除。");
return;
}
if (MsgBox.AskOK(string.Format("确定要删除温控“{0}[{1}]”吗？", removeEntity.TemperatureName, removeEntity.TemperatureCode)) == DialogResult.OK)
{
int ret = temperatureDal.DeleteOne(removeEntity.TemperatureCode);
if (ret == 1)
{
bindingSource1.Remove(removeEntity);
}
else if (ret == -1)
{
MsgBox.Warn("不允许删除，因为有货区在引用中。");
}
else
{
MsgBox.Warn("删除失败。");
}
}
}
private bool Save()
{
if (!IsFieldValueValid())
{
return(false);
}
bool success = false;
try
{
TemperatureEntity editEntity = PrepareSave();
int ret = temperatureDal.Save(editEntity, isNew);
if (ret == -1)
{
MsgBox.Warn("编码已存在，请改为其他的编码。");
}
else if (ret == -2)
{
MsgBox.Warn("更新失败，该行已经被其他人删除。");
}
else
{
success = true;
if (DataSourceChanged != null)
{
DataSourceChanged(editEntity, null);
}
}
}
catch (Exception ex)
{
MsgBox.Warn(ex.Message);
}
return(success);
}
private void OnCreateChanage(object sender, EventArgs e)
{
TemperatureEntity newEntity = (TemperatureEntity)sender;
bindingSource1.Add(newEntity);
bindingSource1.ResetBindings(false);
}
///<summary>
///基础管理（货区信息-查询所有温控信息）
///</summary>
///<returns></returns>
public List <TemperatureEntity> GetAllTemperature()
{
List <TemperatureEntity> list = new List <TemperatureEntity>();
try
{
#region 请求数据
System.Text.StringBuilder loStr = new System.Text.StringBuilder();
//loStr.Append("groupCode=").Append(groupCode);
string jsonQuery = WebWork.SendRequest(string.Empty, WebWork.URL_GetAllTemperature);
if (string.IsNullOrEmpty(jsonQuery))
{
MsgBox.Warn(WebWork.RESULT_NULL);
//LogHelper.InfoLog(WebWork.RESULT_NULL);
return(list);
}
#endregion
#region 正常错误处理
JsonGetAllTemperature bill = JsonConvert.DeserializeObject <JsonGetAllTemperature>(jsonQuery);
if (bill == null)
{
MsgBox.Warn(WebWork.JSON_DATA_NULL);
return(list);
}
if (bill.flag != 0)
{
MsgBox.Warn(bill.error);
return(list);
}
#endregion
#region 赋值数据
foreach (JsonGetAllTemperatureResult jbr in bill.result)
{
TemperatureEntity asnEntity = new TemperatureEntity();
asnEntity.AllowEdit = jbr.allowEdit;
asnEntity.LowerLimit = Convert.ToInt32(jbr.lowerLimit);
asnEntity.TemperatureCode = jbr.tempCode;
asnEntity.TemperatureName = jbr.tempName;
asnEntity.UpperLimit = Convert.ToInt32(jbr.upperLimit);
list.Add(asnEntity);
}
return(list);
#endregion
}
catch (Exception ex)
{
MsgBox.Err(ex.Message);
}
return(list);
}
private void gridView1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
TemperatureEntity removeEntity = SelectedUnitRow;
if (removeEntity == null || removeEntity.AllowEdit == "N")
{
toolEdit.Enabled = toolDel.Enabled = false;
}
else
{
toolEdit.Enabled = toolDel.Enabled = true;
}
}
/// <summary>
/// 检查编码是否已存在
/// </summary>
/// <param name="dept"></param>
/// <returns></returns>
private bool IsCodeExists(TemperatureEntity entity)
{
IMapper map = DatabaseInstance.Instance();
string id = map.ExecuteScalar <string>("select TEMP_CODE from WM_TEMPERATURE where TEMP_CODE = @COD",
new { COD = entity.TemperatureCode });
if (!string.IsNullOrEmpty(id))
{
return(true);
}
return(false);
}
/// <summary>
/// 编辑
/// </summary>
private void ShowEdit()
{
TemperatureEntity editEntity = SelectedUnitRow;
if (editEntity == null)
{
MsgBox.Warn("没有要修改的数据。");
return;
}
FrmTemperatureEdit frmEdit = new FrmTemperatureEdit(editEntity);
frmEdit.DataSourceChanged += OnEditChanage;
frmEdit.ShowDialog();
}
public TemperatureEntity PrepareSave()
{
TemperatureEntity editEntity = temperatureEntity;
if (editEntity == null)
{
editEntity = new TemperatureEntity();
editEntity.AllowEdit = "Y";
}
editEntity.TemperatureCode = txtCode.Text.Trim();
editEntity.TemperatureName = txtName.Text.Trim();
editEntity.LowerLimit = (int)spinLower.Value;
editEntity.UpperLimit = (int)spinUpper.Value;
return(editEntity);
}
private object ConvertReverseTicksToLocalDateTimeString(TemperatureEntity temperature, TemperatureViewModel destination, string destMember, ResolutionContext context)
{
if (string.IsNullOrWhiteSpace(temperature.RowKey))
{
return(null);
}
context.Items.TryGetValue("DateTimeZone", out var ianaTimeZone);
var dateTimeZone = ianaTimeZone as DateTimeZone;
if (dateTimeZone == null)
{
return(null);
}
return(ReverseTicks.ToZonedDateTime(temperature.RowKey, dateTimeZone).ToOffsetDateTime().ToString());
}
public async Task LogAction(double obj)
{
var currentReading = Convert.ToInt32(obj);
//if (currentReading == _lastReading)
//{
// //Do nothing
// return;
//}
_lastReading = currentReading;
var temperatureTable = _client.GetTableReference(_tableName);
await temperatureTable.CreateIfNotExistsAsync();
var entity = new TemperatureEntity(_location, currentReading);
var operation = TableOperation.InsertOrReplace(entity);
var result = await temperatureTable.ExecuteAsync(operation);
}
/// <summary>
/// 保存
/// </summary>
/// <param name="entity"></param>
/// <param name="operatorFlag">添加或编辑</param>
/// <returns></returns>
public int Save(TemperatureEntity entity, bool isNew)
{
IMapper map = DatabaseInstance.Instance();
int ret = -2;
if (isNew)
{
//检查编号是否已经存在
if (IsCodeExists(entity))
{
return(-1);
}
ret = map.Execute("insert into WM_TEMPERATURE(TEMP_CODE, TEMP_NAME, ALLOW_EDIT, LOWER_LIMIT, UPPER_LIMIT) " +
"values(@COD, @NAM, @ALLOW_EDIT, @LOWER_LIMIT, @UPPER_LIMIT)",
new
{
COD = entity.TemperatureCode,
NAM = entity.TemperatureName,
ALLOW_EDIT = entity.AllowEdit,
LOWER_LIMIT = entity.LowerLimit,
UPPER_LIMIT = entity.UpperLimit
});
}
else
{
//更新
ret = map.Execute("update WM_TEMPERATURE set TEMP_NAME = @NAM, ALLOW_EDIT = @ALLOW_EDIT, LOWER_LIMIT = @LOWER_LIMIT, UPPER_LIMIT = @UPPER_LIMIT where TEMP_CODE = @COD",
new
{
COD = entity.TemperatureCode,
NAM = entity.TemperatureName,
ALLOW_EDIT = entity.AllowEdit,
LOWER_LIMIT = entity.LowerLimit,
UPPER_LIMIT = entity.UpperLimit
});
}
return(ret);
}
public FrmTemperatureEdit(TemperatureEntity temperatureEntity)
: this()
{
this.temperatureEntity = temperatureEntity;
}
