private void changeChartView()
{
using (OracleConnection connection = new OracleConnection(FormLogin.connString))
{
connection.Open();
String query = "SELECT m.idRound AS ROUND, ROUND(SUM(part.match_Rating)/COUNT(part.match_Rating)) AS TEAMRATING"
+ " FROM participates part JOIN player p ON (part.idPlayer = p.idPlayer) JOIN match m ON (part.idMatch = m.idMatch)"
+ " WHERE p.idTeam = " + Team.Id
+ " GROUP BY m.idRound"
+ " ORDER BY m.idRound";
OracleDataAdapter adapter = new OracleDataAdapter(query, connection);
DataTable table = new DataTable();
adapter.Fill(table);
chartTeamRating.DataSource = table;
chartTeamRating.Series["Series1"].XValueMember = "Round";
chartTeamRating.Series["Series1"].YValueMembers = "TeamRating";
}
chartTeamRating.ChartAreas["ChartArea1"].AxisX.Title = "Rounds";
chartTeamRating.ChartAreas["ChartArea1"].AxisY.Title = "Rating";
chartTeamRating.ChartAreas["ChartArea1"].AxisX.Minimum = 1;
chartTeamRating.ChartAreas["ChartArea1"].AxisX.Maximum = 38;
chartTeamRating.ChartAreas["ChartArea1"].AxisX.Interval = 1;
chartTeamRating.ChartAreas["ChartArea1"].AxisY.Minimum = 1000;
chartTeamRating.ChartAreas["ChartArea1"].AxisY.Maximum = 3000;
chartTeamRating.ChartAreas["ChartArea1"].Visible = true;
chartTeamRating.Series["Series1"].BorderWidth = 3;
}
protected void Page_Load(object sender, EventArgs e)
{
//DataTable dt = new DataTable();
//dt.Columns.Add("STUFF_NAME");
//dt.Columns.Add("STUFF_GENDER");
//dt.Columns.Add("STUFF_PHONE");
//dt.Columns.Add("STUFF_DOB");
//dt.Columns.Add("STUFF_NID");
//dt.Columns.Add("STUFF_DESIGNATION");
//dt.Columns.Add("STUFF_Salary");
//DataRow dr;
string ConnectionString = @"DATA SOURCE=127.0.0.1:1521/XE;PERSIST SECURITY INFO=True;USER ID=TAHMID; Password=anik";
string cmdQuery = "Select STUFF.STUFF_ID as SID, STUFF.STUFF_NAME as name, STUFF.STUFF_GENDER as gen, STUFF.STUFF_PHONE as phone, STUFF.STUFF_DOB as dob, STUFF.STUFF_NID as nid, DESIGNATION.D_NAME as d_name, DESIGNATION.SALARY as salary, TIME_SHIFT.TS as ts from STUFF, DESIGNATION, TIME_SHIFT where STUFF.STUFF_DESIGNATION = DESIGNATION.D_ID and STUFF.STUFF_TS = TIME_SHIFT.TS_ID ";
OracleDataAdapter a = new OracleDataAdapter(cmdQuery, ConnectionString);
OracleCommandBuilder builder = new OracleCommandBuilder(a);
DataSet ds = new DataSet();
a.Fill(ds, "STUFF_details");
GridView_stuff_list.DataSource = ds;
GridView_stuff_list.DataBind();
//foreach (DataRow r in ds.Tables["STUFF"].Rows)
//{
// dr = dt.NewRow();
// dr["STUFF_NAME"] = r["STUFF_NAME"].ToString();
// dr["STUFF_GENDER"] = r["STUFF_GENDER"].ToString();
// dr["STUFF_PHONE"] = r["STUFF_PHONE"].ToString();
// dr["STUFF_DOB"] = r["STUFF_DOB"].ToString();
// dr["STUFF_NID"] = r["STUFF_NID"].ToString();
// string i;
// i = r["STUFF_DESIGNATION"].ToString();
// dt.Rows.Add(dr);
// dt.AcceptChanges();
//}
}
private void button1_Click(object sender, EventArgs e)
{
try{
//abrir la conexión
Conexion c = new Conexion();
String query = "select * from scott.PACIENTE Where num_identificacion_paciente = '" + txt_idpaciente.Text+"'";
Conexion.get_cmd().CommandText = query;
Conexion.get_cmd().CommandType = CommandType.Text;
//Conexion.get_cmd().Parameters.Add("@id_pas", Oracle.DataAccess.Client.OracleDbType.NVarchar2, 9);
//Conexion.get_cmd().Parameters[0].Value = txt_idpaciente.Text;
//****Ejecutamos la consulta mediante un DataReader de Oracle
OracleDataReader reader = Conexion.get_cmd().ExecuteReader();
//***si se quiere en un dataset
//Al adaptador hay que pasarle el string SQL y la Conexión
OracleDataAdapter adapter = new OracleDataAdapter(Conexion.get_cmd());
// DataSet set = new DataSet();
// DataRow DR;
//adapter.Fill(set, "paciente"); //llena el conjunto con la respuesta de la consulta
//DR = set.Tables["paciente"].Rows[0];
if ( reader.Read () )
{
MessageBox.Show("sí existe paciente");
consulta f3 = new consulta(txt_idpaciente.Text);
f3.Show();
this.Hide();
c.Close();
}
else { MessageBox.Show("no existe paciente"); }
}
catch { }
}
private void PesquisarButton_Click(object sender, EventArgs e)
{
StringBuilder sbQuery = new StringBuilder();
sbQuery.Append(query);
try
{
if (!FiltroTextBox.Text.Equals("") && !FiltroComboBox.SelectedItem.ToString().Equals("FORNECEDOR"))
{
sbQuery.Append(" WHERE " + FiltroComboBox.SelectedItem.ToString() + " = " + FiltroTextBox.Text);
}
if (!FiltroTextBox.Text.Equals("") && FiltroComboBox.SelectedItem.ToString().Equals("FORNECEDOR"))
{
sbQuery.Append(" WHERE " + FiltroComboBox.SelectedItem.ToString() + " like '%" + FiltroTextBox.Text + "%'");
}
OracleDataAdapter adpBuscarDados = new OracleDataAdapter(sbQuery.ToString(), conn);
DataTable resultado = new DataTable();
adpBuscarDados.Fill(resultado);
GridPesquisa.DataSource = resultado;
sbQuery.Clear();
}
catch (OracleException)
{
}
}
void MgfLoad()
{
try
{
conn.Open();
// string sqlquery = "SELECT MED_ID,MED_NAME,MED_STG,MED_MGF,MED_BATCH,MED_GROUP,MED_TYPE,COST_PRICE,SELL_PRICE,NOTES FROM MED_INFO";
string sqlquery = "SELECT * FROM MFG_INFO";
OracleCommand cmd = new OracleCommand(sqlquery, conn);
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
dt = new DataTable();
// dt.Columns["MED_NAME"].ColumnName = "Name";
oda.Fill(dt);
BindingSource bsource = new BindingSource();
bsource.DataSource = dt;
dataGridView1.DataSource = bsource;
oda.Update(dt);
dt.Columns[0].ColumnName = "ID";
dt.Columns[1].ColumnName = "Name";
dt.Columns[2].ColumnName = "Address";
dt.Columns[3].ColumnName = "Mobile";
dt.AcceptChanges();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public Object DLookUp(String column,String table,String condition)
{
OracleConnection objConexion;
OracleDataAdapter objComando;
DataSet requestquery = new DataSet();
object result;
objConexion = new OracleConnection(driver);
objConexion.Open();
if(condition.Equals("")){
objComando = new OracleDataAdapter("Select " + column + " from " + table, objConexion);
}
else
{
objComando = new OracleDataAdapter("Select " + column + " from " + table + " where " + condition, objConexion);
}
try
{
objComando.Fill(requestquery);
result = requestquery.Tables[0].Rows[0][requestquery.Tables[0].Columns.IndexOf(column)];
}
catch (Exception e)
{
result = -1;
}
objConexion.Close();
return result;
}
public static DataTable GetItensEstoque()
{
DataTable dt = new DataTable();
OracleDataAdapter da = new OracleDataAdapter();
OracleConnection conn = Conexao.GetInstance();
OracleCommand cmd = new OracleCommand();
try
{
cmd.CommandText = "SELECT * FROM ITEM_ESTOQUE ";
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
da.SelectCommand = cmd;
da.Fill(dt);
return dt;
}
catch (Exception ex)
{
strErrMsg = "Atenção, o sistema detectou o seguinte problema: " + "\r\n" +
"Descrição: " + Convert.ToString(ex.Message) + "\r\n" +
"Origem: " + Convert.ToString(ex.Source);
MessageBox.Show(strErrMsg, "Procedimento: " + Convert.ToString(ex.TargetSite),
MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
protected void GridView_stuff_list_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Del_Btn")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = GridView_stuff_list.Rows[index];
TableCell SID = selectedRow.Cells[0];
Session["SID"] = SID.Text;
string ConnectionString = @"DATA SOURCE=127.0.0.1:1521/XE;PERSIST SECURITY INFO=True;USER ID=TAHMID; Password=anik";
string cmdQuery = "delete from STUFF where STUFF_ID = '" +Session["SID"]+"'";
OracleDataAdapter a = new OracleDataAdapter(cmdQuery, ConnectionString);
OracleCommandBuilder builder = new OracleCommandBuilder(a);
DataSet ds = new DataSet();
a.Fill(ds, "STUFF_delete");
Response.Redirect("stuff_list.aspx");
}
else if (e.CommandName == "edit_Btn")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow selectedRow = GridView_stuff_list.Rows[index];
TableCell SID = selectedRow.Cells[0];
Session["U_SID"] = SID.Text;
Response.Redirect("edit_stuff.aspx");
}
}
/// <summary>
/// 将数据读取到 DataSet 中.
/// </summary>
public void ReadDataToDataSet()
{
Console.WriteLine("使用DataAdapter，将数据填充到DataSet中，然后脱离数据库，直接对DataSet进行处理。");
// 建立数据库连接.
OracleConnection conn = new OracleConnection(connString);
// 创建一个适配器
OracleDataAdapter adapter = new OracleDataAdapter(SQL, conn);
// 创建DataSet，用于存储数据.
DataSet testDataSet = new DataSet();
// 执行查询，并将数据导入DataSet.
adapter.Fill(testDataSet, "result_data");
// 关闭数据库连接.
conn.Close();
// 处理DataSet中的每一行数据.
foreach (DataRow testRow in testDataSet.Tables["result_data"].Rows)
{
// 将检索出来的数据，输出到屏幕上.
Console.WriteLine("NO:{0} ; Date:{1} ; Money:{2} ",
testRow["NO"], testRow["SALE_DATE"], testRow["SUM_MONEY"]
);
}
}
public static DataTable GetItensCompra(int id_ficha_compra)
{
DataTable dt = new DataTable();
OracleDataAdapter da = new OracleDataAdapter();
OracleConnection conn = Conexao.GetInstance();
OracleCommand cmd = new OracleCommand();
try
{
cmd.CommandText = "SELECT * FROM FICHA_DE_COMPRA_ITEM " +
"WHERE ID_FICHA_DE_COMPRA = :Id";
cmd.Parameters.Add(":Id", OracleDbType.Int32).Value = id_ficha_compra;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
da.SelectCommand = cmd;
da.Fill(dt);
return dt;
}
catch (Exception ex)
{
strErrMsg = "Atenção, o sistema detectou o seguinte problema: " + "\r\n" +
"Descrição: " + Convert.ToString(ex.Message) + "\r\n" +
"Origem: " + Convert.ToString(ex.Source);
MessageBox.Show(strErrMsg, "Procedimento: " + Convert.ToString(ex.TargetSite),
MessageBoxButtons.OK, MessageBoxIcon.Error);
return null;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Global.CurrentPerson == null)
Response.Redirect("Index.aspx");
DataTable seasonsTable = new DataTable();
List<Season> seasons = new List<Season>();
using (OracleConnection objConn = new OracleConnection(Global.ConnectionString))
{
// Set up the seasons command
var seasonsCommand = new OracleCommand("TICKETS_QUERIES.getSeasonsForPurchase", objConn) { BindByName = true, CommandType = CommandType.StoredProcedure };
seasonsCommand.Parameters.Add("p_Return", OracleDbType.RefCursor, ParameterDirection.ReturnValue);
seasonsCommand.Parameters.Add("p_PersonId", OracleDbType.Int64, Global.CurrentPerson.person_id, ParameterDirection.Input);
try
{
// Execute the queries and auto map the results to models
objConn.Open();
var seasonsAdapter = new OracleDataAdapter(seasonsCommand);
seasonsAdapter.Fill(seasonsTable);
seasons = Mapper.DynamicMap<IDataReader, List<Season>>(seasonsTable.CreateDataReader());
}
catch (Exception)
{
Response.Redirect("Index.aspx");
}
objConn.Close();
}
// Fill list dropdowns with data from the database
if (seasons.Count > 0)
{
var seasonsWithEvents = seasons.GroupBy(s => s.season_id).Select(season => new Season()
{
season_id = season.First().season_id,
name = season.First().name,
price = season.First().price,
ticket_count = season.First().ticket_count,
event_names = seasons.Where(ev => ev.season_id == season.First().season_id).Select(en => en.event_name).ToList()
}).ToList();
SeasonDropDown.DataTextField = "name";
SeasonDropDown.DataValueField = "season_id";
SeasonDropDown.DataSource = seasonsWithEvents;
SeasonDropDown.DataBind();
SeasonListView.DataSource = seasonsWithEvents;
SeasonListView.DataBind();
}
if (Request.QueryString["Success"] != null)
{
Error.Text = "Successfully purchased season ticket!";
Error.Visible = true;
}
}
}
/// <summary>
/// 根据配置文件中所配置的数据库类型
/// 来创建相应数据库适配器对象
/// </summary>
/// <returns></returns>
public static IDbDataAdapter CreateDataAdapter()
{
IDbDataAdapter adapter = null;
switch (DbHelper.DbType)
{
case DatabaseType.SqlServer:
adapter = new SqlDataAdapter();
break;
case DatabaseType.Oracle:
adapter = new OracleDataAdapter();
break;
case DatabaseType.MySql:
adapter = new MySqlDataAdapter();
break;
case DatabaseType.Access:
adapter = new OleDbDataAdapter();
break;
case DatabaseType.SQLite:
adapter = new SQLiteDataAdapter();
break;
default:
throw new Exception("数据库类型目前不支持！");
}
return adapter;
}
void MedStoreLoad()
{
try
{
conn.Open();
string sqlquery = "SELECT * FROM MED_STORE";
//string sqlquery = "SELECT * FROM MED_INFO";
OracleCommand cmd = new OracleCommand(sqlquery, conn);
OracleDataAdapter oda = new OracleDataAdapter();
oda.SelectCommand = cmd;
dt = new DataTable();
// dt.Columns["MED_NAME"].ColumnName = "Name";
oda.Fill(dt);
BindingSource bsource = new BindingSource();
bsource.DataSource = dt;
dataGridView1.DataSource = bsource;
oda.Update(dt);
dt.Columns[0].ColumnName = "ID";
dt.Columns[1].ColumnName = "Name";
dt.Columns[2].ColumnName = "Quantity";
dt.Columns[3].ColumnName = "Damage Qty";
dt.Columns[4].ColumnName = "Reorder Level";
dt.AcceptChanges();
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DataTable Consulta
(
string pQuery,
string pConnectionString
)
{
DataTable lTable = new DataTable();
DataSet lDataSet = new DataSet();
OracleConnection lConnection = new OracleConnection(pConnectionString);
try
{
lConnection.Open();
OracleDataAdapter lDataAdapter = new OracleDataAdapter(pQuery, pConnectionString);
lDataAdapter.Fill(lDataSet);
lTable = lDataSet.Tables[0];
return lTable;
}
finally
{
lConnection.Close();
}
}
private void setDataGrid()
{
DataTable table = new DataTable();
using (OracleConnection connection = new OracleConnection(FormLogin.connString))
{
String query = "SELECT c.description as Tip, c.value as Coefficient, r.homeTeam as HomeTeam, r.goalshome || ' - ' || r.goalsguest as Result, r.guestteam as GuestTeam"
+ " FROM Computegain c JOIN Results r ON (c.idMatch = r.idMatch) WHERE c.idTipster = "+idTipster;
OracleDataAdapter adapter = new OracleDataAdapter(query, connection);
adapter.Fill(table);
}
dataGrid.DataSource = table;
dataGrid.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
dataGrid.AutoSize = true;
dataGrid.DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomCenter;
dataGrid.Columns["Tip"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight;
dataGrid.Columns["HomeTeam"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomRight;
dataGrid.Columns["GuestTeam"].DefaultCellStyle.Alignment = DataGridViewContentAlignment.BottomLeft;
dataGrid.Columns["GuestTeam"].HeaderText = "Guest Team";
dataGrid.Columns["HomeTeam"].HeaderText = "Home Team";
dataGrid.Columns["Tip"].HeaderText = "Tip";
dataGrid.Columns["Coefficient"].HeaderText = "Coefficient";
dataGrid.Columns["Result"].HeaderText = "Result";
}
public DataTable throwSelect(string sql)
{
DataTable dt = new DataTable();
string ConnectionString = "";
ConnectionString = "DATA SOURCE = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.70)(PORT = 1521)))";
ConnectionString += "(CONNECT_DATA = (SERVICE_NAME = UBIZDB)));";
ConnectionString += "USER ID=RCS;PASSWORD=RCS";
OracleConnection conn = new OracleConnection(ConnectionString);
conn.Open();
OracleCommand oracmd = new OracleCommand();
oracmd.Connection = conn;
oracmd.CommandType = CommandType.Text;
oracmd.CommandText = sql;
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = oracmd;
//adapter.Fill(ds);
adapter.Fill(dt);
return dt;
}
private void button1_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection();
conn.ConnectionString = "User ID=SYSTEM; Password=19; Data Source=PC";
try
{
conn.Open();
MessageBox.Show("Veritabanına Baglantı Basarılı.");
}
catch
{
MessageBox.Show("Veritabanına Baglanılamadı.");
}
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "SELECT ogrenci_tablosu.ogrenci_ad, fakulte_tablosu.fakulte_ad FROM ogrenci_tablosu, bolum_tablosu, fakulte_tablosu WHERE ogrenci_tablosu.ogrenci_bolum = bolum_tablosu.bolum_id AND bolum_tablosu.bolum_fakulte = fakulte_tablosu.fakulte_id";
cmd.Connection = conn;
OracleDataAdapter adapter = new OracleDataAdapter();
adapter.SelectCommand = cmd;
DataSet dataset = new DataSet();
adapter.Fill(dataset);
dataGridView1.DataSource = dataset.Tables[0];
conn.Close();
}
private void button1_Click(object sender, EventArgs e)
{
try{
//abrir la conexión
Conexion c = new Conexion();
String query = "select * from scott.PACIENTE Where num_identificacion_paciente = :id ";
c.get_cmd().CommandText = query;
c.get_cmd().CommandType = CommandType.Text;
//evitamos inyección SQL
c.get_cmd().Parameters.Add("id", txt_idpaciente.Text);
//****Ejecutamos la consulta mediante un DataReader de Oracle
OracleDataReader reader = c.get_cmd().ExecuteReader();
//***si se quiere en un dataset
//Al adaptador hay que pasarle el string SQL y la Conexión
OracleDataAdapter adapter = new OracleDataAdapter(c.get_cmd());
if ( reader.Read () ){
MessageBox.Show("Exsite paciente");
consulta f3 = new consulta(txt_idpaciente.Text);
f3.Show();
this.Hide();
c.Close();
}
else { MessageBox.Show("No existe paciente"); }
}
catch { }
}
protected void Page_Load(object sender, EventArgs e)
{
//todo: (003-xxxDataAdapter) implementar paginação e ordenação para o gridview
#region solução de "implementar paginação e ordenação para o gridview"
GridView1.AllowPaging = GridView1.AllowSorting = true;
GridView1.PageIndexChanging += GridView1PageIndexChanging;
GridView1.Sorting += GridView1Sorting;
ViewState["SORT_DIRECTION"] = ViewState["SORT_DIRECTION"] ?? " ASC";
ViewState["SORT_EXPRESSION"] = ViewState["SORT_EXPRESSION"] ?? "GENREID";
#endregion
var da = new OracleDataAdapter("SELECT * FROM GENRE",
@"DATA SOURCE=127.0.0.1/ORCL;USER ID=chinook;PASSWORD=p4ssw0rd;");
var ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string ab = Session["B_c_package"].ToString();
string cmdQuery = "Select * from Decuration_Package where dec_pack_service = '"+ ab +"' ";
OracleDataAdapter a = new OracleDataAdapter(cmdQuery, ConnectionString);
OracleCommandBuilder builder = new OracleCommandBuilder(a);
DataSet ds = new DataSet();
a.Fill(ds, "Decuration_Package");
foreach (DataRow r in ds.Tables["Decuration_Package"].Rows)
{
ListItem i = new ListItem();
i.Text = r["DEC_PACK_NAME"].ToString();
i.Value = r["DEC_PACK_ID"].ToString();
Session["Decuration_price"]= r["DEC_PACK_PRICE"].ToString();
DropDownList_decuration.Items.Add(i);
}
string cmdQuery2 = "Select * from FOOD_PACKAGE where f_pack_service = '" + ab + "' ";
OracleDataAdapter b = new OracleDataAdapter(cmdQuery2, ConnectionString);
OracleCommandBuilder builder2 = new OracleCommandBuilder(b);
DataSet ds2 = new DataSet();
b.Fill(ds2, "FOOD_PACKAGEes");
foreach (DataRow r in ds2.Tables["FOOD_PACKAGEes"].Rows)
{
ListItem i = new ListItem();
i.Text = r["f_pack_name"].ToString();
i.Value = r["f_pack_id"].ToString();
Session["FOOD_price"] = r["f_pack_price"].ToString();
DropDownList_food_package.Items.Add(i);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string cmdQuery = "Select * from DESIGNATION";
OracleDataAdapter a = new OracleDataAdapter(cmdQuery, ConnectionString);
OracleCommandBuilder builder = new OracleCommandBuilder(a);
DataSet ds = new DataSet();
try
{
a.Fill(ds, "DESIGNATION");
foreach (DataRow r in ds.Tables["DESIGNATION"].Rows)
{
ListItem i = new ListItem();
i.Text = r["D_NAME"].ToString();
i.Value = r["D_ID"].ToString();
Stuff_position_DropDownList.Items.Add(i);
}
show_ts(1);
}
catch(Exception er)
{
Response.Write("<script language= 'javascript'>alart('Connection Problem');</script>");
}
finally { }
}
}
public void changeChartView()
{
using (OracleConnection connection = new OracleConnection(FormLogin.connString))
{
connection.Open();
String query = "SELECT m.idround as round, p.Match_Rating FROM participates p JOIN match m ON(p.idMatch = m.idMatch) WHERE p.idPlayer = "+Player.Id+" ORDER BY m.idRound";
DataTable table = new DataTable();
OracleDataAdapter dataAdapter = new OracleDataAdapter(query, connection);
dataAdapter.Fill(table);
chartPlayerRating.DataSource = table;
chartPlayerRating.Series["Series1"].XValueMember = "Round";
chartPlayerRating.Series["Series1"].YValueMembers = "Match_Rating";
}
chartPlayerRating.ChartAreas["ChartArea1"].AxisX.Title = "Rounds";
chartPlayerRating.ChartAreas["ChartArea1"].AxisX.Minimum = 1;
chartPlayerRating.ChartAreas["ChartArea1"].AxisX.Maximum = 38;
chartPlayerRating.ChartAreas["ChartArea1"].AxisX.Interval = 1;
chartPlayerRating.ChartAreas["ChartArea1"].AxisY.Title = "Rankings";
chartPlayerRating.ChartAreas["ChartArea1"].AxisY.Minimum = 1000;
chartPlayerRating.ChartAreas["ChartArea1"].AxisY.Maximum = 3000;
chartPlayerRating.ChartAreas["ChartArea1"].Visible = true;
chartPlayerRating.Series["Series1"].BorderWidth = 3;
}
private void LoginRandomEmployee()
{
DataTable employeeTable = new DataTable();
Person employee = null;
using (OracleConnection objConn = new OracleConnection(Global.ConnectionString))
{
OracleCommand objCmd = new OracleCommand("TICKETS_QUERIES.getRandomEmployee", objConn) { BindByName = true, CommandType = CommandType.StoredProcedure };
objCmd.Parameters.Add("p_Return", OracleDbType.RefCursor, ParameterDirection.ReturnValue);
try
{
objConn.Open();
OracleDataAdapter adapter = new OracleDataAdapter(objCmd);
adapter.Fill(employeeTable);
employee = Mapper.DynamicMap<IDataReader, List<Person>>(employeeTable.CreateDataReader()).FirstOrDefault();
}
catch (Exception)
{
Response.Redirect("../Default.aspx");
}
objConn.Close();
}
if (employee != null)
{
Global.CurrentPerson = employee;
Global.CurrentPerson.accountType = Account.Faculty;
}
else
Response.Redirect("../Default.aspx");
}
private GroupRequest addPersonToGroup(int personId, int seriesId)
{
DataTable groupTable = new DataTable();
GroupRequest groupResult = new GroupRequest();
using (OracleConnection objConn = new OracleConnection(Global.ConnectionString))
{
// Set up the searchPeople command
var command = new OracleCommand("TICKETS_API.insertGroupRequests", objConn) { BindByName = true, CommandType = CommandType.StoredProcedure };
command.Parameters.Add("p_Return", OracleDbType.RefCursor, ParameterDirection.ReturnValue);
command.Parameters.Add("p_PersonId", OracleDbType.Int64, Global.CurrentPerson.person_id, ParameterDirection.Input);
command.Parameters.Add("p_RequestedId", OracleDbType.Int64, personId, ParameterDirection.Input);
command.Parameters.Add("p_SeriesId", OracleDbType.Int64, seriesId, ParameterDirection.Input);
// Execute the query and map the results to models
objConn.Open();
var groupAdapter = new OracleDataAdapter(command);
groupAdapter.Fill(groupTable);
groupResult.group_id = long.Parse(groupTable.Rows[0]["group_id"].ToString());
groupResult.requested_id = long.Parse(groupTable.Rows[0]["requested_id"].ToString());
groupResult.requested_firstname = groupTable.Rows[0]["requested_firstname"].ToString();
groupResult.requested_lastname = groupTable.Rows[0]["requested_lastname"].ToString();
objConn.Close();
}
return groupResult;
}
public DataSet GetProdOCRData(string queryName,string startDate, string endDate)
{
string queryPath = string.Format(@"{0}\Query\{1}", Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location),queryName);
string query = File.ReadAllText(queryPath);
query = string.Format(query, startDate, endDate);
DataSet ds = new DataSet();
using (oraconnection = new OracleConnection(ConfigurationManager.AppSettings["DSN_PNRP"]))
{
try
{
oraconnection.Open();
oracommand = new OracleCommand(query, oraconnection);
oracommand.CommandType = CommandType.Text;
OracleDataAdapter adp = new OracleDataAdapter(oracommand);
ds = new DataSet();
adp.Fill(ds);
}
catch (Exception)
{
}
finally
{
oraconnection.Close();
}
return ds;
}
}
private void btn_hyouji_Click(object sender, EventArgs e)
{
try
{
dt.Rows.Clear();
dt.Columns.Clear();
dt.Clear();
TssSystemLibrary tssdb = new TssSystemLibrary();
string connStr = tssdb.GetConnectionString();
OracleConnection conn = new OracleConnection(connStr);
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
string sql = "select * from " + cb_table_name.Text;
if (tb_sql.Text.Length >= 1)
{
sql = sql + " " + tb_sql.Text;
}
cmd.CommandText = sql;
da = new OracleDataAdapter(cmd);
cb = new OracleCommandBuilder(da);
das = new DataSet();
da.Fill(dt);
dgv_table.DataSource = null;
dgv_table.DataSource = dt;
}
catch
{
dgv_table.DataSource = null;
}
}
public DataTable ChiTietDuAn(string mdv, string nsd, string pas, string maDonVi, long idDuAn)
{
try
{
ConnectDB.CloseConnection(_connectGs);
_connectGs = new OracleConnection();
_connectGs = ConnectDB.GetOracleConnection(_connectGs);
var cm = _connectGs.CreateCommand();
cm.CommandText = "usp_ChiTiet_DuAn";
cm.CommandType = CommandType.StoredProcedure;
cm.Parameters.Add(new OracleParameter("ma_donvi", OracleDbType.Varchar2)).Value = "";
cm.Parameters.Add(new OracleParameter("nsd", OracleDbType.Varchar2)).Value = "";
cm.Parameters.Add(new OracleParameter("pas", OracleDbType.Varchar2)).Value = "";
cm.Parameters.Add(new OracleParameter("id_duan", OracleDbType.Long)).Value = idDuAn;
cm.Parameters.Add(new OracleParameter("ma_donvi_thuchien", OracleDbType.Varchar2)).Value = maDonVi;
cm.Parameters.Add(new OracleParameter("cs_lke", OracleDbType.RefCursor)).Direction =
ParameterDirection.Output;
var tableGs = new DataTable();
_oracleAdapter = new OracleDataAdapter(cm);
_oracleAdapter.Fill(tableGs);
return tableGs;
}
catch (Exception)
{
return null;
}
finally
{
ConnectDB.CloseConnection(_connectGs);
}
}
protected void con_btn_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(TextBox_ad_pay.Text))
{
LabelMessage.Text = "Advance Payment is empty";
TextBox_ad_pay.Focus();
}
else
{
int advanced = Convert.ToInt32(TextBox_ad_pay.Text);
int due = Convert.ToInt32( Session["total_price"]) - advanced;
string ConnectionString = @"DATA SOURCE=127.0.0.1:1521/XE;PERSIST SECURITY INFO=True;USER ID=TAHMID; Password=anik";
string cmdQuery = "insert into CLIENT(C_ID, C_NAME, C_PHONE, C_EMAIL, C_ADDRESS, C_GUEST, C_SERVICE_ID, C_F_PACK_ID, C_D_PACK_ID, C_R_TIME, C_R_DATE) values (client_seq.NEXTVAL, '" + Session["B_c_name"] + "', '" + Session["B_c_phone"] + "', '" + Session["B_c_email"] + "', '" + Session["B_c_address"] + "', '" + Session["gest"] + "', '" + Session["B_c_package"] + "', '" + Session["f_package"] + "', '" + Session["d_package"] + "', '" + Session["r_date"] + "', '" + Session["r_time"] + "' )";
OracleDataAdapter a = new OracleDataAdapter(cmdQuery, ConnectionString);
OracleCommandBuilder builder = new OracleCommandBuilder(a);
DataSet ds = new DataSet();
a.Fill(ds, "client");
string cmdquery2 = "Select C_ID from CLIENT where C_NAME = '" + Session["B_c_name"] + "' and C_PHONE = '" + Session["B_c_phone"] + "' ";
OracleDataAdapter b = new OracleDataAdapter(cmdquery2, ConnectionString);
OracleCommandBuilder builder2 = new OracleCommandBuilder(b);
DataSet ds2 = new DataSet();
b.Fill(ds2, "client_id");
int cid = Convert.ToInt32(ds2.Tables["client_id"].Rows[0]["C_ID"]);
string cmdQuery3 = "insert into COST(CO_ID, CO_C_ID, CO_DEC, CO_F_PR, CO_F_TOTAL, CO_TOTAL, CO_ADVANCED, CO_DUE) values (cost_seq.NEXTVAL, '" + cid + "','" + Session["Decuration_price"] + "', '" + Session["FOOD_price"] + "' ,'" + Session["total_f_price"] + "', '" + Session["total_price"] + "', '" + advanced + "', '" + due + "')";
OracleDataAdapter c = new OracleDataAdapter(cmdQuery3, ConnectionString);
OracleCommandBuilder builder3 = new OracleCommandBuilder(c);
DataSet ds3 = new DataSet();
c.Fill(ds3, "COST");
Response.Redirect("booking.aspx");
}
}
public object DLookUp(String column, string table, string condition)
{
OracleConnection objConexion = default(OracleConnection);
OracleDataAdapter objComando = default(OracleDataAdapter);
DataSet requestquery = new DataSet();
object result = null;
objConexion = new OracleConnection(driver);
objConexion.Open();
if (string.IsNullOrEmpty(condition))
{
objComando = new OracleDataAdapter("Select " + column + " from " + table, objConexion);
}
else
{
objComando = new OracleDataAdapter("Select " + column + " from " + table + " where " + condition, objConexion);
}
objComando.Fill(requestquery);
try
{
result = requestquery.Tables[0].Rows[0][requestquery.Tables[0].Columns.IndexOf(column)];
}
catch (Exception ex)
{
result = -1;
}
objConexion.Close();
return result;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["USER_NAME"] != null)
{
string requestedFile = Path.GetFileName(Request.Path);
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
string makeSQL = " SELECT NUPP.IS_PAGE_ACTIVE, NUPP.IS_ADD_ACTIVE, NUPP.IS_EDIT_ACTIVE, NUPP.IS_DELETE_ACTIVE, NUPP.IS_VIEW_ACTIVE FROM NRC_USER_PAGE_PERMISSION NUPP LEFT JOIN NRC_USER_PAGES NUP ON NUP.USER_PAGE_ID = NUPP.USER_PAGE_ID WHERE NUPP.USER_ID = '" + Session["USER_ID"] + "' AND NUP.IS_ACTIVE = 'Enable' AND NUP.PAGE_URL = '" + requestedFile + "' ";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
IS_PAGE_ACTIVE = dt.Rows[i]["IS_PAGE_ACTIVE"].ToString();
IS_ADD_ACTIVE = dt.Rows[i]["IS_ADD_ACTIVE"].ToString();
IS_EDIT_ACTIVE = dt.Rows[i]["IS_EDIT_ACTIVE"].ToString();
IS_DELETE_ACTIVE = dt.Rows[i]["IS_DELETE_ACTIVE"].ToString();
IS_VIEW_ACTIVE = dt.Rows[i]["IS_VIEW_ACTIVE"].ToString();
}
if (IS_PAGE_ACTIVE == "Enable")
{
if (!IsPostBack)
{
DataTable dtEmpID = new DataTable();
DataSet ds = new DataSet();
string makeEmpSQL = " SELECT EMP_ID, EMP_ID || ' - ' || EMP_FNAME || ' ' || EMP_LNAME AS EMP_NAME from HR_EMPLOYEES WHERE IS_ACTIVE = 'Enable' ORDER BY EMP_ID ASC";
ds = ExecuteBySqlString(makeEmpSQL);
dtEmpID = (DataTable)ds.Tables[0];
DropDownEmployeeID.DataSource = dtEmpID;
DropDownEmployeeID.DataValueField = "EMP_ID";
DropDownEmployeeID.DataTextField = "EMP_NAME";
DropDownEmployeeID.DataBind();
DropDownEmployeeID.Items.Insert(0, new ListItem("Select Employee", "0"));
DataTable dtItemID = new DataTable();
DataSet di = new DataSet();
string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON AI.ITEM_ID = IAEI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE AI.IS_ACTIVE = 'Enable' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC";
di = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)di.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "EMP_ITEMS_ID";
DropDownItemID.DataTextField = "ITEM_NAME_ALL";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
DataTable dtItemExpID = new DataTable();
DataSet die = new DataSet();
string makeItemExpSQL = " SELECT AIE.ITEM_EXP_ID, AIE.ITEM_EXP_NAME from IT_ASSET_ITEM_EXPIRES AIE LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AIE.ITEM_CATEGORY_ID WHERE AIE.IS_ACTIVE = 'Enable' ORDER BY AIE.ITEM_EXP_ID ASC";
die = ExecuteBySqlString(makeItemExpSQL);
dtItemExpID = (DataTable)die.Tables[0];
DropDownItemExpID.DataSource = dtItemExpID;
DropDownItemExpID.DataValueField = "ITEM_EXP_ID";
DropDownItemExpID.DataTextField = "ITEM_EXP_NAME";
DropDownItemExpID.DataBind();
DropDownItemExpID.Items.Insert(0, new ListItem("Select Item Expire", "0"));
DataTable dtDepartmentID = new DataTable();
DataSet dep = new DataSet();
string makeDepartmentSQL = " SELECT * FROM HR_EMP_DEPARTMENTS WHERE IS_ACTIVE = 'Enable' ORDER BY DEPARTMENT_ID ASC";
dep = ExecuteBySqlString(makeDepartmentSQL);
dtDepartmentID = (DataTable)dep.Tables[0];
DropDownDepartmentID.DataSource = dtDepartmentID;
DropDownDepartmentID.DataValueField = "DEPARTMENT_ID";
DropDownDepartmentID.DataTextField = "DEPARTMENT_NAME";
DropDownDepartmentID.DataBind();
DropDownDepartmentID.Items.Insert(0, new ListItem("Select Department", "0"));
DataTable dtDivisionID = new DataTable();
DataSet dsd = new DataSet();
string makeDivisionSQL = " SELECT * FROM HR_EMP_DIVISIONS WHERE IS_ACTIVE = 'Enable' ORDER BY DIVISION_ID ASC";
dsd = ExecuteBySqlString(makeDivisionSQL);
dtDivisionID = (DataTable)dsd.Tables[0];
DropDownDivisionID.DataSource = dtDivisionID;
DropDownDivisionID.DataValueField = "DIVISION_ID";
DropDownDivisionID.DataTextField = "DIVISION_NAME";
DropDownDivisionID.DataBind();
DropDownDivisionID.Items.Insert(0, new ListItem("Select Division", "0"));
DataTable dtLocationID = new DataTable();
DataSet dsl = new DataSet();
string makeLocationSQL = " SELECT * FROM HR_EMP_LOCATIONS WHERE IS_ACTIVE = 'Enable' ORDER BY LOCATION_ID ASC";
dsl = ExecuteBySqlString(makeLocationSQL);
dtLocationID = (DataTable)dsl.Tables[0];
DropDownLocationID.DataSource = dtLocationID;
DropDownLocationID.DataValueField = "LOCATION_ID";
DropDownLocationID.DataTextField = "LOCATION_NAME";
DropDownLocationID.DataBind();
DropDownLocationID.Items.Insert(0, new ListItem("Select Location", "0"));
DataTable dtPlacementID = new DataTable();
DataSet depl = new DataSet();
string makePlacementSQL = " SELECT * FROM IT_ASSET_ITEMS_PLACEMENT WHERE IS_ACTIVE = 'Enable' ORDER BY PLACEMENT_ID ASC";
depl = ExecuteBySqlString(makePlacementSQL);
dtPlacementID = (DataTable)depl.Tables[0];
DropDownPlacementID.DataSource = dtPlacementID;
DropDownPlacementID.DataValueField = "PLACEMENT_ID";
DropDownPlacementID.DataTextField = "PLACEMENT_NAME";
DropDownPlacementID.DataBind();
DropDownPlacementID.Items.Insert(0, new ListItem("Select Placement", "0"));
// Display();
DropDownItemID.Attributes.Add("disabled", "disabled");
// TextQrImage.Visible = false;
alert_box.Visible = false;
ExpDept.Visible = false;
}
IsLoad = false;
}
else
{
Response.Redirect("~/PagePermissionError.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
}
private void Form1_Load(object sender, EventArgs e)
{
string Return_Value;
System.Windows.Forms.Form.CheckForIllegalCrossThreadCalls = false;//线程处理后的错误处理控件任然可以赋值
Return_Value = INIExists(inifile);
if (!String.IsNullOrEmpty(Return_Value))
{
MessageBox.Show(Return_Value);
}
StringBuilder objStrBd = new StringBuilder(256);
GetPrivateProfileString("EQUIPMENT", "INSTRUMENTID", "", objStrBd, 256, FileName);
instrument_id = objStrBd.ToString();
textBox2.Text = INIHelper.getInstance().IniReadValue("EQUIPMENT", "Encode");
string orgID = INIHelper.getInstance().IniReadValue("EQUIPMENT", "Agencies");
string sql = "select 资源id,简称 from 机构 where 资源id='in_机构id'";
sql = sql.Replace("in_机构id", orgID);
DataTable orgName = OracleHelper.GetDataTable(sql);
if (orgName.Rows.Count > 0)
{
textBox1.Text = orgName.Rows[0]["简称"].ToString();
}
using (OracleConnection _connection = new OracleConnection(OracleHelper.GetConnectionstring()))
{
DataTable dt = new DataTable();
ListViewItem item = new ListViewItem();
try
{
_connection.Open();
OracleDataAdapter da = new OracleDataAdapter();
da.SelectCommand = new OracleCommand("select id,名称 from 检验仪器 where instr('" + instrument_id + "',id)>0", _connection);
da.Fill(dt);
bolLongin = true;
}
catch (Exception exs)
{
LoginForm log = new LoginForm();
if (log.ShowDialog() == DialogResult.OK)
{
bolLongin = true;
}
else
{
Application.Exit();
}
}
finally { _connection.Close(); }
lv_Device.Items.Clear();
foreach (DataRow i in dt.Rows)
{
item = lv_Device.Items.Add(i["名称"].ToString(), 1);
item.Tag = i["id"].ToString();
lv_Device.Columns[2].Text = "0";
}
}
if (lv_Device.Items.Count > 0)
{
but_begin.Enabled = false;
but_end.Enabled = true;
bolCon = true;
backgroundWorker1.RunWorkerAsync();
}
this.WindowState = FormWindowState.Minimized;
this.Visible = false;
this.notifyIcon1.Visible = true;
this.SizeChanged += new System.EventHandler(this.Form1_SizeChanged);
}
public void consulta_cortador_porID()
{
string ID_Cortador = Request.QueryString["idlector"];
lb_id_cortador.Text = Convert.ToString(Request.QueryString["idlector"]).Trim(' ');
lbRutEmpresa.Visible = false; //CAMPO OCULTO --- RUT de la empresa
lbIDRegion.Visible = false; // CAMPO OCULTO --- ID de Region del Lector
string sSQL = null;
OracleDataAdapter objComando = null; //OleDbDataAdapter
DataTable dtLectores = new DataTable();
OracleConnection objConexion = new OracleConnection(conexion_cliente_oracle); //OleDbConnection(conexion)
objConexion.Open();
sSQL = "select * from instalador where id_instalador=" + ID_Cortador; // Para rellenar combo
objComando = new OracleDataAdapter(sSQL, conexion_cliente_oracle);
objComando.Fill(dtLectores);
objConexion.Close();
objConexion.Dispose();
dt = new DataTable();
dt.Columns.Add(new DataColumn("id_instalador", typeof(string)));
dt.Columns.Add(new DataColumn("id_region", typeof(string)));
dt.Columns.Add(new DataColumn("id_zona", typeof(string)));
dt.Columns.Add(new DataColumn("rut_empresa", typeof(string)));
dt.Columns.Add(new DataColumn("cod_instalador", typeof(string)));
dt.Columns.Add(new DataColumn("apellido", typeof(string)));
dt.Columns.Add(new DataColumn("nombre", typeof(string)));
dt.Columns.Add(new DataColumn("nom_empresa", typeof(string)));
dt.Columns.Add(new DataColumn("clave_admin", typeof(string)));
dt.Columns.Add(new DataColumn("clave_instalador", typeof(string)));
dt.Columns.Add(new DataColumn("estado", typeof(string)));
dt.Columns.Add(new DataColumn("cantidad", typeof(string)));
dt.Columns.Add(new DataColumn("fotografia", typeof(string)));
dt.Columns.Add(new DataColumn("numero_telefono", typeof(string)));
dt.Columns.Add(new DataColumn("serie_maquina", typeof(string)));
dt.Columns.Add(new DataColumn("id_modelo", typeof(string)));
dt.Columns.Add(new DataColumn("id_contratista", typeof(string)));
dt.Columns.Add(new DataColumn("email", typeof(string)));
dt.Columns.Add(new DataColumn("forma_gestion", typeof(string)));
DataRow dr = null;
foreach (System.Data.DataRow drLectorItem in dtLectores.Rows)
{
dr = dt.NewRow();
dr["id_instalador"] = drLectorItem["id_instalador"].ToString();
dr["id_region"] = drLectorItem["id_region"].ToString();
dr["id_zona"] = drLectorItem["id_zona"].ToString();
dr["rut_empresa"] = drLectorItem["rut_empresa"].ToString();
dr["cod_instalador"] = drLectorItem["cod_instalador"].ToString();
dr["apellido"] = drLectorItem["apellido"].ToString();
dr["nombre"] = drLectorItem["nombre"].ToString();
dr["nom_empresa"] = "EMPRESA"; //OBTIENE_NOMBRE_EMPRESA(drUsuarioItem("rut_empresa").ToString) '"Empresa" 'Funcion que entrege Empresa 'drUsuarioItem("nom_empresa").ToString
dr["clave_admin"] = drLectorItem["clave_admin"].ToString();
dr["clave_instalador"] = drLectorItem["clave_instalador"].ToString();
dr["estado"] = drLectorItem["estado"].ToString();
dr["cantidad"] = drLectorItem["cantidad"].ToString();
dr["fotografia"] = drLectorItem["fotografia"].ToString();
dr["numero_telefono"] = drLectorItem["numero_telefono"].ToString();
dr["serie_maquina"] = drLectorItem["serie_maquina"].ToString();
dr["id_modelo"] = drLectorItem["id_modelo"].ToString();
dr["id_contratista"] = drLectorItem["id_contratista"].ToString();
dr["email"] = drLectorItem["email"].ToString();
dr["forma_gestion"] = drLectorItem["forma_gestion"].ToString();
dt.Rows.Add(dr);
}
txt_codLector.Text = dt.Rows[0]["cod_instalador"].ToString();
txt_nomLector.Text = dt.Rows[0]["nombre"].ToString();
txt_apeLector.Text = dt.Rows[0]["apellido"].ToString();
txt_claveAdmin.Text = dt.Rows[0]["clave_admin"].ToString();
txt_ClaveInstalador.Text = dt.Rows[0]["clave_instalador"].ToString();
lbRutEmpresa.Text = dt.Rows[0]["rut_empresa"].ToString();
lbIDRegion.Text = dt.Rows[0]["id_region"].ToString();
txt_cantidad.Text = dt.Rows[0]["cantidad"].ToString();
combo_fotografia.SelectedValue = dt.Rows[0]["fotografia"].ToString();
//'''''''
txt_num_celular.Text = dt.Rows[0]["numero_telefono"].ToString();
txt_serie_maquina.Text = dt.Rows[0]["serie_maquina"].ToString();
combo_modelo.Text = dt.Rows[0]["id_modelo"].ToString();
//''''''''''''''
combo_regiones.Text = dt.Rows[0]["id_region"].ToString();
Llena_combo_zonas(combo_regiones.Items[combo_regiones.SelectedIndex].Value, 0.ToString());
combo_zonaLector.Text = dt.Rows[0]["id_zona"].ToString();
//combo_estado_lector.Items(combo_estado_lector.SelectedIndex).Value = dt.Rows(0).Item("estado").ToString();
combo_estado_lector.SelectedValue = dt.Rows[0]["estado"].ToString();
combo_contratistas.SelectedValue = dt.Rows[0]["id_contratista"].ToString();
txt_email.Text = dt.Rows[0]["email"].ToString().Trim(' ');
if (dt.Rows[0]["forma_gestion"].ToString().Trim(' ') == "PDA")
{
cmb_formagestion.SelectedIndex = 0; //Utiliza PDA
}
else
{
cmb_formagestion.SelectedIndex = 1; //Utiliza PAPEL
}
//Response.Write(dt.Rows(0).Item("id_zona").ToString)
//Response.End()
//Llena_combo_zonas(lbIDRegion.Text, dt.Rows(0).Item("id_zona").ToString)
//llena_combo_regiones(lbRutEmpresa.Text)
//Dim MydataView As DataView
//MydataView = New DataView(dt)
//GrillaUsuarios.DataSource = MydataView
//GrillaUsuarios.DataBind()
}
public void carga_ruta(int proceso, int localidad, int instalacion, int sincro, String ruta, int tipo, String desde, String hasta, int zona, string contratista)
{
OracleConnection objConexion = new OracleConnection(conexion_cliente_oracle);
OracleDataAdapter objComando;
DataSet objDS = new DataSet();
int id_servicio;
int numero_orden;
if (TextboxNumOrden.Text == "")
{
numero_orden = 0;
}
else
{
numero_orden = int.Parse(TextboxNumOrden.Text);
}
if (txtServ.Text == "")
{
id_servicio = 0;
}
else
{
id_servicio = int.Parse(txtServ.Text);
}
String rutaXml = Server.MapPath("./sessiones/") + "usuario_" + Session.SessionID + ".xml";
int id_contratis = int.Parse(PRO.recSession(rutaXml, "ID_CONTRATISTA"));
objConexion.Open();
objComando = new OracleDataAdapter("PRUEBAS.CARGAR_RUTA2", objConexion);
objComando.SelectCommand.CommandType = CommandType.StoredProcedure;
PRO.agrega_parametro_sp(objComando, "o_cursor", OracleType.Cursor, ParameterDirection.Output, "");
PRO.agrega_parametro_sp(objComando, "i_proceso", OracleType.Int32, ParameterDirection.Input, proceso.ToString());
PRO.agrega_parametro_sp(objComando, "i_localidad", OracleType.Int32, ParameterDirection.Input, localidad.ToString());
PRO.agrega_parametro_sp(objComando, "i_instalacion", OracleType.Int32, ParameterDirection.Input, instalacion.ToString());
PRO.agrega_parametro_sp(objComando, "i_idSincro", OracleType.Int32, ParameterDirection.Input, sincro.ToString());
PRO.agrega_parametro_sp(objComando, "i_ruta", OracleType.NVarChar, ParameterDirection.Input, ruta);
PRO.agrega_parametro_sp(objComando, "i_tipo", OracleType.Int32, ParameterDirection.Input, tipo.ToString());
PRO.agrega_parametro_sp(objComando, "i_rutem", OracleType.NVarChar, ParameterDirection.Input, PRO.recSession(rutaXml, "RUT_EMPRESA"));
PRO.agrega_parametro_sp(objComando, "i_fechaDesde", OracleType.NVarChar, ParameterDirection.Input, desde);
PRO.agrega_parametro_sp(objComando, "i_fechaHasta", OracleType.NVarChar, ParameterDirection.Input, hasta);
PRO.agrega_parametro_sp(objComando, "i_serv", OracleType.Int32, ParameterDirection.Input, id_servicio.ToString());
PRO.agrega_parametro_sp(objComando, "i_idZona", OracleType.Int32, ParameterDirection.Input, zona.ToString());
PRO.agrega_parametro_sp(objComando, "i_numero_orden", OracleType.Int32, ParameterDirection.Input, numero_orden.ToString()); //
if (id_contratis == 0)
{ // Muestra todos los contratistas
PRO.agrega_parametro_sp(objComando, "i_id_contratista", OracleType.NVarChar, ParameterDirection.Input, contratista.ToString());
}
else
{ // Muestra solo el contratista que tiene asignado
PRO.agrega_parametro_sp(objComando, "i_id_contratista", OracleType.NVarChar, ParameterDirection.Input, id_contratis.ToString());
}
try
{
objComando.SelectCommand.ExecuteNonQuery();
objComando.Fill(objDS, "RUTA");
objConexion.Close();
}
catch (Exception ex)
{
}
int i = 1;
ddRuta.Items.Clear();
ddRuta.Items.Add("Todas...");
ddRuta.Items[0].Value = "0";
foreach (DataRow row in objDS.Tables["RUTA"].Rows)
{
ddRuta.Items.Add(row[0].ToString());
ddRuta.Items[i].Value = row[0].ToString();
i = i + 1;
}
}
public void carga_grilla(int proceso, int localidad, int instalacion, int sincro, String ruta, int tipo, String desde, String hasta, int zona, string contratista)
{
String rutaXml = Server.MapPath("./sessiones/") + "usuario_" + Session.SessionID + ".xml";
int id_contratis = 0;
id_contratis = int.Parse(PRO.recSession(rutaXml, "ID_CONTRATISTA"));
OracleConnection CnOra = new OracleConnection(conexion_cliente_oracle);
OracleCommand cmdAcceso = new OracleCommand("PK_CAMBIO_PROCESO.CARGAR_ORDENES", CnOra);
OracleDataAdapter da = new OracleDataAdapter(cmdAcceso);
// PONE VISIBLE LA COLUMNA ID_SINCRONIZACION Y ID_ORDEN PARA LLENARLA
//(SI NO SE PONE VISIBLE NO SE LLENA)
gridOrden.Columns[17].Visible = true;
gridOrden.Columns[0].Visible = true;
PRO.agrega_parametro_sp(da, "o_cursor", OracleType.Cursor, ParameterDirection.Output, "");
PRO.agrega_parametro_sp(da, "i_proceso", OracleType.Int32, ParameterDirection.Input, proceso.ToString());
if (TextboxNumOrden.Text == "")
{
TextboxNumOrden.Text = "0";
}
if (txtServ.Text == "")
{
txtServ.Text = "0";
}
PRO.agrega_parametro_sp(da, "i_numero_orden", OracleType.Number, ParameterDirection.Input, TextboxNumOrden.Text);
PRO.agrega_parametro_sp(da, "i_localidad", OracleType.Int32, ParameterDirection.Input, localidad.ToString());
PRO.agrega_parametro_sp(da, "i_instalacion", OracleType.Int32, ParameterDirection.Input, instalacion.ToString());
PRO.agrega_parametro_sp(da, "i_idSincro", OracleType.Int32, ParameterDirection.Input, sincro.ToString());
PRO.agrega_parametro_sp(da, "i_ruta", OracleType.NVarChar, ParameterDirection.Input, ruta);
PRO.agrega_parametro_sp(da, "i_tipo", OracleType.Int32, ParameterDirection.Input, tipo.ToString());
PRO.agrega_parametro_sp(da, "i_rutem", OracleType.NVarChar, ParameterDirection.Input, PRO.recSession(rutaXml, "RUT_EMPRESA"));
PRO.agrega_parametro_sp(da, "i_fechaDesde", OracleType.NVarChar, ParameterDirection.Input, desde);
PRO.agrega_parametro_sp(da, "i_fechaHasta", OracleType.NVarChar, ParameterDirection.Input, hasta);
PRO.agrega_parametro_sp(da, "i_serv", OracleType.Int32, ParameterDirection.Input, txtServ.Text);
PRO.agrega_parametro_sp(da, "i_idZona", OracleType.Int32, ParameterDirection.Input, zona.ToString());
PRO.agrega_parametro_sp(da, "i_id_contratista", OracleType.NVarChar, ParameterDirection.Input, contratista);
//i_id_contratista
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dtOrdenes = new DataTable();
try
{
CnOra.Open();
da.Fill(dtOrdenes);
CnOra.Close();
CnOra.Dispose();
}
catch (Exception ex)
{
lbErrorGrilla.Text = ex.ToString() + txtServ.Text;
lbErrorGrilla.ForeColor = System.Drawing.Color.Red;
lbErrorGrilla.Text = ex.ToString() + TextboxNumOrden.Text;
lbErrorGrilla.ForeColor = System.Drawing.Color.Red;
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ID_ORDEN", typeof(String)));
dt.Columns.Add(new DataColumn("NUMERO_ORDEN", typeof(String))); //
dt.Columns.Add(new DataColumn("FECHA_CREACION", typeof(String)));
dt.Columns.Add(new DataColumn("ID_SERVICIO", typeof(String)));
dt.Columns.Add(new DataColumn("RUTA", typeof(String)));
dt.Columns.Add(new DataColumn("GESTION_CORTE", typeof(String)));
dt.Columns.Add(new DataColumn("TIPO_MARCA_DI", typeof(String)));
dt.Columns.Add(new DataColumn("SERIE_MEDIDOR", typeof(String)));
dt.Columns.Add(new DataColumn("DIRECCION", typeof(String)));
dt.Columns.Add(new DataColumn("CLIENTE", typeof(String)));
dt.Columns.Add(new DataColumn("OBSERVACION_IN", typeof(String)));
dt.Columns.Add(new DataColumn("LOCALIDAD", typeof(String)));
dt.Columns.Add(new DataColumn("ID_PROCESO", typeof(Int32)));
dt.Columns.Add(new DataColumn("GRUPO_PROCESO", typeof(String)));
dt.Columns.Add(new DataColumn("ID_TIPO_PROCESO", typeof(Int32)));
dt.Columns.Add(new DataColumn("DETALLE", typeof(String)));
dt.Columns.Add(new DataColumn("ESTADO", typeof(String)));
dt.Columns.Add(new DataColumn("ID_SINCRONIZACION", typeof(Int32)));
dt.Columns.Add(new DataColumn("DESCRIPCION", typeof(String)));
dt.Columns.Add(new DataColumn("NOMBRE", typeof(String)));
dt.Columns.Add(new DataColumn("APELLIDO", typeof(String)));
dt.Columns.Add(new DataColumn("FECHA_INTEGRACION", typeof(String)));
dt.Columns.Add(new DataColumn("dias_transcurridos", typeof(Int32)));
dt.Columns.Add(new DataColumn("CONTRATISTA", typeof(String)));
DataRow dr;
int total = 0;
foreach (DataRow drOrdenItem in dtOrdenes.Rows)
{
dr = dt.NewRow();
dr["ID_ORDEN"] = drOrdenItem["ID_ORDEN"].ToString();
dr["FECHA_CREACION"] = drOrdenItem["FECHA_CREACION"].ToString().Replace(" 0:00:00", "");
dr["NUMERO_ORDEN"] = drOrdenItem["NUMERO_ORDEN"].ToString();//
dr["ID_SERVICIO"] = drOrdenItem["ID_SERVICIO"].ToString();
dr["RUTA"] = drOrdenItem["RUTA"].ToString();
dr["GESTION_CORTE"] = drOrdenItem["GESTION_CORTE"].ToString();
dr["TIPO_MARCA_DI"] = drOrdenItem["TIPO_MARCA_DI"].ToString();
dr["SERIE_MEDIDOR"] = drOrdenItem["SERIE_MEDIDOR"].ToString();
dr["DIRECCION"] = drOrdenItem["DIRECCION"].ToString();
dr["CLIENTE"] = drOrdenItem["CLIENTE"].ToString();
dr["OBSERVACION_IN"] = drOrdenItem["OBSERVACION_IN"].ToString();
dr["LOCALIDAD"] = drOrdenItem["LOCALIDAD"].ToString();
dr["ID_PROCESO"] = drOrdenItem["ID_PROCESO"].ToString();
dr["GRUPO_PROCESO"] = drOrdenItem["GRUPO_PROCESO"].ToString();
dr["ID_TIPO_PROCESO"] = drOrdenItem["ID_TIPO_PROCESO"].ToString();
dr["DETALLE"] = drOrdenItem["DETALLE"].ToString();
dr["ESTADO"] = drOrdenItem["DESCRIPCION"].ToString();
dr["ID_SINCRONIZACION"] = drOrdenItem["ID_SINCRONIZACION"].ToString();
dr["FECHA_INTEGRACION"] = drOrdenItem["FECHA_INTEGRACION"].ToString().Replace(" 0:00:00", "");
dr["dias_transcurridos"] = drOrdenItem["DIFERENCIA"].ToString();
dr["CONTRATISTA"] = drOrdenItem["CONTRATISTA"].ToString();
dr["NOMBRE"] = drOrdenItem["NOMBRE"].ToString() + " " + drOrdenItem["APELLIDO"].ToString();
dt.Rows.Add(dr);
total = total + 1;
}
DataView MydataView;
MydataView = new DataView(dt);
gridOrden.DataSource = MydataView;
gridOrden.DataBind();
lbTotal.Text = total + " registro(s) encontrado(s)";
int i;
GridViewRow gvRow;
CheckBox chk_as;
for (i = 0; i < gridOrden.Rows.Count; i++)
{
gvRow = gridOrden.Rows[i];
chk_as = ((CheckBox)gvRow.FindControl("check_cambio"));
if (gridOrden.Rows[i].Cells[17].Text == "4")
{
chk_as.Enabled = false;
}
}
// PONE INVISIBLES LAS COLUMNAS CON LOS ID
gridOrden.Columns[0].Visible = false;
gridOrden.Columns[17].Visible = false;
//gridOrden.Columns[10].Visible = false;
gridOrden.Columns[12].Visible = false;
gridOrden.Columns[14].Visible = false;
//carga_ruta(txtServ.Text, int.Parse(ddGrupo.SelectedValue), int.Parse(ddLocalidad.SelectedValue), int.Parse(ddTipoIn.SelectedValue), int.Parse(ddSincro.SelectedValue), ddRuta.SelectedValue.ToString(), int.Parse(ddTipoPro.SelectedValue.ToString()), txtDesde.Text, txtHasta.Text, int.Parse(ddZona.SelectedValue));
}
public DataSet InsertExchangeRateFactor(string companyCode, Int32 month, Int32 year, double exchangeRateFactor, string userCode, out Int32 iErrorId)
{
ds = new DataSet();
try
{
OpenConnection(out iErrorId, out sErrorMsg);
ErrorId = new OracleParameter();
OracleParameter inCompanyCode = new OracleParameter();
OracleParameter inMonth = new OracleParameter();
OracleParameter inYear = new OracleParameter();
OracleParameter inExchangeRateFactor = new OracleParameter();
OracleParameter inUserCode = new OracleParameter();
OracleParameter curExchangeRateData = new OracleParameter();
orlDA = new OracleDataAdapter();
orlCmd = new OracleCommand("pkg_maint_exchange_rates.p_insert_exchange_rate_factor", orlConn);
orlCmd.CommandType = System.Data.CommandType.StoredProcedure;
inCompanyCode.OracleDbType = OracleDbType.Varchar2;
inCompanyCode.Direction = ParameterDirection.Input;
inCompanyCode.Value = companyCode;
orlCmd.Parameters.Add(inCompanyCode);
inMonth.OracleDbType = OracleDbType.Int32;
inMonth.Direction = ParameterDirection.Input;
inMonth.Value = month;
orlCmd.Parameters.Add(inMonth);
inYear.OracleDbType = OracleDbType.Int32;
inYear.Direction = ParameterDirection.Input;
inYear.Value = year;
orlCmd.Parameters.Add(inYear);
inExchangeRateFactor.OracleDbType = OracleDbType.Double;
inExchangeRateFactor.Direction = ParameterDirection.Input;
inExchangeRateFactor.Value = exchangeRateFactor;
orlCmd.Parameters.Add(inExchangeRateFactor);
inUserCode.OracleDbType = OracleDbType.Varchar2;
inUserCode.Direction = ParameterDirection.Input;
inUserCode.Value = userCode;
orlCmd.Parameters.Add(inUserCode);
curExchangeRateData.OracleDbType = OracleDbType.RefCursor;
curExchangeRateData.Direction = System.Data.ParameterDirection.Output;
orlCmd.Parameters.Add(curExchangeRateData);
ErrorId.OracleDbType = OracleDbType.Int32;
ErrorId.Direction = ParameterDirection.Output;
ErrorId.ParameterName = "ErrorId";
orlCmd.Parameters.Add(ErrorId);
orlDA = new OracleDataAdapter(orlCmd);
orlDA.Fill(ds);
iErrorId = Convert.ToInt32(orlCmd.Parameters["ErrorId"].Value.ToString());
}
catch (Exception ex)
{
iErrorId = 2;
throw ex;
}
finally
{
CloseConnection();
}
return ds;
}
static void Main(string[] args)
{
StreamWriter
fstr_out = null;
OracleConnection
conn = null;
OracleCommand
cmd=null;
OracleDataAdapter
da=null;
OracleDataReader
rdr = null;
OracleTransaction
tr = null;
DataTable
tmpDataTable = null;
object
tmpObject;
string
FieldName,
tmpString;
long
tmpLong;
int
tmpInt,
i;
bool
tmpBool;
DateTime
tmpDateTime;
try
{
try
{
fstr_out = new StreamWriter("log.log", false, System.Text.Encoding.GetEncoding(1251));
fstr_out.AutoFlush = true;
string
ConnectionString = "User ID=corp_yk_user;Password=google;Data Source=sm";
//ConnectionString = "User ID=aspnetuser;Password=aspnet;Data Source=ASM";
//ConnectionString = "User ID=sqlpretension;Password=impression;Data Source=SM";
conn = new OracleConnection(ConnectionString);
#if TEST_DBMS_OUTPUT
conn.StateChange += new StateChangeEventHandler(conn_StateChange);
conn.InfoMessage += new OracleInfoMessageEventHandler(conn_InfoMessage);
#endif
conn.Open();
#if TEST_NULL
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from testtabletypes";
rdr=cmd.ExecuteReader();
do
{
if (rdr.HasRows)
{
int
idx = rdr.GetOrdinal(FieldName = "FINT");
while (rdr.Read())
{
tmpInt = !rdr.IsDBNull(idx) ? Convert.ToInt32(rdr[idx]) : int.MinValue;
tmpInt = rdr[idx] != DBNull.Value ? Convert.ToInt32(rdr[idx]) : int.MaxValue;
tmpInt = !rdr[idx].Equals(DBNull.Value) ? Convert.ToInt32(rdr[idx]) : int.MinValue;
tmpInt = !Convert.IsDBNull(rdr[idx]) ? Convert.ToInt32(rdr[idx]) : int.MaxValue;
}
}
} while (rdr.NextResult());
rdr.Close();
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
foreach (DataRow r in tmpDataTable.Rows)
{
tmpInt = !r.IsNull(FieldName = "FINT") ? Convert.ToInt32(r[FieldName]) : int.MinValue;
tmpInt = r[FieldName] != DBNull.Value ? Convert.ToInt32(r[FieldName]) : int.MaxValue;
tmpInt = !r[FieldName].Equals(DBNull.Value) ? Convert.ToInt32(r[FieldName]) : int.MinValue;
tmpInt = !Convert.IsDBNull(r[FieldName]) ? Convert.ToInt32(r[FieldName]) : int.MaxValue;
}
#endif
#if TEST_NLS_NUMERIC_CHARACTERS
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select cast('0,123' as number(10,6)) from dual";
tmpObject = cmd.ExecuteScalar();
#endif
#if CAST_VS_CONVERT
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select count(*) from dual";
try
{
tmpInt = (int)cmd.ExecuteScalar();
}
catch (Exception eException)
{
Console.WriteLine(eException.GetType().FullName + Environment.NewLine + "Message: " + eException.Message + Environment.NewLine + "StackTrace:" + Environment.NewLine + eException.StackTrace);
}
tmpObject = cmd.ExecuteScalar(); // decimal
tmpInt = Convert.ToInt32(tmpObject);
tmpObject = cmd.ExecuteOracleScalar(); // OracleNumber
OracleNumber
tmpOracleNumber = (OracleNumber)tmpObject;
#endif
#if TEST_TYPES
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
tmpDateTime = DateTime.Now;
cmd.CommandText = @"
update
testtabletypes
set
ftimestamp=:ftimestamp_in,
ftimestamp_w_tz=:ftimestamp_w_tz_in,
ftimestamp_w_l_tz=:ftimestamp_w_l_tz_in
";
cmd.Parameters.Clear();
cmd.Parameters.Add("ftimestamp_in", OracleType.Timestamp).Value = tmpDateTime;
cmd.Parameters.Add("ftimestamp_w_tz_in", OracleType.TimestampWithTZ).Value = tmpDateTime;
cmd.Parameters.Add("ftimestamp_w_l_tz_in", OracleType.TimestampLocal).Value = tmpDateTime;
tmpInt=cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
cmd.CommandText = "select * from TestTableTypes";
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
if (tmpDataTable.Rows.Count > 0)
{
tmpObject = tmpDataTable.Rows[0]["FNumber_Asterisk_0"];
if(!Convert.IsDBNull(tmpObject)) // System.InvalidCastException: Object cannot be cast from DBNull to other types.
tmpBool = Convert.ToBoolean(tmpObject);
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "UpdateTestTableTypes";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["ID_IN"].Value = 1;
//cmd.Parameters["FCLOB_IN"].Value = new string('я', 2001); //"CLOB";
//cmd.Parameters["FNCLOB_IN"].Value = new string('я', 2001); //"NCLOB";
//cmd.Parameters["FSMALLINT_IN"].Value = false;
//cmd.Parameters["FINT_IN"].Value = Enum4TestTypes.Second;
cmd.ExecuteNonQuery();
#endif
#if TEST_DBMS_OUTPUT
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TestProcedureWithDBMSOutput";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.ExecuteNonQuery();
#endif
#if TEST_CLOB
if (cmd == null)
cmd = conn.CreateCommand();
//tmpString = "<P style=\"FONT-SIZE: large\" align=center>Спасибо, что пользуетесь нашей системой заказов!</P><P style=\"FONT-SIZE: large\" align=center>С 3 декабря изменился интерфейс \"онлайн заказов\" для клиентов компании.</P><P style=\"FONT-SIZE: large\" align=center>Просьба о всех пожеланиях и возможных проблемах сообщать на эл. адрес <A href=\"mailto:[email protected]\">[email protected]</A></P><P>Для создания заказа воспользуйтесь пунктом меню \"Каталог товаров\", либо загрузите заказ из <IMG src=\"http://corp.mtr.com.ua/OrdersApp/images/excel.gif\"> Excel через меню \"Загрузить заказ\"</P><P>Более подробно о том, как делать заказы и пользоваться системой вы можете почитать в <A href=\"http://corp.mtr.com.ua/OrdersApp/client/manual/help%20b2b.doc\">документации</A>.</P><P align=center><B>Уважаемые партнёры:</B></P><P align=center>Не упустите возможность закупить продукцию «Медиа Трейдинг» по очень хорошим ценам.</P><P align=center>Только раз в неделю, каждую пятницу, мы предлагаем специальные цены на несколько позиций из своего ассортимента. Размер партии может быть любой. Условие только одно: <B>Полная оплата закупки в тот же день*.</B><BR><BR>Способ оплаты может быть любой.<BR><SPAN style=\"COLOR: rgb(255,0,0); FONT-WEIGHT: bold\">ВНИМАНИЕ: АССОРТИМЕНТ ТОВАРОВ ОБНОВЛЯЕТСЯ КАЖДЫЙ ЧЕТВЕРГ В 16:00.</SPAN><BR></P><P><B>*Пояснение к условию:</B><BR>Вы можете получить товар по объявленной цене при условии оплаты в этот же день.<BR>Это значит, что нужно <B>«принести» (любым способом: безнал, предоплата) деньги в офис или представительство компании с 9:00 до 17:00 пятницы.</B> При этом <B>у Вас не должно быть вообще никаких задолженностей перед компанией, <U>независимо от размеров и срока давности</U>. Баланс либо нулевой, либо плюс.</B><BR><B><U>Без подтверждения оплаты товар отгружен не будет!</U></B><BR><BR>В случае, если товара нет на складе представительства, заказ будет доставлен с центрального склада ближайшей отгрузкой.</P><p align=\"center\"><b><br></b></p><p align=\"center\"><b><br></b></p><p align=\"center\"><b><br></b></p>";
//tmpString = new string('я', 2000);
tmpString = new string('я', 2001);
//tmpString = new string('я', 3000);
//tmpString = new string('я', 3999);
//tmpString = new string('я', 4000);
//tmpString = new string('я', 4001);
//tmpString = new string('я', 0x0ffff);
cmd.CommandType = CommandType.Text;
cmd.CommandText = "update TestTableTypes set FClob = :FClob, FNClob = :FNClob";
//cmd.Parameters.Add(":FClob", OracleType.Clob).Value = tmpString;
//cmd.Parameters.Add(":FNClob", OracleType.NClob).Value = tmpString;
//cmd.Parameters.AddWithValue(":FClob", tmpString);
//cmd.Parameters.AddWithValue(":FNClob", tmpString);
OracleParameter
p;
p = new OracleParameter();
p.ParameterName = ":FClob";
p.DbType = DbType.String;
p.Value = tmpString;
cmd.Parameters.Add(p);
p = new OracleParameter();
p.ParameterName = ":FNClob";
p.DbType = DbType.String;
p.Value = tmpString;
cmd.Parameters.Add(p);
tmpInt=cmd.ExecuteNonQuery();
#endif
#if TEST_EXECUTE_SCALAR
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select count(*) from user_objects";
tmpObject = cmd.ExecuteScalar();
// tmpInt=(int)tmpObject; // Wrong!!!
tmpInt = Convert.ToInt32(tmpObject);
#endif
#if TEST_FUNCTION
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "get_actions_count";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["application_id_in"].Value = 128;
cmd.Parameters["date_actual"].Value = new DateTime(1900, 1, 1);
tmpObject = cmd.ExecuteNonQuery();
tmpInt = Convert.ToInt32(cmd.Parameters["return_value"].Value);
cmd.CommandText = "get_zonder_duration";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["volume_in"].Value = 0.1;
tmpObject = cmd.ExecuteNonQuery();
tmpInt = Convert.ToInt32(cmd.Parameters["return_value"].Value);
#endif
#if GET_STORED_PROCEDURE_PARAMETERS
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "typhoon.utilfunctions.updategextra"; // "typhoon.Utilization_Util.ImportUtilization"; //"typhoon.pkg_claim.get_doc_status"; // "typhoon.movegoodstoresrevforinetf"; //"typhoon.setdocpropvalue"; // "typhoon.GET_URL_OPENDOC"; //"typhoon.HO_Utils.makeDocument";
OracleCommandBuilder.DeriveParameters(cmd);
Console.WriteLine(cmd.CommandText);
for (int ii = 0; ii < cmd.Parameters.Count; ++ii)
Console.WriteLine("ParameterName: " + cmd.Parameters[ii].ParameterName + " OracleType: " + cmd.Parameters[ii].OracleType.ToString() + " Direction: " + cmd.Parameters[ii].Direction.ToString());
Console.ReadLine();
#endif
#if TEST_SEND_E_MAIL
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "typhoon.mail_task_util.sendmail"; //"typhoon.mail_task_util.sendmail2";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["M_SENDER"].Value = "*****@*****.**"; //"*****@*****.**"; // "*****@*****.**"
cmd.Parameters["M_RECIPIENT"].Value = "[email protected]; [email protected]"; // "*****@*****.**";
cmd.Parameters["M_SUBJECT"].Value = "Тест e-mail посредством оракула";
cmd.Parameters["M_MESSAGE"].Value = "<p><center><img src=\"http://b2b.mtr.com.ua/images/logo.gif\" /></center></p><p><center><b>Дистрибуция Медиа Продукции</b></center></p><p>Тест e-mail посредством оракула <a href=\"http://google.com/\">google.com</a></p>";
//cmd.Parameters["M_CC_RECIPIENT"].Value = DBNull.Value;
//cmd.Parameters["M_BCC_RECIPIENT"].Value = DBNull.Value;
cmd.Parameters["M_ADDRDELIM"].Value = ";";
cmd.ExecuteNonQuery();
#endif
#if TEST_STORED_PROCEDURE_IN_CIRCLE
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TableWithSequenceSave";
OracleCommandBuilder.DeriveParameters(cmd);
for (i = 0; i < 10; ++i)
{
cmd.Parameters["id_cur"].Value = 0;
cmd.Parameters["val_new"].Value = i;
cmd.ExecuteNonQuery();
tmpInt = Convert.ToInt32(cmd.Parameters["id_new"].Value);
}
#endif
#if TEST_BLOB
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
FileStream
fs;
byte[]
Blob;
#if TEST_BLOB_SAVE
cmd.CommandText = "update TableWithBLOB set FBlob=:FBlob where Id=:Id";
cmd.Parameters.Clear();
cmd.Parameters.Add("Id", OracleType.Number).Value = 1;
cmd.Parameters.Add("FBlob", OracleType.Blob);
fs = new FileStream("xpfirewall.bmp", FileMode.Open, FileAccess.Read);
Blob = new byte[fs.Length];
fs.Read(Blob, 0, Blob.Length);
fs.Close();
cmd.Parameters["FBlob"].Value = Blob;
tmpInt = cmd.ExecuteNonQuery();
#endif
#if TEST_BLOB_SAVE_BY_SP
// http://support.microsoft.com/default.aspx?scid=kb;en-us;322796
fs = new FileStream("xpfirewall.bmp", FileMode.Open, FileAccess.Read);
Blob = new byte[fs.Length];
fs.Read(Blob, 0, Blob.Length);
fs.Close();
cmd.Transaction = conn.BeginTransaction();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "declare xx blob; begin dbms_lob.createtemporary(xx, false, 0); :tempblob := xx; end;";
cmd.Parameters.Clear();
cmd.Parameters.Add(new OracleParameter("tempblob", OracleType.Blob)).Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
OracleLob
tmpOracleLob;
tmpOracleLob = (OracleLob)cmd.Parameters["tempblob"].Value;
tmpOracleLob.BeginBatch(OracleLobOpenMode.ReadWrite);
tmpOracleLob.Write(Blob, 0, Blob.Length);
tmpOracleLob.EndBatch();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "TableWithBLOBSave";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["ID_IN"].Value = 2;
cmd.Parameters["FBLOB_IN"].Value = tmpOracleLob;
tmpInt = cmd.ExecuteNonQuery();
cmd.Transaction.Commit();
cmd.CommandType = CommandType.Text;
#endif
cmd.CommandText = "select * from TableWithBLOB";
cmd.Parameters.Clear();
rdr = cmd.ExecuteReader();
do
{
if (rdr.HasRows)
{
for (int i = 0; i < rdr.FieldCount; ++i)
fstr_out.WriteLine(rdr.GetName(i) + " GetDataTypeName(): \"" + rdr.GetDataTypeName(i) + "\" GetFieldType(): \"" + rdr.GetFieldType(i) + "\"");
tmpInt = rdr.GetOrdinal("FBlob");
while (rdr.Read())
{
tmpString = "FromBlob.bmp";
if (File.Exists(tmpString))
File.Delete(tmpString);
Blob = (byte[])rdr["FBlob"];
fs = new FileStream(tmpString, FileMode.Create);
fs.Write(Blob, 0, Blob.Length);
fs.Close();
tmpString = "FromBlob_1.bmp";
if (File.Exists(tmpString))
File.Delete(tmpString);
Blob = new byte[rdr.GetBytes(tmpInt, 0, null, 0, int.MaxValue)];
rdr.GetBytes(tmpInt, 0, Blob, 0, Blob.Length);
fs = new FileStream(tmpString, FileMode.Create);
fs.Write(Blob, 0, Blob.Length);
fs.Close();
}
}
} while (rdr.NextResult());
rdr.Close();
#endif
#if TEST_SELECT
/* if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType=CommandType.Text;
cmd.CommandText = @"
select
ew.ew_id as ""Id"",
ew.ew_name as ""Description""
from
typhoon.tbl_extra_what ew
where
(ew.ew_fs=typhoon.get_parent_cfo(:cfo))
and (coalesce(ew.ew_is_closed,0)=0)
order by ew.ew_id
";
cmd.Parameters.Clear();
cmd.Parameters.Add("cfo", OracleType.Number).Value = 150140;
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
*/ /*
tmpObject = cmd.ExecuteScalar();
if (tmpObject != null && !Convert.IsDBNull(tmpObject))
tmpLong = Convert.ToInt64(tmpObject);
*/
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText="select * from tmp_docs_badrows";
cmd.Parameters.Clear();
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
if (tmpDataTable.PrimaryKey == null)
tmpDataTable.PrimaryKey = new DataColumn[] { tmpDataTable.Columns["doc_id"], tmpDataTable.Columns["g_id"] };
#endif
#if TEST_SELECTED_STORED_PROCEDURE
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "StoredProcedureForPaging";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["start_in"].Value = 2;
cmd.Parameters["limit_in"].Value = 2;
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
FieldName="id";
foreach(DataRow r in tmpDataTable.Rows)
{
Console.WriteLine(!r.IsNull(FieldName) ? Convert.ToInt32(r[FieldName]).ToString() : "null");
}
#endif
#if TEST_STORED_PROCEDURE
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "typhoon.GET_URL_OPENDOC";
OracleCommandBuilder.DeriveParameters(cmd);
cmd.Parameters["P_DOCID"].Value = 33711025;
cmd.Parameters["P_FULLHTMLCODE"].Value = DBNull.Value;
cmd.ExecuteNonQuery();
tmpString = Convert.ToString(cmd.Parameters["RETURN_VALUE"].Value);
#endif
#if TEST_MULTI_STATEMENTS
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
//cmd.CommandText = "alter session set NLS_TERRITORY = 'CIS';alter session set NLS_SORT = 'RUSSIAN';alter session set NLS_NUMERIC_CHARACTERS = '.,'";
cmd.CommandText = "begin execute immediate 'alter session set NLS_TERRITORY = ''CIS'''; execute immediate 'alter session set NLS_SORT = ''RUSSIAN'''; execute immediate 'alter session set NLS_NUMERIC_CHARACTERS = ''.,'''; end;";
cmd.ExecuteNonQuery();
#endif
#if TEST_PARAMETERS
if (cmd == null)
cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from dual where :a=:b";
cmd.Parameters.Add("a", OracleType.Int32).Value = 1;
cmd.Parameters.Add("b", OracleType.Int32).Value = 1;
//cmd.Parameters.Add("c", OracleType.Int32).Value = 2;
tmpObject = cmd.ExecuteScalar();
cmd.Parameters.Clear();
cmd.CommandText = "select k_id as id, k_name as val from typhoon.tbl_kontragents where k_name like :q order by k_name";
tmpString = "FOTO";
cmd.Parameters.Add("q", OracleType.NVarChar).Value = tmpString + "%";
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
cmd.Parameters.Clear();
cmd.CommandText = @"
select
hoty_id,
param_name,
param_value
from
order_params
where
(hoty_id = :hoty_id)
";
cmd.Parameters.Add("hoty_id", OracleType.Number).Value = 2219;
if (da == null)
da = new OracleDataAdapter();
da.SelectCommand = cmd;
if (tmpDataTable == null)
tmpDataTable = new DataTable();
else
tmpDataTable.Reset();
da.Fill(tmpDataTable);
FieldName = "param_name";
foreach (DataRow r in tmpDataTable.Rows)
{
Console.WriteLine(!r.IsNull(FieldName) ? Convert.ToString(r[FieldName]).ToString() : "null");
}
#endif
}
catch (Exception eException)
{
Console.WriteLine(eException.GetType().FullName + Environment.NewLine + "Message: " + eException.Message + Environment.NewLine + "StackTrace:" + Environment.NewLine + eException.StackTrace);
}
}
finally
{
if (rdr != null && !rdr.IsClosed)
rdr.Close();
if (conn != null && conn.State == ConnectionState.Open)
conn.Close();
if (fstr_out != null)
fstr_out.Close();
}
}
private void Load_Pins()
{
int i = 0;
string command1 = "select c.category_id from category c, user_category uc, pinterest_user pu where c.category_id = uc.category_id and uc.user_id = pu.user_id and pu.user_id =: userId ";
OracleDataAdapter adapter1 = new OracleDataAdapter(command1, FixedValues.ordb);
adapter1.SelectCommand.Parameters.Add("userid", Account.UserID);
DataSet set1 = new DataSet();
adapter1.Fill(set1);
int[] categories_user = new int[set1.Tables[0].Rows.Count];
for (int k = 0; k < set1.Tables[0].Rows.Count; k++)
{
categories_user[k] = Convert.ToInt32(set1.Tables[0].Rows[k]["category_id"].ToString());
string command = "select pin_name, pin_image, pin_id from pin , board where board.board_name=pin.board_name and board.user_Id=pin.user_id and pin.user_id !=:userid and board.privacy='0' and category_id=:categoryID ";
OracleDataAdapter adapter = new OracleDataAdapter(command, FixedValues.ordb);
adapter.SelectCommand.Parameters.Add("userid", Account.UserID);
adapter.SelectCommand.Parameters.Add("categoryID", categories_user[k]);
DataSet set = new DataSet();
adapter.Fill(set);
//initial coordinates... don't change
double initLeft = 50;
double initTop = 20;
double initRight = 510;
double initBottom = 10;
//for first login only.. don't change
double d;
for (int j = 0; j < set.Tables[0].Rows.Count; j++)
{
if ((i + 1) % 5 == 0)
{
initLeft = 20;
initRight = 510;
i = 0;
}
if (i >= 1)
{
d = 0.5;
}
else
{
d = i;
}
connection.Open();
OracleCommand c = new OracleCommand();
c.Connection = connection;
c.CommandText = "select react_type from user_react where pin_id=:pin_id and user_id=:user_id";
c.CommandType = CommandType.Text;
c.Parameters.Add("pin_id", set.Tables[0].Rows[i].ItemArray[2]);
c.Parameters.Add("user_id", Account.UserID);
OracleDataReader dr = c.ExecuteReader();
string react = "";
if (dr.Read())
{
react = dr[0].ToString();
}
dr.Close();
connection.Close();
Pinterest_V2.UserControls.othersPinUserControl othersPinsControl = new UserControls.othersPinUserControl();
byte[] image = (byte[])set.Tables[0].Rows[j].ItemArray[1];
othersPinsControl.otherPinPhoto.Source = FixedValues.LoadImage(image);
othersPinsControl.pin_id = Convert.ToInt32(set.Tables[0].Rows[j].ItemArray[2]);
othersPinsControl.addIcon.Foreground = Brushes.White;
if (react.Equals("likes"))
{
othersPinsControl.likeIcon.Foreground = Brushes.Gray;
}
else
{
othersPinsControl.likeIcon.Foreground = Brushes.White;
}
if (react.Equals("dislikes"))
{
othersPinsControl.dislikeIcon.Foreground = Brushes.Gray;
}
else
{
othersPinsControl.dislikeIcon.Foreground = Brushes.White;
}
othersPinsControl.Margin = new Thickness(initLeft + (i * 230), initTop - (d * 440), initRight - (i * 220), initBottom - 220 * d);
HomePanel.Children.Add(othersPinsControl);
i++;
}
}
}
private void Search_Pin(string Search_txt)
{
/////////////////////////// b. 1. ////////////////////////////////////
string cmdstr = @"Select p.pin_id, p.pin_name, p.pin_image From Pin p , board b Where p.board_name = b.board_name and b.privacy = 0 and lower(p.pin_name) = lower(:SearchName) and p.user_id != :userID";
SearchAdapter = new OracleDataAdapter(cmdstr, FixedValues.ordb);
SearchAdapter.SelectCommand.Parameters.Add("SearchName", Search_txt);
SearchAdapter.SelectCommand.Parameters.Add("userID", Account.UserID);
DataSet SearchDS = new DataSet();
SearchAdapter.Fill(SearchDS);
DataRow row = SearchDS.Tables[0].NewRow();
//initial coordinates... don't change
double initLeft = 50;
double initTop = 50;
double initRight = 510;
double initBottom = 10;
double d;
int i = 0;
for (int j = 0; j < SearchDS.Tables[0].Rows.Count; j++)
{
if ((i + 1) % 5 == 0)
{
initLeft = 20;
initRight = 510;
i = 0;
}
if (i >= 1)
{
d = 0.5;
}
else
{
d = i;
}
row = SearchDS.Tables[0].Rows[j];
Pinterest_V2.UserControls.othersPinUserControl OtherPinControl = new UserControls.othersPinUserControl();
OtherPinControl.pin_id = Convert.ToInt32(SearchDS.Tables[0].Rows[j][0]);
byte[] image = (byte[])SearchDS.Tables[0].Rows[j][2];
OtherPinControl.otherPinPhoto.Source = FixedValues.LoadImage(image);
OtherPinControl.Margin = new Thickness(initLeft + (i * 230), initTop - (d * 440), initRight - (i * 220), initBottom - 220 * d);
HomePanel.Children.Add(OtherPinControl);
i++;
}
if (SearchDS.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No Result Found");
}
}
//################## SEARCH FUNCTION ##################\\
private void Search_User(string Search_txt)
{
/////////////////////////// b. 1. ////////////////////////////////////
string cmdstr = @"Select user_id, user_name, profile_pic From pinterest_user Where lower(user_name) = lower(:SearchName) and user_id != :userID";
OracleDataAdapter SearchAdapter = new OracleDataAdapter(cmdstr, FixedValues.ordb);
SearchAdapter.SelectCommand.Parameters.Add("SearchName", Search_txt);
SearchAdapter.SelectCommand.Parameters.Add("userID", Account.UserID);
DataSet SearchDS = new DataSet();
SearchAdapter.Fill(SearchDS);
DataRow row = SearchDS.Tables[0].NewRow();
//initial coordinates... don't change
double initLeft = 50;
double initTop = 50;
double initRight = 510;
double initBottom = 10;
double d;
int i = 0;
for (int j = 0; j < SearchDS.Tables[0].Rows.Count; j++)
{
if ((i + 1) % 5 == 0)
{
initLeft = 20;
initRight = 510;
i = 0;
}
if (i >= 1)
{
d = 0.5;
}
else
{
d = i;
}
row = SearchDS.Tables[0].Rows[j];
Pinterest_V2.UserControls.UserSearchUserControl OtherUserControl = new UserControls.UserSearchUserControl();
OtherUserControl.OtherUserID = Convert.ToInt32(SearchDS.Tables[0].Rows[j][0]);
OtherUserControl.Profilbtn.Content = SearchDS.Tables[0].Rows[j][1];
byte[] image = (byte[])SearchDS.Tables[0].Rows[i][2];
OtherUserControl.Profilbtn.Background = new ImageBrush(FixedValues.LoadImage(image));
OtherUserControl.Profilbtn.Foreground = Brushes.White;
OtherUserControl.Margin = new Thickness(initLeft + (i * 230), initTop - (d * 440), initRight - (i * 220), initBottom - 220 * d);
HomePanel.Children.Add(OtherUserControl);
i++;
}
if (SearchDS.Tables[0].Rows.Count == 0)
{
MessageBox.Show("No Result Found");
}
}
protected void linkSelectClick(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
LinkButton btn = (LinkButton)sender;
Session["user_page_data_id"] = btn.CommandArgument;
string USER_DATA_ID = Session["user_page_data_id"].ToString();
DataTable dtUserTypeID = new DataTable();
DataSet ds = new DataSet();
string makeSQL = " select * from IT_ASSET_EMP_ITEM_EXPIRES where EMP_ITEM_EXP_ID = '" + USER_DATA_ID + "'";
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
RowCount = dt.Rows.Count;
for (int i = 0; i < RowCount; i++)
{
TextItemExpID.Text = dt.Rows[i]["EMP_ITEM_EXP_ID"].ToString();
DropDownItemExpID.Text = dt.Rows[i]["ITEM_EXP_ID"].ToString();
if (radExpSelect.SelectedValue == "Employee")
{
DataTable dtItemID = new DataTable();
DataSet di = new DataSet();
string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON AI.ITEM_ID = IAEI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE AI.IS_ACTIVE = 'Enable' AND IAEI.EMP_ID = '" + dt.Rows[i]["EMP_ID"].ToString() + "' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC";
di = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)di.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "EMP_ITEMS_ID";
DropDownItemID.DataTextField = "ITEM_NAME_ALL";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
DropDownItemID.Text = dt.Rows[i]["ITEM_ID"].ToString();
DropDownEmployeeID.Text = dt.Rows[i]["EMP_ID"].ToString();
}
else
{
DropDownDepartmentID.Text = dt.Rows[i]["DEPARTMENT_ID"].ToString();
DropDownDivisionID.Text = dt.Rows[i]["DIVISION_ID"].ToString();
DropDownLocationID.Text = dt.Rows[i]["LOCATION_ID"].ToString();
DropDownPlacementID.Text = dt.Rows[i]["PLACEMENT_ID"].ToString();
string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON IAEI.ITEM_ID = AI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE AI.IS_ACTIVE = 'Enable' AND IAEI.DEPARTMENT_ID = '" + dt.Rows[i]["DEPARTMENT_ID"].ToString() + "' AND IAEI.DIVISION_ID = '" + dt.Rows[i]["DIVISION_ID"].ToString() + "' AND IAEI.LOCATION_ID = '" + dt.Rows[i]["LOCATION_ID"].ToString() + "' AND IAEI.PLACEMENT_ID = '" + dt.Rows[i]["PLACEMENT_ID"].ToString() + "' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC";
DataTable dtItemdID = new DataTable();
DataSet did = new DataSet();
did = ExecuteBySqlString(makeItemSQL);
dtItemdID = (DataTable)did.Tables[0];
DropDownItemID.DataSource = dtItemdID;
DropDownItemID.DataValueField = "EMP_ITEMS_ID";
DropDownItemID.DataTextField = "ITEM_NAME_ALL";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
DropDownItemID.Text = dt.Rows[i]["ITEM_ID"].ToString();
}
TextSerialNo.Text = dt.Rows[i]["SERIAL_NO"].ToString();
TextActivationCode.Text = dt.Rows[i]["ACTIVATION_CODE"].ToString();
DateTime StartDateTemp = DateTime.ParseExact(dt.Rows[i]["START_DATE"].ToString(), "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture);
string StartDate = String.Format("{0:dd/MM/yyyy h:mm:ss tt}", StartDateTemp);
DateTime ExpiryDateTemp = DateTime.ParseExact(dt.Rows[i]["EXPIRES_DATE"].ToString(), "M/d/yyyy h:mm:ss tt", CultureInfo.InvariantCulture);
string ExpiryDate = String.Format("{0:dd/MM/yyyy h:mm:ss tt}", ExpiryDateTemp);
TextStartExpiryDate.Text = StartDate + " - " + ExpiryDate;
TextExpiredDays.Text = dt.Rows[i]["EXPIRED_DAYS"].ToString();
CheckIsActive.Checked = Convert.ToBoolean(dt.Rows[i]["IS_ACTIVE"].ToString() == "Enable" ? true : false);
}
conn.Close();
// Display();
alert_box.Visible = false;
BtnAdd.Attributes.Add("aria-disabled", "false");
BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
// GridViewItem.UseAccessibleHeader = true;
// GridViewItem.HeaderRow.TableSection = TableRowSection.TableHeader;
// TextQrImage.Visible = true;
// PlaceHolder1.Text = USER_DATA_ID;
}
protected void btn_Actualiza_Click(object sender, System.EventArgs e)
{
Response.Buffer = true;
Response.AddHeader("Pragma", "no-cache");
Response.CacheControl = "no-cache";
Response.Expires = -1;
//int aux;
//if (dr_foto.Text == "Sin Fotografía")
// aux = 0;
//else
// aux = 1;
if (txt_ClaveInstalador.Text != txt_claveAdmin.Text)
{
lb_valida_claves.Visible = false;
string str_valida_codigo = null;
string str_carga_imagen = null;
str_valida_codigo = validadacion_Codigo_Lector(txt_codLector.Text.Trim(' '));
//str_carga_imagen = UPLOAD_FOTO_CORTADOR(FileUpload_Cortador, lb_id_cortador.Text.Trim(' '));
if (str_valida_codigo == "OK")
{
lb_valida_claves.Visible = false;
string ID_Lector_UPDATE = Request.QueryString["idlector"];
OracleConnection objConexion = new OracleConnection(conexion_cliente_oracle); //OleDbConnection(conexion)
objConexion.Open();
OracleDataAdapter ComandoDA = null;
ComandoDA = new OracleDataAdapter("PK_INSTALADOR.UPDATE_INSTALADORES", objConexion);
ComandoDA.SelectCommand.CommandType = CommandType.StoredProcedure;
PRO.agrega_parametro_sp(ComandoDA, "i_id_instalador", OracleType.Int32, ParameterDirection.Input, ID_Lector_UPDATE.ToString());
PRO.agrega_parametro_sp(ComandoDA, "i_id_region", OracleType.Int32, ParameterDirection.Input, combo_regiones.Items[combo_regiones.SelectedIndex].Value);
PRO.agrega_parametro_sp(ComandoDA, "i_id_zona", OracleType.Int32, ParameterDirection.Input, combo_zonaLector.Items[combo_zonaLector.SelectedIndex].Value);
PRO.agrega_parametro_sp(ComandoDA, "i_rut_empresa", OracleType.Number, ParameterDirection.Input, lbRutEmpresa.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_cod_instalador", OracleType.NVarChar, ParameterDirection.Input, PRO.CadenaSinCeros(txt_codLector.Text.Trim(' ')));
PRO.agrega_parametro_sp(ComandoDA, "i_clave_admin", OracleType.NVarChar, ParameterDirection.Input, txt_claveAdmin.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_clave_instalador", OracleType.NVarChar, ParameterDirection.Input, txt_ClaveInstalador.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_estado", OracleType.Int32, ParameterDirection.Input, combo_estado_lector.Items[combo_estado_lector.SelectedIndex].Value);
PRO.agrega_parametro_sp(ComandoDA, "i_apellido_instalador", OracleType.NVarChar, ParameterDirection.Input, txt_apeLector.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_nombre_instalador", OracleType.NVarChar, ParameterDirection.Input, txt_nomLector.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_cantidad", OracleType.Int32, ParameterDirection.Input, txt_cantidad.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_fotografia", OracleType.Int32, ParameterDirection.Input, dr_foto.Items[dr_foto.SelectedIndex].Value);
PRO.agrega_parametro_sp(ComandoDA, "i_numero_telefono", OracleType.NVarChar, ParameterDirection.Input, txt_num_celular.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_serie_maquina", OracleType.NVarChar, ParameterDirection.Input, txt_serie_maquina.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_id_modelo", OracleType.Int32, ParameterDirection.Input, combo_modelo.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_id_contratista", OracleType.Int32, ParameterDirection.Input, combo_contratistas.Items[combo_contratistas.SelectedIndex].Value);
PRO.agrega_parametro_sp(ComandoDA, "i_email", OracleType.NVarChar, ParameterDirection.Input, txt_email.Text.Trim(' '));
PRO.agrega_parametro_sp(ComandoDA, "i_forma_gestion", OracleType.NVarChar, ParameterDirection.Input, cmb_formagestion.Items[cmb_formagestion.SelectedIndex].Text.Trim(' '));
try
{
ComandoDA.SelectCommand.ExecuteNonQuery();
lb_mensaje_edicion.Visible = true;
img_ok.Visible = true;
lb_mensaje_edicion.Text = "Información del Instalador actualizada exitosamente!";
desabilita_edicion(false);
lb_error.Visible = false;
string nom_foto_cortador = null;
nom_foto_cortador = "INSTALADOR_ID_" + Convert.ToString(Request.QueryString["idlector"]).Trim(' ') + ".JPG";
//foto_cortador.Visible = true;
//foto_cortador.ImageUrl = ResolveUrl("~/images/instaladores/" + nom_foto_cortador);
//*********************** INSERTAMOS LOG DEL SISTEMA ***********************************
try
{
string str_fecha = null;
string str_hora = null;
string str_desc_evento = null;
str_fecha = DateTime.Now.ToString().Substring(0, 10).Trim(' ');
str_hora = DateTime.Now.ToString().Substring(10, 9).Trim(' ');
str_desc_evento = "SE ACTUALIZO EL INSTALADOR CON CODIGO " + txt_codLector.Text;
PRO.Insertamos_log_del_Sistema(LB_id_usuario.Text, lbRutEmpresa.Text, str_fecha, str_hora, str_desc_evento, "0", "0", Request.ServerVariables["REMOTE_ADDR"].ToString());
}
catch (Exception ex)
{
}
//**************************************************************************************
}
catch (Exception ex)
{
lb_mensaje_edicion.Visible = false;
lb_error.Visible = true;
img_ok.Visible = false;
lb_error.Text = "Se ha producido un error en la actualización! Inténtelo nuevamente.";
}
}
else
{
lb_valida_claves.Visible = true;
lb_valida_claves.Text = str_valida_codigo;
}
}
else
{
lb_valida_claves.Visible = true;
lb_valida_claves.Text = "NO SE PERMITE CLAVE ADMINISTRADOR = CLAVE INSTALADOR!";
}
}
private void urunleriListele()
{
con.Open();
DataTable dt = new DataTable();
adapt = new OracleDataAdapter("select * from URUNLER U WHERE U.URUN_GRUP_ID = " + CBUrunGruplari.SelectedValue, con);
adapt.Fill(dt);
con.Close();
for (int i = 0; i < dt.Rows.Count; i++)
{
// Dış Panel Özellikleri
Panel p = new Panel();
p.Height = 220;
p.Width = 125;
p.Padding = new Padding(10);
p.BorderStyle = BorderStyle.FixedSingle;
//Resim Ekleme İşlemleri
Panel ustp = new Panel();
ustp.Height = 150;
ustp.Width = 110;
ustp.Dock = DockStyle.Top;
PictureBox pb = new PictureBox();
pb.Height = 150;
pb.Width = 110;
pb.SizeMode = PictureBoxSizeMode.StretchImage;
pb.ImageLocation = dt.Rows[i][6].ToString();
ustp.Controls.Add(pb);
p.Controls.Add(ustp);
// Alt Panel İşlemleri Ürün Adedi ve Sepete Ekleme
Panel altp = new Panel();
altp.Height = 41;
altp.Width = 110;
altp.Dock = DockStyle.Bottom;
Panel altUstP = new Panel();
altUstP.Height = 20;
altUstP.Width = 110;
altUstP.Dock = DockStyle.Top;
Label lbl = new Label();
lbl.Text = dt.Rows[i][1].ToString();
altUstP.Controls.Add(lbl);
altp.Controls.Add(altUstP);
Panel altAltP = new Panel();
altAltP.Height = 21;
altAltP.Width = 110;
altAltP.Dock = DockStyle.Bottom;
// Alt sol panel Ürün Adedi
Panel altSolP = new Panel();
altSolP.Width = 40;
altSolP.Dock = DockStyle.Left;
ComboBox cb = new ComboBox();
cb.Dock = DockStyle.Fill;
for (int k = 1; k < 11; k++)
{
cb.Items.Add(k);
}
cb.SelectedIndex = 0;
cb.Name = "cb_" + dt.Rows[i][0].ToString();
cb.SelectedIndexChanged += new System.EventHandler(cmb_SelectedValueChanged);
altSolP.Controls.Add(cb);
altAltP.Controls.Add(altSolP);
// Alt sağ panel Seç Butonu
Panel altSagP = new Panel();
altSagP.Width = 70;
altSagP.Dock = DockStyle.Right;
Button bt = new Button();
bt.Text = "Ekle";
bt.Name = dt.Rows[i][0].ToString();
bt.Click += new EventHandler(button_Click);
bt.Dock = DockStyle.Fill;
altSagP.Controls.Add(bt);
altAltP.Controls.Add(altSagP);
altp.Controls.Add(altAltP);
p.Controls.Add(altp);
flowLayoutPanel1.Controls.Add(p);
}
}
/* protected void DisplayItemCatQRPriCode(object sender, EventArgs e)
* {
* OracleConnection conn = new OracleConnection(strConnString);
* conn.Open();
*
* int USER_DATA_ID = Convert.ToInt32(DropDownItemExpID.Text);
*
*
* DataTable dtUserTypeID = new DataTable();
* DataSet ds = new DataSet();
* string makeSQL = " select AIC.ITEM_CAT_QR_PRI_CODE from IT_ASSET_ITEM_EXPIRES AIE left join IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AIE.ITEM_CATEGORY_ID where AIE.ITEM_EXP_ID = '" + USER_DATA_ID + "'";
*
* cmdl = new OracleCommand(makeSQL);
* oradata = new OracleDataAdapter(cmdl.CommandText, conn);
* dt = new DataTable();
* oradata.Fill(dt);
* RowCount = dt.Rows.Count;
*
* for (int i = 0; i < RowCount; i++)
* {
* TextQRPreCode.Text = dt.Rows[i]["ITEM_CAT_QR_PRI_CODE"].ToString();
* }
*
* conn.Close();
* // Display();
* CheckQRCode.Text = "";
* alert_box.Visible = false;
* BtnAdd.Attributes.Add("aria-disabled", "false");
* BtnAdd.Attributes.Add("class", "btn btn-primary disabled");
*
* if (EmpStatus == 0)
* {
* // PlaceHolder1.Text = "if";
* }
* else
* {
* // PlaceHolder1.Text = "else";
* GridViewItem.UseAccessibleHeader = true;
* GridViewItem.HeaderRow.TableSection = TableRowSection.TableHeader;
*
*
* }
*
*
*
* } */
public void DisplayEmpItem(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(strConnString);
conn.Open();
DataTable dtItemID = new DataTable();
DataSet di = new DataSet();
string USER_DATA_ID0 = ""; int USER_DATA_ID = 0, USER_DATA_ID2 = 0, USER_DATA_ID3 = 0, USER_DATA_ID4 = 0; string makeSQL = "";
if (radExpSelect.SelectedValue == "Employee")
{
USER_DATA_ID0 = DropDownEmployeeID.SelectedValue;
makeSQL = " select AEIE.*, AIE.ITEM_EXP_NAME, (EXTRACT (DAY FROM (AEIE.EXPIRES_DATE-SYSDATE))) AS EXPIRED_DAYS_BET, AEIE.EXPIRED_DAYS , AEIE.IS_ACTIVE from IT_ASSET_EMP_ITEM_EXPIRES AEIE left join IT_ASSET_ITEM_EXPIRES AIE ON AIE.ITEM_EXP_ID = AEIE.ITEM_EXP_ID where AEIE.EMP_ID = '" + USER_DATA_ID0 + "' order by AEIE.EMP_ITEM_EXP_ID";
string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON AI.ITEM_ID = IAEI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE IAEI.EMP_ID = '" + USER_DATA_ID0 + "' AND AI.IS_ACTIVE = 'Enable' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC";
di = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)di.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "EMP_ITEMS_ID";
DropDownItemID.DataTextField = "ITEM_NAME_ALL";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
dt = new DataTable();
oradata.Fill(dt);
GridViewItem.DataSource = dt;
GridViewItem.DataKeyNames = new string[] { "EMP_ITEM_EXP_ID" };
GridViewItem.DataBind();
for (int i = 0; GridViewItemDept.Columns.Count > i;)
{
GridViewItemDept.Columns.RemoveAt(i);
}
}
else
{
USER_DATA_ID = Convert.ToInt32(DropDownDepartmentID.SelectedValue);
USER_DATA_ID2 = Convert.ToInt32(DropDownDivisionID.SelectedValue);
USER_DATA_ID3 = Convert.ToInt32(DropDownLocationID.SelectedValue);
USER_DATA_ID4 = Convert.ToInt32(DropDownPlacementID.SelectedValue);
makeSQL = " select AEIE.*, AIE.ITEM_EXP_NAME, (EXTRACT (DAY FROM (AEIE.EXPIRES_DATE-SYSDATE))) AS EXPIRED_DAYS_BET, AEIE.EXPIRED_DAYS , AEIE.IS_ACTIVE, IAIP.PLACEMENT_NAME from IT_ASSET_EMP_ITEM_EXPIRES AEIE left join IT_ASSET_ITEM_EXPIRES AIE ON AIE.ITEM_EXP_ID = AEIE.ITEM_EXP_ID left join IT_ASSET_ITEMS_PLACEMENT IAIP ON IAIP.PLACEMENT_ID = AEIE.PLACEMENT_ID where AEIE.DEPARTMENT_ID = '" + USER_DATA_ID + "' AND AEIE.DIVISION_ID = '" + USER_DATA_ID2 + "' AND AEIE.LOCATION_ID = '" + USER_DATA_ID3 + "' AND AEIE.PLACEMENT_ID = '" + USER_DATA_ID4 + "' order by AEIE.EMP_ITEM_EXP_ID";
string makeItemSQL = " SELECT IAEI.EMP_ITEMS_ID, AI.ITEM_NAME || ' - ' || AI.ITEM_TYPE || ' ' || AI.ITEM_BRAND AS ITEM_NAME_ALL from IT_ASSET_EMP_ITEMS IAEI LEFT JOIN IT_ASSET_ITEMS AI ON AI.ITEM_ID = IAEI.ITEM_ID LEFT JOIN IT_ASSET_ITEM_CATEGORIES AIC ON AIC.ITEM_CATEGORY_ID = AI.ITEM_CATEGORY_ID WHERE IAEI.DEPARTMENT_ID = '" + USER_DATA_ID + "' AND IAEI.DIVISION_ID = '" + USER_DATA_ID2 + "' AND IAEI.LOCATION_ID = '" + USER_DATA_ID3 + "' AND IAEI.PLACEMENT_ID = '" + USER_DATA_ID4 + "' AND AI.IS_ACTIVE = 'Enable' AND (AIC.ITEM_CAT_QR_PRI_CODE = 'CPU' OR AIC.ITEM_CAT_QR_PRI_CODE = 'ITD') ORDER BY AI.ITEM_ID ASC";
di = ExecuteBySqlString(makeItemSQL);
dtItemID = (DataTable)di.Tables[0];
DropDownItemID.DataSource = dtItemID;
DropDownItemID.DataValueField = "EMP_ITEMS_ID";
DropDownItemID.DataTextField = "ITEM_NAME_ALL";
DropDownItemID.DataBind();
DropDownItemID.Items.Insert(0, new ListItem("Select Item", "0"));
cmdl = new OracleCommand(makeSQL);
oradata = new OracleDataAdapter(cmdl.CommandText, conn);
ds = new DataTable();
oradata.Fill(ds);
GridViewItemDept.DataSource = ds;
GridViewItemDept.DataKeyNames = new string[] { "EMP_ITEM_EXP_ID" };
GridViewItemDept.DataBind();
for (int i = 0; GridViewItem.Columns.Count > i;)
{
GridViewItem.Columns.RemoveAt(i);
}
}
DropDownItemID.Attributes.Remove("disabled");
BtnAdd.Attributes.Add("aria-disabled", "true");
BtnAdd.Attributes.Add("class", "btn btn-primary active");
TextItemID.Text = "";
DropDownItemID.Text = "0";
DropDownItemExpID.Text = "0";
TextSerialNo.Text = "";
TextActivationCode.Text = "";
TextExpiredDays.Text = "";
TextStartExpiryDate.Text = "";
conn.Close();
alert_box.Visible = false;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//记录页面使用次数
DB.RecordPageUseCount("CCM_Bloom_Attemper");
date1 = "1910-01";
newdate = false;
int CurrentYear = Convert.ToInt32(DateTime.Now.Year);
int i;
for (i = CurrentYear - 5; i <= CurrentYear; i++)
{
ListItem Year = new ListItem();
Year.Text = Convert.ToString(i);
Year.Value = Convert.ToString(i);
if (i == CurrentYear)
{
Year.Selected = true;
}
else
{
Year.Selected = false;
}
ddlYear.Items.Add(Year);
//EndYear.Items.Add(Year);
}
string CurrentDate = Convert.ToString(DateTime.Now.Month);
if (CurrentDate.Length == 1)
{
CurrentDate = "0" + CurrentDate;
}
foreach (ListItem Month in ddlMonth.Items)
{
if (Month.Text == CurrentDate)
{
Month.Selected = true;
ddlMonth.Text = Month.Text;
//EndMonth.Text = Month.Text;
break;
}
else
{
Month.Selected = false;
}
}
AddDate(sender, e);
CurrentDate = Convert.ToString(DateTime.Now.Day);
if (CurrentDate.Length == 1)
{
CurrentDate = "0" + CurrentDate;
}
foreach (ListItem day in ddlDay.Items)
{
if (day.Text == CurrentDate)
{
day.Selected = true;
ddlDay.Text = day.Text;
//EndDay.Text = day.Text;
break;
}
else
{
day.Selected = false;
}
}
}
else
{
date1 = ddlYear.SelectedValue.ToString() + '-' + ddlMonth.SelectedValue.ToString() + '-' + ddlDay.SelectedValue.ToString();
string strCurrentDate = date1;
OracleConnection conn = DB.createConn();
try
{
OracleDataAdapter da = new OracleDataAdapter();
if (newdate)
{
newdate = false;
}
conn.Open();
string strSQL = "Select * from TC_BLOOM_ATTEMPER where LOGTIME='" + strCurrentDate + "' order by length,STEELGRADE";
da.SelectCommand = new OracleCommand(strSQL, conn);
DataSet ds = new DataSet();
da.Fill(ds, "TC_BLOOM_ATTEMPER");
rdt.Load(this.Server.MapPath("").ToString() + "\\Bloom_Attemper.rpt");
//rdt.PrintOptions.PrinterName = "Microsoft Office Document Image Writer";
rdt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperEsheet;
rdt.SetDataSource(ds);
CrystalReportViewer1.ReportSource = rdt;
CrystalReportViewer1.DataBind();
ds.Dispose();
}
catch (Exception ee)
{
Response.Write(ee.ToString());//"出错");
}
finally
{
conn.Close();
}
}
}
private DataSet CallSP3(SQLInboundChanel ch, OracleCommand cmd)
{
if (ch.CallSPAsSQLText)
{
cmd.CommandType = CommandType.Text;
}
else
{
cmd.CommandType = CommandType.StoredProcedure;
}
#region Log Prameter
Program.Log.Write(" ============ Storage Procedure Parameter===============");
foreach (OracleParameter p in cmd.Parameters)
{
string str = "";
if (p.Value == null)
{
str = "(null)";
}
else if (p.Value == DBNull.Value)
{
str = "(dbnull)";
}
else
{
str = p.Value.ToString();
}
Program.Log.Write(p.ParameterName + "=" + str);
}
Program.Log.Write(" ========================= Parameter End ===============");
#endregion
Program.Log.Write("CommandText='" + cmd.CommandText + "'");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("mc", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
try
{
DataSet ds = new DataSet();
using (OracleDataAdapter da = new OracleDataAdapter(cmd))
{
da.Fill(ds);
return(ds);
}
}
catch (OracleException err)
{
string errMsg = err.ToString();
Program.Log.Write(LogType.Error, errMsg);
if (SQLInAdapterConfigMgt.SQLInAdapterConfig.ThirdPartyInteractConfig.ConnectionParameter.SuicideWhenOleDbException)
{
string errCode = SQLInAdapterConfigMgt.SQLInAdapterConfig.ThirdPartyInteractConfig.ConnectionParameter.SuicideWhenOleDbExceptionErrorCodeExclude;
if (!string.IsNullOrEmpty(errCode))
{
if (errMsg.IndexOf(errCode) >= 0)
{
Program.Log.Write(LogType.Error, "Ignore error code: " + errCode);
return(null);
}
}
Program.Log.Write(LogType.Error, "Killing myself now.");
System.Diagnostics.Process.GetCurrentProcess().Kill();
}
return(null);
}
}
public void carga_articulos()
{
String rutaXml = Server.MapPath("./sessiones/") + "usuario_" + Session.SessionID + ".xml";
OracleConnection CnOra = new OracleConnection(conexion_cliente_oracle);
OracleCommand cmdAcceso = new OracleCommand("PK_CARGA_DD_GUIA.CARGA_ARTICULOS", CnOra);
OracleDataAdapter da = new OracleDataAdapter(cmdAcceso);
articulos.Columns[0].Visible = true;
PRO.agrega_parametro_sp(da, "o_cursor", OracleType.Cursor, ParameterDirection.Output, "");
PRO.agrega_parametro_sp(da, "numero_guia", OracleType.Number, ParameterDirection.Input, numero_guia.Text);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dtArticulos = new DataTable();
try
{
CnOra.Open();
da.Fill(dtArticulos);
CnOra.Close();
CnOra.Dispose();
}
catch (Exception ex) {
}
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("ID_DETALLE_GUIA", typeof(String)));
dt.Columns.Add(new DataColumn("ID_GUIA", typeof(String)));
dt.Columns.Add(new DataColumn("CODIGO_ARTICULO", typeof(String)));
dt.Columns.Add(new DataColumn("NOMBRE_ARTICULO", typeof(String)));
dt.Columns.Add(new DataColumn("CANTIDAD", typeof(String)));
dt.Columns.Add(new DataColumn("DIAMETRO", typeof(String)));
dt.Columns.Add(new DataColumn("NUMERO_GUIA", typeof(String)));
DataRow dr;
int total = 0;
foreach (DataRow drArticulo in dtArticulos.Rows)
{
dr = dt.NewRow();
dr["ID_DETALLE_GUIA"] = drArticulo["ID_DETALLE_GUIA"].ToString();
dr["ID_GUIA"] = drArticulo["ID_GUIA"].ToString();
dr["NUMERO_GUIA"] = numero_guia.Text;
dr["CODIGO_ARTICULO"] = drArticulo["CODIGO_ARTICULO"].ToString();
dr["NOMBRE_ARTICULO"] = drArticulo["NOMBRE_ARTICULO"].ToString();
dr["CANTIDAD"] = drArticulo["CANTIDAD"].ToString();
dr["DIAMETRO"] = drArticulo["DIAMETRO"].ToString();
dt.Rows.Add(dr);
total = total + 1;
}
DataView MydataView;
MydataView = new DataView(dt);
articulos.DataSource = MydataView;
articulos.DataBind();
articulos.Columns[0].Visible = false;
articulos.Columns[1].Visible = false;
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
double x_ZB = Convert.ToDouble(context.Request["X"]);
double y_ZB = Convert.ToDouble(context.Request["Y"]);
string dt = Convert.ToString(context.Request["dateTime"]);
DataSet ds;
OracleDataAdapter sda;
OracleConnection conn = new OracleConnection("data source=ORCL;user=LGY;password=123456;");
conn.Open();
OracleCommand cmd = new OracleCommand("select dianming,aqi,no2,pm25,pm10,so2,o3,co,X,Y from (select * from shipinchang0 union all select * from kechechang0 union all select * from youdianxueyuan0 union all select * from laodonggongyuan0 union all select * from yuanlinchu0 union all select * from jingyuetan0 union all select * from shuaiwanzi0 union all select * from jingkaiquhuanweichu0 union all select * from gaoxinquguanweihui0 union all select * from daishangongyuan0) where riqi=to_date(' " + dt + " ' ,'yyyy-mm-dd')", conn);
sda = new OracleDataAdapter();
sda.SelectCommand = cmd;
ds = new DataSet();
sda.Fill(ds, "WMXX");
// 计算距离权重
double[] jili = new double[10];
double jili_sum = 0;
for (int i = 0; i < 10; i++)
{
double xx = Convert.ToDouble(ds.Tables[0].Rows[i][8].ToString()); //x坐标
double yy = Convert.ToDouble(ds.Tables[0].Rows[i][9].ToString()); //y
jili[i] = Math.Sqrt(Math.Pow((xx - x_ZB), 2) + Math.Pow((yy - y_ZB), 2));
jili_sum += jili[i];
}
double AQI_DanDian = 0;
double no2_DanDian = 0;
double pm25_DanDian = 0;
double pm10_DanDian = 0;
double so2_DanDian = 0;
double o3_DanDian = 0;
double co_DanDian = 0;
//按距离计算各参数
for (int i = 0; i < 10; i++)
{
double aqi = Convert.ToDouble(ds.Tables[0].Rows[i][1].ToString());
AQI_DanDian += aqi * jili[i] / jili_sum;
double no2 = Convert.ToDouble(ds.Tables[0].Rows[i][2].ToString());
no2_DanDian += no2 * jili[i] / jili_sum;
double pm25 = Convert.ToDouble(ds.Tables[0].Rows[i][3].ToString());
pm25_DanDian += pm25 * jili[i] / jili_sum;
double pm10 = Convert.ToDouble(ds.Tables[0].Rows[i][4].ToString());
pm10_DanDian += pm10 * jili[i] / jili_sum;
double so2 = Convert.ToDouble(ds.Tables[0].Rows[i][5].ToString());
so2_DanDian += so2 * jili[i] / jili_sum;
double o3 = Convert.ToDouble(ds.Tables[0].Rows[i][6].ToString());
o3_DanDian += o3 * jili[i] / jili_sum;
double co = Convert.ToDouble(ds.Tables[0].Rows[i][7].ToString());
co_DanDian += co * jili[i] / jili_sum;
}
context.Response.Write(AQI_DanDian + "," + no2_DanDian + "," + pm25_DanDian + "," + pm10_DanDian + "," + so2_DanDian + "," + o3_DanDian + "," + co_DanDian);
}
public void cargaDetalle(String servicio, String grupo)
{
OracleConnection CnOra = new OracleConnection(conexion_cliente_oracle);
OracleCommand cmdAcceso = new OracleCommand("PK_ORDEN.CARGA_DET_HISTORICO", CnOra);
OracleDataAdapter da = new OracleDataAdapter(cmdAcceso);
String rutaXml = Server.MapPath("./sessiones/") + "usuario_" + Session.SessionID + ".xml";
PRO.agrega_parametro_sp(da, "o_cursor", OracleType.Cursor, ParameterDirection.Output, "");
PRO.agrega_parametro_sp(da, "i_rutem", OracleType.NVarChar, ParameterDirection.Input, PRO.recSession(rutaXml, "RUT_EMPRESA"));
PRO.agrega_parametro_sp(da, "i_servicio", OracleType.NVarChar, ParameterDirection.Input, servicio);
PRO.agrega_parametro_sp(da, "i_grupo", OracleType.NVarChar, ParameterDirection.Input, grupo);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataTable dtOrdenes = new DataTable();
try
{
CnOra.Open();
da.Fill(dtOrdenes);
CnOra.Close();
CnOra.Dispose();
}
catch (Exception ex)
{
//lbErrorGrilla.ForeColor = System.Drawing.Color.Red;
//lbErrorGrilla.Text = ex.Message.ToString();
//lbErrorGrilla.Text = ex.ToString();
}
DataTable dt = new DataTable();
/*
* dt.Columns.Add(new DataColumn("ID_ORDEN", typeof(Int32)));
* dt.Columns.Add(new DataColumn("NUMERO_ORDEN", typeof(Int32)));
* dt.Columns.Add(new DataColumn("ID_SERVICIO", typeof(String)));
* dt.Columns.Add(new DataColumn("LECTURA_RET", typeof(Int32)));
* dt.Columns.Add(new DataColumn("DIAMETRO_RET", typeof(Int32)));
* dt.Columns.Add(new DataColumn("ANO_MN", typeof(String)));
* dt.Columns.Add(new DataColumn("NUMERO_MN", typeof(String)));
* dt.Columns.Add(new DataColumn("DIAMETRO_NU", typeof(Int32)));
* dt.Columns.Add(new DataColumn("LECTURA_MN", typeof(Int32)));
* dt.Columns.Add(new DataColumn("MATERIAL_VARAL", typeof(String)));
* dt.Columns.Add(new DataColumn("TIPO_LLAVE_PASO", typeof(String)));
* dt.Columns.Add(new DataColumn("NUM_SELLO", typeof(String)));
* dt.Columns.Add(new DataColumn("COLOR_SELLO", typeof(String)));
* dt.Columns.Add(new DataColumn("RUT_CLIENTE", typeof(String)));
* dt.Columns.Add(new DataColumn("OBSERVACION_OUT", typeof(String)));
* dt.Columns.Add(new DataColumn("FECHA_CREACION", typeof(String)));
* dt.Columns.Add(new DataColumn("FECHA_INST", typeof(String)));
* dt.Columns.Add(new DataColumn("LOCALIDAD", typeof(String)));
* dt.Columns.Add(new DataColumn("DIRECCION", typeof(String)));
* dt.Columns.Add(new DataColumn("CLIENTE", typeof(String)));
* dt.Columns.Add(new DataColumn("RUTA", typeof(String)));
* dt.Columns.Add(new DataColumn("COD_INSTALADOR", typeof(String)));
* dt.Columns.Add(new DataColumn("TIPO_MARCA_DI", typeof(String)));
* dt.Columns.Add(new DataColumn("X", typeof(String)));
* dt.Columns.Add(new DataColumn("Y", typeof(String)));
* dt.Columns.Add(new DataColumn("ORDEN_ESTATUS", typeof(String)));
* dt.Columns.Add(new DataColumn("ESTATUS_MEDIDOR", typeof(String)));
* dt.Columns.Add(new DataColumn("MARCA", typeof(String)));
* dt.Columns.Add(new DataColumn("VARAL_ESTATUS", typeof(String)));
* dt.Columns.Add(new DataColumn("LLAVE_ESTATUS", typeof(String)));
* dt.Columns.Add(new DataColumn("CAMBIO_CAUSA", typeof(String)));
* dt.Columns.Add(new DataColumn("NOMBRE", typeof(String)));
* dt.Columns.Add(new DataColumn("ID_PROCESO", typeof(Int32)));
* dt.Columns.Add(new DataColumn("GRUPO_PROCESO", typeof(String)));
* dt.Columns.Add(new DataColumn("ID_TIPO_PROCESO", typeof(Int32)));
* dt.Columns.Add(new DataColumn("DETALLE", typeof(String)));
*/
dt.Columns.Add(new DataColumn("TIPO_MARCA_DI", typeof(String)));
dt.Columns.Add(new DataColumn("OBSERVACION_IN", typeof(String)));
dt.Columns.Add(new DataColumn("OBSERVACION_OUT", typeof(String)));
DataRow dr;
int total = 0;
foreach (DataRow drOrdenItem in dtOrdenes.Rows)
{
dr = dt.NewRow();
/*
* dr["ID_ORDEN"] = drOrdenItem["ID_ORDEN"].ToString();
* dr["NUMERO_ORDEN"] = drOrdenItem["NUMERO_ORDEN"].ToString();
* dr["ID_SERVICIO"] = drOrdenItem["ID_SERVICIO"].ToString();
* dr["LECTURA_RET"] = drOrdenItem["LECTURA_RET"].ToString();
* dr["DIAMETRO_RET"] = drOrdenItem["DIAMETRO_RET"].ToString();
* dr["ANO_MN"] = drOrdenItem["ANO_MN"].ToString();
* dr["NUMERO_MN"] = drOrdenItem["NUMERO_MN"].ToString();
* dr["DIAMETRO_NU"] = drOrdenItem["DIAMETRO_NU"].ToString();
* dr["LECTURA_MN"] = drOrdenItem["LECTURA_MN"].ToString();
* dr["MATERIAL_VARAL"] = drOrdenItem["MATERIAL_VARAL"].ToString();
* dr["TIPO_LLAVE_PASO"] = drOrdenItem["TIPO_LLAVE_PASO"].ToString();
* dr["NUM_SELLO"] = drOrdenItem["NUM_SELLO"].ToString();
* dr["COLOR_SELLO"] = drOrdenItem["COLOR_SELLO"].ToString();
* dr["RUT_CLIENTE"] = drOrdenItem["RUT_CLIENTE"].ToString();
* dr["OBSERVACION_OUT"] = drOrdenItem["OBSERVACION_OUT"].ToString();
* dr["FECHA_CREACION"] = drOrdenItem["FECHA_CREACION"].ToString();
* dr["FECHA_INST"] = drOrdenItem["FECHA_INST"].ToString();
* dr["LOCALIDAD"] = drOrdenItem["LOCALIDAD"].ToString();
* dr["DIRECCION"] = drOrdenItem["DIRECCION"].ToString();
* dr["CLIENTE"] = drOrdenItem["CLIENTE"].ToString();
* dr["RUTA"] = drOrdenItem["RUTA"].ToString();
* dr["COD_INSTALADOR"] = drOrdenItem["COD_INSTALADOR"].ToString();
* dr["TIPO_MARCA_DI"] = drOrdenItem["TIPO_MARCA_DI"].ToString();
* dr["X"] = drOrdenItem["X"].ToString();
* dr["Y"] = drOrdenItem["Y"].ToString();
* dr["ORDEN_ESTATUS"] = drOrdenItem["ORDEN_ESTATUS"].ToString();
* dr["ESTATUS_MEDIDOR"] = drOrdenItem["ESTATUS_MEDIDOR"].ToString();
* dr["MARCA"] = drOrdenItem["MARCA"].ToString();
* dr["VARAL_ESTATUS"] = drOrdenItem["VARAL_ESTATUS"].ToString();
* dr["LLAVE_ESTATUS"] = drOrdenItem["LLAVE_ESTATUS"].ToString();
* dr["CAMBIO_CAUSA"] = drOrdenItem["CAMBIO_CAUSA"].ToString();
* dr["NOMBRE"] = drOrdenItem["NOMBRE"].ToString();
* dr["ID_PROCESO"] = drOrdenItem["ID_PROCESO"].ToString();
* dr["GRUPO_PROCESO"] = drOrdenItem["GRUPO_PROCESO"].ToString();
* dr["ID_TIPO_PROCESO"] = drOrdenItem["ID_TIPO_PROCESO"].ToString();
* dr["DETALLE"] = drOrdenItem["DETALLE"].ToString();
*/
dr["TIPO_MARCA_DI"] = drOrdenItem["TIPO_MARCA_DI"].ToString();
dr["OBSERVACION_IN"] = drOrdenItem["OBSERVACION_IN"].ToString();
dr["OBSERVACION_OUT"] = drOrdenItem["OBSERVACION_OUT"].ToString();
dt.Rows.Add(dr);
total = total + 1;
lbTmd.Text = dr["TIPO_MARCA_DI"].ToString();
txtIn.Text = dr["OBSERVACION_IN"].ToString();
txtOut.Text = dr["OBSERVACION_OUT"].ToString();
}
}
protected void carga_detalle(object sender, EventArgs e)
{
// Inicia el contador:
DateTime tiempo1 = DateTime.Now;
try
{
//inicializamos contadores de error...
error_otro = error_cod = error_cant = error_diam = error_no_existe_diametro = error_no_existe_marca = registros_no_ingresados = 0;
String ruta = Server.MapPath("./TXT/" + fuArchivo.PostedFile.FileName);
String ext = Path.GetExtension(fuArchivo.PostedFile.FileName).ToString();
int cont = 0;
if (System.IO.File.Exists(ruta) == false)
{
if (true)
{
fuArchivo.SaveAs(ruta);
StreamReader sr = new StreamReader(ruta);
String x = "";
String line;
String[] miArray;
int noIn = 0;
do
{
line = sr.ReadLine();
line = limpiar(line);
try
{
if (line != null)
{
miArray = line.Split(';');
if (valida_registro(miArray))
{
OracleDataAdapter ComandoDA;
OracleConnection objConexion = new OracleConnection(conexion_cliente_oracle);
objConexion.Open();
ComandoDA = new OracleDataAdapter("PK_CARGA_DD_GUIA.CARGA_INSERCION_DETALLE", objConexion);
PRO.agrega_parametro_sp(ComandoDA, "i_guia", OracleType.NVarChar, ParameterDirection.Input, numero_guia.Text);
PRO.agrega_parametro_sp(ComandoDA, "i_codigo", OracleType.Number, ParameterDirection.Input, miArray[0]);
PRO.agrega_parametro_sp(ComandoDA, "i_cantidad", OracleType.Number, ParameterDirection.Input, miArray[3]);
PRO.agrega_parametro_sp(ComandoDA, "i_diametro", OracleType.Number, ParameterDirection.Input, miArray[2]);
//PRO.agrega_parametro_sp(ComandoDA, "i_tipo", OracleType.NVarChar, ParameterDirection.Input, miArray[1]);
ComandoDA.SelectCommand.CommandType = CommandType.StoredProcedure;
ComandoDA.SelectCommand.ExecuteNonQuery();
objConexion.Close();
cont = cont + 1;
objConexion.Dispose();
}
else
{
registros_no_ingresados = registros_no_ingresados + 1;
}
}
}
catch (Exception ex)
{
registros_no_ingresados = registros_no_ingresados + 1;
error_otro++;
}
} while (line != null);
if (registros_no_ingresados > 0)
{
String detalle = log_error();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SomestartupScript", " carga_con_error('" + detalle + "','" + registros_no_ingresados + "');", true);
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SomestartupScript", " carga_realizada('" + cont + "');", true);
}
carga_articulos();
}
}
else
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SomestartupScript", " error('El archivo ya existe');", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "SomestartupScript", " error(''No se pudo cargar);", true);
}
}
public static DataTable DataTable()
{
string connString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
OracleConnection con = new OracleConnection(connString);
con.Open();
string cmd = "SELECT * " +
" FROM (SELECT ROWNUM as Items, E.* " +
" FROM (SELECT DISTINCT A.* " +
" FROM QCMainInfo A " +
" LEFT JOIN QCConstructionDtl B " +
" ON A.Quality_Code = B.Quality_Code " +
" LEFT JOIN QCFinishDtl C " +
" ON A.Quality_COde = C.Quality_Code " +
" LEFT JOIN QCCustomerLibrary D " +
" ON D.Quality_Code = A.Quality_Code " +
" LEFT JOIN QCCustomerLibrary F " +
" ON F.Quality_Code=A.Quality_Code " +
" where 1=1 " + a + " order by A.Quality_Code asc ) E) ";
using (OracleDataAdapter oleAdper = new OracleDataAdapter(cmd, con))
{
DataTable result = new DataTable("table");
oleAdper.Fill(result);
if (result.Rows.Count >= 100)
{
string cmds = @"
select
distinct
A.quality_code,A.status, A.replace_by, A.repeat,
L.ApprovedFromSPPO,
L.ApprovedFromSPPO_Usage,
to_char(S.descriptions) as construction ,
to_char(K.finishing_name) as Finishing,A.pattern, (N.DESCRIPTION) as DYE_METHOD , A.bf_gmmm,
A.af_gmmm, A.shrinkage, A.shrinkage_testing_method,
A.gmt_washing,to_char(J.customer_quality_id) as customer_quality_id,
to_char(H.AvailableWidth) as AvailableWidth,
A.remark,to_char(I.YarnInfo) as YarnInfo,A.layout, A.yarn_length, A.tapping_type ,(A.special_type ) as Heavy_Flat_Knit,
to_char(J.mill_comments) as mill_comments,A.measurement, A.sourcing, A.create_date, A.material_group,
A.analysis_no, A.ref_quality_code, A.creator, A.approve_date, A.approver,
to_char(J.buyer_id) as buyer_id, to_char(J.brand) as Branks,
A.gk_no, A.qc_ref_ppo, A.qc_ref_gp, A.hf_ref_ppo, A.hf_ref_gp,M.customercomment
from QCMainInfo A
left join QCConstructionDtl B on A.Quality_Code = B.Quality_Code
left join QCFinishDtl C on A.Quality_COde = C.Quality_Code
left join QCCustomerLibrary D on A.Quality_Code = D.Quality_Code
left join QCCustomerLibrary F on A.Quality_Code = F.Quality_Code
left join (
select * from ( select Quality_Code , wm_concat(to_char(description)) as descriptions from QCConstructionDtl G
left join Pbknitconstruction S on S.construction=G.construction
group by Quality_Code )) S on A.Quality_Code=S.Quality_Code
-- left join QCConstructionDtl G on A.Quality_Code = G.Quality_Code
-- left join Pbknitconstruction M on M.construction=G.construction
left join PBKNITDYEMETHOD N on A.DYE_METHOD =N.DYE_METHOD
left join
(select * from (select quality_code, (wmsys.wm_concat(''||gauge||'G'||diameter||'Inch/'||total_needles||'N/'||width||'-'||max_width||'\' )) as AvailableWidth
from qcavailablewidth where 1=1 group by quality_code) ) H
on A.Quality_Code = H.Quality_Code
left join
(select * from ( select quality_code,( wmsys.wm_concat( ''||yarn_count||'X'||threads||''||b.DESCRIPTION||''||yarn_ratio||'% '||yarn_component||'' ))as YarnInfo from qcyarndtl a left join PBKNITYARNTYPE b on a.YARN_TYPE=b.YARN_TYPE
where 1=1 group by quality_code) ) I
on A.Quality_Code = I.Quality_Code
left join
(select * from (select quality_code , (wmsys.wm_concat(buyer_id)) as buyer_id , (wmsys.wm_concat(brand)) as brand,
(wmsys.wm_concat(customer_quality_id)) as customer_quality_id,(wmsys.wm_concat(mill_comments) ) as mill_comments from QCCustomerLibrary where 1=1 group by quality_code)) J
on A.Quality_Code=j.Quality_Code
left join
(select * from (select quality_code, (wmsys.wm_concat(z.finishing_name )) as finishing_name
from QCFinishDtl y, pbknitfinish Z
where y.finishing_code= z.finishing_code group by quality_code)) K
on A.Quality_Code = K.Quality_Code
left join
(
select quality_code,
ApprovedFromSPPO,ApprovedFromSPPO_Usage
from
(
--modify:gaofeng 2021/01/18 <2021-0001 QC System Enhancement from sales> --begin
--select ROW_NUMBER() OVER(PARTITION BY quality_code ORDER BY approve_date desc) rn,
--quality_code, ApprovedFromSPPO from (SELECT distinct qm.quality_code,( pi.ppo_no|| '('||pi.FABRIC_TYPE_CD ||')' ) as ApprovedFromSPPO ,QCC.approve_date
--FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm
--WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id
--and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and pic.fab_combo_id=fc.fab_combo_id
--and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' )s ) where rn=1
select ROW_NUMBER() OVER(PARTITION BY quality_code ORDER BY approve_date desc) rn,
quality_code,
ApprovedFromSPPO,ApprovedFromSPPO_Usage
from (
SELECT distinct qm.quality_code,
--( pi.ppo_no|| '('||pi.FABRIC_TYPE_CD ||')' ) as ApprovedFromSPPO ,
pi.ppo_no as ApprovedFromSPPO,
pi.FABRIC_TYPE_CD as ApprovedFromSPPO_Usage,
QCC.approve_date
FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm
WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id
and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and pic.fab_combo_id=fc.fab_combo_id
and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' )s ) where rn=1
--modify:gaofeng 2021/01/18 <2021-0001 QC System Enhancement from sales> --end
) L
on A.Quality_Code = L.Quality_Code
left join
( select * from
(SELECT ROW_NUMBER() OVER(PARTITION BY pi.quality_code ORDER BY qcc.customer_comment ) rn, (qcc.customer_comment ) as customercomment ,pi.quality_code
FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm
WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and qm.Material_Group<>'Flat Knit Fabric'
AND pic.fab_combo_id=fc.fab_combo_id and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd
)s WHERE rn = 1 ) M
on A.Quality_Code = M.quality_code where 1=1
" + a + " order by A.Quality_Code asc ";
using (OracleDataAdapter oleAdpers = new OracleDataAdapter(cmds, con))
{
DataTable results = new DataTable("table");
oleAdpers.Fill(results);
results.Columns["QUALITY_CODE"].ColumnName = "QualityCode";
results.Columns["STATUS"].ColumnName = "Status";
results.Columns["REPLACE_BY"].ColumnName = "ReplaceBy";
results.Columns["REPEAT"].ColumnName = "Repeat";
results.Columns["APPROVEDFROMSPPO"].ColumnName = "ApprovedFromSPPO";
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin
results.Columns["APPROVEDFROMSPPO_USAGE"].ColumnName = "ApprovedFromSPPO_Usage";
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end
results.Columns["CONSTRUCTION"].ColumnName = "Construction";
results.Columns["FINISHING"].ColumnName = "Finishing";
results.Columns["PATTERN"].ColumnName = "Pattern";
results.Columns["DYE_METHOD"].ColumnName = "DyeMethod";
results.Columns["BF_GMMM"].ColumnName = "BfGmmm";
results.Columns["AF_GMMM"].ColumnName = "AfGmmm";
results.Columns["SHRINKAGE"].ColumnName = "Shrinkage";
results.Columns["SHRINKAGE_TESTING_METHOD"].ColumnName = "ShrinkageTestingMethod";
results.Columns["GMT_WASHING"].ColumnName = "GmtWashing";
results.Columns["CUSTOMER_QUALITY_ID"].ColumnName = "CustomerQualityId";
results.Columns["AVAILABLEWIDTH"].ColumnName = "Available Width";
results.Columns["REMARK"].ColumnName = "Available Width Remark";
results.Columns["YARNINFO"].ColumnName = "YarnInfo";
results.Columns["LAYOUT"].ColumnName = "Layout";
results.Columns["YARN_LENGTH"].ColumnName = "YarnLength";
results.Columns["TAPPING_TYPE"].ColumnName = "TappingType";
results.Columns["HEAVY_FLAT_KNIT"].ColumnName = "Heavy_Flat_Knit";
results.Columns["MILL_COMMENTS"].ColumnName = "MillComments";
results.Columns["MEASUREMENT"].ColumnName = "Measurement";
results.Columns["SOURCING"].ColumnName = "Sourcing";
results.Columns["CREATE_DATE"].ColumnName = "CreateDate";
results.Columns["MATERIAL_GROUP"].ColumnName = "MaterialGroup";
results.Columns["ANALYSIS_NO"].ColumnName = "AnalysisNo";
results.Columns["REF_QUALITY_CODE"].ColumnName = "RefQualityCode";
results.Columns["CREATOR"].ColumnName = "Creator";
results.Columns["APPROVE_DATE"].ColumnName = "ApproveDate";
results.Columns["APPROVER"].ColumnName = "Approver";
results.Columns["BUYER_ID"].ColumnName = "BuyerIds";
results.Columns["BRANKS"].ColumnName = "Branks";
results.Columns["GK_NO"].ColumnName = "GK_NO";
results.Columns["QC_REF_PPO"].ColumnName = "QC_Ref_PPO";
results.Columns["QC_REF_GP"].ColumnName = "QC_Ref_GP";
results.Columns["HF_REF_PPO"].ColumnName = "HF_Ref_PPO";
results.Columns["HF_REF_GP"].ColumnName = "HF_Ref_GP";
results.Columns["CUSTOMERCOMMENT"].ColumnName = "CustomerComment";
return(results);
}
}
else
{
DataTable dtt = new DataTable();
dtt.Columns.Add("QualityCode", typeof(string));
dtt.Columns.Add("Status", typeof(string));
dtt.Columns.Add("ReplaceBy", typeof(string));
dtt.Columns.Add("Repeat", typeof(string));
dtt.Columns.Add("ApprovedFromSPPO", typeof(string));
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin
dtt.Columns.Add("ApprovedFromSPPO_Usage", typeof(string));
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end
dtt.Columns.Add("Construction", typeof(string));
dtt.Columns.Add("Finishing", typeof(string));
dtt.Columns.Add("Pattern", typeof(string));
dtt.Columns.Add("DyeMethod", typeof(string));
dtt.Columns.Add("BfGmmm", typeof(string));
dtt.Columns.Add("AfGmmm", typeof(string));
dtt.Columns.Add("Shrinkage", typeof(string));
dtt.Columns.Add("ShrinkageTestingMethod", typeof(string));
dtt.Columns.Add("GmtWashing", typeof(string)); http://localhost:58826/Service References/
dtt.Columns.Add("CustomerQualityId", typeof(string));
dtt.Columns.Add("Available Width", typeof(string));
dtt.Columns.Add("Available Width Remark", typeof(string));
dtt.Columns.Add("YarnInfo", typeof(string));
dtt.Columns.Add("Layout", typeof(string));
dtt.Columns.Add("YarnLength", typeof(string));
dtt.Columns.Add("TappingType", typeof(string));
dtt.Columns.Add("Heavy_Flat_Knit", typeof(string));
dtt.Columns.Add("MillComments", typeof(string));
dtt.Columns.Add("Measurement", typeof(string));
dtt.Columns.Add("Sourcing", typeof(string));
dtt.Columns.Add("CreateDate", typeof(string));
dtt.Columns.Add("MaterialGroup", typeof(string));
dtt.Columns.Add("AnalysisNo", typeof(string));
dtt.Columns.Add("RefQualityCode", typeof(string));
dtt.Columns.Add("Creator", typeof(string));
dtt.Columns.Add("ApproveDate", typeof(string));
dtt.Columns.Add("Approver", typeof(string));
dtt.Columns.Add("BuyserIds", typeof(string));
dtt.Columns.Add("Branks", typeof(string));
dtt.Columns.Add("GK_NO", typeof(string));
dtt.Columns.Add("QC_Ref_PPO", typeof(string));
dtt.Columns.Add("QC_Ref_GP", typeof(string));
dtt.Columns.Add("HF_Ref_PPO", typeof(string));
dtt.Columns.Add("HF_Ref_GP", typeof(string));
dtt.Columns.Add("CustomerComment", typeof(string));
string connStrings = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
OracleConnection cons = new OracleConnection(connStrings);
cons.Open();
string Sql1 =
"SELECT * " +
" FROM (SELECT ROWNUM as Items, E.* " +
" FROM (SELECT DISTINCT A.* " +
" FROM QCMainInfo A " +
" LEFT JOIN QCConstructionDtl B " +
" ON A.Quality_Code = B.Quality_Code " +
" LEFT JOIN QCFinishDtl C " +
" ON A.Quality_COde = C.Quality_Code " +
" LEFT JOIN QCCustomerLibrary D " +
" ON D.Quality_Code = A.Quality_Code " +
" LEFT JOIN QCCustomerLibrary F " +
" ON F.Quality_Code=A.Quality_Code " +
" where 1=1 @Condition order by A.Quality_Code asc ) E) ";
PbknityarntypeManager yarnManager = new PbknityarntypeManager();//kingzhang for support 709786 对于YarnInfo字符串中的Yarn_Type信息替换为pbKnitYarnType.description
QcconstructiondtlManager qcm = new QcconstructiondtlManager();
QcfinishdtlManager qsm = new QcfinishdtlManager();
QccustomerlibraryManager qlm = new QccustomerlibraryManager();
QcconstructiondtlModelList qcml = new QcconstructiondtlModelList();
QcfinishdtlModelList qsml = new QcfinishdtlModelList();
QccustomerlibraryModelList qclm = new QccustomerlibraryModelList();
QcavailablewidthModelList qsaw = new QcavailablewidthModelList();
QcavailablewidthManager qcam = new QcavailablewidthManager();
QcyarndtlManager qym = new QcyarndtlManager();
QcyarndtlModelList qyml = new QcyarndtlModelList();
DataSet ds;
CustomSqlSection css;
DataTable dt;
QcmaininfoTable table = new QcmaininfoTable();
Sql1 = Sql1.Replace("@Condition", a.ToString());
CustomSqlSection csql1 = DataAccess.DefaultDB.CustomSql(Sql1);
using (SafeDataReader sdr = new SafeDataReader(csql1.ToDataReader()))
{
while (sdr.Read())
{
QcmaininfoModel m = new QcmaininfoModel();
m.QualityCode = sdr.GetString(table.QualityCode);
qcml = qcm.GetModelListOne(new QcconstructiondtlModel()
{
QualityCode = m.QualityCode
});
for (int i = 0; i < qcml.Count; i++)
{
m.Construction = m.Construction + qcml[i].Construction + ";";
}
qsml = qsm.GetModelListOne(new QcfinishdtlModel()
{
QualityCode = m.QualityCode
});
for (int i = 0; i < qsml.Count; i++)
{
m.Finishing = m.Finishing + qsml[i].FinishingCode + ";";
}
qclm = qlm.GetModelList(new QccustomerlibraryModel()
{
QualityCode = m.QualityCode
});
for (int i = 0; i < qclm.Count; i++)
{
m.CustomerQualityId = m.CustomerQualityId + qclm[i].CustomerQualityId + ";";
m.BuyserIds = m.BuyserIds + qclm[i].BuyerId + ";";
m.Brank = m.Brank + qclm[i].Brand + ";";
m.MillComments = m.MillComments + qclm[i].MillComments + ";";
}
qsaw = qcam.GetModelList(new QcavailablewidthModel()
{
QualityCode = m.QualityCode
});
for (int i = 0; i < qsaw.Count; i++)
{
if (i != qsaw.Count - 1)
{
m.AvaWidth = m.AvaWidth + string.Format("{0}G{1}Inch/{2}N/{3}-{4}\"", qsaw[i].Gauge, qsaw[i].Diameter, qsaw[i].TotalNeedles, qsaw[i].Width, qsaw[i].MaxWidth) + "--";
}
else
{
m.AvaWidth = m.AvaWidth + string.Format("{0}G{1}Inch/{2}N/{3}-{4}\"", qsaw[i].Gauge, qsaw[i].Diameter, qsaw[i].TotalNeedles, qsaw[i].Width, qsaw[i].MaxWidth);
}
}
qyml = qym.GetModelList(new QcyarndtlModel()
{
QualityCode = m.QualityCode
});
for (int i = 0; i < qyml.Count; i++)
{
PbknityarntypeModelList yarnModel = yarnManager.GetModelList(new PbknityarntypeModel()
{
YarnType = qyml[i].YarnType
}); //kingzhang for support 709786 对于YarnInfo字符串中的Yarn_Type信息替换为pbKnitYarnType.description
if (i != qyml.Count - 1)
{
m.YarnInfo = m.YarnInfo + string.Format("{0}X{1} {2} {3}% {4}", qyml[i].YarnCount, qyml[i].Threads, yarnModel.Count > 0 ? yarnModel[0].Description : qyml[i].YarnType, qyml[i].YarnRatio, qyml[i].YarnComponent) + "--";
}
else
{
m.YarnInfo = m.YarnInfo + string.Format("{0}X{1} {2} {3}% {4}", qyml[i].YarnCount, qyml[i].Threads, yarnModel.Count > 0 ? yarnModel[0].Description : qyml[i].YarnType, qyml[i].YarnRatio, qyml[i].YarnComponent);
}
}
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin
css = DataAccess.DefaultDB.CustomSql(@"
select ppo_no as PPO , FABRIC_TYPE_CD
from
(select ROW_NUMBER() OVER(PARTITION BY quality_code ORDER BY approve_date desc) rn,
quality_code,ppo_no, FABRIC_TYPE_CD from (SELECT distinct qm.quality_code, pi.ppo_no ,pi.FABRIC_TYPE_CD ,QCC.approve_date
FROM ppo_hd ph,gen_customer c,ppo_qcmaininfo qc, ppo_item pi, fab_combo fc, ppo_qccomment qcc,ppo_item_combo pic,QCMainInfo qm
WHERE ph.ppo_no=pi.ppo_no and fc.fab_combo_id = qcc.fab_combo_id and qc.ppo_item_id=pi.ppo_item_id
and pi.ppo_item_id=pic.ppo_item_id and pi.quality_code=qm.quality_code and pic.fab_combo_id=fc.fab_combo_id
and qc.ppo_qc_id=qcc.ppo_qc_id and ph.customer_cd=c.customer_cd and QCC.STATUS='Approved' )s ) where rn=1 and quality_code=@QC
");
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end
css.AddInputParameter("QC", DbType.String, m.QualityCode);
ds = css.ToDataSet();
dt = ds.Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
//m.ApprovedFromSPPO = m.ApprovedFromSPPO + dt.Rows[i]["PPO"].ToString() + "(" + dt.Rows[i]["FABRIC_TYPE_CD"].ToString() + ");";
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin
m.ApprovedFromSPPO = m.ApprovedFromSPPO + dt.Rows[i]["PPO"].ToString();
m.ApprovedFromSPPO_Usage = m.ApprovedFromSPPO_Usage + dt.Rows[i]["FABRIC_TYPE_CD"].ToString();
}
;
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end
m.CreateDate = sdr.GetDateTime(table.CreateDate);
m.Creator = sdr.GetString(table.Creator);
m.ApproveDate = sdr.GetDateTime(table.ApproveDate);
m.Approver = sdr.GetString(table.Approver);
m.Status = sdr.GetString(table.Status);
if (m.Status == "NEW")
{
m.Status = "New";
}
m.Sourcing = sdr.GetString(table.Sourcing);
m.MaterialGroup = sdr.GetString(table.MaterialGroup);
m.AnalysisNo = sdr.GetString(table.AnalysisNo);
m.RefQualityCode = sdr.GetString(table.RefQualityCode);
m.Pattern = sdr.GetString(table.Pattern);
m.DyeMethod = sdr.GetString(table.DyeMethod);
m.ReplaceBy = sdr.GetString(table.ReplaceBy);
m.Repeat = sdr.GetString(table.REPEAT);
m.BfGmmm = sdr.GetInt32(table.BfGmmm);
m.AfGmmm = sdr.GetInt32(table.AfGmmm);
m.Shrinkage = sdr.GetString(table.Shrinkage);
m.ShrinkageTestingMethod = sdr.GetString(table.ShrinkageTestingMethod);
m.GmtWashing = sdr.GetString(table.GmtWashing);
m.Layout = sdr.GetString(table.Layout);
m.YarnLength = sdr.GetString(table.YarnLength);
m.TappingType = sdr.GetString(table.TappingType);
m.Measurement = sdr.GetString(table.Measurement);
m.Remark = sdr.GetString(table.Remark);
m.SpecialType = sdr.GetString(table.SpecialType);
m.LastUpdateTime = sdr.GetDateTime(table.LastUpdateTime);
m.LastUpdateBy = sdr.GetString(table.LastUpdateBy);
m.GK_NO = sdr.GetString(table.GK_NO);
m.QC_Ref_PPO = sdr.GetString(table.QC_Ref_PPO);
m.HF_Ref_PPO = sdr.GetString(table.HF_Ref_PPO);
m.QC_Ref_GP = sdr.GetString(table.QC_Ref_GP);
m.HF_Ref_GP = sdr.GetString(table.HF_Ref_GP);
m.CustomerComment = GetCustomerComment(m.QualityCode);
dtt.Rows.Add(m.QualityCode, m.Status, m.ReplaceBy, m.Repeat,
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --begin
m.ApprovedFromSPPO,
m.ApprovedFromSPPO_Usage,
//modify:gaofeng 2021 / 01 / 18 < 2021 - 0001 QC System Enhancement from sales > --end
m.Construction, m.Finishing, m.Pattern, m.DyeMethod, m.BfGmmm,
m.AfGmmm, m.Shrinkage, m.ShrinkageTestingMethod, m.GmtWashing, m.CustomerQualityId,
m.AvaWidth, m.Remark, m.YarnInfo, m.Layout, m.YarnLength,
m.TappingType, m.SpecialType, m.MillComments, m.Measurement, m.Sourcing,
m.CreateDate, m.MaterialGroup, m.AnalysisNo, m.RefQualityCode, m.Creator,
m.ApproveDate, m.Approver, m.BuyserIds, m.Brank, m.GK_NO,
m.QC_Ref_PPO, m.QC_Ref_GP, m.HF_Ref_PPO, m.HF_Ref_GP, m.CustomerComment
);
}
}
return(dtt);
}
}
}
public Boolean valida_registro(String[] arreglo)
{
String val_cod_marca = arreglo[0], val_diametro = arreglo[2], val_cantidad = arreglo[3];
int cont;
//validamos formatos
if (!int.TryParse(val_cod_marca, out cont))
{
error_cod++;
return(false);
}
else if (!int.TryParse(val_diametro, out cont))
{
error_diam++;
return(false);
}
else if (!int.TryParse(val_cantidad, out cont))
{
error_cant++;
return(false);
}
if (int.Parse(val_cantidad) < 1)
{
error_cant++;
return(false);
}
OracleConnection objConexion = new OracleConnection(conexion_cliente_oracle);
OracleDataAdapter objComando;
DataSet objDS = new DataSet();
objConexion.Open();
objComando = new OracleDataAdapter("PK_CARGA_DD_GUIA.VALIDA_DETALLE_GUIA", objConexion);
objComando.SelectCommand.CommandType = CommandType.StoredProcedure;
PRO.agrega_parametro_sp(objComando, "o_cursor", OracleType.Cursor, ParameterDirection.Output, "");
PRO.agrega_parametro_sp(objComando, "i_cod_marca", OracleType.NVarChar, ParameterDirection.Input, val_cod_marca);
PRO.agrega_parametro_sp(objComando, "i_diametro", OracleType.NVarChar, ParameterDirection.Input, val_diametro);
objComando.SelectCommand.ExecuteNonQuery();
objComando.Fill(objDS, "VALIDA");
objConexion.Close();
foreach (DataRow row in objDS.Tables["VALIDA"].Rows)
{
if (row[0].ToString().Equals("0")) //si marca no existe, error.
{
error_no_existe_marca++;
return(false);
}
if (row[1].ToString().Equals("0")) //si diametro no existe, error.
{
error_no_existe_diametro++;
return(false);
}
}
return(true);
}
/// <summary>
/// 执行查询操作，查询结果保存至 DataTable 中。
/// </summary>
/// <param name="sql">sql语句</param>
/// <param name="sqlParams">参数数组</param>
/// <param name="timeOut">等待命令执行的时间（以秒为单位）,默认值为 30 秒。</param>
/// <param name="errorMsg">返回的异常信息</param>
public DataTable QueryDt(string sql, OracleParameter[] sqlParams, int timeOut, out string errorMsg)
{
OracleConnection conn = null;
OracleCommand cmd = new OracleCommand();
OracleDataAdapter adapter = new OracleDataAdapter();
DataTable dt = new DataTable();
errorMsg = string.Empty;
try
{
//取得数据库连接
conn = GetConnection();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
if (sqlParams != null)
{
foreach (OracleParameter sp in sqlParams)
{
cmd.Parameters.Add(sp);
}
}
//等待命令执行的时间（以秒为单位）,默认值为 30 秒。
if (timeOut <= 30)
{
cmd.CommandTimeout = 30;
}
else
{
cmd.CommandTimeout = timeOut;
}
adapter.SelectCommand = cmd;
conn.Open();
adapter.Fill(dt);
}
catch (Exception ex)
{
errorMsg = ex.ToString();
}
finally
{
if (conn != null)
{
conn.Close();
}
cmd.Dispose();
adapter.Dispose();
}
//记录日志
if (!string.IsNullOrEmpty(errorMsg))
{
Log4NetUtil.Error(this, "SQL:" + sql + "|*|ErrorMsg:" + errorMsg);
}
return(dt);
}
public void NonTCSBatchRun()
{
try
{
string vBatchType = "";
string vCompleteBatch = "";
//---------------------------500 Record Trnsfer to TCS batch Table in each time--------------------------
OracleCommand cmdTrnsfer = new OracleCommand("SP_FAS_IBT_POOLING_PROCESS_NT", con);
cmdTrnsfer.CommandType = CommandType.StoredProcedure;
cmdTrnsfer.Parameters.Add("vBatchType", OracleType.VarChar, 100).Direction = ParameterDirection.Output;
cmdTrnsfer.Parameters.Add("vCompleteBatch", OracleType.VarChar, 100).Direction = ParameterDirection.Output;
con.Open();
cmdTrnsfer.ExecuteNonQuery();
vBatchType = cmdTrnsfer.Parameters["vBatchType"].Value.ToString(); // SYSTEM / MANUAL
vCompleteBatch = cmdTrnsfer.Parameters["vCompleteBatch"].Value.ToString(); // YES / NO
con.Close();
//=========================================End Of Data Transfer==========================================
if (vCompleteBatch == "EOF")
{
return;
}
OracleCommand ora_cmd = new OracleCommand("SP_FAS_IBT_BATCHES", con);
ora_cmd.CommandType = CommandType.StoredProcedure;
ora_cmd.Parameters.Add("v_user_name", OracleType.VarChar).Value = "UPLD";
ora_cmd.Parameters.Add("v_request_id", OracleType.VarChar).Value = "01";
ora_cmd.Parameters.Add("vfile", OracleType.VarChar).Value = "";
ora_cmd.Parameters.Add("VBatchType", OracleType.VarChar).Value = "NonTCS";
con.Open();
ora_cmd.ExecuteNonQuery();
con.Close();
//==========================================End Of TCS Batch Run=========================================
//Feedback update only for system uploaded not the manual excle uploads
if (vBatchType == "SYSTEM")
{
using (con)
{
con.Open();
OracleCommand command = con.CreateCommand();
OracleTransaction transaction;
transaction = con.BeginTransaction(System.Data.IsolationLevel.Serializable);
command.Transaction = transaction;
//----------------Feed back - Detail Update---------------
OracleCommand cmdBulk = new OracleCommand("sp_fas_ibt_rv_feedback_nontcs", con);
cmdBulk.CommandType = CommandType.StoredProcedure;
cmdBulk.Parameters.Add("StatusRet", OracleType.VarChar, 100).Direction = ParameterDirection.Output;
//con.Open();
cmdBulk.Transaction = transaction;
cmdBulk.ExecuteNonQuery();
string Status = cmdBulk.Parameters["StatusRet"].Value.ToString();
//con.Close();
if (Status == "")
{
transaction.Commit();
con.Close();
//Email Send only if the batch completed
if (vCompleteBatch == "YES")
{
CommonClass.ClsEmail clsEmail = new CommonClass.ClsEmail();
clsEmail.SendEmails("NonTCS");
CommonClass.CommonFunctions clsCommon = new CommonClass.CommonFunctions();
clsCommon.Logger(System.Reflection.MethodBase.GetCurrentMethod().Name, "Batch Process Completed & Sent Emails------------------");
}
return;
}
Status = Status.Remove(0, 1);
Status = Status.Replace(",", "','");
Status = "'" + Status + "'";
OracleCommand cmdGetBulkDTL = con.CreateCommand();
cmdGetBulkDTL.CommandText = " select SUBSTR(bdtl.dtl_id,0,INSTR(bdtl.dtl_id,'.')-1),dtl.serial_no, bdtl.receipt_status,dtl.id from fas_ibt_bulk_receipt_dtl bdtl " +
" inner join fas_ibt_uploaded_dtl dtl on SUBSTR(bdtl.dtl_id,0,INSTR(bdtl.dtl_id,'.')-1) = dtl.id and bdtl.effective_end_date is null and " +
" dtl.serial_no in (" + Status + ") ";
OracleDataAdapter oda = new OracleDataAdapter(cmdGetBulkDTL);
DataTable dtTemp = new DataTable();
cmdGetBulkDTL.Transaction = transaction;
oda.Fill(dtTemp);
//--------------------------------------------------------
string[] split = Status.Split(',');
split = split.Distinct().ToArray();
foreach (string item in split)
{
Console.WriteLine(item);
DataRow[] DrAll = dtTemp.Select("serial_no = " + item + "");
DataRow[] DrSuccess = dtTemp.Select("serial_no = " + item + " and (receipt_status = 5 or receipt_status = 9)");
if (DrAll.Length == DrSuccess.Length)
{
//Success
OracleCommand oraSuccess = new OracleCommand("SP_FAS_IBT_UPLD_DTL_INSERT", con);
oraSuccess.CommandType = CommandType.StoredProcedure;
oraSuccess.Parameters.Add("vreceipt_status", OracleType.Int16).Value = 5;
oraSuccess.Parameters.Add("vmatching_status", OracleType.Int16).Value = 3;
oraSuccess.Parameters.Add("vBULK_RECEIPT_IND", OracleType.Int16).Value = 1;
oraSuccess.Parameters.Add("vCREATEDBY", OracleType.VarChar).Value = "TCS";
oraSuccess.Parameters.Add("vSerialNo", OracleType.VarChar).Value = item.ToString().Replace("'", "");
//con.Open();
oraSuccess.Transaction = transaction;
oraSuccess.ExecuteNonQuery();
//con.Close();
continue;
}
else
{
//Fail
OracleCommand oraFail = new OracleCommand("SP_FAS_IBT_UPLD_DTL_INSERT", con);
oraFail.CommandType = CommandType.StoredProcedure;
oraFail.Parameters.Add("vreceipt_status", OracleType.Int16).Value = 7;
oraFail.Parameters.Add("vmatching_status", OracleType.Int16).Value = 1;
oraFail.Parameters.Add("vBULK_RECEIPT_IND", OracleType.Int16).Value = 1;
oraFail.Parameters.Add("vCREATEDBY", OracleType.VarChar).Value = "TCS";
oraFail.Parameters.Add("vSerialNo", OracleType.VarChar).Value = item.ToString().Replace("'", "");
//con.Open();
oraFail.Transaction = transaction;
oraFail.ExecuteNonQuery();
//con.Close();
continue;
}
}
transaction.Commit();
con.Close();
}
}
//Email Send only if the batch completed
if (vCompleteBatch == "YES")
{
CommonClass.ClsEmail clsEmail = new CommonClass.ClsEmail();
clsEmail.SendEmails("NonTCS");
CommonClass.CommonFunctions clsCommon = new CommonClass.CommonFunctions();
clsCommon.Logger(System.Reflection.MethodBase.GetCurrentMethod().Name, "Batch Process Completed & Sent Emails------------------");
}
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet AddSalesTypeToGroup(string salesTypeGroupCode, Array salesTypecodes, string userCode, out Int32 iErrorId)
{
ds = new DataSet();
try
{
OpenConnection(out iErrorId, out sErrorMsg);
ErrorId = new OracleParameter();
orlDA = new OracleDataAdapter();
OracleParameter inSalesTypeGroupCode = new OracleParameter();
OracleParameter inSalesTypeCodes = new OracleParameter();
OracleParameter inUserCode = new OracleParameter();
OracleParameter curGroupInData = new OracleParameter();
OracleParameter curGroupOutdata = new OracleParameter();
orlCmd = new OracleCommand("pkg_maint_sales_type_group.p_add_salestype_to_group", orlConn);
orlCmd.CommandType = System.Data.CommandType.StoredProcedure;
inSalesTypeGroupCode.OracleDbType = OracleDbType.Varchar2;
inSalesTypeGroupCode.Direction = ParameterDirection.Input;
inSalesTypeGroupCode.Value = salesTypeGroupCode;
orlCmd.Parameters.Add(inSalesTypeGroupCode);
inSalesTypeCodes.OracleDbType = OracleDbType.Varchar2;
inSalesTypeCodes.Direction = ParameterDirection.Input;
inSalesTypeCodes.CollectionType = OracleCollectionType.PLSQLAssociativeArray;
if (salesTypecodes.Length == 0)
{
inSalesTypeCodes.Size = 0;
inSalesTypeCodes.Value = new OracleDecimal[1] {
OracleDecimal.Null
};
}
else
{
inSalesTypeCodes.Size = salesTypecodes.Length;
inSalesTypeCodes.Value = salesTypecodes;
}
orlCmd.Parameters.Add(inSalesTypeCodes);
inUserCode.OracleDbType = OracleDbType.Varchar2;
inUserCode.Direction = ParameterDirection.Input;
inUserCode.Value = userCode;
orlCmd.Parameters.Add(inUserCode);
curGroupInData.OracleDbType = OracleDbType.RefCursor;
curGroupInData.Direction = System.Data.ParameterDirection.Output;
orlCmd.Parameters.Add(curGroupInData);
curGroupOutdata.OracleDbType = OracleDbType.RefCursor;
curGroupOutdata.Direction = System.Data.ParameterDirection.Output;
orlCmd.Parameters.Add(curGroupOutdata);
ErrorId.OracleDbType = OracleDbType.Int32;
ErrorId.Direction = ParameterDirection.Output;
ErrorId.ParameterName = "ErrorId";
orlCmd.Parameters.Add(ErrorId);
orlDA = new OracleDataAdapter(orlCmd);
orlDA.Fill(ds);
iErrorId = Convert.ToInt32(orlCmd.Parameters["ErrorId"].Value.ToString());
}
catch (Exception ex)
{
iErrorId = 2;
}
finally
{
CloseConnection();
}
return(ds);
}
protected void binddata()
{
string from = txtFrom.Text;
string to = txtTo.Text;
DateTime fromDt;
DateTime toDt;
string strCon = ConfigurationSettings.AppSettings["conString"].ToString().Trim();
OracleConnection con = new OracleConnection(strCon);
string str = "";
if (!String.IsNullOrEmpty(from) && !String.IsNullOrEmpty(to))
{
fromDt = new DateTime();
toDt = new DateTime();
fromDt = DateTime.ParseExact(from, "dd-MMM-yyyy", null);
toDt = DateTime.ParseExact(to, "dd-MMM-yyyy", null);
if (toDt.CompareTo(fromDt) < 0)
{
lblSearchMsg.Text = "To date must be later than From date";
lblSearchMsg.ForeColor = System.Drawing.Color.Red;
return;
}
else if (Convert.ToDateTime(txtFrom.Text.ToString()) > DateTime.Now.Date)
{
lblSearchMsg.Text = "You can not select date greater than current date!";
return;
}
else if (Convert.ToDateTime(txtTo.Text.ToString()) > DateTime.Now.Date)
{
lblSearchMsg.Text = "You can not select date greater than current date!";
return;
}
else
{
lblSearchMsg.Text = "";
}
}
Hashtable htTopupParams = getTopupParamsData();
string username, catid, operator_id;
if (Session["username"] != null || Session["operator_id"] != null)
{
username = Session["username"].ToString();
catid = Convert.ToString(Session["category"]);
operator_id = Convert.ToString(Session["operator_id"]);
}
else
{
Session.Abandon();
Response.Redirect("~/Login.aspx");
return;
}
str = " select a.uploadid,a.filename,a.insdt,a.Total,'in-progress' status from View_lcopre_bulk_file_process a " +
" where trunc(a.insdt) >='" + from + "' " +
" and trunc(a.insdt) <='" + to + "' and a.lcocode= '" + ddlLco.SelectedValue.ToString().Trim() + "' ";
OracleCommand cmd = new OracleCommand(str, con);
OracleDataAdapter DaObj = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
DaObj.Fill(dt);
if (dt.Rows.Count == 0)
{
grdBulkProc.Visible = false;
lblSearchMsg.Text = "No data found";
}
else
{
grdBulkProc.Visible = true;
lblSearchMsg.Text = "";
ViewState["searched_trans"] = dt;
grdBulkProc.DataSource = dt;
grdBulkProc.DataBind();
ScriptManager.RegisterStartupScript(Page, this.GetType(), "Key", "<script>MakeStaticHeader('" + grdBulkProc.ClientID + "', 400, 1200 , 37 ,false); </script>", false);
DivRoot.Style.Add("display", "block");
}
}
public DataTable GetInsigRecord2(string CITIZEN_ID, string DDATE, string POSITION_WORK_NAME, string POSITION_NAME, string GRADEINSIGNIA_NAME, string GAZETTE_LAM, string GAZETTE_TON, string GAZETTE_NA, string GAZETTE_DATE, string INVOICE, string DECORATION, string NOTES)
{
DataTable dt = new DataTable();
OracleConnection conn = ConnectionDB.GetOracleConnection();
string query = "SELECT * FROM TB_RECORDNOTE1 ";
if (!string.IsNullOrEmpty(CITIZEN_ID) || !string.IsNullOrEmpty(DDATE) || !string.IsNullOrEmpty(POSITION_WORK_NAME) || !string.IsNullOrEmpty(POSITION_NAME) || !string.IsNullOrEmpty(GRADEINSIGNIA_NAME) || !string.IsNullOrEmpty(GAZETTE_LAM) || !string.IsNullOrEmpty(GAZETTE_TON) || !string.IsNullOrEmpty(GAZETTE_NA) || !string.IsNullOrEmpty(GAZETTE_DATE) || !string.IsNullOrEmpty(INVOICE) || !string.IsNullOrEmpty(DECORATION) || !string.IsNullOrEmpty(NOTES))
{
query += " where 1=1 ";
if (!string.IsNullOrEmpty(CITIZEN_ID))
{
query += " and CITIZEN_ID like :CITIZEN_ID ";
}
if (!string.IsNullOrEmpty(DDATE))
{
query += " and DDATE like :DDATE ";
}
if (!string.IsNullOrEmpty(POSITION_WORK_NAME))
{
query += " and POSITION_WORK_NAME like :POSITION_WORK_NAME ";
}
if (!string.IsNullOrEmpty(POSITION_NAME))
{
query += " and POSITION_NAME like :POSITION_NAME ";
}
if (!string.IsNullOrEmpty(GRADEINSIGNIA_NAME))
{
query += " and GRADEINSIGNIA_NAME like :GRADEINSIGNIA_NAME ";
}
if (!string.IsNullOrEmpty(GAZETTE_LAM))
{
query += " and GAZETTE_LAM like :GAZETTE_LAM ";
}
if (!string.IsNullOrEmpty(GAZETTE_TON))
{
query += " and GAZETTE_TON like :GAZETTE_TON ";
}
if (!string.IsNullOrEmpty(GAZETTE_NA))
{
query += " and GAZETTE_NA like :GAZETTE_NA ";
}
if (!string.IsNullOrEmpty(GAZETTE_DATE))
{
query += " and GAZETTE_DATE like :GAZETTE_DATE ";
}
if (!string.IsNullOrEmpty(INVOICE))
{
query += " and INVOICE like :INVOICE ";
}
if (!string.IsNullOrEmpty(DECORATION))
{
query += " and DECORATION like :DECORATION ";
}
if (!string.IsNullOrEmpty(NOTES))
{
query += " and NOTES like :NOTES ";
}
}
OracleCommand command = new OracleCommand(query, conn);
// Create the command
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
if (!string.IsNullOrEmpty(CITIZEN_ID))
{
command.Parameters.Add(new OracleParameter("CITIZEN_ID", "%" + CITIZEN_ID + "%"));
}
if (!string.IsNullOrEmpty(DDATE))
{
command.Parameters.Add(new OracleParameter("DDATE", "%" + DDATE + "%"));
}
if (!string.IsNullOrEmpty(POSITION_WORK_NAME))
{
command.Parameters.Add(new OracleParameter("POSITION_WORK_NAME", "%" + POSITION_WORK_NAME + "%"));
}
if (!string.IsNullOrEmpty(POSITION_NAME))
{
command.Parameters.Add(new OracleParameter("POSITION_NAME", "%" + POSITION_NAME + "%"));
}
if (!string.IsNullOrEmpty(GRADEINSIGNIA_NAME))
{
command.Parameters.Add(new OracleParameter("GRADEINSIGNIA_NAME", "%" + GRADEINSIGNIA_NAME + "%"));
}
if (!string.IsNullOrEmpty(GAZETTE_LAM))
{
command.Parameters.Add(new OracleParameter("GAZETTE_LAM", "%" + GAZETTE_LAM + "%"));
}
if (!string.IsNullOrEmpty(GAZETTE_TON))
{
command.Parameters.Add(new OracleParameter("GAZETTE_TON", "%" + GAZETTE_TON + "%"));
}
if (!string.IsNullOrEmpty(GAZETTE_NA))
{
command.Parameters.Add(new OracleParameter("GAZETTE_NA", "%" + GAZETTE_NA + "%"));
}
if (!string.IsNullOrEmpty(GAZETTE_DATE))
{
command.Parameters.Add(new OracleParameter("GAZETTE_DATE", "%" + GAZETTE_DATE + "%"));
}
if (!string.IsNullOrEmpty(INVOICE))
{
command.Parameters.Add(new OracleParameter("INVOICE", "%" + INVOICE + "%"));
}
if (!string.IsNullOrEmpty(DECORATION))
{
command.Parameters.Add(new OracleParameter("DECORATION", "%" + DECORATION + "%"));
}
if (!string.IsNullOrEmpty(NOTES))
{
command.Parameters.Add(new OracleParameter("NOTES", "%" + NOTES + "%"));
}
OracleDataAdapter sd = new OracleDataAdapter(command);
sd.Fill(dt);
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Dispose();
conn.Close();
}
return(dt);
}
private void button3_Click(object sender, EventArgs e)
{
sex = "xyz";
ph1 = textBox10.Text;
ph2 = textBox1.Text;
nam = textBox5.Text;
aad = textBox8.Text;
age = numericUpDown2.Value.ToString();
email = textBox9.Text;
mnam = textBox6.Text;
lnam = textBox7.Text;
foreach (char c in ph1)
{
if (!Char.IsNumber(c))
{
ph1err = 1;
}
}
if (ph2 != "")
{
foreach (char c in ph2)
{
if (!Char.IsNumber(c))
{
ph2err = 1;
}
}
}
foreach (char c in aad)
{
if (!Char.IsNumber(c))
{
aaderr = 1;
}
}
foreach (char c in nam)
{
if (!Char.IsLetter(c))
{
namerr = 1;
}
}
foreach (char c in mnam)
{
if (!Char.IsLetter(c))
{
namerr = 1;
}
}
foreach (char c in lnam)
{
if (!Char.IsLetter(c))
{
namerr = 1;
}
}
if (radioButton3.Checked == true)
{
sex = "M";
}
else if (radioButton4.Checked == true)
{
sex = "F";
}
if (radioButton3.Checked == false && radioButton4.Checked == false)
{
MessageBox.Show("Select Gender!");
}
else if (textBox10.Text.Length != 10 || (ph1err == 1))
{
MessageBox.Show("Invalid Phone Number");
textBox10.Text = "";
ph1err = 0;
}
else if (textBox5.Text.Length == 0 || namerr == 1)
{
MessageBox.Show("Enter Proper Name!");
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
namerr = 0;
}
else if (!((textBox1.Text.Length == 10) || (textBox1.Text.Length == 0)) || (ph2err == 1))
{
MessageBox.Show("Invalid Phone Number");
textBox1.Text = "";
ph2err = 0;
}
else if (!textBox9.Text.Contains("@") || !textBox9.Text.Contains(".com") || !(textBox9.Text.Length >= 6))
{
MessageBox.Show("Invalid Email");
textBox9.Text = "";
}
else if (textBox8.Text.Length != 12 || (aaderr == 1))
{
MessageBox.Show("Invalid Aadhar");
textBox8.Text = "";
aaderr = 0;
}
else
{
String oradb2 = "Data Source=xe;Persist Security Info=True;User ID=SYSTEM;Password=pogkaku";
OracleConnection conn1 = new OracleConnection(oradb2);
conn1.Open();
OracleCommand comm1 = new OracleCommand();
comm1.CommandText = "select * from passenger where aadhar_id = '" + aad + "'";
comm1.CommandType = CommandType.Text;
DataSet ds1 = new DataSet();
OracleDataAdapter da1 = new OracleDataAdapter(comm1.CommandText, conn1);
da1.Fill(ds1, "Tbl_passenger1");
DataTable dt1 = ds1.Tables["Tbl_passenger1"];
int t1 = dt1.Rows.Count;
OracleConnection conn2 = new OracleConnection(oradb2);
conn2.Open();
OracleCommand comm2 = new OracleCommand();
comm2.CommandText = "select * from passenger_phone where phone = '" + ph1 + "'";
comm2.CommandType = CommandType.Text;
DataSet ds2 = new DataSet();
OracleDataAdapter da2 = new OracleDataAdapter(comm2.CommandText, conn2);
da2.Fill(ds2, "Tbl_passenger");
DataTable dt2 = ds2.Tables["Tbl_passenger"];
int t2 = dt2.Rows.Count;
OracleConnection conn5 = new OracleConnection(oradb2);
conn5.Open();
OracleCommand comm5 = new OracleCommand();
comm5.CommandText = "select * from passenger_phone where phone = '" + ph2 + "'";
comm5.CommandType = CommandType.Text;
DataSet ds5 = new DataSet();
OracleDataAdapter da5 = new OracleDataAdapter(comm5.CommandText, conn5);
da5.Fill(ds5, "Tbl_passenger2");
DataTable dt5 = ds5.Tables["Tbl_passenger2"];
int t3 = dt5.Rows.Count;
if (t2 == 0 && t1 == 0 && t3 == 0 && ph1 != ph2)
{
try
{
String oradb = "Data Source=xe;Persist Security Info=True;User ID=SYSTEM;Password=pogkaku";
OracleConnection conn = new OracleConnection(oradb);
conn.Open();
OracleCommand comm = new OracleCommand();
comm.Connection = conn;
comm.CommandText = "insert into passenger values('" + aad + "','" + nam + "','" + mnam + "','" + lnam + "','" + age + "','" + sex + "','" + email + "')";
comm.CommandType = CommandType.Text;
comm.ExecuteNonQuery();
conn.Close();
}
catch (OracleException ex)
{
MessageBox.Show("SQL Query Failed : " + ex.ToString());
MessageBox.Show(age);
}
try
{
String oradb1 = "Data Source=xe;Persist Security Info=True;User ID=SYSTEM;Password=pogkaku";
OracleConnection conn4 = new OracleConnection(oradb1);
conn4.Open();
OracleCommand comm4 = new OracleCommand();
comm4.Connection = conn4;
comm4.CommandText = "insert into passenger_phone values('" + textBox8.Text + "','" + textBox10.Text + "')";
comm4.CommandType = CommandType.Text;
comm4.ExecuteNonQuery();
conn4.Close();
}
catch (OracleException ex1)
{
MessageBox.Show("" + ex1.ToString());
}
if (textBox1.Text.Length != 0)
{
try
{
String oradb3 = "Data Source=xe;Persist Security Info=True;User ID=SYSTEM;Password=pogkaku";
OracleConnection conn3 = new OracleConnection(oradb3);
conn3.Open();
OracleCommand comm3 = new OracleCommand();
comm3.Connection = conn3;
comm3.CommandText = "insert into passenger_phone values('" + textBox8.Text + "','" + textBox1.Text + "')";
comm3.CommandType = CommandType.Text;
comm3.ExecuteNonQuery();
conn3.Close();
//MessageBox.Show("Account Created");
}
catch (OracleException ex1)
{
MessageBox.Show("" + ex1.ToString());
}
}
MessageBox.Show("Account Created");
Menu m = new Menu(aad, nam, mnam, lnam, age, sex, email, ph1, ph2);
m.Show();
this.Hide();
}
else if (t1 != 0)
{
MessageBox.Show("Aadhar ID already registered!");
}
else if (t2 != 0)
{
MessageBox.Show("Phone Number already registered!");
}
else if (t3 != 0)
{
MessageBox.Show("Phone Number already registered!");
}
else if (ph1 == ph2)
{
MessageBox.Show("Enter Different Numbers");
textBox1.Text = "";
}
conn2.Close();
}
}
/* -------------------BOTON PARA CAMBIAR PROCESO Y CONTRATISTA A ORDEN ----------- */
protected void btnCambio_Proceso_Click(object sender, EventArgs e)
{
gridOrden.Columns[17].Visible = true;
gridOrden.Columns[0].Visible = true;
int pro = int.Parse(ddProcesoCambio.SelectedValue);
if (pro == 0)
{
lbResultado.ForeColor = System.Drawing.Color.Red;
lbResultado.Text = "Ingrese proceso al que desea cambiar las ordenes";
IMG2.Visible = false;
IMG5.Visible = true;
IMG6.Visible = false;
gridOrden.Columns[17].Visible = false;
gridOrden.Columns[0].Visible = false;
}
else
{
String rutaXml = Server.MapPath("./sessiones/") + "usuario_" + Session.SessionID + ".xml";
IMG2.Visible = false;
IMG5.Visible = false;
IMG6.Visible = false;
lbResultado.Text = "";
IMG2.Visible = false;
IMG5.Visible = false;
IMG6.Visible = false;
lbResultado.Text = "";
if (valida_check() == true)
{
IMG2.Visible = false;
IMG5.Visible = false;
IMG6.Visible = false;
lbResultado.Text = "";
int i;
GridViewRow gvRow;
CheckBox check_permiso = new CheckBox();
OracleConnection objConexion = new OracleConnection(conexion_cliente_oracle);
OracleDataAdapter ComandoDA;
for (i = 0; i < gridOrden.Rows.Count; i++)
{
gvRow = gridOrden.Rows[i];
check_permiso = (CheckBox)(gvRow.FindControl("check_cambio"));
if (check_permiso.Checked == true && gridOrden.Rows[i].Cells[17].Text != "4")
{
objConexion.Open();
// cambia proceso de una orden
ComandoDA = new OracleDataAdapter("PK_CAMBIO_PROCESO.CAMBIAR_PROCESO", objConexion);
ComandoDA.SelectCommand.CommandType = CommandType.StoredProcedure;
PRO.agrega_parametro_sp(ComandoDA, "i_orden", OracleType.Int32, ParameterDirection.Input, gridOrden.Rows[i].Cells[0].Text);
PRO.agrega_parametro_sp(ComandoDA, "i_proceso", OracleType.Int32, ParameterDirection.Input, ddProcesoCambio.SelectedValue);
try
{
ComandoDA.SelectCommand.ExecuteNonQuery();
objConexion.Close();
lbResultado.ForeColor = System.Drawing.Color.Blue;
lbResultado.Text = "Se cambio de proceso exitosamente.";
IMG2.Visible = true;
IMG5.Visible = false;
IMG6.Visible = false;
gridOrden.Columns[10].Visible = false;
gridOrden.Columns[0].Visible = false;
}
catch (Exception ex)
{
lbResultado.ForeColor = System.Drawing.Color.Red;
lbResultado.Text = "Error al cambiar de proceso la orden " + gridOrden.Rows[i].Cells[0].Text + ". Descripción: " + ex.Message.ToString();
IMG2.Visible = false;
//IMG4.Visible = false;
IMG5.Visible = true;
IMG6.Visible = false;
break;
}
}
}
gridOrden.Columns[17].Visible = false;
gridOrden.Columns[0].Visible = false;
objConexion.Dispose();
carga_grilla(int.Parse(ddGrupo.SelectedValue), int.Parse(ddLocalidad.SelectedValue), int.Parse(ddTipoIn.SelectedValue), int.Parse(ddSincro.SelectedValue), ddRuta.SelectedValue.ToString(), int.Parse(ddTipoPro.SelectedValue.ToString()), txtDesde.Text, txtHasta.Text, int.Parse(ddZona.SelectedValue), ddContratista.SelectedValue);
}
else
{
lbResultado.ForeColor = System.Drawing.Color.Red;
lbResultado.Text = "Seleccione al menos una orden para cambiar de proceso.";
IMG2.Visible = false;
IMG5.Visible = false;
IMG6.Visible = true;
gridOrden.Columns[17].Visible = false;
gridOrden.Columns[0].Visible = false;
} //Valida_seleccion_Checkbox()
}
}
public DataSet InsertSalesTypeGroup(string salesTypeGroupCode, string salesTypeGroupName, string userCode, out Int32 iErrorId)
{
ds = new DataSet();
try
{
OpenConnection(out iErrorId, out sErrorMsg);
ErrorId = new OracleParameter();
orlDA = new OracleDataAdapter();
OracleParameter inSaleTypeGroupCode = new OracleParameter();
OracleParameter inSaleTypeGroupName = new OracleParameter();
OracleParameter inUserCode = new OracleParameter();
OracleParameter curGroupInData = new OracleParameter();
OracleParameter curGroupOutdata = new OracleParameter();
OracleParameter curGroupList = new OracleParameter();
orlCmd = new OracleCommand("pkg_maint_sales_type_group.p_insert_salestype_group", orlConn);
orlCmd.CommandType = System.Data.CommandType.StoredProcedure;
inSaleTypeGroupCode.OracleDbType = OracleDbType.Varchar2;
inSaleTypeGroupCode.Direction = ParameterDirection.Input;
inSaleTypeGroupCode.Value = salesTypeGroupCode;
orlCmd.Parameters.Add(inSaleTypeGroupCode);
inSaleTypeGroupName.OracleDbType = OracleDbType.Varchar2;
inSaleTypeGroupName.Direction = ParameterDirection.Input;
inSaleTypeGroupName.Value = salesTypeGroupName;
orlCmd.Parameters.Add(inSaleTypeGroupName);
inUserCode.OracleDbType = OracleDbType.Varchar2;
inUserCode.Direction = ParameterDirection.Input;
inUserCode.Value = userCode;
orlCmd.Parameters.Add(inUserCode);
curGroupInData.OracleDbType = OracleDbType.RefCursor;
curGroupInData.Direction = System.Data.ParameterDirection.Output;
orlCmd.Parameters.Add(curGroupInData);
curGroupOutdata.OracleDbType = OracleDbType.RefCursor;
curGroupOutdata.Direction = System.Data.ParameterDirection.Output;
orlCmd.Parameters.Add(curGroupOutdata);
curGroupList.OracleDbType = OracleDbType.RefCursor;
curGroupList.Direction = System.Data.ParameterDirection.Output;
orlCmd.Parameters.Add(curGroupList);
ErrorId.OracleDbType = OracleDbType.Int32;
ErrorId.Direction = ParameterDirection.Output;
ErrorId.ParameterName = "ErrorId";
orlCmd.Parameters.Add(ErrorId);
orlDA = new OracleDataAdapter(orlCmd);
orlDA.Fill(ds);
iErrorId = Convert.ToInt32(orlCmd.Parameters["ErrorId"].Value.ToString());
}
catch (Exception ex)
{
iErrorId = 2;
}
finally
{
CloseConnection();
}
return(ds);
}
public static DataTable ExecuteDataTable(string connectionString, CommandType cmdType, string cmdText, params OracleParameter[] commandParameters)
{
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand cmd = new OracleCommand();
try
{
PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters);
OracleDataAdapter MyAdapter = new OracleDataAdapter();
MyAdapter.SelectCommand = cmd;
DataSet ds = new DataSet();
MyAdapter.Fill(ds);
cmd.Parameters.Clear();
DataTable table = ds.Tables[0];
ds.Dispose();
connection.Close();
return table;
}
catch
{
connection.Close();
throw;
}
}
}
