public void SubmitForm(TableEntity entity, string f_Id)
{
if (!string.IsNullOrEmpty(f_Id))
{
entity.Modify(f_Id);
service.Update(entity);
}
else
{
entity.Create();
service.Insert(entity);
string strSql = "create table " + entity.SqlTableName + " (";
strSql += "[RowId] bigint primary key identity(1,1),"; //自增序列
strSql += "[F_Id] varchar(50),"; //唯一标识
strSql += "[F_CreatorTime] datetime,"; //允许新增（默认）
strSql += "[F_CreatorUserId] varchar(50),";
if ((bool)entity.AllowEdit)
{
strSql += "[F_LastModifyTime] datetime,"; //允许编辑
strSql += "[F_LastModifyUserId] varchar(50),";
}
if ((bool)entity.AllowDelete)
{
strSql += "[F_DeleteTime] datetime,"; //允许删除
strSql += "[F_DeleteUserId] varchar(50),";
strSql += "[F_DeleteMark] bit,";
}
strSql = (strSql.Trim(',') + ")");
DbHelper.ExecuteNonQuery(strSql);
}
}
public void SubmitForm(TableEntity entity, string id)
{
if (!string.IsNullOrEmpty(id))
{
entity.Modify(id);
service.Update(entity);
}
else
{
entity.Create();
service.Insert(entity);
string strSql = "create table " + entity.TableName + " (";
strSql += "[RowId] bigint primary key identity(1,1),"; //自增序列
strSql += "[Id] varchar(50),"; //唯一标识
strSql += "[CreatorUserId] varchar(50),"; //创建者
strSql += "[CreatorTime] datetime,";
strSql += "[LastModifyUserId] varchar(50),"; //修改者
strSql += "[LastModifyTime] datetime,";
strSql += "[CompanyId] varchar(50),"; //公司id
strSql += "[DepartmentId] varchar(50),"; //部门id
strSql = (strSql.Trim(',') + ")");
DbHelper.ExecuteNonQuery(strSql);
}
}
