/// <summary> /// 搜索按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DMButton_Search_Click(object sender, RoutedEventArgs e) { clientBase.ClientList.Clear(); List <WMS_Client_Model> list = new List <WMS_Client_Model>(); DataTable dt = WMS_Client_Bll.Select_Client(" CompanyName = '" + SearchText.Text.Trim() + "'"); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Client_Model wMS_Client_Model = new WMS_Client_Model { CompanyName = dt.Rows[i]["CompanyName"].ToString(), ProductionName = dt.Rows[i]["ProductionName"].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_Client_Model); } foreach (var model in list) { clientBase.ClientList.Add(model); } this.ClientDataGrid.ItemsSource = clientBase.ClientList; }
/// <summary> /// 更新客户 /// </summary> /// <param name="wms_Client_Model"></param> /// <param name="condition"></param> /// <returns></returns> public static int Update_Client(WMS_Client_Model wms_Client_Model, string condition) { using (var con = GetOpenConnection()) { return(con.Execute(WMS_Client_Dal.Update_Client(wms_Client_Model, condition))); } }
/// <summary> /// 插入客户 /// </summary> /// <param name="wms_Client_Model"></param> /// <returns></returns> public static int Insert_Client(WMS_Client_Model wms_Client_Model) { using (var con = GetOpenConnection()) { return(con.Execute(WMS_Client_Dal.Insert_Client(wms_Client_Model))); } }
/// <summary> /// 更新客户 /// </summary> /// <param name="wms_Client_Model"></param> /// <param name="condition"></param> /// <returns></returns> public static string Update_Client(WMS_Client_Model wms_Client_Model, string condition) { string _updateSql = "UPDATE [WMS].[dbo].[WMS_Client]" + "SET[CompanyName] = '" + wms_Client_Model.CompanyName + "',[ProductionName] = '" + wms_Client_Model.ProductionName + "',[CreatPerson] = '" + wms_Client_Model.CreatPerson + "',[CreatTime] = '" + wms_Client_Model.CreatTime + "',[ModifyPerson] = '" + wms_Client_Model.ModifyPerson + "',[ModifyTime] = '" + wms_Client_Model.ModifyTime + "' WHERE " + condition; return(_updateSql); }
/// <summary> /// 插入客户 /// </summary> /// <param name="wms_Client_Model"></param> /// <returns></returns> public static string Insert_Client(WMS_Client_Model wms_Client_Model) { string _insertSql = "INSERT INTO [WMS].[dbo].[WMS_Client]" + "([CompanyName],[ProductionName],[CreatPerson]" + ",[CreatTime],[ModifyPerson],[ModifyTime])" + "VALUES('" + wms_Client_Model.CompanyName + "','" + wms_Client_Model.ProductionName + "','" + wms_Client_Model.CreatPerson + "','" + wms_Client_Model.CreatTime + "','" + wms_Client_Model.ModifyPerson + "','" + wms_Client_Model.ModifyTime + "')"; return(_insertSql); }
/// <summary> /// 获取列表 /// </summary> /// <returns></returns> public static List <WMS_Client_Model> GetClienteList() { List <WMS_Client_Model> list = new List <WMS_Client_Model>(); DataTable dt = WMS_Client_Bll.Select_Client(string.Empty); for (int i = 0; i < dt.Rows.Count; i++) { WMS_Client_Model wms_Client_Model = new WMS_Client_Model { CompanyName = dt.Rows[i]["CompanyName"].ToString(), ProductionName = dt.Rows[i]["ProductionName"].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_Client_Model); } return(list); }
/// <summary> /// 编辑结束事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ClientDataGrid_RowEditEnding(object sender, DataGridRowEditEndingEventArgs e) { wms_Client_Model = e.Row.Item as WMS_Client_Model; clientName = wms_Client_Model.CompanyName; }