/// <summary>
/// 更新条码规则
/// </summary>
/// <returns></returns>
public static int Update_Barcode(WMS_Barcode_Model wms_Barcode_Model, string condition)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Barcode_Dal.Update_Barcode(wms_Barcode_Model, condition)));
}
}
/// <summary>
/// 添加条码规则
/// </summary>
/// <returns></returns>
public static int Insert_Barcode(WMS_Barcode_Model wms_Barcode_Model)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Barcode_Dal.Insert_Barcode(wms_Barcode_Model)));
}
}
/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
barcodeRuleBase.BarcodeList.Clear();
List <WMS_Barcode_Model> list = new List <WMS_Barcode_Model>();
DataTable dt = WMS_Barcode_Bll.Select_Barcode(" ProductionNo = '" + SearchText.Text.Trim() + "'");
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Barcode_Model wMS_Barcode_Model = new WMS_Barcode_Model
{
BarcodeLength = int.Parse(dt.Rows[i]["BarcodeLength"].ToString()),
BarcodeRule = dt.Rows[i]["BarcodeRule"].ToString(),
ProductionNo = dt.Rows[i]["ProductionNo"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wMS_Barcode_Model);
}
foreach (var model in list)
{
barcodeRuleBase.BarcodeList.Add(model);
}
this.BarcodeDataGrid.ItemsSource = barcodeRuleBase.BarcodeList;
}
/// <summary>
/// 添加条码规则
/// </summary>
/// <returns></returns>
public static string Insert_Barcode(WMS_Barcode_Model wms_Barcode_Model)
{
string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_Barcode]"
+ "([BarcodeLength],[BarcodeRule],[ProductionNo]"
+ ",[CreatPerson],[CreatTime],[ModifyPerson],[ModifyTime]) "
+ "VALUES(" + wms_Barcode_Model.BarcodeLength + ",'"
+ wms_Barcode_Model.BarcodeRule + "','" + wms_Barcode_Model.ProductionNo
+ "','" + wms_Barcode_Model.CreatPerson + "','"
+ wms_Barcode_Model.CreatTime + "','" + wms_Barcode_Model.ModifyPerson
+ "','" + wms_Barcode_Model.ModifyTime + "')";
return(_insertSql);
}
/// <summary>
/// 更新条码规则
/// </summary>
/// <returns></returns>
public static string Update_Barcode(WMS_Barcode_Model wms_Barcode_Model, string condition)
{
string _updateSql = "UPDATE [WMS].[dbo].[WMS_Barcode]"
+ "SET[BarcodeLength] = " + wms_Barcode_Model.BarcodeLength
+ ",[BarcodeRule] = '" + wms_Barcode_Model.BarcodeRule
+ "',[ProductionNo] = '" + wms_Barcode_Model.ProductionNo
+ "',[CreatPerson] = '" + wms_Barcode_Model.CreatPerson
+ "',[CreatTime] = '" + wms_Barcode_Model.CreatTime
+ "',[ModifyPerson] = '" + wms_Barcode_Model.ModifyPerson
+ "',[ModifyTime] = '" + wms_Barcode_Model.ModifyTime
+ "' WHERE " + condition;
return(_updateSql);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <WMS_Barcode_Model> GetBarcodeList()
{
List <WMS_Barcode_Model> list = new List <WMS_Barcode_Model>();
DataTable dt = WMS_Barcode_Bll.Select_Barcode(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Barcode_Model wms_Barcode_Model = new WMS_Barcode_Model
{
BarcodeLength = int.Parse(dt.Rows[i]["BarcodeLength"].ToString()),
BarcodeRule = dt.Rows[i]["BarcodeRule"].ToString(),
ProductionNo = dt.Rows[i]["ProductionNo"].ToString(),
CreatPerson = dt.Rows[i]["CreatPerson"].ToString(),
CreatTime = dt.Rows[i]["CreatTime"].ToString(),
ModifyPerson = dt.Rows[i]["ModifyPerson"].ToString(),
ModifyTime = dt.Rows[i]["ModifyTime"].ToString()
};
list.Add(wms_Barcode_Model);
}
return(list);
}
/// <summary>
/// DataGrid编辑完事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
wms_Barcode_Model = e.Row.Item as WMS_Barcode_Model;
productionNo = wms_Barcode_Model.ProductionNo;
}
