protected void Button4_Click(object sender, EventArgs e) { string strSrch = TextBox1.Text; string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch); OdbcConnection connection = new OdbcConnection(ConTecdoc); connection.ConnectionTimeout = 600; connection.Open(); OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT TOF_ARTICLES.ART_ID, TOF_ARTICLES.ART_ARTICLE_NR, TOF_DES_TEXTS.TEX_TEXT, TOF_ARTICLE_CRITERIA.ACR_VALUE FROM TOF_ARTICLES LEFT OUTER JOIN TOF_ARTICLE_CRITERIA ON (TOF_ARTICLES.ART_ID = TOF_ARTICLE_CRITERIA.ACR_ART_ID) INNER JOIN TOF_CRITERIA ON (TOF_ARTICLE_CRITERIA.ACR_CRI_ID = TOF_CRITERIA.CRI_ID) INNER JOIN TOF_DESIGNATIONS ON (TOF_CRITERIA.CRI_DES_ID = TOF_DESIGNATIONS.DES_ID) INNER JOIN TOF_DES_TEXTS ON (TOF_DESIGNATIONS.DES_TEX_ID = TOF_DES_TEXTS.TEX_ID) WHERE TOF_ARTICLES.ART_ID = 4325174 AND TOF_CRITERIA.CRI_TYPE IN ('A','B','D','N') AND TOF_DESIGNATIONS.DES_LNG_ID = 16", connection); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }
protected void Button2_Click(object sender, EventArgs e) { string txt1 = TextBox1.Text; string strRepl = RemoveElementsFrom.RmvSomeElements(txt1); if (!string.IsNullOrEmpty(strRepl)) { OdbcConnection conn_tec = new OdbcConnection(ConTecdoc); OdbcDataAdapter da_arls = new OdbcDataAdapter(@"SELECT * FROM TOF_ART_LOOKUP ARL INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID) LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID) INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID) INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID) WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '4' OR ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "' ", conn_tec); DataTable dt_arls = new DataTable(); da_arls.Fill(dt_arls); GridView2.DataSource = dt_arls; GridView2.DataBind(); if (dt_arls.Rows.Count < 1) { img_btn_Kia.Visible = true; } else { img_btn_Kia.Visible = false; } } }
protected void TextBox2_TextChanged(object sender, EventArgs e) { string strSrch = TextBox2.Text; string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch); OdbcConnection connection = new OdbcConnection(ConTecdoc); connection.ConnectionTimeout = 600; connection.Open(); OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT TOF_ART_LOOKUP.ARL_SEARCH_NUMBER, TOF_ART_LOOKUP.ARL_KIND, TOF_ART_LOOKUP.ARL_ART_ID, TOF_ART_LOOKUP.ARL_DISPLAY_NR, TOF_ARTICLES.ART_SUP_ID, TOF_SUPPLIERS.SUP_BRAND, TOF_DES_TEXTS.TEX_TEXT AS ART_COMPLETE_DES_TEXT FROM TOF_ART_LOOKUP LEFT JOIN TOF_BRANDS ON TOF_BRANDS.BRA_ID = TOF_ART_LOOKUP.ARL_BRA_ID INNER JOIN TOF_ARTICLES ON TOF_ARTICLES.ART_ID = TOF_ART_LOOKUP.ARL_ART_ID INNER JOIN TOF_SUPPLIERS ON TOF_SUPPLIERS.SUP_ID = TOF_ARTICLES.ART_SUP_ID INNER JOIN TOF_DESIGNATIONS ON TOF_DESIGNATIONS.DES_ID = TOF_ARTICLES.ART_COMPLETE_DES_ID INNER JOIN TOF_DES_TEXTS ON TOF_DES_TEXTS.TEX_ID = TOF_DESIGNATIONS.DES_TEX_ID WHERE TOF_DESIGNATIONS.DES_LNG_ID = 16 AND (TOF_ART_LOOKUP.ARL_KIND = '1' ) AND TOF_ART_LOOKUP.ARL_ART_ID = 177531", connection); DataTable dt = new DataTable(); da.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); // Response.Write("<SCRIPT language='JavaScript'> alert('"+ TextBox2.Text +"') </SCRIPT>"); }
protected void Replace_ImgBtn_Click(object sender, ImageClickEventArgs e) { ImageButton ReplaceImgBtn = (ImageButton)sender; GridViewRow GrdViewRow = (GridViewRow)ReplaceImgBtn.NamingContainer; string strSrch = GrdViewRow.Cells[4].Text; string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch); OdbcConnection connection = new OdbcConnection(ConTecdoc); connection.ConnectionTimeout = 600; connection.Open(); OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT * FROM TOF_ART_LOOKUP ARL INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID) LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID) INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID) INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID) WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '4' OR ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "'", connection); DataTable dt = new DataTable(); da.Fill(dt); GRD_Replacement.DataSource = dt; GRD_Replacement.DataBind(); if (dt.Rows.Count > 0) { ShowReplacement_popupextender.Show(); } else { Response.Write("<SCRIPT language='JavaScript'> alert('შემცვლელის მოძებნა ვერ მოხერხდა !!!') </SCRIPT>"); } }
protected void Generate_WB_Num() { string tmp_wbn = string.Empty; string tmp_wbn_converted = string.Empty; tmp_wbn = DateTime.Now.ToString(); tmp_wbn_converted = RemoveElementsFrom.RmvSomeElements(tmp_wbn); WaybillNumber_inputID.Value = tmp_wbn_converted.Replace("PM", "").Replace("AM", ""); // waybill number }
protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { ImageButton ReplaceImgBtn2 = (ImageButton)sender; GridViewRow GrdViewRow2 = (GridViewRow)ReplaceImgBtn2.NamingContainer; string strArtBrand2 = GrdViewRow2.Cells[3].Text; string strArtNum2 = RemoveElementsFrom.RmvSomeElements(GrdViewRow2.Cells[4].Text); //Response.Write("<SCRIPT language='JavaScript'> alert('"+ strArtNum.ToString()+"') </SCRIPT>"); Response.Redirect("http://vedro.pro/search/?pcode=" + strArtNum2 + " "); }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e) { ImageButton ReplaceImgBtn = (ImageButton)sender; GridViewRow GrdViewRow = (GridViewRow)ReplaceImgBtn.NamingContainer; string strArtBrand = GrdViewRow.Cells[3].Text; string strArtNum = RemoveElementsFrom.RmvSomeElements(GrdViewRow.Cells[4].Text); //Response.Write("<SCRIPT language='JavaScript'> alert('"+ strArtNum.ToString()+"') </SCRIPT>"); Response.Redirect("http://old.tegetamotors.ge/ka/products/act/partsGetResultsByCode2/?make=&makeName=&model=&modelName=&typ=&typName=&pcat=" + strArtNum + "&pcatName=&brand=" + strArtBrand + ""); // Response.Write("<a href='tegetamotors.ge/ka/products/act/partsGetResultsByCode2/?make=&makeName=&model=&modelName=&typ=&typName=&pcat=" + strArtNum + "&pcatName=&brand=" + strArtBrand + "'></a>"); }
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { GridView gvParts = e.Row.FindControl("GridView2") as GridView; // Retrieve the underlying data item. In this example // the underlying data item is a DataRowView object. DataRowView rowView = (DataRowView)e.Row.DataItem; // Retrieve the key value for the current row. Here it is an int. string myDataKey = rowView["ARL_DISPLAY_NR"].ToString(); string Art_Num = RemoveElementsFrom.RmvSomeElements(myDataKey); // ... do more work ... OdbcConnection connection = new OdbcConnection(ConTecdoc); connection.ConnectionTimeout = 600; connection.Open(); OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT * FROM TOF_ART_LOOKUP ARL INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID) LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID) INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID) INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID) WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + Art_Num + "' FIRST(1)", connection); DataTable dt = new DataTable(); da.Fill(dt); gvParts.DataSource = dt; gvParts.DataBind(); } }
protected void Query_InTecdoc_Click(object sender, ImageClickEventArgs e) { string strSrch = txt_editgoodsCode.Text; string strRepl = RemoveElementsFrom.RmvSomeElements(strSrch); OdbcConnection connection = new OdbcConnection(ConTecdoc); connection.ConnectionTimeout = 600; connection.Open(); OdbcDataAdapter da = new OdbcDataAdapter(@"SELECT TOF_ART_LOOKUP.ARL_SEARCH_NUMBER, TOF_ART_LOOKUP.ARL_KIND, TOF_ART_LOOKUP.ARL_ART_ID, TOF_ART_LOOKUP.ARL_DISPLAY_NR, TOF_ARTICLES.ART_SUP_ID, TOF_SUPPLIERS.SUP_BRAND, TOF_DES_TEXTS.TEX_TEXT AS ART_COMPLETE_DES_TEXT FROM TOF_ART_LOOKUP LEFT JOIN TOF_BRANDS ON TOF_BRANDS.BRA_ID = TOF_ART_LOOKUP.ARL_BRA_ID INNER JOIN TOF_ARTICLES ON TOF_ARTICLES.ART_ID = TOF_ART_LOOKUP.ARL_ART_ID INNER JOIN TOF_SUPPLIERS ON TOF_SUPPLIERS.SUP_ID = TOF_ARTICLES.ART_SUP_ID INNER JOIN TOF_DESIGNATIONS ON TOF_DESIGNATIONS.DES_ID = TOF_ARTICLES.ART_COMPLETE_DES_ID INNER JOIN TOF_DES_TEXTS ON TOF_DES_TEXTS.TEX_ID = TOF_DESIGNATIONS.DES_TEX_ID WHERE TOF_DESIGNATIONS.DES_LNG_ID = 16 AND (TOF_ART_LOOKUP.ARL_KIND = '1') AND TOF_ART_LOOKUP.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "'", connection); DataTable dt = new DataTable(); da.Fill(dt); for (int i = 0; i < dt.Rows.Count; i++) { string Brand_Name = dt.Rows[i]["SUP_BRAND"].ToString(); string Category_Name = dt.Rows[i]["ART_COMPLETE_DES_TEXT"].ToString(); txt_edit_Brand_Manufacturer.Text = Brand_Name.ToString(); txt_editgoodsCategory.Text = Category_Name; } edt_mod_popupextender.Show(); }
private void test1() { string txt1 = TextBox1.Text; string strRepl = RemoveElementsFrom.RmvSomeElements(txt1); OdbcConnection connection = new OdbcConnection(ConTecdoc); OdbcDataAdapter da2 = new OdbcDataAdapter(@"SELECT * FROM TOF_ART_LOOKUP ARL INNER JOIN TOF_ARTICLES ART ON (ART.ART_ID = ARL.ARL_ART_ID) LEFT OUTER JOIN TOF_SUPPLIERS SUP ON (SUP.SUP_ID = ART.ART_SUP_ID) INNER JOIN TOF_DESIGNATIONS DES ON (DES.DES_ID = ART.ART_COMPLETE_DES_ID) INNER JOIN TOF_DES_TEXTS TEX ON (DES.DES_TEX_ID = TEX.TEX_ID) WHERE DES.DES_LNG_ID = 16 AND (ARL.ARL_KIND = '4' OR ARL.ARL_KIND = '3') AND ARL.ARL_SEARCH_NUMBER = '" + strRepl.ToUpper() + "' ", connection); DataTable dt2 = new DataTable(); da2.Fill(dt2); for (int i = 0; i < dt2.Rows.Count; i++) { var StringValue = dt2.Rows[i]["ART_ARTICLE_NR"].ToString(); var StringText = dt2.Rows[i]["ARL_SEARCH_NUMBER"].ToString(); var StringBrand = dt2.Rows[i]["SUP_BRAND"].ToString(); var StringCategory = dt2.Rows[i]["TEX_TEXT"].ToString(); con.Open(); string str = @" INSERT INTO tmpTable (name, brand, category) VALUES ('" + StringValue + "', '" + StringBrand + "', N'" + StringCategory + "')"; SqlCommand cmd = new SqlCommand(str, con); int insNum = cmd.ExecuteNonQuery(); if (insNum == 0) { Response.Write("<script type='text/javascript'>alert(' არ დამატებულა!')</script>"); } SqlCommand command = new SqlCommand(@"select * from (select Id, name as Gname, price, product_code, description from goods) T1 INNER JOIN (select * from tmpTable) T2 ON(T2.name = T1.product_code OR T2.name = T1.Gname OR T2.name = T1.description)", con); SqlDataReader dr = command.ExecuteReader(); DataTable dt = new DataTable(); dt.Load(dr); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); } else if (dt.Rows.Count == 0) { SqlCommand command1 = new SqlCommand(@"select brand, name, name AS Gname, category, REPLACE(brand, brand, N'შეკვეთით' ) price from tmpTable order by brand", con); SqlDataReader dtr = command1.ExecuteReader(); DataTable dt_t = new DataTable(); dt_t.Load(dtr); GridView1.DataSource = dt_t; GridView1.DataBind(); } // string strdel = "DELETE from tmpTable "; // SqlCommand strCmd1 = new SqlCommand(strdel, con); con.Close(); // Response.Write("<script type='text/javascript'>alert('"+ArtNum+"-"+ArtBrand+"')</script>"); } }