private void tBtnGenConnStr_Click(object sender, EventArgs e)
{
if (skinLVConns.SelectedItems.Count > 0)
{
var a = skinLVConns.SelectedItems[0];
HA_Connection ha_conn = new HA_Connection
{
conn_name = a.SubItems[1].Text,
conn_IP = a.SubItems[2].Text,
conn_Account = a.SubItems[3].Text,
conn_Password = a.SubItems[4].Text,
conn_DBType = a.SubItems[5].Text,
conn_CType = a.SubItems[7].Text,
//conn_String = a.SubItems[7].Text,
conn_note = a.SubItems[9].Text,
conn_Alias = a.SubItems[6].Text
};
//代码重构点之一
string connString = SQLHelper.GetConnStr(ha_conn.conn_DBType, ha_conn.conn_IP,
ha_conn.conn_Alias, ha_conn.conn_Account,
ha_conn.conn_Password, 0);
txtConnStrGen.Text = connString;
}
labelConnStatus.Text = "";
}
private static HA_Connection ToModel(DataRow row)
{
HA_Connection model = new HA_Connection();
model.conn_id = row.IsNull("conn_id") ? null : (Int32?)row["conn_id"];
model.conn_name = row.IsNull("conn_name") ? null : (String)row["conn_name"];
model.conn_IP = row.IsNull("conn_IP") ? null : (String)row["conn_IP"];
model.conn_Account = row.IsNull("conn_Account") ? null : (String)row["conn_Account"];
model.conn_Password = row.IsNull("conn_Password") ? null : (String)row["conn_Password"];
model.conn_DBType = row.IsNull("conn_DBType") ? null : (String)row["conn_DBType"];
model.conn_Alias = row.IsNull("conn_Alias") ? null : (String)row["conn_Alias"];
model.conn_CType = row.IsNull("conn_CType") ? null : (String)row["conn_CType"];
model.conn_String = row.IsNull("conn_String") ? null : (String)row["conn_String"];
model.conn_note = row.IsNull("conn_note") ? null : (String)row["conn_note"];
return(model);
}
public HA_Connection GetModelById(int id)
{
string sqlStr = "select * from HA_Connection where conn_id=@id";
DataTable dt = SQLHelper.ExecuteDataTable(sqlStr, new SqlParameter("id", id));
if (dt.Rows.Count > 1)
{
throw new Exception("more than 1 row was found");
}
if (dt.Rows.Count <= 0)
{
return(null);
}
DataRow row = dt.Rows[0];
HA_Connection model = ToModel(row);
return(model);
}
public int AddNew(HA_Connection model)
{
string sqlStr = "insert into HA_Connection(conn_name,conn_IP,conn_Account,conn_Password,conn_DBType,conn_Alias,conn_CType,conn_String,conn_note) " +
"output inserted.conn_id values(@conn_name,@conn_IP,@conn_Account,@conn_Password,@conn_DBType,@conn_Alias,@conn_CType,@conn_String,@conn_note)";
int id = (int)SQLHelper.ExecuteScalar(sqlStr
, new SqlParameter("conn_name", model.conn_name)
, new SqlParameter("conn_IP", model.conn_IP)
, new SqlParameter("conn_Account", model.conn_Account)
, new SqlParameter("conn_Password", model.conn_Password)
, new SqlParameter("conn_DBType", model.conn_DBType)
, new SqlParameter("conn_Alias", model.conn_Alias)
, new SqlParameter("conn_CType", model.conn_CType)
, new SqlParameter("conn_String", model.conn_String)
, new SqlParameter("conn_note", model.conn_note)
);
return(id);
}
public bool Update(HA_Connection model)
{
string sqlStr = "update HA_Connection set conn_name=@conn_name,conn_IP=@conn_IP,conn_Account=@conn_Account," +
"conn_Password=@conn_Password,conn_DBType=@conn_DBType,conn_Alias=@conn_Alias,conn_CType=@conn_CType," +
"conn_String=@conn_String,conn_note=@conn_note where conn_name=@conn_name";
int rows = SQLHelper.ExecuteNonQuery(sqlStr
, new SqlParameter("conn_name", model.conn_name)
, new SqlParameter("conn_IP", model.conn_IP)
, new SqlParameter("conn_Account", model.conn_Account)
, new SqlParameter("conn_Password", model.conn_Password)
, new SqlParameter("conn_DBType", model.conn_DBType)
, new SqlParameter("conn_Alias", model.conn_Alias)
, new SqlParameter("conn_CType", model.conn_CType)
, new SqlParameter("conn_String", model.conn_String)
, new SqlParameter("conn_note", model.conn_note)
);
return(rows > 0);
}
private void btnSaveBackToConn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtConnStrGen.Text))
{
try
{
if (skinLVConns.SelectedItems.Count > 0)
{
labelConnStatus.Text = "";
var a = skinLVConns.SelectedItems[0];
HA_ConnectionDAL dal = new HA_ConnectionDAL();
HA_Connection ha_conn = new HA_Connection
{
conn_name = a.SubItems[1].Text,
conn_IP = a.SubItems[2].Text,
conn_Account = a.SubItems[3].Text,
conn_Password = a.SubItems[4].Text,
conn_DBType = a.SubItems[5].Text,
conn_Alias = a.SubItems[6].Text,
conn_CType = a.SubItems[7].Text,
conn_String = txtConnStrGen.Text,
conn_note = a.SubItems[9].Text
};
bool ret = dal.Update(ha_conn);
if (ret)
{
labelConnStatus.Text = "保存成功!";
ReloadConnection();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void skinLVConns_DoubleClick(object sender, EventArgs e)
{
if (skinLVConns.SelectedItems.Count > 0)
{
var a = skinLVConns.SelectedItems[0];
HA_Connection ha_conn = new HA_Connection
{
conn_name = a.SubItems[1].Text,
conn_IP = a.SubItems[2].Text,
conn_Account = a.SubItems[3].Text,
conn_Password = a.SubItems[4].Text,
conn_DBType = a.SubItems[5].Text,
conn_Alias = a.SubItems[6].Text,
conn_CType = a.SubItems[7].Text,
conn_String = a.SubItems[8].Text,
conn_note = a.SubItems[9].Text
};
FrmManageConn connForm = new FrmManageConn(ha_conn, a.SubItems[1].Text);
connForm.ShowDialog();
ReloadConnection();
}
}
public FrmManageConn(HA_Connection ha_c, string connName)
{
cobj = ha_c;
InitializeComponent();
txtConnName.Text = connName;
}
