protected void FormViewSheetInfo_DataBound(object sender, EventArgs e) { int sheetid = 0; if (Session["UserId"] == null) return; else sheetid = Convert.ToInt32(Session["UserId"]); tb_repairsheetTableAdapter repairsheetTableAdapter = new tb_repairsheetTableAdapter(); AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow repairsheetRow = (AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow)repairsheetTableAdapter.GetDataByid(sheetid).Rows[0]; int stateid = repairsheetRow.repairstateid; Label lbrepairstateid = (Label)this.Master.FindControl("ContentPlaceHolderContent").FindControl("FormViewSheetInfo").FindControl("repairstateidLabel"); if (lbrepairstateid != null) { tb_repairstateTableAdapter repairstateTableAdapter = new tb_repairstateTableAdapter(); if (repairstateTableAdapter.GetDatabyid(stateid).Rows.Count > 0) { AfterSaleServiceSystem.DAL.dsRepairState.tb_repairstateRow repairstateRow = (AfterSaleServiceSystem.DAL.dsRepairState.tb_repairstateRow) repairstateTableAdapter.GetDatabyid(stateid).Rows[0]; lbrepairstateid.Text = repairstateRow.description; } } }
protected void Page_Load(object sender, EventArgs e) { string guidRequest = HiddenField1.Value; if (IsPostBack)//表单提交 { string productType = Context.Request["productType"]; string productCode = Context.Request["productCode"]; tb_repairsheetTableAdapter repairsheetTableAdapter = new tb_repairsheetTableAdapter(); if (repairsheetTableAdapter.GetDataByGUID(guidRequest).Rows.Count > 0)//已经存在该条形码 { Label1.Text = "该维修单已经被录入"; } else { dsRepairSheet.tb_repairsheetDataTable ds = new dsRepairSheet.tb_repairsheetDataTable(); repairsheetTableAdapter.Fill(ds); //repairsheetTableAdapter.Fill(dataset, "acUser");//用表User填充dataset对象 repairsheetTableAdapter.InsertNewSheet(guidRequest, productType, productCode, 1, 0, DropDownList1.SelectedIndex + 1, 0); repairsheetTableAdapter.Update(ds); isInsertSucced.Text = "录入成功"; } } else//非表单提交 { HiddenField1.Value = Context.Request["GUID"]; } }
protected void FormViewSheetInfo_DataBound(object sender, EventArgs e) { int sheetid = 0; if (Session["UserId"] == null) { return; } else { sheetid = Convert.ToInt32(Session["UserId"]); } tb_repairsheetTableAdapter repairsheetTableAdapter = new tb_repairsheetTableAdapter(); AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow repairsheetRow = (AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow)repairsheetTableAdapter.GetDataByid(sheetid).Rows[0]; int stateid = repairsheetRow.repairstateid; Label lbrepairstateid = (Label)this.Master.FindControl("ContentPlaceHolderContent").FindControl("FormViewSheetInfo").FindControl("repairstateidLabel"); if (lbrepairstateid != null) { tb_repairstateTableAdapter repairstateTableAdapter = new tb_repairstateTableAdapter(); if (repairstateTableAdapter.GetDatabyid(stateid).Rows.Count > 0) { AfterSaleServiceSystem.DAL.dsRepairState.tb_repairstateRow repairstateRow = (AfterSaleServiceSystem.DAL.dsRepairState.tb_repairstateRow) repairstateTableAdapter.GetDatabyid(stateid).Rows[0]; lbrepairstateid.Text = repairstateRow.description; } } }
protected void Button1_Click(object sender, EventArgs e) { //TextBox tbGUID = (TextBox)this.FindControl("TextBoxGUID"); TextBox tbGUID = (TextBox)this.Master.FindControl("ContentPlaceHolderContent").FindControl("TextBoxGUID"); Label err_Checked = (Label)this.Master.FindControl("ContentPlaceHolderContent").FindControl("LabelErr_Checked"); err_Checked.Visible = false; Label err_NoExist = (Label)this.Master.FindControl("ContentPlaceHolderContent").FindControl("LabelErr_NoExist"); err_NoExist.Visible = false; if (tbGUID != null) { string sguid = tbGUID.Text; tb_repairsheetTableAdapter repairsheetTableAdapter = new tb_repairsheetTableAdapter(); DataRowCollection Rows = repairsheetTableAdapter.GetDataByGuid(sguid).Rows; if (Rows.Count > 0) { AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow repairsheetRow = (AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow)Rows[0]; if (repairsheetRow.clerkid != 0) { //err:维修单已经申领 err_Checked.Visible = true; } else if (Session["UserId"] == null || Session["UserId"] == string.Empty) { //用户未登录,重定向到登录页面 this.Response.Redirect(MapPath("~\\Default.aspx")); } else { repairsheetRow.clerkid = Convert.ToInt32(Session["UserId"]); repairsheetTableAdapter.Update(repairsheetRow); Response.Redirect(MapPath("~\\Serviceman\\ClerkMain.aspx")); //申领成功 } } else { //维修单不存在 err_NoExist.Visible = true; } } }
protected void Button1_Click(object sender, EventArgs e) { //TextBox tbGUID = (TextBox)this.FindControl("TextBoxGUID"); TextBox tbGUID = (TextBox)this.Master.FindControl("ContentPlaceHolderContent").FindControl("TextBoxGUID"); Label err_Checked = (Label)this.Master.FindControl("ContentPlaceHolderContent").FindControl("LabelErr_Checked"); err_Checked.Visible = false; Label err_NoExist = (Label)this.Master.FindControl("ContentPlaceHolderContent").FindControl("LabelErr_NoExist"); err_NoExist.Visible = false; if (tbGUID != null) { string sguid = tbGUID.Text; tb_repairsheetTableAdapter repairsheetTableAdapter = new tb_repairsheetTableAdapter(); DataRowCollection Rows = repairsheetTableAdapter.GetDataByGUID(sguid).Rows; if (Rows.Count > 0) { AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow repairsheetRow = (AfterSaleServiceSystem.DAL.dsRepairSheet.tb_repairsheetRow)Rows[0]; if (repairsheetRow.clerkid != 0) { //err:维修单已经申领 err_Checked.Visible = true; } else if (Session["UserId"] == null || Session["UserId"] == string.Empty) { //用户未登录,重定向到登录页面 this.Response.Redirect(MapPath("~\\Default.aspx")); } else { repairsheetRow.clerkid = Convert.ToInt32(Session["UserId"]); repairsheetTableAdapter.Update(repairsheetRow); Response.Redirect(MapPath("~\\Serviceman\\ClerkMain.aspx")); //申领成功 } } else { //维修单不存在 err_NoExist.Visible = true; } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("/LogIn.ashx"); return; } try { sheetid = Convert.ToInt32(Request["id"]); #region 绑定客户数据 tb_repairsheetTableAdapter sheet = new tb_repairsheetTableAdapter(); dsRepairSheet.tb_repairsheetDataTable sheetDt = sheet.GetDataByid(sheetid); if (sheetDt != null && sheetDt.Rows.Count > 0) { dsRepairSheet.tb_repairsheetRow row = (dsRepairSheet.tb_repairsheetRow)sheetDt.Rows[0]; tb_customTableAdapter custom = new tb_customTableAdapter(); AfterSaleServiceSystem.DAL.dsCustomer.tb_customDataTable customDt = custom.GetDataByid(Convert.ToInt32(row.customid)); FormView_custom.DataSource = customDt; FormView_custom.DataBind(); } #endregion } catch (Exception) { // throw; } Label_No.Text = sheetid.ToString(); tb_reportsTableAdapter reports = new tb_reportsTableAdapter(); if (reports.GetDataBysheetid(sheetid).Rows.Count > 0) { FormView_report.DefaultMode = FormViewMode.Edit; } else FormView_report.DefaultMode = FormViewMode.Insert; }