private void rbtnBrandTNH_CheckedChanged(object sender, EventArgs e) { if ((sender as RadioButton).Checked) { brand = TBrand.NewHolland; } }
private void rbtnBrandTJDeere_CheckedChanged(object sender, EventArgs e) { if ((sender as RadioButton).Checked) { brand = TBrand.JDeere; } }
private void rbtnBrandTMassey_CheckedChanged(object sender, EventArgs e) { if ((sender as RadioButton).Checked) { brand = TBrand.Massey; } }
protected void UpdateSortID(int id, int sortid) { TBrand tbrand = brandbll.GetBrandByID(id); tbrand.SortID = sortid; brandbll.UpdateBrand(tbrand, id); }
//Check Brand is changed private void rbtnBrandTAoG_CheckedChanged(object sender, EventArgs e) { if ((sender as RadioButton).Checked) { brand = TBrand.AGOpenGPS; } }
public string GetBrandJsonByKeyWord(string keyword) { NameValueCollection nvc = new NameValueCollection(); nvc.Add("@keyword", "%" + keyword.Trim() + "%"); StringBuilder sb = new StringBuilder(); dh.Open(); DataTable dt = dh.GetDataTable(CommandType.Text, "Select top 100 BrandID from T_Brand where BrandName like @keyword order by SortID asc,BrandID desc", nvc); dh.Close(); List <TModel.json.J_brand> T_list = new List <TModel.json.J_brand>(); TModel.json.J_brand T_List_null = new TModel.json.J_brand(); T_List_null.BrandID = "-1"; T_List_null.BrandName = "暂无品牌信息"; T_list.Add(T_List_null); for (int i = 0; i < dt.Rows.Count; i++) { int id = 0; Int32.TryParse(dt.Rows[i]["BrandID"].ToString().Trim(), out id); TBrand tbrand = GetBrandByID(id); TModel.json.J_brand jbrand = new TModel.json.J_brand(); jbrand.BrandID = tbrand.BrandID.ToString(); jbrand.BrandName = tbrand.BrandName; T_list.Add(jbrand); } dt.Dispose(); return(CommonLibrary.CommOperate.ToJson(T_list)); }
private void rbtnBrandTValtra_CheckedChanged(object sender, EventArgs e) { if ((sender as RadioButton).Checked) { brand = TBrand.Valtra; } }
protected void Button1_Click(object sender, EventArgs e) { TBrand tbrand = InitBrand(); BrandBLL brandbll = new BrandBLL(); brandbll.UpdateBrand(tbrand, tbrand.BrandID); CommonLibrary.RunJs.PageReplace("Brand_UpdateManage.aspx?LastID=" + tbrand.BrandID); }
protected void Button1_Click(object sender, EventArgs e) { TBrand tbrand = InitBrand(); BrandBLL brandbll = new BrandBLL(); brandbll.AddBrand(tbrand); int lastid = brandbll.GetLastID(); CommonLibrary.RunJs.PageReplace("Brand_UpdateManage.aspx?LastID=" + lastid); }
protected void DeleteBrand(int BrandID) { TBrand brand = brandbll.GetBrandByID(BrandID); if (brand.BrandPic.Trim() != "") { CommonLibrary.CommOperate.DeleteFile(Server.MapPath(brand.BrandPic.Trim())); } ImageOperate.DeleteMemoImage(brand.BrandPic.Trim()); brandbll.DeleteBrand(BrandID); }
private TBrand InitBrand() { int Brandid = 0; Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestQueryString("id"), out Brandid); string BrandName = tbx_title.Text; bool IsRecom = false; bool.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("Chk_tuijian"), out IsRecom); string BrandMemo = ContentHolder.Value; string BrandPic = string.Empty; BrandPic = CommonLibrary.CommOperate.GetStrFromRequestForm("CatePic"); string BrandTemplate = Tbx_BrandTemplate.Text.Trim(); bool IsHtml = false; string BrandHtmlPath = Tbx_htmlpath.Text; bool IsRemote = false; bool.TryParse(CommonLibrary.CommOperate.GetStrFromRequestForm("Chk_Remote"), out IsRemote); DateTime BrandAddtime; DateTime.TryParse(Tbx_Addtime.Text, out BrandAddtime); int BrandAdder = 0; Int32.TryParse(H_Adder.Value, out BrandAdder); int SortID = 0; Int32.TryParse(tbx_SortId.Text, out SortID); TBrand tbrand = new TBrand(); tbrand.BrandName = BrandName; tbrand.IsRecom = IsRecom; if (IsRemote == true) { tbrand.BrandMemo = ImageOperate.GetRemoteImage(BrandMemo, "/uploadfile/remote/"); } else { tbrand.BrandMemo = BrandMemo; } tbrand.BrandPic = BrandPic; tbrand.BrandTemplate = BrandTemplate; tbrand.IsHtml = IsHtml; tbrand.BrandHtmlPath = BrandHtmlPath; tbrand.IsRemote = IsRemote; tbrand.BrandAddtime = BrandAddtime; tbrand.BrandAdder = BrandAdder; tbrand.SortID = SortID; tbrand.BrandID = Brandid; return(tbrand); }
public void InsertNewBrand(string brandName) { using (DataLinqToSQLDataContext brands = new DataLinqToSQLDataContext()) { TBrand newBrand = new TBrand { Name = brandName }; brands.TBrands.InsertOnSubmit(newBrand); brands.SubmitChanges(); } }
public void UpdateBrand(int brandId, string name) { // Updating product information using (DataLinqToSQLDataContext brands = new DataLinqToSQLDataContext()) { TBrand editBrand = brands.TBrands.SingleOrDefault(x => x.BrandID == brandId); editBrand.Name = name; brands.SubmitChanges(); } }
public ActionResult Create(TBrand brand) { try { using (DbModels dbModel = new DbModels()) { dbModel.TBrands.Add(brand); dbModel.SaveChanges(); } return(RedirectToAction("Index", "Brand")); } catch { return(View()); } }
public ActionResult Edit(int id, TBrand brand) { try { using (DbModels dbModel = new DbModels()) { dbModel.Entry(brand).State = EntityState.Modified; dbModel.SaveChanges(); } return(RedirectToAction("Index", "Brand")); } catch { return(View()); } }
public ActionResult Delete(int id, FormCollection collection) { try { using (DbModels dbModel = new DbModels()) { TBrand brand = dbModel.TBrands.Where(x => x.BrandId == id).FirstOrDefault(); dbModel.TBrands.Remove(brand); dbModel.SaveChanges(); } return(RedirectToAction("Index", "Brand")); } catch { return(View()); } }
public TBrand GetBrandByID(int id) { NameValueCollection nvc = new NameValueCollection(); nvc.Add("@BrandID", id.ToString()); TBrand tb = new TBrand(); dh.Open(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, SelectBrand + " and BrandID=@BrandID", nvc)) { if (dr.HasRows) { dr.Read(); tb.BrandID = id; tb.BrandName = dr["BrandName"].ToString(); bool IsRecom; bool.TryParse(dr["IsRecom"].ToString(), out IsRecom); tb.IsRecom = IsRecom; tb.BrandMemo = dr["BrandMemo"].ToString().Trim(); tb.BrandPic = dr["BrandPic"].ToString().Trim(); tb.BrandTemplate = dr["BrandTemplate"].ToString().Trim(); bool IsHtml; bool.TryParse(dr["IsHtml"].ToString(), out IsHtml); tb.IsHtml = IsHtml; tb.BrandHtmlPath = dr["BrandHtmlPath"].ToString().Trim(); bool IsRemote; bool.TryParse(dr["IsRemote"].ToString(), out IsRemote); tb.IsRemote = IsRemote; DateTime BrandAddtime; DateTime.TryParse(dr["BrandAddtime"].ToString(), out BrandAddtime); tb.BrandAddtime = BrandAddtime; int BrandAdder = 0; Int32.TryParse(dr["BrandAdder"].ToString(), out BrandAdder); tb.BrandAdder = BrandAdder; int SortID = 0; Int32.TryParse(dr["SortID"].ToString(), out SortID); tb.SortID = SortID; } } dh.Close(); return(tb); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { int Brandid = 0; Int32.TryParse(CommonLibrary.CommOperate.GetStrFromRequestQueryString("id"), out Brandid); TBrand tbrand = new TBrand(); BrandBLL brandbll = new BrandBLL(); tbrand = brandbll.GetBrandByID(Brandid); tbx_title.Text = tbrand.BrandName; ContentHolder.Value = tbrand.BrandMemo; #region 图片列表 L_selpic.Text = ImageOperate.GetImageSelect(tbrand.BrandMemo, tbrand.BrandPic); #endregion Tbx_BrandTemplate.Text = tbrand.BrandTemplate; if (tbrand.IsRemote == true) { L_isRemote.Text = "<input type=\"checkbox\" id=\"Chk_Remote\" name=\"Chk_Remote\" value=\"true\" Checked=Checked />"; } else { L_isRemote.Text = "<input type=\"checkbox\" id=\"Chk_Remote\" name=\"Chk_Remote\" value=\"true\" />"; } if (tbrand.IsRecom == true) { L_IsRecoom.Text = "<input type=\"checkbox\" id=\"Chk_tuijian\" name=\"Chk_tuijian\" Checked=Checked value=\"true\" />"; } else { L_IsRecoom.Text = "<input type=\"checkbox\" id=\"Chk_tuijian\" name=\"Chk_tuijian\" value=\"true\" />"; } Tbx_Addtime.Text = tbrand.BrandAddtime.ToString("yyyy-MM-dd hh:mm:ss"); Tbx_Adder.Text = LoginUser.Admin_RealName; H_Adder.Value = LoginUser.Admin_ID.ToString(); tbx_SortId.Text = tbrand.SortID.ToString(); Tbx_htmlpath.Text = tbrand.BrandHtmlPath; } }
/// <summary> /// 添加品牌 /// </summary> /// <param name="brand"></param> /// <returns></returns> public int AddBrand(TBrand brand) { int stat = 0; NameValueCollection nvc = new NameValueCollection(); nvc.Add("@BrandName", brand.BrandName); nvc.Add("@IsRecom", brand.IsRecom.ToString()); nvc.Add("@BrandMemo", brand.BrandMemo); nvc.Add("@BrandPic", brand.BrandPic); nvc.Add("@BrandTemplate", brand.BrandTemplate); nvc.Add("@IsHtml", brand.IsHtml.ToString()); nvc.Add("@BrandHtmlPath", brand.BrandHtmlPath); nvc.Add("@IsRemote", brand.IsRemote.ToString()); nvc.Add("@BrandAddtime", brand.BrandAddtime.ToString()); nvc.Add("@BrandAdder", brand.BrandAdder.ToString()); nvc.Add("@SortID", brand.SortID.ToString()); dh.Open(); stat = dh.ExecuteNonQuery(CommandType.Text, "Insert into T_Brand(BrandName,IsRecom,BrandMemo,BrandPic,BrandTemplate,IsHtml,BrandHtmlPath,IsRemote,BrandAddtime,BrandAdder,SortID) values(@BrandName,@IsRecom,@BrandMemo,@BrandPic,@BrandTemplate,@IsHtml,@BrandHtmlPath,@IsRemote,@BrandAddtime,@BrandAdder,@SortID)", nvc); dh.Close(); return(stat); }
/// <summary> /// 修改品牌 /// </summary> /// <param name="brand"></param> /// <param name="id"></param> /// <returns></returns> public int UpdateBrand(TBrand brand, int id) { int stat = 0; NameValueCollection nvc = new NameValueCollection(); nvc.Add("@BrandName", brand.BrandName); nvc.Add("@IsRecom", brand.IsRecom.ToString()); nvc.Add("@BrandMemo", brand.BrandMemo); nvc.Add("@BrandPic", brand.BrandPic); nvc.Add("@BrandTemplate", brand.BrandTemplate); nvc.Add("@IsHtml", brand.IsHtml.ToString()); nvc.Add("@BrandHtmlPath", brand.BrandHtmlPath); nvc.Add("@IsRemote", brand.IsRemote.ToString()); nvc.Add("@BrandAddtime", brand.BrandAddtime.ToString()); nvc.Add("@BrandAdder", brand.BrandAdder.ToString()); nvc.Add("@SortID", brand.SortID.ToString()); nvc.Add("@BrandID", id.ToString()); dh.Open(); stat = dh.ExecuteNonQuery(CommandType.Text, "Update T_Brand set BrandName=@BrandName,IsRecom=@IsRecom,BrandMemo=@BrandMemo,BrandPic=@BrandPic,BrandTemplate=@BrandTemplate,IsHtml=@IsHtml,BrandHtmlPath=@BrandHtmlPath,IsRemote=@IsRemote,BrandAddtime=@BrandAddtime,BrandAdder=@BrandAdder,SortID=@SortID where BrandID=@BrandID", nvc); dh.Close(); return(stat); }
//constructor public FormConfig(Form callingForm) { //get copy of the calling main form mf = callingForm as FormGPS; InitializeComponent(); //Brand constructor brand = Settings.Default.setBrand_TBrand; if (brand == TBrand.Case) { rbtnBrandTCase.Checked = true; } else if (brand == TBrand.Claas) { rbtnBrandTClaas.Checked = true; } else if (brand == TBrand.Deutz) { rbtnBrandTDeutz.Checked = true; } else if (brand == TBrand.Fendt) { rbtnBrandTFendt.Checked = true; } else if (brand == TBrand.JDeere) { rbtnBrandTJDeere.Checked = true; } else if (brand == TBrand.Kubota) { rbtnBrandTKubota.Checked = true; } else if (brand == TBrand.Massey) { rbtnBrandTMassey.Checked = true; } else if (brand == TBrand.NewHolland) { rbtnBrandTNH.Checked = true; } else if (brand == TBrand.Same) { rbtnBrandTSame.Checked = true; } else if (brand == TBrand.Steyr) { rbtnBrandTSteyr.Checked = true; } else if (brand == TBrand.Ursus) { rbtnBrandTUrsus.Checked = true; } else if (brand == TBrand.Valtra) { rbtnBrandTValtra.Checked = true; } else { rbtnBrandTAoG.Checked = true; } brandH = Settings.Default.setBrand_HBrand; if (brandH == HBrand.Case) { rbtnBrandHCase.Checked = true; } else if (brandH == HBrand.Claas) { rbtnBrandHClaas.Checked = true; } else if (brandH == HBrand.JDeere) { rbtnBrandHJDeere.Checked = true; } else if (brandH == HBrand.NewHolland) { rbtnBrandHNH.Checked = true; } else { rbtnBrandHAoG.Checked = true; } brand4WD = Settings.Default.setBrand_WDBrand; if (brand4WD == WDBrand.Case) { rbtnBrand4WDCase.Checked = true; } else if (brand4WD == WDBrand.Challenger) { rbtnBrand4WDChallenger.Checked = true; } else if (brand4WD == WDBrand.JDeere) { rbtnBrand4WDJDeere.Checked = true; } else if (brand4WD == WDBrand.NewHolland) { rbtnBrand4WDNH.Checked = true; } else { rbtnBrand4WDAoG.Checked = true; } tab1.Appearance = TabAppearance.FlatButtons; tab1.ItemSize = new Size(0, 1); tab1.SizeMode = TabSizeMode.Fixed; HideSubMenu(); nudTrailingHitchLength.Controls[0].Enabled = false; nudDrawbarLength.Controls[0].Enabled = false; nudTankHitch.Controls[0].Enabled = false; nudLookAhead.Controls[0].Enabled = false; nudLookAheadOff.Controls[0].Enabled = false; nudTurnOffDelay.Controls[0].Enabled = false; nudOffset.Controls[0].Enabled = false; nudOverlap.Controls[0].Enabled = false; nudCutoffSpeed.Controls[0].Enabled = false; nudMinTurnRadius.Controls[0].Enabled = false; nudAntennaHeight.Controls[0].Enabled = false; nudAntennaOffset.Controls[0].Enabled = false; nudAntennaPivot.Controls[0].Enabled = false; nudLightbarCmPerPixel.Controls[0].Enabled = false; nudVehicleTrack.Controls[0].Enabled = false; nudSnapDistance.Controls[0].Enabled = false; nudABLength.Controls[0].Enabled = false; nudWheelbase.Controls[0].Enabled = false; nudLineWidth.Controls[0].Enabled = false; nudMinCoverage.Controls[0].Enabled = false; nudDefaultSectionWidth.Controls[0].Enabled = false; nudSection1.Controls[0].Enabled = false; nudSection2.Controls[0].Enabled = false; nudSection3.Controls[0].Enabled = false; nudSection4.Controls[0].Enabled = false; nudSection5.Controls[0].Enabled = false; nudSection6.Controls[0].Enabled = false; nudSection7.Controls[0].Enabled = false; nudSection8.Controls[0].Enabled = false; nudSection9.Controls[0].Enabled = false; nudSection10.Controls[0].Enabled = false; nudSection11.Controls[0].Enabled = false; nudSection12.Controls[0].Enabled = false; nudSection13.Controls[0].Enabled = false; nudSection14.Controls[0].Enabled = false; nudSection15.Controls[0].Enabled = false; nudSection16.Controls[0].Enabled = false; nudMinFixStepDistance.Controls[0].Enabled = false; nudStartSpeed.Controls[0].Enabled = false; nudForwardComp.Controls[0].Enabled = false; nudReverseComp.Controls[0].Enabled = false; nudAgeAlarm.Controls[0].Enabled = false; nudMaxCounts.Controls[0].Enabled = false; nudRaiseTime.Controls[0].Enabled = false; nudLowerTime.Controls[0].Enabled = false; nudTramWidth.Controls[0].Enabled = false; nudMenusOnTime.Controls[0].Enabled = false; nudGuidanceLookAhead.Controls[0].Enabled = false; }
/// <summary> /// 插入品牌 /// </summary> /// <param name="tbrand"></param> /// <returns></returns> public int AddBrand(TBrand tbrand) { return(BrandOperate.AddBrand(tbrand)); }
/// <summary> /// 更新品牌 /// </summary> /// <param name="tbrand"></param> /// <param name="id"></param> /// <returns></returns> public int UpdateBrand(TBrand tbrand, int id) { return(BrandOperate.UpdateBrand(tbrand, id)); }
private void tabVBrand_Enter(object sender, EventArgs e) { //Brand constructor brand = Settings.Default.setBrand_TBrand; if (brand == TBrand.Case) { rbtnBrandTCase.Checked = true; } else if (brand == TBrand.Claas) { rbtnBrandTClaas.Checked = true; } else if (brand == TBrand.Deutz) { rbtnBrandTDeutz.Checked = true; } else if (brand == TBrand.Fendt) { rbtnBrandTFendt.Checked = true; } else if (brand == TBrand.JDeere) { rbtnBrandTJDeere.Checked = true; } else if (brand == TBrand.Kubota) { rbtnBrandTKubota.Checked = true; } else if (brand == TBrand.Massey) { rbtnBrandTMassey.Checked = true; } else if (brand == TBrand.NewHolland) { rbtnBrandTNH.Checked = true; } else if (brand == TBrand.Same) { rbtnBrandTSame.Checked = true; } else if (brand == TBrand.Steyr) { rbtnBrandTSteyr.Checked = true; } else if (brand == TBrand.Ursus) { rbtnBrandTUrsus.Checked = true; } else if (brand == TBrand.Valtra) { rbtnBrandTValtra.Checked = true; } else { rbtnBrandTAoG.Checked = true; } brandH = Settings.Default.setBrand_HBrand; if (brandH == HBrand.Case) { rbtnBrandHCase.Checked = true; } else if (brandH == HBrand.Claas) { rbtnBrandHClaas.Checked = true; } else if (brandH == HBrand.JDeere) { rbtnBrandHJDeere.Checked = true; } else if (brandH == HBrand.NewHolland) { rbtnBrandHNH.Checked = true; } else { rbtnBrandHAoG.Checked = true; } brand4WD = Settings.Default.setBrand_WDBrand; if (brand4WD == WDBrand.Case) { rbtnBrand4WDCase.Checked = true; } else if (brand4WD == WDBrand.Challenger) { rbtnBrand4WDChallenger.Checked = true; } else if (brand4WD == WDBrand.JDeere) { rbtnBrand4WDJDeere.Checked = true; } else if (brand4WD == WDBrand.NewHolland) { rbtnBrand4WDNH.Checked = true; } else { rbtnBrand4WDAoG.Checked = true; } }