//绑定页面
private void PageLoad()
{
string where = search.Text;//搜索条件
if (Session["AdminId"] != null)
{
if (string.IsNullOrEmpty(where))
{
GvData.DataSource = DB.ResearchItem.Where(a => true).ToList();
}
else
{
GvData.DataSource = DB.ResearchItem.Where(a => a.ItemName.Contains(where)).ToList();
}
}
else
{
int id = Convert.ToInt32(Session["PersonId"].ToString());
if (string.IsNullOrEmpty(where))
{
GvData.DataSource = DB.ResearchItem.Where(a => a.PersonId == id).ToList();
}
else
{
GvData.DataSource = DB.ResearchItem.Where(a => a.PersonId == id && a.ItemName.Contains(where)).ToList();
}
}
GvData.DataBind();
}
protected void ViewButton_Click(Object sender, EventArgs e)
{
LinkButton linkButton = (LinkButton)(sender);
string orderNo = linkButton.CommandArgument;
var retData = sampleControls.GetDataByOrderNo(orderNo);
var dataSample = retData.Result;
foreach (var dat in dataSample)
{
if (dat.isReceived == "1")
{
dat.isReceived = "Sudah";
}
else
{
dat.isReceived = "Belum";
}
}
GvData.DataSource = dataSample;
GvData.DataBind();
GvData.Visible = true;
lblSampel.Visible = true;
divParamUji.Visible = false;
btnBalikDah.Visible = false;
}
void RefreshGrid(params string[] Status)
{
var ret = listGridMaster.GetDataByOrderNoAndStatus(TxtBarcode.Text, Status);
var datas = ret.Result;
foreach (var dat in datas)
{
if (dat.isPaid == "1")
{
dat.isPaid = "Sudah Dibayar";
}
else
{
dat.isPaid = "Belum Dibayar";
}
}
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
private void BindGvData()
{
try
{
int GovIdId = Convert.ToInt16(ddlGovernmentOrder.SelectedValue);
int ClaimType = Convert.ToInt16(ddlClaimType.SelectedValue);
clsInputParameter objInputParameter = new clsInputParameter();
objInputParameter.InFromDate = Convert.ToDateTime(txtFromDate.Text.Trim() + " 00:00:00.000");
objInputParameter.InToDate = Convert.ToDateTime(txtToDate.Text.Trim() + " 23:59:59.999");
objInputParameter.InStatus = Convert.ToInt16(ddlStatus.SelectedValue);
GvData.DataSource = objLtmsService.GetLotteryClaimSendToGovDtlByStatus(objInputParameter, ClaimType, GovIdId);
GvData.DataBind();
gridDiv.Visible = objMenuOptions.AllowView;
btnPrint.Visible = (GvData.Rows.Count > 0 ? true : false);
btnSave.Visible = (ddlClaimType.SelectedIndex > 0 ? true : false);
}
catch (Exception Ex)
{
objValidateData.SaveSystemErrorLog(Ex, Request.UserHostAddress);
var message = new JavaScriptSerializer().Serialize("Some Error has occurred while performing your activity. Please contact the System Administrator for further assistance.");
var script = string.Format("alert({0});", message);
ScriptManager.RegisterClientScriptBlock(this, GetType(), "", script, true);
}
}
void RefreshGrid(string param = "")
{
var myLab = CommonWeb.GetUserLab();
var ret = listGridMaster.GetDataProses(myLab);
var datas = ret.Result;
foreach (var dat in datas)
{
if (dat.isPaid == "1")
{
dat.isPaid = "Sudah Dibayar";
}
else
{
dat.isPaid = "Belum Dibayar";
}
}
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
void LoadGridSample(string NoBalitTanah = "")
{
using (var db = new smlpobDB())
{
var myLab = CommonWeb.GetUserLab();
var dataSample = OrderSampleControls.GetDataByStatus(Status.OrderStatus[3], myLab); //db.ordersampletbls.Include(c => c.ordermastertbl).Where(x => x.ordermastertbl.status == "Proses Lab").ToList();
if (!string.IsNullOrEmpty(NoBalitTanah) && dataSample != null)
{
dataSample = dataSample.Where(x => x.noBalittanah == NoBalitTanah).ToList();
}
foreach (var data in dataSample)
{
if (data.isReceived == "1")
{
data.isReceived = "Sudah";
}
else
{
data.isReceived = "Belum";
}
}
GvData.DataSource = dataSample;
GvData.DataBind();
}
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
private void dtb()
{
SqlConnection cn = new SqlConnection(WebConfigurationManager.ConnectionStrings["cnen"].ConnectionString);
SqlCommand cmd = new SqlCommand("Select * from [DONHANG]", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GvData.DataSource = ds;
GvData.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
GvData.DataSource = ds;
GvData.DataBind();
int columncount = GvData.Rows[0].Cells.Count;
GvData.Rows[0].Cells.Clear();
GvData.Rows[0].Cells.Add(new TableCell());
GvData.Rows[0].Cells[0].ColumnSpan = columncount;
GvData.Rows[0].Cells[0].Text = "No Records Found";
}
}
void RefreshGrid(string param = "")
{
GvData.DataBind();
if (param == null || param == "")
{
var ret = orderControls.GetData();
var datas = ret.Result;
if (datas != null && datas.Count() > 0)
{
GvData.DataSource = datas;
GvData.DataBind();
}
}
else
{
var ret = orderControls.GetDataByContaint(param);
var datas = ret.Result;
if (datas != null && datas.Count() > 0)
{
GvData.DataSource = datas;
GvData.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
for (int i = 0; i < a.Length; i++)
{
ddlrecipients.Items.Insert(0, new ListItem(a[i], (i).ToString()));
}
for (int i = 0; i < menu.Length; i++)
{
DdlMenu.Items.Insert(0, new ListItem(menu[i], (i).ToString()));
}
if (Session["UserName"] == null)
{
Response.Write("<script> alert('bạn chưa đăng nhập!!!!')</script>");
Response.Redirect("~/Login.aspx");
}
string str = "SELECT TenKH,MaKH FROM KHACHHANG WHERE TenDN = '" + Session["UserName"] + "'";
dtl = cn.getData(str);
lbltenKH.Text = dtl.Rows[0][0].ToString();
if (Session["GioHang"] != null)
{
DataTable dt = (DataTable)Session["GioHang"];
GvData.DataSource = dt;
GvData.DataBind();
for (int i = 0; i < dt.Rows.Count; i++)
{
Sum += Convert.ToDouble(dt.Rows[i]["ThanhTien"].ToString());
}
}
else
{
lblTB.Text = "Giỏ Hàng Của Bạn Đang Trống!!!";
}
}
private void dtb()
{
SqlConnection cn = new SqlConnection(WebConfigurationManager.ConnectionStrings["cnen"].ConnectionString);
SqlCommand cmd = new SqlCommand("Select * From CUAHANG C,SANPHAM where C.MaCH = SANPHAM.MaCH and C.TenDNCH = '" + Session["UserNameStore"].ToString() + "'", cn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
cn.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GvData.DataSource = ds;
GvData.DataBind();
}
else
{
ds.Tables[0].Rows.Add(ds.Tables[0].NewRow());
GvData.DataSource = ds;
GvData.DataBind();
int columncount = GvData.Rows[0].Cells.Count;
GvData.Rows[0].Cells.Clear();
GvData.Rows[0].Cells.Add(new TableCell());
GvData.Rows[0].Cells[0].ColumnSpan = columncount;
GvData.Rows[0].Cells[0].Text = "No Records Found";
}
}
void RefreshGrid()
{
Dictionary <string, double> Progress = new Dictionary <string, double>();
var ret = ordersamplecontrols.GetDataAsync(_orderno);
var datas = ret.Result;
foreach (var item in datas)
{
using (var db = new smlpobDB())
{
var itemProgress = (from x in db.orderanalysisdetailtbls
where x.orderNo == lblorder.Text && x.sampleNo == item.noBalittanah
select x).ToList();
if (itemProgress != null)
{
var total = (double)itemProgress.Count(x => x.status == "Diproses");
total = (total / itemProgress.Count) * 100;
Progress.Add(item.noBalittanah, total);
}
}
}
ViewState["Progress"] = Progress;
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
void LoadGridSample(string orderNo)
{
var ret = orderControls.GetDataDetail(orderNo);
var datas = ret.Result;
foreach (var data in datas)
{
if (data.isReceived == "1")
{
data.isReceived = "Sudah";
}
else
{
data.isReceived = "Belum";
}
}
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
private void DoDuplicate(string NoBalitTanah)
{
var sampel = DataSampel.Where(x => x.noBalittanah == NoBalitTanah).FirstOrDefault();
if (sampel != null)
{
DataTable table = new DataTable();
table.Columns.Add("countNumber", typeof(int));
table.Columns.Add("sampleCode", typeof(string));
table.Columns.Add("noBalittanah", typeof(string));
table.Columns.Add("village", typeof(string));
table.Columns.Add("subDistrict", typeof(string));
table.Columns.Add("district", typeof(string));
table.Columns.Add("province", typeof(string));
table.Columns.Add("landUse", typeof(string));
table.Columns.Add("longitude", typeof(string));
table.Columns.Add("latitude", typeof(string));
DataSampel.Add(new ordersampletbl
{
orderNo = sampel.orderNo,
countNumber = DataSampel.Count + 1,
sampleCode = "SAMPLE/" + shortid.ShortId.Generate(true, false, 10),
noBalittanah = GenerateNoBalitTanah(DataSampel.Count + 1),
village = sampel.village,
subDistrict = sampel.subDistrict,
district = sampel.district,
province = sampel.province,
landUse = sampel.landUse,
longitude = sampel.longitude,
latitude = sampel.latitude,
creaBy = currentUser,
creaDate = DatetimeHelper.GetDatetimeNow(),
modBy = currentUser,
modDate = DatetimeHelper.GetDatetimeNow()
, samplingDate = sampel.samplingDate,
sampleDescription = sampel.sampleDescription
});
if (DataSampel.Count > 0)
{
var sort = DataSampel.OrderBy(o => o.countNumber);
DataSampel = sort.ToList();
foreach (var data in DataSampel)
{
table.Rows.Add(data.countNumber, data.sampleCode, data.noBalittanah, data.village,
data.subDistrict, data.district, data.province, data.landUse,
data.longitude, data.latitude);
}
}
LitJumlahSampel.Text = DataSampel.Count.ToString();
GvData.DataSource = table;
GvData.DataBind();
UpdateJumlahContoh();
}
}
private void PopulateData()
{
using (testDBEntities t = new testDBEntities())
{
GvData.DataSource = t.Grupo.ToList();
GvData.DataBind();
}
}
void BindData()
{
var empNo = CommonWeb.GetCurrentEmployeeNo();
var datas = orderControls.GetOrdersForBatch(empNo);
GvData.DataSource = datas;
GvData.DataBind();
}
private void DelRowGv(string param)
{
List <ordersampletbl> sampel = new List <ordersampletbl>();
DataTable table = new DataTable();
table.Columns.Add("countNumber", typeof(int));
table.Columns.Add("sampleCode", typeof(string));
table.Columns.Add("noBalittanah", typeof(string));
table.Columns.Add("village", typeof(string));
table.Columns.Add("subDistrict", typeof(string));
table.Columns.Add("district", typeof(string));
table.Columns.Add("province", typeof(string));
table.Columns.Add("landUse", typeof(string));
table.Columns.Add("gpsCoordinat", typeof(string));
if (GvData.Rows.Count > 0)
{
for (int i = 0; i < GvData.Rows.Count; i++)
{
if (GvData.Rows[i].Cells[2].Text != param)
{
string[] longlat1 = (GvData.Rows[i].Cells[8].Text).Split(',');
sampel.Add(new ordersampletbl
{
countNumber = i + 1,
sampleCode = GvData.Rows[i].Cells[1].Text,
noBalittanah = GvData.Rows[i].Cells[2].Text,
village = GvData.Rows[i].Cells[3].Text,
subDistrict = GvData.Rows[i].Cells[4].Text,
district = GvData.Rows[i].Cells[5].Text,
province = GvData.Rows[i].Cells[6].Text,
landUse = GvData.Rows[i].Cells[7].Text,
longitude = longlat1[0],
latitude = longlat1[1]
});
}
}
}
if (sampel.Count > 0)
{
var sort = sampel.OrderBy(o => o.countNumber);
sampel = sort.ToList();
foreach (var data in sampel)
{
table.Rows.Add(data.countNumber, data.sampleCode, data.noBalittanah, data.village,
data.subDistrict, data.district, data.province, data.landUse,
(data.longitude + "," + data.latitude).ToString());
}
}
txtJumlahSampel.Text = sampel.Count.ToString();
GvData.DataSource = table;
GvData.DataBind();
}
private void binDT()
{
if (Session["GioHang"] != null)
{
CapNhat();
}
GvData.DataSource = (DataTable)Session["Giohang"];
GvData.DataBind();
}
//重新绑定页面
private void PageLoad()
{
string where = search.Text;//搜索条件
if (string.IsNullOrEmpty(where))
GvData.DataSource = DB.Admin.Where(a => true).ToList();
else
GvData.DataSource = DB.Admin.Where(a => a.Name.Contains(where)).ToList();
GvData.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
GvData.DataSource = con.getData("Select * From [DONHANG]");
GvData.DataBind();
ViewState["SortDirection"] = SortDirection.Ascending;
}
}
void LoadData(string orderNo)
{
using (var db = new smlpobDB())
{
var dataSample = (from x in db.ordersampletbls
where x.orderNo == orderNo
select x).ToList();
GvData.DataSource = dataSample;
GvData.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
GvData.RowDataBound += GvData_RowDataBound;
if (!IsPostBack)
{
GetTranslation();
CounterGen = new NumberCounter();
CmbPIC.DataTextField = "employeeName";
CmbPIC.DataValueField = "employeeNo";
var myLab = CommonWeb.GetUserLab();
var picData = orderControls.GetPICAnalyst(myLab);
CmbPIC.DataSource = picData;
CmbPIC.DataBind();
var batchIdStr = Request.QueryString["batchId"];
if (!string.IsNullOrEmpty(batchIdStr))
{
LitTitleBatch.Text = "Lihat Batch";
LitTitleBatch.Text = LanguageHelper.GetTranslation("detailbatch");
TxtNoBatch.Text = batchIdStr;
var data = orderControls.GetBatchFromId(batchIdStr);
if (data != null)
{
GvData.DataSource = orderControls.GetOrdersFromBatchId(batchIdStr);
GvData.DataBind();
}
BtnSimpan.Visible = false;
GvData.Columns[0].Visible = false;
int counter = 0;
foreach (var x in picData)
{
if (x.employeeNo == data.pic_analis.Value)
{
CmbPIC.SelectedIndex = counter;
}
counter++;
}
CmbPIC.Enabled = false;
}
else
{
LitTitleBatch.Text = "Buat Batch";
LitTitleBatch.Text = LanguageHelper.GetTranslation("createbatch");
TxtNoBatch.Text = GenerateNoBatch();
BindData();
}
}
BtnBack.Click += (a, b) => { Response.Redirect("DaftarPesanan.aspx"); };
BtnSimpan.Click += (a, b) => { SimpanData(); };
}
//实验记录
private void PageLoad()
{
//查看所有记录
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
var list = DB.ExpRecord.Where(a => a.ItemId == id).ToList();
GvData.DataSource = list;
GvData.DataBind();
PageModel = DB.ResearchItem.FirstOrDefault(a => a.Id == id);//获取项目对象
}
private void Get_Data()
{
try
{
GvData.DataSource = GetCodeBy(0);
GvData.DataBind();
}
catch
{
}
}
void LoadGridSample(string orderNo)
{
try
{
var ret = orderControls.GetDataDetail(orderNo);
var dataSample = ret.Result;
using (var db = new smlpobDB())
{
var UrlToFile = (from x in db.ordermastertbls
where x.orderNo == orderNo
select x.LHPAttachmentUrl).FirstOrDefault();
if (!string.IsNullOrEmpty(UrlToFile))
{
ViewState["DownloadUrl"] = UrlToFile;
//BtnDownload.PostBackUrl = UrlToFile;
}
else
{
BtnDownloadZip.Visible = false;
BtnDownloadZip2.Visible = true;
}
}
foreach (var data in dataSample)
{
if (data.isReceived == "1")
{
data.isReceived = "Sudah";
}
else
{
data.isReceived = "Belum";
}
}
GvData.DataSource = dataSample;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
catch { }
}
void RefreshGrid(string param = "")
{
GvData.DataBind();
if (param == null || param == "")
{
var ret = orderControl.GetData();
var datas = ret.Result;
foreach (var data in datas)
{
if (data.isPaid == "1")
{
data.isPaid = "Sudah";
}
else
{
data.isPaid = "Belum";
}
}
foreach (var data in datas)
{
if (data.isPaid == "1")
{
data.isPaid = "Sudah";
}
else
{
data.isPaid = "Belum";
}
}
if (datas != null && datas.Count() > 0)
{
GvData.DataSource = datas;
GvData.DataBind();
}
}
else
{
var ret = orderControl.GetDataByContaint(param);
var datas = ret.Result;
if (datas != null && datas.Count() > 0)
{
GvData.DataSource = datas;
GvData.DataBind();
}
}
}
void RefreshGrid(string param = "")
{
var ret = orderControls.GetData();
var datas = ret.Result.Where(x => (x.status == Status.OrderStatus[7] || x.status == Status.OrderStatus[8]));
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
protected void Page_Load(object sender, EventArgs e)
{
var vectorDBConnectionString = ConfigurationManager.ConnectionStrings["VectorDBConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(vectorDBConnectionString))
{
SqlDataAdapter sde = new SqlDataAdapter("Select * from students", con);
DataSet ds = new DataSet();
sde.Fill(ds);
GvData.DataSource = ds;
GvData.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserNameStore"] == null)
{
Response.Redirect("DangNhapCuaHang.aspx");
}
if (!IsPostBack)
{
GvData.DataSource = cn.getData("Select * From CUAHANG C,SANPHAM where C.MaCH = SANPHAM.MaCH and C.TenDNCH = '" + Session["UserNameStore"].ToString() + "'");
GvData.DataBind();
ViewState["SortDirection"] = SortDirection.Ascending;
}
}
void RefreshGrid()
{
var ret = ordersamplecontrols.GetDataAsync(_orderno);
var datas = ret.Result;
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
void RefreshGrid(string param = "")
{
var ret = orderControls.GetDataKasir();
var datas = ret.Result;
GvData.DataSource = datas;
GvData.DataBind();
if (GvData.Rows.Count > 0)
{
GvData.UseAccessibleHeader = true;
GvData.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
