public ActionResult DBProviders()
{
NameValueList providers = new NameValueList();
try
{
foreach (Provider provider in System.Enum.GetValues(typeof(Provider)))
{
string value = provider.ToString();
providers.Add(new ListItem()
{
Name = value, Value = value
});
}
return(Json(providers, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
_logger.Error(e.ToString());
_CustomErrorLog = new CustomErrorLog();
_CustomError = _CustomErrorLog.customErrorLogger(ErrorMessages.errUIDBProviders, e, _logger);
return(Json(new { success = false, message = "[ Message Id " + _CustomError.msgId + "] - " + _CustomError.errMessage, stackTraceDescription = _CustomError.stackTraceDescription }, JsonRequestBehavior.AllowGet));
}
}
public static bool Save(Transaction trans, params string[] fields)
{
NameValueList config = OriData;
lock (Singleton)
{
Transaction _trans = trans;
if (_trans == null)
{
_trans = new Transaction(true);
}
bool res = true;
foreach (var nv in OriData)
{
if (fields.Length == 0 || nv.Name.In(fields))
{
object d = Burst.Utils.Serialize(nv.Value, SerializeType);
NameValueList pms = new NameValueList();
pms.Add("@" + KeyFieldName, nv.Name);
pms.Add("@" + TypeFieldName, nv.Value.GetType().AssemblyQualifiedName);
pms.Add("@" + ValueFieldName, d);
Command cmd = DbProvider.Adapter.GetReplaceCommand(TableName, nv.Name, KeyFieldName, pms, DbProvider);
res = cmd.ExecuteNonQuery(_trans) > -1 && res;
}
}
if (trans != null)
{
return(res);
}
return(_trans.Commit());
}
}
private void CopyCollection(NameValueList dest, object collection)
{
if (dest == null || collection == null)
{
return;
}
if (collection is SortedDictionary <string, object> sorteddict)
{
foreach (var kvp in sorteddict)
{
this.Items.Add(new NameValuePair(kvp.Key, kvp.Value));
}
}
else if (collection is Dictionary <string, object> dict)
{
foreach (var kvp in dict)
{
this.Items.Add(new NameValuePair(kvp.Key, kvp.Value));
}
}
else if (collection is IEnumerable <(string, object)> kvparray)
{
foreach (var a in kvparray)
{
this.Items.Add(new NameValuePair(a.Item1, a.Item2));
}
}
public DbConnectException(Exception InnerException, NameValueList Config)
: base(string.Empty, InnerException)
{
this.ConnectionString = Config.Get <string>("ConnectionString");
this.DbProviderFactory = Config.Get <DbProviderFactory>("DbProviderFactory");
this.DbAdapter = Config.Get <IDbAdapter>("DbAdapter");
}
public static Command GetInsertCommand(InsertType iops, IEnumerable <NameValue> pms)
{
if (pms.Count() == 0)
{
return(null);
}
StringBuilder ss = new StringBuilder(), vs = new StringBuilder();
NameValueList pre = new NameValueList(pms);
NameValueList _pms = new NameValueList();
foreach (var fi in AllFields)
{
if (pre.ContainsKey(fi.Attribute.DbFieldName))
{
if (iops == InsertType.New && fi.Key)
{
continue;
}
ss.AppendFormat("{0},", fi.EnsuredName);
vs.AppendFormat("@{0},", fi.Attribute.DbFieldName);
_pms.Add(GetFieldValue(fi, InsertType.None, pre[fi.Attribute.DbFieldName]));
}
}
if (ss.Length > 0)
{
ss.Remove(ss.Length - 1, 1);
vs.Remove(vs.Length - 1, 1);
}
return(DbProvider.CreateCommand(string.Format("insert into {0} ({1}) values ({2})", EnsuredTableName, ss, vs), _pms));
}
/// <summary>
/// Adds or updates a name-value pair in this request's Cookie header.
/// To automatically maintain a cookie "session", consider using a CookieJar or CookieSession instead.
/// </summary>
/// <param name="request">The IFlurlRequest.</param>
/// <param name="name">The cookie name.</param>
/// <param name="value">The cookie value.</param>
/// <returns>This IFlurlClient instance.</returns>
public static IFlurlRequest WithCookie(this IFlurlRequest request, string name, object value)
{
var cookies = new NameValueList <string>(request.Cookies);
cookies.AddOrReplace(name, value.ToInvariantString());
return(request.WithHeader("Cookie", CookieCutter.ToRequestHeader(cookies)));
}
public DbConnectException(Exception InnerException, NameValueList Config)
: base(string.Empty, InnerException)
{
this.ConnectionString = Config.Get<string>("ConnectionString");
this.DbProviderFactory = Config.Get<DbProviderFactory>("DbProviderFactory");
this.DbAdapter = Config.Get<IDbAdapter>("DbAdapter");
}
public static bool Delete(Transaction trans, params string[] fields)
{
NameValueList config = OriData;
lock (Singleton)
{
Transaction _trans = trans;
if (_trans == null)
{
_trans = new Transaction(true);
}
bool res = true;
foreach (var nv in OriData)
{
if (fields.Length == 0 || nv.Name.In(fields))
{
Command cmd = new Command(string.Format("delete from {0}", EnsuredTableName));
Builder.AppendWhere(cmd, new Where(WhereType.Key, nv.Name), KeyFieldName, DbProvider.Adapter);
res = cmd.ExecuteNonQuery(_trans) > -1 && res;
}
}
if (trans != null)
{
return(res);
}
return(_trans.Commit());
}
}
public Command CreateCommand(string cmd, NameValueList pms)
{
Command res = new Command(cmd, pms);
res.DbProvider = this;
return(res);
}
/// <summary>
/// Adds or updates a name-value pair in this request's Cookie header.
/// To automatically maintain a cookie "session", consider using a CookieJar or CookieSession instead.
/// </summary>
/// <param name="request">The IFlurlRequest.</param>
/// <param name="name">The cookie name.</param>
/// <param name="value">The cookie value.</param>
/// <returns>This IFlurlClient instance.</returns>
public static IFlurlRequest WithCookie(this IFlurlRequest request, string name, object value)
{
var cookies = new NameValueList <string>(request.Cookies, true); // cookie names are case-sensitive https://stackoverflow.com/a/11312272/62600
cookies.AddOrReplace(name, value.ToInvariantString());
return(request.WithHeader("Cookie", CookieCutter.ToRequestHeader(cookies)));
}
/// <summary>
/// This method is called when the AccountControl's Load event has been fired.
/// </summary>
/// <param name="sender">The <see cref="object"/> that fired the event.</param>
/// <param name="e">The <see cref="EventArgs"/> of the event.</param>
private void AccountControl_Load(object sender, EventArgs e)
{
if (account == null)
{
return;
}
account.Transactions.Sort(delegate(AccountTransaction x, AccountTransaction y) {
return(x.Date.CompareTo(y.Date));
});
grid.SelectionChanged += GridOnSelectionChanged;
NameValueList settings = ctx.Settings.Get(this);
for (int i = 0; i < grid.Columns.Count; i++)
{
grid.Columns[i].Width = settings[string.Format("GridColumn{0}", i)].ToInt(100);
}
grid.Rows.Clear();
foreach (AccountTransaction t in account.Transactions)
{
int ind = grid.Rows.Add();
DataGridViewRow row = grid.Rows[ind];
row.Tag = t;
row.Cells["Date"].Value = t.Date.ToString("yyyy-MM-dd");
row.Cells["Amount"].Value = t.Amount.Format();
row.Cells["Comment"].Value = t.Comment;
row.Cells["User"].Value = Plug.Users.GetByID(t.UserID).Username;
}
checkBox1.Checked = string.Equals(settings["ShowAll"], "true");
dateTimePicker1.Value = new DateTime(settings["FilterDate"].ToLong(DateTime.Now.Ticks));
}
private IReadOnlyNameValueList <string> LoadHeaders()
{
var result = new NameValueList <string>(false);
foreach (var h in ResponseMessage.Headers)
{
foreach (var v in h.Value)
{
result.Add(h.Key, v);
}
}
if (ResponseMessage.Content?.Headers == null)
{
return(result);
}
foreach (var h in ResponseMessage.Content.Headers)
{
foreach (var v in h.Value)
{
result.Add(h.Key, v);
}
}
return(result);
}
public void SchemaTestMethod()
{
var pms = new NameValueList();
pms.Add("");
var schema = new DbSchema(DbProvider.Initialize(pms));
}
public override string BuildConnectionString(NameValueList pms)
{
StringBuilder res = new StringBuilder("Provider=Microsoft.Jet.OLEDB.4.0;");
if (pms.ContainsKey("FilePath"))
{
if (!string.IsNullOrEmpty(pms["FilePath"] as string))
{
res.AppendFormat("Data Source={0};", Path.GetFullPath(pms["FilePath"] as string));
}
}
if (pms.ContainsKey("Password"))
{
if (!string.IsNullOrEmpty(pms["Password"] as string))
{
res.AppendFormat("Password={0};", pms["Password"]);
}
}
if (pms.ContainsKey("ExtraConfiguration"))
{
if (pms["ExtraConfiguration"] is NameValueList)
{
foreach (NameValue nv in pms["ExtraConfiguration"] as NameValueList)
{
res.AppendFormat("{0}={1};", nv.Name, nv.Value);
}
}
}
return(res.ToString());
}
public static Command GetUpdateCommand(Where where, IEnumerable <NameValue> pms)
{
if (pms.Count() == 0)
{
return(null);
}
StringBuilder ss = new StringBuilder();
NameValueList pre = new NameValueList(pms);
NameValueList _pms = new NameValueList();
foreach (var fi in AllFields)
{
if (pre.ContainsKey(fi.Attribute.DbFieldName))
{
ss.AppendFormat("{0}=@{1},", fi.EnsuredName, fi.Attribute.DbFieldName);
_pms.Add(GetFieldValue(fi, InsertType.None, pre[fi.Attribute.DbFieldName]));
}
}
if (ss.Length > 0)
{
ss.Remove(ss.Length - 1, 1);
}
Command cmd = DbProvider.CreateCommand(string.Format("update {0} set {1}", EnsuredTableName, ss), _pms);
Builder.AppendWhereByEnsuredKey(cmd, where, KeyField.EnsuredName, DbProvider.Adapter);
return(cmd);
}
/// <summary>
/// 从默认配置中初始化数据连接参数，包括连接字符串(ConnectionString)、DbProviderFactory、DbAdapter。
/// </summary>
/// <returns>初始化成功时，返回DbProvider，否则，返回null。</returns>
public static DbProvider Initialize()
{
DbConnection _conn = null;
DbProvider res = new DbProvider();
try
{
res._config["DbAdapter"] = Activator.CreateInstance(Type.GetType(ConfigurationManager.AppSettings["DbAdapter"]));
res.Adapter.InitializeOptions(res.Options);
if (string.IsNullOrEmpty(ConfigurationManager.AppSettings["DbProviderFactory"]) && res.Options["DefaultDbProviderFactory"] != null)
{
res._config["DbProviderFactory"] = _getInstance <DbProviderFactory>(res.Options["DefaultDbProviderFactory"]);
}
else
{
res._config["DbProviderFactory"] = Activator.CreateInstance(Type.GetType(ConfigurationManager.AppSettings["DbProviderFactory"]));
}
res._config["ConnectionString"] = ConfigurationManager.AppSettings["ConnectionString"];
if (string.IsNullOrEmpty(res.ConnectionString))
{
NameValueList DbParameters = new NameValueList();
DbParameters.Add("Host", ConfigurationManager.AppSettings["DbHost"]);
DbParameters.Add("Database", ConfigurationManager.AppSettings["DbDatabase"]);
DbParameters.Add("FilePath", ConfigurationManager.AppSettings["DbFilePath"]);
DbParameters.Add("Username", ConfigurationManager.AppSettings["DbUsername"]);
DbParameters.Add("Password", ConfigurationManager.AppSettings["DbPassword"]);
DbParameters.Add("Charset", ConfigurationManager.AppSettings["DbCharset"]);
DbParameters.Add("Version", ConfigurationManager.AppSettings["DbVersion"]);
DbParameters.Add("ReadOnly", ConfigurationManager.AppSettings["DbReadOnly"]);
res._config["ConnectionString"] = res.Adapter.BuildConnectionString(DbParameters);
}
_conn = res.Provider.CreateConnection();
_conn.ConnectionString = res.ConnectionString;
_conn.Open();
res._config["DbSchema"] = res.Adapter.GetSchema(_conn);
if (Current == null)
{
Current = res;
}
return(res);
}
catch (Exception e)
{
#if DEBUG
DbConnectException dce = new DbConnectException(e, res._config);
Debug.WriteLine(dce);
throw dce;
#endif
return(null);
}
finally
{
try
{
_conn.Close();
}
catch { }
}
}
/// <summary>
/// 使用若干参数初始化数据连接参数。
/// </summary>
/// <param name="Parameters">参数，包括DbProviderFactory(String类型表示的完整限定名称或DbProviderFactory类型)、DbAdapter(String类型表示的类型完整限定名称或DbAdapter类型)，及连接字符串(ConnectionString)或当前IDbAdapter.BuildConnectionString所需参数。</param>
/// <returns>初始化成功时，返回DbProvider，否则，返回null。</returns>
public static DbProvider Initialize(NameValueList Parameters)
{
DbConnection _conn = null;
DbProvider res = new DbProvider();
try
{
IDbAdapter DbAdapter = _getInstance <IDbAdapter>(Parameters["DbAdapter"]);
if (DbAdapter != null)
{
res._config["DbAdapter"] = DbAdapter;
DbAdapter.InitializeOptions(res.Options);
}
DbProviderFactory DbProviderFactory = _getInstance <DbProviderFactory>(Parameters["DbProviderFactory"]);
if (DbProviderFactory != null)
{
res._config["DbProviderFactory"] = DbProviderFactory;
}
else if (res.Options["DefaultDbProviderFactory"] != null)
{
res._config["DbProviderFactory"] = _getInstance <DbProviderFactory>(res.Options["DefaultDbProviderFactory"]);
}
if (Parameters["ConnectionString"] is string)
{
res._config["ConnectionString"] = Parameters["ConnectionString"];
}
else
{
res._config["ConnectionString"] = res.Adapter.BuildConnectionString(Parameters);
}
_conn = res.Provider.CreateConnection();
_conn.ConnectionString = res.ConnectionString;
_conn.Open();
res._config["DbSchema"] = res.Adapter.GetSchema(_conn);
if (Current == null)
{
Current = res;
}
return(res);
}
catch (Exception e)
{
#if DEBUG
DbConnectException dce = new DbConnectException(e, res._config);
Debug.WriteLine(dce);
throw dce;
#endif
return(null);
}
finally
{
try
{
_conn.Close();
}
catch { }
}
}
public void Get_by_name_uppercase_should_get_expected_value()
{
var list = new NameValueList {
new KeyValuePair<string, string>("name", "value")
};
Assert.That(list["NAME"], Is.EqualTo("value"));
}
public void Set_by_name_for_new_name_should_add_name_and_value_to_list()
{
var expectedList = new[] { new KeyValuePair<string, string>("name", "value") };
var list = new NameValueList();
list["name"] = "value";
Assert.That(list, Is.EqualTo(expectedList));
}
public static void Set(string name, Object data)
{
NameValueList config = OriData;
lock (Singleton)
{
config.Add(name, data);
}
}
public void Set_by_name_for_name_with_different_case_should_update_existing_value()
{
var expectedList = new[] { new KeyValuePair<string, string>("name", "second") };
var list = new NameValueList {
new KeyValuePair<string, string>("name", "first")
};
list["NAME"] = "second";
Assert.That(list, Is.EqualTo(expectedList));
}
public Command(string cmd, NameValueList pms)
{
if (string.IsNullOrEmpty(cmd))
cmd = "";
this._cmd = new StringBuilder(cmd);
this._pms = new NameValueList();
if (pms != null)
foreach (NameValue i in pms)
this._pms.Add(i.Name, i.Value);
this._dbprovider = Burst.Data.DbProvider.Current;
}
public Command(string cmd, params object[] pms)
{
if (string.IsNullOrEmpty(cmd))
cmd = "";
this._cmd = new StringBuilder(cmd);
this._pms = new NameValueList();
if (pms != null)
for (int i = 0; i < pms.Length; i++)
this._pms.Add("@" + i, pms[i]);
this._dbprovider = Burst.Data.DbProvider.Current;
}
/// <summary>
///
/// </summary>
/// <param name="e"></param>
public void UnloadControl(UnloadFinanceControlEventArgs e)
{
NameValueList settings = ctx.Settings.Get(this);
for (int i = 0; i < grid.Columns.Count; i++)
{
settings[string.Format("GridColumn{0}", i)] = grid.Columns[i].Width.ToString();
}
settings["ShowAll"] = checkBox1.Checked ? "true" : "false";
settings["FilterDate"] = dateTimePicker1.Value.Ticks.ToString();
}
/*
* public virtual void InitializeOwner(Transaction trans, params string[] fields)
* {
* bool all = false;
* if (fields.Length == 0)
* all = true;
* foreach (MemberInfo mi in OwnerFields)
* {
* if (all || mi.Name.In(fields))
* {
* DataOwnerFieldAttribute a = mi.GetAttribute<DataOwnerFieldAttribute>();
* SetValue(mi.Name, a.GetMethod(
* new Where(a.OwnedFieldName + "=@0", Key), null, null, trans));
* }
* }
* }
* protected virtual void InitializeAutoLoadFields(Transaction trans)
* {
* List<string> autoloadfields = new List<string>();
* foreach (MemberInfo mi in OwnerFields)
* {
* DataOwnerFieldAttribute a = mi.GetAttribute<DataOwnerFieldAttribute>();
* if (a.AutoLoad)
* autoloadfields.Add(mi.Name);
* }
* if (autoloadfields.Count > 0)
* InitializeOwner(trans, autoloadfields.ToArray());
* }
*/
protected virtual void InitializeOri(NameValueList nv, Transaction trans)
{
foreach (var fi in AllFields)
{
if (nv.ContainsKey(fi.Attribute.DbFieldName))
{
SetValue(fi.Attribute.DbFieldName, nv[fi.Attribute.DbFieldName]);
}
}
//InitializeAutoLoadFields(trans);
}
protected void SetByAppSettings(NameValueList Data, string Key, Object DefaultValue)
{
if (Data == null)
{
Data = OriData;
}
Data[Key] = ConfigurationManager.AppSettings[Key];
if (string.IsNullOrEmpty(Data.Get <string>(Key)))
{
Data[Key] = DefaultValue;
}
}
public static void Reload(Transaction trans, params string[] fields)
{
lock (Singleton)
{
if (_buf == null)
{
_buf = new NameValueList();
}
Command cmd = new Command(string.Format("select * from {0}", EnsuredTableName));
if (fields.Length > 0)
{
Builder.AppendWhere(
cmd,
new Compare(KeyFieldName, fields as object[]).ToWhere(),
KeyFieldName, DbProvider.Adapter
);
}
else
{
_buf.Clear();
}
NameValueList _old_buf = _buf;
_buf = new NameValueList();
(Singleton as DbConfiguration <T>).Initialize();
foreach (var i in _buf)
{
if (!_old_buf.ContainsKey(i.Name))
{
_old_buf.Add(i);
}
}
_buf = _old_buf;
NameValueList[] res = cmd.Execute(trans);
foreach (var nv in res)
{
try
{
_buf.Add(
nv.Get <string>(KeyFieldName),
Burst.Utils.DeserializeAs(
nv.Get <object>(ValueFieldName),
Type.GetType(nv.Get <string>(TypeFieldName)),
SerializeType
)
);
}
catch { }
}
}
}
public ActionResult InitializeUISettings()
{
NameValueList nvlSettings = _repository.GetGlobalVariables();
JsonContainer <NameValueList> container = new JsonContainer <NameValueList>();
container.items = nvlSettings;
container.success = true;
container.total = nvlSettings.Count;
return(Json(container, JsonRequestBehavior.AllowGet));
}
private void LoginDialog_Load(object sender, System.EventArgs e)
{
if (ctx == null)
{
return;
}
NameValueList settings = ctx.Settings.Get(this);
tbServer.Text = settings["Flygaretorpet.se_Server"];
tbEmail.Text = settings["Flygaretorpet.se_Email"];
tbPassword.Text = settings["Flygaretorpet.se_Password"];
checkBox1.Checked = !string.IsNullOrEmpty(tbServer.Text);
}
public static Tt Get <Tt>(string name)
{
NameValueList config = OriData;
lock (Singleton)
{
if (config[name] == null)
{
return(default(Tt));
}
return(Burst.Utils.DeserializeAs <Tt>(config[name]));
}
}
/// <summary>
/// 所需参数: Host, Database, Username, Password, ExtraConfiguration(NameValueList)。
/// </summary>
public virtual string BuildConnectionString(NameValueList pms)
{
string res = "";
if (pms.ContainsKey("Host"))
{
if (!string.IsNullOrEmpty(pms["Host"] as string))
{
res = string.Format("Server={0};", pms["Host"]);
}
}
if (pms.ContainsKey("Database"))
{
if (!string.IsNullOrEmpty(pms["Database"] as string))
{
res = string.Format("{0}Database={1};", res, pms["Database"]);
}
}
if (pms.ContainsKey("Username"))
{
if (!string.IsNullOrEmpty(pms["Username"] as string))
{
res = string.Format("{0}Uid={1};", res, pms["Username"]);
}
}
if (pms.ContainsKey("Password"))
{
if (!string.IsNullOrEmpty(pms["Password"] as string))
{
res = string.Format("{0}Pwd={1};", res, pms["Password"]);
}
}
if (pms.ContainsKey("Charset"))
{
if (!string.IsNullOrEmpty(pms["Charset"] as string))
{
res = string.Format("{0}Charset={1};", res, pms["Charset"]);
}
}
if (pms.ContainsKey("ExtraConfiguration"))
{
if (pms["ExtraConfiguration"] is NameValueList)
{
foreach (NameValue nv in pms["ExtraConfiguration"] as NameValueList)
{
res = string.Format("{0}{1}={2};", res, nv.Name, nv.Value);
}
}
}
return(res);
}
public void GetAppList(string scope)
{
try
{
NameValueList appList = _dtoProvider.GetAppList(scope);
HttpContext.Current.Response.ContentType = "application/xml";
HttpContext.Current.Response.Write(Utility.SerializeDataContract <NameValueList>(appList));
}
catch (Exception ex)
{
ExceptionHander(ex);
}
}
private void LoginDialog_FormClosing(object sender, FormClosingEventArgs e)
{
if (DialogResult != DialogResult.OK)
{
return;
}
if (string.IsNullOrEmpty(tbServer.Text.Trim()))
{
MessageBox.Show("Please enter a server");
e.Cancel = true;
return;
}
if (!tbServer.Text.Trim().Contains("."))
{
MessageBox.Show("Please enter a valid server...");
e.Cancel = true;
return;
}
if (tbServer.Text.Trim().Contains(":") || tbServer.Text.Trim().Contains("/") || tbServer.Text.Trim().Contains(" "))
{
MessageBox.Show("Server must be specified as \"server.domain\", without ports, protocols etc.");
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(tbEmail.Text.Trim()))
{
MessageBox.Show("Please enter an email");
e.Cancel = true;
return;
}
if (string.IsNullOrEmpty(tbPassword.Text.Trim()))
{
MessageBox.Show("Please enter a password");
e.Cancel = true;
return;
}
if (ctx != null)
{
if (checkBox1.Checked)
{
NameValueList settings = new NameValueList();
settings["Flygaretorpet.se_Server"] = tbServer.Text;
settings["Flygaretorpet.se_Email"] = tbEmail.Text;
settings["Flygaretorpet.se_Password"] = tbPassword.Text;
ctx.Settings.Set(this, settings);
return;
}
ctx.Settings.Set(this, new NameValueList());
}
}
public override string BuildConnectionString(NameValueList pms)
{
StringBuilder res = new StringBuilder("Provider=Microsoft.Jet.OLEDB.4.0;");
if (pms.ContainsKey("FilePath"))
if (!string.IsNullOrEmpty(pms["FilePath"] as string))
res.AppendFormat("Data Source={0};", Path.GetFullPath(pms["FilePath"] as string));
if (pms.ContainsKey("Password"))
if (!string.IsNullOrEmpty(pms["Password"] as string))
res.AppendFormat("Password={0};", pms["Password"]);
if (pms.ContainsKey("ExtraConfiguration"))
if (pms["ExtraConfiguration"] is NameValueList)
foreach (NameValue nv in pms["ExtraConfiguration"] as NameValueList)
res.AppendFormat("{0}={1};", nv.Name, nv.Value);
return res.ToString();
}
public NameValueList SaveFields()
{
var nvList = new NameValueList();
// Find all fields that are persistable, and record those of them that have non-null values
for (int idx = this.RepeaterIndex + 1; idx < this.EndingIndex; idx++)
{
var field = this.Form.Fields[idx];
if (field is SBSPersistableFormField && field.Value != null)
{
nvList.Add(new NameValuePair(field.Name, field.Value));
}
}
return(nvList);
}
/// <summary>
///
/// </summary>
private void FilterItems()
{
foreach (DataGridViewRow row in grid.Rows)
{
AccountTransaction trans = row.Tag as AccountTransaction;
if (trans == null)
{
continue;
}
row.Visible = checkBox1.Checked || (trans.Date.Year == dateTimePicker1.Value.Year && trans.Date.Month == dateTimePicker1.Value.Month);
}
NameValueList settings = ctx.Settings.Get(this);
settings["ShowAll"] = checkBox1.Checked ? "true" : "false";
settings["FilterDate"] = dateTimePicker1.Value.Ticks.ToString();
}
public void UnloadControl(UnloadFinanceControlEventArgs e)
{
if (ctx == null || ctx.TreeNode == null)
{
return;
}
NameValueList settings = ctx.Settings.Get(this);
settings["SelectedAccount"] = "";
if (ac != null)
{
ac.UnloadControl(e);
settings["SelectedAccount"] = ac.AccountID.ToString();
}
ctx.TreeNode.TreeView.AfterSelect -= TreeViewOnAfterSelect;
ctx.TreeNode.Nodes.Clear();
}
/// <summary>
/// 所需参数: Host, Database, Username, Password, ExtraConfiguration(NameValueList)。
/// </summary>
public virtual string BuildConnectionString(NameValueList pms)
{
string res = "";
if (pms.ContainsKey("Host"))
if (!string.IsNullOrEmpty(pms["Host"] as string))
res = string.Format("Data Source={0};", pms["Host"]);
if (pms.ContainsKey("Database"))
if (!string.IsNullOrEmpty(pms["Database"] as string))
res = string.Format("{0}Initial Catalog={1};", res, pms["Database"]);
if (pms.ContainsKey("Username"))
if (!string.IsNullOrEmpty(pms["Username"] as string))
res = string.Format("{0}User ID={1};", res, pms["Username"]);
if (pms.ContainsKey("Password"))
if (!string.IsNullOrEmpty(pms["Password"] as string))
res = string.Format("{0}Password={1};", res, pms["Password"]);
if (pms.ContainsKey("ExtraConfiguration"))
if (pms["ExtraConfiguration"] is NameValueList)
foreach (NameValue nv in pms["ExtraConfiguration"] as NameValueList)
res = string.Format("{0}{1}={2};", res, nv.Name, nv.Value);
return res;
}
public virtual Command GetReplaceCommand(string tableName, object key, string keyFieldName, NameValueList pms, DbProvider provider)
{
return null;
}
public virtual void InitializeOptions(NameValueList options)
{
options["DefaultDbProviderFactory"] = System.Data.SqlClient.SqlClientFactory.Instance;
}
private void LoginDialog_FormClosing( object sender, FormClosingEventArgs e )
{
if( DialogResult != DialogResult.OK ) {
return;
}
if( string.IsNullOrEmpty( tbServer.Text.Trim() ) ) {
MessageBox.Show( "Please enter a server" );
e.Cancel = true;
return;
}
if( !tbServer.Text.Trim().Contains( "." ) ) {
MessageBox.Show( "Please enter a valid server..." );
e.Cancel = true;
return;
}
if( tbServer.Text.Trim().Contains( ":" ) || tbServer.Text.Trim().Contains( "/" ) || tbServer.Text.Trim().Contains( " " ) ) {
MessageBox.Show( "Server must be specified as \"server.domain\", without ports, protocols etc." );
e.Cancel = true;
return;
}
if( string.IsNullOrEmpty( tbEmail.Text.Trim() ) ) {
MessageBox.Show( "Please enter an email" );
e.Cancel = true;
return;
}
if( string.IsNullOrEmpty( tbPassword.Text.Trim() ) ) {
MessageBox.Show( "Please enter a password" );
e.Cancel = true;
return;
}
if( ctx != null ) {
if( checkBox1.Checked ) {
NameValueList settings = new NameValueList();
settings[ "Flygaretorpet.se_Server" ] = tbServer.Text;
settings[ "Flygaretorpet.se_Email" ] = tbEmail.Text;
settings[ "Flygaretorpet.se_Password" ] = tbPassword.Text;
ctx.Settings.Set( this, settings );
return;
}
ctx.Settings.Set( this, new NameValueList());
}
}
public void SchemaTestMethod()
{
var pms = new NameValueList();
pms.Add("");
var schema = new DbSchema(DbProvider.Initialize(pms));
}
public override void InitializeOptions(NameValueList options)
{
options["DefaultDbProviderFactory"] = "System.Data.SQLite.SQLiteFactory, System.Data.SQLite, Version=1.0.76.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139";
}
public NameValueList[] Execute(Transaction trans)
{
DbConnection conn = null;
DbDataReader r = null;
bool err = false;
try
{
DbCommand cmd;
if (trans != null)
cmd = this.AsCommonCommand(trans.CurrentConnection.OriConnection, trans.CurrentTransaction);
else
{
conn = DbProvider.Current.CreateConnection();
conn.Open();
cmd = this.AsCommonCommand(conn, null);
}
r = cmd.ExecuteReader();
List<NameValueList> res = new List<NameValueList>();
List<string> keys = new List<string>();
while (r.Read())
{
NameValueList data = new NameValueList();
for (int i = 0; i < r.FieldCount; i++)
{
if (res.Count == 0)
keys.Add(r.GetName(i));
data.Add(keys[i], r.GetValue(i));
}
res.Add(data);
}
r.Close();
return res.ToArray();
}
catch (Exception e)
{
err = true;
if (trans != null)
trans.success = false;
#if DEBUG
CommandException ce = new CommandException("Execute", this, e);
Debug.WriteLine(ce);
throw ce;
#endif
return new NameValueList[] { };
}
finally
{
try
{
r.Close();
}
catch (Exception e)
{
if (trans != null)
trans.success = false;
#if DEBUG
if (!err)
{
CommandException ce = new CommandException("Execute", this, e);
Debug.WriteLine(ce);
throw ce;
}
#endif
}
try
{
if (trans == null)
conn.Close();
}
catch (Exception e)
{
if (trans != null)
trans.success = false;
#if DEBUG
if (!err)
{
CommandException ce = new CommandException("Execute", this, e);
Debug.WriteLine(ce);
throw ce;
}
#endif
}
}
}
public static void Generate(
IGenerator generator,
DTE DTE, GeneralProperty[] GeneralProperties,
bool OverwriteAll,
bool ToPascalName,
bool GenerateInitializer,
NameValueList InitializeParameters,
string Namespace
)
{
Project _project = Utils.GetProject(DTE);
ProjectItem pi = Utils.GetSelectedDirectory(DTE);
ProjectItems _currentDirectory = null;
string _path = null;
string _language = null;
string _fileExtension = null;
if (pi != null)
{
_currentDirectory = pi.ProjectItems;
_path = pi.Properties.Item("FullPath").Value.ToString();
}
else
{
_currentDirectory = _project.ProjectItems;
_path = _project.Properties.Item("FullPath").Value.ToString();
}
if (_project.CodeModel.Language == CodeModelLanguageConstants.vsCMLanguageCSharp)
{
_language = "CSharp";
_fileExtension = ".cs";
}
else if (_project.CodeModel.Language == CodeModelLanguageConstants.vsCMLanguageVB)
{
_language = "VisualBasic";
_fileExtension = ".vb";
}
//Generate
foreach (GeneralProperty gp in GeneralProperties)
{
if (string.IsNullOrWhiteSpace(gp.ClassName))
{
if (ToPascalName)
gp.ClassName = gp.TableName.ToPascalName();
else
gp.ClassName = gp.TableName;
}
foreach (GFieldInfo fieldinfo in gp.Fields)
if (string.IsNullOrWhiteSpace(fieldinfo.DisplayName))
{
if (ToPascalName)
fieldinfo.DisplayName = fieldinfo.Name.ToPascalName();
else
fieldinfo.DisplayName = fieldinfo.Name;
}
/*
foreach (OwnerFieldInfo ownerfieldinfo in gp.OwnerFields)
if (string.IsNullOrWhiteSpace(ownerfieldinfo.DisplayName))
{
if (ToPascalName)
ownerfieldinfo.DisplayName = ownerfieldinfo.Name.ToPascalName();
else
ownerfieldinfo.DisplayName = ownerfieldinfo.Name;
}
*/
ProjectItem _baseItem = null;
string basefile = Path.Combine(_path, gp.ClassName + _fileExtension);
if (OverwriteAll)
File.WriteAllText(basefile, generator.GenerateBaseFile(gp, Namespace, _language));
try
{
_baseItem = _currentDirectory.Item(Path.GetFileName(basefile));
}
catch
{
if (!OverwriteAll)
File.WriteAllText(basefile, generator.GenerateBaseFile(gp, Namespace, _language));
_baseItem = _currentDirectory.AddFromFile(basefile);
}
string fieldsfile = Path.Combine(_path, gp.ClassName + ".Fields" + _fileExtension);
File.WriteAllText(fieldsfile, generator.GenerateFieldsFile(gp, Namespace, _language));
try
{
_baseItem.ProjectItems.Item(Path.GetFileName(fieldsfile));
}
catch
{
_baseItem.ProjectItems.AddFromFile(fieldsfile);
}
/*
string ownerfieldsfile = Path.Combine(_path, gp.ClassName + ".OwnerFields" + _fileExtension);
if (OverwriteAll && File.Exists(ownerfieldsfile) || gp.OwnerFields.Count > 0)
{
File.WriteAllText(ownerfieldsfile, generator.GenerateOwnerFieldsFile(gp, Namespace, _language));
try
{
_baseItem.ProjectItems.Item(Path.GetFileName(ownerfieldsfile));
}
catch
{
_baseItem.ProjectItems.AddFromFile(ownerfieldsfile);
}
}
*/
}
if (GenerateInitializer)
{
var init_file = Path.Combine(_path, "DbInitializer" + _fileExtension);
File.WriteAllText(
init_file,
generator.GenerateInitializeFile(InitializeParameters, Namespace, _language)
);
try
{
_currentDirectory.Item(Path.GetFileName(init_file));
}
catch
{
_currentDirectory.AddFromFile(init_file);
}
}
}
public string GenerateInitializeFile(NameValueList Parameters, string Namespace, string Language)
{
CodeCompileUnit ccu = new CodeCompileUnit();
System.CodeDom.CodeNamespace cns = new System.CodeDom.CodeNamespace(Namespace);
cns.Imports.Add(new CodeNamespaceImport("System"));
cns.Imports.Add(new CodeNamespaceImport("Burst"));
cns.Imports.Add(new CodeNamespaceImport("Burst.Data"));
CodeTypeDeclaration model = new CodeTypeDeclaration("DbInitializer");
model.TypeAttributes = TypeAttributes.Public;
var init = new CodeMemberMethod();
init.Attributes = MemberAttributes.Static | MemberAttributes.Public;
init.Name = "InitializeDb";
init.ReturnType = new CodeTypeReference(typeof(bool));
init.Parameters.Add(new CodeParameterDeclarationExpression(typeof(bool), "InitializeEntities"));
init.Statements.Add(new CodeVariableDeclarationStatement(typeof(NameValueList), "__pms", new CodeObjectCreateExpression(typeof(Burst.NameValueList))));
foreach (var nv in Parameters)
{
CodeExpression value;
var _type = nv.Value.GetType();
if(_type.IsValueType || _type == typeof(string))
value = new CodePrimitiveExpression(nv.Value);
else
value = new CodeObjectCreateExpression(_type);
init.Statements.Add(new CodeExpressionStatement(new CodeMethodInvokeExpression(
new CodeVariableReferenceExpression("__pms"), "Add",
new CodePrimitiveExpression(nv.Name),
value
)));
}
init.Statements.Add(new CodeVariableDeclarationStatement(
typeof(Burst.Data.DbProvider),
"__provider",
new CodeMethodInvokeExpression(
new CodeTypeReferenceExpression(typeof(Burst.Data.DbProvider)),
"Initialize",
new CodeVariableReferenceExpression("__pms")
)
));
var init_entities = new List<CodeStatement>();
foreach (var c in Entities)
init_entities.Add(new CodeExpressionStatement(new CodeMethodInvokeExpression(
new CodeTypeReferenceExpression(c), "InitializeDbInfo"
)));
init.Statements.Add(new CodeConditionStatement(
new CodeBinaryOperatorExpression(
new CodeVariableReferenceExpression("__provider"),
CodeBinaryOperatorType.IdentityInequality,
new CodePrimitiveExpression(null)
),
new CodeStatement[] {
new CodeConditionStatement(
new CodeArgumentReferenceExpression("InitializeEntities"),
init_entities.ToArray()
),
new CodeMethodReturnStatement(new CodePrimitiveExpression(true))
},
new CodeStatement[] {
new CodeMethodReturnStatement(new CodePrimitiveExpression(false))
}
));
model.Members.Add(init);
cns.Types.Add(model);
ccu.Namespaces.Add(cns);
return _getString(ccu, Language);
}
public virtual Command GetReplaceCommand(string tableName, object key, string keyFieldName, NameValueList pms, DbProvider provider)
{
StringBuilder vs = new StringBuilder();
foreach (string s in pms.Keys)
vs.AppendFormat("{0},", s);
if (vs.Length > 0)
vs.Remove(vs.Length - 1, 1);
string cmd = string.Format("replace into {0} values ({1})", tableName, vs);
return provider.CreateCommand(cmd, pms);
}
public virtual void InitializeOptions(NameValueList options)
{
options["DefaultDbProviderFactory"] = "MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.3.6.0, Culture=neutral, PublicKeyToken=C5687FC88969C44D";
}
public override void InitializeOptions(NameValueList options)
{
options["DefaultDbProviderFactory"] = System.Data.OleDb.OleDbFactory.Instance;
}
public AdapterProperty()
{
pms = new NameValueList();
}
public void Get_by_name_should_return_null_if_not_found()
{
var list = new NameValueList();
Assert.That(list["invalid"], Is.Null);
}
