//初始化 private void FormOutLibDetail_Load(object sender, EventArgs e) { List <StorageDetail> storageDetails = new List <StorageDetail>(); string sql = "select b.Id, b.MakeDate, g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,bi.Count,b.Maker,b.Remark from MD_BillItem as bi inner join MD_Bill as b on bi.Bill_ID=b.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID inner join MD_Storehouse as s on b.Storehouse_ID=s.ID inner join MD_Goods as g on bi.GoodsName=g.ID" + " where b.billtype_id=0 and g.Actived=1"; List <SqlParameter> list = new List <SqlParameter>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { storageDetails.Add(new StorageDetail() { Id = Convert.ToInt32(row["Id"]), MakeDate = row["MakeDate"].ToString(), GoodsName = row["GoodsName"].ToString(), GoodsFromName = row["GoodsFromName"].ToString(), GoodsCategoryName = row["GoodsCategoryName"].ToString(), StorehouseName = row["StorehouseName"].ToString(), Count = row["Count"].ToString(), Maker = row["Maker"].ToString(), Remark = row["Remark"].ToString() }); } gridControl1.DataSource = storageDetails; }
private void SelectDatas() { string sql = "select * from " + Program.DataBaseName + "..MD_Storehouse where Actived=1"; if (!string.IsNullOrEmpty(txtCode.Text.Trim())) { sql += " and StorehouseCode=" + "'" + txtCode.Text.Trim() + "'"; } if (!string.IsNullOrEmpty(txtName.Text.Trim())) { sql += " and StorehouseName like" + "'%" + txtName.Text.Trim() + "%'"; } List <SqlParameter> list = new List <SqlParameter>(); List <Storehouse> storehouses = new List <Storehouse>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { storehouses.Add(new Storehouse() { Id = Convert.ToInt32(row["id"]), StorehouseCode = row["StorehouseCode"].ToString(), StorehouseName = row["StorehouseName"].ToString(), Actived = Convert.ToBoolean(row["Actived"]), Remark = row["Remark"].ToString() }); } if (StorehouseWhereEvent != null) { StorehouseWhereEvent(storehouses); this.Close(); } }
private void FillData(int id) { string sql = "select * from " + Program.DataBaseName + "..MD_Storehouse where Actived=1 and id=" + id; List <SqlParameter> list = new List <SqlParameter>(); DataRow row = DataAccessUtil.ExecuteDataTable(sql, list).Rows[0]; txtCode.Text = row["StorehouseCode"].ToString(); txtName.Text = row["StorehouseName"].ToString(); txtRemark.Text = row["Remark"].ToString(); }
private void FillDatas() { string sql = "select * from " + Program.DataBaseName + "..MD_Company where id=" + Tag; List <SqlParameter> list = new List <SqlParameter>(); DataRow row = DataAccessUtil.ExecuteDataTable(sql, list).Rows[0]; txtCode.Text = row["CompanyCode"].ToString(); txtName.Text = row["CompanyName"].ToString(); lueType.EditValue = row["CompanyType"]; txtRemark.Text = row["Remark"].ToString(); }
private void FillData(int id) { string sql = "select * from " + Program.DataBaseName + "..MD_Goods" + " where id=@id and Actived=1"; List <SqlParameter> list = new List <SqlParameter>() { new SqlParameter("@id", id) }; DataRow row = DataAccessUtil.ExecuteDataTable(sql, list).Rows[0]; txtCode.Text = row["GoodsCode"].ToString(); txtName.Text = row["GoodsName"].ToString(); lueGoodsFrom.EditValue = row["GoodsFromId"]; lueGoodsCategory.EditValue = row["GoodsCategoryId"]; }
private void FillDataToViews(int id) { string sql = "select bi.*,b.* from MD_BillItem as bi inner join MD_Bill as b on bi.Bill_ID=b.id inner join MD_Goods as g on bi.GoodsName=g.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID where b.BillType_ID=1and bi.id=" + id; List <SqlParameter> list = new List <SqlParameter>(); try { DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); if (table.Rows.Count <= 0) { MessageBox.Show("老哥,没有数据啦...", "提示!!!", MessageBoxButtons.OK); return; } DataRow row = table.Rows[0]; txtPurOddNumber.Text = row["BillCode"].ToString(); deTime.Text = row["MakeDate"].ToString(); txtMaker.Text = row["Maker"].ToString(); lueCompany.EditValue = Convert.ToInt32(row["Company_ID"]); lueStorehouse.EditValue = Convert.ToInt32(row["Storehouse_ID"]); DataTable dt = new DataTable(); dt.Columns.Add("GoodsCode", typeof(string)); dt.Columns.Add("GoodsName", typeof(string)); dt.Columns.Add("GoodsFromName", typeof(string)); dt.Columns.Add("GoodsCategoryName", typeof(string)); dt.Columns.Add("UnitPrice", typeof(decimal)); dt.Columns.Add("Count", typeof(decimal)); dt.Columns.Add("Total", typeof(decimal)); gridControl1.DataSource = dt; DataRow newRow = dt.NewRow(); dt.Rows.Add(newRow); newRow["GoodsCode"] = row["GoodsCode"]; newRow["GoodsName"] = row["GoodsName"]; //这里给lookUpEdit赋值的时候是需要赋值ID的.....千万记住 newRow["GoodsFromName"] = row["GoodsFrom_ID"]; newRow["GoodsCategoryName"] = row["GoodsCategory_ID"]; newRow["UnitPrice"] = row["UnitPrice"]; newRow["Count"] = row["Count"]; newRow["Total"] = row["Total"]; } catch (Exception e) { ErrorHandler.OnError(e); } }
private void LoadlueCompanyData() { string sql = "select * from " + Program.DataBaseName + "..MD_Company where Actived=1 and CompanyType=1"; List <SqlParameter> list = new List <SqlParameter>(); List <Company> companies = new List <Company>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { companies.Add(new Company() { Id = Convert.ToInt32(row["Id"]), CompanyCode = row["CompanyCode"].ToString(), CompanyName1 = row["CompanyName"].ToString() }); } lueCompany.Properties.DisplayMember = "CompanyName1"; lueCompany.Properties.ValueMember = "Id"; lueCompany.Properties.DataSource = companies; }
private void LoadLueStorehouseData() { string sql = "select * from " + Program.DataBaseName + "..MD_Storehouse where Actived=1"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <Storehouse> storehouses = new List <Storehouse>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, sqlParameters); foreach (DataRow row in table.Rows) { storehouses.Add(new Storehouse() { Id = Convert.ToInt32(row["Id"]), StorehouseCode = row["StorehouseCode"].ToString(), StorehouseName = row["StorehouseName"].ToString() }); } lueStorehouse.Properties.DisplayMember = "StorehouseName"; lueStorehouse.Properties.ValueMember = "Id"; lueStorehouse.Properties.DataSource = storehouses; }
private void LoadLueGoodsNameData() { string sql = "select * from " + Program.DataBaseName + "..MD_Goods where Actived=1"; List <SqlParameter> list = new List <SqlParameter>(); List <Goods> goodsNameList = new List <Goods>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { goodsNameList.Add(new Goods() { Id = Convert.ToInt32(row["Id"]), GoodsCode = row["GoodsCode"].ToString(), GoodsName = row["GoodsName"].ToString() }); } lueGoodsName.ValueMember = "Id"; lueGoodsName.DisplayMember = "GoodsName"; lueGoodsName.DataSource = goodsNameList; }
private void LoadStorehouseList() { string sql = "select * from " + Program.DataBaseName + "..MD_Storehouse where Actived=1"; List <SqlParameter> list = new List <SqlParameter>(); List <Storehouse> storehouses = new List <Storehouse>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { storehouses.Add(new Storehouse() { Id = Convert.ToInt32(row["id"]), StorehouseCode = row["StorehouseCode"].ToString(), StorehouseName = row["StorehouseName"].ToString(), Actived = Convert.ToBoolean(row["Actived"]), Remark = row["Remark"].ToString() }); } gridControl1.DataSource = storehouses; }
private void LoadAllCompany() { string sql = "select * from " + Program.DataBaseName + "..MD_Company where Actived=1"; List <SqlParameter> list = new List <SqlParameter>(); List <Company> companies = new List <Company>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { companies.Add(new Company() { Id = Convert.ToInt32(row["id"]), CompanyCode = row["CompanyCode"].ToString(), CompanyName1 = row["CompanyName"].ToString(), CompanyType = Convert.ToInt32(row["CompanyType"]), Actived = Convert.ToBoolean(row["Actived"]), Remark = row["Remark"].ToString() }); } gridControl1.DataSource = companies; }
private void DeleteGoods() { int selectRow = gridView1.GetSelectedRows()[0]; //获得选中的第一行的下标 int id = Convert.ToInt32(gridView1.GetRowCellValue(selectRow, gridView1.Columns["Id"])); //根据下标选择列值 //删除先看入库明细和出库明细是否有此商品的单据,如有先删除明细 string sqls = "select * from " + Program.DataBaseName + "..MD_BillItem where GoodsName=" + id; List <SqlParameter> sqlParameters = new List <SqlParameter>(); if (DataAccessUtil.ExecuteDataTable(sqls, sqlParameters).Rows.Count > 0) { MessageBox.Show("确定要删除吗?\r\n当前要删除的商品在单据中存在,请先删除单据..", "提示", MessageBoxButtons.OK); return; } string sql = "update " + Program.DataBaseName + "..MD_Goods set" + " Actived=0 where id=" + id; List <SqlParameter> list = new List <SqlParameter>(); if (DataAccessUtil.ExecuteNonQuery(sql, list) > 0) { LoadAllGoods(); } //gridView1.DeleteRow(gridView1.FocusedRowHandle); }
private void gridView1_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { DataRow row = gridView1.GetFocusedDataRow(); if (null != row) { string unitPrice = row["UnitPrice"].ToString(); string goodsName = row["GoodsName"].ToString(); string count = row["Count"].ToString(); string goodFromName = row["GoodsFromName"].ToString(); string goodsCategoryName = row["GoodsCategoryName"].ToString(); if (!string.IsNullOrEmpty(goodsName) && !string.IsNullOrEmpty(count) && !string.IsNullOrEmpty(goodFromName) && !string.IsNullOrEmpty(goodsCategoryName)) { // string sql = // "select g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,sum(bi.Count) as lastcount from MD_BillItem as bi inner join MD_Goods as g on bi.GoodsName=g.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID inner join MD_Bill as b on bi.Bill_ID=b.ID inner join MD_Storehouse as s on b.Storehouse_ID=s.ID where b.BillType_ID=1 and bi.GoodsName=" + goodsName + " and bi.GoodsFrom_ID=" + goodFromName + " and bi.GoodsCategory_ID=" + goodsCategoryName + "group by g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID"; string sql = "select * from MD_Stock where Goods_ID=" + goodsName + " and GoodsFrom_ID=" + goodFromName + " and GoodsCategory_ID=" + goodsCategoryName; List <SqlParameter> list = new List <SqlParameter>(); DataRow row1 = DataAccessUtil.ExecuteDataTable(sql, list).Rows[0]; if (Convert.ToDecimal(row1["count"]) < Convert.ToDecimal(count)) { MessageBox.Show("当前库存中并没有这么多商品,只有" + Convert.ToDecimal(row1["count"]) + "个!!", "提示", MessageBoxButtons.OK); row["Count"] = 0; } } if (!string.IsNullOrEmpty(unitPrice) && !string.IsNullOrEmpty(count)) { row["Total"] = Convert.ToDecimal(unitPrice) * Convert.ToDecimal(row["Count"].ToString()); } } }
public void formCompanyWhere_SelectCompanyEvent(Company company) { string sql = "select * from " + Program.DataBaseName + "..MD_Company where actived=1"; if (!string.IsNullOrEmpty(company.CompanyCode)) { sql += " and CompanyCode=" + "'" + company.CompanyCode + "'"; } if (!string.IsNullOrEmpty(company.CompanyName1)) { sql += " and CompanyName like" + "'%" + company.CompanyName1 + "%'"; } if (company.CompanyType == 0 || company.CompanyType == 1) { sql += " and CompanyType=" + company.CompanyType; } List <SqlParameter> list = new List <SqlParameter>(); List <Company> companies = new List <Company>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); foreach (DataRow row in table.Rows) { companies.Add(new Company() { Id = Convert.ToInt32(row["id"]), CompanyCode = row["CompanyCode"].ToString(), CompanyName1 = row["CompanyName"].ToString(), CompanyType = Convert.ToInt32(row["CompanyType"]), Remark = row["Remark"].ToString() }); } gridControl1.DataSource = companies; }
private void LoadStockDataList() { //所有的入库单 //select g.ID as gid,gf.ID as gfid,gc.ID as gcid,g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,sum(bi.Count) as lastcount from MD_BillItem as bi inner join MD_Goods as g on bi.GoodsName=g.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID inner join MD_Bill as b on bi.Bill_ID=b.ID inner join MD_Storehouse as s on b.Storehouse_ID=s.ID where b.BillType_ID=1 group by g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,g.ID,gf.ID,gc.ID //所有的出库单 //select g.ID as gid,gf.ID as gfid,gc.ID as gcid,g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,sum(bi.Count) as lastcount from MD_BillItem as bi inner join MD_Goods as g on bi.GoodsName=g.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID inner join MD_Bill as b on bi.Bill_ID=b.ID inner join MD_Storehouse as s on b.Storehouse_ID=s.ID where b.BillType_ID=0 group by g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,g.ID,gf.ID,gc.ID string sql = "select g.ID as gid,gf.ID as gfid,gc.ID as gcid,b.Storehouse_ID,g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,sum(bi.Count) as lastcount from MD_BillItem as bi inner join MD_Goods as g on bi.GoodsName=g.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID inner join MD_Bill as b on bi.Bill_ID=b.ID inner join MD_Storehouse as s on b.Storehouse_ID=s.ID where b.BillType_ID=1 group by g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,g.ID,gf.ID,gc.ID,b.Storehouse_ID"; List <SqlParameter> sqlParameters = new List <SqlParameter>(); List <StockDetail> stockDetailsIn = new List <StockDetail>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, sqlParameters); foreach (DataRow row in table.Rows) { StockDetail stock = new StockDetail(); stock.GoodsName = row["GoodsName"].ToString(); //名称 stock.GoodsFromName = row["GoodsFromName"].ToString(); //产地 stock.GoodsCategoryName = row["GoodsCategoryName"].ToString(); //品种 stock.StorehouseName = row["StorehouseName"].ToString(); //仓库名称 stock.LastCount = row["lastcount"].ToString(); //每个商品的最终入库数量 stock.GoodsId = Convert.ToInt32(row["gid"]); stock.GoodsFromId = Convert.ToInt32(row["gfid"]); stock.GoodsCategoryId = Convert.ToInt32(row["gcid"]); stock.StorehouseId = Convert.ToInt32(row["Storehouse_ID"]); stockDetailsIn.Add(stock); //所有入库结果 } string outSql = "select g.ID as gid,gf.ID as gfid,gc.ID as gcid,b.Storehouse_ID,g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,sum(bi.Count) as lastcount from MD_BillItem as bi inner join MD_Goods as g on bi.GoodsName=g.ID inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID inner join MD_Bill as b on bi.Bill_ID=b.ID inner join MD_Storehouse as s on b.Storehouse_ID=s.ID where b.BillType_ID=0 group by g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,s.StorehouseName,b.BillType_ID,g.ID,gf.ID,gc.ID,b.Storehouse_ID"; List <StockDetail> stockDetailsOut = new List <StockDetail>(); DataTable tableOut = DataAccessUtil.ExecuteDataTable(outSql, sqlParameters); foreach (DataRow row in tableOut.Rows) { StockDetail stock = new StockDetail(); stock.GoodsName = row["GoodsName"].ToString(); //名称 stock.GoodsFromName = row["GoodsFromName"].ToString(); //产地 stock.GoodsCategoryName = row["GoodsCategoryName"].ToString(); //品种 stock.StorehouseName = row["StorehouseName"].ToString(); //仓库名称 stock.LastCount = row["lastcount"].ToString(); //每个商品的最终出库数量 stock.GoodsId = Convert.ToInt32(row["gid"]); stock.GoodsFromId = Convert.ToInt32(row["gfid"]); stock.GoodsCategoryId = Convert.ToInt32(row["gcid"]); stock.StorehouseId = Convert.ToInt32(row["Storehouse_ID"]); stockDetailsOut.Add(stock); //所有出库结果 } List <StockDetail> lastShowDetails = new List <StockDetail>(); foreach (StockDetail detailIn in stockDetailsIn) { foreach (StockDetail detailOut in stockDetailsOut) { if (detailIn.GoodsId == detailOut.GoodsId && detailIn.GoodsFromId == detailOut.GoodsFromId && detailIn.GoodsCategoryId == detailOut.GoodsCategoryId) { StockDetail stock = new StockDetail(); stock.GoodsId = detailIn.GoodsId; stock.GoodsFromId = detailIn.GoodsFromId; stock.GoodsCategoryId = detailIn.GoodsCategoryId; stock.StorehouseId = detailIn.StorehouseId; stock.GoodsName = detailIn.GoodsName; stock.GoodsFromName = detailIn.GoodsFromName; stock.GoodsCategoryName = detailIn.GoodsCategoryName; stock.StorehouseName = detailIn.StorehouseName; stock.LastCount = (Convert.ToDecimal(detailIn.LastCount) - Convert.ToDecimal(detailOut.LastCount)).ToString(); lastShowDetails.Add(stock); } else { lastShowDetails.Add(detailIn); } } } gridControl1.DataSource = lastShowDetails; //将库存量录入数据库 foreach (StockDetail detail in lastShowDetails) { string insertSql = "insert into " + Program.DataBaseName + "..MD_Stock(Goods_ID,Storehouse_ID,Count,GoodsFrom_ID,GoodsCategory_ID) values(@goods_ID,@storehouse_ID,@coun,@goodsFrom_ID,@goodsCategory_ID)"; List <SqlParameter> list = new List <SqlParameter>() { new SqlParameter("@goods_ID", detail.GoodsId), new SqlParameter("@storehouse_ID", detail.StorehouseId), new SqlParameter("@coun", Convert.ToDecimal(detail.LastCount)), new SqlParameter("@goodsFrom_ID", detail.GoodsFromId), new SqlParameter("@goodsCategory_ID", detail.GoodsCategoryId), }; try { DataAccessUtil.ExecuteNonQuery(insertSql, list); } catch (Exception e) { ErrorHandler.OnError(e); } } }
//导出报表 private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { DataTable table = DataAccessUtil.ExecuteDataTable("Select * from MD_Stock ", new List <SqlParameter>()); AExcelHelper.ExportDTtoExcel(table, "导出的表", "C:\\Users\\Administrator\\Desktop\\a.xls"); }
private void FillDataToViews(int id) { string sql = string.Empty; if (id == 1) { sql = "select top 1 g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,bi.*,b.* " + "from MD_BillItem as bi inner join MD_Bill as b on bi.Bill_ID=b.id " + "inner join MD_Goods as g on bi.GoodsName=g.ID " + "inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID " + "inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID where b.BillType_ID=0"; } else { sql = "select g.GoodsName,gf.GoodsFromName,gc.GoodsCategoryName,bi.*,b.* " + "from MD_BillItem as bi inner join MD_Bill as b on bi.Bill_ID=b.id " + "inner join MD_Goods as g on bi.GoodsName=g.ID " + "inner join MD_GoodsFrom as gf on bi.GoodsFrom_ID=gf.ID " + "inner join MD_GoodsCategory as gc on bi.GoodsCategory_ID=gc.ID where b.BillType_ID=0 and bi.id=" + id; } List <SqlParameter> list = new List <SqlParameter>(); DataTable table = DataAccessUtil.ExecuteDataTable(sql, list); if (table.Rows.Count <= 0) { MessageBox.Show("老哥,没有数据啦...", "提示!!!", MessageBoxButtons.OK); return; } DataRow row = table.Rows[0]; txtPurOddNumber.Text = row["BillCode"].ToString(); deTime.Text = row["MakeDate"].ToString(); txtMaker.Text = row["Maker"].ToString(); lueCompany.EditValue = Convert.ToInt32(row["Company_ID"]); lueStorehouse.EditValue = Convert.ToInt32(row["Storehouse_ID"]); DataTable dt = new DataTable(); dt.Columns.Add("GoodsCode", typeof(string)); dt.Columns.Add("GoodsName", typeof(string)); dt.Columns.Add("GoodsFromName", typeof(string)); dt.Columns.Add("GoodsCategoryName", typeof(string)); dt.Columns.Add("UnitPrice", typeof(decimal)); dt.Columns.Add("Count", typeof(decimal)); dt.Columns.Add("Total", typeof(decimal)); gridControl1.DataSource = dt; DataRow newRow = dt.NewRow(); dt.Rows.Add(newRow); newRow["GoodsCode"] = row["GoodsCode"]; // newRow["GoodsName"] = row["GoodsName"]; lueGoodsName.NullText = row["GoodsName"].ToString(); // newRow["GoodsFromName"] = row["GoodsFromName"]; lueGoodsFromName.NullText = row["GoodsFromName"].ToString(); // newRow["GoodsCategoryName"] = row["GoodsCategoryName"]; lueGoodsCategoryName.NullText = row["GoodsCategoryName"].ToString(); newRow["UnitPrice"] = row["UnitPrice"]; newRow["Count"] = row["Count"]; newRow["Total"] = row["Total"]; }