private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { // strCombo = funs.GetStrCombo("*"); strCombo = funs.GetStrComboled("*"); textBox1.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); LoadData(funs.Select_ac_id(textBox1.Text).ToString(), gtyp); }
private void textBox14_KeyPress(object sender, KeyPressEventArgs e) { string strCombo = ""; if ((gtype == "Purchase" || gtype == "P Return" || gtype == "receive" || gtype == "RCM" || gtype == "Sale Order" || gtype == "JReceive")) { //multiloc // strCombo = funs.GetStrCombonew(" (Path LIKE '1;39;%') OR (Path LIKE '1;38;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;40;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '8;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " HAVING Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote+" and Branch_id="+Database.BranchId); strCombo = funs.GetStrCombonew(" (Path LIKE '1;39;%') OR (Path LIKE '1;38;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;40;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '8;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " HAVING Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote); } else if ((gtype == "Sale" || gtype == "Return" || gtype == "issue" || gtype == "PWDebitNote" || gtype == "JIssue")) { //multiloc //strCombo = funs.GetStrCombonew(" (Path LIKE '8;40;%') OR (Path LIKE '8;39;%') OR (Path LIKE '1;3;%') or (Path LIKE '1;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '1;38;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " HAVING Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id=" + Database.BranchId); // strCombo = funs.GetStrCombonew(" (Path LIKE '8;40;%') OR (Path LIKE '8;39;%') OR (Path LIKE '1;3;%') or (Path LIKE '1;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '1;38;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " HAVING Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote); strCombo = funs.GetStrCombonew(" (Path LIKE '1;39;%') or (Path LIKE '1;38;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;40;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '8;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id='" + Database.BranchId + "' "); } textBox14.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); if (textBox14.Text != "") { textBox6.Text = funs.Select_TIN(textBox14.Text); } else { textBox6.Text = ""; } }
private void textBox4_KeyPress(object sender, KeyPressEventArgs e) { Database.OpenConnection(); strCombo = "SELECT distinct FIRMINFO.Firm_Period_name FROM FIRMINFO where FIRMINFO.Firm_name='" + textBox3.Text + "' order by FIRMINFO.Firm_Period_name desc"; textBox4.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); Database.CloseConnection(); }
private void textBox3_KeyPress(object sender, KeyPressEventArgs e) { Database.OpenConnection(); strCombo = "SELECT distinct FIRMINFO.Firm_name FROM Firminfo order by FIRMINFO.Firm_name"; textBox3.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); Database.CloseConnection(); }
private void textBox30_KeyPress(object sender, KeyPressEventArgs e) { string wheresrt = "(Path LIKE '10;%') OR (Path LIKE '9;%') or (Path LIKE '6;%') or (Path LIKE '37;%')"; // strCombo = funs.GetStrCombo(wheresrt); strCombo = funs.GetStrCombonew(wheresrt, "1=1"); textBox30.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox7_KeyPress(object sender, KeyPressEventArgs e) { string strCombo = ""; strCombo = "select Sname As State from State order by Sname"; textBox7.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox14_KeyPress(object sender, KeyPressEventArgs e) { sql = funs.GetStrCombo("in(4,5,23,3,13,22,11,20,5)"); textBox14.Text = SelectCombo.ComboKeypress(this, e.KeyChar, sql, e.KeyChar.ToString(), 1); if (textBox1.Text == "") { textBox1.Text = textBox14.Text; } }
private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { string strCombo = ""; strCombo = "SELECT Name AS VoucherName FROM Vouchertype where " + Database.BMode + "='true' And active=" + access_sql.Singlequote + "True" + access_sql.Singlequote; char cg = ' '; textBox1.Text = SelectCombo.ComboKeypress(this, cg, strCombo, "", 0); }
private void textBox2_KeyPress(object sender, KeyPressEventArgs e) { if (textBox5.Text != "") { strCombo = "SELECT DISTINCT Pack as Packing FROM Description WHERE Description = '" + textBox5.Text + "' ORDER BY Pack"; } else { strCombo = "SELECT DISTINCT Pack as Packing FROM Description ORDER BY Packing"; } textBox2.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox5_KeyPress(object sender, KeyPressEventArgs e) { if (textBox2.Text != "") { strCombo = "SELECT DISTINCT Description as name FROM Description WHERE Pack = '" + textBox2.Text + "' ORDER BY Description"; } else { strCombo = "select distinct Description as name from Description order by Description"; } textBox5.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); }
private void ansGridView1_KeyPress(object sender, KeyPressEventArgs e) { if (char.IsLetter(e.KeyChar) || char.IsNumber(e.KeyChar) || e.KeyChar == ' ') { String ActiveCell = ""; if (ansGridView1.CurrentCell.OwningColumn.Name == "Pack") { ActiveCell = "Packing"; } else if (ansGridView1.CurrentCell.OwningColumn.Name == "Description") { ActiveCell = "Desc"; } if (ActiveCell == "Desc" && (ansGridView1.CurrentCell.OwningRow.Cells["pack"].Value == null || ansGridView1.CurrentCell.OwningRow.Cells["pack"].Value == "")) { strCombo = "select distinct(description) from description order by description"; ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); ansGridView1.CurrentCell = ansGridView1["Pack", ansGridView1.CurrentCell.RowIndex]; if (ansGridView1.CurrentCell.Value != "") { DataTable dt = new DataTable("Description"); Database.GetSqlData("select pack from Description where description='" + ansGridView1.CurrentCell.OwningRow.Cells["Description"].Value + "' order by Description", dt); if (dt.Rows.Count == 1) { ansGridView1.Rows[ansGridView1.CurrentCell.RowIndex].Cells["pack"].Value = dt.Rows[0][0].ToString(); ansGridView1.CurrentCell = ansGridView1["Qty", ansGridView1.CurrentCell.RowIndex]; } } } else if (ActiveCell == "Packing" && ansGridView1.CurrentCell.OwningRow.Cells["Description"].Value != null && ansGridView1.CurrentCell.OwningRow.Cells["Description"].Value.ToString() != "") { strCombo = "select pack from Description where description='" + ansGridView1.CurrentCell.OwningRow.Cells["Description"].Value + "' order by Description"; ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); ansGridView1.CurrentCell = ansGridView1["Qty", ansGridView1.CurrentCell.RowIndex]; } else if (ActiveCell == "Desc" && ansGridView1.CurrentCell.OwningRow.Cells["pack"].Value != null && ansGridView1.CurrentCell.OwningRow.Cells["pack"].Value.ToString() != "") { strCombo = "select description from description where pack='" + ansGridView1.CurrentCell.OwningRow.Cells["Pack"].Value.ToString() + "' order by description"; ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); ansGridView1.CurrentCell = ansGridView1["Qty", ansGridView1.CurrentCell.RowIndex]; } else if (ActiveCell == "Packing" && (ansGridView1.CurrentCell.OwningRow.Cells["Description"].Value == null || ansGridView1.CurrentCell.OwningRow.Cells["Description"].Value == "")) { strCombo = "select distinct(pack) from description order by Pack"; ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); ansGridView1.CurrentCell = ansGridView1["Description", ansGridView1.CurrentCell.RowIndex]; } ansGridView1.CurrentCell.OwningRow.Cells["Qty"].Value = 0; ansGridView1.CurrentCell.OwningRow.Cells["Rate"].Value = 0; ansGridView1.CurrentCell.OwningRow.Cells["Amt"].Value = 0; } }
private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if (mode == "2Packings") { strCombo = "select distinct description from description "; textBox1.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); } else { strCombo = "SELECT Distinct Pack FROM Description order by Pack"; textBox1.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); } }
private void textBox2_KeyPress(object sender, KeyPressEventArgs e) { if (mode == "2Packings") { strCombo = "SELECT PACK from Description WHERE (((DESCRIPTION.Description)='" + textBox1.Text + "'))"; textBox2.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); } else { strCombo = "SELECT DESCRIPTION.Description FROM Description WHERE (((PACK)='" + textBox1.Text + "'))"; textBox2.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); } }
private void ansGridView1_KeyPress(object sender, KeyPressEventArgs e) { e.Handled = false; if (char.IsLetter(e.KeyChar) || char.IsNumber(e.KeyChar) || e.KeyChar == ' ') { if (ansGridView1.CurrentCell.OwningColumn.Name == "ChargeName") { ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, gstrcombo, e.KeyChar.ToString(), 0); } SendKeys.Send("{Tab}"); } }
private void textBox3_KeyPress(object sender, KeyPressEventArgs e) { //strCombo = "SELECT Name FROM ACCOUNT ORDER BY Name"; if (frmtext == "Agent") { strCombo = "SELECT ACCOUNT.Name FROM ACCOUNT LEFT OUTER JOIN ACCOUNTYPE ON ACCOUNT.Act_id = ACCOUNTYPE.Act_id WHERE (ACCOUNTYPE.Name = 'Agent') ORDER BY ACCOUNT.Name"; } else { strCombo = "SELECT Name FROM Salesman order by name"; } textBox3.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select distinct '<MAIN>' as name from account union all Select Name from Account where act_id='" + funs.Select_act_id("Godown") + "' and Branch_id='" + Database.BranchId + "' order by Name"; DataTable dtgodown = new DataTable(); Database.GetSqlData(strCombo, dtgodown); if (dtgodown.Rows.Count == 1) { textBox1.Text = dtgodown.Rows[0]["name"].ToString(); } else { textBox1.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); } LoadData(); }
private void ansGridView1_KeyPress(object sender, KeyPressEventArgs e) { if (char.IsLetter(e.KeyChar) || char.IsNumber(e.KeyChar) || e.KeyChar == ' ') { if (ansGridView1.CurrentCell.OwningColumn.Name == "Packing") { strCombo = "select Distinct [pack] from Description order by Pack"; ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); } if (ansGridView1.CurrentCell.OwningColumn.Name == "Description") { strCombo = "select description from description where pack='" + ansGridView1.CurrentCell.OwningRow.Cells["Packing"].Value.ToString() + "' order by description"; ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); } } }
private void ansGridView1_KeyPress(object sender, KeyPressEventArgs e) { if (char.IsLetter(e.KeyChar) || char.IsNumber(e.KeyChar) || e.KeyChar == ' ' || Convert.ToInt32(e.KeyChar) == 13) { } else { return; } string wheresrt = ""; string strCombo = ""; if (ansGridView1.CurrentCell.OwningColumn.Name == "Accname") { wheresrt = " Path LIKE '1;3;%' or Path like '1;2;%' "; strCombo = funs.GetStrCombonew(wheresrt, " Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id='" + Database.BranchId + "' "); } ansGridView1.CurrentCell.Value = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); calc(); }
private void textBox14_KeyPress(object sender, KeyPressEventArgs e) { string strCombo = ""; if ((gtype == "Sale" || gtype == "Return" || gtype == "Pending" || gtype == "issue" || gtype == "Sale Order")) { strCombo = funs.GetStrCombonew(" (Path LIKE '1;39;%') or (Path LIKE '1;38;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;40;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '8;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id='" + Database.BranchId + "' "); //strCombo = funs.GetStrCombonew(" (Path LIKE '1;39;%') OR (Path LIKE '1;38;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;40;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '8;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " HAVING Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id=" + Database.BranchId); } else if ((gtype == "Purchase" || gtype == "P Return" || gtype == "receive" || gtype == "RCM" || gtype == "PWDebitNote")) { strCombo = funs.GetStrCombonew(" (Path LIKE '8;40;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;39;%') or (Path LIKE '1;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '1;38;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id='" + Database.BranchId + "' "); //strCombo = funs.GetStrCombonew(" (Path LIKE '8;40;%') OR (Path LIKE '8;39;%') OR (Path LIKE '1;3;%') or (Path LIKE '1;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '1;38;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " HAVING Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id=" + Database.BranchId); } else if (gtype == "Opening") { strCombo = "select distinct '<MAIN>' as name from account union all SELECT ACCOUNT.Name as name FROM ACCOUNT LEFT JOIN ACCOUNTYPE ON ACCOUNT.Act_id = ACCOUNTYPE.Act_id WHERE (((ACCOUNTYPE.Name)='Godown')) GROUP BY ACCOUNT.Name"; } textBox14.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); textBox1.Text = funs.Select_Print(textBox14.Text); textBox2.Text = funs.Select_Address1(textBox14.Text); textBox10.Text = funs.Select_city_name(funs.Select_ac_City_id(textBox14.Text)); textBox11.Text = funs.Select_Pincode(textBox14.Text); textBox3.Text = funs.Select_Address2(textBox14.Text); textBox4.Text = funs.Select_Mobile(textBox14.Text); textBox5.Text = funs.Select_Email(textBox14.Text); textBox6.Text = funs.Select_TIN(textBox14.Text); textBox8.Text = funs.Select_PAN(textBox14.Text); textBox9.Text = funs.Select_AAdhar(textBox14.Text);; textBox7.Text = funs.Select_state_nm(funs.Select_ac_state_id(textBox14.Text).ToString()); }
private void textBox3_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "Select RoleName from SYS_Role order by RoleName"; textBox3.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox5_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select [Bname] from Branch order by Bname"; textBox5.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox4_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select [name] from other where Type='" + funs.Get_Department_id() + "' order by [name]"; textBox4.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox14_KeyPress(object sender, KeyPressEventArgs e) { string strCombo = funs.GetStrCombonew(" (Path LIKE '1;39;%') or (Path LIKE '1;38;%') OR (Path LIKE '1;3;%') or (Path LIKE '8;40;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") or (Path LIKE '8;39;%' and AllowPS=" + access_sql.Singlequote + "true" + access_sql.Singlequote + ") ", " Status=" + access_sql.Singlequote + "true" + access_sql.Singlequote + " and Branch_id='" + Database.BranchId + "' "); textBox14.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); }
private void textBox2_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select [name] from other where Type='SER15' order by [name]"; textBox2.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox14_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select TAXCATEGORY.Category_Name From TAXCATEGORY ORDER BY TAXCATEGORY.Category_Name"; textBox14.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void t5_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select distinct pack from Description order by pack"; t5.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void dataGridView1_KeyPress(object sender, KeyPressEventArgs e) { if (dataGridView1.CurrentCell.OwningColumn.Name == "Description") { string StrSql = ""; if (dataGridView1.CurrentCell.OwningRow.Cells["packing"].Value != null && dataGridView1.CurrentCell.OwningRow.Cells["packing"].Value != "") { wh1 = " DESCRIPTION.Pack ='" + dataGridView1.CurrentCell.OwningRow.Cells["packing"].Value.ToString() + "' "; } if (wh1 != "") { wh2 = " AND TAXCATEGORYDETAIL.SubCategory_Name='" + SubCategory_Name + "'"; } else { wh2 = " TAXCATEGORYDETAIL.SubCategory_Name='" + SubCategory_Name + "'"; } StrSql = "SELECT DISTINCT DESCRIPTION.Description FROM (DESCRIPTION INNER JOIN TAXCATEGORY ON DESCRIPTION.Tax_Cat_id = TAXCATEGORY.Category_Id) INNER JOIN TAXCATEGORYDETAIL ON TAXCATEGORY.Category_Id = TAXCATEGORYDETAIL.Category_Id WHERE " + wh1 + wh2 + " GROUP BY DESCRIPTION.Description, DESCRIPTION.Pack_id, TAXCATEGORYDETAIL.SubCategory_Name"; if (gtaxinvoice == true) { StrSql = "SELECT DISTINCT DESCRIPTION.Description FROM (DESCRIPTION INNER JOIN TAXCATEGORY ON DESCRIPTION.Tax_Cat_id = TAXCATEGORY.Category_Id) INNER JOIN TAXCATEGORYDETAIL ON TAXCATEGORY.Category_Id = TAXCATEGORYDETAIL.Category_Id WHERE " + wh1 + wh2 + " GROUP BY DESCRIPTION.Description, DESCRIPTION.Pack_id, TAXCATEGORYDETAIL.SubCategory_Name HAVING (((Sum(TAXCATEGORYDETAIL.Tax_Rate))<>0))"; } String retStr = SelectCombo.ComboKeypress(this, e.KeyChar, StrSql, e.KeyChar.ToString(), 0); if (retStr != "") { dataGridView1.CurrentCell.Value = retStr; } else { dataGridView1.CurrentCell.Value = ""; dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["description"].Value = ""; return; } String strCnt = ""; if (dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["description"].Value == null || dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["description"].Value.ToString() == "") { strCombo = "select [name] from packing"; strCnt = "select count(*) from packing"; } else { strCombo = "select [name] from packing where Pack_id in (select Pack_id from description where description='" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Description"].Value.ToString() + "')"; strCnt = "select count(*) from packing where Pack_id in (select Pack_id from description where description='" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Description"].Value.ToString() + "')"; } int cnt; cnt = Database.GetScalar(strCnt); if (cnt == 1) { dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Packing"].Value = Database.GetScalarText(strCombo); unit = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Packing"].Value.ToString(); } else if (cnt == 0) { dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Packing"].Value = ""; unit = ""; } desc = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Description"].Value.ToString(); dataGridView1.Select(); SendKeys.Send("{right}"); } if (dataGridView1.CurrentCell.OwningColumn.Name == "Packing") { if (dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Description"].Value == null || dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Description"].Value.ToString() == "") { strCombo = "select distinct [pack] from description order by description"; } else { strCombo = "select Pack from description where description='" + dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Description"].Value.ToString() + "' "; } String packing = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); DataTable dtDesc = new DataTable(); Database.GetSqlData("select description,Pack from description where shortcode='" + packing + "'", dtDesc); if (dtDesc.Rows.Count == 1) { dataGridView1.CurrentCell.OwningRow.Cells["Packing"].Value = dtDesc.Rows[0]["Pack"].ToString(); dataGridView1.CurrentCell.OwningRow.Cells["description"].Value = dtDesc.Rows[0]["description"]; } dataGridView1.CurrentCell.Value = packing; if (dataGridView1.CurrentCell.OwningRow.Cells["description"].Value == null) { dataGridView1.CurrentCell.OwningRow.Cells["description"].Value = ""; } unit = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["Packing"].Value.ToString(); dataGridView1.Select(); SendKeys.Send("{down}"); SendKeys.Send("{left}"); } if (unit != null && desc != null) { getDescdata(desc, unit); } }
private void textBox7_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "SELECT DISTINCT Pack as Packing FROM Description ORDER BY Packing"; textBox7.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }
private void textBox4_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "select distinct '<MAIN>' as name from account union all SELECT ACCOUNT.Name as name FROM ACCOUNT LEFT JOIN ACCOUNTYPE ON ACCOUNT.Act_id = ACCOUNTYPE.Act_id WHERE ACCOUNTYPE.Name='Godown' and Account.Branch_id='" + Database.BranchId + "' GROUP BY ACCOUNT.Name"; textBox4.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 1); }
private void t4_KeyPress(object sender, KeyPressEventArgs e) { strCombo = "Select [Name] from OTHER where type = 'SER16' order by [Name]"; t4.Text = SelectCombo.ComboKeypress(this, e.KeyChar, strCombo, e.KeyChar.ToString(), 0); }