rezarko
شنبه 10 فروردین 1392, 16:11 عصر
سلام. من یه فرم جستو جو دارم که با کد زیر جستو جو میکنه و اطلاعات رو داخل متغیر war میریزه.حالا میخوام این اطلاعات رو به فرم دیگه ای پاس بدم.
using (NovinPendarEntities3 context = new NovinPendarEntities3())
{
var War = context.C_Wars.AsQueryable();
if (txt_NAme.Text.Trim() != string.Empty)
{
War = War.Where(p => p.war_Name.Contains(txt_NAme.Text.Trim()));
}
if (txt_ID.Text.Trim() != string.Empty && txt_ToID.Text.Trim() != string.Empty)
{
int from = Convert.ToInt32(txt_ID.Text);
int to = Convert.ToInt32(txt_ToID.Text);
War = War.Where(p => p.war_ID.CompareTo(from) >= 0 &&
p.war_ID.CompareTo(to) <= 0);
}
if (txt_FromPrice.Text.Trim() != string.Empty && txt_ToPrice.Text.Trim() != string.Empty)
{
decimal fromPrice = Convert.ToDecimal(txt_FromPrice.Text);
decimal toPrice = Convert.ToDecimal(txt_ToPrice.Text);
War = War.Where(p => p.war_Price.Value.CompareTo(fromPrice) >= 0 &&
p.war_Price.Value.CompareTo(toPrice) <= 0);
}
if (cmb_Group.Text.Trim() != string.Empty)
{
if (!odb._Stors.Any(item => item.str_Name == cmb_Group.Text))
{
MessageBox.Show("لطفا نام انبار را صحیح وارد کنید");
}
else
{
var s = (from d in odb._Stors where d.str_Name.Equals(cmb_Group.Text) select new { d.str_ID }).SingleOrDefault();
int strID = Convert.ToInt32(s.str_ID);
War = War.Where(p => p.war_str_ID.Value.Equals(strID));
}
}
if (txt_FromBuy.Text.Trim() != string.Empty && txt_ToBuy.Text.Trim() != string.Empty)
{
decimal frombPrice = Convert.ToDecimal(txt_FromBuy.Text);
decimal tobPrice = Convert.ToDecimal(txt_ToBuy.Text);
War = War.Where(p => p.war_BuyPrice.Value.CompareTo(frombPrice) >= 0 &&
p.war_BuyPrice.Value.CompareTo(tobPrice) <= 0);
}
radGridView1.DataSource = War;
}
using (NovinPendarEntities3 context = new NovinPendarEntities3())
{
var War = context.C_Wars.AsQueryable();
if (txt_NAme.Text.Trim() != string.Empty)
{
War = War.Where(p => p.war_Name.Contains(txt_NAme.Text.Trim()));
}
if (txt_ID.Text.Trim() != string.Empty && txt_ToID.Text.Trim() != string.Empty)
{
int from = Convert.ToInt32(txt_ID.Text);
int to = Convert.ToInt32(txt_ToID.Text);
War = War.Where(p => p.war_ID.CompareTo(from) >= 0 &&
p.war_ID.CompareTo(to) <= 0);
}
if (txt_FromPrice.Text.Trim() != string.Empty && txt_ToPrice.Text.Trim() != string.Empty)
{
decimal fromPrice = Convert.ToDecimal(txt_FromPrice.Text);
decimal toPrice = Convert.ToDecimal(txt_ToPrice.Text);
War = War.Where(p => p.war_Price.Value.CompareTo(fromPrice) >= 0 &&
p.war_Price.Value.CompareTo(toPrice) <= 0);
}
if (cmb_Group.Text.Trim() != string.Empty)
{
if (!odb._Stors.Any(item => item.str_Name == cmb_Group.Text))
{
MessageBox.Show("لطفا نام انبار را صحیح وارد کنید");
}
else
{
var s = (from d in odb._Stors where d.str_Name.Equals(cmb_Group.Text) select new { d.str_ID }).SingleOrDefault();
int strID = Convert.ToInt32(s.str_ID);
War = War.Where(p => p.war_str_ID.Value.Equals(strID));
}
}
if (txt_FromBuy.Text.Trim() != string.Empty && txt_ToBuy.Text.Trim() != string.Empty)
{
decimal frombPrice = Convert.ToDecimal(txt_FromBuy.Text);
decimal tobPrice = Convert.ToDecimal(txt_ToBuy.Text);
War = War.Where(p => p.war_BuyPrice.Value.CompareTo(frombPrice) >= 0 &&
p.war_BuyPrice.Value.CompareTo(tobPrice) <= 0);
}
radGridView1.DataSource = War;
}