protected void btnConfirm_OTP_Click(object sender, EventArgs e)
{
try
{
String match_OTP = enter_OTP.Value;
using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST))
{
connection.Open();
string queryString = "SELECT * FROM VP_OTP WHERE EMAIL = :email AND OTP = :match_OTP AND VALIDITY=:YES";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection);
command.Parameters.AddWithValue("email", Session["Otp_email"]);
command.Parameters.AddWithValue("match_OTP", match_OTP);
command.Parameters.AddWithValue("YES", "YES");
using (System.Data.OracleClient.OracleDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
HttpContext.Current.Response.Redirect("ResetPassword.aspx", false);
}
else
{
lblError.Text = "Check Your OTP!";
}
}
}
}
catch (Exception ex)
{
}
}
protected override ExeResEdm SqlCMD_DT(string cmdText, CommandType commandType, Func <DbDataAdapter, int> fun, params DbParameter[] parameters)
{
ExeResEdm dBResEdm = new ExeResEdm();
try
{
parameters = ParameterPrepare(parameters);
using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr))
{
conn.Open();
System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = cmdText;
cmd.CommandType = commandType;
if (parameters != null && parameters.Length > 0)
{
cmd.Parameters.AddRange((parameters));
}
var da = new System.Data.OracleClient.OracleDataAdapter(cmd);
var res = fun(da);
dBResEdm.ExeNum = res;
}
}
catch (Exception ex)
{
dBResEdm.Module = "SqlCMD_DT 方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
return(dBResEdm);
}
protected override ExeResEdm SqlCMD(string sql, Func <DbCommand, object> fun, params DbParameter[] pms)
{
ExeResEdm dBResEdm = new ExeResEdm();
try
{
pms = ParameterPrepare(pms);
using (System.Data.OracleClient.OracleConnection con = new System.Data.OracleClient.OracleConnection(connstr))
{
using (System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(sql, con))
{
con.Open();
if (pms != null && pms.Length > 0)
{
cmd.Parameters.AddRange((pms));
}
var res = fun(cmd);
dBResEdm.ExeModel = res;
return(dBResEdm);
}
}
}
catch (Exception ex)
{
dBResEdm.Module = "SqlCMD方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
}
/// <summary>
/// 返回指定Sql语句的DbDataReader
/// 方法关闭数据库连接
/// </summary>
/// <param name="sqlstr">传入的Sql语句</param>
/// <returns>DBDataReader对象</returns>
public virtual DbDataReader GetDataReader(string sqlstr)
{
//程序不能返回抽象类，故用分数据访问分工来生成DataReader对象
if (databaseType == "Oracle")
{
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand();
System.Data.OracleClient.OracleDataReader oraDr = cmd.ExecuteReader();
return(oraDr);
}
else if (databaseType == "SqlServer")
{
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand();
System.Data.SqlClient.SqlDataReader sqlDr = cmd.ExecuteReader();
return(sqlDr);
}
else if (databaseType == "Sybase")
{
System.Data.OleDb.OleDbCommand cmd = new System.Data.OleDb.OleDbCommand();
System.Data.OleDb.OleDbDataReader oleDr = cmd.ExecuteReader();
return(oleDr);
}
else
{
System.Data.Odbc.OdbcCommand cmd = new System.Data.Odbc.OdbcCommand();
System.Data.Odbc.OdbcDataReader odbcDr = cmd.ExecuteReader();
return(odbcDr);
}
}
protected override ExeResEdm UpdateDtToDB(DataTable dtInfos, string strComFields = "*")
{
ExeResEdm dBResEdm = new ExeResEdm();
string strTableName = dtInfos.TableName;
try
{
using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr))
{
conn.Open();
System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = GetColumnsNameSql(strTableName, strComFields);
System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(cmd);
adapter.UpdateCommand = new System.Data.OracleClient.OracleCommandBuilder(adapter).GetUpdateCommand();
adapter.Update(dtInfos.GetChanges());
dtInfos.AcceptChanges();
}
}
catch (Exception ex)
{
dBResEdm.Module = "UpdateDtToDB方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
return(dBResEdm);
}
protected override ExeResEdm ExecuteNonQueryFromSqlContianer(List <SqlContianer> ltSqls)
{
ExeResEdm dBResEdm = new ExeResEdm();
string curSQL = "";
try
{
using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr))
{
conn.Open();
System.Data.OracleClient.OracleTransaction oraOprate = conn.BeginTransaction();
try
{
System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
cmd.Transaction = oraOprate;
foreach (SqlContianer objOraSqlCon in ltSqls)
{
cmd.CommandText = objOraSqlCon.strSqlTxt;
curSQL = objOraSqlCon.strSqlTxt;
cmd.Parameters.Clear();
cmd.Parameters.AddRange(objOraSqlCon.ltOraParams.ToArray());
int intRes = cmd.ExecuteNonQuery();
dBResEdm.ExeNum += intRes;
if (objOraSqlCon.intExpectNums >= 0)
{
if (intRes != objOraSqlCon.intExpectNums)
{
throw new Exception("Update records not match the expect nums");
}
}
else if (objOraSqlCon.intExpectNums != Int16.MinValue)
{
if (intRes != 0 && intRes != objOraSqlCon.intExpectNums * -1)
{
throw new Exception("Update records not match the expect nums");
}
}
}
oraOprate.Commit();
}
catch (Exception ex)
{
oraOprate.Rollback();
dBResEdm.Module = "ExecuteNonQueryFromSqlContianer方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
}
}
catch (Exception ex)
{
dBResEdm.Module = "ExecuteNonQueryFromSqlContianer方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
return(dBResEdm);
}
private string GetDDLForTable(string tableName, string owner)
{
using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(strCon1))
{
System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
cmd.CommandText = string.Format("select SYS.DBMS_METADATA.GET_DDL('TABLE','{0}','{1}') from dual", tableName, owner);
conn.Open();
object result = cmd.ExecuteScalar();
return(result.ToString());
}
}
public void InsertRecord(string SQLStatement)
{
if (SQLStatement.Length > 0)
{
if (connOracle.State.ToString().Equals("Open"))
{
sqlCommandOracle =
new System.Data.OracleClient.OracleCommand(SQLStatement, connOracle);
sqlCommandOracle.ExecuteScalar();
}
}
}
/// <summary>
/// 执行sql
/// </summary>
/// <param name="strSql"></param>
/// <param name="strDataSet"></param>
/// <param name="strXSLFileName"></param>
/// <param name="SettingXml"></param>
/// <returns></returns>
public int ExecQuery(string strSql, ref string strDataSet, string strXSLFileName, string SettingXml)
{
System.Data.OracleClient.OracleConnection con = new System.Data.OracleClient.OracleConnection(strConn);
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand();
command.Connection = con;
command.CommandType = System.Data.CommandType.Text;
command.Parameters.Clear();
command.CommandText = strSql + "";
try
{
System.Data.OracleClient.OracleDataReader TempReader1;
TempReader1 = command.ExecuteReader();
XmlDocument doc = new XmlDocument();
XmlNode root;
XmlElement node, row;
doc.AppendChild(doc.CreateXmlDeclaration("1.0", "GB2312", ""));
if (strXSLFileName != null && strXSLFileName != "")
{
string PI = "type='text/xsl' href='" + strXSLFileName + "'";
System.Xml.XmlProcessingInstruction xmlProcessingInstruction = doc.CreateProcessingInstruction("xml-stylesheet", PI);
doc.AppendChild(xmlProcessingInstruction);
}
string Header = doc.OuterXml + "\n<DataSet>\n" + SettingXml;
doc = new XmlDocument();
root = doc.CreateElement("Table");
doc.AppendChild(root);
while (TempReader1.Read())
{
row = doc.CreateElement("Row");
for (int i = 0; i < TempReader1.FieldCount; i++)
{
node = doc.CreateElement("Column");
node.SetAttribute("Name", TempReader1.GetName(i).ToString());
node.InnerText = TempReader1[i].ToString() + "";
row.AppendChild(node);
}
root.AppendChild(row);
}
strDataSet = Header + "\n" + doc.OuterXml + "\n</DataSet>";
TempReader1.Close();
}
catch (Exception ex)
{
this.Err = "执行语句产生错误!" + ex.Message;
this.ErrorException = ex.InnerException + "+ " + ex.Source;
this.ErrCode = strSql;
this.WriteErr();
return(-1);
}
WriteDebug("执行查询sql语句！" + strSql);
return(0);
}
//Value which you want to pass
public void btnGet_OTP_Click(object sender, EventArgs e)
{
try
{
// to save the Email_id and OTP in database
String email = send_otp.Value;
Session["Otp_email"] = email;
string strNewOtp = GenerateOtp().ToString();
using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST))
{
connection.Open();
string queryString = "update VP_OTP SET VALIDITY =:NO WHERE EMAIL = :email AND VALIDITY= :YES ";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection);
command.Parameters.AddWithValue("email", email);
command.Parameters.AddWithValue("YES", "YES");
command.Parameters.AddWithValue("NO", "NO");
int rowsUpdated = command.ExecuteNonQuery();
string QueryString = "insert into VP_OTP (EMAIL,OTP, VALIDITY) values (:email,:OTP,:VALIDITY)";
System.Data.OracleClient.OracleCommand Command = new System.Data.OracleClient.OracleCommand(QueryString, connection);
Command.Parameters.AddWithValue("email", email);
Command.Parameters.AddWithValue("OTP", strNewOtp);
Command.Parameters.AddWithValue("VALIDITY", "YES");
int RowsUpdated = Command.ExecuteNonQuery();
HttpContext.Current.Response.Redirect("OTP.aspx", false);
}
// to send the random OTP in email
// MailMessage msg = new MailMessage();
// msg.From = new MailAddress("*****@*****.**");
// msg.To.Add(email);
// msg.Body = "Dear " + email + ", <br/><br/> Your OTP is " + strNewOtp + " for Vendor Registration for RCF. <br/> Kindly ignore this email if already submitted. <br/><br/>This is system generated mail.<br/>Please do not reply.<br/><br/>Regards,<br/>RCF Ltd.";
//Response.Write(msg.Body);
// msg.IsBodyHtml = true;
// msg.Subject = "OTP for Verification for Grievance Monitoring System";
/// SmtpClient smt = new SmtpClient("webmail.rcfltd.com");
// smt.Port = 25;
// smt.Credentials = new NetworkCredential("*****@*****.**", "asdfgh@123");
//smt.EnableSsl = true;
// smt.Send(msg);
//string script = "<script>alert('Mail Sent Successfully');self.close();</script>";
//this.ClientScript.RegisterClientScriptBlock(this.GetType(), "sendMail", script);
}
catch (Exception ex)
{
}
}
/// <summary>
/// There are no comments for COMP_BIOSUM_VOLS_BY_UPDATE in the schema.
/// </summary>
public virtual void COMP_BIOSUM_VOLS_BY_UPDATE()
{
m_intError = 0; m_strError = "";
bool bCloseConnection = false;
if (_OracleADO.ConnectionDisposed ||
_OracleADO.m_Connection == null ||
(_OracleADO.m_Connection != null &&
_OracleADO.m_Connection.State != ConnectionState.Open))
{
OracleConnect();
bCloseConnection = true;
}
if (_OracleADO.m_intError == 0)
{
try
{
//using (Oracle.DataAccess.Client.OracleCommand command = new Oracle.DataAccess.Client.OracleCommand())
using (System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand())
{
command.Connection = _OracleADO.m_Connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = FCSOracle.FCSSchema + ".COMPUTE_BIOSUM_VOLUMES_PKG.COMP_BIOSUM_VOLS_BY_UPDATE";
command.ExecuteNonQuery();
}
}
catch (Exception e)
{
m_intError = -1;
m_strError = e.Message;
if (DisplayErrors)
{
MessageBox.Show("!!Error!! \n" +
"Module - FCSEntities:COMP_BIOSUM_VOLS_BY_UPDATE \n" +
"Err Msg - " + e.Message.ToString().Trim(),
"BIOSUM", System.Windows.Forms.MessageBoxButtons.OK,
System.Windows.Forms.MessageBoxIcon.Exclamation);
}
}
finally
{
if (bCloseConnection)
{
//close connection and release resources
OracleADO.CloseAndDisposeConnection(_OracleADO.m_Connection, false);
}
}
}
}
//Connection to Oracle database
public System.Data.DataTable OracOLEds(string SqlString, string constring, int rowlimit)
{
DataTable dt = new DataTable();
if (rowlimit > 0)
{
try
{
using (System.Data.OracleClient.OracleConnection OracConnect = new System.Data.OracleClient.OracleConnection(constring))
{
OracConnect.Open();
System.Data.OracleClient.OracleCommand OraCmd = new System.Data.OracleClient.OracleCommand(SqlString, OracConnect);
System.Data.OracleClient.OracleDataReader Oraxreader = OraCmd.ExecuteReader();
DataSet ds = new DataSet();
ds.Load(Oraxreader, LoadOption.OverwriteChanges, "Result");
var ddt = ds.Tables[0].AsEnumerable().Take(rowlimit);
dt = ddt.CopyToDataTable <DataRow>();
Oraxreader.Close();
OracConnect.Close();
}
}
catch (Exception exOrac)
{
var ex1 = exOrac.Message;
}
}
else
{
try
{
using (System.Data.OracleClient.OracleConnection OracConnect = new System.Data.OracleClient.OracleConnection(constring))
{
OracConnect.Open();
System.Data.OracleClient.OracleCommand OraCmd = new System.Data.OracleClient.OracleCommand(SqlString, OracConnect);
System.Data.OracleClient.OracleDataReader Oraxreader = OraCmd.ExecuteReader();
DataSet ds = new DataSet();
ds.Load(Oraxreader, LoadOption.OverwriteChanges, "Result");
dt = ds.Tables[0];
Oraxreader.Close();
OracConnect.Close();
}
}
catch (Exception exOrac)
{
var ex1 = exOrac.Message;
}
}
return(dt);
}
protected void GrdViewDocs_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "Select")
{
GridDataItem dataitem = e.Item as GridDataItem;
//DataTable dtcon = CM_Main.SelectJob("CASE11", dataitem["REQUEST_ID"].Text, "", "", "", "", System.DateTime.Now);
//grdRequest.DataSource = dtcon;
//grdRequest.DataBind();
// int idx = dataitem["REQUEST_ID"].Text;
// Label lbl = dataitem["ID"].Text;
System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(ConfigurationManager.ConnectionStrings["CGConnectionString"].ToString());
System.Data.OracleClient.OracleCommand myCommand = new System.Data.OracleClient.OracleCommand("SELECT * FROM wf_cm_docs_jobwise_blob WHERE ID = '" + dataitem["ID"].Text + "'", conn);
conn.Open();
System.Data.OracleClient.OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default);
try
{
while (myReader.Read())
{
System.Data.OracleClient.OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("DOCUMENT"));
if (!myLob.IsNull)
{
string FN = myReader.GetString(myReader.GetOrdinal("DOCUMENT_NAME"));
//Use buffer to transfer data
byte[] b = new byte[myLob.Length];
//Read data from database
myLob.Read(b, 0, (int)myLob.Length);
Response.AddHeader("content-disposition", "attachment;filename=" + FN);
Response.ContentType = "application/octectstream";
Response.BinaryWrite(b);
Response.End();
}
}
}
finally
{
myReader.Close();
conn.Close();
}
}
}
private void DisplayDataForQuery()
{
dataGridView1.DataSource = null;
if (queryBuilder.MetadataProvider != null && queryBuilder.MetadataProvider.Connected)
{
if (queryBuilder.MetadataProvider is OracleMetadataProvider)
{
System.Data.OracleClient.OracleCommand command = (System.Data.OracleClient.OracleCommand)queryBuilder.MetadataProvider.Connection.CreateCommand();
command.CommandText = queryBuilder.SQL;
// handle the query parameters
if (queryBuilder.Parameters.Count > 0)
{
for (int i = 0; i < queryBuilder.Parameters.Count; i++)
{
if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName))
{
System.Data.OracleClient.OracleParameter parameter = new System.Data.OracleClient.OracleParameter();
parameter.ParameterName = queryBuilder.Parameters[i].FullName;
parameter.DbType = queryBuilder.Parameters[i].DataType;
command.Parameters.Add(parameter);
}
}
using (QueryParametersForm qpf = new QueryParametersForm(command))
{
qpf.ShowDialog();
}
}
System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(command);
DataSet dataset = new DataSet();
try
{
adapter.Fill(dataset, "QueryResult");
dataGridView1.DataSource = dataset.Tables["QueryResult"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "SQL query error");
}
} //end oracle (ms)
} //end check if connected
} //end method
protected void btnSignUp_Click(object sender, EventArgs e)
{
try
{
String username = user_name.Value;
String email = user_email.Value;
String password = user_password.Value;
using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST))
{
connection.Open();
string queryString = "SELECT * FROM VP_LOGIN WHERE EMAIL_ID = :useremail";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection);
command.Parameters.AddWithValue("useremail", email);
using (System.Data.OracleClient.OracleDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
lblError_email.Text = "Email already exist!";
}
else
{
string QueryString = "insert into VP_LOGIN (NAME,EMAIL_ID,PASSWORD) values (:username,:email,:password)";
System.Data.OracleClient.OracleCommand Command = new System.Data.OracleClient.OracleCommand(QueryString, connection);
Command.Parameters.AddWithValue("username", username);
Command.Parameters.AddWithValue("email", email);
Command.Parameters.AddWithValue("password", password);
int rowsUpdated = Command.ExecuteNonQuery();
if (rowsUpdated == 0)
{
Response.Write("Record not inserted");
}
else
{
HttpContext.Current.Response.Redirect("Login.aspx", false);
}
}
}
}
}
catch (Exception ex)
{
lblError.Text = "Something Went Wrong!";
}
}
public void InsertCLOB(string SQLStatement, string str)
{
if (SQLStatement.Length > 0)
{
if (connOracle.State.ToString().Equals("Open"))
{
byte[] newvalue = System.Text.Encoding.Unicode.GetBytes(str);
sqlCommandOracle =
new System.Data.OracleClient.OracleCommand(SQLStatement, connOracle);
rstOracle = sqlCommandOracle.ExecuteReader();
rstOracle.Read();
txn = connOracle.BeginTransaction();
clob = rstOracle.GetOracleLob(0);
clob.Write(newvalue, 0, newvalue.Length);
txn.Commit();
}
}
}
private TB_Dzsrcdel GetDzsrcdel(string sono, int entryid, System.Data.OracleClient.OracleCommand cmd)
{
TB_Dzsrcdel model = new TB_Dzsrcdel()
{
Fjde_sono = sono, FsoentryID = entryid
};
string sql = DbUtils.GetSqlWithObject(model, Operate.Select);
sql += "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("Fjde_sono", model.Fjde_sono);
cmd.Parameters.AddWithValue("FsoentryID", model.FsoentryID);
System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd);
System.Data.DataTable table = new System.Data.DataTable();
da.Fill(table);
if (table.Rows.Count == 1)
{
var t = model.GetType();
var pis = t.GetProperties().ToList();
var row = table.Rows[0];
pis.ForEach(p =>
{
var value = row[p.Name];
if (value != null && DBNull.Value != value)
{
p.SetValue(model, value, null);
}
});
return(model);
}
if (table.Rows.Count > 1)
{
throw new Exception(string.Format("TB_DZsrcdel表中存在多条符合条件【Fjde_sono={0} AND FsoentryID={1}】的记录", sono, entryid));
}
return(null);
}
protected void btnResetPassword_Click(object sender, EventArgs e)
{
try
{
String newpassword = New_password.Value;
using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST))
{
connection.Open();
string queryString = "update VP_LOGIN SET PASSWORD =:New_password WHERE EMAIL_ID = :email";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection);
command.Parameters.AddWithValue("email", Session["Otp_email"]);
command.Parameters.AddWithValue("New_password", newpassword);
int rowsUpdated = command.ExecuteNonQuery();
Response.Redirect("Login.aspx");
}
}
catch (Exception ex)
{
Response.Write("pm");
}
}
protected void DataList2_SelectedIndexChanged(object sender, EventArgs e)
{
int idx = DataList2.SelectedIndex;
Label lbl = (Label)DataList2.Items[idx].FindControl("Label2");
System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(ConfigurationManager.ConnectionStrings["CGConnectionString"].ToString());
System.Data.OracleClient.OracleCommand myCommand = new System.Data.OracleClient.OracleCommand("SELECT * FROM wf_it_images WHERE ID = '" + lbl.Text + "'", conn);
conn.Open();
System.Data.OracleClient.OracleDataReader myReader = myCommand.ExecuteReader(System.Data.CommandBehavior.Default);
try
{
while (myReader.Read())
{
System.Data.OracleClient.OracleLob myLob = myReader.GetOracleLob(myReader.GetOrdinal("IMAGE"));
if (!myLob.IsNull)
{
string FN = myReader.GetString(myReader.GetOrdinal("IMAGE_NAME"));
//Use buffer to transfer data
byte[] b = new byte[myLob.Length];
//Read data from database
myLob.Read(b, 0, (int)myLob.Length);
Response.AddHeader("content-disposition", "attachment;filename=" + FN);
Response.ContentType = "application/octectstream";
Response.BinaryWrite(b);
Response.End();
}
}
}
finally
{
myReader.Close();
conn.Close();
}
}
// https://social.msdn.microsoft.com/Forums/en-US/dc1b053d-f0d5-48f8-ad82-fb6d96d27f80/how-to-insert-or-update-blob-data-for-sqlserver-based-on-buffersize?forum=adodotnetdataproviders
public void WriteLargeFileChunckedOracle(string path)
{
byte[] buffer = new byte[1024];
using (System.Data.OracleClient.OracleCommand cmd = null)
{
using (System.Data.OracleClient.OracleDataReader dataReader = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
{
// this code segment works well for Oracle database
System.Data.OracleClient.OracleLob lob = dataReader.GetOracleLob(1);
using (System.IO.Stream fileStream = System.IO.File.OpenRead(path))
{
lob.SetLength(0);
int readBytes = 0;
while ((readBytes = fileStream.Read(buffer, 0, buffer.Length)) > 0)
{
lob.Write(buffer, 0, readBytes);
} // Whend
} // End Using fileStream
} // End Using dataReader
} // End Using cmd
} // End Sub WriteLargeFileChunckedOracle
protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
String useremail = txtemail.Value;
Session["Login_email"] = useremail;
String password = txtpassword.Value;
using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST))
{
connection.Open();
string queryString = "SELECT * FROM VP_LOGIN WHERE EMAIL_ID = :useremail AND PASSWORD = :password";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection);
command.Parameters.AddWithValue("useremail", useremail);
command.Parameters.AddWithValue("password", password);
using (System.Data.OracleClient.OracleDataReader reader = command.ExecuteReader())
{
if (reader.HasRows)
{
reader.Read();
/*Session["username"] = Convert.ToString(reader["EMAIL_ID"]);
* Session["name"] = Convert.ToString(reader["NAME"]);
* Session["contact"] = Convert.ToString(reader["CONTACT"]);*/
HttpContext.Current.Response.Redirect("VendorRegistration.aspx", false);
}
else
{
lblError.Text = "Check Your User Name and Password!";
}
}
}
}
catch (Exception ex)
{
lblError.Text = "Something Went Wrong!";
}
}
//total marks
//procedure
private void button1_Click(object sender, EventArgs e)
{
try
{
String oradb = "Data Source=DESKTOP-K6AG53J;Persist Security Info=True;User ID=system;Password=student;";
System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(oradb);
//conn.Open();
System.Data.OracleClient.OracleCommand comm = new System.Data.OracleClient.OracleCommand();
comm.Connection = conn;
comm.CommandText = "tot_marks";
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.Add("s_id", System.Data.OracleClient.OracleType.Number).Value = s1;
comm.Parameters.Add("co_id", System.Data.OracleClient.OracleType.Number).Value = comboBox1.Text;
comm.Parameters.Add("cout", System.Data.OracleClient.OracleType.Number).Direction = ParameterDirection.Output;
conn.Open();
comm.ExecuteNonQuery();
textBox1.Text = (comm.Parameters["cout"].Value).ToString();
conn.Close();
}
catch (IndexOutOfRangeException ex)
{
MessageBox.Show("Invalid Details!");
}
}
public DataResult Forder_delivery(List <Forder_delivery_Input> input)
{
string sql = "";
string where = "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID";
int count = 0;
DataResult result = new DataResult()
{
errCode = 0
};
System.Data.OracleClient.OracleCommand cmd = null;
try
{
if (input == null || input.Count == 0)
{
throw new Exception("传入参数不能为空");
}
TB_Dzsrcdel model = null;
cmd = DbUtils.GetCommand(model, Operate.Insert);
input.ForEach(p =>
{
DataChecker.CheckObj(p);
//根据Fjde_sono和FsoentryID获取底表记录FID
var manuscript = GetManuscript_By_SonoAnd_EntryID(p.Fjde_sono, p.FsoentryID, cmd);
model = GetDzsrcdel(p.Fjde_sono, p.FsoentryID, cmd);
Operate insertOrupdate = Operate.Update;
if (model == null)
{
insertOrupdate = Operate.Insert;
model = new TB_Dzsrcdel();
model.FmanuscriptID = manuscript.FID;
model.Fjde_sono = p.Fjde_sono;
model.FsoentryID = p.FsoentryID;
model.Fsrcbillno = p.Fsrcbillno;
model.fsrcdelno = p.Fsrcdelno;
model.fdeldate = p.Fdeldate;
model.Fproductcode = p.Fproductcode;
}
model.fdelqty = p.Fdelqty;
model.Fcasecode = p.Fcasecode;
model.Fisdelover = p.Fisdelover;
model.Fbuttstatus3 = p.Fbuttstatus3;
model.Fremark1 = p.Fremark2;
model.FTime = DateTime.Now;
//插入或更新子表记录
sql = DbUtils.GetSqlWithObject(model, insertOrupdate);
sql = insertOrupdate == Operate.Update ? sql += where:sql;
cmd.CommandText = sql;
DbUtils.GetParams(model, cmd);
count += cmd.ExecuteNonQuery();
});
//按销售单号，行号进行汇总求和发货数量
var group = input.GroupBy(p => new { p.Fjde_sono, p.FsoentryID })
.Select(p => new { Fjde_sono = p.Key.Fjde_sono, FsoentryID = p.Key.FsoentryID, Fdelqty_total = p.Sum(item => item.Fdelqty) })
.ToList();
//更新WHERE语句，根据销售单号和行号更新发货数量
where = "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID";
group.ForEach(p => {
// 更新底表发货数量
sql = string.Format("UPDATE TB_DZmanuscript SET Fdelqty_total={0} WHERE Fjde_sono={1} AND FsoentryID={2}", p.Fdelqty_total, p.Fjde_sono, p.FsoentryID);
cmd = DbUtils.GetCommand(new TB_DZmanuscript(), Operate.Update);
cmd.CommandText = sql;
count += cmd.ExecuteNonQuery();
});
cmd.Transaction.Commit();
cmd.Connection.Close();
if (count == 0)
{
throw new Exception("同步失败，插入了0条数据");
}
return(result);
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
LogHelper.WriteLog("Input: " + JsonHelper.ToJson(input));
LogHelper.WriteLog("SQL: " + sql);
result.errMsg = ex.Message;
result.errCode = -1;
if (cmd != null)
{
cmd.Transaction.Rollback();
cmd.Connection.Close();
}
return(result);
}
}
public void RunSQl(object dbmodel)
{
DbModel model = (DbModel)dbmodel;
if (string.IsNullOrEmpty(model.Conn)) return;
string sql = this.txtsql.Text.Trim();
string conn = model.Conn;
RichTextBox ctl = null;
if (model.TextBoxName == "rtxtCtosut")
{
ctl = this.rtxtCtosut;
}
else
{
ctl = this.rtxtCtosdemo;
}
Stopwatch sw = Stopwatch.StartNew();
sw.Restart();
StringBuilder sb = new StringBuilder();
DataSet ds = new DataSet();
string dbname = null;
try
{
if (model.isOdp)
{
using (OracleConnection oraconn = new OracleConnection(conn))
{
oraconn.Open();
dbname = oraconn.ServiceName;
OracleCommand cmd = new OracleCommand(sql, oraconn);
OracleDataAdapter oda = new OracleDataAdapter(cmd);
int x = oda.Fill(ds);
sw.Stop();
}
}
else
{
using (System.Data.OracleClient.OracleConnection oraconn = new System.Data.OracleClient.OracleConnection(conn))
{
oraconn.Open();
dbname = oraconn.DataSource;
System.Data.OracleClient.OracleCommand cmd = new System.Data.OracleClient.OracleCommand(sql, oraconn);
System.Data.OracleClient.OracleDataAdapter oda = new System.Data.OracleClient.OracleDataAdapter(cmd);
int x = oda.Fill(ds);
sw.Stop();
}
}
DataTable dt = ds.Tables[0];
sb.AppendFormat("#{3}, server: {4}, Return {0} rows with {1} columns, cost: {2}ms", dt.Rows.Count, dt.Columns.Count, sw.ElapsedMilliseconds, Thread.CurrentThread.ManagedThreadId, dbname);
if (dt.Rows.Count == 1)
{
sb.AppendLine();
foreach (DataColumn dc in dt.Columns)
{
sb.AppendFormat("Column {0}; Type {1}; Value {2};", dc.ColumnName.PadLeft(20), dc.DataType.ToString().PadLeft(20), dt.Rows[0][dc].ToString().PadLeft(20));
sb.AppendLine();
}
}
}
catch (Exception ex)
{
sb.AppendFormat("Error: {0}" , ex.Message);
}
sb.AppendLine();
if (this.rtxtCtosut.InvokeRequired)
{
Invoke(new SetContrlValueDelegate(SetTextboxValue), ctl, sb.ToString());
}
else
{
ctl.Text += sb.ToString();
SetState();
}
}
protected override ExeResEdm GetDataSets(List <SqlContianer> ltSqls)
{
ExeResEdm dBResEdm = new ExeResEdm();
DataSet ds = new DataSet();
try
{
using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr))
{
conn.Open();
System.Data.OracleClient.OracleTransaction tsOprate = conn.BeginTransaction();
try
{
System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
cmd.Transaction = tsOprate;
List <string> tbNames = new List <string>();
foreach (var objOraSqlCon in ltSqls)
{
DataTable dt = new DataTable();
if (!string.IsNullOrEmpty(objOraSqlCon.tableName))
{
dt.TableName = objOraSqlCon.tableName;
}
else
{
string tb = GetTableNameFromSelectSql(objOraSqlCon.strSqlTxt);
if (!string.IsNullOrEmpty(tb))
{
dt.TableName = tb;
}
}
if (tbNames.Contains(dt.TableName))
{
dt.TableName = dt.TableName + "_" + (tbNames.Count() + 1);
}
tbNames.Add(dt.TableName);
cmd.CommandText = objOraSqlCon.strSqlTxt;
cmd.Parameters.Clear();
if (objOraSqlCon.ltOraParams != null && objOraSqlCon.ltOraParams.Count > 0)
{
cmd.Parameters.AddRange(objOraSqlCon.ltOraParams.ToArray());
}
System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(cmd);
adapter.Fill(dt);
ds.Tables.Add(dt);
}
tsOprate.Commit();
}
catch (Exception ex)
{
tsOprate.Rollback();
dBResEdm.Module = "GetDataSets方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
}
}
catch (Exception ex)
{
dBResEdm.Module = "GetDataSets方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
dBResEdm.ExeModel = ds;
return(dBResEdm);
}
public ComCommand(string cmdText, ComConnection con, ComTransaction trans)
{
_cmd = new System.Data.OracleClient.OracleCommand(cmdText, con.Connection, trans.Transaction);
}
protected override ExeResEdm UpdateDsToDB(DataSet dsTables, Dictionary <string, string> dicDtMainFields = null)
{
ExeResEdm dBResEdm = new ExeResEdm();
int n = 0;
try
{
using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(connstr))
{
conn.Open();
System.Data.OracleClient.OracleTransaction tsOprate = conn.BeginTransaction();
try
{
System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
cmd.Transaction = tsOprate;
foreach (DataTable dtTemp in dsTables.Tables)
{
string strComFields = "*";
if (dicDtMainFields != null && dicDtMainFields.Count > 0 && dicDtMainFields.ContainsKey(dtTemp.TableName))
{
strComFields = !string.IsNullOrEmpty(dicDtMainFields[dtTemp.TableName]) ? dicDtMainFields[dtTemp.TableName]: strComFields;
}
cmd.CommandText = GetColumnsNameSql(dtTemp.TableName, strComFields);
System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(cmd);
var dtChanges = dtTemp.GetChanges();
adapter.FillSchema(dtChanges, SchemaType.Mapped); //new added
if (dtChanges != null) //是添加或更新
{
adapter.UpdateCommand = new System.Data.OracleClient.OracleCommandBuilder(adapter).GetUpdateCommand();
n += adapter.Update(dtChanges);
dtTemp.AcceptChanges();
}
else //是删除
{
adapter.DeleteCommand = new System.Data.OracleClient.OracleCommandBuilder(adapter).GetDeleteCommand();
for (int i = dtTemp.Rows.Count - 1; i >= 0; i--)
{
dtTemp.Rows[i].Delete();
}
n += adapter.Update(dtTemp);
}
}
dsTables.AcceptChanges();
tsOprate.Commit();
}
catch (Exception ex)
{
tsOprate.Rollback();
dBResEdm.Module = "UpdateDsToDB方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
}
}
catch (Exception ex)
{
dBResEdm.Module = "UpdateDsToDB方法";
dBResEdm.ExBody = ex;
dBResEdm.ErrCode = 1;
return(dBResEdm);
}
dBResEdm.ExeNum = n;
return(dBResEdm);
}
private void DisplayDataForQuery()
{
//AppGlobals.AppMessages.DisplayAlertMessage("DisplayDataForQuery");
dataGridView1.DataSource = null;
if (queryBuilder.MetadataProvider != null && queryBuilder.MetadataProvider.Connected)
{
if (queryBuilder.MetadataProvider is MSSQLMetadataProvider)
{
SqlCommand command = (SqlCommand)queryBuilder.MetadataProvider.Connection.CreateCommand();
command.CommandText = queryBuilder.SQL;
// handle the query parameters
if (queryBuilder.Parameters.Count > 0)
{
for (int i = 0; i < queryBuilder.Parameters.Count; i++)
{
if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName))
{
SqlParameter parameter = new SqlParameter();
parameter.ParameterName = queryBuilder.Parameters[i].FullName;
parameter.DbType = queryBuilder.Parameters[i].DataType;
command.Parameters.Add(parameter);
}
}
using (QueryParametersForm qpf = new QueryParametersForm(command))
{
qpf.ShowDialog();
}
}
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet dataset = new DataSet();
try
{
adapter.Fill(dataset, "QueryResult");
dataGridView1.DataSource = dataset.Tables["QueryResult"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "SQL query error");
}
}//end sql server
//if (queryBuilder.MetadataProvider is MSSQLCEMetadataProvider)
//{
// SqlCeCommand command = (SqlCeCommand)queryBuilder.MetadataProvider.Connection.CreateCommand();
// command.CommandText = queryBuilder.SQL;
// // handle the query parameters
// if (queryBuilder.Parameters.Count > 0)
// {
// for (int i = 0; i < queryBuilder.Parameters.Count; i++)
// {
// if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName))
// {
// SqlCeParameter parameter = new SqlCeParameter();
// parameter.ParameterName = queryBuilder.Parameters[i].FullName;
// parameter.DbType = queryBuilder.Parameters[i].DataType;
// command.Parameters.Add(parameter);
// }
// }
// using (QueryParametersForm qpf = new QueryParametersForm(command))
// {
// qpf.ShowDialog();
// }
// }
// SqlCeDataAdapter adapter = new SqlCeDataAdapter(command);
// DataSet dataset = new DataSet();
// try
// {
// adapter.Fill(dataset, "QueryResult");
// dataGridView1.DataSource = dataset.Tables["QueryResult"];
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message, "SQL query error");
// }
//}//end sql server ce
if (queryBuilder.MetadataProvider is OLEDBMetadataProvider)
{
//AppGlobals.AppMessages.DisplayAlertMessage("for OLEDBMetadataProvider");
OleDbCommand command = (OleDbCommand)queryBuilder.MetadataProvider.Connection.CreateCommand();
command.CommandText = queryBuilder.SQL;
// handle the query parameters
if (queryBuilder.Parameters.Count > 0)
{
for (int i = 0; i < queryBuilder.Parameters.Count; i++)
{
if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName))
{
OleDbParameter parameter = new OleDbParameter();
parameter.ParameterName = queryBuilder.Parameters[i].FullName;
parameter.DbType = queryBuilder.Parameters[i].DataType;
command.Parameters.Add(parameter);
}
}
using (QueryParametersForm qpf = new QueryParametersForm(command))
{
qpf.ShowDialog();
}
}
OleDbDataAdapter adapter = new OleDbDataAdapter(command);
DataSet dataset = new DataSet();
try
{
adapter.Fill(dataset, "QueryResult");
dataGridView1.DataSource = dataset.Tables["QueryResult"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "SQL query error");
}
//AppGlobals.AppMessages.DisplayAlertMessage("end for OLEDBMetadataProvider");
}//end ole schemaRoot
if (queryBuilder.MetadataProvider is ODBCMetadataProvider)
{
OdbcCommand command = (OdbcCommand)queryBuilder.MetadataProvider.Connection.CreateCommand();
command.CommandText = queryBuilder.SQL;
// handle the query parameters
if (queryBuilder.Parameters.Count > 0)
{
for (int i = 0; i < queryBuilder.Parameters.Count; i++)
{
if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName))
{
OdbcParameter parameter = new OdbcParameter();
parameter.ParameterName = queryBuilder.Parameters[i].FullName;
parameter.DbType = queryBuilder.Parameters[i].DataType;
command.Parameters.Add(parameter);
}
}
using (QueryParametersForm qpf = new QueryParametersForm(command))
{
qpf.ShowDialog();
}
}
OdbcDataAdapter adapter = new OdbcDataAdapter(command);
DataSet dataset = new DataSet();
try
{
adapter.Fill(dataset, "QueryResult");
dataGridView1.DataSource = dataset.Tables["QueryResult"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "SQL query error");
}
}//end odbc
if (queryBuilder.MetadataProvider is OracleMetadataProvider)
{
System.Data.OracleClient.OracleCommand command = (System.Data.OracleClient.OracleCommand)queryBuilder.MetadataProvider.Connection.CreateCommand();
command.CommandText = queryBuilder.SQL;
// handle the query parameters
if (queryBuilder.Parameters.Count > 0)
{
for (int i = 0; i < queryBuilder.Parameters.Count; i++)
{
if (!command.Parameters.Contains(queryBuilder.Parameters[i].FullName))
{
System.Data.OracleClient.OracleParameter parameter = new System.Data.OracleClient.OracleParameter();
parameter.ParameterName = queryBuilder.Parameters[i].FullName;
parameter.DbType = queryBuilder.Parameters[i].DataType;
command.Parameters.Add(parameter);
}
}
using (QueryParametersForm qpf = new QueryParametersForm(command))
{
qpf.ShowDialog();
}
}
System.Data.OracleClient.OracleDataAdapter adapter = new System.Data.OracleClient.OracleDataAdapter(command);
DataSet dataset = new DataSet();
try
{
adapter.Fill(dataset, "QueryResult");
dataGridView1.DataSource = dataset.Tables["QueryResult"];
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "SQL query error");
}
} //end oracle (ms)
} //end check if connected
} //end method
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("ÕýÔÚ¼ìË÷");
Application.DoEvents();
Neusoft.FrameWork.Management.Connection.Instance = new System.Data.OracleClient.OracleConnection(Neusoft.FrameWork.Management.Connection.Instance.ConnectionString);
Neusoft.FrameWork.Management.Connection.Instance.Open();
Neusoft.FrameWork.Management.DataBaseManger m = new Neusoft.FrameWork.Management.DataBaseManger();
DataSet ds = new DataSet();
if (m.ExecQuery("select id,name from com_sql", ref ds) == -1)
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
MessageBox.Show(m.Err);
return;
}
//Neusoft.FrameWork.Management.Connection.Instance.Close();
//Neusoft.FrameWork.Management.Connection.Instance = new Oracle.DataAccess.Client.OracleConnection(Neusoft.FrameWork.Management.Connection.Instance.ConnectionString);
//Neusoft.FrameWork.Management.Connection.Instance.Open();
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
m.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
//m.SetTrans(t.Trans);
foreach (DataRow dr in ds.Tables[0].Rows)
{
string s = "update com_sql set name1 = :a where id='" + dr[0].ToString() + "'";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(s);
command.Connection = Neusoft.FrameWork.Management.Connection.Instance as System.Data.OracleClient.OracleConnection;
command.CommandText = s;
command.CommandType = System.Data.CommandType.Text;
command.Transaction = Neusoft.FrameWork.Management.PublicTrans.Trans as System.Data.OracleClient.OracleTransaction;
System.Data.OracleClient.OracleParameter param = command.Parameters.Add("a", System.Data.OracleClient.OracleType.Clob);
param.Direction = System.Data.ParameterDirection.Input;
// Assign Byte Array to Oracle Parameter
param.Value = dr[1].ToString();
// Step 5
// Execute the Anonymous PL/SQL Block
try
{
if (command.ExecuteNonQuery() == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
MessageBox.Show(m.Err);
return;
}
}
catch (Exception ex)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
MessageBox.Show(ex.Message);
return;
}
//if (m.InputBlob(s, b)== -1)
//{
// t.RollBack();
// Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
// MessageBox.Show(m.Err);
// return;
//}
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(dr[0].ToString() + "\n" + dr[1].ToString());
Application.DoEvents();
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
MessageBox.Show("³É¹¦£¡");
}
private TB_DZmanuscript GetManuscript_By_SonoAnd_EntryID(string sono, int entryid, System.Data.OracleClient.OracleCommand cmd)
{
TB_DZmanuscript model = new TB_DZmanuscript()
{
Fjde_sono = sono, FsoentryID = entryid
};
string sql = DbUtils.GetSqlWithObject(model, Operate.Select);
sql += "WHERE Fjde_sono=:Fjde_sono AND FsoentryID=:FsoentryID";
cmd.CommandText = sql;
DbUtils.GetParams(model, cmd);
System.Data.OracleClient.OracleDataAdapter da = new System.Data.OracleClient.OracleDataAdapter(cmd);
System.Data.DataTable table = new System.Data.DataTable();
da.Fill(table);
if (table.Rows.Count == 1)
{
var t = model.GetType();
var pis = t.GetProperties().ToList();
var row = table.Rows[0];
model.FID = row["FID"].ToString();
return(model);
}
if (table.Rows.Count > 1)
{
throw new Exception(string.Format("{2}表中存在多条符合条件【Fjde_sono={0} AND FsoentryID={1}】的记录", sono, entryid, table.TableName));
}
throw new Exception("未找到相关的底表记录");
}
protected void btnFormSubmit_Click(object sender, EventArgs e)
{
try
{
String selectp = Request.Form.Get("title");
String Fname = fname.Value;
String Mname = mname.Value;
String Lname = lname.Value;
String Username = selectp + " " + Fname + " " + Mname + " " + Lname;
String House_no = house_no.Value;
String Street = street.Value;
String City_code = city_code.Value;
String City = city.Value;
String State = state.Value;
String PIN = pin.Value;
String Country = country.Value;
String Address = House_no + ", " + Street + ", " + City_code + ", " + City + ", " + State + ", " + PIN + ", " + Country;
String Contact_person = contact_person.Value;
String Telephone_no = telephone_no.Value;
String Mobile_no = mobile_no.Value;
String Fax = fax.Value;
//String Email = email_id.Value;
String Pan = pan_no.Value;
String Gst_no = gst_no.Value;
String Industry = industry.Value;
String Micro = micro.Value;
using (System.Data.OracleClient.OracleConnection connection = new System.Data.OracleClient.OracleConnection(connectionStringGST))
{
connection.Open();
string queryString = "insert into VP_REGISTRATION (NAME, ADDRESS, CONTACT_PERSON,EMAIL,FAX, GST_NO, INDUSTRY, MICRO_OR_SSI_STATUS, MOBILE_NO, PAN_NO, TELEPHONE_NO_EXT) values (:username , :Address, :C_person, :Email, :Fax, :Gst, :Industry, :Micro, :Mob_no, :Pan_no, :Telephone_no)";
System.Data.OracleClient.OracleCommand command = new System.Data.OracleClient.OracleCommand(queryString, connection);
command.Parameters.AddWithValue("username", Username);
command.Parameters.AddWithValue("Address", Address);
command.Parameters.AddWithValue("C_person", Contact_person);
command.Parameters.AddWithValue("Email", Session["Login_email"]);
command.Parameters.AddWithValue("Fax", Fax);
command.Parameters.AddWithValue("Gst", Gst_no);
command.Parameters.AddWithValue("Industry", Industry);
command.Parameters.AddWithValue("Micro", Micro);
command.Parameters.AddWithValue("Mob_no", Mobile_no);
command.Parameters.AddWithValue("Pan_no", Pan);
command.Parameters.AddWithValue("Telephone_no", Telephone_no);
int rowsUpdated = command.ExecuteNonQuery();
if (rowsUpdated == 0)
{
Response.Write("Record not inserted");
}
else
{
HttpContext.Current.Response.Redirect("Login.aspx", false);
}
}
}
catch (Exception ex)
{
lblError.Text = "Something Went Wrong!";
}
}
