private void BindGrid() { SaleOrderDts entitydts = new SaleOrderDts(); entitydts.ID = m_DID; entitydts.SelectByID(); string sql = "SELECT * FROM Sale_SaleOrderFabricCompSite WHERE MainID=" + SysString.ToDBString(m_ID); sql += " AND DID=" + SysString.ToDBString(m_DID); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0) { gridView1.GridControl.DataSource = SysUtils.Fill(sql); gridView1.GridControl.Show(); decimal TotalQty = 0; for (int i = 0; i < gridView1.RowCount; i++) { TotalQty += SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty")); } txtTotalQty.Text = TotalQty.ToString(); } else { sql = "SELECT ItemCode,ItemName,ItemStd,ItemModel,ComTypeID FROM UV1_Data_ItemCompositeDts WHERE MainID IN (SELECT ID FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entitydts.ItemCode) + ")"; DataTable dto = SysUtils.Fill(sql); for (int i = 0; i < dto.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["ItemCode"] = SysConvert.ToString(dto.Rows[i]["ItemCode"]); dr["ItemName"] = SysConvert.ToString(dto.Rows[i]["ItemName"]); dr["ItemStd"] = SysConvert.ToString(dto.Rows[i]["ItemStd"]); dr["ComTypeID"] = SysConvert.ToInt32(dto.Rows[i]["ComTypeID"]); dr["ColorName"] = entitydts.ColorName; dr["ItemModel"] = SysConvert.ToString(dto.Rows[i]["ItemModel"]); dr["SQty"] = entitydts.Qty; dr["RQty"] = entitydts.Qty; dr["Unit"] = "KG"; if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5405))) //转换为默认单位模式开启,目前支持转换为公斤模式 { string unitdefault = SysConvert.ToString(ProductParamSet.GetStrValueByID(5406)); //转换后默认单位 if (unitdefault != string.Empty) { dr["Unit"] = unitdefault; //entitydts[index].Unit = unitdefault;//赋值转换后单位 } } dr["SO"] = m_SO; dt.Rows.Add(dr); } gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); } }
private void BindGrid() { SaleOrderDts entitydts = new SaleOrderDts(); entitydts.ID = m_DID; entitydts.SelectByID(); string sql = "SELECT * FROM Sale_SaleOrderFabric WHERE Mainid=" + SysString.ToDBString(m_ID); sql += " AND DID=" + SysString.ToDBString(m_DID); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count > 0)//找到算料的绑定算料内容 { gridView1.GridControl.DataSource = SysUtils.Fill(sql); gridView1.GridControl.Show(); decimal TotalQty = 0; for (int i = 0; i < gridView1.RowCount; i++) { TotalQty += SysConvert.ToDecimal(gridView1.GetRowCellValue(i, "Qty")); } txtTotalQty.Text = TotalQty.ToString(); } else// 没有找到算料的绑定原始信息 { DataTable dto = new DataTable(); if (SaleItemType == (int)EnumItemType.坯布) { sql = "SELECT ItemCode,ItemName,ItemStd,ItemModel,ItemUnit FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entitydts.ItemCode); dto = SysUtils.Fill(sql); } else//成品 { sql = "SELECT ItemCode,ItemName,ItemStd,ItemModel,ItemUnit FROM Data_Item WHERE ItemCode IN (SELECT GreyFabItemCode FROM Data_Item WHERE ItemCode=" + SysString.ToDBString(entitydts.ItemCode) + ")"; dto = SysUtils.Fill(sql); } if (dto.Rows.Count != 0) /// 查找成品对应的坯布的信息 { for (int i = 0; i < dto.Rows.Count; i++) { DataRow dr = dt.NewRow(); if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(5009)))//面料的坯布启用可替换坯布功能,影响到订单坯布算料、坯布采购、织造等 { dr["CPItemCode"] = entitydts.ItemCode; dr["CPItemName"] = entitydts.ItemName; dr["CPItemStd"] = entitydts.ItemStd; dr["CPItemModel"] = entitydts.ItemModel; } dr["ItemCode"] = SysConvert.ToString(dto.Rows[i]["ItemCode"]); dr["ItemName"] = SysConvert.ToString(dto.Rows[i]["ItemName"]); dr["ItemStd"] = SysConvert.ToString(dto.Rows[i]["ItemStd"]); dr["ColorName"] = entitydts.ColorName; //坯布带入颜色 dr["MWidth"] = entitydts.MWidth; //坯布带入门幅 dr["MWeight"] = entitydts.MWeight; //坯布带入克重 dr["Needle"] = entitydts.Needle; //坯布带入针形 dr["ItemModel"] = SysConvert.ToString(dto.Rows[i]["ItemModel"]); dr["SQty"] = entitydts.Qty; dr["RQty"] = entitydts.Qty; dr["Unit"] = SysConvert.ToString(dto.Rows[i]["ItemUnit"]); //"KG"; dr["SO"] = m_SO; dt.Rows.Add(dr); } } gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); } }