private void btnUpdate_Click(object sender, EventArgs e)
{
if (!checkInput())
{
MessageBox.Show("请检查输入项", this.funName, MessageBoxButtons.OK);
return;
}
COLUMNS_INFO ci = new COLUMNS_INFO
{
CI_COLNAME = txtColName.Text.Trim().Replace(" ", string.Empty),
CI_ISVALID = true,
CI_MARK = txtMark.Text.Trim(),
CI_TYPEID = (short)cbxType.SelectedIndex,
CI_NAME = txtName.Text.Trim().Replace(" ", string.Empty),
};
db.COLUMNS_INFOs.InsertOnSubmit(ci);
db.SubmitChanges();
ColumnsDAL cd = new ColumnsDAL();
cd.OpenConnection(System.Configuration.ConfigurationManager.ConnectionStrings["TaxDemo.Properties.Settings.testdbConnectionString"].ConnectionString);
cd.InsertCol(ci);
cd.CloseConnection();
MessageBox.Show("添加成功", this.funName, MessageBoxButtons.OK);
loadCols();
}
/// <summary>
/// 增加列
/// </summary>
/// <param name="ci"></param>
public void InsertCol(COLUMNS_INFO ci)
{
string sql = string.Empty;
if (ci.CI_TYPEID == 0)
{
sql = string.Format("ALTER TABLE SALARY_IMPORT ADD {0} nvarchar(50) ", ci.CI_COLNAME); //MONEY ==> nvarchar(50)
}
else
{
sql = string.Format("ALTER TABLE SALARY_IMPORT ADD {0} nvarchar(50) ", ci.CI_COLNAME);
}
using (SqlCommand cmd = new SqlCommand(sql, this.sqlcn))
{
cmd.ExecuteNonQuery();
}
}
