void hubungan1()
{
DataSet Ds = new DataSet();
try
{
string com = "select Contact_Code,UPPER(Contact_Name) as Contact_Name from Ref_Hubungan where Contact_Code NOT IN('05') order by Contact_Code";
SqlDataAdapter adpt = new SqlDataAdapter(com, con);
DataTable dt = new DataTable();
adpt.Fill(dt);
DropDownList19.DataSource = dt;
DropDownList19.DataTextField = "Contact_Name";
DropDownList19.DataValueField = "Contact_Code";
DropDownList19.DataBind();
DropDownList19.Items.Insert(0, new ListItem("--- PILIH ---", ""));
}
catch (Exception ex)
{
throw ex;
}
}
protected void DropDownList14_SelectedIndexChanged(object sender, EventArgs e)
{
if (DropDownList14.SelectedValue == "2")
{
DropDownList4.Items.Clear();
if (FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isotimia() == 1)
{
DropDownList4.DataSourceID = "GR_FOR_EMV_FPA2_LC";
}
else
{
DropDownList4.DataSourceID = "GR_FOR_EMV_FPA2";
}
DropDownList4.DataBind();
//DropDownList4.Items.Add(new ListItem("Επιλογή Γραμματίου ...", "0"));
DropDownList4.Items.Insert(0, new ListItem("Επιλογή Γραμματίου ...", "0"));
DropDownList4.SelectedIndex = 0;
string Etos_Y = DropDownList3.Text;
string Xrisi_Y = TextBox15.Text;
string strConn_Y;
strConn_Y = WebConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
SqlConnection Conn_Xy = new SqlConnection(strConn_Y);
Conn_Xy.Open();
string sqltitle_Xy;
sqltitle_Xy = "SELECT Count(*) FROM Esoda";
sqltitle_Xy += " WHERE (Etos ='" + Etos_Y + "') AND (Xrisi ='" + Xrisi_Y + "') AND [ESODA].[Eidos_Es] = 14 ";
// sqltitle += " AND (edition ='" + edition + "')";
SqlCommand com_Xc = new SqlCommand(sqltitle_Xy, Conn_Xy);
Int32 CurrentQty_Xc;
CurrentQty_Xc = Convert.ToInt32(com_Xc.ExecuteScalar());
if (CurrentQty_Xc == 0)
{
DropDownList19.Items.Clear();
DropDownList19.Enabled = true;
DropDownList19.DataSourceID = "GR_FOR_FPA";
DropDownList19.DataBind();
DropDownList19.Items.Insert(0, new ListItem("Επιλογή Προηγούμενου Γραμματίου ...", "0"));
DropDownList19.SelectedIndex = 0;
}
else
{
DropDownList19.Enabled = false;
}
Conn_Xy.Close();
Label4.Text = "ΑΣ Διαβιβαστικού";
Label5.Text = "Αριθμός Παρασταστικού Αποστολής Τραπεζικού Εμβάσματος";
}
else if (DropDownList14.SelectedValue == "1")
{
DropDownList4.Items.Clear();
if (FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isotimia() == 1)
{
DropDownList4.DataSourceID = "GR_FOR_EMV_FPA01_LC";
}
else
{
DropDownList4.DataSourceID = "GR_FOR_EMV_FPA01";
}
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, new ListItem("Επιλογή Γραμματίου ...", "0"));
// DropDownList4.Items.Insert(0, new ListItem("Επιλογή Γραμματίου ...", String.Empty));
DropDownList4.SelectedIndex = 0;
DropDownList19.Items.Clear();
DropDownList19.Enabled = true;
DropDownList19.DataSourceID = "Arxes";
DropDownList19.DataBind();
DropDownList19.Items.Insert(0, new ListItem("Αποστολή προς Αρχή ...", "0"));
DropDownList19.SelectedIndex = 0;
Label4.Text = "Σχετ. Έγκρισης";
Label5.Text = "Περιγραφή Εμβάσματος";
}
else
{
DropDownList4.Items.Clear();
if (FINANCIAL_MANAGEMENT.App_Code.xrisi.Fetch_Isotimia() == 1)
{
DropDownList4.DataSourceID = "GR_FOR_EMV_FPA01_LC";
}
else
{
DropDownList4.DataSourceID = "GR_FOR_EMV_FPA01";
}
DropDownList4.DataBind();
DropDownList4.Items.Insert(0, new ListItem("Επιλογή Γραμματίου ...", "0"));
// DropDownList4.Items.Insert(0, new ListItem("Επιλογή Γραμματίου ...", String.Empty));
DropDownList4.SelectedIndex = 0;
DropDownList19.Enabled = false;
DropDownList19.Items.Clear();
Label4.Text = "ΑΣ Διαβιβ. / Ημερ/νια";
Label5.Text = "Περιγραφή Εμβάσματος";
TextBox10.Text = DropDownList14.SelectedItem.ToString();
}
TextBox7.Text = "";
TextBox21.Text = DropDownList4.SelectedValue.ToString();
}
