/// <summary>
/// 绑定存储过程列表
/// </summary>
private void BindProcedureList()
{
BLL.SQLServerFrame frame = new BLL.SQLServerFrame();
List <string> list = frame.GetProcedureList(BLL.Config.ConnectionString);
listBoxProcedure.DataSource = list;
}
/// <summary>
/// 生成存储过程代码
/// </summary>
/// <param name="procedureName"></param>
public void CreateCode(string procedureName)
{
BLL.Build.BuildProcedure builder = new BLL.Build.BuildProcedure();
BLL.SQLServerFrame frame = new BLL.SQLServerFrame();
List <BLL.ProcedureParameter> list = frame.GetParameterOfProcedure(BLL.Config.ConnectionString, procedureName);
string txt = builder.BuildCode_Procedure(procedureName, list);
richCode.Text = txt;
}
/// <summary>
/// 绑定表名列表
/// </summary>
private void BindTableList()
{
BLL.SQLServerFrame frame = new BLL.SQLServerFrame();
string strConnection = BLL.Config.ConnectionString;
DataTable dt = frame.GetTables(strConnection);
List <string> list = new List <string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
list.Add(dt.Rows[i]["table_name"].ToString());
}
list.Sort();
list.Insert(0, "");
cbbTableList.DataSource = list;
//DataView dv = new DataView(dt);
//dv.Sort = "table_name";
//cbbTableList.DisplayMember = "table_name";
//cbbTableList.ValueMember = "table_name";
//cbbTableList.DataSource = dv;
}
//下拉列表选项改变时
private void cbbTableList_SelectedIndexChanged(object sender, EventArgs e)
{
//选空数据跳过
if (cbbTableList.SelectedValue.ToString() == "")
{
return;
}
string tableName = cbbTableList.SelectedValue.ToString();
selectTableName = tableName;
BLL.SQLServerFrame frame = new BLL.SQLServerFrame();
string strConnection = BLL.Config.ConnectionString;
DataSet ds = frame.GetColumnField2(strConnection, tableName);
DataTable dt = ds.Tables[0];
List <Column> list = new List <Column>();
foreach (DataRow dr in dt.Rows)
{
list.Add(new Column {
Name = dr[0].ToString(), Type = dr[1].ToString(), Key = false, AddColumn = true, UpdateColumn = true
});
}
list[0].Key = true; //默认第一个字段为主键
list[0].UpdateColumn = false; //默认主键不修改
if (checkIdentity.Checked) //主键自增
{
list[0].AddColumn = false;
list[0].UpdateColumn = false;
}
dataGridView1.DataSource = list;
}
