コード例 #1
0
        private void SavDet()
        {
            try
            {
                string ProQuot_id = "";

                string cmds = "select max(cast(MProQuot_id as int)) as [MProQuot_id] from tbl_MProQuot";

                SqlCommand cmd = new SqlCommand(cmds, con);
                con.Open();

                DataTable      dt_ = new DataTable();
                SqlDataAdapter adp = new SqlDataAdapter(cmd);
                adp.Fill(dt_);
                {
                    ProQuot_id = dt_.Rows[0]["MProQuot_id"].ToString();
                }
                if (dt_.Rows.Count > 0)
                {
                    foreach (GridViewRow g1 in GVDetQuot.Rows)
                    {
                        string DDLPro   = (g1.FindControl("DDL_Pro") as DropDownList).SelectedValue;
                        string TBProQty = (g1.FindControl("TBProQty") as TextBox).Text;
                        string TBProrat = (g1.FindControl("TBProrat") as TextBox).Text;
                        string TBAmt    = (g1.FindControl("TBAmt") as TextBox).Text;
                        string TBNarr   = (g1.FindControl("TBNarr") as TextBox).Text;

                        tbl_DProQuot dquot = new tbl_DProQuot();

                        dquot.DProQuot_id   = HFDQuotID.Value;
                        dquot.DProQuot_SNO  = string.IsNullOrEmpty(TBProQty) ? null : TBProQty;
                        dquot.ProductID     = string.IsNullOrEmpty(DDLPro) ? null : DDLPro;
                        dquot.DProQuot_rat  = string.IsNullOrEmpty(TBProrat) ? null : TBProrat;
                        dquot.MProQuot_amt  = string.IsNullOrEmpty(TBAmt) ? null : TBAmt;
                        dquot.MProQuot_tamt = string.IsNullOrEmpty(TBGrssTotal.Text.Trim()) ? null : TBGrssTotal.Text.Trim();
                        dquot.MProQuot_narr = string.IsNullOrEmpty(TBNarr) ? null : TBNarr;
                        dquot.CreatedBy     = Session["user"].ToString();
                        dquot.CreatedAt     = DateTime.Now;
                        dquot.ISActive      = "1";
                        dquot.MProQuot_id   = string.IsNullOrEmpty(ProQuot_id) ? null : ProQuot_id;

                        tbl_DProQuotManager dproquotmanag = new tbl_DProQuotManager(dquot);
                        dproquotmanag.Save();
                    }
                }
                else
                {
                    lbl_err.Text = "Sory Record has not been Saved! Inner Error";
                }
                con.Close();
            }
            catch (Exception ex)
            {
                lbl_err.Text = ex.Message.ToString();
            }
        }
コード例 #2
0
        public override bool Equals(object obj)
        {
            if (obj == null)
            {
                return(false);
            }

            tbl_DProQuot DProQuot = obj as tbl_DProQuot;

            if (DProQuot == null)
            {
                return(false);
            }

            if (this.DProQuot_id == DProQuot.DProQuot_id)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
コード例 #3
0
 public tbl_DProQuotManager(tbl_DProQuot _DProQuot)
 {
     DProQuot = _DProQuot;
 }