private void DelBar()
{
if (GridBarSelect.SelectedItems.Count > 0)
{
var mbr = MessageBox.Show("确定要删除选中的字段吗？", "提示信息", MessageBoxButton.OKCancel, MessageBoxImage.Information);
if (mbr != MessageBoxResult.OK)
{
return;
}
var barInfo = (BarInfo)GridBarSelect.SelectedItem;
if (!DbBar.DelBarInfo(_cable.CableName, barInfo.BarFieldName))
{
InfoBox.InfoMsg("删除失败");
return;
}
if (!CpldControl.Bartend.BartendControl.LoadBartendDb(_cable.CableName))
{
InfoBox.ErrorMsg("读取Bartend数据库文件失败");
return;
}
LoadBar();
}
else
{
InfoBox.InfoMsg("请选择需要删除的字段");
}
}
public static bool UpdateBartendDb(string itemName, DataTable dt)
{
if (!DbBar.UpdateBarInfo(dt))
{
return(false);
}
WriteBartendTxtFile(itemName, dt);
return(true);
}
public static bool LoadBartendDb(string itemName, out DataTable dt)
{
dt = new DataTable();
if (!DbBar.LoadBarInfo(itemName, out dt))
{
return(false);
}
WriteBartendTxtFile(itemName, dt);
return(true);
}
private void LoadBar()
{
if (!DbBar.LoadBarInfo(_cable.CableName, out _barInfoList))
{
InfoBox.InfoMsg("加载失败");
}
else
{
GridBarSelect.ItemsSource = _barInfoList;
}
}
private void CreateBarControl()
{
if (!DbBar.LoadBarInfo(Cable.CableName, out _barDt))
{
return;
}
if (_barDt.Rows.Count == 0)
{
return;
}
for (var i = 0; i < _barDt.Rows.Count; i++)
{
var gridRow = new Grid();
//标签定义
var cd1 = new RowDefinition {
Height = new GridLength(1, GridUnitType.Star)
};
gridRow.RowDefinitions.Add(cd1);
//标签名称
var barFieldName = _barDt.Rows[i]["bar_field_name"].ToString();
var lb = new Label
{
Content = barFieldName + ":",
FontSize = 16
};
Grid.SetRow(lb, 0);
gridRow.Children.Add(lb);
//输入框定义
var cd2 = new RowDefinition {
Height = new GridLength(1, GridUnitType.Star)
};
gridRow.RowDefinitions.Add(cd2);
var tb = new TextBox
{
Name = "tbName_" + barFieldName,
Margin = new Thickness(0, 3, 0, 3),
Text = "",
IsReadOnly = false
};
RegisterName(tb.Name, tb);
var type = (BarFieldType)_barDt.Rows[i]["bar_field_type"];
var isBarEditable = Convert.ToBoolean(_barDt.Rows[i]["is_editable"]);
if (!isBarEditable)
{
var barFieldValue = "";
switch (type)
{
case BarFieldType.AutoIncrement:
case BarFieldType.Constant:
barFieldValue = _barDt.Rows[i]["bar_field_value"].ToString();
break;
case BarFieldType.Month:
break;
case BarFieldType.Day:
break;
case BarFieldType.Year:
break;
default:
barFieldValue = "";
break;
}
tb.Text = barFieldValue;
tb.Background = new SolidColorBrush(Color.FromRgb(245, 245, 245));
tb.IsReadOnly = true;
}
Grid.SetRow(tb, 1);
gridRow.Children.Add(tb);
//
ListBar.Items.Add(gridRow);
}
}
private void OperateDb(DbOperateType operateType, int index)
{
var barFieldName = TbBarFieldName.Text.Trim();
if (barFieldName.Equals(""))
{
InfoBox.ErrorMsg("条码字段名不能为空,请首先配置条形码确定字段内容");
}
else
{
if (_barInfoList != null)
{
if (operateType == DbOperateType.Insert)
{
if (_barInfoList.Any(tmp => tmp.BarFieldName.Equals(barFieldName)))
{
InfoBox.InfoMsg("条码字段名已存在");
return;
}
}
else
{
var tmpIndex = 0;
foreach (var tmp in _barInfoList)
{
if (tmp.BarFieldName.Equals(barFieldName) && tmpIndex != index)
{
InfoBox.InfoMsg("条码字段名已存在");
return;
}
tmpIndex++;
}
}
var fieldType = BarFieldType.AutoIncrement;
var fieldValue = "";
var iTmp = 0;
if (int.TryParse(TbBarValueLen.Text, out iTmp) == false)
{
InfoBox.ErrorMsg("数值长度必须为数字");
return;
}
if (iTmp <= 0)
{
InfoBox.ErrorMsg("数值长度必须大于0");
return;
}
switch (CbBar.SelectedIndex)
{
case 0:
fieldType = BarFieldType.AutoIncrement;
fieldValue = "0".PadLeft(iTmp, '0');
break;
case 1:
fieldType = BarFieldType.Constant;
fieldValue = TbBarFieldContent.Text.Trim();
break;
case 2:
fieldType = BarFieldType.Month;
fieldValue = "";
break;
case 3:
fieldType = BarFieldType.Day;
fieldValue = "";
break;
case 4:
fieldType = BarFieldType.Year;
fieldValue = "";
break;
default: break;
}
switch (operateType)
{
case DbOperateType.Insert:
if (ChkEditable.IsChecked != null && !DbBar.AddBarInfo(_cable.CableName, barFieldName, fieldType, fieldValue, (bool)ChkEditable.IsChecked))
{
InfoBox.ErrorMsg("添加条码字段失败");
return;
}
break;
case DbOperateType.Update:
var id = _barInfoList[index].Id;
if (ChkEditable.IsChecked != null && !DbBar.UpdateBarInfo(id, _cable.CableName, barFieldName, fieldType, fieldValue, (bool)ChkEditable.IsChecked))
{
InfoBox.ErrorMsg("修改条码字段失败");
return;
}
break;
default:
break;
}
if (!CpldControl.Bartend.BartendControl.LoadBartendDb(_cable.CableName))
{
InfoBox.ErrorMsg("读取Bartend数据库文件失败");
return;
}
}
}
LoadBar();
}
