public void SaveUdeftemplate(UdefTemplateItem udefTemplate)
{
var tran = mDBHelper.BeginTransaction();
try
{
if (mDBHelper.Exist(tran, string.Format("select 1 from _UdefTemplate where _tableName = '{0}' and _name ='{1}'", udefTemplate.tableName, udefTemplate.name)))
{
mDBHelper.ExecuteSql(tran,
string.Format("UPDATE [_UdefTemplate] SET [_label] = '{0}',[_dataType] = '{1}',[_tabIndex] = '{2}',[_defaultVal] = '{3}',[_reserved] = '{4}',[_tagLabel] = '{5}',[_width] = {6} WHERE [_tableName] = '{7}'and [_name] = '{8}'",
udefTemplate.label, udefTemplate.dataType, udefTemplate.tabIndex, udefTemplate.defaultVal, udefTemplate.reserved, udefTemplate.tagLabel, udefTemplate.width, udefTemplate.tableName, udefTemplate.name));
}
else
{
mDBHelper.ExecuteSql(tran,
string.Format("INSERT INTO [_UdefTemplate]([_tableName],[_name],[_label],[_dataType],[_tabIndex],[_defaultVal],[_reserved],[_tagLabel],[_width]) VALUES('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}',{8})",
udefTemplate.tableName, udefTemplate.name, udefTemplate.label, udefTemplate.dataType, udefTemplate.tabIndex, udefTemplate.defaultVal, udefTemplate.reserved, udefTemplate.tagLabel, udefTemplate.width));
}
mDBHelper.CommitTransaction(tran);
}
catch (Exception ex)
{
logger.Error(ex.ToString());
mDBHelper.RollbackTransaction(tran);
throw ex;
}
}
private void btn_Click(object sender, RoutedEventArgs e)
{
try
{
var txt = (sender as Button).Name;
switch (txt)
{
case "savenew":
if (NeedSave())
{
Save();
}
else
{
Console.WriteLine("don't change,no need save.");
}
_itemSource = new UdefTemplateItem();
_originItemSource = new UdefTemplateItem();
break;
case "save":
if (NeedSave())
{
Save();
}
else
{
Console.WriteLine("don't change,no need save.");
}
FinanceMessageBox.Info("保存成功");
Close();
break;
case "close":
case "exit":
if (NeedSave())
{
MessageBoxResult ret = FinanceMessageBox.Quest("修改了项目，需要进行保存吗？");
if (ret == MessageBoxResult.Yes)
{
Save();
}
else if (ret == MessageBoxResult.Cancel)
{
break;
}
}
Close();
break;
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
FinanceMessageBox.Error(ex.Message);
}
}
public UdefReportDataSet Query(string procName, Dictionary <string, object> filter)
{
try
{
DataSet ds = null;
if (filter == null)
{
ds = (DataSet)DBHelper.GetInstance(mContext).RunDataSetProc(procName);
}
else
{
var prams = new SqlParameter[filter.Keys.Count];
var i = 0;
foreach (var kv in filter)
{
prams[i++] = new SqlParameter(kv.Key, kv.Value);
}
ds = (DataSet)DBHelper.GetInstance(mContext).RunDataSetProc(procName, prams);
}
var dtHeader = ds.Tables[0];
var dtEntries = ds.Tables[1];
List <UdefTemplateItem> header = new List <UdefTemplateItem>();
foreach (DataColumn dc in dtHeader.Columns)
{
DataRow dr = dtHeader.Rows[0];
var item = new UdefTemplateItem
{
name = dc.ColumnName,
label = dr[dc.ColumnName].ToString()
};
header.Add(item);
}
foreach (DataColumn dc in dtEntries.Columns)
{
var item = header.FirstOrDefault(h => h.name == dc.ColumnName);
if (item != null)
{
if (dc.DataType == typeof(long) || dc.DataType == typeof(decimal) || dc.DataType == typeof(byte) ||
dc.DataType == typeof(sbyte) || dc.DataType == typeof(short) || dc.DataType == typeof(int) ||
dc.DataType == typeof(ushort) || dc.DataType == typeof(uint) || dc.DataType == typeof(ulong) ||
dc.DataType == typeof(float) || dc.DataType == typeof(double))
{
item.dataType = "number";
}
}
}
List <Dictionary <string, object> > entries = new List <Dictionary <string, object> >();
foreach (DataRow dr in dtEntries.Rows)
{
var dict = new Dictionary <string, object>();
foreach (DataColumn dc in dtHeader.Columns)
{
dict.Add(dc.ColumnName, dr[dc.ColumnName]);
}
entries.Add(dict);
}
return(new UdefReportDataSet {
header = header, entries = entries
});
}
catch (Exception ex)
{
logger.Error(ex.ToString());
}
return(null);
}
public void SaveUdefTemplate(UdefTemplateItem udefTemplate)
{
Execute(new UdefTemplateSaveRequest {
Content = udefTemplate
});
}
public void DeleteUdefTemplate(UdefTemplateItem udefTemplate)
{
Execute(new UdefTemplateDeleteRequest {
Content = udefTemplate
});
}
public void DeleteUdeftemplate(UdefTemplateItem udefTemplate)
{
mDBHelper.ExecuteSql(string.Format("delete from _UdefTemplate where _tableName = '{0}' and _name = '{1}'", udefTemplate.tableName, udefTemplate.name));
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
_originItemSource = JsonConvert.DeserializeObject <UdefTemplateItem>(JsonConvert.SerializeObject(_itemSource));
}
