using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Windows.Forms;
|
|
namespace BLL
|
{
|
public partial class FrmAutoSQL : Form
|
{
|
public FrmAutoSQL()
|
{
|
InitializeComponent();
|
}
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
|
private void cmdOk_Click(object sender, EventArgs e)
|
{
|
|
|
|
}
|
|
|
public void GetBaseInsertSQL()
|
{
|
//
|
string SQLHead;
|
string SQLFiled;
|
string SQLValue;
|
//
|
SQLHead = "Insert Into " + txtHBaseTableName + " (";
|
//¸ù¾Ý±íÍ·ÕÒµ½ ËùÓÐ×Ö¶Î
|
DataSet ds;
|
ds=oCn.RunProcReturn("select a.name hname,a.length,b.name htypename From SysColumns a inner join " +
|
" systypes b on a.xtype=b.xtype Where ID=Object_Id('"+txtHBaseTableName.Text+"') " +
|
" order by a.name","SysColumns");
|
if (ds == null || ds.Tables[0].Rows.Count == 0)
|
{
|
MessageBox.Show("ÊäÈëµÄ±íÃû²»ÕýÈ·£¡");
|
return;
|
}
|
SQLFiled = "";
|
SQLValue = "";
|
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
|
{
|
//Æ´½Ó×Ö¶Î
|
SQLFiled = SQLFiled + "," + ds.Tables[0].Rows[i]["HName"].ToString();
|
//Æ´½Ó×Ö¶ÎÖµ
|
SQLValue = SQLValue + "," + GetStrByType(ds.Tables[0].Rows[i]["HName"].ToString(), ds.Tables[0].Rows[i]["htypename"].ToString());
|
|
}
|
}
|
|
public string GetStrByType(string HName,string HType)
|
{
|
return "";
|
//switch ( HType.ToLower())
|
//{
|
// case "int":
|
// case "smallint":
|
// return "oModel."+HName+".ToString()";
|
// break;
|
// case "":
|
// case "":
|
|
// break;
|
// default:
|
|
// break;
|
//}
|
}
|
}
|
}
|
