/// <summary>
/// 修改数据库
/// </summary>
/// <param name="sql"></param>
/// <param name="tb"></param>
private void databaseupdate(string sql, DataTable tb)
{
//数据更行到数据库
System.Data.SqlClient.SqlConnection connect = new System.Data.SqlClient.SqlConnection();
connect.ConnectionString = FrmMdiMain.Database.ConnectionString;// " server=x6x8-20100320QL\\SQLEXPRESS;database=trasen_Emr_test;UID=sa;Password=sa8920993";
connect.Open();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new System.Data.SqlClient.SqlCommand(sql, connect);
System.Data.SqlClient.SqlCommandBuilder sqlcom = new System.Data.SqlClient.SqlCommandBuilder(adapter);
//DataTable newtb = new DataTable();
// newtb.TableName = "tb";
DataSet ds = new DataSet();
adapter.TableMappings[0].ColumnMappings.Add("", "");
adapter.TableMappings.Add("df", "fdf");
adapter.Fill(ds);
//ds.Tables[0].Rows[2]["note"] = "开户银行2";
ds.Tables[1].Rows[0]["bbid"] = 1;
adapter.InsertCommand = sqlcom.GetInsertCommand();
adapter.DeleteCommand = sqlcom.GetDeleteCommand();
adapter.UpdateCommand = sqlcom.GetUpdateCommand();
int i = adapter.Update(ds);
tb.AcceptChanges();
sqlcom.RefreshSchema();
connect.Close();
}
/// <summary>
/// 修改数据库
/// </summary>
/// <param name="sql"></param>
/// <param name="tb"></param>
public static void databaseupdate(string sql, DataTable tb)
{
//数据更行到数据库
System.Data.SqlClient.SqlConnection connect = new System.Data.SqlClient.SqlConnection();
connect.ConnectionString = FrmMdiMain.Database.ConnectionString;// " server=x6x8-20100320QL\\SQLEXPRESS;database=trasen_Emr_test;UID=sa;Password=sa8920993";
connect.Open();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new System.Data.SqlClient.SqlCommand(sql, connect);
System.Data.SqlClient.SqlCommandBuilder sqlcom = new System.Data.SqlClient.SqlCommandBuilder(adapter);
//DataSet ds = new DataSet();
//System.Data.SqlClient.SqlTransaction sqltra = connect.BeginTransaction();
//adapter.TableMappings[0].ColumnMappings.Add("", "");
// adapter.TableMappings.Add("df", "fdf");
//adapter.Fill(ds);
//ds.Tables[0].Rows[2]["note"] = "开户银行2";
//ds.Tables[1].Rows[0]["bbid"] = 1;
//tb.PrimaryKey = new DataColumn[] { tb.Columns["Bsid"] };
//tb.Rows[0]["reason"] = "1";
//tb.Rows[1]["reason"] = "1";
//tb.Rows[2]["reason"] = "1";
//tb.Columns["Bsid"].ColumnName = "path_step_item_id";
//tb.Columns["Parent_id"].ColumnName = "step_item_kind_id";
//tb.Columns["order_spec"].ColumnName = "notes";
DataTable tbnew = tb.GetChanges(DataRowState.Modified);
DataTable tbdel = tb.GetChanges(DataRowState.Deleted);
adapter.InsertCommand = sqlcom.GetInsertCommand();
adapter.DeleteCommand = sqlcom.GetDeleteCommand();
adapter.UpdateCommand = sqlcom.GetUpdateCommand();
int i = 0;
if (tb.GetChanges() != null)
{
i = adapter.Update(tb);
}
tb.AcceptChanges();
sqlcom.RefreshSchema();
//tb.Columns["path_step_item_id"].ColumnName = "Bsid";
//tb.Columns["step_item_kind_id"].ColumnName = "Parent_id";
//tb.Columns["notes"].ColumnName = "order_spec";
// sqltra.Commit();
connect.Close();
}
/// <summary>
/// 修改数据库
/// </summary>
/// <param name="sql"></param>
/// <param name="tb"></param>
private void databaseupdate(string sql, DataTable tb)
{
//数据更行到数据库
System.Data.SqlClient.SqlConnection connect = new System.Data.SqlClient.SqlConnection();
connect.ConnectionString = TrasenFrame.Forms.FrmMdiMain.Database.ConnectionString;// " server=x6x8-20100320QL\\SQLEXPRESS;database=trasen_Emr_test;UID=sa;Password=sa8920993";
connect.Open();
System.Data.SqlClient.SqlDataAdapter adapter = new System.Data.SqlClient.SqlDataAdapter();
adapter.SelectCommand = new System.Data.SqlClient.SqlCommand(sql, connect);
System.Data.SqlClient.SqlCommandBuilder sqlcom = new System.Data.SqlClient.SqlCommandBuilder(adapter);
DataTable newtb = new DataTable();
newtb.TableName = "tb";
adapter.Fill(newtb);
adapter.InsertCommand = sqlcom.GetInsertCommand();
adapter.DeleteCommand = sqlcom.GetDeleteCommand();
adapter.UpdateCommand = sqlcom.GetUpdateCommand();
int i = adapter.Update(tb);
tb.AcceptChanges();
sqlcom.RefreshSchema();
connect.Close();
}
protected override void SetCommandSelect(string strTable, System.Collections.ArrayList arlCondicaoCampo, System.Collections.ArrayList arlCondicaoComparador, System.Collections.ArrayList arlCondicaoValor, System.Collections.ArrayList arlOrdenacaoCampo, System.Collections.ArrayList arlOrdenacaoTipo)
{
string strSQL = "SELECT * FROM " + strTable + " ";
// Condicoes
if ((arlCondicaoCampo != null) && (arlCondicaoValor != null) && (arlCondicaoComparador != null) && (arlCondicaoCampo.Count == arlCondicaoComparador.Count) && (arlCondicaoCampo.Count == arlCondicaoValor.Count) && (arlCondicaoValor.Count > 0))
{
strSQL += " WHERE ";
for (int nCont = 0; nCont < arlCondicaoCampo.Count; nCont++)
{
strSQL += " ( " + arlCondicaoCampo[nCont].ToString();
switch ((mdlDataBaseAccess.Comparador)arlCondicaoComparador[nCont])
{
case mdlDataBaseAccess.Comparador.Igual:
strSQL += " = ";
break;
case mdlDataBaseAccess.Comparador.Diferente:
strSQL += " <> ";
break;
case mdlDataBaseAccess.Comparador.Menor:
strSQL += " < ";
break;
case mdlDataBaseAccess.Comparador.Maior:
strSQL += " > ";
break;
case mdlDataBaseAccess.Comparador.MenorOuIgual:
strSQL += " <= ";
break;
case mdlDataBaseAccess.Comparador.MaiorOuIgual:
strSQL += " >= ";
break;
default:
strSQL += " = ";
break;
}
if (arlCondicaoValor[nCont].GetType().ToString() == "System.String")
{
strSQL += " '" + arlCondicaoValor[nCont].ToString() + "' ) ";
}
else
{
strSQL += arlCondicaoValor[nCont].ToString() + " ) ";
}
if ((nCont + 1) < arlCondicaoCampo.Count)
{
strSQL += " AND ";
}
}
}
// Ordem
if ((arlOrdenacaoCampo != null) && (arlOrdenacaoTipo != null) && (arlOrdenacaoCampo.Count > 0) && (arlOrdenacaoTipo.Count > 0) && (arlOrdenacaoCampo.Count == arlOrdenacaoTipo.Count))
{
strSQL += " ORDER BY ";
for (int nCont = 0; nCont < arlOrdenacaoCampo.Count; nCont++)
{
strSQL += " " + arlOrdenacaoCampo[nCont].ToString() + " ";
switch ((mdlDataBaseAccess.TipoOrdenacao)arlOrdenacaoTipo[nCont])
{
case mdlDataBaseAccess.TipoOrdenacao.Crescente:
break;
case mdlDataBaseAccess.TipoOrdenacao.Decrestente:
strSQL += " DESC ";
break;
}
if ((nCont + 1) < arlOrdenacaoCampo.Count)
{
strSQL += " , ";
}
}
}
m_CommandSelect.CommandText = strSQL;
m_CommandBuilder.RefreshSchema();
}