/// <summary>
/// A113 获取病人信息函数 getPersonInfo_New
/// </summary>
/// <param name="rateType"></param>
/// <param name="outParm"></param>
/// <returns></returns>
public virtual string getPersonInfo_New(string rateType, string centerCode, string cardNo)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.getPersonInfo_New(rateType, centerCode, cardNo, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A102 药品匹配数据审核状态查询 matchSeek
/// </summary>
/// <param name="rateType"></param>
/// <param name="outParm"></param>
/// <returns></returns>
public virtual string matchSeek(string rateType, string insurancePriceItemCode, string itemCode)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.matchSeek(rateType, insurancePriceItemCode, itemCode, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A003 补偿类别字典下载redeemTypeDownLoad
/// </summary>
/// <param name="rateType"></param>
/// <returns></returns>
public virtual string redeemTypeDownLoad(string rateType)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.redeemTypeDownLoad(rateType, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
/// <summary>
/// A008 转诊单信息查询 downloadReferralsheet
/// </summary>
/// <param name="rateType"></param>
/// <param name="operateType"></param>
/// <param name="turnCode"></param>
/// <param name="safetyNo"></param>
/// <returns></returns>
public virtual string downloadReferralsheet(string rateType, string inoutType, string turnCode, string safetyNo)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.downloadReferralsheet(rateType, inoutType, turnCode, safetyNo, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
protected void Button1_Click(object sender, EventArgs e)
{
///////////////delete button////////////////////
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string delete_genreId_check = string.Format("select * from cd_genre where genre_id = {0}", TextBox1.Text);
DataTable genre_delete_table = oc.searchDB(delete_genreId_check);
if (String.IsNullOrWhiteSpace(TextBox1.Text))
{
Label1.Text = "Please enter all informations";
}
else if (genre_delete_table.Rows.Count == 0)
{
Label1.Text = "No Genre with this Id, Please enter correct Id";
}
else
{
string deleteQuery = string.Format("delete from cd_genre where genre_id={0}", TextBox1.Text);
oc.updateDB(deleteQuery);
TextBox1.Text = "";
//TextBox2.Text = "";
Label1.Text = "";
oc.close();
}
}
/// <summary>
/// 2113 通过身份证号， 获取病人的就诊卡信息
/// </summary>
/// <param name="docRequestPre"></param>
/// <param name="outParm"></param>
/// <returns></returns>
public int GetSickCardByIdCard2113(XmlDocument docRequestPre, out string outParm)
{
outParm = "";
try
{
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
PreXuanchengCityDal ruralResiDal = new PreXuanchengCityDal();
ruralResiDal.GetSickCardByIdCard2113(docRequestPre, out outParm);
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
}
catch (Exception ex)
{
UtilityDAL initXmlDoc = new UtilityDAL();
XmlDocument docResponse = initXmlDoc.GetResponseXmlDoc();
XmlNode ndResponse = docResponse.SelectSingleNode("Response");
ndResponse.SelectSingleNode("TradeCode").InnerText = "2108";
ndResponse.SelectSingleNode("ResultCode").InnerText = "0004";
ndResponse.SelectSingleNode("ResultContent").InnerText = ex.Message;
outParm = docResponse.OuterXml;
return(-1);
}
return(0);
}
public virtual string inpatientUpdate(string rateType, string centerCodeEx, string insuranceNo, string residenceNo, string diagnosisCode, string diagnosisCode2, string treatCode, string admissionDept, string admissionTime, string registType, string admissionCondition, string doctor, string bedNo, string ward, string turnCode)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.inpatientUpdate(rateType, centerCodeEx, insuranceNo, residenceNo, diagnosisCode,
diagnosisCode2, treatCode, admissionDept, admissionTime, registType,
admissionCondition, doctor, bedNo, ward, turnCode, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B008 出院登记（扩展函数）leaveInpatientRegister
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <param name="dischargeTime"></param>
/// <param name="outDept"></param>
/// <param name="diseaseStatus"></param>
/// <param name="diagnosisCode"></param>
/// <returns></returns>
public virtual string leaveInpatientRegister(string rateType, string centerCodeEx, string insuranceNo, string dischargeTime,
string outDept, string doctorName, string doctorId,
string diseaseStatus, string diagnosisCode, string treatCode, string turnCode)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.leaveInpatientRegister(rateType, centerCodeEx, insuranceNo, dischargeTime,
outDept, doctorName, doctorId,
diseaseStatus, diagnosisCode, treatCode, turnCode, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B012 住院兑付（扩展函数）inpatientPay
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <param name="redeemNo"></param>
/// <param name="phoneNo"></param>
/// <returns></returns>
public virtual string inpatientPay(string rateType, string centerCodeEx, string insuranceNo, string redeemNo, string phoneNo,
string obligateOne, string obligateTwo, string obligateThree,
string obligateFour, string obligateFive)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.inpatientPay(rateType, centerCodeEx, insuranceNo, redeemNo, phoneNo,
obligateOne, obligateTwo, obligateThree, obligateFour, obligateFive, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B005 住院费用明细录入函数inpDetailInput
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <param name="applyNo"></param>
/// <param name="hiscode"></param>
/// <param name="insureId"></param>
/// <param name="classId"></param>
/// <param name="name"></param>
/// <param name="spec"></param>
/// <param name="unit"></param>
/// <param name="conf"></param>
/// <param name="price"></param>
/// <param name="quantity"></param>
/// <param name="money"></param>
/// <param name="factMoney"></param>
/// <param name="useDate"></param>
/// <returns></returns>
public virtual string inpDetailInput(string rateType, string centerCodeEx, string insuranceNo, string applyNo, string hiscode, string insureId, string classId, string name, string spec, string unit, string conf, string price, string quantity, string money, string factMoney, string useDate)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.inpDetailInput(rateType, centerCodeEx, insuranceNo, applyNo, hiscode, insureId,
classId, name, spec, unit, conf, price, quantity,
money, factMoney, useDate, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// B007 住院批量费用明细录入函数（扩展函数）uploadInpatientDetails
/// </summary>
/// <param name="rateType"></param>
/// <param name="sickId"></param>
/// <param name="residenceNo"></param>
/// <param name="rowCount"></param>
/// <param name="xmlDetails"></param>
/// <returns></returns>
public virtual string uploadInpatientDetails(string rateType, string centerCodeEx, string sickId, string residenceNo, string rowCount, string xmlDetails)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.uploadInpatientDetails(rateType, centerCodeEx, sickId, residenceNo, rowCount, xmlDetails, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
/// <summary>
/// A006 上传/修改转诊单信息 uploadReferralsheet
/// </summary>
/// <param name="rateType"></param>
/// <param name="infoType"></param>
/// <param name="turnCode"></param>
/// <param name="safetyNo"></param>
/// <param name="idCardNo"></param>
/// <param name="sickName"></param>
/// <param name="birthday"></param>
/// <param name="insurCardNo"></param>
/// <param name="turnType"></param>
/// <param name="icdCode"></param>
/// <param name="icdName"></param>
/// <param name="beginDate"></param>
/// <param name="cityType"></param>
/// <param name="remark"></param>
/// <returns></returns>
public virtual string uploadReferralsheet(string rateType, string infoType, string turnCode, string safetyNo,
string idCardNo, string sickName, string sexName, string birthday, string insurCardNo,
string phoneNo, string turnType, string icdCode, string icdName, string beginDate,
string fromHospCode, string fromHospName, string toHospCode, string toHospName,
string cityType, string toHospLevel,
string remark)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
BasicInformationDAL basicInfoDAL = new BasicInformationDAL();
if (basicInfoDAL.uploadReferralsheet(rateType, infoType, turnCode, safetyNo, idCardNo, sickName,
sexName, birthday, insurCardNo, phoneNo, turnType, icdCode, icdName, beginDate,
fromHospCode, fromHospName, toHospCode, toHospName, cityType, toHospLevel,
remark, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
return("success:" + outParm);
}
public int SendLisBeforeSettle(XmlNode ndApplyItems, out string outParm)
{
outParm = "";
try
{
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
NjpkSelfServiceDal serviceDal = new NjpkSelfServiceDal();
if (serviceDal.SendLisBeforeSettle(ndApplyItems, out outParm) < 0)
{
dbTran.Rollback();
}
else
{
dbTran.Commit();
}
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
}
catch (Exception ex)
{
return(-1);
}
return(0);
}
protected void Button2_Click(object sender, EventArgs e)
{
///////////////////update button//////////////////////////
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string update_genreId_check = string.Format("select * from cd_genre where genre_id = {0}", TextBox2.Text);
DataTable genre_update_table = oc.searchDB(update_genreId_check);
if (String.IsNullOrWhiteSpace(TextBox2.Text) || String.IsNullOrWhiteSpace(TextBox3.Text) || DropDownList1.SelectedItem.Text.Equals("Select From"))
{
Label2.Text = "Please enter all informations";
}
else if (genre_update_table.Rows.Count == 0)
{
Label2.Text = "No genre with this Id, Please enter correct Id";
}
else
{
string drop_down = DropDownList1.SelectedItem.Text;
string updateQuery2 = string.Format("update cd_genre set {0} = '{1}' where genre_id= {2}", drop_down, TextBox3.Text, TextBox2.Text);
oc.updateDB(updateQuery2);
TextBox2.Text = "";
TextBox3.Text = "";
Label2.Text = "";
oc.close();
}
}
public int ReportStatusInfo(string hisAppid, string affirmMan, string affirmDate, string status, out string outParm)
{
outParm = "";
try
{
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
DHCRisDal risDal = new DHCRisDal();
risDal.ReportStatusInfo(hisAppid, affirmMan, affirmDate, status, out outParm);
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
}
catch (Exception ex)
{
return(-1);
}
return(0);
}
static void Main(string[] args)
{
OracleConnect con = new OracleConnect("User ID=import_user;password=sT7hk9Lm;Data Source=CD_WORK");
con.OpenConnect();
ReadDataToList(con);
}
protected void Button1_Click(object sender, EventArgs e)
{
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string adminusernamecheck = string.Format("select * from np_admin where admin_username = upper('{0}')", TextBox1.Text);
DataTable admin_table = oc.searchDB(adminusernamecheck);
if (String.IsNullOrWhiteSpace(TextBox1.Text) || String.IsNullOrWhiteSpace(TextBox2.Text))
{
Label1.Text = "Please enter all informations";
}
else if (admin_table.Rows.Count != 0)
{
Label1.Text = "User with this name already exists, give another user name";
}
else
{
string insertQuery = string.Format("insert into np_admin(admin_id, admin_username,admin_password) values(np_admin_sequence.nextval, '{0}', '{1}')", TextBox1.Text.ToUpper(), TextBox2.Text);
oc.updateDB(insertQuery);
TextBox1.Text = "";
TextBox2.Text = "";
Label1.Text = "";
oc.close();
}
}
public int getSchedueInfo(XmlDocument docRequestPre, out string outParm)
{
outParm = "";
try
{
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
NjpkSelfServiceDal serviceDal = new NjpkSelfServiceDal();
serviceDal.getSchedueInfo(docRequestPre, out outParm);
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
}
catch (Exception ex)
{
return(-1);
}
return(0);
}
public int GetCurrentRegisterType(XmlDocument docRequestPre, out string outParm)
{
outParm = "";
try
{
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
NjpkSelfServiceDal serviceDal = new NjpkSelfServiceDal();
if (serviceDal.GetCurrentRegisterType(docRequestPre, out outParm) < 0)
{
dbTran.Rollback();
}
else
{
dbTran.Commit();
}
}
catch (Exception ex)
{
dbTran.Rollback();
throw ex;
}
}
}
catch (Exception ex)
{
return(-1);
}
return(0);
}
/// <summary>
/// B003 取消住院登记（扩展函数）cancelInpatientRegister
/// </summary>
/// <param name="rateType"></param>
/// <param name="insuranceNo"></param>
/// <returns></returns>
public virtual string cancelInpatientRegister(string rateType, string centerCodeEx, string insuranceNo)
{
string outParm;
using (OracleConnection dbCon = OracleConnect.Connect())
{
OracleTransaction dbTran = dbCon.BeginTransaction();
CreateDBTransaction(dbCon, dbTran);
try
{
RuralResiDAL ruralResiDal = new RuralResiDAL();
if (ruralResiDal.cancelInpatientRegister(rateType, centerCodeEx, insuranceNo, out outParm) < 0)
{
dbTran.Rollback();
return("error:" + outParm);
}
dbTran.Commit();
}
catch (Exception ex)
{
dbTran.Rollback();
return("error:" + ex.Message);
}
}
return("success:" + outParm);
}
protected void Page_Load(object sender, EventArgs e)
{
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string showQuery = "select * from cd_pay_order";
this.LoadGrid2(showQuery);
oc.close();
}
protected void Button2_Click(object sender, EventArgs e)
{
//////////////////////update Button//////////////////////////
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string update_cdId_check = string.Format("select * from cd_collection where cd_id = {0}", TextBox2.Text);
DataTable cd_update_table = oc.searchDB(update_cdId_check);
if (String.IsNullOrWhiteSpace(TextBox2.Text) || String.IsNullOrWhiteSpace(TextBox3.Text) || DropDownList1.SelectedItem.Text.Equals("Select From"))
{
Label2.Text = "Please enter all informations";
}
else if (cd_update_table.Rows.Count == 0)
{
Label2.Text = "No Cd with this Id, Please enter correct Id";
}
else
{
string drop_down = DropDownList1.SelectedItem.Text;
if (drop_down.Equals("price") || drop_down.Equals("category_id") || drop_down.Equals("genre_id"))
{
string update_cat_id_check = string.Format("select * from cd_category where category_id = {0}", TextBox3.Text);
string update_gen_id_check = string.Format("select * from cd_genre where genre_id = {0}", TextBox3.Text);
DataTable cd_update_check_cat_table = oc.searchDB(update_cat_id_check);
DataTable cd_update_check_gen_table = oc.searchDB(update_gen_id_check);
if (drop_down.Equals("category_id") && cd_update_check_cat_table.Rows.Count == 0)
{
Label2.Text = "No such categroy id available, Please enter correct Id";
}
else if (drop_down.Equals("genre_id") && cd_update_check_gen_table.Rows.Count == 0)
{
Label2.Text = "No such genre id available, Please enter correct Id";
}
else
{
string updateQuery1 = string.Format("update cd_collection set {0} = {1} where cd_id= {2}", drop_down, TextBox3.Text, TextBox2.Text);
oc.updateDB(updateQuery1);
TextBox2.Text = "";
TextBox3.Text = "";
Label2.Text = "";
oc.close();
}
}
else
{
string updateQuery2 = string.Format("update cd_collection set {0} = '{1}' where cd_id= {2}", drop_down, TextBox3.Text, TextBox2.Text);
oc.updateDB(updateQuery2);
TextBox2.Text = "";
TextBox3.Text = "";
Label2.Text = "";
oc.close();
}
}
}
private void LoadGrid(string q_parameter)
{
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string query = q_parameter;//"select * from products order by id";
DataTable table = oc.searchDB(query);
this.GridView1.DataSource = table;
this.GridView1.DataBind();
GridView1.Visible = true;
oc.close();
}
protected void Button36_Click(object sender, EventArgs e)
{
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string deleteQuery = string.Format("delete from cd_history");
oc.updateDB(deleteQuery);
//TextBox1.Text = "";
//TextBox2.Text = "";
//Label1.Text = "";
oc.close();
}
public static void CreateConnect()
{
try
{
_con = new OracleConnect(AppSettings.DbConnectionString);
_con.OpenConnect();
}
catch (Exception ex)
{
MessageBox.Show("Exception from Semaphore.Infrastructure.Manager.CreateConnect()" + ex.Message);
}
}
public static void CreateConnect()
{
try
{
_con = new OracleConnect(AppSettings.DbConnectionString);
_con.OpenConnect();
}
catch (Exception ex)
{
MessageBox.Show("Exception from MyLetterManager.LetterManager.CreateConnect()" + ex.Message);
}
}
static string DbReader(OracleConnect connnect, string queryName)
{
string str = "";
string query = "select t.query_block from LETTER_BLDR t where t.name = '" + queryName + "'";
OracleDataReader reader = connnect.GetReader(query);
while (reader.Read())
{
str = reader[0].ToString();
}
reader.Close();
return(str);
}
static void ReadDataToList(OracleConnect con)
{
try
{
string query = "select x.id, x.project_id, x.data " +
"from SUVD.PROJECTS t, suvd.creditor_dogovors d, suvd.project_xml x " +
"where d.id = t.dogovor_id " +
"and t.archive_flag = 0" +
"and nvl(d.stop_date, sysdate) >= sysdate " +
"and x.project_id = t.id " +
"and x.data is not null";
OracleDataReader reader = con.GetReader(query);
DateTime startDate = DateTime.Now;
DateTime lastDate = DateTime.Now;
Console.WriteLine("Старт. " + startDate);
int count = 0;
int bitStart = 0;
while (reader.Read() && count < 100)
{
count++;
//if (count < 77888) continue;
XmlData xmlData = new XmlData();
xmlData.Id = Convert.ToDecimal(reader[0].ToString());
xmlData.ProjectId = Convert.ToDecimal(reader[1].ToString());
xmlData.Data = reader[2].ToString();
Parser(xmlData, con, count);
if (count % 25000 == 0)
{
double tmp = (DateTime.Now - lastDate).TotalMinutes;
Console.WriteLine("c " + bitStart.ToString() + " по " + count.ToString() + " залилось за " + tmp.ToString() + " минут.");
bitStart = count;
lastDate = DateTime.Now;
Console.WriteLine();
}
//Console.WriteLine(count.ToString());
FileHandler.WriteToFile(count.ToString());
}
reader.Close();
DateTime endDate = DateTime.Now;
double dif = (endDate - startDate).TotalMinutes;
Console.WriteLine("Закончено за " + dif + " минут." + Environment.NewLine + "Распарсено " + count + " записей.");
Console.ReadLine();
}
catch (Exception ex)
{
Console.WriteLine(ex.TargetSite + "\n" + ex.Message);
FileHandler.WriteToFile(ex.TargetSite + "\n" + ex.Message);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(TextBox1.Text))
{
Label1.Text = "Please enter all informations";
}
else
{
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string insertQuery = string.Format("insert into cd_category(category_id, category_name) values(cd_category_sequence.nextval, '{0}')", TextBox1.Text);
oc.updateDB(insertQuery);
TextBox1.Text = "";
Label1.Text = "";
oc.close();
}
}
private void LoadGrid(string q_parameter)
{
OracleConnect oc = new OracleConnect("localhost", "orcl", "hr", "hr");
string query = q_parameter;//"select * from products order by id";
DataTable table = oc.searchDB(query);
/* if (!table.IsInitialized)
* {
* Label1.Visible = true;
* Label1.Text = "nodata";
*
* }*/
this.GridView1.DataSource = table;
this.GridView1.DataBind();
GridView1.Visible = true;
oc.close();
}
