//
 public dynamic GetModel(int Id)
 {
     try
     {
         dynamic       model  = null;
         StringBuilder strSql = new StringBuilder();
         strSql.Append(" select Id,FK_BidId,ScanName,ScanUrl,Editor,CreateDate from T_BidClinchScan ");
         strSql.Append(" where Id=@Id");
         SqlParameter[] parameters =
         {
             new SqlParameter("@Id", SqlDbType.Int, 4)
         };
         parameters[0].Value = Id;
         using (dynamic read = DbHelperSQL.ExecuteReader(strSql.ToString(), parameters))
         {
             if (read.Read())
             {
                 model            = new BidClinchScan();
                 model.Id         = int.Parse(read["Id"].ToString());
                 model.FK_BidId   = int.Parse(read["FK_BidId"].ToString());
                 model.ScanName   = read["ScanName"].ToString();
                 model.ScanUrl    = read["ScanUrl"].ToString();
                 model.Editor     = read["Editor"].ToString();
                 model.CreateDate = DateTime.Parse(read["CreateDate"].ToString());
             }
             read.Dispose();
         }
         return(model);
     }
     catch { throw; }
 }
        private dynamic GetModels(HttpContext context)
        {
            dynamic model = new BidClinchScan();

            try { model.Id = int.Parse(context.Request.Form["Id"].ToString()); }
            catch { }
            model.FK_BidId = int.Parse(context.Request.Form["FK_BidId"].ToString());
            model.ScanName = context.Request.Form["ScanName"].ToString();
            string ImgName = new UpLoadImgPlug().UploadImg("~/Super/Scan/biscan/" + model.FK_BidId + "/", 0);

            if (!string.IsNullOrEmpty(ImgName))
            {
                string imgUrl = HttpContext.Current.Server.MapPath("~/Super/Scan/biscan/" + model.FK_BidId + "/" + ImgName);
                string pdfUrl = "~/Super/Scan/biscan/" + model.FK_BidId + "/";
                new ProducePdfPlug().CreatePdf(imgUrl, pdfUrl, ImgName.Split('.')[0] + ".pdf");
                model.ScanUrl = ImgName.Split('.')[0] + ".pdf";
            }
            else
            {
                model.ScanUrl = context.Request.Form["ScanUrl"].ToString();
            }
            model.Editor     = adminUser.AdminName;
            model.CreateDate = DateTime.Now;
            return(model);
        }
 //
 public bool Create(BidClinchScan model)
 {
     try
     {
         StringBuilder strSql = new StringBuilder();
         strSql.Append("insert into T_BidClinchScan(");
         strSql.Append("FK_BidId,ScanName,ScanUrl,Editor,CreateDate)");
         strSql.Append(" values (");
         strSql.Append("@FK_BidId,@ScanName,@ScanUrl,@Editor,@CreateDate)");
         if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch { throw; }
 }
 //
 public bool Update(BidClinchScan model)
 {
     try
     {
         StringBuilder strSql = new StringBuilder();
         strSql.Append("update T_BidClinchScan set ");
         strSql.Append("FK_BidId=@FK_BidId,");
         strSql.Append("ScanName=@ScanName,");
         strSql.Append("ScanUrl=@ScanUrl,");
         strSql.Append("Editor=@Editor,");
         strSql.Append("CreateDate=@CreateDate");
         strSql.Append(" where Id=@Id");
         if (DbHelperSQL.ExecuteSql(strSql.ToString(), GetSqlParameter(model)) > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     catch { throw; }
 }