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;
}
}
