WPF之超市通信息管理系统项目的基本查询

最新推荐文章于 2024-07-04 11:25:58 发布

上天试道者

最新推荐文章于 2024-07-04 11:25:58 发布

阅读量580

点赞数

分类专栏： WPF

本文链接：https://blog.csdn.net/weixin_44548814/article/details/97530220

版权

WPF 专栏收录该内容

22 篇文章 2 订阅

订阅专栏

主页面
 button嵌套报错
超市通信息管理系统项目仓库业务主要包括商品存货查询、内部调拨单，盘点等。
所以我设置嵌套页面，可能不好看，如下图：
在这里插入图片描述
1.商品存货查询
主要查询商品仓库的存货及供应货的商品存货，在主窗口下选择【仓库管理】【商品存货查询】，则进入【商品存货查询】窗口，此窗口共分三页，库存存货查询和主供货商存货查询和实时库存查询。
我用选项卡来搭这个商品存货查询。
商品存货查询查询操作如下，选取查询关键字段，并输入查询值，然后单击【查询】按钮，系统将在列表框中显示符合查询值的商品信息。
供货商存货查询查询操作如下：在供应商输入框输入供应商编号或点击手指图标的快捷按钮，在弹出的供货商选择框中选择要查询的供应商，然后单击【查询】按钮，系统将显示符合条件的商品信息。
实时库存查询查询操作如下：输入相关的查询值后，然后单击【查询】按钮，系统将显示符合条件的商品信息。
商品存货查询的页面，如下图：
在这里插入图片描述
数据库代码：

--查询商品信息
	IF(@type='Frm_CommodityInventoryEnquiry')
  SELECT ROW_NUMBER () over(order by  CommodityInfor.CommodityInforID) as number,
                   CommodityInfor.CommodityName, CommodityInfor.CommodityType, CommodityInfor.CommodityCode, 
                   CommodityInfor.SecondCode, CommodityInfor.Unit, CommodityInfor.Specification, CommodityInfor.RetailPrice, 
                   CommodityInfor.InterPrice, CommodityInfor.WholesalePrice, CommodityInfor.MemberPrice, 
                   CommodityInfor.ExpirationDate, CommodityInfor.ProducingDate, CommodityInfor.PictureData, 
                   CommodityInfor.BrandType, CommodityWarehouseInformation.WarehouseCount, CommodityInfor.Remark, 
                   CommodityWarehouseInformation.NowCount
FROM      CommodityWarehouseInformation INNER JOIN
                   CommodityInfor ON CommodityWarehouseInformation.CommodityInforID = CommodityInfor.CommodityInforID

服务层代码：

DAL.DALMethod myDALMethod = new DAL.DALMethod();
        //查询商品信息
        [OperationContract]
        public DataSet Frm_CommodityInventoryEnquiry()
        {
            //1.0实例化对象数组(序列化参数)
            SqlParameter[] mySqlParameters =
            {
                //定义参数，以及传递参数的类型
                new SqlParameter("@type",SqlDbType.NChar),
            };
            //1.1 给对象赋值
            mySqlParameters[0].Value = "Frm_CommodityInventoryEnquiry";
            DataTable myDataTable = myDALMethod.QueryDataTable("StoreManagement_Frm_MerchandiseInventory", mySqlParameters);
            DataSet myDataSet = new DataSet();
            //添加参数
            myDataSet.Tables.Add(myDataTable);
            //返回值
            return myDataSet;
        }

