public RecordsMedicineCnModel RecordDataRowToModel(DataRow row) { RecordsMedicineCnModel records_medicine_cn = new RecordsMedicineCnModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { records_medicine_cn.ID = int.Parse(row["ID"].ToString()); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { records_medicine_cn.IDCardNo = row["IDCardNo"].ToString(); } if (((row["Energy"] != null) && (row["Energy"] != DBNull.Value)) && (row["Energy"].ToString() != "")) { records_medicine_cn.Energy = new decimal?(decimal.Parse(row["Energy"].ToString())); } if (((row["Tired"] != null) && (row["Tired"] != DBNull.Value)) && (row["Tired"].ToString() != "")) { records_medicine_cn.Tired = new decimal?(decimal.Parse(row["Tired"].ToString())); } if (((row["Breath"] != null) && (row["Breath"] != DBNull.Value)) && (row["Breath"].ToString() != "")) { records_medicine_cn.Breath = new decimal?(decimal.Parse(row["Breath"].ToString())); } if (((row["Voice"] != null) && (row["Voice"] != DBNull.Value)) && (row["Voice"].ToString() != "")) { records_medicine_cn.Voice = new decimal?(decimal.Parse(row["Voice"].ToString())); } if (((row["Emotion"] != null) && (row["Emotion"] != DBNull.Value)) && (row["Emotion"].ToString() != "")) { records_medicine_cn.Emotion = new decimal?(decimal.Parse(row["Emotion"].ToString())); } if (((row["Spirit"] != null) && (row["Spirit"] != DBNull.Value)) && (row["Spirit"].ToString() != "")) { records_medicine_cn.Spirit = new decimal?(decimal.Parse(row["Spirit"].ToString())); } if (((row["Alone"] != null) && (row["Alone"] != DBNull.Value)) && (row["Alone"].ToString() != "")) { records_medicine_cn.Alone = new decimal?(decimal.Parse(row["Alone"].ToString())); } if (((row["Fear"] != null) && (row["Fear"] != DBNull.Value)) && (row["Fear"].ToString() != "")) { records_medicine_cn.Fear = new decimal?(decimal.Parse(row["Fear"].ToString())); } if (((row["Weight"] != null) && (row["Weight"] != DBNull.Value)) && (row["Weight"].ToString() != "")) { records_medicine_cn.Weight = new decimal?(decimal.Parse(row["Weight"].ToString())); } if (((row["Eye"] != null) && (row["Eye"] != DBNull.Value)) && (row["Eye"].ToString() != "")) { records_medicine_cn.Eye = new decimal?(decimal.Parse(row["Eye"].ToString())); } if (((row["FootHand"] != null) && (row["FootHand"] != DBNull.Value)) && (row["FootHand"].ToString() != "")) { records_medicine_cn.FootHand = new decimal?(decimal.Parse(row["FootHand"].ToString())); } if (((row["Stomach"] != null) && (row["Stomach"] != DBNull.Value)) && (row["Stomach"].ToString() != "")) { records_medicine_cn.Stomach = new decimal?(decimal.Parse(row["Stomach"].ToString())); } if (((row["Cold"] != null) && (row["Cold"] != DBNull.Value)) && (row["Cold"].ToString() != "")) { records_medicine_cn.Cold = new decimal?(decimal.Parse(row["Cold"].ToString())); } if (((row["Influenza"] != null) && (row["Influenza"] != DBNull.Value)) && (row["Influenza"].ToString() != "")) { records_medicine_cn.Influenza = new decimal?(decimal.Parse(row["Influenza"].ToString())); } if (((row["Nasal"] != null) && (row["Nasal"] != DBNull.Value)) && (row["Nasal"].ToString() != "")) { records_medicine_cn.Nasal = new decimal?(decimal.Parse(row["Nasal"].ToString())); } if (((row["Snore"] != null) && (row["Snore"] != DBNull.Value)) && (row["Snore"].ToString() != "")) { records_medicine_cn.Snore = new decimal?(decimal.Parse(row["Snore"].ToString())); } if (((row["Allergy"] != null) && (row["Allergy"] != DBNull.Value)) && (row["Allergy"].ToString() != "")) { records_medicine_cn.Allergy = new decimal?(decimal.Parse(row["Allergy"].ToString())); } if (((row["Urticaria"] != null) && (row["Urticaria"] != DBNull.Value)) && (row["Urticaria"].ToString() != "")) { records_medicine_cn.Urticaria = new decimal?(decimal.Parse(row["Urticaria"].ToString())); } if (((row["Skin"] != null) && (row["Skin"] != DBNull.Value)) && (row["Skin"].ToString() != "")) { records_medicine_cn.Skin = new decimal?(decimal.Parse(row["Skin"].ToString())); } if (((row["Scratch"] != null) && (row["Scratch"] != DBNull.Value)) && (row["Scratch"].ToString() != "")) { records_medicine_cn.Scratch = new decimal?(decimal.Parse(row["Scratch"].ToString())); } if (((row["Mouth"] != null) && (row["Mouth"] != DBNull.Value)) && (row["Mouth"].ToString() != "")) { records_medicine_cn.Mouth = new decimal?(decimal.Parse(row["Mouth"].ToString())); } if (((row["Arms"] != null) && (row["Arms"] != DBNull.Value)) && (row["Arms"].ToString() != "")) { records_medicine_cn.Arms = new decimal?(decimal.Parse(row["Arms"].ToString())); } if (((row["Greasy"] != null) && (row["Greasy"] != DBNull.Value)) && (row["Greasy"].ToString() != "")) { records_medicine_cn.Greasy = new decimal?(decimal.Parse(row["Greasy"].ToString())); } if (((row["Spot"] != null) && (row["Spot"] != DBNull.Value)) && (row["Spot"].ToString() != "")) { records_medicine_cn.Spot = new decimal?(decimal.Parse(row["Spot"].ToString())); } if (((row["Eczema"] != null) && (row["Eczema"] != DBNull.Value)) && (row["Eczema"].ToString() != "")) { records_medicine_cn.Eczema = new decimal?(decimal.Parse(row["Eczema"].ToString())); } if (((row["Thirsty"] != null) && (row["Thirsty"] != DBNull.Value)) && (row["Thirsty"].ToString() != "")) { records_medicine_cn.Thirsty = new decimal?(decimal.Parse(row["Thirsty"].ToString())); } if (((row["Smell"] != null) && (row["Smell"] != DBNull.Value)) && (row["Smell"].ToString() != "")) { records_medicine_cn.Smell = new decimal?(decimal.Parse(row["Smell"].ToString())); } if (((row["Abdomen"] != null) && (row["Abdomen"] != DBNull.Value)) && (row["Abdomen"].ToString() != "")) { records_medicine_cn.Abdomen = new decimal?(decimal.Parse(row["Abdomen"].ToString())); } if (((row["Coolfood"] != null) && (row["Coolfood"] != DBNull.Value)) && (row["Coolfood"].ToString() != "")) { records_medicine_cn.Coolfood = new decimal?(decimal.Parse(row["Coolfood"].ToString())); } if (((row["Defecate"] != null) && (row["Defecate"] != DBNull.Value)) && (row["Defecate"].ToString() != "")) { records_medicine_cn.Defecate = new decimal?(decimal.Parse(row["Defecate"].ToString())); } if (((row["Defecatedry"] != null) && (row["Defecatedry"] != DBNull.Value)) && (row["Defecatedry"].ToString() != "")) { records_medicine_cn.Defecatedry = new decimal?(decimal.Parse(row["Defecatedry"].ToString())); } if (((row["Tongue"] != null) && (row["Tongue"] != DBNull.Value)) && (row["Tongue"].ToString() != "")) { records_medicine_cn.Tongue = new decimal?(decimal.Parse(row["Tongue"].ToString())); } if (((row["Vein"] != null) && (row["Vein"] != DBNull.Value)) && (row["Vein"].ToString() != "")) { records_medicine_cn.Vein = new decimal?(decimal.Parse(row["Vein"].ToString())); } //if (((row["RecordDate"] != null) && (row["RecordDate"] != DBNull.Value)) && (row["RecordDate"].ToString() != "")) //{ // records_medicine_cn.RecordDate = new DateTime?(DateTime.Parse(row["RecordDate"].ToString())); //} if ((row["RecordDate"] != null) && (row["RecordDate"] != DBNull.Value)) { records_medicine_cn.RecordDate = row["RecordDate"].ToString(); } } return(records_medicine_cn); }
public bool Update(RecordsMedicineCnModel model) { return(this.dal.Update(model)); }
public bool Update(RecordsMedicineCnModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_MEDICINE_CN set "); builder.Append("RecordID=@RecordID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("CustomerID=@CustomerID,"); builder.Append("PhysicalID=@PhysicalID,"); builder.Append("Energy=@Energy,"); builder.Append("Tired=@Tired,"); builder.Append("Breath=@Breath,"); builder.Append("Voice=@Voice,"); builder.Append("Emotion=@Emotion,"); builder.Append("Spirit=@Spirit,"); builder.Append("Alone=@Alone,"); builder.Append("Fear=@Fear,"); builder.Append("Weight=@Weight,"); builder.Append("Eye=@Eye,"); builder.Append("FootHand=@FootHand,"); builder.Append("Stomach=@Stomach,"); builder.Append("Cold=@Cold,"); builder.Append("Influenza=@Influenza,"); builder.Append("Nasal=@Nasal,"); builder.Append("Snore=@Snore,"); builder.Append("Allergy=@Allergy,"); builder.Append("Urticaria=@Urticaria,"); builder.Append("Skin=@Skin,"); builder.Append("Scratch=@Scratch,"); builder.Append("Mouth=@Mouth,"); builder.Append("Arms=@Arms,"); builder.Append("Greasy=@Greasy,"); builder.Append("Spot=@Spot,"); builder.Append("Eczema=@Eczema,"); builder.Append("Thirsty=@Thirsty,"); builder.Append("Smell=@Smell,"); builder.Append("Abdomen=@Abdomen,"); builder.Append("Coolfood=@Coolfood,"); builder.Append("Defecate=@Defecate,"); builder.Append("Defecatedry=@Defecatedry,"); builder.Append("Tongue=@Tongue,"); builder.Append("Vein=@Vein,"); builder.Append("CreatedBy=@CreatedBy,"); builder.Append("CreatedDate=@CreatedDate,"); builder.Append("LastUpdateBy=@LastUpdateBy,"); builder.Append("LastUpdateDate=@LastUpdateDate,"); builder.Append("FollowUpDoctor=@FollowUpDoctor,"); builder.Append("RecordDate=@RecordDate,"); builder.Append("IsDel=@IsDel"); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@CustomerID", MySqlDbType.String, 17), new MySqlParameter("@PhysicalID", MySqlDbType.String, 17), new MySqlParameter("@Energy", MySqlDbType.Decimal), new MySqlParameter("@Tired", MySqlDbType.Decimal), new MySqlParameter("@Breath", MySqlDbType.Decimal), new MySqlParameter("@Voice", MySqlDbType.Decimal), new MySqlParameter("@Emotion", MySqlDbType.Decimal), new MySqlParameter("@Spirit", MySqlDbType.Decimal), new MySqlParameter("@Alone", MySqlDbType.Decimal), new MySqlParameter("@Fear", MySqlDbType.Decimal), new MySqlParameter("@Weight", MySqlDbType.Decimal), new MySqlParameter("@Eye", MySqlDbType.Decimal), new MySqlParameter("@FootHand", MySqlDbType.Decimal), new MySqlParameter("@Stomach", MySqlDbType.Decimal), new MySqlParameter("@Cold", MySqlDbType.Decimal), new MySqlParameter("@Influenza", MySqlDbType.Decimal), new MySqlParameter("@Nasal", MySqlDbType.Decimal), new MySqlParameter("@Snore", MySqlDbType.Decimal), new MySqlParameter("@Allergy", MySqlDbType.Decimal), new MySqlParameter("@Urticaria", MySqlDbType.Decimal), new MySqlParameter("@Skin", MySqlDbType.Decimal), new MySqlParameter("@Scratch", MySqlDbType.Decimal), new MySqlParameter("@Mouth", MySqlDbType.Decimal), new MySqlParameter("@Arms", MySqlDbType.Decimal), new MySqlParameter("@Greasy", MySqlDbType.Decimal), new MySqlParameter("@Spot", MySqlDbType.Decimal), new MySqlParameter("@Eczema", MySqlDbType.Decimal), new MySqlParameter("@Thirsty", MySqlDbType.Decimal), new MySqlParameter("@Smell", MySqlDbType.Decimal), new MySqlParameter("@Abdomen", MySqlDbType.Decimal), new MySqlParameter("@Coolfood", MySqlDbType.Decimal), new MySqlParameter("@Defecate", MySqlDbType.Decimal), new MySqlParameter("@Defecatedry", MySqlDbType.Decimal), new MySqlParameter("@Tongue", MySqlDbType.Decimal), new MySqlParameter("@Vein", MySqlDbType.Decimal), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal), new MySqlParameter("@LastUpdateDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 20), new MySqlParameter("@RecordDate", MySqlDbType.Date), new MySqlParameter("@IsDel", MySqlDbType.String, 1), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.RecordID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.CustomerID; cmdParms[3].Value = model.PhysicalID; cmdParms[4].Value = model.Energy; cmdParms[5].Value = model.Tired; cmdParms[6].Value = model.Breath; cmdParms[7].Value = model.Voice; cmdParms[8].Value = model.Emotion; cmdParms[9].Value = model.Spirit; cmdParms[10].Value = model.Alone; cmdParms[11].Value = model.Fear; cmdParms[12].Value = model.Weight; cmdParms[13].Value = model.Eye; cmdParms[14].Value = model.FootHand; cmdParms[15].Value = model.Stomach; cmdParms[16].Value = model.Cold; cmdParms[17].Value = model.Influenza; cmdParms[18].Value = model.Nasal; cmdParms[19].Value = model.Snore; cmdParms[20].Value = model.Allergy; cmdParms[21].Value = model.Urticaria; cmdParms[22].Value = model.Skin; cmdParms[23].Value = model.Scratch; cmdParms[24].Value = model.Mouth; cmdParms[25].Value = model.Arms; cmdParms[26].Value = model.Greasy; cmdParms[27].Value = model.Spot; cmdParms[28].Value = model.Eczema; cmdParms[29].Value = model.Thirsty; cmdParms[30].Value = model.Smell; cmdParms[31].Value = model.Abdomen; cmdParms[32].Value = model.Coolfood; cmdParms[33].Value = model.Defecate; cmdParms[34].Value = model.Defecatedry; cmdParms[35].Value = model.Tongue; cmdParms[36].Value = model.Vein; cmdParms[37].Value = model.CreatedBy; cmdParms[38].Value = model.CreatedDate; cmdParms[39].Value = model.LastUpdateBy; cmdParms[40].Value = model.LastUpdateDate; cmdParms[41].Value = model.FollowUpDoctor; cmdParms[42].Value = model.RecordDate; cmdParms[43].Value = model.IsDel; cmdParms[44].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public int Add(RecordsMedicineCnModel model) { return(this.dal.Add(model)); }
public int Add(RecordsMedicineCnModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_MEDICINE_CN("); builder.Append("RecordID,IDCardNo,CustomerID,PhysicalID,Energy,Tired,Breath,Voice,Emotion,Spirit,Alone,Fear,"); builder.Append("Weight,Eye,FootHand,Stomach,Cold,Influenza,Nasal,Snore,Allergy,Urticaria,Skin,Scratch,Mouth,"); builder.Append("Arms,Greasy,Spot,Eczema,Thirsty,Smell,Abdomen,Coolfood,Defecate,Defecatedry,Tongue,Vein,"); builder.Append("CreatedBy,CreatedDate,LastUpdateBy,LastUpdateDate,FollowUpDoctor,RecordDate,IsDel)"); builder.Append(" values ("); builder.Append("@RecordID,@IDCardNo,@CustomerID,@PhysicalID,@Energy,@Tired,@Breath,@Voice,@Emotion,@Spirit,@Alone,@Fear,"); builder.Append("@Weight,@Eye,@FootHand,@Stomach,@Cold,@Influenza,@Nasal,@Snore,@Allergy,@Urticaria,@Skin,@Scratch,@Mouth,"); builder.Append("@Arms,@Greasy,@Spot,@Eczema,@Thirsty,@Smell,@Abdomen,@Coolfood,@Defecate,@Defecatedry,@Tongue,@Vein,"); builder.Append("@CreatedBy,@CreatedDate,@LastUpdateBy,@LastUpdateDate,@FollowUpDoctor,@RecordDate,@IsDel)"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@CustomerID", MySqlDbType.String, 17), new MySqlParameter("@PhysicalID", MySqlDbType.String, 17), new MySqlParameter("@Energy", MySqlDbType.Decimal), new MySqlParameter("@Tired", MySqlDbType.Decimal), new MySqlParameter("@Breath", MySqlDbType.Decimal), new MySqlParameter("@Voice", MySqlDbType.Decimal), new MySqlParameter("@Emotion", MySqlDbType.Decimal), new MySqlParameter("@Spirit", MySqlDbType.Decimal), new MySqlParameter("@Alone", MySqlDbType.Decimal), new MySqlParameter("@Fear", MySqlDbType.Decimal), new MySqlParameter("@Weight", MySqlDbType.Decimal), new MySqlParameter("@Eye", MySqlDbType.Decimal), new MySqlParameter("@FootHand", MySqlDbType.Decimal), new MySqlParameter("@Stomach", MySqlDbType.Decimal), new MySqlParameter("@Cold", MySqlDbType.Decimal), new MySqlParameter("@Influenza", MySqlDbType.Decimal), new MySqlParameter("@Nasal", MySqlDbType.Decimal), new MySqlParameter("@Snore", MySqlDbType.Decimal), new MySqlParameter("@Allergy", MySqlDbType.Decimal), new MySqlParameter("@Urticaria", MySqlDbType.Decimal), new MySqlParameter("@Skin", MySqlDbType.Decimal), new MySqlParameter("@Scratch", MySqlDbType.Decimal), new MySqlParameter("@Mouth", MySqlDbType.Decimal), new MySqlParameter("@Arms", MySqlDbType.Decimal), new MySqlParameter("@Greasy", MySqlDbType.Decimal), new MySqlParameter("@Spot", MySqlDbType.Decimal), new MySqlParameter("@Eczema", MySqlDbType.Decimal), new MySqlParameter("@Thirsty", MySqlDbType.Decimal), new MySqlParameter("@Smell", MySqlDbType.Decimal), new MySqlParameter("@Abdomen", MySqlDbType.Decimal), new MySqlParameter("@Coolfood", MySqlDbType.Decimal), new MySqlParameter("@Defecate", MySqlDbType.Decimal), new MySqlParameter("@Defecatedry", MySqlDbType.Decimal), new MySqlParameter("@Tongue", MySqlDbType.Decimal), new MySqlParameter("@Vein", MySqlDbType.Decimal), new MySqlParameter("@CreatedBy", MySqlDbType.Decimal), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal), new MySqlParameter("@LastUpdateDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 20), new MySqlParameter("@RecordDate", MySqlDbType.Date), new MySqlParameter("@IsDel", MySqlDbType.String, 1) }; cmdParms[0].Value = model.RecordID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.CustomerID; cmdParms[3].Value = model.PhysicalID; cmdParms[4].Value = model.Energy; cmdParms[5].Value = model.Tired; cmdParms[6].Value = model.Breath; cmdParms[7].Value = model.Voice; cmdParms[8].Value = model.Emotion; cmdParms[9].Value = model.Spirit; cmdParms[10].Value = model.Alone; cmdParms[11].Value = model.Fear; cmdParms[12].Value = model.Weight; cmdParms[13].Value = model.Eye; cmdParms[14].Value = model.FootHand; cmdParms[15].Value = model.Stomach; cmdParms[16].Value = model.Cold; cmdParms[17].Value = model.Influenza; cmdParms[18].Value = model.Nasal; cmdParms[19].Value = model.Snore; cmdParms[20].Value = model.Allergy; cmdParms[21].Value = model.Urticaria; cmdParms[22].Value = model.Skin; cmdParms[23].Value = model.Scratch; cmdParms[24].Value = model.Mouth; cmdParms[25].Value = model.Arms; cmdParms[26].Value = model.Greasy; cmdParms[27].Value = model.Spot; cmdParms[28].Value = model.Eczema; cmdParms[29].Value = model.Thirsty; cmdParms[30].Value = model.Smell; cmdParms[31].Value = model.Abdomen; cmdParms[32].Value = model.Coolfood; cmdParms[33].Value = model.Defecate; cmdParms[34].Value = model.Defecatedry; cmdParms[35].Value = model.Tongue; cmdParms[36].Value = model.Vein; cmdParms[37].Value = model.CreatedBy; cmdParms[38].Value = model.CreatedDate; cmdParms[39].Value = model.LastUpdateBy; cmdParms[40].Value = model.LastUpdateDate; cmdParms[41].Value = model.FollowUpDoctor; cmdParms[42].Value = model.RecordDate; cmdParms[43].Value = model.IsDel; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }