public void DisplaySettingValue_Dac(setting frm)
{
if (conn == null) //DB
{
conn = new OleDbConnection(connStr);
conn.Open(); //DB open
}
string sql = "SELECT * FROM table1";
comm = new OleDbCommand(sql, conn);
reader = comm.ExecuteReader();
while (reader.Read())
{
frm.t1.Text = reader["Dac02"] + "";
frm.t2.Text = reader["Dac03"] + "";
frm.t3.Text = reader["Dac04"] + "";
frm.t4.Text = reader["Dac05"] + "";
frm.t5.Text = reader["Dac06"] + "";
frm.t6.Text = reader["Dac07"] + "";
frm.t7.Text = reader["Dac08"] + "";
frm.t8.Text = reader["Dac09"] + "";
frm.t9.Text = reader["Dac10"] + "";
frm.t10.Text = reader["Dac11"] + "";
frm.t11.Text = reader["DacValue"] + "";
frm.t12.Text = reader["DacPerc"] + "";
}
reader.Close();
conn.Close();
conn = null;
}
public setting SetValue(setting value, bool force)
{
setting o = value;
using (SQLiteDb db = new SQLiteDb(datafile)) o = SetValue(db, value, force);
return(o);
}
public void AddSetting()
{
setting newsetting = new setting(){ Name="Test", Value="Test Value"};
newsetting.SaveAndFlush();
PropertyBag["PropertyID"] = newsetting.Id;
RenderView("addedsetting");
}
public ActionResult SetUrl(string url)
{
setting setting = entity.setting.FirstOrDefault(p => p.key == "url");
setting.value = url;
return(Json(entity.SaveChanges() > 0, JsonRequestBehavior.AllowGet));
}
public Calculate(setting setting, OutlineRenderFeature render, RenderTargetIdentifier source)
{
mysetting = setting;
SelectOutline = render;
sour = source;
my_level = new LEVEL[maxLevel];
for (int t = 0; t < maxLevel; t++) //申请32个ID的，up和down各16个，用这个id去代替临时RT来使用
{
my_level[t] = new LEVEL
{
down = Shader.PropertyToID("_OutlineBlurMipDown" + t),
up = Shader.PropertyToID("_OutlineBlurMipUp" + t)
};
}
if (mysetting.ColorType == TYPE.INcolorON)
{
mysetting.mymat.EnableKeyword("_INCOLORON");
mysetting.mymat.DisableKeyword("_INCOLOROFF");
}
else
{
mysetting.mymat.EnableKeyword("_INCOLOROFF");
mysetting.mymat.DisableKeyword("_INCOLORON");
}
}
public ActionResult Create(setting setting, HttpPostedFileBase[] files)
{
if (ModelState.IsValid)
{
if (files != null)
{
for (int i = 0; i < files.Length; i++)
{
if (files[i] != null)
{
string path = "";
path = Path.Combine(Server.MapPath("/Content/ProductImage"), Path.GetFileName(files[i].FileName));
var picId = db.artlinks.OrderByDescending(x => x.LINENO).FirstOrDefault();
files[i].SaveAs(path);
setting.urlimage = "/Content/ProductImage/" + files[i].FileName;
}
}
}
db.settings.Add(setting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(setting));
}
public setValues GetRowBySettingName(string settingName)
{
setValues sv = new setValues();
List <setValues> svl = new List <setValues>();
// DateTime cmpdate = DateTime.Now.AddDays(newdays);
try
{
using (incposdbEntities entity = new incposdbEntities())
{
setting sett = entity.setting.Where(s => s.name == settingName).FirstOrDefault();
var svlv = entity.setValues.ToList();
svl = svlv.Where(x => sett.settingId == x.settingId)
.Select(X => new setValues
{
valId = X.valId,
value = X.value,
isDefault = X.isDefault,
isSystem = X.isSystem,
settingId = X.settingId,
notes = X.notes,
}).ToList();
sv = svl.FirstOrDefault();
return(sv);
}
}
catch
{
sv = new setValues();
// return ex.ToString();
return(sv);
}
}
public ActionResult SetTime(string time)
{
setting setting = entity.setting.FirstOrDefault(p => p.key == "time");
setting.value = time;
return(Json(entity.SaveChanges() > 0, JsonRequestBehavior.AllowGet));
}
public static void registerSetting(string file, string name, object defaultValue, ValidatorDelegate validator, SaveFormatDelegate saveFormat)
{
INIFile f;
setting v = new setting();
if (!Directory.Exists(SettingsDirectory()))
{
Directory.CreateDirectory(SettingsDirectory());
}
string[] taxonomy = name.Split(".".ToCharArray(), 2);
//Debug.Assert(taxonomy.Length == 2, "Taxonomy must include at least one dot character [.]");
v.name = name;
v.fileName = file;
v.validate = validator;
v.saveFormat = saveFormat;
v.defaultValue = defaultValue;
f = new INIFile(SettingsDirectory() + v.fileName + configSuffix);
v.actualValue = validator(f.ReadValue(taxonomy[0], taxonomy[1], saveFormat(defaultValue)));
settings.Add(name, v);
}
public setting GetValue(string name, string grp)
{
setting s = null;
using (SQLiteDb db = new SQLiteDb(datafile)) s = GetValue(db, name, null, grp);
return(s);
}
public static void set(string name, Object value)
{
setting s = settings[name];
s.actualValue = value;
settings[name] = s;
}
public static void LoadSettingData()
{
var list = FileInput.Input(FilePath);
// ファイルの存在を確認する
if (list != null)
{
// foreachを使いファイルをデータ化する
foreach (string line in list)
{
var str = line.Split('\t');
switch (list.IndexOf(line))
{
case 0: // 一行目
if (str.Length < 2)
{
goto write; // 書式が不正だったとき
}
double.TryParse(str[0], out SettingData.scale);
byte.TryParse(str[1], out SettingData.fullscreen);
break;
}
}
return;
}
write:
// 存在しなかった場合新しくファイルを出力する
SettingData = new setting(0);
WriteSettingData(SettingData, true);
return;
}
private void btnGet_Click(object sender, EventArgs e)
{
if (settingsManager == null)
{
return;
}
if (int.TryParse(txtIndex.Text, out int index))
{
txtName.Text = txtData1.Text = txtData2.Text = string.Empty;
if (settingsNames.ContainsKey(index))
{
setting setting = settingsManager.GetSetting(settingsNames[index]);
if (setting == null)
{
txtName.Text = txtData1.Text = txtData2.Text = string.Empty;
}
else
{
txtName.Text = getName(setting);
txtData1.Text = setting.data1.ToString();
txtData2.Text = setting.data2.ToString();
}
}
}
}
private void button4_Click(object sender, EventArgs e)
{
var setting = new setting(im);
setting.StartPosition = FormStartPosition.CenterParent;
setting.ShowDialog(this);
}
public Text QuizText1, QuizText2, QuizText3; //クイズ問題
// Use this for initialization
void Start()
{
opningcs = GetComponent <opning>();
settingcs = GetComponent <setting>();
QuizText1.text = "";
QuizText2.text = "";
QuizText3.text = "";
}
private static void Save(setting v)
{
INIFile f = new INIFile(SettingsDirectory() + v.fileName + configSuffix);
string[] taxonomy = v.name.Split(".".ToCharArray(), 2);
f.WriteValue(taxonomy[0], taxonomy[1], v.saveFormat(v.actualValue));
}
public ActionResult DeleteOrderSetting(int?id)
{
setting setting = db.settings.Find(id);
db.settings.Remove(setting);
db.SaveChanges();
return(RedirectToAction("SettingIndex"));
}
public ActionResult DeleteConfirmed(string id)
{
setting setting = db.setting.Find(id);
db.setting.Remove(setting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
internal void sleep()
{
if (currState != setting.sleep)
{
sleepState = currState;
currState = setting.sleep;
}
}
public static void WriteSettingData(setting data, bool OverWriteFlag)
{
// OverWriteFlag = true → 上書き
// データの書き込みを行う
using (var w = new StreamWriter(FilePath, !OverWriteFlag))
{
w.WriteLine("{0}\t{1}", data.scale, data.fullscreen);
}
}
/// <summary>
/// Checks if line is the provided setting. If so, it will set the setting in memory
/// </summary>
/// <param name="s"></param>
/// <param name="line"></param>
/// <returns></returns>
private bool load_setting(setting key, string line)
{
if (line.Trim().StartsWith(key + ":"))
{
string value = line.Replace(key + ":", "").Trim();
set_setting(key, value);
return(true);
}
return(false);
}
public ActionResult Edit([Bind(Include = "channel_name,background,type,full_name")] setting setting)
{
if (ModelState.IsValid)
{
db.Entry(setting).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(setting));
}
public IActionResult Create(setting setting, string returnUrl = null)
{
if (ModelState.IsValid)
{
repository.AddEntity(setting);
return(RedirectToLocal(returnUrl));
}
ViewData["ReturnUrl"] = returnUrl;
return(View(setting));
}
private void SaveSetting_Click(object sender, EventArgs e)
{
saveFileDialog1.Filter = "XML files (*.xml)|*.xml";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)//Save setting file
{
setting save = new setting();
save.temperature = float.Parse(targettemp.Text);
save.moisture = float.Parse(targetmoist.Text);
save.s_radius = float.Parse(sample_radius.Text);
save.samples = uint.Parse(Sample.Text);
save.sampleid = uint.Parse(sampleid.Text);
save.s_angle = float.Parse(angle.Text);
save.h_radius = float.Parse(radius.Text);
save.holeid = uint.Parse(holeid.Text);
save.h_off = float.Parse(hole_off.Text);
save.h_angle = float.Parse(angle.Text);
save.LED = decimal.ToUInt32(LED_light.Value);
save.uL = uint.Parse(uL.Text);
save.test_time = int.Parse(textBox7.Text);
save.test_time_unit = comboBox1.SelectedIndex;
save.time = int.Parse(textBox1.Text);
save.time_unit = comboBox2.SelectedIndex;
save.grid_size = dataGridView1.RowCount;
for (int i = 0; i < save.grid_size; i++)
{
save.grid_name.Add(dataGridView1[1, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_resualt.Add(dataGridView1[2, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_diameter.Add(dataGridView1[3, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_uL.Add(dataGridView1[4, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_other.Add(dataGridView1[6, i].Value.ToString());
}
XmlSerializer serializer = new XmlSerializer(save.GetType());
TextWriter writer = new StreamWriter(saveFileDialog1.FileName);
serializer.Serialize(writer, save);
writer.Close();
}
}
public ActionResult Create([Bind(Include = "channel_name,background,type,full_name")] setting setting)
{
if (ModelState.IsValid)
{
db.setting.Add(setting);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(setting));
}
// Use this for initialization
void Start()
{
opningcs = GetComponent <opning>();
settingcs = GetComponent <setting>();
quizbookcs = GetComponent <quizbook>();
frame = new Vector3(100, 3.75f, 0); //枠組みの位置
Frame.transform.position = frame; //枠組みの位置を代入(最初はカメラの範囲外に)
judge = new Vector3(50, 50, 0); //〇×の位置
Judge.transform.position = judge; //〇×の位置(最初は両方とも見えないように)
}
/*-------------------------------------------------------------------------
*
* ---------------------------------------------------------------------------*/
public sea_routes_form(setting _setting)
{
// 設定内容をコピーして持つ
m_setting = _setting.Clone();
InitializeComponent();
useful.SetFontMeiryo(this, def.MEIRYO_POINT);
checkBox1.Checked = m_setting.remove_sea_routes_routes;
checkBox2.Checked = m_setting.remove_sea_routes_popup;
checkBox3.Checked = m_setting.remove_sea_routes_accident;
}
private void alSetBt_Click(object sender, EventArgs e)
{
alSetBt.Enabled = false;
setting = new setting(ConAl, cP.InfoReturn);
cP.Chk = alList;
setting.setChk = new DgChkBox(cP.getDgChkBox);
setting.setParam = new DgParam(cP.getDgInfo);
setting.setReturnValue = new DgReturnValue(cP.getDgReturnValue);
setting.MdiParent = this.ParentForm;
setting.Show();
setting.FormClosed += new FormClosedEventHandler(btEnable);
}
public ActionResult sett(setting k)
{
try
{
con.Open();
com = new SqlCommand("update setting set name='" + k.name + "',password='******' where id=" + k.id + " ", con);
com.ExecuteNonQuery();
con.Close();
Response.Write("<script>alert('تم التعديل')</script>");
return(View());
}
catch { ViewBag.Emsg = "خطأ لم يتم الحفظ"; return(View()); }
}
public DrawSoildColorPass(setting setting, OutlineRenderFeature render)
{
mysetting = setting;
SelectOutline = render;
//过滤设定
RenderQueueRange queue = new RenderQueueRange();
queue.lowerBound = Mathf.Min(setting.QueueMax, setting.QueueMin);
queue.upperBound = Mathf.Max(setting.QueueMax, setting.QueueMin);
filter = new FilteringSettings(queue, setting.layer);
}
/// <summary>
/// add new
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int add(ref setting obj)
{
using (NpgsqlDBConnection db = new NpgsqlDBConnection())
{
try
{
int ID = -1;
if (db.open_connection())
{
string sql_command = "INSERT INTO settings ( setting_key, " +
" setting_value, setting_type, note, setting_datetime)" +
" VALUES (:setting_key, " +
" :setting_value, :setting_type, :note, :setting_datetime)";
sql_command += " RETURNING id;";
using (NpgsqlCommand cmd = db._conn.CreateCommand())
{
cmd.CommandText = sql_command;
cmd.Parameters.Add(":setting_key", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.setting_key;
cmd.Parameters.Add(":setting_value", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.setting_value;
cmd.Parameters.Add(":setting_type", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.setting_type;
cmd.Parameters.Add(":note", NpgsqlTypes.NpgsqlDbType.Varchar).Value = obj.note;
cmd.Parameters.Add(":setting_datetime", NpgsqlTypes.NpgsqlDbType.Timestamp).Value = obj.setting_datetime;
ID = Convert.ToInt32(cmd.ExecuteScalar());
obj.id = ID;
db.close_connection();
return(ID);
}
}
else
{
db.close_connection();
return(-1);
}
}
catch
{
if (db != null)
{
db.close_connection();
}
return(-1);
}
finally
{ db.close_connection(); }
}
}
partial void Deletesetting(setting instance);
private void LoadSetting_Click(object sender, EventArgs e)
{
openFileDialog1.Filter = "XML files (*.xml)|*.xml";
if (openFileDialog1.ShowDialog() == DialogResult.OK)//Load setting file
{
int i;
setting save = new setting();
XmlSerializer serializer = new XmlSerializer(save.GetType());
TextReader read = new StreamReader(openFileDialog1.FileName);
save = (setting)serializer.Deserialize(read);
read.Close();
targettemp.Text = save.temperature.ToString();
targetmoist.Text = save.moisture.ToString();
sample_radius.Text = save.s_radius.ToString();
Sample.Text = save.samples.ToString();
sampleid.Text = save.sampleid.ToString();
angle.Text = save.s_angle.ToString();
radius.Text = save.h_radius.ToString();
holeid.Text = save.holeid.ToString();
hole_off.Text = save.h_off.ToString();
angle.Text = save.h_angle.ToString();
LED_light.Value = new decimal(save.LED);
uL.Text = save.uL.ToString();
textBox7.Text = save.test_time.ToString();
comboBox1.SelectedIndex = save.test_time_unit;
textBox1.Text = save.time.ToString();
comboBox2.SelectedIndex = save.time_unit;
i = 0;
foreach(string s in save.grid_name)
{
dataGridView1[1, i].Value = s;
i++;
}
i = 0;
foreach (string s in save.grid_resualt)
{
dataGridView1[2, i].Value = s;
i++;
}
i = 0;
foreach(string s in save.grid_diameter)
{
dataGridView1[3, i].Value = s;
i++;
}
i = 0;
foreach (string s in save.grid_uL)
{
dataGridView1[4, i].Value = s;
i++;
}
i = 0;
foreach (string s in save.grid_other)
{
dataGridView1[6, i].Value = s;
i++;
}
}
}
private void SaveSetting_Click(object sender, EventArgs e)
{
saveFileDialog1.Filter = "XML files (*.xml)|*.xml";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)//Save setting file
{
setting save = new setting();
save.temperature = float.Parse(targettemp.Text);
save.moisture = float.Parse(targetmoist.Text);
save.s_radius = float.Parse(sample_radius.Text);
save.samples = uint.Parse(Sample.Text);
save.sampleid = uint.Parse(sampleid.Text);
save.s_angle = float.Parse(angle.Text);
save.h_radius = float.Parse(radius.Text);
save.holeid = uint.Parse(holeid.Text);
save.h_off = float.Parse(hole_off.Text);
save.h_angle = float.Parse(angle.Text);
save.LED = decimal.ToUInt32(LED_light.Value);
save.uL = uint.Parse(uL.Text);
save.test_time = int.Parse(textBox7.Text);
save.test_time_unit = comboBox1.SelectedIndex;
save.time = int.Parse(textBox1.Text);
save.time_unit = comboBox2.SelectedIndex;
save.grid_size = dataGridView1.RowCount;
for (int i = 0; i < save.grid_size; i++)
{
save.grid_name.Add(dataGridView1[1, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_resualt.Add(dataGridView1[2, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_diameter.Add(dataGridView1[3, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_uL.Add(dataGridView1[4, i].Value.ToString());
}
for (int i = 0; i < save.grid_size; i++)
{
save.grid_other.Add(dataGridView1[6, i].Value.ToString());
}
XmlSerializer serializer = new XmlSerializer(save.GetType());
TextWriter writer = new StreamWriter(saveFileDialog1.FileName);
serializer.Serialize(writer, save);
writer.Close();
}
}
partial void Insertsetting(setting instance);
partial void Updatesetting(setting instance);
private void saveSettingsToFile(setting s, DirectoryInfo di)
{
//get serializer
IFormatter serializer = new BinaryFormatter();
try
{
FileStream saveFile = new FileStream(di
+ "\\settings.bin", FileMode.Create, FileAccess.Write);
serializer.Serialize(saveFile, s);
saveFile.Close();
}
catch (Exception ex)
{
throw ex;
}
}
private setting getSettingsFromFile(DirectoryInfo di)
{
IFormatter serializer = new BinaryFormatter();
setting temp = new setting();
try
{
FileStream loadFile = new FileStream(di + "\\settings.bin",
FileMode.Open, FileAccess.Read);
temp = serializer.Deserialize(loadFile) as setting;
loadFile.Close();
}
catch (Exception ex)
{
throw ex;
}
return temp;
}
//when serchbox has changed,update the results
public void Search(String queryString,bool textQuery)
{
if (queryString == txtnote.Resources.StringLibrary.searchBox)
{
queryString = "";
}
setting abc = new setting();
if (textQuery == true)
{
if (abc.RadioButton1Setting)
{
var query =
from ord in toDoDB.Items
where ord.ItemName.Contains(queryString) || ord.TxtFile.Contains(queryString)
orderby ord.EditTime descending
select ord;
AllToDoItems = new ObservableCollection<ToDoItem>(query);
}
else
{
if (abc.RadioButton2Setting)
{
var query =
from ord in toDoDB.Items
where ord.ItemName.Contains(queryString) || ord.TxtFile.Contains(queryString)
orderby ord.ItemName descending
select ord;
AllToDoItems = new ObservableCollection<ToDoItem>(query);
}
else
{
var query =
from ord in toDoDB.Items
where ord.ItemName.Contains(queryString) || ord.TxtFile.Contains(queryString)
orderby ord.CreatTime descending
select ord;
AllToDoItems = new ObservableCollection<ToDoItem>(query);
}
}
}
else
{
if (abc.RadioButton1Setting)
{
var query =
from ord in toDoDB.Items
where ord.ItemName.Contains(queryString)
orderby ord.EditTime descending
select ord;
AllToDoItems = new ObservableCollection<ToDoItem>(query);
}
else
{
if (abc.RadioButton2Setting)
{
var query =
from ord in toDoDB.Items
where ord.ItemName.Contains(queryString)
orderby ord.ItemName
select ord;
AllToDoItems = new ObservableCollection<ToDoItem>(query);
}
else
{
var query =
from ord in toDoDB.Items
where ord.ItemName.Contains(queryString)
orderby ord.CreatTime descending
select ord;
AllToDoItems = new ObservableCollection<ToDoItem>(query);
}
}
}
}
public App()
{
// Global handler for uncaught exceptions.
UnhandledException += Application_UnhandledException;
// Standard Silverlight initialization
InitializeComponent();
// 特定于电话的初始化
InitializePhoneApplication();
setting abc = new setting();
switch (abc.ListBoxSetting)
{
case 0:
System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("zh-CN");
txtnote.Resources.StringLibrary.Culture = ci;
break;
case 1:
System.Globalization.CultureInfo en = new System.Globalization.CultureInfo("en-US");
txtnote.Resources.StringLibrary.Culture = en;
break;
case 2:
System.Globalization.CultureInfo ciJA = new System.Globalization.CultureInfo("ja");
txtnote.Resources.StringLibrary.Culture = ciJA;
break;
default:
break;
}
// 调试时显示图形分析信息。
if (System.Diagnostics.Debugger.IsAttached)
{
// 显示当前帧速率计数器。
Application.Current.Host.Settings.EnableFrameRateCounter = true;
// 显示在每个帧中重绘的应用程序区域。
//Application.Current.Host.Settings.EnableRedrawRegions = true；
// Enable non-production analysis visualization mode,
// 该模式显示递交给 GPU 的包含彩色重叠区的页面区域。
//Application.Current.Host.Settings.EnableCacheVisualization = true；
// Disable the application idle detection by setting the UserIdleDetectionMode property of the
// application's PhoneApplicationService object to Disabled.
// 注意: 仅在调试模式下使用此设置。禁用用户空闲检测的应用程序在用户不使用电话时将继续运行
// 并且消耗电池电量。
PhoneApplicationService.Current.UserIdleDetectionMode = IdleDetectionMode.Disabled;
}
// Specify the local database connection string.
string DBConnectionString = "Data Source=isostore:/ToDo.sdf";
// Create the database if it does not exist.
using (ToDoDataContext db = new ToDoDataContext(DBConnectionString))
{
if (db.DatabaseExists() == false)
{
// Create the local database.
db.CreateDatabase();
// Prepopulate the categories.
db.Categories.InsertOnSubmit(new ToDoCategory { Name = txtnote.Resources.StringLibrary.richang });
db.Categories.InsertOnSubmit(new ToDoCategory { Name = txtnote.Resources.StringLibrary.gongzuo });
db.Categories.InsertOnSubmit(new ToDoCategory { Name = txtnote.Resources.StringLibrary.xingqu });
// Save categories to the database.
db.SubmitChanges();
}
}
// Create the ViewModel object.
viewModel = new ToDoViewModel(DBConnectionString);
// Query the local database and load observable collections.
viewModel.LoadCollectionsFromDatabase();
}
