/// <summary>
/// Авторизация.
/// </summary>
public static bool Autorization(decimal worguild, string password)
{
var dbFolder = Properties.Settings.Default.FoxProDbFolder_Temp;
const string query = "SELECT * FROM WorkingStandardsPassword " +
"WHERE workguild = ? AND password = ?";
try
{
using (var oleDbConnection = DbControl.GetConnection(dbFolder))
{
// Установка соединения и проверка кодировки
oleDbConnection.TryConnectOpen();
oleDbConnection.VerifyInstalledEncoding("BalancePassword");
using (var oleDbCommand = new OleDbCommand(query, oleDbConnection))
{
oleDbCommand.Parameters.AddWithValue("workguild", worguild);
oleDbCommand.Parameters.AddWithValue("password", password);
using (var reader = oleDbCommand.ExecuteReader())
{
return(reader != null && reader.Read());
}
}
}
}
catch (OleDbException ex)
{
throw DbControl.HandleKnownDbFoxProAndMssqlServerExceptions(ex);
}
}
protected void bntSignIn_Click(object sender, EventArgs e)
{
TUser tUser;
//Verify if txtId is nothing
if ((txtId.Value.Trim() == "") || (txtPassword.Value.Trim() == ""))
{
Response.Write("<script type='text/javascript'>alert('ID number and Password cannot be NULL!');</script>");
return;
}
tUser = DbControl.getInstance().getUser(txtId.Value, txtPassword.Value);
//Verify if ID or PASSWORD is Wrong
if (tUser == null)
{
Response.Write("<script type='text/javascript'>alert('ID number or Password wrong!');</script>");
return;
}
else
{
Session["user"] = tUser;
if (tUser.id == "admin")
{
Response.Redirect("admin.aspx");
}
else
{
Response.Redirect("home.aspx");
}
}
}
protected void Page_Init(object sender, EventArgs e)
{
for (int i = 0; i <= 23; i++)
{
stime.Items.Add(i.ToString());
etime.Items.Add(i.ToString());
}
unitid = Request.QueryString["unitid"];
// unitname = Unitlib.Get_UnitName(int.Parse(unitid));
string strsql = "SELECT * FROM tbl_banner_class where unitid = (select upperid from unitdata where unitid= @id) order by sort ";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("id", Request.QueryString ["unitid"]);
DataTable dt = DbControl.Data_Get(strsql, nvc);
DropDownList1.DataSource = dt;
DropDownList1.DataBind();
nvc.Clear();
strsql = "select * FROM tbl_category";
dt = DbControl.Data_Get(strsql, nvc);
DropDownList2.DataSource = dt;
DropDownList2.DataBind();
DropDownList2.Items.Insert(0, new ListItem("全部", ""));
DropDownList2_SelectedIndexChanged(sender, e);
}
public void selectSQL(string sorttype = "desc", string sortColumn = "packageid")
{
string strsql = @" SELECT (SELECT TOP (1) tbl_productData.logo
FROM tbl_package_product INNER JOIN
tbl_productData ON tbl_package_product.p_id = tbl_productData.p_id
WHERE tbl_package_product.packageid = Tbl_package.packageid) AS logo,
Tbl_package.*
FROM Tbl_package where status <> 'D' ";
if (search_txt.Text != "")
{
int n;
bool isNumeric = int.TryParse(search_txt.Text, out n);
strsql += @" and (ReMark like '%'+@S+'%' or packagename like '%'+@S+'%' or description like '%'+@S+'%') ";
}
if (DropDownList1.SelectedIndex > 0)
{
strsql += " and categoryid = @categoryid";
}
strsql += " ORDER BY sort," + sortColumn + " " + sorttype;
NameValueCollection nvc = new NameValueCollection();
nvc.Add("S", search_txt.Text);
nvc.Add("categoryid", DropDownList1.SelectedValue);
DataTable dt = DbControl.Data_Get(strsql, nvc);
ListView1.DataSource = dt;
ListView1.DataBind();
dt.Dispose();
MultiView1.ActiveViewIndex = 0;
}
public static dynamic MyJoinLesson(string memberid)
{
string strsql = @"SELECT tbl_lesson.startday, tbl_lesson.address, tbl_lesson.lessontime, tbl_OrderData.ord_code, tbl_OrderData.memberid,
tbl_Joindata.joinid, tbl_OrderData.paymode, tbl_OrderData.TotalPrice, tbl_OrderData.ordname,
tbl_OrderData.ordphone, tbl_OrderData.ord_date, tbl_article.articleId, tbl_article.subject, tbl_article.pic,
tbl_lesson.endday, tbl_OrderData.companyno, tbl_OrderData.title, tbl_OrderData.status, tbl_OrderData.ord_id,
tbl_OrderData.ordaddress, tbl_OrderData.atmcode, tbl_OrderData.card_code, tbl_OrderData.card_pan,
tbl_OrderData.card_response, tbl_OrderData.paid, tbl_OrderData.ordgender, tbl_OrderData.email, tbl_OrderData.zip,
tbl_OrderData.cityid, tbl_OrderData.countryid, tbl_OrderData.companyid, tbl_paymode.name AS paymodename,
tbl_payStatus.name AS payStatusname, tbl_OrderData.invoice
FROM tbl_OrderData INNER JOIN
tbl_Joindata ON tbl_OrderData.ord_code = tbl_Joindata.ord_code INNER JOIN
tbl_article ON tbl_Joindata.Articleid = tbl_article.articleId INNER JOIN
tbl_lesson ON tbl_Joindata.Articleid = tbl_lesson.articleId INNER JOIN
tbl_payStatus ON tbl_OrderData.status = tbl_payStatus.id INNER JOIN
tbl_paymode ON tbl_OrderData.paymode = tbl_paymode.id
WHERE (tbl_OrderData.memberid = @memberid) and tbl_OrderData.status != 0
ORDER BY tbl_OrderData.ord_code DESC ";
NameValueCollection nvc = new NameValueCollection
{
{ "memberid", memberid },
};
DataTable result = DbControl.Data_Get(strsql, nvc);
return(result);
}
public static Mmemberdata Add(string email, string password, string account, string username = "", string phone = "")
{
Mmemberdata result = new Mmemberdata();
if (account == "")
{
account = email;
}
//result = Check_exist(email);
//if (result.Memberid == 0)
//{
string strsql = @"insert into tbl_MemberData ( email,password ,AccountId,phone,username)
values ( @email,@password,@AccountId,@phone ,@username) ";
NameValueCollection nvc = new NameValueCollection
{
{ "email", email },
{ "password", password },
{ "AccountId", account },
{ "username", username },
{ "phone", phone }
};
DbControl.Data_add(strsql, nvc);
result = Login(account, password);
Mail.Join_member(result.Memberid);
// }
return(result);
}
public void selectSQL(string sorttype = "desc", string sortColumn = "memberid")
{
NameValueCollection nvc = new NameValueCollection();
nvc.Add("id", "0");
string strsql = "select * from tbl_memberdata where memberid >@id ";
if (keyword.Text != "")
{
strsql += " and ( username like '%' + @keyword + '%' or email like '%' + @keyword + '%' or phone like '%' + @keyword + '%' )";
nvc.Add("keyword", keyword.Text);
}
if (sortColumn != "")
{
strsql += " ORDER BY " + sortColumn + " " + sorttype;
}
else
{
strsql += " ORDER BY memberid desc ";
}
DataTable dt = DbControl.Data_Get(strsql, nvc);
ListView1.DataSource = dt;
ListView1.DataBind();
}
public static Mmemberdata GetData(string memberid)
{
string strsql = @"select * from tbl_MemberData where
memberid =@memberid ";
NameValueCollection nvc = new NameValueCollection
{
{ "memberid", memberid },
};
DataTable dt = DbControl.Data_Get(strsql, nvc);
Mmemberdata m = new Mmemberdata();
if (dt.Rows.Count > 0)
{
m.AccountId = dt.Rows[0]["AccountId"].ToString();
m.Email = dt.Rows[0]["email"].ToString();
m.Memberid = (int)dt.Rows[0]["memberid"];
m.Phone = dt.Rows[0]["Phone"].ToString();
m.Password = MySecurity.SimpleTripleDes(dt.Rows[0]["Password"].ToString());
m.Username = dt.Rows[0]["Username"].ToString();
m.Address = dt.Rows[0]["Address"].ToString();
m.Zip = dt.Rows[0]["zip"].ToString();
m.Countyid = dt.Rows[0]["Countyid"].ToString() == ""? 0:(int)dt.Rows[0]["Countyid"];
m.Cityid = dt.Rows[0]["Cityid"].ToString() == "" ? 0 : (int)dt.Rows[0]["Cityid"];
m.Password = dt.Rows[0]["password"].ToString();
m.Kind = dt.Rows[0]["Kind"].ToString();
m.Birthday = dt.Rows[0]["Birthday"].ToString() == "" ? DateTime.Parse("1911/1/1") : (DateTime )dt.Rows[0]["Birthday"];
}
return(m);
}
private void waitToBeNextSpeaker()
{
while (!DbControl.getInstance().checkNextSpeaker(simulationId, speaker))
{
Application.DoEvents();
}
}
private void btnWait_Click(object sender, EventArgs e)
{
if (txtDatabase.Text == "")
{
MessageBox.Show("Please, choose a database file before start the simulation.");
btnBrowseDatabase.Focus();
return;
}
//Open connection
//DbControl.getInstance().openConnection();//Now, the connection will be closed only when closed
//Create Simulation
simulationId = DbControl.getInstance().createSimulation(txtUserId.Text);
//Wait for connection
gbDatafile.Visible = false;
btnWait.Visible = false;
gbWait.Visible = true;
btnCancel.Visible = true;
waitToBeNextSpeaker();
//Open FormInteractionSimulation
FormInteractionSimulation formInteractionSimulation = new FormInteractionSimulation();
formInteractionSimulation.setSimulationId(simulationId);
formInteractionSimulation.setSpeaker(speaker);
formInteractionSimulation.setNextSpeaker(nextSpeaker);
formInteractionSimulation.Show();
this.Hide();
}
protected void Page_Init(object sender, EventArgs e)
{
string unitid = Request.QueryString["unitid"];
string strsql = "SELECT * FROM tbl_category_class where unitid =@unitid ";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("unitid", unitid);
DataTable dt = DbControl.Data_Get(strsql, nvc);
classid = dt.Rows[0]["classid"].ToString();
strsql = "SELECT * FROM tbl_category where parentid =0 and classid=@classid ";
nvc.Clear();
nvc.Add("classid", classid);
dt = DbControl.Data_Get(strsql, nvc);
DropDownList2.Items.Add(new ListItem("設為上層", "0"));
DropDownList1.Items.Add(new ListItem("第一層", "0"));
for (int i = 0; i < dt.Rows.Count; i++)
{
DropDownList1.Items.Add(new ListItem(dt.Rows [i]["title"].ToString(), dt.Rows[i]["categoryid"].ToString()));
DropDownList2.Items.Add(new ListItem(dt.Rows[i]["title"].ToString(), dt.Rows[i]["categoryid"].ToString()));
}
dt.Dispose();
}
public void selectSQL(string sorttype = "desc", string sortColumn = "p_id")
{
string strsql = " SELECT * ,(select title from tbl_category where tbl_category.categoryid = tbl_productdata.categoryid) as title from tbl_productdata where status <> 'D' ";
if (search_txt.Text != "")
{
int n;
bool isNumeric = int.TryParse(search_txt.Text, out n);
strsql += @" and (memo like '%'+@S+'%' or productname like '%'+@S+'%' or description like '%'+@S+'%') ";
}
if (DropDownList1.SelectedIndex > 0)
{
strsql += " and categoryid = @categoryid";
}
strsql += " ORDER BY sort," + sortColumn + " " + sorttype;
NameValueCollection nvc = new NameValueCollection();
nvc.Add("S", search_txt.Text);
nvc.Add("categoryid", DropDownList1.SelectedValue);
DataTable dt = DbControl.Data_Get(strsql, nvc);
ListView1.DataSource = dt;
ListView1.DataBind();
dt.Dispose();
MultiView1.ActiveViewIndex = 0;
}
protected void Page_Init(object sender, EventArgs e)
{
//DropDownList1.DataBound += new EventHandler(DropDownList1_DataBound);
DropDownList1.Items.Add(new ListItem("不區分", ""));
string strsql = "select * from tbl_category where parentid =0 and classid=@classid and status<>'D' ";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("classid", "2");
DataTable dt = DbControl.Data_Get(strsql, nvc);
for (int i = 0; i < dt.Rows.Count; i++)
{
string name = dt.Rows[i]["title"].ToString();
string id = dt.Rows[i]["categoryid"].ToString();
categoryid.Items.Add(new ListItem(name, id));
DropDownList1.Items.Add(new ListItem(name, id));
}
dt.Dispose();
categoryid.Items.Insert(0, new ListItem("請選擇", ""));
nvc.Clear();
nvc.Add("classid", "3");
dt = DbControl.Data_Get(strsql, nvc);
for (int i = 0; i < dt.Rows.Count; i++)
{
string name = dt.Rows[i]["title"].ToString();
string id = dt.Rows[i]["categoryid"].ToString();
supplierid.Items.Add(new ListItem(name, id));
}
dt.Dispose();
supplierid.Items.Insert(0, new ListItem("請選擇", ""));
}
/// <summary>
/// Обновление [Выпуска изделий] (dbf izd_rasc)
/// </summary>
public static void Update(RealaseProduct realaseProduct)
{
var dbFolder = Properties.Settings.Default.FoxProDbFolder_Foxpro_Trudnorm;
const string update = "UPDATE [izd_rasc] SET vypusk = ? WHERE detal = ?";
try
{
using (var oleDbConnection = DbControl.GetConnection(dbFolder))
{
oleDbConnection.TryConnectOpen();
using (var oleDbCommand = new OleDbCommand(update, oleDbConnection))
{
oleDbCommand.Parameters.AddWithValue("@vypusk", realaseProduct.Realase);
oleDbCommand.Parameters.AddWithValue("@detal", realaseProduct.CodeDetail);
oleDbCommand.ExecuteNonQuery();
}
}
}
catch (OleDbException ex)
{
throw DbControl.HandleKnownDbFoxProAndMssqlServerExceptions(ex);
}
}
/// <summary>
/// Проверка на дубликат
/// </summary>
public static bool IsDublicate(long productId, long materialId, string workGuildId, string parcelId)
{
const string query = "SELECT * FROM [Nu65DB].[dbo].[Nu65Table] " +
"WHERE [productsId] = @productsId and [materialsId] = @materialsId and " +
"[workGuildId] = @workGuildId and [parcelId] = @parcelId";
var server = Properties.Settings.Default.SqlServerNu65;
var db = Properties.Settings.Default.SqlDbNu65Db;
try
{
using (var connection = DbControl.GetConnection(server, db))
{
connection.TryConnectOpen();
using (var sqlCommand = new SqlCommand(query, connection))
{
sqlCommand.Parameters.AddWithValue("@productsId", productId);
sqlCommand.Parameters.AddWithValue("@materialsId", materialId);
sqlCommand.Parameters.AddWithValue("@workGuildId", workGuildId);
sqlCommand.Parameters.AddWithValue("@parcelId", parcelId);
using (var reader = sqlCommand.ExecuteReader())
{
return(reader.HasRows);
}
}
}
}
catch (SqlException ex)
{
throw DbControl.HandleKnownDbFoxProAndMssqlServerExceptions(ex);
}
}
public async System.Threading.Tasks.Task <object> PostClienteAsync(ClienteViewModel viewModel)
{
try
{
OracleCommand orcCommand = new OracleCommand();
orcCommand.Parameters.add(new OracleParameter("V_CEP", viewModel.CEP));
orcCommand.Parameters.add(new OracleParameter("V_CIDADE", viewModel.Cidade));
orcCommand.Parameters.add(new OracleParameter("V_DATANASCIMENTO", viewModel.DataNascimento));
orcCommand.Parameters.add(new OracleParameter("V_ENDERECO", viewModel.Endereco));
orcCommand.Parameters.add(new OracleParameter("V_ESTADO", viewModel.Estado));
orcCommand.Parameters.add(new OracleParameter("V_NOME", viewModel.Nome));
orcCommand.Parameters.add(new OracleParameter("V_SOBRENOME", viewModel.Sobrenome));
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertCliente,
orcCommand);
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
public static string get_lesson(string kind)
{
string result = "{ \"main\":[";
if (kind == "get")
{
string strsql = "SELECT * FROM tbl_Lesson where status='Y' ";
NameValueCollection nvc = new NameValueCollection();
DataTable dt = DbControl.Data_Get(strsql, nvc);
//result = JsonConvert.SerializeObject(dt);
int i = 0;
for (i = 0; i < dt.Rows.Count; i++)
{
if (i != 0)
{
result += ",";
}
result += "{\"name\":\"" + dt.Rows[i]["subject"].ToString() + "\",\"id\":\"" + dt.Rows[i]["lessonid"].ToString() + "\"}";
}
dt.Dispose();
}
result += "]}";
return(result);
}
public static string Is_collection(string memberid, string articleId)
{
string result = "";
string strsql = @"select * from tbl_articleCollection where articleId =@articleId
and memberid =@memberid";
NameValueCollection nvc = new NameValueCollection
{
{ "memberid", memberid },
{ "articleId", articleId }
};
DataTable dt = DbControl.Data_Get(strsql, nvc);
if (dt.Rows.Count == 0)
{
result = "";
}
else
{
result = "Y";
}
dt.Dispose();
return(result);
}
public static string Set_active(string unitid, string thisid)
{
string msg = "";
if (thisid == unitid)
{
msg = "class=\"active\"";
}
if (thisid != null)
{
string strsql = "select * from unitdata where unitid=" + thisid;
NameValueCollection nvc = new NameValueCollection();
DataTable dt = DbControl.Data_Get(strsql, nvc);
if (dt.Rows.Count > 0)
{
if (dt.Rows [0]["upperid"].ToString() == unitid)
{
msg = "class=\"active open\"";
}
}
dt.Dispose();
nvc.Clear();
}
return(msg);
}
public static Mmemberdata Update(Mmemberdata m)
{
string strsql = @"update tbl_MemberData set email=@email,
username=@username
,phone=@phone
,mobile=@mobile
,cityid=@cityid
,countyid=@countyid
,zip=@zip,birthday=@birthday
,address=@address,password=@password where memberid=@memberid";
NameValueCollection nvc = new NameValueCollection
{
{ "username", m.Username },
{ "email", m.Email },
{ "phone", m.Phone },
{ "mobile", m.Mobile },
{ "cityid", m.Cityid.ToString() },
{ "countyid", m.Countyid.ToString() },
{ "zip", m.Zip },
{ "address", m.Address },
{ "birthday", m.Birthday.ToString("yyyy/MM/dd") },
{ "password", m.Password },
{ "memberid", m.Memberid.ToString() }
};
DbControl.Data_add(strsql, nvc);
return(m);
}
public static object Tbl_article_tag(int id, string kind = "dt")
{
NameValueCollection nvc = new NameValueCollection();
string strsql = @"select tbl_article_tag.articleId, tbl_article_tag.tagid, tbl_article_tag.unitid,
tbl_tag.tagname, tbl_tag.pic, tbl_tag.contents, tbl_tag.title
FROM tbl_article_tag INNER JOIN tbl_tag ON tbl_article_tag.tagid = tbl_tag.tagid
where tbl_article_tag.articleId=@id ";
nvc.Add("id", id.ToString());
DataTable dt = DbControl.Data_Get(strsql, nvc);
{
if (kind == "dt")
{
return(dt);
}
else
{
List <article.Lecturer> Lecture = new List <article.Lecturer>();
int i = 0;
for (i = 0; i < dt.Rows.Count; i++)
{
Lecture.Add(new article.Lecturer
{
Id = (int)dt.Rows[i]["tagid"],
Title = (string)dt.Rows[i][" Title"],
Subject = (string)dt.Rows[i]["tagname"],
Contents = (string)dt.Rows[i]["Contents"],
Pic = (string)dt.Rows[i]["Contents"]
});
}
dt.Dispose();
return(Lecture);
}
}
}
protected void link_edit(object sender, System.EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
LinkButton obj = sender as LinkButton;
Selected_id.Value = obj.CommandArgument;
o = OrderLib.Get_ordData(Selected_id.Value);
payStatus.SelectedValue = o.Status;
MultiView1.ActiveViewIndex = 1;
LessonLib.JoinData l = LessonLib.Web.Get_ord_JoinData(o.Ord_code);
joindata.Visible = false;
companyno.Text = o.Companyno;
title.Text = o.Title;
Repeater1.DataSource = o.OrderDetail;
Repeater1.DataBind();
if (l.JoinDetail != null)
{
joindata.Visible = true;
Lstatus.SelectedValue = l.JoinDetail[0].Status;
}
paymode.SelectedValue = o.Paymode;
Btn_save.CommandArgument = "edit";
string strsql = "select * from Log_Sms where ord_code=@ord_code";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("ord_code", Selected_id.Value);
DataTable dt = DbControl.Data_Get(strsql, nvc);
Repeater2.DataSource = dt;
Repeater2.DataBind();
}
public static article.LessonDetail Get_LessonClass(int id)
{
NameValueCollection nvc = new NameValueCollection();
string strsql = "select * from tbl_lesson_class ";
strsql += "where lessonId =@id";
nvc.Add("id", id.ToString());
DataTable dt = DbControl.Data_Get(strsql, nvc);
article.LessonDetail MainData = new article.LessonDetail();
int i = 0;
for (i = 0; i < dt.Rows.Count; i++)
{
MainData.Id = (int)dt.Rows[i]["articleId"];
MainData.Price = (int)dt.Rows[i]["Price"];
MainData.Description = (string)dt.Rows[i]["description"];
MainData.Sellprice = (int)dt.Rows[i]["Sellprice"];
MainData.Limitnum = (int)dt.Rows[i]["limitnum"];
MainData.LessonId = (int)dt.Rows[i]["lessonId"];
}
dt.Dispose();
return(MainData);
}
protected void btn_del_Click(object sender, System.EventArgs e)
{
string strsql = "delete from tbl_banner where bannerid = @id";
int i = DbControl.Data_delete(strsql, Selected_id.Value);
ListView1.DataBind();
}
public static object Get_lecturer(string kind = "dt")
{
NameValueCollection nvc = new NameValueCollection();
string strsql = "select * from tbl_tag where unitid=14 ";
DataTable dt = DbControl.Data_Get(strsql, nvc);
if (kind == "dt")
{
dt.Dispose();
return(dt);
}
else
{
List <article.Lecturer> Lecture = new List <article.Lecturer>();
int i = 0;
for (i = 0; i < dt.Rows.Count; i++)
{
Lecture.Add(new article.Lecturer
{
Id = (int)dt.Rows[i]["tagid"],
Subject = (string)dt.Rows[i]["tagname"],
Contents = (string)dt.Rows[i]["Contents"],
Pic = (string)dt.Rows[i]["Contents"]
});
}
dt.Dispose();
return(Lecture);
}
}
public async System.Threading.Tasks.Task <object> PostReclamacaoAsync(ReclamacaoInstalacaoViewModel viewModel)
{
try
{
OracleCommand orcCommand = new OracleCommand();
orcCommand.Parameters.add(new OracleParameter("V_CODIGOCLIENTE", viewModel.CodigoCliente));
orcCommand.Parameters.add(new OracleParameter("V_CODIGOINSTALACAO", viewModel.CodigoInstalacao));
orcCommand.Parameters.add(new OracleParameter("V_CODIGOREGIAO", viewModel.CodigoRegiao));
orcCommand.Parameters.add(new OracleParameter("V_DATACADASTRO", viewModel.DataCadastro));
orcCommand.Parameters.add(new OracleParameter("V_DESCRICAOOPCIONAL", viewModel.DescricaoOpcional));
orcCommand.Parameters.add(new OracleParameter("V_STATUS", viewModel.Status));
var result = await DbControl.ExecuteProcWithReturnAsync(
StoredProcedure.InsertReclamacaoInstalacao,
orcCommand);
return(result);
}
catch (Exception x)
{
//TODO: Adicionar log para Exception
return(new HttpResponseMessage(System.Net.HttpStatusCode.ExpectationFailed));
}
}
void deleteBrickImage(string now_id)
{
foreach (RepeaterItem item in Repeater_image.Items)
{
CheckBox chk = (CheckBox)(item.FindControl("chk_del"));
HiddenField imgid = (HiddenField)(item.FindControl("img_id"));
if (chk.Checked)
{
string strsql = "delete from tbl_article_file where imgid=@imgid ";
NameValueCollection nvc = new NameValueCollection();
nvc.Clear();
nvc.Add("imgid", imgid.Value);
int i = DbControl.Data_add(strsql, nvc);
}
}
foreach (RepeaterItem item in Repeater_file.Items)
{
CheckBox chk = (CheckBox)(item.FindControl("chk_del"));
HiddenField imgid = (HiddenField)(item.FindControl("file_id"));
if (chk.Checked)
{
string strsql = "delete from tbl_article_file where imgid=@imgid ";
NameValueCollection nvc = new NameValueCollection();
nvc.Clear();
nvc.Add("imgid", imgid.Value);
int i = DbControl.Data_add(strsql, nvc);
}
}
}
/// <summary>
/// Установление признака детали в бд
/// </summary>
public static void UpdateIsCalculate(bool isCalculate, DetailCalculate detailCalculate)
{
var dbFolder = Properties.Settings.Default.FoxProDbFolder_Foxpro_Trudnorm;
const string update = "UPDATE [izd_rasc] SET pr_rasc = ? WHERE detal = ?";
try
{
using (var oleDbConnection = DbControl.GetConnection(dbFolder))
{
oleDbConnection.TryConnectOpen();
using (var oleDbCommand = new OleDbCommand(update, oleDbConnection))
{
oleDbCommand.Parameters.AddWithValue("@pr_rasc", isCalculate ? "+" : "");
oleDbCommand.Parameters.AddWithValue("@detal", detailCalculate.CodeDetail);
oleDbCommand.ExecuteNonQuery();
}
}
}
catch (OleDbException ex)
{
throw DbControl.HandleKnownDbFoxProAndMssqlServerExceptions(ex);
}
}
public void selectSQL()
{
string strsql = "select* from tbl_article_file where status <> 'D' and (articleid =@articleid or tempid=@articleId) and kind='P' order by sort";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("articleid", Session["uploadid"].ToString());
DataTable dt = DbControl.Data_Get(strsql, nvc);
Repeater_image.DataSource = dt;
if (Request.QueryString ["type"] == "image")
{
Repeater_image.DataBind();
}
dt.Dispose();
strsql = "select* from tbl_article_file where status <> 'D' and (articleid =@articleid or tempid=@articleId) and kind='F' order by sort";
dt = DbControl.Data_Get(strsql, nvc);
Repeater_file.DataSource = dt;
if (Request.QueryString["type"] == "file")
{
Repeater_file.DataBind();
}
;
dt.Dispose();
nvc.Clear();
}
//編輯
protected void link_edit(object sender, System.EventArgs e)
{
LinkButton obj = sender as LinkButton;
Selected_id.Value = obj.CommandArgument;
MultiView1.ActiveViewIndex = 1;
Btn_save.CommandArgument = "edit";
string strsql = "select * from tbl_banner where bannerid=@bannerid";
NameValueCollection nvc = new NameValueCollection();
nvc.Add("bannerid", Selected_id.Value);
DataTable dt = DbControl.Data_Get(strsql, nvc);
t_title.Text = dt.Rows[0]["title"].ToString();
t_url.Text = dt.Rows[0]["url"].ToString();
t_sort.Text = dt.Rows[0]["sort"].ToString();
t_status.SelectedValue = dt.Rows[0]["status"].ToString();
t_targetblank.Text = dt.Rows[0]["targetblank"].ToString();
sdate.Text = DateTime.Parse(dt.Rows[0]["enabledate"].ToString()).ToString("yyyy/MM/dd");
stime.SelectedValue = DateTime.Parse(dt.Rows[0]["enabledate"].ToString()).Hour.ToString();
Literal1.Text = "<img src=\"../webimages/banner/" + dt.Rows[0]["filename"].ToString() + "\" height =\"200\"/>";
HiddenField1.Value = dt.Rows[0]["filename"].ToString();
contents.Text = dt.Rows[0]["contents"].ToString();
DropDownList2.SelectedIndex =
DropDownList2.Items.IndexOf(DropDownList2.Items.FindByValue(dt.Rows[0]["categoryid"].ToString()));
DropDownList3.SelectedIndex =
DropDownList3.Items.IndexOf(DropDownList3.Items.FindByValue(dt.Rows[0]["articleId"].ToString()));
articleId = dt.Rows[0]["articleId"].ToString();
if (dt.Rows[0]["disabledate"].ToString() != "")
{
DateTime ee = DateTime.Parse(dt.Rows[0]["disabledate"].ToString());
edate.Text = ee.ToString("yyyy/MM/dd");
etime.SelectedValue = ee.Hour.ToString();
}
else
{
edate.Text = "";
}
dt.Dispose();
strsql = "select * from tbl_recommend where bannerid=@bannerid";
dt = DbControl.Data_Get(strsql, nvc);
for (int i = 0; i < dt.Rows.Count; i++)
{
foreach (ListItem li in classid.Items)
{
if (dt.Rows [i]["classid"].ToString() == li.Value)
{
li.Selected = true;
}
}
}
dt.Dispose();
}
private void Page_Load(object sender, System.EventArgs e)
{
cnString = ConfigurationSettings.AppSettings["connectionstring"].ToString();
Response.Cache.SetCacheability(System.Web.HttpCacheability.NoCache);
/* List<string> list1 = new List<string>();
string ll = getHours("trtd16:00,1:00/td td width=\"20\"/tdtd class=\"w2b\"â/td/trtrtd20:30/td td width=\"20\"/tdtd class=\"w2b\"ã/td/trtrtd/td td width=\"20\"/tdtd class=\"w2b\"/td/tr".Replace(">", "").Replace("<", ""),
list1);
Response.Write("Count:" + list1.Count+" ");
ll = getHours(ll, list1);
Response.Write("Count:" + list1.Count + " ");
List<string> list2 = new List<string>();
ll = getHours(ll, list2);
Response.Write("Count:" + list2.Count + " ");
return;
*/
string page = readPage1("http://movies.walla.co.il");
//string filterArr[] = page.Split('dropdown_selection'); // all code before dropdown_selection is unneeded
string[] pageLines = page.Split('\n');
DbControl dbControl = new DbControl();
foreach (string line in pageLines)
{
string strToFind = "onclick=\"location.href='/movie/";
int index = line.IndexOf(strToFind);
string movieId;
if (index > 0)
{
movieId = line.Substring(index + strToFind.Length, 4);
Match movieIdMatch = Regex.Match(movieId, "[0-9]*", RegexOptions.IgnoreCase);
movieId = movieIdMatch.Value;
string movieUrl = line.Substring(line.IndexOf(strToFind) + strToFind.Length);
movieUrl = movieUrl.Substring(0, movieUrl.IndexOf("';"));
string moviePage = readPage1("http://movies.walla.co.il/movie/" + movieUrl);
string hebrewName = getStringInBetween(moviePage, "class=\"right block\">", "</span>");
string englishName = getStringInBetween(moviePage, "class=\"left block\">", "</span>");
if (dbControl.hasMovie(movieId) == true)
continue;
Response.Write("<BR>" + "movie:" + movieId + "<BR>");
Match imageMatch = Regex.Match(line, "http://msc.wcdn.co.il/archive/[0-9-]*.jpg", RegexOptions.IgnoreCase);
string movieIcon = "";
if (imageMatch.Success)
{
movieIcon = imageMatch.Value;
Response.Write(movieIcon + "<BR>");
}
dbControl.addMovie(movieId, hebrewName, englishName, movieIcon);
string findCinemasUrl = @"http://movies.walla.co.il/?w=/@ajax.movie.projections&movie_id=" + movieId;
//http://movies.walla.co.il/?w=/@ajax.movie.projection.time&movie_id=4673&cinema_id=38
string cinemasPage = readPage1(findCinemasUrl);
string[] cinemasPageLines = cinemasPage.Split('\n');
List<string> cinemasList = new List<string>();
List<string> cinemasIdList = new List<string>();
foreach (string cinemasLine in cinemasPageLines)
{
string cinemasLineStrip = cinemasLine.ToLower();
strToFind = "\"w3b\"";
int indexStart = cinemasLineStrip.IndexOf(strToFind);
int indexEnd = cinemasLineStrip.IndexOf("</a>");
string cinemaLineSuf;
if (indexEnd > 0)
{
cinemaLineSuf = cinemasLineStrip.Substring(indexStart + strToFind.Length, indexEnd - (indexStart + strToFind.Length));
//MatchCollection matches = Regex.Matches("[a-zA-Z0-9]*", cinemasLineStrip, RegexOptions.IgnoreCase);
MatchCollection matches = Regex.Matches(cinemaLineSuf, "[a-zà-ú\\- ]*", RegexOptions.IgnoreCase);
if (indexStart > 0 && indexEnd > 0)
{
foreach (Match match1 in matches)
{
string cinema = match1.Value;
if (cinema.Length > 1)
{
cinemasList.Add(cinema);
Response.Write(cinema);
}
}
}
}
strToFind = "/?w=/";
indexStart = cinemasLineStrip.IndexOf(strToFind);
indexEnd = cinemasLineStrip.IndexOf("/@cinema");
if (indexStart > 0 && indexEnd > 0)
{
string cinemaId = cinemasLineStrip.Substring(indexStart + strToFind.Length, indexEnd - (indexStart + strToFind.Length));
cinemasIdList.Add(cinemaId);
Response.Write(cinemaId + "<BR>");
string timesPage = readPage1(@"http://movies.walla.co.il/?w=/@ajax.movie.projection.time&movie_id=" + movieId + "&cinema_id=" + cinemaId);
//Response.Write(timesPage+"<BR>");
string[] timesPageLines = timesPage.Split(new string[] { "</tr>" }, StringSplitOptions.RemoveEmptyEntries);
List<DateTime> dates = new List<DateTime>();
foreach (string timesLine in timesPageLines)
{
if (timesLine.Replace("<BR>", "").Replace(">", "").Replace("<", "").Replace(" ", "").Length < 4)
continue;
GetTimesAndDays(timesLine, dates);
}
if (dates != null && dates.Count > 0)
dbControl.addMovieTimes(Int32.Parse(movieId), dates, Int32.Parse(cinemaId));
}
}
}
strToFind = "</span>";
index = line.IndexOf(strToFind);
Match match = Regex.Match(line, "[à-ú]");
if (line.Replace("\t", "").Replace(" ", "").StartsWith(strToFind) && match.Success && index > 0 && line.Length > index + strToFind.Length)
{
string name = line.Substring(index + strToFind.Length, line.Length - (index + strToFind.Length));
// Response.Write(name + "<BR>");
// Response.Write("found: " + line.Replace("<","") + "<br>");
}
}
}
