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;
}
}
