//زر الإضافة في جدول التفاصيل protected void Btn_Add_Details_Click(object sender, EventArgs e) { if (Txt_Disc1_Prct.Text == "") { Txt_Disc1_Prct.Text = "0"; } //رقم السطر New_Ln_No(); //الاضافة SqlCommand cmd = 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], [Unit_No], [Qty], [Exp_Date], [Itm_Pur], [Titm_Pur], [Itm_Sal], [Titm_Sal], [Disc1_Prct], [Disc1_Val], [FcItm_Pur], [FcTitm_Pur], [Batch_No], [Taxp_Extra], [Taxv_Extra], [Sup_No], [Loc_No], [Itm_No]) VALUES (@Cmp_No, @Actvty_No, @StoreID, @Doc_Ty, @Doc_No, @Ln_No, @Doc_Dt, @Doc_DtAr, @Reftyp_No, @Pym_No, @To_Store, @Unit_No, @Qty, @Exp_Date, @Itm_Pur, @Titm_Pur, @Itm_Sal, @Titm_Sal, @Disc1_Prct, @Disc1_Val, @FcItm_Pur, @FcTitm_Pur, @Batch_No, @Taxp_Extra, @Taxv_Extra, @Sup_No, @Loc_No, @Itm_No)", cn); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Doc_No", Convert.ToInt64(Txt_Doc_No.Text)); cmd.Parameters.AddWithValue("@StoreID", int.Parse(DDL_Store_Number.SelectedValue)); cmd.Parameters.AddWithValue("@Cmp_No", int.Parse(DDL_Com_NO.SelectedValue)); cmd.Parameters.AddWithValue("@Actvty_No", int.Parse(DDL_Actinvity_NO.SelectedValue)); cmd.Parameters.AddWithValue("@Doc_Ty", int.Parse(DDL_Reftyp_No.SelectedValue)); cmd.Parameters.AddWithValue("@Ln_No", int.Parse(Hf_Ln_No.Value)); cmd.Parameters.AddWithValue("@Doc_Dt", Txt_Doc_Dt.Text); cmd.Parameters.AddWithValue("@Doc_DtAr", Txt_Doc_DtAr.Text); cmd.Parameters.AddWithValue("@Reftyp_No", int.Parse(DDL_Reftyp_No.SelectedValue)); cmd.Parameters.AddWithValue("@To_Store", int.Parse(DDL_To_Store.SelectedValue)); cmd.Parameters.AddWithValue("@Sup_No", Convert.ToInt64(DDL_Sup_No.SelectedValue)); cmd.Parameters.AddWithValue("@Itm_No", Convert.ToInt64(Txt_Itm_No.Text)); cmd.Parameters.AddWithValue("@Unit_No", int.Parse(DDL_Itm_Unit.SelectedValue)); cmd.Parameters.AddWithValue("@Loc_No", int.Parse(Txt_Loc_No.Text)); cmd.Parameters.AddWithValue("@Qty", Convert.ToDecimal(Txt_Qty.Text)); cmd.Parameters.AddWithValue("@Itm_Pur", Convert.ToDecimal(Txt_Itm_Pur.Text)); cmd.Parameters.AddWithValue("@Exp_Date", Txt_Exp_Date.Text); cmd.Parameters.AddWithValue("@Batch_No", Txt_Batch_No.Text); cmd.Parameters.AddWithValue("@Titm_Pur", Convert.ToDecimal(Txt_Titm_Pur.Text)); cmd.Parameters.AddWithValue("@Disc1_Prct", Convert.ToDecimal(Txt_Disc1_Prct.Text)); cmd.Parameters.AddWithValue("@Disc1_Val", Convert.ToDecimal(Txt_Disc1_Val.Text)); cmd.Parameters.AddWithValue("@Itm_Sal", Convert.ToDecimal(Txt_Item_Sal.Text)); cmd.Parameters.AddWithValue("@TItm_Sal", Convert.ToDecimal(Txt_TItem_Sal.Text)); cmd.Parameters.AddWithValue("@FcItm_Pur", Convert.ToDecimal(Txt_FcItm_Pur.Text)); cmd.Parameters.AddWithValue("@FcTitm_Pur", Convert.ToDecimal(Txt_FcTitm_Pur.Text)); cmd.Parameters.AddWithValue("@Taxp_Extra", Convert.ToDecimal(Txt_Taxp_Extra.Text)); cmd.Parameters.AddWithValue("@Taxv_Extra", Convert.ToDecimal(Txt_Taxv_Extra.Text)); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); GridView1.DataBind(); GVInv_Details.DataBind(); }
protected void LinkButton3_Click(object sender, EventArgs e) { New_Ln_No(); SQL_GVInv_Details.InsertParameters["Cmp_No"].DefaultValue = "0"; SQL_GVInv_Details.InsertParameters["Actvty_No"].DefaultValue = "0"; SQL_GVInv_Details.InsertParameters["StoreID"].DefaultValue = "0"; SQL_GVInv_Details.InsertParameters["Doc_Ty"].DefaultValue = "2"; SQL_GVInv_Details.InsertParameters["Doc_No"].DefaultValue = Txt_Doc_No.Text; SQL_GVInv_Details.InsertParameters["Ln_No"].DefaultValue = Hf_Ln_No.Value; SQL_GVInv_Details.InsertParameters["Doc_Dt"].DefaultValue = Txt_Doc_Dt.Text; SQL_GVInv_Details.InsertParameters["Doc_DtAr"].DefaultValue = Txt_Doc_DtAr.Text; SQL_GVInv_Details.InsertParameters["Reftyp_No"].DefaultValue = DDL_Reftyp_No.SelectedValue; SQL_GVInv_Details.InsertParameters["Pym_No"].DefaultValue = DDL_Pym_No.SelectedValue; SQL_GVInv_Details.InsertParameters["To_Store"].DefaultValue = ((DropDownList)GVInv_Details.HeaderRow.FindControl("GV_To_Store")).SelectedValue; SQL_GVInv_Details.InsertParameters["Unit_No"].DefaultValue = ((DropDownList)GVInv_Details.HeaderRow.FindControl("GV_Itm_Unit")).SelectedValue; SQL_GVInv_Details.InsertParameters["Qty"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Qty")).Text; SQL_GVInv_Details.InsertParameters["Exp_Date"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Exp_Date")).Text; SQL_GVInv_Details.InsertParameters["Itm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Itm_Pur")).Text; SQL_GVInv_Details.InsertParameters["Titm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_TItm_Pur")).Text; SQL_GVInv_Details.InsertParameters["Itm_Sal"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_ItmSal")).Text; SQL_GVInv_Details.InsertParameters["Titm_Sal"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_TitmSal")).Text; SQL_GVInv_Details.InsertParameters["Disc1_Prct"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV__Disc1_Prct")).Text; SQL_GVInv_Details.InsertParameters["Disc1_Val"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Disc1_Val")).Text; SQL_GVInv_Details.InsertParameters["FcItm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_FcItm_Pur")).Text; SQL_GVInv_Details.InsertParameters["FcTitm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_FcTitm_Pur")).Text; SQL_GVInv_Details.InsertParameters["Batch_No"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Batch_No")).Text; SQL_GVInv_Details.InsertParameters["Taxp_Extra"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Taxp_Extra")).Text; SQL_GVInv_Details.InsertParameters["Taxv_Extra"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Taxv_Extra")).Text; SQL_GVInv_Details.InsertParameters["Sup_No"].DefaultValue = ((DropDownList)GVInv_Details.HeaderRow.FindControl("DDL_Sup_No")).SelectedValue; SQL_GVInv_Details.InsertParameters["Loc_No"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Loc_No")).Text; SQL_GVInv_Details.InsertParameters["Itm_No"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Itm_No")).Text; SQL_GVInv_Details.Insert(); GVInv_Details.DataBind(); //SqlCommand cmd = new SqlCommand("InvLoddtl_Insert_Pur", cn); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@Doc_No", Convert.ToInt64(Txt_Doc_No.Text)); //cmd.Parameters.AddWithValue("@StoreID", int.Parse(DDL_Store_Number.SelectedValue)); //cmd.Parameters.AddWithValue("@Cmp_No", int.Parse(DDL_Com_NO.SelectedValue)); //cmd.Parameters.AddWithValue("@Actvty_No", int.Parse(DDL_Actinvity_NO.SelectedValue)); //cmd.Parameters.AddWithValue("@Doc_Ty", int.Parse(DDL_Reftyp_No.SelectedValue)); //cmd.Parameters.AddWithValue("@Ln_No", int.Parse(Hf_Ln_No.Value)); //cmd.Parameters.AddWithValue("@Doc_Dt", Txt_Doc_Dt.Text); //cmd.Parameters.AddWithValue("@Doc_DtAr", Txt_Doc_DtAr.Text); //cmd.Parameters.AddWithValue("@To_Store", int.Parse(DDL_To_Store.SelectedValue)); //cmd.Parameters.AddWithValue("@Sup_No", Convert.ToInt64(DDL_Sup_No.SelectedValue)); //cmd.Parameters.AddWithValue("@Itm_No", Convert.ToInt64(Txt_Itm_No.Text)); //cmd.Parameters.AddWithValue("@Unit_No", int.Parse(DDL_Itm_Unit.SelectedValue)); //cmd.Parameters.AddWithValue("@Loc_No", int.Parse(Txt_Loc_No.Text)); //cmd.Parameters.AddWithValue("@Qty", Convert.ToDecimal(Txt_Qty.Text)); //cmd.Parameters.AddWithValue("@Itm_Pur", Convert.ToDecimal(Txt_Itm_Pur.Text)); //cmd.Parameters.AddWithValue("@Exp_Date", Txt_Exp_Date.Text); //cmd.Parameters.AddWithValue("@Batch_No", Txt_Batch_No.Text); //cmd.Parameters.AddWithValue("@Titm_Pur", Convert.ToDecimal(Txt_Titm_Pur.Text)); //cmd.Parameters.AddWithValue("@Disc1_Prct", Convert.ToDecimal(Txt_Disc1_Prct.Text)); //cmd.Parameters.AddWithValue("@Disc1_Val", Convert.ToDecimal(Txt_Disc1_Val.Text)); //cmd.Parameters.AddWithValue("@Itm_SalSubUnt", Convert.ToDecimal(Txt_Item_SalSubUnit.Text)); //cmd.Parameters.AddWithValue("@FcTitm_Sal", Convert.ToDecimal(Txt_FcTitm_Sal.Text)); //cmd.Parameters.AddWithValue("@FcItm_Pur", Convert.ToDecimal(Txt_FcItm_Pur.Text)); //cmd.Parameters.AddWithValue("@FcTitm_Cost", Convert.ToDecimal(Txt_FcTitm_Cost.Text)); //cmd.Parameters.AddWithValue("@Taxp_Extra", Convert.ToDecimal(Txt_Taxp_Extra.Text)); //cmd.Parameters.AddWithValue("@Taxv_Extra", Convert.ToDecimal(Txt_Taxv_Extra.Text)); //cn.Open(); //cmd.ExecuteNonQuery(); //cn.Close(); }