private void GetCode(string tableName)
{
string getfiled = sqltype == 2 ? "select * from `" + tableName + "` LIMIT 0" : "select top 0 * from [" + tableName + "]";
DataTable dt = ExecuteDataTable(getfiled);
CreateCodeHelper helper = new CreateCodeHelper();
string strDAL = cbDAL.SelectedItem.ToString();
StringBuilder sb = new StringBuilder();
switch (strDAL)
{
case "All DAL":
{
dalstr = helper.CreateDALCode(tableName, dt);
break;
}
case "ListAll()":
{
helper.CreateListAll(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "DeleteById()":
{
helper.CreateDeleteById(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "GetById()":
{
helper.CreateGetById(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "Insert()":
{
helper.CreateInsert(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "Update()":
{
helper.CreateUpdate(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "ListByWhere()":
{
helper.CreateListByWhere(tableName, sb, "");
dalstr = sb;
break;
}
case "ListByPage()":
{
helper.CreateListByPage(tableName, dt, sb, "");
dalstr = sb;
break;
}
default:
{
dalstr = sb;
break;
}
}
}
private void GetCode(string tableName)
{
string getfiled = sqltype == 2 ? "select * from `" + tableName + "` LIMIT 0" : "select top 0 * from [" + tableName + "]";
DataTable dt = ExecuteDataTable(getfiled);
CreateCodeHelper helper = new CreateCodeHelper();
string strDAL = cbDAL.SelectedItem.ToString();
StringBuilder sb = new StringBuilder();
switch (strDAL)
{
case "All DAL":
{
dalstr = helper.CreateDALCode(tableName, dt);
break;
}
case "ListAll()":
{
helper.CreateListAll(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "DeleteById()":
{
helper.CreateDeleteById(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "GetById()":
{
helper.CreateGetById(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "Insert()":
{
helper.CreateInsert(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "Update()":
{
helper.CreateUpdate(tableName, dt, sb, "");
dalstr = sb;
break;
}
case "ListByWhere()":
{
helper.CreateListByWhere(tableName, sb, "");
dalstr = sb;
break;
}
case "ListByPage()":
{
helper.CreateListByPage(tableName, dt, sb, "");
dalstr = sb;
break;
}
default:
{
dalstr = sb;
break;
}
}
}
