/// <summary>
/// 更新部门
/// </summary>
/// <param name="wms_Partment_Model"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static int Update_Partment(WMS_Partment_Model wms_Partment_Model, string condition)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Partment_Dal.Update_Partment(wms_Partment_Model, condition)));
}
}
/// <summary>
/// 插入部门
/// </summary>
/// <param name="wms_Partment_Model"></param>
/// <returns></returns>
public static int Insert_Partment(WMS_Partment_Model wms_Partment_Model)
{
using (var con = GetOpenConnection())
{
return(con.Execute(WMS_Partment_Dal.Insert_Partment(wms_Partment_Model)));
}
}
/// <summary>
/// 搜索按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void DMButton_Search_Click(object sender, RoutedEventArgs e)
{
partmentBase.PartmentList.Clear();
List <WMS_Partment_Model> list = new List <WMS_Partment_Model>();
DataTable dt = WMS_Partment_Bll.Select_Partment(" PartmentNo = " + int.Parse(SearchText.Text.Trim()));
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Partment_Model wMS_Partment_Model = new WMS_Partment_Model
{
PartmentNo = int.Parse(dt.Rows[i]["PartmentNo"].ToString()),
PartmentName = dt.Rows[i]["PartmentName"].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_Partment_Model);
}
foreach (var model in list)
{
partmentBase.PartmentList.Add(model);
}
this.PartmentDataGrid.ItemsSource = partmentBase.PartmentList;
}
/// <summary>
/// 插入部门
/// </summary>
/// <param name="wms_Partment_Model"></param>
/// <returns></returns>
public static string Insert_Partment(WMS_Partment_Model wms_Partment_Model)
{
string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_Partment]"
+ "([PartmentNo],[PartmentName],[CreatPerson],[CreatTime]"
+ ",[ModifyPerson],[ModifyTime])VALUES(" + wms_Partment_Model.PartmentNo
+ ",'" + wms_Partment_Model.PartmentName + "','" + wms_Partment_Model.CreatPerson
+ "','" + wms_Partment_Model.CreatTime + "','" + wms_Partment_Model.ModifyPerson
+ "','" + wms_Partment_Model.ModifyTime + "')";
return(_insertSql);
}
/// <summary>
/// 更新部门
/// </summary>
/// <param name="wms_Partment_Model"></param>
/// <param name="condition"></param>
/// <returns></returns>
public static string Update_Partment(WMS_Partment_Model wms_Partment_Model, string condition)
{
string _updateSql = "UPDATE [WMS].[dbo].[WMS_Partment]"
+ "SET[PartmentNo] = " + wms_Partment_Model.PartmentNo
+ ",[PartmentName] = '" + wms_Partment_Model.PartmentName
+ "',[CreatPerson] = '" + wms_Partment_Model.CreatPerson
+ "',[CreatTime] = '" + wms_Partment_Model.CreatTime
+ "',[ModifyPerson] = '" + wms_Partment_Model.ModifyPerson
+ "',[ModifyTime] = '" + wms_Partment_Model.ModifyTime
+ "' WHERE " + condition;
return(_updateSql);
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List<WMS_Partment_Model> GetPartmentList()
{
List<WMS_Partment_Model> list = new List<WMS_Partment_Model>();
DataTable dt = WMS_Partment_Bll.Select_Partment(string.Empty);
for (int i = 0; i < dt.Rows.Count; i++)
{
WMS_Partment_Model wms_Partment_Model = new WMS_Partment_Model
{
PartmentNo = int.Parse(dt.Rows[i]["PartmentNo"].ToString()),
PartmentName = dt.Rows[i]["PartmentName"].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_Partment_Model);
}
return list;
}
/// <summary>
/// 编辑框事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void PartmentDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e)
{
wms_Partment_Model = e.Row.Item as WMS_Partment_Model;
partmentNo = wms_Partment_Model.PartmentNo;
}
