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