protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var query = (from D in db.InvLoddtl join I in db.MtsItmMfs on D.Itm_No equals I.Itm_No select new { م = D.Ln_No, رقم_الصنف = D.Itm_No, اسم_الصنف = I.Itm_NmAr }); DDL_Com_NO.Focus(); //var NID = db.InvLodhdr.Where(o => o.Doc_Ty == 2).Max(q=>q.Doc_No); //Int64 NewID = Convert.ToInt64(NID) + 1; //Txt_Doc_No.Text = NewID.ToString(); Txt_Doc_No.Text = My_Vairables.Pur_UID; //SqlCommand cmd = new SqlCommand("InvLodhdr_Insert", cn); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@Doc_No", Txt_Doc_No.Text); //cn.Open(); //cmd.ExecuteNonQuery(); //cn.Close(); //Inv_Details_Insert(); //Lbl_B_ID.Text = Txt_Doc_No.Text; Txt_Doc_Dt.Text = DateTime.Now.ToString("dd/MM/yyyy"); CultureInfo X = new CultureInfo("ar_SA"); string m = Convert.ToDateTime(Txt_Doc_Dt.Text).ToString("dd/MM/yyyy", X); Txt_Doc_DtAr.Text = m; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDL_Com_NO.Focus(); InvLodhdr_New_ID(); Txt_Doc_No.Text = Hf_InvLodhdr.Value; SqlCommand cmd = new SqlCommand("InvLodhdr_Insert", cn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Doc_No", Txt_Doc_No.Text); cn.Open(); cmd.ExecuteNonQuery(); cn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { DDL_Com_NO.Focus(); var NID = db.InvLodhdr.Where(o => o.Doc_Ty == 2).Max(q => q.Doc_No); Int64 NewID = Convert.ToInt64(NID) + 1; Txt_Doc_No.Text = NewID.ToString(); //SqlCommand cmd = new SqlCommand("InvLodhdr_Insert", cn); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@Doc_No", Txt_Doc_No.Text); //cn.Open(); //cmd.ExecuteNonQuery(); //cn.Close(); //Inv_Details_Insert(); //Lbl_B_ID.Text = Txt_Doc_No.Text; Txt_Doc_Dt.Text = DateTime.Now.ToString("dd/MM/yyyy"); CultureInfo X = new CultureInfo("ar_SA"); string m = Convert.ToDateTime(Txt_Doc_Dt.Text).ToString("dd/MM/yyyy", X); Txt_Doc_DtAr.Text = m; } }