Пример #1
0
        private void chkNull(LabOpuEmbryoDev p)
        {
            long chk = 0;

            p.date_modi   = p.date_modi == null ? "" : p.date_modi;
            p.date_cancel = p.date_cancel == null ? "" : p.date_cancel;
            p.user_create = p.user_create == null ? "" : p.user_create;
            p.user_modi   = p.user_modi == null ? "" : p.user_modi;
            p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;

            p.opu_fet_id        = long.TryParse(p.opu_fet_id, out chk) ? chk.ToString() : "0";
            p.opu_embryo_dev_no = long.TryParse(p.opu_embryo_dev_no, out chk) ? chk.ToString() : "0";
            p.staff_id          = long.TryParse(p.staff_id, out chk) ? chk.ToString() : "0";
            p.checked_id        = long.TryParse(p.checked_id, out chk) ? chk.ToString() : "0";

            p.day               = p.day == null ? "0" : p.day;
            p.desc0             = p.desc0 == null ? "" : p.desc0;
            p.active            = p.active == null ? "" : p.active;
            p.remark            = p.remark == null ? "" : p.remark;
            p.path_pic          = p.path_pic == null ? "" : p.path_pic;
            p.desc1             = p.desc1 == null ? "" : p.desc1;
            p.desc2             = p.desc2 == null ? "" : p.desc2;
            p.desc3             = p.desc3 == null ? "" : p.desc3;
            p.embryo_dev_date   = p.embryo_dev_date == null ? "" : p.embryo_dev_date;
            p.desc4             = p.desc4 == null ? "" : p.desc4;
            p.desc5             = p.desc5 == null ? "" : p.desc5;
            p.status_biopsy_ngs = p.status_biopsy_ngs == null ? "" : p.status_biopsy_ngs;

            //p.user_cancel = p.user_cancel == null ? "" : p.user_cancel;
        }
Пример #2
0
        private void initConfig()
        {
            opuEmDev = new LabOpuEmbryoDev();
            opuEmDev.opu_embryo_dev_id = "opu_embryo_dev_id";
            opuEmDev.opu_fet_id        = "opu_fet_id";
            opuEmDev.day = "day";
            opuEmDev.opu_embryo_dev_no = "opu_embryo_dev_no";
            opuEmDev.desc0             = "desc0";
            opuEmDev.active            = "active";
            opuEmDev.remark            = "remark";
            opuEmDev.path_pic          = "path_pic";
            opuEmDev.date_create       = "date_create";
            opuEmDev.date_modi         = "date_modi";
            opuEmDev.date_cancel       = "date_cancel";
            opuEmDev.user_create       = "user_create";
            opuEmDev.user_modi         = "user_modi";
            opuEmDev.user_cancel       = "user_cancel";
            opuEmDev.desc1             = "desc1";
            opuEmDev.desc2             = "desc2";
            opuEmDev.desc3             = "desc3";
            opuEmDev.staff_id          = "staff_id";
            opuEmDev.checked_id        = "checked_id";
            opuEmDev.embryo_dev_date   = "embryo_dev_date";
            opuEmDev.desc4             = "desc4";
            opuEmDev.desc5             = "desc5";
            opuEmDev.status_biopsy_ngs = "status_biopsy_ngs";

            opuEmDev.table   = "lab_t_opu_embryo_dev";
            opuEmDev.pkField = "opu_embryo_dev_id";

            lStf = new List <LabOpuEmbryoDev>();
        }
Пример #3
0
        public String update(LabOpuEmbryoDev p, String userId)
        {
            String re  = "";
            String sql = "";
            int    chk = 0;

            chkNull(p);
            sql = "Update " + opuEmDev.table + " Set " +
                  " " + opuEmDev.day + " = '" + p.day + "'" +
                  "," + opuEmDev.opu_embryo_dev_no + " = '" + p.opu_embryo_dev_no.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc0 + " = '" + p.desc0 + "'" +
                  "," + opuEmDev.remark + " = '" + p.remark.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc1 + " = '" + p.desc1.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc2 + " = '" + p.desc2.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc3 + " = '" + p.desc3.Replace("'", "''") + "'" +
                  //"," + opuEmDev.staff_id + " = '" + p.staff_id + "'" +
                  //"," + opuEmDev.checked_id + "='" + p.checked_id + "'" +
                  //"," + opuEmDev.embryo_dev_date + "='" + p.embryo_dev_date + "'" +
                  "," + opuEmDev.desc4 + "='" + p.desc4.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc5 + "='" + p.desc5.Replace("'", "''") + "'" +
                  "," + opuEmDev.status_biopsy_ngs + "='" + p.status_biopsy_ngs.Replace("'", "''") + "'" +
                  "Where " + opuEmDev.pkField + "='" + p.opu_embryo_dev_id + "'"
            ;

            try
            {
                re = conn.ExecuteNonQuery(conn.conn, sql);
            }
            catch (Exception ex)
            {
                sql = ex.Message + " " + ex.InnerException;
            }

            return(re);
        }
Пример #4
0
        public String insertLabOpuEmbryoDev(LabOpuEmbryoDev p, String userId)
        {
            String re = "";

            if (p.opu_embryo_dev_id.Equals(""))
            {
                re = insert(p, "");
            }
            else
            {
                re = update(p, "");
            }

            return(re);
        }
Пример #5
0
        public String insert(LabOpuEmbryoDev p, String userId)
        {
            String re  = "";
            String sql = "";

            p.active = "1";
            //p.ssdata_id = "";
            int chk = 0;

            chkNull(p);
            //opuEmDev.desc0 = "desc0";
            sql = "Insert Into " + opuEmDev.table + " Set " +
                  " " + opuEmDev.opu_fet_id + "='" + p.opu_fet_id + "'" +
                  "," + opuEmDev.day + "='" + p.day + "'" +
                  "," + opuEmDev.opu_embryo_dev_no + "='" + p.opu_embryo_dev_no + "'" +
                  "," + opuEmDev.desc0 + "='" + p.desc0.Replace("'", "''") + "'" +
                  "," + opuEmDev.active + "='" + p.active + "'" +
                  "," + opuEmDev.remark + "='" + p.remark + "'" +
                  "," + opuEmDev.path_pic + "='" + p.path_pic + "'" +
                  "," + opuEmDev.date_create + "=now()" +
                  "," + opuEmDev.user_create + "='" + userId + "'" +
                  "," + opuEmDev.desc1 + "='" + p.desc1.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc2 + "='" + p.desc2.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc3 + "='" + p.desc3.Replace("'", "''") + "'" +
                  "," + opuEmDev.staff_id + "='" + p.staff_id + "'" +
                  "," + opuEmDev.checked_id + "='" + p.checked_id + "'" +
                  "," + opuEmDev.embryo_dev_date + "='" + p.embryo_dev_date + "'" +
                  "," + opuEmDev.desc4 + "='" + p.desc4.Replace("'", "''") + "'" +
                  "," + opuEmDev.desc5 + "='" + p.desc5.Replace("'", "''") + "'" +
                  "," + opuEmDev.status_biopsy_ngs + "='" + p.status_biopsy_ngs.Replace("'", "''") + "'" +
                  " " +

                  "";
            try
            {
                re = conn.ExecuteNonQuery(conn.conn, sql);
            }
            catch (Exception ex)
            {
                sql = ex.Message + " " + ex.InnerException;
            }

            return(re);
        }