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); } }