客户端C#代码：

 BLL.StoreManagement.Frm_MerchandiseInventory.Frm_MerchandiseInventoryClient myFrm_MerchandiseInventory = new BLL.StoreManagement.Frm_MerchandiseInventory.Frm_MerchandiseInventoryClient();
 private void DW1_Loaded(object sender, RoutedEventArgs e)
        {

            PublicStaticMothd.SetDgStyle(dgTraveller);
            PublicStaticMothd.SetDgStyle(DGSupplier);
            PublicStaticMothd.SetDgStyle(DGWarehouse);
            #region  绑定信息
            SelectDataGrid();
            #endregion
        }
        public void SelectDataGrid()
        {
            //执行服务端的方法获取表格 数据
            DataTable dt = myFrm_MerchandiseInventory.Frm_CommodityInventoryEnquiry().Tables[0];
            DataTable data = myFrm_MerchandiseInventory.Supplier_Frm_CommodityInventoryEnquiry().Tables[0];
            DataTable dd = myFrm_MerchandiseInventory.Warehouse_Frm_CommodityInventoryEnquiry().Tables[0];
            //绑定表格
            dgTraveller.ItemsSource = dt.DefaultView;
            DGSupplier.ItemsSource = data.DefaultView;
            DGWarehouse.ItemsSource = dd.DefaultView;
            
        }

客户端XAML代码：

