private void BtnitemSave_Click(object sender, EventArgs e)
{
SqlConnection conn = sqlcon.getcon("");
//string strwhere = "select item_no,M_name,khdw,m_product.id as pid from m_product " +
// " where ITEM_NO ='" + this.TxtBarCode.Text.ToString() + "' ";
string strwhere = "SELECT ITEM_NO,M_name,khdw,S_COLOR,CO_CODE,m_SizeDetails.cade as SDcade,m_SizeDetails.[name] as SDName," +
"m_ProductSub.pid,M_productsub.id as colourID,m_SizeDetails.id sdid FROM m_product LEFT JOIN m_ProductSub " +
"ON m_ProductSub.PID=m_product.ID left join m_ProductSize on m_ProductSize.pid=m_product.ID " +
"LEFT join m_SizeDetails on m_SizeDetails.sizeid=m_ProductSize.sizeid " +
"where cast(ITEM_NO as varchar(20))+cast(CO_CODE as varchar(20))+m_SizeDetails.Cade='" + TxtBarCode.Text.ToString() + "' ";
DataSet ds = new DataSet();
SqlDataAdapter sqlDaper = new SqlDataAdapter(strwhere, conn);
//SqlDataAdapter sqlDaper = sqlcon.getread(strwhere);
conn.Open();
sqlDaper.Fill(ds, "HDS");
conn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ((DataTable)DGVDetailList.DataSource).NewRow();
dr["Item_no"] = ds.Tables["HDS"].Rows[0]["Item_no"].ToString();
dr["M_name"] = ds.Tables["HDS"].Rows[0]["M_name"].ToString();
dr["khdw"] = ds.Tables["HDS"].Rows[0]["khdw"].ToString();
dr["S_COLOR"] = ds.Tables["HDS"].Rows[0]["S_COLOR"].ToString();
dr["CO_CODE"] = ds.Tables["HDS"].Rows[0]["CO_CODE"].ToString();
dr["SDName"] = ds.Tables["HDS"].Rows[0]["SDName"].ToString();
dr["pid"] = ds.Tables["HDS"].Rows[0]["pid"].ToString();
dr["ColourID"] = ds.Tables["HDS"].Rows[0]["ColourID"].ToString();
dr["Sdid"] = ds.Tables["HDS"].Rows[0]["Sdid"].ToString();
dr["Qty"] = TxtQty.Text.ToString();
((DataTable)DGVDetailList.DataSource).Rows.Add(dr);
}
else
{
MessageBox.Show("查无此条码");
}
//TxtBarCode.Text = "";
TxtBarCode.Focus();
TxtBarCode.SelectAll();
}
private void BtnitemSave_Click(object sender, EventArgs e)
{
SqlConnection conn = sqlcon.getcon("");
string strwhere = "select item_no,M_name,khdw,co_code,s_color,m_SizeDetails.NAME as SDName,m_product.id as pid,m_ProductSub.id as colourID,m_SizeDetails.id as sdid from m_product " +
"left join m_productsize on m_product.id=m_productsize.pid " +
"left join m_ProductSub on m_product.id=m_ProductSub.pid " +
"left join m_SizeDetails on m_SizeDetails.sizeid=m_productsize.sizeid where cast(ITEM_NO as varchar(20))+cast(CO_CODE as varchar(20))+m_SizeDetails.Cade='" + this.TxtBarCode.Text.ToString() + "' ";
DataSet ds = new DataSet();
SqlDataAdapter sqlDaper = new SqlDataAdapter(strwhere, conn);
//SqlDataAdapter sqlDaper = sqlcon.getread(strwhere);
conn.Open();
sqlDaper.Fill(ds, "Rks");
conn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ((DataTable)DGVDetailList.DataSource).NewRow();
dr["Item_no"] = ds.Tables["RKs"].Rows[0]["Item_no"].ToString();
dr["co_code"] = ds.Tables["RKs"].Rows[0]["co_code"].ToString();
dr["s_color"] = ds.Tables["RKs"].Rows[0]["s_color"].ToString();
dr["M_name"] = ds.Tables["RKs"].Rows[0]["M_name"].ToString();
dr["khdw"] = ds.Tables["RKs"].Rows[0]["khdw"].ToString();
dr["SDName"] = ds.Tables["RKs"].Rows[0]["SDName"].ToString();
dr["pid"] = ds.Tables["RKs"].Rows[0]["pid"].ToString();
dr["colourID"] = ds.Tables["RKs"].Rows[0]["colourID"].ToString();
dr["sdid"] = ds.Tables["RKs"].Rows[0]["sdid"].ToString();
dr["Qty"] = TxtQty.Text.ToString();
((DataTable)DGVDetailList.DataSource).Rows.Add(dr);
}
else
{
MessageBox.Show("查无此条码");
}
//TxtBarCode.Text = "";
TxtBarCode.Focus();
TxtBarCode.SelectAll();
}
