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();
}
}
