//المستودع
protected void DDL_GV_ToStore_SelectedIndexChanged(object sender, EventArgs e)
{
//تعديل بيانات السطر في الجدول
int RowIndex = ((GridViewRow)((DropDownList)sender).NamingContainer).RowIndex;
Hf_Ln_No.Value = ((Label)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Ln_No")).Text;
cn.Open();
SqlCommand cmd = new SqlCommand("UPDATE InvLoddtl SET Itm_No = @Itm_No,Unit_No = @Unit_No,Qty = @Qty,Exp_Date = @Exp_Date,Itm_Pur = @Itm_Pur,Titm_Pur = @Titm_Pur,Itm_Sal = @Itm_Sal,Titm_Sal = @Titm_Sal,Disc1_Prct = @Disc1_Prct,Disc1_Val = @Disc1_Val,FcItm_Pur = @FcItm_Pur,FcTitm_Pur = @FcTitm_Pur,Batch_No = @Batch_No,Taxp_Extra = @Taxp_Extra,Taxv_Extra = @Taxv_Extra,Loc_No = @Loc_No, To_Store = @To_Store WHERE Doc_Ty = 2 AND Doc_No = @Doc_No AND Ln_No = @Ln_No", cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Doc_No", int.Parse(Txt_Doc_No.Text));
cmd.Parameters.AddWithValue("@Ln_No", short.Parse(Hf_Ln_No.Value));
cmd.Parameters.AddWithValue("@Itm_No", Int64.Parse(((DropDownList)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Itm_Name")).Text));
cmd.Parameters.AddWithValue("@Unit_No", short.Parse(((DropDownList)GV_Details_Invoice.Rows[RowIndex].FindControl("DDL_GV_Unit")).SelectedValue));
cmd.Parameters.AddWithValue("@Exp_Date", ((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Exp_Date")).Text);
cmd.Parameters.AddWithValue("@Qty", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Qty")).Text));
cmd.Parameters.AddWithValue("@Itm_Pur", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Itm_Pur")).Text));
cmd.Parameters.AddWithValue("@Titm_Pur", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Titm_Pur")).Text));
cmd.Parameters.AddWithValue("@Disc1_Prct", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Disc1_Prct")).Text));
cmd.Parameters.AddWithValue("@Disc1_Val", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Disc1_Val")).Text));
cmd.Parameters.AddWithValue("@Itm_Sal", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Itm_Sal")).Text));
cmd.Parameters.AddWithValue("@Titm_Sal", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Titm_Sal")).Text));
cmd.Parameters.AddWithValue("@FcItm_Pur", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_FcItm_Pur")).Text));
cmd.Parameters.AddWithValue("@FcTitm_Pur", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_FcTitm_Pur")).Text));
cmd.Parameters.AddWithValue("@Batch_No", ((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Batch_No")).Text);
cmd.Parameters.AddWithValue("@Taxp_Extra", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Taxp_Extra")).Text));
cmd.Parameters.AddWithValue("@Taxv_Extra", Convert.ToDecimal(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Taxv_Extra")).Text));
cmd.Parameters.AddWithValue("@Loc_No", short.Parse(((TextBox)GV_Details_Invoice.Rows[RowIndex].FindControl("GV_Loc_No")).Text));
cmd.Parameters.AddWithValue("@To_Store", short.Parse(((DropDownList)GV_Details_Invoice.Rows[RowIndex].FindControl("DDL_GV_ToStore")).SelectedValue));
cmd.ExecuteNonQuery();
cn.Close();
//سطر جديد
//New_Ln_No();
//SqlCommand cmd1 = new SqlCommand("insert into InvLoddtl (Cmp_No,Actvty_No,StoreID,Doc_Ty,Doc_No,Ln_No,Doc_Dt,Doc_DtAr,Reftyp_No,Pym_No,To_Store,Sup_No,Loc_No) values (@Cmp_No,@Actvty_No,@StoreID,2,@Doc_No,@Ln_No, @Doc_Dt,@Doc_DtAr,@Reftyp_No,@Pym_No,@To_Store,@Sup_No,1)", cn);
//cmd1.CommandType = CommandType.Text;
//cmd1.Parameters.AddWithValue("@Cmp_No", int.Parse(DDL_Com_NO.SelectedValue));
//cmd1.Parameters.AddWithValue("@Actvty_No", int.Parse(DDL_Actinvity_NO.SelectedValue));
//cmd1.Parameters.AddWithValue("@StoreID", int.Parse(DDL_Store_Number.SelectedValue));
//cmd1.Parameters.AddWithValue("@Doc_No", Int64.Parse(Txt_Doc_No.Text));
//cmd1.Parameters.AddWithValue("@Ln_No", int.Parse(Hf_Ln_No.Value));
//cmd1.Parameters.AddWithValue("@Doc_Dt", Convert.ToDateTime(Txt_Doc_Dt.Text));
//cmd1.Parameters.AddWithValue("@Doc_DtAr",Convert.ToDateTime(Txt_Doc_DtAr.Text).ToString("dd/MM/yy"));
//cmd1.Parameters.AddWithValue("@Reftyp_No", int.Parse(DDL_Reftyp_No.SelectedValue));
//cmd1.Parameters.AddWithValue("@Pym_No", int.Parse(DDL_Pym_No.SelectedValue));
//cmd1.Parameters.AddWithValue("@To_Store", int.Parse(DDL_To_Store.SelectedValue));
//cmd1.Parameters.AddWithValue("Sup_No", int.Parse(DDL_Sup_No.SelectedValue));
//cn.Open();
//cmd1.ExecuteNonQuery();
//cn.Close();
Insert_Details();
//Refresh GridView
GV_Details_Invoice.DataBind();
//النزول في السطر التالي عند رقم الصنف
((TextBox)GV_Details_Invoice.Rows[RowIndex + 1].FindControl("GV_Itm_No")).Focus();
}
protected void Button1_Click(object sender, EventArgs e)
{
New_Ln_No();
Insert_Details();
GV_Details_Invoice.DataBind();
}
