//*/ public int Update(string TableName) { new OleDbCommandBuilder(adapter); return(adapter.Update(dataset, TableName)); }
//************************************************************************** /// <Description> /// This method uses to update a DataSet /// </Description> /// <Inputs> /// DataSet /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// HungLa /// </Authors> /// <History> /// Monday, December 27, 2004 /// </History> /// <Notes> /// </Notes> //************************************************************************** public void UpdateDataSet(DataSet pData) { const string METHOD_NAME = THIS + ".UpdateDataSet()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + sys_TableGroupTable.TABLEGROUPID_FLD + "," + sys_TableGroupTable.CODE_FLD + "," + sys_TableGroupTable.TABLEGROUPNAME_FLD + "," + sys_TableGroupTable.GROUPORDER_FLD; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); pData.EnforceConstraints = false; odadPCS.Update(pData, sys_TableGroupTable.TABLE_NAME); } catch (OleDbException ex) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
// Sauvegarde tous les changements effectué dans le dataset public void SaveDataSet(string tableName, DataSet dataSet) { if (dataSet.HasChanges() == false) { return; } switch (connType) { case ConnectionType.DATABASE_MSSQL: { try { var conn = new SqlConnection(connString); var adapter = new SqlDataAdapter("SELECT * from " + tableName, conn); var builder = new SqlCommandBuilder(adapter); adapter.DeleteCommand = builder.GetDeleteCommand(); adapter.UpdateCommand = builder.GetUpdateCommand(); adapter.InsertCommand = builder.GetInsertCommand(); lock (dataSet) // lock dataset to prevent changes to it { adapter.ContinueUpdateOnError = true; DataSet changes = dataSet.GetChanges(); adapter.Update(changes, tableName); PrintDatasetErrors(changes); dataSet.AcceptChanges(); } conn.Close(); } catch (Exception ex) { throw new DatabaseException("Can not save table " + tableName, ex); } break; } case ConnectionType.DATABASE_ODBC: { try { var conn = new OdbcConnection(connString); var adapter = new OdbcDataAdapter("SELECT * from " + tableName, conn); var builder = new OdbcCommandBuilder(adapter); adapter.DeleteCommand = builder.GetDeleteCommand(); adapter.UpdateCommand = builder.GetUpdateCommand(); adapter.InsertCommand = builder.GetInsertCommand(); DataSet changes; lock (dataSet) // lock dataset to prevent changes to it { adapter.ContinueUpdateOnError = true; changes = dataSet.GetChanges(); adapter.Update(changes, tableName); dataSet.AcceptChanges(); } PrintDatasetErrors(changes); conn.Close(); } catch (Exception ex) { throw new DatabaseException("Can not save table ", ex); } break; } case ConnectionType.DATABASE_MYSQL: { return; } case ConnectionType.DATABASE_OLEDB: { try { var conn = new OleDbConnection(connString); var adapter = new OleDbDataAdapter("SELECT * from " + tableName, conn); var builder = new OleDbCommandBuilder(adapter); adapter.DeleteCommand = builder.GetDeleteCommand(); adapter.UpdateCommand = builder.GetUpdateCommand(); adapter.InsertCommand = builder.GetInsertCommand(); DataSet changes; lock (dataSet) // lock dataset to prevent changes to it { adapter.ContinueUpdateOnError = true; changes = dataSet.GetChanges(); adapter.Update(changes, tableName); dataSet.AcceptChanges(); } PrintDatasetErrors(changes); conn.Close(); } catch (Exception ex) { throw new DatabaseException("Can not save table", ex); } break; } } }
//************************************************************************** /// <Description> /// This method uses to update a DataSet /// </Description> /// <Inputs> /// DataSet /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// HungLa /// </Authors> /// <History> /// Tuesday, February 07, 2006 /// </History> /// <Notes> /// </Notes> //************************************************************************** public void SaveDeliveryHour(DataTable pdtbData) { const string METHOD_NAME = THIS + ".SaveDeliveryHour()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + PO_VendorDeliveryScheduleTable.VENDORDELIVERYSCHEDULE_FLD + "," + PO_VendorDeliveryScheduleTable.PARTYID_FLD + "," + PO_VendorDeliveryScheduleTable.CCNID_FLD + "," + PO_VendorDeliveryScheduleTable.DELIVERYTYPE_FLD + "," + PO_VendorDeliveryScheduleTable.DELHOUR_FLD + "," + PO_VendorDeliveryScheduleTable.WEEKLYDAY_FLD + "," + PO_VendorDeliveryScheduleTable.MONTHLYDATE_FLD + "," + PO_VendorDeliveryScheduleTable.COMMENT_FLD + "," + PO_VendorDeliveryScheduleTable.DELMIN_FLD + "," + PO_VendorDeliveryScheduleTable.PRODUCTID_FLD + " FROM " + PO_VendorDeliveryScheduleTable.TABLE_NAME; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); odadPCS.Update(pdtbData); } catch (OleDbException ex) { if (ex.Errors.Count > 1) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
private void UpdateDB() { OleDbCommandBuilder cm = new OleDbCommandBuilder(da); da.Update(dt); }
// override the 'Save uploaded file' method protected override string SaveUploadedFile(string folder, string name, string title, Stream stream) { Regex regex = new Regex("^" + DatabaseProtocol, RegexOptions.Compiled); if (!regex.IsMatch(folder)) // it is the 'file system' gallery command { // call the base method return(base.SaveUploadedFile(folder, name, title, stream)); } string url = regex.Replace(folder, ""); OleDbConnection connection = new OleDbConnection(); try { connection.ConnectionString = ConnectionString; connection.Open(); int folderId = findFolderId(connection, url); if (folderId >= 0) { string sqlString = "Select * from tbImage Where fldFolderId=" + folderId.ToString() + " AND fldName=\"" + name + "\""; OleDbDataAdapter eAdapter = new OleDbDataAdapter(sqlString, connection); DataTable eTable = new DataTable(); eAdapter.Fill(eTable); // Delete the duplicate if it is present if (eTable.Rows.Count > 0) { OleDbCommand myComm = new OleDbCommand("DELETE FROM tbImage Where fldFolderId=" + folderId.ToString() + " AND fldName=\"" + name + "\"", connection); myComm.ExecuteNonQuery(); } eAdapter.Dispose(); eTable.Dispose(); sqlString = "Select * from tbImage Where fldFolderId=" + folderId.ToString(); eAdapter = new OleDbDataAdapter(sqlString, connection); eTable = new DataTable(); eAdapter.Fill(eTable); OleDbCommand cmdInsert = new OleDbCommand("INSERT INTO tbImage (fldName, fldFolderId, fldDescription, fldContent) VALUES(?, ?, ?, ?)", connection); cmdInsert.Parameters.Add(new OleDbParameter("fldName", OleDbType.VarChar, 50, "fldName")); cmdInsert.Parameters.Add(new OleDbParameter("fldFolderId", OleDbType.Integer, 0, "fldFolderId")); cmdInsert.Parameters.Add(new OleDbParameter("fldDescription", OleDbType.VarChar, 100, "fldDescription")); cmdInsert.Parameters.Add(new OleDbParameter("fldContent", OleDbType.Binary, 0, "fldContent")); eAdapter.InsertCommand = cmdInsert; DataRow newRow = eTable.NewRow(); newRow["fldName"] = name; newRow["fldFolderId"] = folderId; newRow["fldDescription"] = title; byte[] content = new byte[stream.Length]; stream.Read(content, 0, (int)stream.Length); newRow["fldContent"] = content; eTable.Rows.Add(newRow); eAdapter.Update(eTable); // Release the Resources cmdInsert = null; eAdapter.Dispose(); eTable.Dispose(); } } finally { connection.Close(); connection.Dispose(); } return(name); }
public void Save() { string dstrSQL; DataTable dDT; string dstrName = ""; try { File.Copy(Application.StartupPath + @"\system\System.mdb", Application.StartupPath + @"\system\System.mdb.bak", true); if (!DBAct.clsDBAct.funBeginTransaction()) { MessageBox.Show("DB Transaction NG!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //DataAdapter 생성 OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM tbUser order by UserLevel", DBAct.clsDBAct.funOleDbConnect()); OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter); //DataAdapter를 이용하여 DB로 업데이트를 한다. dataAdapter.SelectCommand.Transaction = DBAct.clsDBAct.funOleDbTransaction(); dataAdapter.Update((DataTable)pUserBindingSource.DataSource); if (!DBAct.clsDBAct.funCommitTransaction()) { MessageBox.Show("DB Commit Transaction NG!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); DBAct.clsDBAct.funRollbackTransaction(); return; } //DB에 저장이 성공적으로 완료되면 다시 DB에서 Data를 로딩한다. //구조체의 내용 갱신 pInfo.Unit(0).SubUnit(0).RemoveUser(); //DB로부터 User 정보를 읽어들여 저장한다. dstrSQL = "SELECT * FROM tbUser order by UserLevel"; dDT = DBAct.clsDBAct.funSelectQuery2(dstrSQL); //DataTable을 받아온다. if (dDT != null) { pInfo.DeleteTable("USER"); pInfo.AddDataTable("USER", dDT); foreach (DataRow dr in dDT.Rows) { dstrName = dr["UserID"].ToString(); pInfo.Unit(0).SubUnit(0).AddUser(dstrName); pInfo.Unit(0).SubUnit(0).User(dstrName).Level = Convert.ToInt32(dr["UserLevel"].ToString()); pInfo.Unit(0).SubUnit(0).User(dstrName).PassWord = dr["Pass"].ToString(); pInfo.Unit(0).SubUnit(0).User(dstrName).Desc = dr["Description"].ToString(); } } //DBAct.clsDBAct.funDisconnect(); // DB 연결을 끊는다. subSaveLastModified(); //최종 수정된 날짜를 Ini파일에 저장한다. MessageBox.Show("Data Save Success!", "Jobs Complete", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { pInfo.subLog_Set(InfoAct.clsInfo.LogType.CIM, ex.ToString()); DBAct.clsDBAct.funRollbackTransaction(); DBAct.clsDBAct.funDisconnect(); // DB 연결을 끊는다. MessageBox.Show("DB Update Fail, Because DB Process Error!", "DB Update Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void BtnPrint_Click(object sender, EventArgs e) { if (c标签模板.SelectedIndex < 0) { MessageBox.Show("请选择一个模板再打印"); return; } // 判断,如果数据库有存过一张标签,则不管,否则保存一张标签 string sql = "select * from 标签 where 生产指令='{0}'"; System.Data.DataTable dt = new System.Data.DataTable(); if (!mySystem.Parameter.isSqlOk) { OleDbDataAdapter da = new OleDbDataAdapter(String.Format(sql, _s), mySystem.Parameter.connOle); OleDbCommandBuilder cb = new OleDbCommandBuilder(da); da.Fill(dt); if (dt.Rows.Count == 0) { DataRow dr = dt.NewRow(); dr["生产指令ID"] = mySystem.Parameter.proInstruID; dr["生产指令"] = _s; dr["标签类型"] = c标签模板.SelectedIndex; dr["膜代码"] = cmb膜代码.SelectedItem; dr["批号中文"] = tc批号.Text; dr["数量米"] = tc数量米.Text; dr["数量千克"] = tc数量KG.Text; dr["日期中文"] = dc日期.Value; dr["班次中文"] = (cc班次.SelectedItem.ToString() == "白班" ? "白班" : "夜班"); dr["产品名称中文"] = tc产品名称.Text; dr["产品编码中文"] = tc产品编码.Text; dr["产品规格中文"] = tc产品规格.Text; dr["产品批号中文"] = tc产品批号.Text; dr["生产日期中文"] = dc生产日期.Value; dr["有效期至中文"] = dc有效期至.Value; dr["数量中文"] = tc数量.Text; dr["包装序号中文"] = tc包装序号.Text; dr["注册证号中文"] = tc注册证号.Text; dr["毛重中文"] = tc毛重.Text; dr["箱体规格中文"] = tc箱体规格.Text; dr["Name_E"] = teName.Text; dr["Code_E"] = teCode.Text; dr["Size_E"] = teSize.Text; dr["Batch_E"] = teBatch.Text; dr["Mfg_E"] = deMfg.Value; dr["Expiry_E"] = deExpiry.Value; dr["Quantity_E"] = teQuantity.Text; dr["Pack_E"] = tePack.Text; dr["CFDA_E"] = teCFDA.Text; dr["Gross_E"] = teGross.Text; dr["Carton_E"] = teCarton.Text; dt.Rows.Add(dr); da.Update(dt); } } else { SqlDataAdapter da = new SqlDataAdapter(String.Format(sql, _s), mySystem.Parameter.conn); SqlCommandBuilder cb = new SqlCommandBuilder(da); da.Fill(dt); if (dt.Rows.Count == 0) { DataRow dr = dt.NewRow(); dr["生产指令ID"] = mySystem.Parameter.proInstruID; dr["生产指令"] = _s; dr["标签类型"] = c标签模板.SelectedIndex; dr["膜代码"] = cmb膜代码.SelectedItem; dr["批号中文"] = tc批号.Text; dr["数量米"] = tc数量米.Text; dr["数量千克"] = tc数量KG.Text; dr["日期中文"] = dc日期.Value; dr["班次中文"] = (cc班次.SelectedItem.ToString() == "白班" ? "白班" : "夜班"); dr["产品名称中文"] = tc产品名称.Text; dr["产品编码中文"] = tc产品编码.Text; dr["产品规格中文"] = tc产品规格.Text; dr["产品批号中文"] = tc产品批号.Text; dr["生产日期中文"] = dc生产日期.Value; dr["有效期至中文"] = dc有效期至.Value; dr["数量中文"] = tc数量.Text; dr["包装序号中文"] = tc包装序号.Text; dr["注册证号中文"] = tc注册证号.Text; dr["毛重中文"] = tc毛重.Text; dr["箱体规格中文"] = tc箱体规格.Text; dr["Name_E"] = teName.Text; dr["Code_E"] = teCode.Text; dr["Size_E"] = teSize.Text; dr["Batch_E"] = teBatch.Text; dr["Mfg_E"] = deMfg.Value; dr["Expiry_E"] = deExpiry.Value; dr["Quantity_E"] = teQuantity.Text; dr["Pack_E"] = tePack.Text; dr["CFDA_E"] = teCFDA.Text; dr["Gross_E"] = teGross.Text; dr["Carton_E"] = teCarton.Text; dt.Rows.Add(dr); da.Update(dt); } } printLable(); GC.Collect(); }
public void Update(DataSet ds) { if (workbook == null) { objDBConn.Open(); DataTable schemaTable = objDBConn.GetSchema("Tables"); objDBConn.Close(); foreach (DataTable dataTable in ds.Tables) { foreach (DataColumn col in dataTable.Columns) { if (col.ColumnName.Contains(".")) { col.ColumnName = col.ColumnName.Replace(".", ""); } if (col.ColumnName.Contains("#")) { col.ColumnName = col.ColumnName.Replace("#", "Number"); } if (col.ColumnName.Contains("!")) { col.ColumnName = col.ColumnName.Replace("!", ""); } if (col.DataType.Equals(typeof(DateTime))) { foreach (DataRow row in dataTable.Rows) { if (!row.IsNull(col)) { if (((DateTime)row[col]).Ticks.Equals(0)) { row[col] = DBNull.Value; } } } } } DataSet tempDS = new DataSet(); string tableName = dataTable.TableName; DataView view = new DataView(schemaTable); view.RowFilter = "Table_Name='" + tableName + "'"; if (view.ToTable().Rows.Count <= 0) { CreateTable(dataTable); } OleDbDataAdapter objDA = (OleDbDataAdapter)objDBFactory.CreateDataAdapter(); objDA.SelectCommand = (OleDbCommand)CreateCommand("select * from [" + tableName + "]"); objDA.Fill(tempDS, tableName); OleDbCommandBuilder objCB = (OleDbCommandBuilder)objDBFactory.CreateCommandBuilder(); objCB.QuotePrefix = "["; objCB.QuoteSuffix = "]"; objCB.DataAdapter = objDA; string fieldlist = string.Empty; string valuelist = string.Empty; objDA.Update(ds, tableName); } //foreach (DataRow schemaRow in schemaTable.Rows) //{ // DataSet tempDS = new DataSet(); // string tableName = schemaRow["Table_Name"].ToString(); // OleDbDataAdapter objDA = (OleDbDataAdapter)objDBFactory.CreateDataAdapter(); // objDA.SelectCommand = (OleDbCommand)CreateCommand("select * from [" + tableName + "]"); // objDA.Fill(tempDS, tableName); // OleDbCommandBuilder objCB = (OleDbCommandBuilder)objDBFactory.CreateCommandBuilder(); // objCB.QuotePrefix = "["; // objCB.QuoteSuffix = "]"; // objCB.DataAdapter = objDA; // string fieldlist = string.Empty; // string valuelist = string.Empty; // //foreach (DataColumn column in ds.Tables[tableName].Columns) // //{ // // if (string.IsNullOrEmpty(fieldlist)) // // fieldlist = "[" + column.ColumnName + "]"; // // else // // { // // fieldlist += ", [" + column.ColumnName + "]"; // // } // // if (string.IsNullOrEmpty(valuelist)) // // valuelist = "?"; // // else // // { // // valuelist += ", ?"; // // } // //} // //foreach (DataRow row in ds.Tables[tableName].Rows) // //{ // // foreach (DataColumn column in ds.Tables[tableName].Columns) // // { // // if (string.IsNullOrEmpty(fieldlist)) // // fieldlist = "[" + column.ColumnName + "]"; // // else // // { // // fieldlist += ", [" + column.ColumnName + "]"; // // } // // if (string.IsNullOrEmpty(valuelist)) // // valuelist = "'" + row[column].ToString() + "'"; // // else // // { // // valuelist += ", '" + row[column].ToString() + "'"; // // } // // } // // DbCommand command = CreateCommand("INSERT INTO [" + tableName + "] (" + fieldlist + ") VALUES (" + valuelist + ")"); // // command.ExecuteNonQuery(); // //} // //objDA.InsertCommand = (OleDbCommand) CreateCommand("INSERT INTO [" + tableName + "] (" + fieldlist + ") VALUES (" + valuelist + ")"); // //foreach (DataColumn column in ds.Tables[tableName].Columns) // //{ // // objCB.GetInsertCommand().Parameters.Add("@" + column.ColumnName, OleDbType.VarWChar).SourceColumn = column.ColumnName; // //} // objDA.Update(ds, tableName); //} } else { foreach (DataTable dataTable in ds.Tables) { foreach (DataColumn col in dataTable.Columns) { if (col.DataType.Equals(typeof(DateTime))) { foreach (DataRow row in dataTable.Rows) { if (!row.IsNull(col)) { if (((DateTime)row[col]).Ticks.Equals(0)) { row[col] = DBNull.Value; } } } } } DataSet tempDS = new DataSet(); string tableName = dataTable.TableName; CreateWorkSheet(dataTable); //OleDbDataAdapter objDA = (OleDbDataAdapter)objDBFactory.CreateDataAdapter(); //objDA.SelectCommand = (OleDbCommand)CreateCommand("select * from [" + tableName + "]"); //objDA.Fill(tempDS, tableName); //OleDbCommandBuilder objCB = (OleDbCommandBuilder)objDBFactory.CreateCommandBuilder(); //objCB.QuotePrefix = "["; //objCB.QuoteSuffix = "]"; //objCB.DataAdapter = objDA; //string fieldlist = string.Empty; //string valuelist = string.Empty; //objDA.Update(ds, tableName); } System.IO.FileStream file = new System.IO.FileStream(ExcelFilePath, System.IO.FileMode.Create); workbook.Write(file); file.Close(); } }
/// <summary> /// This method uses to add data to PRO_ComponentScrapDetail /// </summary> /// <Inputs> /// PRO_ComponentScrapDetailVO /// </Inputs> /// <Returns> /// void /// </Returns> /// <History> /// Tuesday, June 07, 2005 /// </History> public void UpdateDataSet(DataSet pData) { const string METHOD_NAME = THIS + ".UpdateDataSet()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + PRO_ComponentScrapDetailTable.COMPONENTSCRAPDETAILID_FLD + "," + PRO_ComponentScrapDetailTable.FROMLOCATIONID_FLD + "," + PRO_ComponentScrapDetailTable.FROMBINID_FLD + "," + PRO_ComponentScrapDetailTable.TOBINID_FLD + "," + PRO_ComponentScrapDetailTable.TOLOCATIONID_FLD + "," + PRO_ComponentScrapDetailTable.SCRAPQUANTITY_FLD + "," + PRO_ComponentScrapDetailTable.COMPONENTSCRAPMASTERID_FLD + "," + PRO_ComponentScrapDetailTable.WORKORDERMASTERID_FLD + "," + PRO_ComponentScrapDetailTable.WORKORDERDETAILID_FLD + "," + PRO_ComponentScrapDetailTable.COMPONENTID_FLD + "," + PRO_ComponentScrapDetailTable.PRODUCTID_FLD + "," + PRO_ComponentScrapDetailTable.LINE_FLD + "," + PRO_ComponentScrapDetailTable.AVAILABLEQUANTITY_FLD + "," + PRO_ComponentScrapDetailTable.SCRAPREASONID_FLD + " FROM " + PRO_ComponentScrapDetailTable.TABLE_NAME; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); pData.EnforceConstraints = false; odadPCS.Update(pData, PRO_ComponentScrapDetailTable.TABLE_NAME); } catch (OleDbException ex) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
/// <summary> /// This method uses to add data to IV_Adjustment /// </summary> /// <Inputs> /// IV_AdjustmentVO /// </Inputs> /// <Returns> /// void /// </Returns> /// <History> /// Thursday, June 23, 2005 /// </History> public void UpdateDataSet(DataSet pdstData) { const string METHOD_NAME = THIS + ".UpdateDataSet()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + IV_AdjustmentTable.POSTDATE_FLD + "," + IV_AdjustmentTable.COMMENT_FLD + "," + IV_AdjustmentTable.PRODUCTID_FLD + "," + IV_AdjustmentTable.STOCKUMID_FLD + "," + IV_AdjustmentTable.CCNID_FLD + "," + IV_AdjustmentTable.LOCATIONID_FLD + "," + IV_AdjustmentTable.BINID_FLD + "," + IV_AdjustmentTable.MASTERLOCATIONID_FLD + "," + IV_AdjustmentTable.ADJUSTQUANTITY_FLD + "," + IV_AdjustmentTable.AVAILABLEQTY_FLD + "," + IV_AdjustmentTable.USEDBYCOSTING_FLD + "," + IV_AdjustmentTable.USERNAME_FLD + "," + IV_AdjustmentTable.TRANSNO_FLD + " FROM " + IV_AdjustmentTable.TABLE_NAME; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); pdstData.EnforceConstraints = false; odadPCS.Update(pdstData, IV_AdjustmentTable.TABLE_NAME); } catch (OleDbException ex) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
private void UpdateDB1() { OleDbCommandBuilder comandbuilder = new OleDbCommandBuilder(adRKC); adRKC.Update(DGРКЦTable); }
public static void CreateExcel(System.Data.DataTable dt, List <ObjectItem <string, Type, int> > listColumns, string fileName = null, string idColumn = null) { if (String.IsNullOrEmpty(fileName)) { fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + ".xlsx"; } if (!string.IsNullOrEmpty(fileName)) { string extName = Path.GetExtension(fileName); string connString = string.Empty; if (extName.Equals(".xlsx")) { connString = "Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=Excel 12.0 XML;Data Source=" + fileName + ";"; } else { connString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;Data Source=" + fileName + ";"; } OleDbConnection conn = new OleDbConnection(connString); try { conn.Open(); int col = dt.Columns.Count; if (col > 3) { if (!String.IsNullOrWhiteSpace(idColumn)) { var rr = dt.Select(idColumn + " IS NULL"); foreach (DataRow r in rr) { dt.Rows.Remove(r); } } string tabName = "Test"; List <string> list1 = new List <string>(); List <string> list2 = new List <string>(); List <string> list3 = new List <string>(); OleDbDataAdapter ada = new OleDbDataAdapter(); OleDbCommand cmd = new OleDbCommand(); cmd.Connection = conn; ada.InsertCommand = cmd; foreach (var oi in listColumns) { string colName = oi.Id; if (dt.Columns.Contains(colName)) { if (!cmd.Parameters.Contains("@" + colName)) { OleDbType odType = GetOleDbType((oi.Name)); String typeStr = odType.ToString(); list1.Add("[" + colName + "]"); list2.Add("@" + colName); list3.Add("[" + colName + "] " + GetOleDbTypeString(oi.Name, oi.Tag)); cmd.Parameters.Add("@" + colName, GetOleDbType(oi.Name), oi.Tag, colName); } } } cmd.CommandText = string.Format("CREATE TABLE [{0}]({1})", tabName, string.Join(",", list3.ToArray())); cmd.ExecuteNonQuery(); cmd.CommandText = string.Format("INSERT INTO [{0}] ({1}) VALUES({2})", tabName, string.Join(",", list1.ToArray()), string.Join(",", list2.ToArray())); cmd.UpdatedRowSource = UpdateRowSource.None; int count = ada.Update(dt); if (count > 0) { log.WriteLine("成功"); } else { log.WriteLine("失败"); } } } catch (Exception ex) { log.WriteLine(ex.Message); } finally { conn.Close(); } } }
public override bool UpdateDataTable(string SQLCmd, DataTable NewChangeDT) { bool result = false; if (conn == null) { conn.Open(); } if (conn.State != ConnectionState.Open) { conn.Open(); } OleDbTransaction tr; tr = conn.BeginTransaction(IsolationLevel.RepeatableRead); try { OleDbCommand cm = new OleDbCommand(SQLCmd, conn); OleDbDataAdapter da = new OleDbDataAdapter(cm); OleDbCommandBuilder cb = new OleDbCommandBuilder(da); DataTable mydt = new DataTable(); da.SelectCommand.Transaction = tr; da.Update(NewChangeDT); tr.Commit(); result = true; return(result); } catch (Exception ex) { try { MessageBox.Show(ex.ToString()); tr.Rollback(); if (conn.State.ToString().ToUpper() == "OPEN") { conn.Close(); } return(result); } catch (System.Exception TransactionEx) { //Handle Exception MessageBox.Show(TransactionEx.ToString()); if (conn.State.ToString().ToUpper() == "OPEN") { conn.Close(); } return(result); } } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public void Save() { File.Copy(Application.StartupPath + @"\system\System.mdb", Application.StartupPath + @"\system\System.mdb.bak", true); string dstrSQL; DataTable dDT; int dintIndex = 0; int dintEOV = 0; bool dbolError = false; SortedList dHT = new SortedList(); string dstrAfterEOV = ""; try { //유효성검사 for (int dintLoop = 0; dintLoop < this.dataGridView1.RowCount; dintLoop++) { dintIndex = Convert.ToInt32(this.dataGridView1.Rows[dintLoop].Cells[0].Value); dintEOV = Convert.ToInt32(this.dataGridView1.Rows[dintLoop].Cells[5].Value); if (dintEOV >= this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOVMin&& dintEOV <= this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOVMax) { if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOID == 8) //EOID=8이면 VCR Reading Mode임. { if (dintEOV == 0 || dintEOV == 1 || dintEOV == 2 || dintEOV == 3) //VCR Reading Mode는 0,1,2,3 만 값이 있다. { } else { dbolError = true; } } if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOID == 19) //SEM { if (dintEOV == 1) { //pInfo.All.SEM_ON = true; //if (pInfo.All.CommPort.ToUpper() != "NULL") pInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.SerialPortOpen); this.pInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.UDPPortOpen); //SEM Controller에 Start명령을 내린다. this.pInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.SEMControllerStart); } else { //pInfo.All.SEM_ON = false; this.pInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.SEMControllerEnd); this.pInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.UDPPortClose); } } if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOID == 21) //APC { if (dintEOV == 0 || dintEOV == 1) { if (dintEOV == 0) { pInfo.All.APCUSE = false; } else { pInfo.All.APCUSE = true; } } else { dbolError = true; } } if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOID == 22) //RPC { if (dintEOV == 0 || dintEOV == 1) { if (dintEOV == 0) { pInfo.All.RPCUSE = false; } else { pInfo.All.RPCUSE = true; } } else { dbolError = true; } } } else { dbolError = true; } if (dbolError == true) { dstrErrorMsg = this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).DESC + " 값은 " + this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOVMin + "~" + this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOVMax + " 이어야 합니다."; MessageBox.Show(dstrErrorMsg, "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } //바뀐 EOV 값이 있는지 검사한다. for (int dintLoop = 0; dintLoop < this.dataGridView1.RowCount; dintLoop++) { //dintIndex = dintLoop + 1; dintIndex = Convert.ToInt32(this.dataGridView1.Rows[dintLoop].Cells[0].Value); dintEOV = Convert.ToInt32(this.dataGridView1.Rows[dintLoop].Cells[5].Value); if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV != dintEOV) { dstrAfterEOV = dstrAfterEOV + dintIndex.ToString() + ";"; //EOID 저장 dHT.Add(dintIndex, this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV); //변경전의 EOID, EOV 저장 //if (this.PInfo.funGetEOIDLapseTime(dintIndex) == true) dbolProcessTimeOverChange = true; } } if (dstrAfterEOV == "") { MessageBox.Show("변경된 EOV가 하나도 없습니다.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (!DBAct.clsDBAct.funBeginTransaction()) { MessageBox.Show("DB Transaction NG!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } //DataAdapter 생성 OleDbDataAdapter dataAdapter = new OleDbDataAdapter("SELECT * FROM tbEOID order by Index", DBAct.clsDBAct.funOleDbConnect()); OleDbCommandBuilder commandBuilder = new OleDbCommandBuilder(dataAdapter); //DataAdapter를 이용하여 DB로 업데이트를 한다. dataAdapter.SelectCommand.Transaction = DBAct.clsDBAct.funOleDbTransaction(); dataAdapter.Update((DataTable)pEOIDListSource.DataSource); if (!DBAct.clsDBAct.funCommitTransaction()) { MessageBox.Show("DB Commit Transaction NG!", "Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); DBAct.clsDBAct.funRollbackTransaction(); return; } dstrSQL = "SELECT * FROM tbEOID order by index"; //dDT = DBAct.clsDBAct.funSelectQuery2(dstrSQL); //DataTable을 받아온다. dDT = DBAct.clsDBAct.funSelectQuery2(dstrSQL); if (dDT != null) { pInfo.Unit(0).SubUnit(0).RemoveEOID(); pInfo.DeleteTable("EOID"); pInfo.AddDataTable("EOID", dDT); foreach (DataRow dr in dDT.Rows) { dintIndex = Convert.ToInt32(dr["Index"]); pInfo.Unit(0).SubUnit(0).AddEOID(dintIndex); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOID = Convert.ToInt32(dr["EOID"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOMD = Convert.ToInt32(dr["EOMD"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOMDMin = Convert.ToInt32(dr["EOMDMin"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOMDMax = Convert.ToInt32(dr["EOMDMax"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV = Convert.ToInt32(dr["EOV"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOVMin = Convert.ToInt32(dr["EOVMin"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOVMax = Convert.ToInt32(dr["EOVMax"]); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).DESC = dr["Description"].ToString(); pInfo.Unit(0).SubUnit(0).EOID(dintIndex).PLCWrite = Convert.ToBoolean(dr["PLCWrite"]); } } string[] dstrData = dstrAfterEOV.Split(new char[] { ';' }); if (dstrData.Length > 1) { this.pInfo.All.EOIDChangeBYWHO = "2"; //BY OP //HOST로 EOV값 변경 보고 this.pInfo.subSendSF_Set(InfoAct.clsInfo.SFName.S6F11RelatedEquipmentParameterEvent, 101, dstrAfterEOV); //마지막 인자는 EOID Index임 this.pInfo.All.EOIDChangeBYWHO = ""; //초기화 //변경 이력 로그 저장 foreach (DictionaryEntry de in dHT) { dintIndex = Convert.ToInt32(de.Key); //EOID Index string dstrLog = ""; dstrLog = dstrLog + "EOID" + ","; dstrLog = dstrLog + DateTime.Now.ToString("yyyyMMddHHmmss") + ","; dstrLog = dstrLog + "변경" + ","; dstrLog = dstrLog + this.pInfo.All.UserID + ","; dstrLog = dstrLog + this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).DESC + ","; dstrLog = dstrLog + de.Value.ToString() + ","; dstrLog = dstrLog + this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV; this.pInfo.subLog_Set(InfoAct.clsInfo.LogType.Parameter, dstrLog); //로그 출력 dstrLog = ""; //초기화 //만약 EOID중에 PLC로 변경할 것이 있으면 Write해 준다. if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).PLCWrite == true) { switch (dintIndex) { //case 8: //VCR Reading Mode // this.PInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.VCRReadingMode, this.PInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV); // break; case 1: //APC(Advanced Process Control) MODE this.pInfo.subPLCCommand_Set(InfoAct.clsInfo.PLCCommand.APCMode, this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV); break; default: break; } } else { switch (dintIndex) { case 2: //MCC Reporting Mode if (this.pInfo.Unit(0).SubUnit(0).EOID(dintIndex).EOV == 1) { FunINIMethod.funINIReadValue("MCC", "MCCFileUploadUse", "True", this.pInfo.All.SystemINIFilePath); } else { FunINIMethod.funINIReadValue("MCC", "MCCFileUploadUse", "False", this.pInfo.All.SystemINIFilePath); } break; default: break; } } } } subSaveLastModified(); //최종 수정된 날짜를 Ini파일에 저장한다. MessageBox.Show("Data Save Success!", "Jobs Complete", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception ex) { pInfo.subLog_Set(InfoAct.clsInfo.LogType.CIM, ex.ToString()); DBAct.clsDBAct.funRollbackTransaction(); DBAct.clsDBAct.funDisconnect(); // DB 연결을 끊는다. MessageBox.Show("DB Update Fail, Because DB Process Error!", "DB Update Error!", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
/// <summary> /// This method uses to add data to MTR_MRPCycleOptionDetail /// </summary> /// <Inputs> /// MTR_MRPCycleOptionDetailVO /// </Inputs> /// <Returns> /// void /// </Returns> /// <History> /// Thursday, July 21, 2005 /// </History> public void UpdateDataSet(DataSet pdstData) { const string METHOD_NAME = THIS + ".UpdateDataSet()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + MTR_MRPCycleOptionDetailTable.MRPCYCLEOPTIONDETAILID_FLD + "," + MTR_MRPCycleOptionDetailTable.ONHAND_FLD + "," + MTR_MRPCycleOptionDetailTable.PURCHASEORDER_FLD + "," + MTR_MRPCycleOptionDetailTable.SALEORDER_FLD + "," + MTR_MRPCycleOptionDetailTable.DEMANDWO_FLD + "," + MTR_MRPCycleOptionDetailTable.MRPCYCLEOPTIONMASTERID_FLD + "," + MTR_MRPCycleOptionDetailTable.MASTERLOCATIONID_FLD + " FROM " + MTR_MRPCycleOptionDetailTable.TABLE_NAME; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); pdstData.EnforceConstraints = false; odadPCS.Update(pdstData, MTR_MRPCycleOptionDetailTable.TABLE_NAME); } catch (OleDbException ex) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
//审核功能 public override void CheckResult() { //保存 bool isSaved = Save(); if (isSaved == false) { return; } base.CheckResult(); dt记录.Rows[0]["审核人"] = mySystem.Parameter.userName; dt记录.Rows[0]["审核意见"] = checkform.opinion; dt记录.Rows[0]["审核是否通过"] = checkform.ischeckOk; //写待审核表 DataTable dt_temp = new DataTable("待审核"); //BindingSource bs_temp = new BindingSource(); if (!mySystem.Parameter.isSqlOk) { OleDbDataAdapter da_temp = new OleDbDataAdapter("select * from 待审核 where 表名='清洁分切运行记录' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.connOle); OleDbCommandBuilder cb_temp = new OleDbCommandBuilder(da_temp); da_temp.Fill(dt_temp); dt_temp.Rows[0].Delete(); da_temp.Update(dt_temp); } else { SqlDataAdapter da_temp = new SqlDataAdapter("select * from 待审核 where 表名='清洁分切运行记录' and 对应ID=" + dt记录.Rows[0]["ID"], mySystem.Parameter.conn); SqlCommandBuilder cb_temp = new SqlCommandBuilder(da_temp); da_temp.Fill(dt_temp); dt_temp.Rows[0].Delete(); da_temp.Update(dt_temp); } //写日志 string log = "=====================================\n"; log += DateTime.Now.ToString("yyyy年MM月dd日 hh时mm分ss秒") + "\n" + label角色.Text + ":" + mySystem.Parameter.userName + " 完成审核\n"; log += "审核结果:" + (checkform.ischeckOk == true ? "通过\n" : "不通过\n"); log += "审核意见:" + checkform.opinion + "\n"; dt记录.Rows[0]["日志"] = dt记录.Rows[0]["日志"].ToString() + log; Save(); //修改状态,设置可控性 if (checkform.ischeckOk) { _formState = Parameter.FormState.审核通过; } //审核通过 else { _formState = Parameter.FormState.审核未通过; } //审核未通过 setEnableReadOnly(); setDataGridViewFormat(); }
//************************************************************************** /// <Description> /// This method uses to update a DataSet /// </Description> /// <Inputs> /// DataSet /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// HungLa /// </Authors> /// <History> /// Thursday, September 29, 2005 /// </History> /// <Notes> /// </Notes> //************************************************************************** public void UpdateDataSet(DataSet pData) { const string METHOD_NAME = THIS + ".UpdateDataSet()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + PO_InvoiceDetailTable.INVOICEDETAILID_FLD + "," + PO_InvoiceDetailTable.INVOICELINE_FLD + "," + PO_InvoiceDetailTable.INVOICEMASTERID_FLD + "," + PO_InvoiceDetailTable.INVOICEQUANTITY_FLD + "," + PO_InvoiceDetailTable.UNITPRICE_FLD + "," + PO_InvoiceDetailTable.VAT_FLD + "," + PO_InvoiceDetailTable.VATAMOUNT_FLD + "," + PO_InvoiceDetailTable.IMPORTTAX_FLD + "," + PO_InvoiceDetailTable.IMPORTTAXAMOUNT_FLD + "," + PO_InvoiceDetailTable.INLAND_FLD + "," + PO_InvoiceDetailTable.BEFOREVATAMOUNT_FLD + "," + PO_InvoiceDetailTable.CIFAMOUNT_FLD + "," + PO_InvoiceDetailTable.CIPAMOUNT_FLD + "," + PO_InvoiceDetailTable.NOTE_FLD + "," + PO_InvoiceDetailTable.PRODUCTID_FLD + "," + PO_InvoiceDetailTable.PURCHASEORDERMASTERID_FLD + "," + PO_InvoiceDetailTable.PURCHASEORDERDETAILID_FLD + "," + PO_InvoiceDetailTable.DELIVERYSCHEDULEID_FLD + "," + PO_InvoiceDetailTable.INVOICEUMID_FLD + " FROM " + PO_InvoiceDetailTable.TABLE_NAME; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); pData.EnforceConstraints = false; odadPCS.Update(pData, PO_InvoiceDetailTable.TABLE_NAME); } catch (OleDbException ex) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
public bool AddByGroup(DataTable dt1) { using (OleDbConnection connection = new OleDbConnection(DbHelperOleDb.connectionString)) { try { OleDbCommand cmd2 = new OleDbCommand("insert into OrderInfo(OrderNo,Daterecived,SalesmanID,CustomerID,Tel,Provice,City,Area,Address,Reciver,Remark,Contractor,Contractdate,OState,Merchandiser,UserDate,OperUser,ORState,Paream0,Paream1,Paream2,Paream3,Paream4,Paream5,Paream6,Paream7,Paream8) values (@OrderNo,@Daterecived,@SalesmanID,@CustomerID,@Tel,@Provice,@City,@Area,@Address,@Reciver,@Remark,@Contractor,@Contractdate,@OState,@Merchandiser,@UserDate,@OperUser,@ORState,@Paream0,@Paream1,@Paream2,@Paream3,@Paream4,@Paream5,@Paream6,@Paream7,@Paream8)"); OleDbDataAdapter adapt = new OleDbDataAdapter("select * from OrderInfo", connection); OleDbCommandBuilder OleDbCmdBud = new OleDbCommandBuilder(adapt); OleDbParameter[] parameters = { new OleDbParameter("@OrderNo", OleDbType.VarChar, 30), new OleDbParameter("@Daterecived", OleDbType.Date), new OleDbParameter("@SalesmanID", OleDbType.Integer, 4), new OleDbParameter("@CustomerID", OleDbType.Integer, 4), new OleDbParameter("@Tel", OleDbType.VarChar, 30), new OleDbParameter("@Provice", OleDbType.VarChar, 30), new OleDbParameter("@City", OleDbType.VarChar, 30), new OleDbParameter("@Area", OleDbType.VarChar, 30), new OleDbParameter("@Address", OleDbType.VarChar, 200), new OleDbParameter("@Reciver", OleDbType.VarChar, 10), new OleDbParameter("@Remark", OleDbType.VarChar, 100), new OleDbParameter("@Contractor", OleDbType.VarChar, 20), new OleDbParameter("@Contractdate", OleDbType.Date), new OleDbParameter("@OState", OleDbType.Integer, 4), new OleDbParameter("@Merchandiser", OleDbType.Integer, 4), new OleDbParameter("@UserDate", OleDbType.Date), new OleDbParameter("@OperUser", OleDbType.VarChar, 20), new OleDbParameter("@ORState", OleDbType.Integer, 4), new OleDbParameter("@Paream0", OleDbType.VarChar, 255), new OleDbParameter("@Paream1", OleDbType.VarChar, 255), new OleDbParameter("@Paream2", OleDbType.VarChar, 255), new OleDbParameter("@Paream3", OleDbType.VarChar, 255), new OleDbParameter("@Paream4", OleDbType.VarChar, 255), new OleDbParameter("@Paream5", OleDbType.Integer, 4), new OleDbParameter("@Paream6", OleDbType.Integer, 4), new OleDbParameter("@Paream7", OleDbType.Integer, 4), new OleDbParameter("@Paream8", OleDbType.Integer, 4) }; adapt.Fill(dt1); adapt.SelectCommand.Parameters.AddRange(parameters); adapt.SelectCommand.Parameters["@OrderNo"].SourceColumn = "OrderNo"; adapt.SelectCommand.Parameters["@Daterecived"].SourceColumn = "Daterecived"; adapt.SelectCommand.Parameters["@SalesmanID"].SourceColumn = "SalesmanID"; adapt.SelectCommand.Parameters["@CustomerID"].SourceColumn = "CustomerID"; adapt.SelectCommand.Parameters["@Tel"].SourceColumn = "Tel"; adapt.SelectCommand.Parameters["@Provice"].SourceColumn = "Provice"; adapt.SelectCommand.Parameters["@City"].SourceColumn = "City"; adapt.SelectCommand.Parameters["@Area"].SourceColumn = "Area"; adapt.SelectCommand.Parameters["@Address"].SourceColumn = "Address"; adapt.SelectCommand.Parameters["@Reciver"].SourceColumn = "Reciver"; adapt.SelectCommand.Parameters["@Remark"].SourceColumn = "Remark"; adapt.SelectCommand.Parameters["@Contractdate"].SourceColumn = "Contractdate"; adapt.SelectCommand.Parameters["@OState"].SourceColumn = "OState"; adapt.SelectCommand.Parameters["@Merchandiser"].SourceColumn = "Merchandiser"; adapt.SelectCommand.Parameters["@UserDate"].SourceColumn = "UserDate"; adapt.SelectCommand.Parameters["@OperUser"].SourceColumn = "OperUser"; adapt.SelectCommand.Parameters["@ORState"].SourceColumn = "ORState"; adapt.SelectCommand.Parameters["@Paream0"].SourceColumn = "Paream0"; adapt.SelectCommand.Parameters["@Paream1"].SourceColumn = "Paream1"; adapt.SelectCommand.Parameters["@Paream2"].SourceColumn = "Paream2"; adapt.SelectCommand.Parameters["@Paream3"].SourceColumn = "Paream3"; adapt.SelectCommand.Parameters["@Paream4"].SourceColumn = "Paream4"; adapt.SelectCommand.Parameters["@Paream5"].SourceColumn = "Paream5"; adapt.SelectCommand.Parameters["@Paream6"].SourceColumn = "Paream6"; adapt.SelectCommand.Parameters["@Paream7"].SourceColumn = "Paream7"; adapt.SelectCommand.Parameters["@Paream8"].SourceColumn = "Paream8"; adapt.UpdateCommand = OleDbCmdBud.GetUpdateCommand(); if (dt1 != null) { adapt.Update(dt1); } return(true); } catch (Exception ex) { return(false); } } }
// override the 'Create new folder' method protected override void ExecAddFolderCommand(string sourceUrl, string name) { Regex regex = new Regex("^" + DatabaseProtocol, RegexOptions.Compiled); if (!regex.IsMatch(sourceUrl)) // it is the 'file system' gallery command { // call the base method base.ExecAddFolderCommand(sourceUrl, name); return; } string url = regex.Replace(sourceUrl, ""); string temp = url; if (temp.Substring(temp.Length - 1, 1) == "/") { temp = temp.Substring(0, temp.Length - 1); } if (temp.Substring(0, 1) == "/") { temp = temp.Substring(1, temp.Length - 1); } string[] folders = temp.Split(new char[] { '/' }); int parentId = 0; OleDbConnection connection = new OleDbConnection(); try { connection.ConnectionString = ConnectionString; connection.Open(); for (int i = 0; i < folders.Length; i++) { string folderName = folders[i]; // inspect for child folders string sqlString = "Select * from tbFolder Where fldFolderId=" + parentId.ToString(); OleDbDataAdapter eAdapter = new OleDbDataAdapter(sqlString, connection); DataTable eTable = new DataTable(); eAdapter.Fill(eTable); bool found = false; // search for the folder for (int j = 0; j < eTable.Rows.Count; j++) { DataRow row = eTable.Rows[j]; string childFolderName = (string)row["fldName"]; if (childFolderName == folderName) { parentId = (int)row["id"]; found = true; break; } } // not found - create it if (!found) { OleDbCommand cmdInsert = new OleDbCommand("INSERT INTO tbFolder (fldName, fldFolderId) VALUES(?, ?)", connection); cmdInsert.Parameters.Add(new OleDbParameter("fldName", OleDbType.VarChar, 100, "fldName")); cmdInsert.Parameters.Add(new OleDbParameter("fldFolderId", OleDbType.Integer, 0, "fldFolderId")); eAdapter.InsertCommand = cmdInsert; // Create a command to get IDENTITY Value cmdGetIdentity = new OleDbCommand("SELECT @@IDENTITY", connection); eAdapter.RowUpdated += new OleDbRowUpdatedEventHandler(HandleRowUpdated); DataRow newRow = eTable.NewRow(); newRow["fldName"] = folderName; newRow["fldFolderId"] = parentId; eTable.Rows.Add(newRow); eAdapter.Update(eTable); parentId = (int)newRow["id"]; // Release the Resources cmdGetIdentity = null; cmdInsert = null; } eAdapter.Dispose(); eTable.Dispose(); } } finally { connection.Close(); connection.Dispose(); } }
private void button2_Click(object sender, EventArgs e) { dta.Update(dts, "doc"); }
// GENEL OLARAK DEĞİŞİKLİKLERİ KAYDETME private void btnKaydet_Click(object sender, EventArgs e) { adaptor.Update(ds.Tables["Depo"]); dataGridDoldur("Select * From Depo ORDER BY UrunID"); MessageBox.Show("Tüm değişiklikler kaydedildi.", "Başarılı", MessageBoxButtons.OK, MessageBoxIcon.Information); }
//************************************************************************** /// <Description> /// This method uses to update a DataSet /// </Description> /// <Inputs> /// DataSet /// </Inputs> /// <Outputs> /// /// </Outputs> /// <Returns> /// /// </Returns> /// <Authors> /// HungLa /// </Authors> /// <History> /// Tuesday, January 25, 2005 /// </History> /// <Notes> /// </Notes> //************************************************************************** public void UpdateDataSet(DataSet pData) { const string METHOD_NAME = THIS + ".UpdateDataSet()"; string strSql; OleDbConnection oconPCS = null; OleDbCommandBuilder odcbPCS; OleDbDataAdapter odadPCS = new OleDbDataAdapter(); try { strSql = "SELECT " + MST_WorkCenterCapacityTable.WORKCENTERCAPACITYID_FLD + "," + MST_WorkCenterCapacityTable.EFFECTIVEBEGINDATE_FLD + "," + MST_WorkCenterCapacityTable.LABORHOURSPERDAY_FLD + "," + MST_WorkCenterCapacityTable.EFFECTIVEENDDATE_FLD + "," + MST_WorkCenterCapacityTable.CREWSIZE_FLD + "," + MST_WorkCenterCapacityTable.LABORSHIFT_FLD + "," + MST_WorkCenterCapacityTable.LABOREFFICIENCYFACTOR_FLD + "," + MST_WorkCenterCapacityTable.MACHINEHOURSPERDAY_FLD + "," + MST_WorkCenterCapacityTable.MACHINEQTY_FLD + "," + MST_WorkCenterCapacityTable.MACHINESHIFT_FLD + "," + MST_WorkCenterCapacityTable.MACHINEEFFICIENCYFACTOR_FLD + " FROM " + MST_WorkCenterCapacityTable.TABLE_NAME; Utils utils = new Utils(); oconPCS = new OleDbConnection(Utils.Instance.OleDbConnectionString); odadPCS.SelectCommand = new OleDbCommand(strSql, oconPCS); odcbPCS = new OleDbCommandBuilder(odadPCS); pData.EnforceConstraints = false; odadPCS.Update(pData, MST_WorkCenterCapacityTable.TABLE_NAME); } catch (OleDbException ex) { if (ex.Errors[1].NativeError == ErrorCode.SQLDUPLICATE_KEYCODE) { throw new PCSDBException(ErrorCode.DUPLICATE_KEY, METHOD_NAME, ex); } else if (ex.Errors[1].NativeError == ErrorCode.SQLCASCADE_PREVENT_KEYCODE) { throw new PCSDBException(ErrorCode.CASCADE_DELETE_PREVENT, METHOD_NAME, ex); } else { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } } catch (InvalidOperationException ex) { throw new PCSDBException(ErrorCode.ERROR_DB, METHOD_NAME, ex); } catch (Exception ex) { throw new PCSDBException(ErrorCode.OTHER_ERROR, METHOD_NAME, ex); } finally { if (oconPCS != null) { if (oconPCS.State != ConnectionState.Closed) { oconPCS.Close(); } } } }
void gravaDados() { OleDbCommandBuilder cb = new OleDbCommandBuilder(daDocs); daDocs.Update(tbDocs); }
private void btnSave_Click(object sender, EventArgs e) { if (ValidateInput()) { try { var savedRecord = txtISBN.Text; titlesManager.EndCurrentEdit(); builderComm = new OleDbCommandBuilder(titlesAdapter); if (AppState == State.Edit) { var titleRow = titlesTable.Select($"ISBN = '{savedRecord}'"); if (string.IsNullOrEmpty(txtYearPublished.Text)) { titleRow[0]["Year_Published"] = DBNull.Value; } else { titleRow[0]["Year_Published"] = txtYearPublished.Text; } titlesAdapter.Update(titlesTable); txtYearPublished.DataBindings.Add("Text", titlesTable, "Year_Published"); } else if (AppState == State.Add) { titlesAdapter.Update(titlesTable); titlesTable.DefaultView.Sort = "Title"; var foundRecord = titlesTable.Select($"ISBN = '{savedRecord}'"); titlesManager.Position = titlesTable.DefaultView.Find(foundRecord[0]["Title"]); ISBNAuthorsComm = new OleDbCommand($"SELECT * FROM Title_Author WHERE ISBN = '{txtISBN.Text}'", booksConn); ISBNAuthorsAdapter = new OleDbDataAdapter(ISBNAuthorsComm); ISBNAuthorsTable = new DataTable(); ISBNAuthorsAdapter.Fill(ISBNAuthorsTable); } builderComm = new OleDbCommandBuilder(ISBNAuthorsAdapter); if (ISBNAuthorsTable.Rows.Count > 0 && AppState == State.Edit) { for (int i = 0; i < ISBNAuthorsTable.Rows.Count; i++) { ISBNAuthorsTable.Rows[i].Delete(); } ISBNAuthorsAdapter.Update(ISBNAuthorsTable); } for (int i = 0; i < 4; i++) { if (authorsCombo[i].SelectedIndex != -1) { ISBNAuthorsTable.Rows.Add(); ISBNAuthorsTable.Rows[ISBNAuthorsTable.Rows.Count - 1]["ISBN"] = txtISBN.Text; ISBNAuthorsTable.Rows[ISBNAuthorsTable.Rows.Count - 1]["AU_ID"] = authorsCombo[i].SelectedValue; } } ISBNAuthorsAdapter.Update(ISBNAuthorsTable); MessageBox.Show("Record is saved successfully", "Saving Record", MessageBoxButtons.OK, MessageBoxIcon.Information); SetAppState(State.View); } catch (Exception ex) { MessageBox.Show(ex.Message, "Record Saving Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void btnSua_Click(object sender, EventArgs e) { Anhien(true); btnSua.Enabled = true; btnXoa.Enabled = false; txtMaSo.Enabled = false; BindingContext[ds, "diem"].EndCurrentEdit(); da.Update(ds, "diem"); }
/// <summary> /// Establece una relación entre algún concepto y el término que se quiere asociar como sinónimo /// </summary> /// <param name="sinonimo">Término con significado similar </param> /// <param name="idConcepto">Concepto al que irá ligado el sinónimo</param> public void SetNewSinonimo(Sinonimos sinonimo, int idConcepto) { OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString()); OleDbDataAdapter dataAdapter; DataSet dataSet = new DataSet(); DataRow dr; try { sinonimo.IdSinonimo = DataBaseUtilities.GetNextIdForUse("Sinonimos", "IdSinonimo", connection); string sqlCadena = "SELECT * FROM Sinonimos WHERE IdSinonimo = 0"; dataAdapter = new OleDbDataAdapter(); dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection); dataAdapter.Fill(dataSet, "Sinonimos"); dr = dataSet.Tables["Sinonimos"].NewRow(); dr["IdSinonimo"] = sinonimo.IdSinonimo; dr["Sinonimo"] = sinonimo.Sinonimo; dr["SinonimoStr"] = sinonimo.SinonimoStr; dr["Fuente"] = sinonimo.Fuente; dr["FuenteStr"] = sinonimo.FuenteStr; dr["FechaAlta"] = DateTime.Now; dr["FechaAltaInt"] = DateTimeUtilities.DateToInt(DateTime.Now); dataSet.Tables["Sinonimos"].Rows.Add(dr); dataAdapter.InsertCommand = connection.CreateCommand(); dataAdapter.InsertCommand.CommandText = "INSERT INTO Sinonimos VALUES (@IdSinonimo,@Sinonimo,@SinonimoStr,@Fuente,@FuenteStr,@FechaAlta,@FechaAltaInt)"; dataAdapter.InsertCommand.Parameters.Add("@IdSinonimo", OleDbType.Numeric, 0, "IdSinonimo"); dataAdapter.InsertCommand.Parameters.Add("@Sinonimo", OleDbType.VarChar, 0, "Sinonimo"); dataAdapter.InsertCommand.Parameters.Add("@SinonimoStr", OleDbType.VarChar, 0, "SinonimoStr"); dataAdapter.InsertCommand.Parameters.Add("@Fuente", OleDbType.VarChar, 0, "Fuente"); dataAdapter.InsertCommand.Parameters.Add("@FuenteStr", OleDbType.VarChar, 0, "FuenteStr"); dataAdapter.InsertCommand.Parameters.Add("@FechaAlta", OleDbType.Date, 0, "FechaAlta"); dataAdapter.InsertCommand.Parameters.Add("@FechaAltaInt", OleDbType.Numeric, 0, "FechaAltaInt"); dataAdapter.Update(dataSet, "Sinonimos"); dataSet.Dispose(); dataAdapter.Dispose(); new RelacionesModel().SetNewRelation(idConcepto, sinonimo.IdSinonimo, 2); } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } finally { connection.Close(); } }
private void button8_Click(object sender, EventArgs e) { for (int v = 0; v < MyData.Tables[0].Rows.Count; v++) { // MessageBox.Show("run"); if (this.a0.Text == MyData.Tables[0].Rows[v][0].ToString()) { string SQL = "delete from e24chdl where a0= '" + this.a0.Text + "'"; OleDbCommand MyCom = new OleDbCommand(SQL, MyConn); MyCom.ExecuteNonQuery(); MyData.Tables[0].Rows.RemoveAt(v); break; } } panel2.Enabled = true; /* * word 存储开始 * */ //代码域 Thread MySaveS = new Thread(new ThreadStart(save)); MySaveS.Start(); /* * word存储结束 */ /* * 数据库存储开始 */ DataRow NewRow = MyData.Tables[0].NewRow(); NewRow["a0"] = a0.Text; NewRow["a1"] = a1.Text; NewRow["a2"] = a2.Text; NewRow["a3"] = a3.Text; NewRow["a4"] = a4.Text; NewRow["a5"] = a5.Text; NewRow["a6"] = a6.Text; NewRow["a7"] = a7.Text; NewRow["a8"] = a8.Text; NewRow["a9"] = a9.Text; NewRow["a10"] = a11.Text; NewRow["a11"] = a10.Text; NewRow["a15"] = a15.Text; NewRow["a13"] = a13.Text; NewRow["a14"] = a14.Text; // NewRow["a15"] = a15.Text; NewRow["a16"] = a16.Text; NewRow["a17"] = a17.Text; NewRow["a18"] = a18.Text; NewRow["a19"] = a19.Text; NewRow["a20"] = a20.Text; NewRow["a21"] = a21.Text; NewRow["time_e"] = main.currentTime.Year.ToString() + "-" + main.currentTime.Month.ToString() + "-" + main.currentTime.Day.ToString(); MyData.Tables[0].Rows.Add(NewRow); MyAd.Update(MyData); //MessageBox.Show(a13_1.CheckState); /* * 数据库的存储结束 * * * */ MessageBox.Show("保存成功!!"); i = MyData.Tables[0].Rows.Count - 1; textBox18.Text = (i + 1).ToString(); panel1.Enabled = false; button6.Enabled = true; button7.Enabled = true; button8.Enabled = false; button9.Enabled = false; button10.Enabled = true; button11.Enabled = true; button12.Enabled = true; button13.Enabled = true; button14.Enabled = true; button16.Enabled = true; button17.Enabled = true; OleDbDataAdapter MyAd0 = new OleDbDataAdapter("select count(a0) from e24chdl ", MyConn); DataSet MyData0 = new DataSet(); MyAd0.Fill(MyData0); this.textBox17.Text = MyData.Tables[0].Rows.Count.ToString(); }
/// <summary> /// Modifica la estructura original del sinónimo /// </summary> /// <param name="sinonimo">Sinonimo que se modificará</param> public void UpdateSinonimo(Sinonimos sinonimo) { OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString()); OleDbDataAdapter dataAdapter; DataSet dataSet = new DataSet(); DataRow dr; try { string sqlCadena = "SELECT * FROM Sinonimos WHERE IdSinonimo = @IdSinonimo"; dataAdapter = new OleDbDataAdapter(); dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection); dataAdapter.SelectCommand.Parameters.AddWithValue("@IdSinonimo", sinonimo.IdSinonimo); dataAdapter.Fill(dataSet, "Sinonimos"); dr = dataSet.Tables["Sinonimos"].Rows[0]; dr.BeginEdit(); dr["Sinonimo"] = sinonimo.Sinonimo; dr["SinonimoStr"] = sinonimo.SinonimoStr; dr["Fuente"] = sinonimo.Fuente; dr["FuenteStr"] = sinonimo.FuenteStr; dr.EndEdit(); dataAdapter.UpdateCommand = connection.CreateCommand(); dataAdapter.UpdateCommand.CommandText = "UPDATE Sinonimos SET Sinonimo = @Sinonimo, SinonimoStr = @SinonimoStr, " + " Fuente = @Fuente, FuenteStr = @FuenteStr WHERE IdSinonimo = @IdSinonimo"; dataAdapter.UpdateCommand.Parameters.Add("@Sinonimo", OleDbType.VarChar, 0, "Sinonimo"); dataAdapter.UpdateCommand.Parameters.Add("@SinonimoStr", OleDbType.VarChar, 0, "SinonimoStr"); dataAdapter.UpdateCommand.Parameters.Add("@Fuente", OleDbType.VarChar, 0, "Fuente"); dataAdapter.UpdateCommand.Parameters.Add("@FuenteStr", OleDbType.VarChar, 0, "FuenteStr"); dataAdapter.UpdateCommand.Parameters.Add("@IdSinonimo", OleDbType.Numeric, 0, "IdSinonimo"); dataAdapter.Update(dataSet, "Sinonimos"); dataSet.Dispose(); dataAdapter.Dispose(); } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } finally { connection.Close(); } }
public void InsertaTemasIusScjn(List <TesisDTO> listaTesis, BackgroundWorker worker) { OleDbConnection connection = Conexion.GetAccessDataBaseConnection(idProducto); OleDbDataAdapter dataAdapter; DataSet dataSet = new DataSet(); DataRow dr; int currentProgress = 1; string sqlCadena = "SELECT * FROM Tesis WHERE IUS4 = 0"; try { connection.Open(); dataAdapter = new OleDbDataAdapter(); dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection); dataAdapter.Fill(dataSet, "Tesis"); int consec = 1; foreach (TesisDTO tesis in listaTesis) { dr = dataSet.Tables["Tesis"].NewRow(); dr["Tipo"] = tesis.Parte; dr["Consec"] = consec; dr["IUS4"] = tesis.Ius; dr["ConsecIndx"] = tesis.Volumen; dataSet.Tables["Tesis"].Rows.Add(dr); dataAdapter.InsertCommand = connection.CreateCommand(); dataAdapter.InsertCommand.CommandText = "INSERT INTO Tesis(TIPO,CONSEC,IUS4,CONSECINDX) VALUES(@TIPO,@CONSEC,@IUS4,@CONSECINDX)"; dataAdapter.InsertCommand.Parameters.Add("@TIPO", OleDbType.Numeric, 0, "TIPO"); dataAdapter.InsertCommand.Parameters.Add("@CONSEC", OleDbType.Numeric, 0, "CONSEC"); dataAdapter.InsertCommand.Parameters.Add("@IUS4", OleDbType.Numeric, 0, "IUS4"); dataAdapter.InsertCommand.Parameters.Add("@CONSECINDX", OleDbType.Numeric, 0, "CONSECINDX"); dataAdapter.Update(dataSet, "Tesis"); dataSet.Dispose(); dataAdapter.Dispose(); consec++; worker.ReportProgress(currentProgress); currentProgress++; } } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MigradorModel", "ChecaPrecedentes"); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,MigradorModel", "ChecaPrecedentes"); } finally { connection.Close(); } }
public int Update(ViewDataSet.品號ViewDataTable table) { OleDbDataAdapter adapter = new OleDbDataAdapter(); adapter.UpdateCommand = UpdateCommand; adapter.InsertCommand = InsertCommand; adapter.DeleteCommand = DeleteCommand; this.Connection.Open(); OleDbTransaction trans = this.Connection.BeginTransaction(); adapter.InsertCommand.Transaction = trans; adapter.UpdateCommand.Transaction = trans; adapter.DeleteCommand.Transaction = trans; try { int count = 0; count = adapter.Update(table); trans.Commit(); return count; } catch (System.Exception ex) { trans.Rollback(); throw ex; } finally { this.Connection.Close(); } }