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