protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserID"] == null || Session["SellerID"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
LabelWelcome.Text = "欢迎经销商 " + Session["SellerName"] + " 的用户 " + Session["UserName"] + " 登录本系统！";
}
if (!IsPostBack)
{
DropDownListBrand.DataSource = (new BLL_Brand()).SelectAll();
DropDownListBrand.DataValueField = "BrandID";
DropDownListBrand.DataTextField = "BrandName";
DropDownListBrand.DataBind();
if (DropDownListBrand.Items.Count != 0)
{
DropDownListModelDataRefresh();
if (DropDownListModel.Items.Count != 0)
{
LableStockDataRefresh();
}
}
DropDownListSunSeller.DataSource = (new BLL_SellerInfo()).SelectByParentSellerID(Int32.Parse(Session["SellerID"].ToString()));
DropDownListSunSeller.DataValueField = "SellerID";
DropDownListSunSeller.DataTextField = "Name";
DropDownListSunSeller.DataBind();
GridView1.DataSource = (new BLL_SellerOpreateLog()).SelectBySellerID(Int32.Parse(Session["SellerID"].ToString()));
GridView1.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
PenggunaLogin pengguna = (PenggunaLogin)Session["PenggunaLogin"];
TextBoxTanggalProyeksi.Text = DateTime.Now.ToString("d MMMM yyyy");
TextBoxTanggalTarget.Text = DateTime.Now.ToString("d MMMM yyyy");
TextBoxPegawai.Text = pengguna.NamaLengkap;
DropDownListBrand.DataSource = db.TBPemilikProduks.OrderBy(item => item.Nama).ToArray();
DropDownListBrand.DataTextField = "Nama";
DropDownListBrand.DataValueField = "IDPemilikProduk";
DropDownListBrand.DataBind();
DropDownListBrand.Items.Insert(0, new ListItem {
Text = "-All Brand-", Value = "0"
});
DropDownListStokProduk.DataSource = db.TBStokProduks
.Where(item =>
item.IDTempat == pengguna.IDTempat &&
item.TBKombinasiProduk.TBProduk._IsActive)
.Select(item => new
{
item.IDStokProduk,
item.TBKombinasiProduk.Nama
})
.OrderBy(item => item.Nama)
.ToArray();
DropDownListStokProduk.DataTextField = "Nama";
DropDownListStokProduk.DataValueField = "IDStokProduk";
DropDownListStokProduk.DataBind();
ViewState["ViewStateListDetail"] = new List <ProyeksiDetail_Model>();
ViewState["ViewStateKomposisiProduk"] = new List <KomposisiProduk_Model>();
if (DropDownListStokProduk.Items.Count == 0)
{
ButtonSimpanDetail.Enabled = false;
ButtonSimpan.Enabled = false;
}
}
}
}
void Yukle()
{
if (Request.QueryString["MarkaID"] == null)
{
GridView1.DataSource = repoProduct.GetAll().AsEnumerable().OrderBy(o => o.Name).Select(s => new { s.ID, s.Name, s.Picture, s.Price, Marka = s.Brand.Name, StokBilgi = s.Stock <= 0 ? "TÜKENDİ" : s.Stock.ToString(), Kategorileri = string.Join(",", s.ProductCategory.Select(pc => pc.Category.Name)) }).ToList();
}
else
{
int BrandID = Convert.ToInt32(Request.QueryString["MarkaID"]);
GridView1.DataSource = repoProduct.GetAll().AsEnumerable().OrderBy(o => o.Name).Where(w => w.BrandID == BrandID).Select(s => new { s.ID, s.Name, s.Picture, s.Price, Marka = s.Brand.Name, StokBilgi = s.Stock <= 0 ? "TÜKENDİ" : s.Stock.ToString(), Kategorileri = string.Join(",", s.ProductCategory.Select(pc => pc.Category.Name)) }).ToList();
h1Baslik.InnerText = Request.QueryString["MarkaAd"].ToUpper() + " ÜRÜNLERİ";
}
GridView1.DataBind();
DropDownListBrand.DataSource = repoBrand.GetAll().OrderBy(o => o.Name).ToList();
DropDownListBrand.DataBind();
CheckBoxListKategori.DataSource = repoCategory.GetAll().OrderBy(o => o.Name).ToList();
CheckBoxListKategori.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
Tempat_Class ClassTempat = new Tempat_Class(db);
PemilikProduk_Class ClassPemilikProduk = new PemilikProduk_Class(db);
DropDownListTempat.DataSource = ClassTempat.Data();
DropDownListTempat.DataValueField = "IDTempat";
DropDownListTempat.DataTextField = "Nama";
DropDownListTempat.DataBind();
DropDownListTempat.Items.Insert(0, new ListItem {
Value = "0", Text = "- Semua -"
});
DropDownListTempat.SelectedValue = Pengguna.IDTempat.ToString();
ViewState["TanggalAwal"] = Pengaturan.HariIni()[0];
ViewState["TanggalAkhir"] = Pengaturan.HariIni()[1];
TextBoxTanggalAwal.Text = ((DateTime)ViewState["TanggalAwal"]).ToString("d MMMM yyyy");
DropDownListBrand.DataSource = ClassPemilikProduk.Data();
DropDownListBrand.DataValueField = "IDPemilikProduk";
DropDownListBrand.DataTextField = "Nama";
DropDownListBrand.DataBind();
DropDownListBrand.Items.Insert(0, new ListItem {
Value = "0", Text = "- Semua -"
});
}
LoadData();
}
else
{
LinkDownload.Visible = false;
}
}
private void ShowBrand()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["dbcon"].ConnectionString); //Create connection b/w .net and database
con.Open(); //open db connection
string qry = "Select * from tblBrand"; //Sql Query
SqlCommand cmd = new SqlCommand(qry, con); //send query execution
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt); // fill sda data into dt
if (dt.Rows.Count != 0) //if data is more then zero
{
DropDownListBrand.DataSource = dt; // dropdown source is dt
DropDownListBrand.DataTextField = "Name"; // Cat name will show in dropdown
DropDownListBrand.DataValueField = "BrandId"; // sub category database will store only Catid
DropDownListBrand.DataBind(); // binding data
DropDownListBrand.Items.Insert(0, new ListItem("-Select-", "0")); //0th index of dropdown list
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
using (DataClassesDatabaseDataContext db = new DataClassesDatabaseDataContext())
{
PenggunaLogin Pengguna = (PenggunaLogin)Session["PenggunaLogin"];
Warna_Class ClassWarna = new Warna_Class(db);
var listKombinasiProduk = db.TBStokProduks.Where(item => item.IDTempat == Pengguna.IDTempat).Select(item => new { item.TBKombinasiProduk.IDKombinasiProduk, item.TBKombinasiProduk.Nama, item.TBKombinasiProduk.TBProduk }).ToArray();
#region Komposisi Produk
DropDownListCariKomposisiProduk.DataSource = listKombinasiProduk;
DropDownListCariKomposisiProduk.DataTextField = "Nama";
DropDownListCariKomposisiProduk.DataValueField = "IDKombinasiProduk";
DropDownListCariKomposisiProduk.DataBind();
DropDownListCariKomposisiProduk.Items.Insert(0, new ListItem {
Text = "-Pilih Produk-", Value = "0"
});
var listStokBahanBaku = db.TBStokBahanBakus.ToArray();
DropDownListBahanBaku.DataSource = listStokBahanBaku.Where(item => item.IDTempat == Pengguna.IDTempat).Select(item => item.TBBahanBaku).ToArray();
DropDownListBahanBaku.DataTextField = "Nama";
DropDownListBahanBaku.DataValueField = "IDBahanBaku";
DropDownListBahanBaku.DataBind();
LabelSatuan.Text = listStokBahanBaku.FirstOrDefault() == null ? string.Empty : listStokBahanBaku.FirstOrDefault().TBBahanBaku.TBSatuan.Nama;
ViewState["KomposisiProduk"] = new List <StokBahanBaku_Model>();
#endregion
#region Biaya Produksi
DropDownListCariBiayaProduksi.DataSource = listKombinasiProduk;
DropDownListCariBiayaProduksi.DataTextField = "Nama";
DropDownListCariBiayaProduksi.DataValueField = "IDKombinasiProduk";
DropDownListCariBiayaProduksi.DataBind();
DropDownListCariBiayaProduksi.Items.Insert(0, new ListItem {
Text = "-Pilih Produk-", Value = "0"
});
DropDownListJenisBiayaProduksi.DataSource = db.TBJenisBiayaProduksis.ToArray();
DropDownListJenisBiayaProduksi.DataTextField = "Nama";
DropDownListJenisBiayaProduksi.DataValueField = "IDJenisBiayaProduksi";
DropDownListJenisBiayaProduksi.DataBind();
DropDownListJenisBiayaProduksi.Items.Insert(0, new ListItem {
Text = "-Tambah Baru-", Value = "0"
});
ViewState["BiayaProduksi"] = new List <JenisBiayaProduksi_Model>();
#endregion
#region Produk
DropDownListCariProduk.DataSource = listKombinasiProduk.Select(item => item.TBProduk).Distinct().ToArray();
DropDownListCariProduk.DataTextField = "Nama";
DropDownListCariProduk.DataValueField = "IDProduk";
DropDownListCariProduk.DataBind();
DropDownListCariProduk.Items.Insert(0, new ListItem {
Text = "-Produk Baru-", Value = "0"
});
DropDownListBrand.DataSource = db.TBPemilikProduks.OrderBy(item => item.Nama).ToArray();
DropDownListBrand.DataTextField = "Nama";
DropDownListBrand.DataValueField = "IDPemilikProduk";
DropDownListBrand.DataBind();
DropDownListBrand.Items.Insert(0, new ListItem {
Text = "-Tambah Baru-", Value = "0"
});
DropDownListWarna.DataSource = ClassWarna.Data();
DropDownListWarna.DataTextField = "Nama";
DropDownListWarna.DataValueField = "IDWarna";
DropDownListWarna.DataBind();
DropDownListWarna.Items.Insert(0, new ListItem {
Text = "-Tambah Baru-", Value = "0"
});
DropDownListVarian.DataSource = db.TBAtributProduks.OrderBy(item => item.Nama).ToArray();
DropDownListVarian.DataTextField = "Nama";
DropDownListVarian.DataValueField = "IDAtributProduk";
DropDownListVarian.DataBind();
DropDownListVarian.Items.Insert(0, new ListItem {
Text = "-Tidak Ada-", Value = "-1"
});
DropDownListVarian.Items.Insert(1, new ListItem {
Text = "-Tambah Baru-", Value = "0"
});
CheckBoxListKategori.DataSource = db.TBKategoriProduks.Select(item => new { item.IDKategoriProduk, Nama = item.Nama }).OrderBy(item => item.Nama).ToArray();
CheckBoxListKategori.DataValueField = "IDKategoriProduk";
CheckBoxListKategori.DataTextField = "Nama";
CheckBoxListKategori.DataBind();
#endregion
}
if (!string.IsNullOrEmpty(Request.QueryString["Status"]))
{
if (Request.QueryString["Status"] == "true")
{
LiteralInformasi.Text = "<div class=\"alert alert-success\" role=\"alert\"><strong>Berhasil.</strong> Data produk telah tersimpan.</div>";
}
}
}
}