<TabControl DockPanel.Dock="Left">
            <TabControl.Background>
                <ImageBrush ImageSource="/Image/0007.jpg"></ImageBrush>
            </TabControl.Background>
            <TabItem Header="库存存货查询">
                <Grid >
                    <Grid.RowDefinitions>
                        <RowDefinition Height="0.2*"/>
                        <RowDefinition Height="0.5*"/>
                        <RowDefinition Height="0.2*"/>
                        <RowDefinition Height="3*"/>
                    </Grid.RowDefinitions>
                    <Grid Grid.Row="1">
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                        </Grid.ColumnDefinitions>
                        <TextBlock Grid.Row="1" HorizontalAlignment="Right" VerticalAlignment="Center" >商品名称：</TextBlock>
                        <TextBox x:Name="txt_Mane" Grid.Row="1" Grid.Column="1" Height="20"></TextBox>
                        <TextBlock Grid.Row="1" Grid.Column="2" HorizontalAlignment="Right" VerticalAlignment="Center">商品编码：</TextBlock>
                        <TextBox x:Name="txt_Select"  Grid.Row="1" Grid.Column="3" Height="20"></TextBox>
                        <Button x:Name="CX_MerchandiseInventory" Grid.Column="4" Margin="10" Click="CX_MerchandiseInventory_Click">查询</Button>
                    </Grid>
                    <Grid Grid.Row="3">
                        <DataGrid x:Name="dgTraveller" IsReadOnly="True" AutoGenerateColumns="False" 
                  CanUserResizeColumns="False" CanUserResizeRows="False"  SelectionMode="Single" 
                  CanUserReorderColumns="False" AlternationCount="2"  RowHeaderWidth="0" CanUserAddRows="False" SnapsToDevicePixels = "True"
                          >
                            <DataGrid.Background>
                                <LinearGradientBrush StartPoint="0,0" EndPoint="0,1">
                                    <LinearGradientBrush.GradientStops>
                                        <GradientStop Color="#FFE6F2F7" Offset="0"/>
                                        <GradientStop Color="White" Offset="0.1"/>
                                        <GradientStop Color="White" Offset="0.4"/>
                                        <GradientStop Color="#FFE6F2F7" Offset="0.81"/>
                                    </LinearGradientBrush.GradientStops>
                                </LinearGradientBrush>
                            </DataGrid.Background>
                            <DataGrid.Columns>
                                <DataGridTextColumn Header="序号"  Binding="{Binding number}" Width="40" IsReadOnly="True" />
                                <DataGridTextColumn Header="商品条码" Width="100" Binding="{Binding CommodityCode}"/>
                                <DataGridTextColumn Header="单位" Width="100" Binding="{Binding Unit }"/>
                                <DataGridTextColumn Header="规格" Width="100" Binding="{Binding Specification}"/>
                                <DataGridTextColumn Header="店内码" Width="100" Binding="{Binding SecondCode}"/>
                                <DataGridTextColumn Header="商品名称" Width="100" Binding="{Binding CommodityName}"/>
                                <DataGridTextColumn Header="类别" Width="100" Binding="{Binding CommodityType}"/>
                                <DataGridTextColumn Header="进货价" Width="100" Binding="{Binding InterPrice}"/>
                                <DataGridTextColumn Header="批发价" Width="100" Binding="{Binding number}"/>
                                <DataGridTextColumn Header="零售价" Width="100" Binding="{Binding WholesalePrice}"/>
                                <DataGridTextColumn Header="会员价" Width="100" Binding="{Binding MemberPrice}"/>
                                <DataGridTextColumn Header="库存量" Width="100" Binding="{Binding WarehouseCount}"/>
                                <DataGridTextColumn Header="现有库存" Width="100" Binding="{Binding NowCount}"/>
                                <DataGridTextColumn Header="最近更改日期" Width="100" />
                            </DataGrid.Columns>
                        </DataGrid>
                    </Grid>
                </Grid>

            </TabItem>
            <TabItem Header="供货商存货查询" >
                <Grid >
                    <Grid.RowDefinitions>
                        <RowDefinition Height="0.2*"/>
                        <RowDefinition Height="0.5*"/>
                        <RowDefinition Height="0.2*"/>
                        <RowDefinition Height="3*"/>
                    </Grid.RowDefinitions>
                    <Grid Grid.Row="1">
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                        </Grid.ColumnDefinitions>
                        <TextBlock Grid.Row="1" HorizontalAlignment="Right" VerticalAlignment="Center" >供应商名称：</TextBlock>
                        <TextBox Grid.Row="1" Grid.Column="1" Height="20"></TextBox>
                        <TextBlock Grid.Row="1" Grid.Column="2" HorizontalAlignment="Right" VerticalAlignment="Center">供应商编码：</TextBlock>
                        <TextBox Grid.Row="1" Grid.Column="3" Height="20"></TextBox>
                        <Button Grid.Column="4" Margin="10">查询</Button>
                    </Grid>
                    <Grid Grid.Row="3">
                        <DataGrid x:Name="DGSupplier" IsReadOnly="True" AutoGenerateColumns="False" 
                  CanUserResizeColumns="False" CanUserResizeRows="False"  SelectionMode="Single" 
                  CanUserReorderColumns="False" AlternationCount="2"  RowHeaderWidth="0" CanUserAddRows="False" SnapsToDevicePixels = "True">
                            <DataGrid.Background>
                                <LinearGradientBrush StartPoint="0,0" EndPoint="0,1">
                                    <LinearGradientBrush.GradientStops>
                                        <GradientStop Color="#FFE6F2F7" Offset="0"/>
                                        <GradientStop Color="White" Offset="0.1"/>
                                        <GradientStop Color="White" Offset="0.4"/>
                                        <GradientStop Color="#FFE6F2F7" Offset="0.81"/>
                                    </LinearGradientBrush.GradientStops>
                                </LinearGradientBrush>
                            </DataGrid.Background>
                            <DataGrid.Columns  >
                                <DataGridTextColumn Header="序号" Width="100" Binding="{Binding number}"/>
                                <DataGridTextColumn Header="编号" Width="100" Binding="{Binding SupplierNum}"/>
                                <DataGridTextColumn Header="厂商ID" Width="100" Visibility="Collapsed" Binding="{Binding FacturerID}"/>
                                <DataGridTextColumn Header="供应商名称" Width="100"  Binding="{Binding SupplierName}"/>
                                <DataGridTextColumn Header="区域" Width="100" Binding="{Binding SupplierArea}" />
                                <DataGridTextColumn Header="类型" Width="100" Binding="{Binding SupplierType}" />
                                <DataGridTextColumn Header="传真" Width="100" Binding="{Binding Fax}"/>
                                <DataGridTextColumn Header="电话" Width="100" Binding="{Binding LinkPhone}" />
                                <DataGridTextColumn Header="结账方式" Width="100" Binding="{Binding AccountsType}"/>
                                <!--<DataGridTextColumn Header="每月结账日期" Width="100" Binding="{Binding AccountsType}" />
                                <DataGridTextColumn Header="结账周期" Width="100" />-->
                                <DataGridTextColumn Header="联系人" Width="100" Binding="{Binding SupplierNum}" />
                                <DataGridTextColumn Header="邮编" Width="100" Binding="{Binding LinkMan}" />
                                <DataGridTextColumn Header="电子邮件" Width="100" Binding="{Binding Postcode}" />
                                <DataGridTextColumn Header="地址" Width="100" Binding="{Binding LinkAddress}" />
                                <DataGridTextColumn Header="帐号" Width="100" Binding="{Binding AccountCode}"/>
                                <DataGridTextColumn Header="开户行" Width="100" Binding="{Binding Bank}" />
                                <DataGridTextColumn Header="税务登记号" Width="100" Binding="{Binding TaxRegisterCode}"/>
                                <DataGridTextColumn Header="备注" Width="100" Binding="{Binding Remark}" />
                            </DataGrid.Columns>
                        </DataGrid>
                    </Grid>
                </Grid>
            </TabItem>
            <TabItem Header="实时库存查询">
                <Grid >
                    <Grid.RowDefinitions>
                        <RowDefinition Height="0.2*"/>
                        <RowDefinition Height="0.5*"/>
                        <RowDefinition Height="0.2*"/>
                        <RowDefinition Height="3*"/>
                    </Grid.RowDefinitions>
                    <Grid Grid.Row="1">
                        <Grid.ColumnDefinitions>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                            <ColumnDefinition/>
                        </Grid.ColumnDefinitions>
                        <TextBlock Grid.Row="1" HorizontalAlignment="Right" VerticalAlignment="Center" >商品名称：</TextBlock>
                        <TextBox Grid.Row="1" Grid.Column="1" Height="20"></TextBox>
                        <TextBlock Grid.Row="1" Grid.Column="2" HorizontalAlignment="Right" VerticalAlignment="Center">仓库：</TextBlock>
                        <ComboBox Grid.Row="1" Grid.Column="3" Height="20"></ComboBox>
                        <Button Grid.Column="4" Margin="10">查询</Button>
                    </Grid>
                    <Grid Grid.Row="3">
                        <DataGrid x:Name="DGWarehouse" IsReadOnly="True" AutoGenerateColumns="False" 
                  CanUserResizeColumns="False" CanUserResizeRows="False"  SelectionMode="Single" 
                  CanUserReorderColumns="False" AlternationCount="2"  RowHeaderWidth="0" CanUserAddRows="False" SnapsToDevicePixels = "True"
                          >
                            <DataGrid.Background>
                                <LinearGradientBrush StartPoint="0,0" EndPoint="0,1">
                                    <LinearGradientBrush.GradientStops>
                                        <GradientStop Color="#FFE6F2F7" Offset="0"/>
                                        <GradientStop Color="White" Offset="0.1"/>
                                        <GradientStop Color="White" Offset="0.4"/>
                                        <GradientStop Color="#FFE6F2F7" Offset="0.81"/>
                                    </LinearGradientBrush.GradientStops>
                                </LinearGradientBrush>
                            </DataGrid.Background>
                            <DataGrid.Columns >
                                <DataGridTextColumn Header="序号" Binding="{Binding number}" Width="80" />
                                <DataGridTextColumn Header="商品名称" Binding="{Binding CommodityName}"  Width="120" />
                                <DataGridTextColumn Header="仓库代码" Binding="{Binding WarehouseCode}"  Width="80" />
                                <DataGridTextColumn Header="仓库名称" Binding="{Binding WarehouseName}"  Width="70"  />
                                <DataGridTextColumn Header="数量" Binding="{Binding WarehouseCount}"  Width="70"  />
                                <DataGridTextColumn Header="状态" Binding="{Binding WarehouseStatus}"  Width="70"  />
                            </DataGrid.Columns>
                        </DataGrid>
                    </Grid>
                </Grid>

            </TabItem>
            
        </TabControl>