public Object SaveResultDataTable(int titleId, string IdName, object IdValue, Dictionary <string, object> fieldAndValue)
{
if (IdValue.Equals(System.DBNull.Value) == true)//插入数据
{
string fields = "";
string values = "";
string strsql = "insert into {0} ({1}) values({2})";
foreach (KeyValuePair <string, object> val in fieldAndValue)
{
fields += (fields == "" ? "" : ",") + val.Key;
values += (values == "" ? "" : ",") + ConvertDBValue(val.Value);
}
BaseGeneralTitle title = NewObject <BaseGeneralTitle>().getmodel(titleId) as BaseGeneralTitle;
IdValue = oleDb.InsertRecord(string.Format(strsql, title.TableName, fields, values));
}
else//更新数据
{
string field_values = "";
string strsql = "update {0} set {1} where {2}";
foreach (KeyValuePair <string, object> val in fieldAndValue)
{
field_values += (field_values == "" ? "" : ",") + val.Key + "=" + ConvertDBValue(val.Value);
}
BaseGeneralTitle title = NewObject <BaseGeneralTitle>().getmodel(titleId) as BaseGeneralTitle;
oleDb.DoCommand(string.Format(strsql, title.TableName, field_values, IdName + "=" + ConvertDBValue(IdValue)));
}
return(IdValue);
}
public void DeleteResultDataTable(int titleId, string IdName, object IdValue)
{
if (IdValue.Equals(System.DBNull.Value) == false)
{
string strsql = "delete from {0} where {1}";
BaseGeneralTitle title = NewObject <BaseGeneralTitle>().getmodel(titleId) as BaseGeneralTitle;
oleDb.DoCommand(string.Format(strsql, title.TableName, IdName + "=" + ConvertDBValue(IdValue)));
}
}
public void AlterTitle(int titleId)
{
frmAddTable.loadTable(NewObject <GeneralTitle>().GetDbTables());
BaseGeneralTitle title = NewObject <BaseGeneralTitle>().getmodel(titleId) as BaseGeneralTitle;
frmAddTable.currTitle = title;
(frmAddTable as Form).Text = "修改表";
(frmAddTable as Form).ShowDialog();
}
public void NewTitle(int layerId)
{
frmAddTable.loadTable(NewObject <GeneralTitle>().GetDbTables());
BaseGeneralTitle title = NewObject <BaseGeneralTitle>();
title.LayerId = layerId;
frmAddTable.currTitle = title;
(frmAddTable as Form).Text = "添加表";
(frmAddTable as Form).ShowDialog();
}
public void LoadShowSearchResult(int titleId, string field, string value)
{
BaseGeneralTitle title = NewObject <BaseGeneralTitle>().getmodel(titleId) as BaseGeneralTitle;
//List<BaseGeneralField> fieldlist = NewObject<GeneralField>().GetFieldList(titleId);
string strsql = "";
if (field == "")
{
strsql = @"select * from {0}";
}
else
{
strsql = @"select * from {0} where {1} like '%{2}%'";
}
strsql = string.Format(strsql, title.TableName, field, value);
DataTable dt = oleDb.GetDataTable(strsql);
(iBaseView["frmShowGeneral"] as IfrmShowGeneral).resultGrid = dt;
}
//[AOP(typeof(AopTransaction))]
public void InitFields(int titleId)
{
BaseGeneralTitle title = NewObject <BaseGeneralTitle>().getmodel(titleId) as BaseGeneralTitle;
DataTable dt = NewDao <GeneralDao>().GetDbFields(title.TableName);
List <BaseGeneralField> fields = new List <BaseGeneralField>();
try
{
//先删除原来数据
NewDao <GeneralDao>().DeleteField(titleId);
//循环添加字段
for (int i = 0; i < dt.Rows.Count; i++)
{
BaseGeneralField field = NewObject <BaseGeneralField>();
field.FieldId = 0;
field.TitleId = titleId;
field.Name = dt.Rows[i]["remarks"] == DBNull.Value ? dt.Rows[i]["colname"].ToString() : dt.Rows[i]["remarks"].ToString();
field.ColName = dt.Rows[i]["colname"].ToString();
field.ColLength = Convert.ToInt32(dt.Rows[i]["length"]);
field.DataType = dt.Rows[i]["typename"].ToString();
field.UiType = 0;
field.DynamicSQL = "";
field.DataUnitId = "-1";
field.IsMust = dt.Rows[i]["nulls"].ToString() == "Y" ? 0 : 1;
field.MatchRegular = "";
field.SortOrder = i;
field.IsKey = dt.Rows[i]["_identity"].ToString() == "Y" ? 1 : 0;
field.save();
}
}
catch (Exception e)
{
throw e;
}
}
