private void MethodEdit_Load(object sender, EventArgs e) { methodeditmethodnametextbox.Text = methodentity.getmethodname(); for (int i = 0; i < methodentity.getsettinglist().Count; i++) { methodeditparamatercombox.Items.Add(((Settingentity)methodentity.getsettinglist()[i]).getparamatername()); } }
private void Method_Load(object sender, EventArgs e) { if (methodtemp.getsettinglist().Count > 0) { methodnamevalue.Text = methodtemp.getmethodname(); Paramaternumbertextbox.Text = methodtemp.getsettinglist().Count.ToString(); String temp = ""; for (int i = 0; i < methodtemp.getsettinglist().Count; i++) { temp = temp + ((Settingentity)methodtemp.getsettinglist()[i]).getparamatername(); if (i != methodtemp.getsettinglist().Count - 1) { temp = temp + ","; } } namevalue.Text = temp; } }
private void save_Click(object sender, EventArgs e) { if (editflag == 1) { MySqlDataReader tempsqlreader = databaseoperator.select("methodtable", "Methodname", methodtemp.getmethodname()); ArrayList deletelist = new ArrayList(); while (tempsqlreader.Read()) { deletelist.Add((String)tempsqlreader.GetValue(3)); } databaseoperator.connectdatabase(); databaseoperator.opendatabase(); databaseoperator.deletedata("methodtable", "Methodname", methodtemp.getmethodname()); for (int i = 0; i < deletelist.Count; i++) { databaseoperator.deletedata("settingentitytable", "Paramaterindex", (String)deletelist[i]); databaseoperator.deletedata("resulttable", "Resultvalueindex", (String)deletelist[i]); databaseoperator.deletedata("rectangletable", "Rectangleindex", (String)deletelist[i]); databaseoperator.deletedata("setzonetable", "Setzoneindex", (String)deletelist[i]); } databaseoperator.closedatabase(); } bool flagtemp = true; methodtemp.getcameraandsourcesetting().setcameraname(devicename); methodtemp.getcameraandsourcesetting().setresolution(resolution); methodtemp.getcameraandsourcesetting().setbrightnes(brightness); methodtemp.getcameraandsourcesetting().setcontrast(contrast); methodtemp.getcameraandsourcesetting().setsaturation(saturation); for (int k = 0; k < methodlisttemp.Count; k++) { MethodEntity temp = (MethodEntity)methodlisttemp[k]; if (temp.getmethodname() == methodtemp.getmethodname()) { flagtemp = false; break; } } if (flagtemp == true) { methodlisttemp.Add(methodtemp); } for (int databasei = 0; databasei < methodtemp.getsettinglist().Count; databasei++) { string paramaterindex = methodtemp.getmethodname().ToString() + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername().ToString(); databaseoperator.insertdata("Methodtable", "Methodname,Paramaters,Paramaterindex,Brightness,Contrast,Saturation,Cameraname,Resolution, Sensitivevalue,Adjustvalue", "'" + methodtemp.getmethodname().ToString() + "'" + "," + "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername().ToString() + "'" + "," + "'" + paramaterindex + "'" + "," + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getbrightness() + "," + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getcontrast() + "," + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getsaturation() + "," + "'" + ((Cameraandsourcesetting)methodtemp.getcameraandsourcesetting()).getcameraname() + "'" + "," + methodtemp.getcameraandsourcesetting().getresolution() + "," + methodtemp.getsensitive() + "," + methodtemp.getadjustvalue()); string settingtablevalue = "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername().ToString() + "'" + "," + "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getlinevalue().ToString() + "'" + "," + ((Settingentity)methodtemp.getsettinglist()[databasei]).getshuttertimes().ToString() + "," + ((Settingentity)methodtemp.getsettinglist()[databasei]).getreadytime().ToString() + "," + "'" + methodtemp.getmethodname().ToString() + "'" + "," + "'" + paramaterindex.ToString() + "'" + "," + "'" + paramaterindex.ToString() + "'" + "," + "'" + paramaterindex.ToString() + "'"; databaseoperator.insertdata("Settingentitytable", "Paramatername,Cline,Shuttertime,Readytime,Methodname,Resultvalueindex,Rectangleindex,Paramaterindex", settingtablevalue); string rectangletablevalue = "'" + paramaterindex + "'" + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getx().ToString() + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).gety().ToString() + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getimagewidth().ToString() + "," + ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getimageheight().ToString(); databaseoperator.insertdata("Rectangletable", "Rectangleindex,X,Y,Width,Height", rectangletablevalue); for (int resulti = 0; resulti < ((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist().Count; resulti++) { //string resultvalueindex = paramaterindex + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultname().ToString(); string resultvalueindex = paramaterindex; string resulttablevalue = "'" + resultvalueindex + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultname().ToString() + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultstartvalue().ToString() + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultendvalue().ToString() + "'" + "," + "'" + ((ResultEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getresultentitylist()[resulti]).getresultvalue() + "'"; databaseoperator.insertdata("Resulttable", "Resultvalueindex,Resultname,Resultstartvalue,Resultendvalue,Resultvalue", resulttablevalue); } for (int setzonei = 0; setzonei < ((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist().Count; setzonei++) { string setzonetablevalue = "'" + ((Settingentity)methodtemp.getsettinglist()[databasei]).getparamatername() + "'" + "," + "'" + paramaterindex + "'" + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositionx().ToString() + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositiony().ToString() + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositionwidth().ToString() + "," + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonepositionheight().ToString() + "," + "'" + ((Setzoneentity)((ImageSampleEntity)((Settingentity)methodtemp.getsettinglist()[databasei]).getImageSample()).getcontrolzonelist()[setzonei]).getzonecategory() + "'"; databaseoperator.insertdata("SetZonetable", "Paramater,Setzoneindex,ZonepositionX,ZonepositionY,ZonepositionWidth, ZonepositionHeight, Zonecategory", setzonetablevalue); } } formtemp.OnLoad(); form.getclosingmethod(); form.Dispose(); }