public void CreateTable_Test()
{
var tabInfo = new TableInfo("customer", "客户表");
tabInfo.AddColumnInfo("id", Common.DataManage.FormItemType.Number, "id", true, true);
tabInfo.AddColumnInfo("code", Common.DataManage.FormItemType.Text, "客户编号", false, false);
tabInfo.AddColumnInfo("name", Common.DataManage.FormItemType.Text, "客户名称", false, false);
tabInfo.AddColumnInfo("company", Common.DataManage.FormItemType.Text, "客户公司", false, false);
tabInfo.AddColumnInfo("sex", Common.DataManage.FormItemType.RadioButtonList, "客户性别", false, false);
string sql = tabInfo.GetColumnSql();
Console.WriteLine(sql);
}
public void Test_Add()
{
TableInfo tab = new TableInfo();
tab.Name = "pre_customers_demo";
tab.Type = 0;
tab.ParentId = 0;
tab.Desc = "客户信息表";
tab.AddColumnInfo("Id", "int", "自动编号", true, 1);
tab.AddColumnInfo("Name", "nvarchar(100)", "客户名称", true, 2);
tab.AddColumnInfo("Tel", "varchar(20)", "客户电话", true, 3);
tab.AddColumnInfo("Company", "nvarchar(100)", "所属公司", true, 4);
tab.AddColumnInfo("Email", "varchar(50)", "客户邮箱", false, 5);
ERP.DAL.ERPRepository repository = new DAL.ERPRepository();
repository.AddTableInfo(tab);
}
public void SaveTableInfo_Test()
{
var ci = GetContainer();
var uow = ci.Resolve <IUnitOfWork>();
ITableInfoRepository rep = ci.Resolve <ITableInfoRepository>();
var tabInfo = new TableInfo("customer", "客户表");
tabInfo.AddColumnInfo("id", Common.DataManage.FormItemType.Number, "id", true, true);
tabInfo.AddColumnInfo("code", Common.DataManage.FormItemType.Text, "客户编号", false, false);
tabInfo.AddColumnInfo("name", Common.DataManage.FormItemType.Text, "客户名称", false, false);
tabInfo.AddColumnInfo("company", Common.DataManage.FormItemType.Text, "客户公司", false, false);
tabInfo.AddColumnInfo("sex", Common.DataManage.FormItemType.RadioButtonList, "客户性别", false, false);
rep.Add(tabInfo);
uow.Commit();
}
private void AddTable()
{
bool tableExist = _tableInfoRepository.Exists(t => t.Name == Request.Name);
if (tableExist)
{
throw new MyFX.Core.Exceptions.AppServiceException(string.Format("名为[{0}]的表已存在", Request.Name));
}
var tabInfo = new TableInfo(Request.Name, Request.Desc);
foreach (var item in Request.ColumnInfos)
{
tabInfo.AddColumnInfo(item.Name, item.FormItemType, item.Desc, item.IsPrimaryKey, item.IsSystem, item.Sort);
}
_tableInfoRepository.Add(tabInfo);
_uow.Commit();
string createTableSql = GetCreateTableSql(tabInfo);
SqlHelper.ExecuteNonQuery(createTableSql);
}