protected void BtnInsert_Click(Object sender, System.EventArgs e) { Clkhesarat cl = new Clkhesarat(); cl = Data; int t = 0; if (CSharp.PublicFunction.ModeInsert(khesaratID.ToString())) { t = khesaratClass.insert(cl); } else { t = khesaratClass.Update(cl); } if (t == 0) { LblMsg.ForeColor = System.Drawing.Color.Red; LblMsg.Text = "خطا در ثبت"; } else { LblMsg.ForeColor = System.Drawing.Color.Green; LblMsg.Text = "ثبت انجام شد."; BindGrid(); } LightBox.Value = "0"; LblParamKesaratID.Text = "0"; }
public void UpItem(object sender, EventArgs e) { String KesaratID = ((HtmlAnchor)sender).HRef.ToString(); LblParamKesaratID.Text = KesaratID; Clkhesarat cl = new Clkhesarat(); cl.KesaratID = Convert.ToInt32(KesaratID); Data = cl; LightBox.Value = "1"; }
private void SetPric(int khesaratID) { Clkhesarat cl = new Clkhesarat(); cl.KesaratID = khesaratID; DataSet ds = khesaratClass.GetList(cl); DataRow dr = ds.Tables[0].Rows[0]; TXTFinePrice.Text = dr["KesaratPrice"].ToString(); ds.Dispose(); }
public void BindGrid() { Clkhesarat cl = new Clkhesarat(); DataSet ds = khesaratClass.GetList(cl); DataView dv = new DataView(ds.Tables[0]); if (ViewState["ParkID"] == null) { ViewState["ParkID"] = "KesaratID Desc"; } dv.Sort = Securenamespace.SecureData.CheckSecurity(ViewState["ParkID"].ToString()).ToString(); GridView1.DataSource = dv; GridView1.DataBind(); }
public void BindDD() { //DDFineID.DataSource = CatalogClass.GetListTypeID("6"); //DDFineID.DataTextField = "CatalogName"; //DDFineID.DataValueField = "CatalogValue"; //DDFineID.DataBind(); Clkhesarat cl = new Clkhesarat(); DataSet ds = khesaratClass.GetList(cl); DDFineID.DataTextField = "KhesaratDesc"; DDFineID.DataValueField = "KesaratID"; DDFineID.DataSource = ds; DDFineID.DataBind(); if (ds.Tables[0].Rows.Count > 0) { DataRow dr = ds.Tables[0].Rows[0]; TXTFinePrice.Text = dr["KesaratPrice"].ToString(); } ds.Dispose(); TXTFineDate.Text = DateConvert.m2sh(DateTime.Now.ToString()).ToString(); }
//--------------------------------------------------------------------------------------------------------- public static DataSet GetList(Clkhesarat c) { SqlCommand cmd = new SqlCommand("PRC_khesarat_GetList", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("KesaratID", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.KesaratID); cmd.Parameters.Add(new SqlParameter("KesaratPrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.KesaratPrice); cmd.Parameters.Add(new SqlParameter("KhesaratDesc", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.KhesaratDesc); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); DataSet ds = new DataSet(); SqlDataAdapter da = new SqlDataAdapter(cmd); try { cnn.Open(); da.Fill(ds); return(ds); } catch (Exception ex) { return(null); } finally { cnn.Close(); } }
public static int insert(Clkhesarat c) { SqlCommand cmd = new SqlCommand("PRC_khesarat_Insert", cnn); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("UserIDLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetUserID(); cmd.Parameters.Add(new SqlParameter("IpLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetIPAddress(); cmd.Parameters.Add(new SqlParameter("OSLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetOS(); cmd.Parameters.Add(new SqlParameter("OSVerLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetBrowser() + CSharp.PublicFunction.GetBrowserVersion(); cmd.Parameters.Add(new SqlParameter("URLLog", SqlDbType.NVarChar)).Value = CSharp.PublicFunction.GetURL(); cmd.Parameters.Add(new SqlParameter("KesaratPrice", SqlDbType.Int)).Value = Securenamespace.SecureData.CheckSecurity(c.KesaratPrice); cmd.Parameters.Add(new SqlParameter("KhesaratDesc", SqlDbType.NVarChar)).Value = Securenamespace.SecureData.CheckSecurity(c.KhesaratDesc); SqlParameter prmResult = new SqlParameter("Result", SqlDbType.Int); prmResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(prmResult); try { cnn.Open(); cmd.ExecuteNonQuery(); return(Convert.ToInt32(prmResult.Value)); } catch (Exception ex) { return(0); } finally { cnn.Close(); } }