/// <summary>
/// 生成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCreate_Click(object sender, EventArgs e)
{
string msg = _rm.GetString("BaseSqlTip");
try
{
//缓存数据库链接
if (string.IsNullOrWhiteSpace(this.txtdataSource.Text))
{
MessageBox.Show("请输入服务器名"); return;
}
HttpRuntime.Cache.Insert("dataSource", this.txtdataSource.Text);
if (string.IsNullOrWhiteSpace(this.txtdataCatalog.Text))
{
MessageBox.Show("请输入数据库名"); return;
}
HttpRuntime.Cache.Insert("dataCatalog", this.txtdataCatalog.Text);
if (string.IsNullOrWhiteSpace(this.txtuserName.Text))
{
MessageBox.Show("请输入数据库登录名"); return;
}
HttpRuntime.Cache.Insert("userName", this.txtuserName.Text);
if (string.IsNullOrWhiteSpace(this.txtuserPwd.Text))
{
MessageBox.Show("请输入数据库登录密码"); return;
}
HttpRuntime.Cache.Insert("userPwd", this.txtuserPwd.Text);
if (String.IsNullOrEmpty(txt_TableName.Text) || txt_TableName.Text.Trim() == string.Empty)
{
MessageBox.Show("请输入表名"); return;
}
if (string.IsNullOrWhiteSpace(this.txtInput.Text))
{
MessageBox.Show("请输入SQL"); return;
}
BaseSql.BaseSql sq = new BaseSql.BaseSql();
StringBuilder str = sq.BuilderCode(txtInput.Text, cbIsModel, txt_TableName.Text, ckb_Model.Checked, ckb_Insert.Checked, ckb_Update.Checked, ckb_Select.Checked, ckb_Delete.Checked, ckbExcel.Checked);
txtResult.Text = str.ToString();
Clipboard.SetDataObject(str.ToString());
}
catch (Exception ex)
{
msg = ex.Message;
}
labTip.Text = msg;
}
/// <summary>
/// 生成
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCreate_Click(object sender, EventArgs e)
{
string msg = _rm.GetString("BaseSqlTip");
try
{
BaseSql.BaseSql sq = new BaseSql.BaseSql();
StringBuilder str = sq.BuilderCode(txtInput.Text, cbIsModel, txt_TableName.Text, ckb_Model.Checked, ckb_Insert.Checked, ckb_Update.Checked, ckb_Select.Checked, ckb_Delete.Checked, ckbExcel.Checked);
txtResult.Text = str.ToString();
Clipboard.SetDataObject(str.ToString());
}
catch (Exception ex)
{
msg = ex.Message;
}
labTip.Text = msg;
}