public string SAVE_MAKHACHHANG_TO_ORACLE() { string RESULT = ""; using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["TBNETERP_SERVER"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { int CURRENT = 0; OracleCommand command = new OracleCommand(); command.Connection = connection; string querySelectItem = "SELECT \"TYPE\",CODE,\"CURRENT\" FROM MD_ID_BUILDER WHERE CODE = 'KH'"; command.CommandText = querySelectItem; command.CommandType = CommandType.Text; OracleDataReader dataReaderBuildCode = command.ExecuteReader(); if (dataReaderBuildCode.HasRows) { while (dataReaderBuildCode.Read()) { MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER(); _MD_ID_BUILDER.ID = Guid.NewGuid().ToString(); _MD_ID_BUILDER.TYPE = "KH"; _MD_ID_BUILDER.CODE = "KH"; _MD_ID_BUILDER.CURRENT = "0000"; _MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode; int CURRENT_NUMBER = 0; int.TryParse(dataReaderBuildCode["CURRENT"].ToString(), out CURRENT_NUMBER); string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString()); _MD_ID_BUILDER.CURRENT = SO_MA; OracleCommand commandUpdate = new OracleCommand(); commandUpdate.Connection = connection; string queryUpdateItem = "UPDATE MD_ID_BUILDER SET \"CURRENT\" = '" + _MD_ID_BUILDER.CURRENT + "' WHERE \"TYPE\" = '" + _MD_ID_BUILDER.TYPE + "' AND \"CODE\" = '" + _MD_ID_BUILDER.CODE + "' "; commandUpdate.CommandText = queryUpdateItem; commandUpdate.CommandType = CommandType.Text; commandUpdate.ExecuteNonQuery(); RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.CODE, SO_MA); } } else { MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER(); _MD_ID_BUILDER.ID = Guid.NewGuid().ToString(); _MD_ID_BUILDER.TYPE = "KH"; _MD_ID_BUILDER.CODE = "KH"; _MD_ID_BUILDER.CURRENT = "0000"; _MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode; string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.CURRENT); _MD_ID_BUILDER.CURRENT = SO_MA; OracleCommand commandInsert = new OracleCommand(); commandInsert.Connection = connection; string queryInsertItem = "INSERT INTO MD_ID_BUILDER(ID,\"TYPE\",CODE,\"CURRENT\",\"UNITCODE\",NGAYTAO) VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.TYPE + "','" + _MD_ID_BUILDER.CURRENT + "','" + _MD_ID_BUILDER.UNITCODE + "','" + DateTime.Now + "')"; commandInsert.CommandText = queryInsertItem; commandInsert.CommandType = CommandType.Text; commandInsert.ExecuteNonQuery(); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal"); } } return(RESULT); }
public string SAVE_MAKHACHHANG_TO_ORACLE() { string RESULT = ""; using (OracleConnection connection = new OracleConnection(ConfigurationManager.ConnectionStrings["ERBusConnection"].ConnectionString)) { connection.Open(); if (connection.State == ConnectionState.Open) { try { OracleCommand command = new OracleCommand(); command.Connection = connection; string querySelectItem = "SELECT LOAIMA,NHOMMA,GIATRI,UNITCODE FROM CAPMA WHERE LOAIMA='VIP' AND NHOMMA = 'KHACHHANG'"; command.CommandText = querySelectItem; command.CommandType = CommandType.Text; OracleDataReader dataReaderBuildCode = command.ExecuteReader(); if (dataReaderBuildCode.HasRows) { while (dataReaderBuildCode.Read()) { MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER(); _MD_ID_BUILDER.ID = Guid.NewGuid().ToString(); _MD_ID_BUILDER.LOAIMA = "VIP"; _MD_ID_BUILDER.NHOMMA = "KHACHHANG"; _MD_ID_BUILDER.GIATRI = "0"; _MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode; int CURRENT_NUMBER = 0; int.TryParse(dataReaderBuildCode["GIATRI"].ToString(), out CURRENT_NUMBER); string SO_MA = GENERATE_NUMBER(CURRENT_NUMBER.ToString()); _MD_ID_BUILDER.GIATRI = SO_MA; OracleCommand commandUpdate = new OracleCommand(); commandUpdate.Connection = connection; string queryUpdateItem = "UPDATE CAPMA SET GIATRI = '" + _MD_ID_BUILDER.GIATRI + "' WHERE LOAIMA = '" + _MD_ID_BUILDER.LOAIMA + "' AND NHOMMA = '" + _MD_ID_BUILDER.NHOMMA + "' "; commandUpdate.CommandText = queryUpdateItem; commandUpdate.CommandType = CommandType.Text; commandUpdate.ExecuteNonQuery(); RESULT = string.Format("{0}{1}", _MD_ID_BUILDER.LOAIMA, SO_MA); } } else { MD_ID_BUILDER _MD_ID_BUILDER = new MD_ID_BUILDER(); _MD_ID_BUILDER.ID = Guid.NewGuid().ToString(); _MD_ID_BUILDER.LOAIMA = "VIP"; _MD_ID_BUILDER.NHOMMA = "KHACHHANG"; _MD_ID_BUILDER.GIATRI = "0"; _MD_ID_BUILDER.UNITCODE = Session.Session.CurrentUnitCode; string SO_MA = GENERATE_NUMBER(_MD_ID_BUILDER.GIATRI); _MD_ID_BUILDER.GIATRI = SO_MA; OracleCommand commandInsert = new OracleCommand(); commandInsert.Connection = connection; string queryInsertItem = "INSERT INTO CAPMA(ID,LOAIMA,NHOMMA,GIATRI,\"UNITCODE\") VALUES ('" + _MD_ID_BUILDER.ID + "','" + _MD_ID_BUILDER.LOAIMA + "','" + _MD_ID_BUILDER.NHOMMA + "','" + _MD_ID_BUILDER.GIATRI + "','" + _MD_ID_BUILDER.UNITCODE + "')"; commandInsert.CommandText = queryInsertItem; commandInsert.CommandType = CommandType.Text; commandInsert.ExecuteNonQuery(); } } catch (Exception ex) { WriteLogs.LogError(ex); } finally { connection.Close(); connection.Dispose(); } } else { NotificationLauncher.ShowNotificationError("THÔNG BÁO", "KHÔNG CÓ KẾT NỐI VỚI CƠ SỞ DỮ LIỆU ORACLE", 1, "0x1", "0x8", "normal"); } } return(RESULT); }