public List <WomenGravidaPostpartum42DayModel> DataTableToList(DataTable dt) { List <WomenGravidaPostpartum42DayModel> list = new List <WomenGravidaPostpartum42DayModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { WomenGravidaPostpartum42DayModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public int AddServer(WomenGravidaPostpartum42DayModel model) { return(this.dal.AddServer(model)); }
public bool UpdateServer(WomenGravidaPostpartum42DayModel model) { return(this.dal.UpdateServer(model)); }
public bool UpdateServer(WomenGravidaPostpartum42DayModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update GRAVIDA_POSTPARTUM_42DAY set "); builder.Append("CustomerID=@CustomerID,"); builder.Append("RecordID=@RecordID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("FollowupDate=@FollowupDate,"); builder.Append("Healthcondition=@Healthcondition,"); builder.Append("Mentalcondition=@Mentalcondition,"); builder.Append("Hbloodpressure=@Hbloodpressure,"); builder.Append("LBloodPressure=@LBloodPressure,"); builder.Append("Breast=@Breast,"); builder.Append("BreastEx=@BreastEx,"); builder.Append("Lochia=@Lochia,"); builder.Append("LochiaEx=@LochiaEx,"); builder.Append("Uterus=@Uterus,"); builder.Append("UterusEx=@UterusEx,"); builder.Append("Wound=@Wound,"); builder.Append("WoundEx=@WoundEx,"); builder.Append("Other=@Other,"); builder.Append("Classification=@Classification,"); builder.Append("ClassificationEx=@ClassificationEx,"); builder.Append("Advising=@Advising,"); builder.Append("AdvisingOther=@AdvisingOther,"); builder.Append("Treat=@Treat,"); builder.Append("ReferralReason=@ReferralReason,"); builder.Append("ReferralOrg=@ReferralOrg,"); builder.Append("NextFollowUpDate=@NextFollowUpDate,"); builder.Append("FollowUpDoctor=@FollowUpDoctor,"); builder.Append("CreatedBy=@CreatedBy,"); builder.Append("CreatedDate=@CreatedDate,"); builder.Append("LastUpdateBy=@LastUpdateBy,"); builder.Append("LastUpDate=@LastUpDate,"); builder.Append("IsDel=@IsDel,"); builder.Append("DeliveryDate=@DeliveryDate,"); builder.Append("LeaveHospitalDate=@LeaveHospitalDate,"); builder.Append("CheckOrg=@CheckOrg,"); builder.Append("ReferralContacts=@ReferralContacts,"); builder.Append("ReferralResult=@ReferralResult "); builder.Append(" where IDCardNo=@IDCardNo"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@CustomerID", MySqlDbType.String, 32), new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@FollowupDate", MySqlDbType.Date), new MySqlParameter("@Healthcondition", MySqlDbType.String, 200), new MySqlParameter("@Mentalcondition", MySqlDbType.String, 200), new MySqlParameter("@Hbloodpressure", MySqlDbType.Decimal), new MySqlParameter("@LBloodPressure", MySqlDbType.Decimal), new MySqlParameter("@Breast", MySqlDbType.String, 1), new MySqlParameter("@BreastEx", MySqlDbType.String, 200), new MySqlParameter("@Lochia", MySqlDbType.String, 1), new MySqlParameter("@LochiaEx", MySqlDbType.String, 200), new MySqlParameter("@Uterus", MySqlDbType.String, 1), new MySqlParameter("@UterusEx", MySqlDbType.String, 200), new MySqlParameter("@Wound", MySqlDbType.String, 1), new MySqlParameter("@WoundEx", MySqlDbType.String, 200), new MySqlParameter("@Other", MySqlDbType.String, 500), new MySqlParameter("@Classification", MySqlDbType.String, 1), new MySqlParameter("@ClassificationEx", MySqlDbType.String, 200), new MySqlParameter("@Advising", MySqlDbType.String, 30), new MySqlParameter("@AdvisingOther", MySqlDbType.String, 200), new MySqlParameter("@Treat", MySqlDbType.String, 1), new MySqlParameter("@ReferralReason", MySqlDbType.String, 500), new MySqlParameter("@ReferralOrg", MySqlDbType.String, 80), new MySqlParameter("@NextFollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 30), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal), new MySqlParameter("@LastUpDate", MySqlDbType.Date), new MySqlParameter("@IsDel", MySqlDbType.String, 1), new MySqlParameter("@DeliveryDate", MySqlDbType.Date), new MySqlParameter("@LeaveHospitalDate", MySqlDbType.Date), new MySqlParameter("@CheckOrg", MySqlDbType.String, 50), new MySqlParameter("@ReferralContacts", MySqlDbType.String, 100), new MySqlParameter("@ReferralResult", MySqlDbType.String, 1) //new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.CustomerID; cmdParms[1].Value = model.RecordID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.FollowupDate; cmdParms[4].Value = model.Healthcondition; cmdParms[5].Value = model.Mentalcondition; cmdParms[6].Value = model.Hbloodpressure; cmdParms[7].Value = model.LBloodPressure; cmdParms[8].Value = model.Breast; cmdParms[9].Value = model.BreastEx; cmdParms[10].Value = model.Lochia; cmdParms[11].Value = model.LochiaEx; cmdParms[12].Value = model.Uterus; cmdParms[13].Value = model.UterusEx; cmdParms[14].Value = model.Wound; cmdParms[15].Value = model.WoundEx; cmdParms[16].Value = model.Other; cmdParms[17].Value = model.Classification; cmdParms[18].Value = model.ClassificationEx; cmdParms[19].Value = model.Advising; cmdParms[20].Value = model.AdvisingOther; cmdParms[21].Value = model.Treat; cmdParms[22].Value = model.ReferralReason; cmdParms[23].Value = model.ReferralOrg; cmdParms[24].Value = model.NextFollowUpDate; cmdParms[25].Value = model.FollowUpDoctor; cmdParms[26].Value = model.CreatedBy; cmdParms[27].Value = model.CreatedDate; cmdParms[28].Value = model.LastUpdateBy; cmdParms[29].Value = model.LastUpDate; cmdParms[30].Value = model.IsDel; cmdParms[31].Value = model.DeliveryDate; cmdParms[32].Value = model.LeaveHospitalDate; cmdParms[33].Value = model.CheckOrg; cmdParms[34].Value = model.ReferralContacts; cmdParms[35].Value = model.ReferralResult; //cmdParms[31].Value = model.ID; return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0); }
public WomenGravidaPostpartum42DayModel DataRowToModel(DataRow row) { WomenGravidaPostpartum42DayModel gravida_postpartum_day = new WomenGravidaPostpartum42DayModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { gravida_postpartum_day.ID = int.Parse(row["ID"].ToString()); } if ((row["CustomerID"] != null) && (row["CustomerID"] != DBNull.Value)) { gravida_postpartum_day.CustomerID = row["CustomerID"].ToString(); } if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value)) { gravida_postpartum_day.RecordID = row["RecordID"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { gravida_postpartum_day.IDCardNo = row["IDCardNo"].ToString(); } if (((row["FollowupDate"] != null) && (row["FollowupDate"] != DBNull.Value)) && (row["FollowupDate"].ToString() != "")) { gravida_postpartum_day.FollowupDate = new DateTime?(DateTime.Parse(row["FollowupDate"].ToString())); } if ((row["Healthcondition"] != null) && (row["Healthcondition"] != DBNull.Value)) { gravida_postpartum_day.Healthcondition = row["Healthcondition"].ToString(); } if ((row["Mentalcondition"] != null) && (row["Mentalcondition"] != DBNull.Value)) { gravida_postpartum_day.Mentalcondition = row["Mentalcondition"].ToString(); } if (((row["Hbloodpressure"] != null) && (row["Hbloodpressure"] != DBNull.Value)) && (row["Hbloodpressure"].ToString() != "")) { gravida_postpartum_day.Hbloodpressure = new decimal?(decimal.Parse(row["Hbloodpressure"].ToString())); } if (((row["LBloodPressure"] != null) && (row["LBloodPressure"] != DBNull.Value)) && (row["LBloodPressure"].ToString() != "")) { gravida_postpartum_day.LBloodPressure = new decimal?(decimal.Parse(row["LBloodPressure"].ToString())); } if ((row["Breast"] != null) && (row["Breast"] != DBNull.Value)) { gravida_postpartum_day.Breast = row["Breast"].ToString(); } if ((row["BreastEx"] != null) && (row["BreastEx"] != DBNull.Value)) { gravida_postpartum_day.BreastEx = row["BreastEx"].ToString(); } if ((row["Lochia"] != null) && (row["Lochia"] != DBNull.Value)) { gravida_postpartum_day.Lochia = row["Lochia"].ToString(); } if ((row["LochiaEx"] != null) && (row["LochiaEx"] != DBNull.Value)) { gravida_postpartum_day.LochiaEx = row["LochiaEx"].ToString(); } if ((row["Uterus"] != null) && (row["Uterus"] != DBNull.Value)) { gravida_postpartum_day.Uterus = row["Uterus"].ToString(); } if ((row["UterusEx"] != null) && (row["UterusEx"] != DBNull.Value)) { gravida_postpartum_day.UterusEx = row["UterusEx"].ToString(); } if ((row["Wound"] != null) && (row["Wound"] != DBNull.Value)) { gravida_postpartum_day.Wound = row["Wound"].ToString(); } if ((row["WoundEx"] != null) && (row["WoundEx"] != DBNull.Value)) { gravida_postpartum_day.WoundEx = row["WoundEx"].ToString(); } if ((row["Other"] != null) && (row["Other"] != DBNull.Value)) { gravida_postpartum_day.Other = row["Other"].ToString(); } if ((row["Classification"] != null) && (row["Classification"] != DBNull.Value)) { gravida_postpartum_day.Classification = row["Classification"].ToString(); } if ((row["ClassificationEx"] != null) && (row["ClassificationEx"] != DBNull.Value)) { gravida_postpartum_day.ClassificationEx = row["ClassificationEx"].ToString(); } if ((row["Advising"] != null) && (row["Advising"] != DBNull.Value)) { gravida_postpartum_day.Advising = row["Advising"].ToString(); } if ((row["AdvisingOther"] != null) && (row["AdvisingOther"] != DBNull.Value)) { gravida_postpartum_day.AdvisingOther = row["AdvisingOther"].ToString(); } if ((row["Treat"] != null) && (row["Treat"] != DBNull.Value)) { gravida_postpartum_day.Treat = row["Treat"].ToString(); } if ((row["ReferralReason"] != null) && (row["ReferralReason"] != DBNull.Value)) { gravida_postpartum_day.ReferralReason = row["ReferralReason"].ToString(); } if ((row["ReferralOrg"] != null) && (row["ReferralOrg"] != DBNull.Value)) { gravida_postpartum_day.ReferralOrg = row["ReferralOrg"].ToString(); } if (((row["NextFollowUpDate"] != null) && (row["NextFollowUpDate"] != DBNull.Value)) && (row["NextFollowUpDate"].ToString() != "")) { gravida_postpartum_day.NextFollowUpDate = new DateTime?(DateTime.Parse(row["NextFollowUpDate"].ToString())); } if ((row["FollowUpDoctor"] != null) && (row["FollowUpDoctor"] != DBNull.Value)) { gravida_postpartum_day.FollowUpDoctor = row["FollowUpDoctor"].ToString(); } if (((row["CreatedBy"] != null) && (row["CreatedBy"] != DBNull.Value)) && (row["CreatedBy"].ToString() != "")) { gravida_postpartum_day.CreatedBy = new decimal?(decimal.Parse(row["CreatedBy"].ToString())); } if (((row["CreatedDate"] != null) && (row["CreatedDate"] != DBNull.Value)) && (row["CreatedDate"].ToString() != "")) { gravida_postpartum_day.CreatedDate = new DateTime?(DateTime.Parse(row["CreatedDate"].ToString())); } if (((row["LastUpdateBy"] != null) && (row["LastUpdateBy"] != DBNull.Value)) && (row["LastUpdateBy"].ToString() != "")) { gravida_postpartum_day.LastUpdateBy = new decimal?(decimal.Parse(row["LastUpdateBy"].ToString())); } if (((row["LastUpDate"] != null) && (row["LastUpDate"] != DBNull.Value)) && (row["LastUpDate"].ToString() != "")) { gravida_postpartum_day.LastUpDate = new DateTime?(DateTime.Parse(row["LastUpDate"].ToString())); } if ((row["IsDel"] != null) && (row["IsDel"] != DBNull.Value)) { gravida_postpartum_day.IsDel = row["IsDel"].ToString(); } if (((row["DeliveryDate"] != null) && (row["DeliveryDate"] != DBNull.Value)) && (row["DeliveryDate"].ToString() != "")) { gravida_postpartum_day.DeliveryDate = new DateTime?(DateTime.Parse(row["DeliveryDate"].ToString())); } if (((row["LeaveHospitalDate"] != null) && (row["LeaveHospitalDate"] != DBNull.Value)) && (row["LeaveHospitalDate"].ToString() != "")) { gravida_postpartum_day.LeaveHospitalDate = new DateTime?(DateTime.Parse(row["LeaveHospitalDate"].ToString())); } if ((row["CheckOrg"] != null) && (row["CheckOrg"] != DBNull.Value)) { gravida_postpartum_day.CheckOrg = row["CheckOrg"].ToString(); } if ((row["ReferralContacts"] != null) && (row["ReferralContacts"] != DBNull.Value)) { gravida_postpartum_day.ReferralContacts = row["ReferralContacts"].ToString(); } if ((row["ReferralResult"] != null) && (row["ReferralResult"] != DBNull.Value)) { gravida_postpartum_day.ReferralResult = row["ReferralResult"].ToString(); } } return(gravida_postpartum_day); }
public int Add(WomenGravidaPostpartum42DayModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into GRAVIDA_POSTPARTUM_42DAY("); builder.Append("CustomerID,RecordID,IDCardNo,FollowupDate,Healthcondition,Mentalcondition,Hbloodpressure,LBloodPressure,Breast,BreastEx,Lochia,LochiaEx,Uterus,UterusEx,Wound,WoundEx,Other,Classification,ClassificationEx,Advising,AdvisingOther,Treat,ReferralReason,ReferralOrg,NextFollowUpDate,FollowUpDoctor,CreatedBy,CreatedDate,LastUpdateBy,LastUpDate,IsDel,"); builder.Append("DeliveryDate,LeaveHospitalDate,CheckOrg,ReferralContacts,ReferralResult)"); builder.Append(" values ("); builder.Append("@CustomerID,@RecordID,@IDCardNo,@FollowupDate,@Healthcondition,@Mentalcondition,@Hbloodpressure,@LBloodPressure,@Breast,@BreastEx,@Lochia,@LochiaEx,@Uterus,@UterusEx,@Wound,@WoundEx,@Other,@Classification,@ClassificationEx,@Advising,@AdvisingOther,@Treat,@ReferralReason,@ReferralOrg,@NextFollowUpDate,@FollowUpDoctor,@CreatedBy,@CreatedDate,@LastUpdateBy,@LastUpDate,@IsDel,"); builder.Append("@DeliveryDate,@LeaveHospitalDate,@CheckOrg,@ReferralContacts,@ReferralResult)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@CustomerID", MySqlDbType.String, 0x20), new MySqlParameter("@RecordID", MySqlDbType.String, 0x11), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@FollowupDate", MySqlDbType.Date), new MySqlParameter("@Healthcondition", MySqlDbType.String, 200), new MySqlParameter("@Mentalcondition", MySqlDbType.String, 200), new MySqlParameter("@Hbloodpressure", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@LBloodPressure", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@Breast", MySqlDbType.String, 1), new MySqlParameter("@BreastEx", MySqlDbType.String, 200), new MySqlParameter("@Lochia", MySqlDbType.String, 1), new MySqlParameter("@LochiaEx", MySqlDbType.String, 200), new MySqlParameter("@Uterus", MySqlDbType.String, 1), new MySqlParameter("@UterusEx", MySqlDbType.String, 200), new MySqlParameter("@Wound", MySqlDbType.String, 1), new MySqlParameter("@WoundEx", MySqlDbType.String, 200), new MySqlParameter("@Other", MySqlDbType.String, 500), new MySqlParameter("@Classification", MySqlDbType.String, 1), new MySqlParameter("@ClassificationEx", MySqlDbType.String, 200), new MySqlParameter("@Advising", MySqlDbType.String, 30), new MySqlParameter("@AdvisingOther", MySqlDbType.String, 200), new MySqlParameter("@Treat", MySqlDbType.String, 1), new MySqlParameter("@ReferralReason", MySqlDbType.String, 500), new MySqlParameter("@ReferralOrg", MySqlDbType.String, 80), new MySqlParameter("@NextFollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 30), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal, 0x7fffffff), new MySqlParameter("@LastUpDate", MySqlDbType.Date), new MySqlParameter("@IsDel", MySqlDbType.String, 1), new MySqlParameter("@DeliveryDate", MySqlDbType.Date), new MySqlParameter("@LeaveHospitalDate", MySqlDbType.Date), new MySqlParameter("@CheckOrg", MySqlDbType.String, 50), new MySqlParameter("@ReferralContacts", MySqlDbType.String, 100), new MySqlParameter("@ReferralResult", MySqlDbType.String, 1) }; cmdParms[0].Value = model.CustomerID; cmdParms[1].Value = model.RecordID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.FollowupDate; cmdParms[4].Value = model.Healthcondition; cmdParms[5].Value = model.Mentalcondition; cmdParms[6].Value = model.Hbloodpressure; cmdParms[7].Value = model.LBloodPressure; cmdParms[8].Value = model.Breast; cmdParms[9].Value = model.BreastEx; cmdParms[10].Value = model.Lochia; cmdParms[11].Value = model.LochiaEx; cmdParms[12].Value = model.Uterus; cmdParms[13].Value = model.UterusEx; cmdParms[14].Value = model.Wound; cmdParms[15].Value = model.WoundEx; cmdParms[16].Value = model.Other; cmdParms[17].Value = model.Classification; cmdParms[18].Value = model.ClassificationEx; cmdParms[19].Value = model.Advising; cmdParms[20].Value = model.AdvisingOther; cmdParms[21].Value = model.Treat; cmdParms[22].Value = model.ReferralReason; cmdParms[23].Value = model.ReferralOrg; cmdParms[24].Value = model.NextFollowUpDate; cmdParms[25].Value = model.FollowUpDoctor; cmdParms[26].Value = model.CreatedBy; cmdParms[27].Value = model.CreatedDate; cmdParms[28].Value = model.LastUpdateBy; cmdParms[29].Value = model.LastUpDate; cmdParms[30].Value = model.IsDel; cmdParms[31].Value = model.DeliveryDate; cmdParms[32].Value = model.LeaveHospitalDate; cmdParms[33].Value = model.CheckOrg; cmdParms[34].Value = model.ReferralContacts; cmdParms[35].Value = model.ReferralResult; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }