protected void Y_PictureBind(object sender, Ext.Net.StoreRefreshDataEventArgs e)
{
lbinfo.Text = "";
try
{
if (TxtStyleId.Text.Trim().Length <= 0)
{
return;
}
string sql = "SELECT DISTINCT F.StyleId,F.ColorId,BrName,S_Name,St_Year,St_Month,St_Xl,St_Xz,St_Dl,P.Picture FROM dbo.Y_StyleFoundation F LEFT JOIN dbo.Y_StylePicture P ON F.StyleId=P.StyleId AND F.ColorId=P.ColorId WHERE F.StyleId='{0}'";
sql = string.Format(sql, TxtStyleId.Text.Trim().Replace("'", "").Replace("-", ""));
DataTable dt = DBHelper.WMSFactory.Y_StylePicture.Query(sql);
if (dt.Rows.Count <= 0)
{
lbinfo.Text = "没有任何记录，请检查款号是否正确！";
return;
}
Y_MainStore.DataSource = dt;
Y_MainStore.DataBind();
}
catch (Exception error)
{
this.lbinfo.Text = "异常：" + error.Message;
}
}
//查询
protected void BtnSearch_Click(object sender, EventArgs e)
{
lbinfo.Text = "";
try
{
if (TxtStyleId.Text.Trim().Length <= 0)
{
return;
}
string sql = "SELECT DISTINCT F.StyleId,F.ColorId,BrName,S_Name,St_Year,St_Month,St_Xl,St_Xz,St_Dl,P.Picture FROM dbo.Y_StyleFoundation F LEFT JOIN dbo.Y_StylePicture P ON F.StyleId=P.StyleId AND F.ColorId=P.ColorId WHERE F.StyleId='{0}'";
sql = string.Format(sql, TxtStyleId.Text.Trim().Replace("'", "").Replace("-", ""));
DataTable dt = DBHelper.WMSFactory.Y_StylePicture.Query(sql);
if (dt.Rows.Count <= 0)
{
lbinfo.Text = "没有任何记录，请检查款号是否正确！";
return;
}
lbBrand.Text = dt.Rows[0]["BrName"].ToString();
lbDl.Text = dt.Rows[0]["St_Dl"].ToString();
lbPinM.Text = dt.Rows[0]["S_Name"].ToString();
lbSeason.Text = dt.Rows[0]["St_Month"].ToString();
lbxl.Text = dt.Rows[0]["St_Xl"].ToString();
lbxz.Text = dt.Rows[0]["St_Xz"].ToString();
lbYear.Text = dt.Rows[0]["St_Year"].ToString();
Y_MainStore.DataSource = dt;
Y_MainStore.DataBind();
}
catch (Exception error)
{
this.lbinfo.Text = "异常：" + error.Message;
}
}
