// //查找治具信息 // private void btn_Search_Aseet_Click(object sender, System.Windows.RoutedEventArgs e) { Maticsoft.Model.Equipment_TypeList _temFindType = (Maticsoft.Model.Equipment_TypeList)cmb_Search_Type.SelectedItem; dgv_FixtureInfo.ItemsSource = MCP_CS.FixtureInfo.GetModelList(_temFindType.Remarks + " LIKE '%" + txb_Search_Value.Text.Trim() + "%'"); IsEnControl(false); ClearControlValue(); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.Equipment_TypeList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Equipment_TypeList set "); strSql.Append("ID=@ID,"); strSql.Append("Type=@Type,"); strSql.Append("Value=@Value,"); strSql.Append("Remarks=@Remarks"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Decimal, 9), new SqlParameter("@Type", SqlDbType.VarChar, 50), new SqlParameter("@Value", SqlDbType.VarChar, 50), new SqlParameter("@Remarks", SqlDbType.VarChar, 255) }; parameters[0].Value = model.ID; parameters[1].Value = model.Type; parameters[2].Value = model.Value; parameters[3].Value = model.Remarks; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.Equipment_TypeList model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Equipment_TypeList("); strSql.Append("ID,Type,Value,Remarks)"); strSql.Append(" values ("); strSql.Append("@ID,@Type,@Value,@Remarks)"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Decimal, 9), new SqlParameter("@Type", SqlDbType.VarChar, 50), new SqlParameter("@Value", SqlDbType.VarChar, 50), new SqlParameter("@Remarks", SqlDbType.VarChar, 255) }; parameters[0].Value = model.ID; parameters[1].Value = model.Type; parameters[2].Value = model.Value; parameters[3].Value = model.Remarks; int rows = dbs.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
// //选择查询条件 // private void cmb_SearchConition_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { Maticsoft.Model.Equipment_TypeList _temEquipment_Typelist = (Maticsoft.Model.Equipment_TypeList)cmb_SearchConition.SelectedItem; DataSet temds = MCP_CS.FixtureList.Get_Distinct_List(_temEquipment_Typelist.Remarks); cmb_SerachValue.DisplayMemberPath = _temEquipment_Typelist.Remarks; if (temds != null) { cmb_SerachValue.ItemsSource = temds.Tables[0].DefaultView; } }
/// <summary> /// 获取查找结果 /// </summary> /// <param name="_SearchConition">查找选项</param> /// <param name="_SearchValue">值</param> /// <param name="IsFuzzySearch">是否模糊查询</param> /// <returns></returns> private List <Maticsoft.Model.ConsumableInfo> GetSearchResult(Maticsoft.Model.Equipment_TypeList _SearchConition, string _SearchValue) { if (_SearchValue != "" || _SearchConition.Value != "所有耗材") { return(MCP_CS.ConsumableInfo.GetModelList(_SearchConition.Remarks + " LIKE '%" + _SearchValue + "%'")); } else { return(MCP_CS.ConsumableInfo.GetModelList("")); } }
// //查找 // private void btn_Search_Click(object sender, RoutedEventArgs e) { //获取用于查询的Sql列名称 Maticsoft.Model.Equipment_TypeList _temFindType = (Maticsoft.Model.Equipment_TypeList)cmb_SearchConition.SelectedItem; //给DataView 控件指定数据源 if (cmb_SerachValue.Text != "") { dgv_Date.ItemsSource = MCP_CS.UserInfo.GetModelList(_temFindType.Remarks + " LIKE '%" + cmb_SerachValue.Text.Trim() + "%'"); } else { dgv_Date.ItemsSource = MCP_CS.UserInfo.GetModelList(""); } lab_UserCount.Content = "记录 " + (dgv_Date.Items.Count - 1) + "条"; }
private ObservableCollection <Maticsoft.Model.FixtureList> GetSearchResult(Maticsoft.Model.Equipment_TypeList _SearchConition, string _SearchValue) { if (_SearchConition != null) { if (_SearchValue != "" || _SearchConition.Value != "所有设备") { return(MCP_CS.FixtureList.GetModelList1(_SearchConition.Remarks + " LIKE '%" + _SearchValue + "%'")); } else { return(MCP_CS.FixtureList.GetModelList1("")); } } else { return(MCP_CS.FixtureList.GetModelList1("")); } }
/// <summary> /// 获取查找结果 /// </summary> /// <param name="_SearchConition">查找选项</param> /// <param name="_SearchValue">值</param> /// <param name="IsFuzzySearch">是否模糊查询</param> /// <returns></returns> private List <Maticsoft.Model.EquipmentInfo> GetSearchResult(Maticsoft.Model.Equipment_TypeList _SearchConition, string _SearchValue) { if (_SearchValue != "" || _SearchConition.Value != "所有设备") { if (IsFuzzySearch) { return(MCP_CS._M_Equipment.GetModelList(_SearchConition.Remarks + " = '" + _SearchValue + "'")); } else { return(MCP_CS._M_Equipment.GetModelList(_SearchConition.Remarks + " LIKE '%" + _SearchValue + "%'")); } } else { return(MCP_CS._M_Equipment.GetModelList("")); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.Equipment_TypeList GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 ID,Type,Value,Remarks from tb_Equipment_TypeList "); strSql.Append(" where "); SqlParameter[] parameters = { }; Maticsoft.Model.Equipment_TypeList model = new Maticsoft.Model.Equipment_TypeList(); DataSet ds = dbs.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = decimal.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["Type"] != null && ds.Tables[0].Rows[0]["Type"].ToString() != "") { model.Type = ds.Tables[0].Rows[0]["Type"].ToString(); } if (ds.Tables[0].Rows[0]["Value"] != null && ds.Tables[0].Rows[0]["Value"].ToString() != "") { model.Value = ds.Tables[0].Rows[0]["Value"].ToString(); } if (ds.Tables[0].Rows[0]["Remarks"] != null && ds.Tables[0].Rows[0]["Remarks"].ToString() != "") { model.Remarks = ds.Tables[0].Rows[0]["Remarks"].ToString(); } return(model); } else { return(null); } }
// //查找治具 // private void btn_Search_Click(object sender, System.Windows.RoutedEventArgs e) { Maticsoft.Model.Equipment_TypeList _tem = (Maticsoft.Model.Equipment_TypeList)cmb_SearchConition.SelectedItem; dgv_FixtureList.ItemsSource = GetSearchResult(_tem, cmb_SerachValue.Text.Trim()); }
// //查找 // private void btn_Search_Click(object sender, RoutedEventArgs e) { Maticsoft.Model.Equipment_TypeList _temFindType = (Maticsoft.Model.Equipment_TypeList)cmb_Search_Type.SelectedItem; dgv_FixInfo_List.ItemsSource = MCP_CS.FixtureInfo.GetModelList(_temFindType.Remarks + "= '" + txb_Search_Value.Text.Trim() + "'"); }