public ALS.Model.treatmentmode GetModel(string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select ID,name,BPSpeed,BPDirection,BPValid,FPSpeed,FPDirection,FPValid,DPSpeed,DPDirection,DPValid,RPSpeed,RPDirection,RPValid,FP2Speed,FP2Direction,FP2Valid,CPSpeed,CPDirection,CPValid,dehydrationSpeed,dehydrationValid,TargetTimeH,TargetTimeMin,IsTargetTime,TargetBP,IsTargetBP,TargetDP,IsTargetDP,TargetSP,IsTargetSP,TargetRP,IsTargetRP,TargetFP,IsTargetFP,Concentration,SP_Speed,SP_RapidInjectionValue,TargetT,PaccUpper,PaccLower,PartUpper,PartLower,PvenUpper,PvenLower,P1stUpper,P1stLower,P2ndUpper,P2ndLower,TmpUpper,TmpLower,PrePaccLower,PrePvenUpper,BloodLeak,PrePartUpper,P3rdLower,P3rdUpper,LeadBloodSpeed,LeadBloodTime,PaccDecrement from tb_treatmentmode ");
strSql.Append(" where name=@name");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar)
};
parameters[0].Value = name;
ALS.Model.treatmentmode model = new ALS.Model.treatmentmode();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ALS.Model.treatmentmode DataRowToModel(DataRow row)
{
ALS.Model.treatmentmode model = new ALS.Model.treatmentmode();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = long.Parse(row["ID"].ToString());
}
if (row["name"] != null)
{
model.name = row["name"].ToString();
}
model.BPSpeed = Convert.ToDouble(row["BPSpeed"].ToString());
if (row["BPDirection"] != null && row["BPDirection"].ToString() != "")
{
if ((row["BPDirection"].ToString() == "1") || (row["BPDirection"].ToString().ToLower() == "true"))
{
model.BPDirection = true;
}
else
{
model.BPDirection = false;
}
}
if (row["BPValid"] != null && row["BPValid"].ToString() != "")
{
if ((row["BPValid"].ToString() == "1") || (row["BPValid"].ToString().ToLower() == "true"))
{
model.BPValid = true;
}
else
{
model.BPValid = false;
}
}
model.FPSpeed = Convert.ToDouble(row["FPSpeed"].ToString());
if (row["FPDirection"] != null && row["FPDirection"].ToString() != "")
{
if ((row["FPDirection"].ToString() == "1") || (row["FPDirection"].ToString().ToLower() == "true"))
{
model.FPDirection = true;
}
else
{
model.FPDirection = false;
}
}
if (row["FPValid"] != null && row["FPValid"].ToString() != "")
{
if ((row["FPValid"].ToString() == "1") || (row["FPValid"].ToString().ToLower() == "true"))
{
model.FPValid = true;
}
else
{
model.FPValid = false;
}
}
model.DPSpeed = Convert.ToDouble(row["DPSpeed"].ToString());
if (row["DPDirection"] != null && row["DPDirection"].ToString() != "")
{
if ((row["DPDirection"].ToString() == "1") || (row["DPDirection"].ToString().ToLower() == "true"))
{
model.DPDirection = true;
}
else
{
model.DPDirection = false;
}
}
if (row["DPValid"] != null && row["DPValid"].ToString() != "")
{
if ((row["DPValid"].ToString() == "1") || (row["DPValid"].ToString().ToLower() == "true"))
{
model.DPValid = true;
}
else
{
model.DPValid = false;
}
}
model.RPSpeed = Convert.ToDouble(row["RPSpeed"].ToString());
if (row["RPDirection"] != null && row["RPDirection"].ToString() != "")
{
if ((row["RPDirection"].ToString() == "1") || (row["RPDirection"].ToString().ToLower() == "true"))
{
model.RPDirection = true;
}
else
{
model.RPDirection = false;
}
}
if (row["RPValid"] != null && row["RPValid"].ToString() != "")
{
if ((row["RPValid"].ToString() == "1") || (row["RPValid"].ToString().ToLower() == "true"))
{
model.RPValid = true;
}
else
{
model.RPValid = false;
}
}
model.FP2Speed = Convert.ToDouble(row["FP2Speed"].ToString());
if (row["FP2Direction"] != null && row["FP2Direction"].ToString() != "")
{
if ((row["FP2Direction"].ToString() == "1") || (row["FP2Direction"].ToString().ToLower() == "true"))
{
model.FP2Direction = true;
}
else
{
model.FP2Direction = false;
}
}
if (row["FP2Valid"] != null && row["FP2Valid"].ToString() != "")
{
if ((row["FP2Valid"].ToString() == "1") || (row["FP2Valid"].ToString().ToLower() == "true"))
{
model.FP2Valid = true;
}
else
{
model.FP2Valid = false;
}
}
model.CPSpeed = Convert.ToDouble(row["CPSpeed"].ToString());
if (row["CPDirection"] != null && row["CPDirection"].ToString() != "")
{
if ((row["CPDirection"].ToString() == "1") || (row["CPDirection"].ToString().ToLower() == "true"))
{
model.CPDirection = true;
}
else
{
model.CPDirection = false;
}
}
if (row["CPValid"] != null && row["CPValid"].ToString() != "")
{
if ((row["CPValid"].ToString() == "1") || (row["CPValid"].ToString().ToLower() == "true"))
{
model.CPValid = true;
}
else
{
model.CPValid = false;
}
}
model.dehydrationSpeed = Convert.ToDouble(row["dehydrationSpeed"].ToString());
if (row["dehydrationValid"] != null && row["dehydrationValid"].ToString() != "")
{
if ((row["dehydrationValid"].ToString() == "1") || (row["dehydrationValid"].ToString().ToLower() == "true"))
{
model.dehydrationValid = true;
}
else
{
model.dehydrationValid = false;
}
}
if (row["TargetTimeH"] != null && row["TargetTimeH"].ToString() != "")
{
model.TargetTimeH = int.Parse(row["TargetTimeH"].ToString());
}
if (row["TargetTimeMin"] != null && row["TargetTimeMin"].ToString() != "")
{
model.TargetTimeMin = int.Parse(row["TargetTimeMin"].ToString());
}
if (row["IsTargetTime"] != null && row["IsTargetTime"].ToString() != "")
{
if ((row["IsTargetTime"].ToString() == "1") || (row["IsTargetTime"].ToString().ToLower() == "true"))
{
model.IsTargetTime = true;
}
else
{
model.IsTargetTime = false;
}
}
model.TargetBP = Convert.ToDouble(row["TargetBP"].ToString());
if (row["IsTargetBP"] != null && row["IsTargetBP"].ToString() != "")
{
if ((row["IsTargetBP"].ToString() == "1") || (row["IsTargetBP"].ToString().ToLower() == "true"))
{
model.IsTargetBP = true;
}
else
{
model.IsTargetBP = false;
}
}
model.TargetDP = Convert.ToDouble(row["TargetDP"].ToString());
if (row["IsTargetDP"] != null && row["IsTargetDP"].ToString() != "")
{
if ((row["IsTargetDP"].ToString() == "1") || (row["IsTargetDP"].ToString().ToLower() == "true"))
{
model.IsTargetDP = true;
}
else
{
model.IsTargetDP = false;
}
}
model.TargetSP = Convert.ToDouble(row["TargetSP"].ToString());
if (row["IsTargetSP"] != null && row["IsTargetSP"].ToString() != "")
{
if ((row["IsTargetSP"].ToString() == "1") || (row["IsTargetSP"].ToString().ToLower() == "true"))
{
model.IsTargetSP = true;
}
else
{
model.IsTargetSP = false;
}
}
model.TargetRP = Convert.ToDouble(row["TargetRP"].ToString());
if (row["IsTargetRP"] != null && row["IsTargetRP"].ToString() != "")
{
if ((row["IsTargetRP"].ToString() == "1") || (row["IsTargetRP"].ToString().ToLower() == "true"))
{
model.IsTargetRP = true;
}
else
{
model.IsTargetRP = false;
}
}
model.TargetFP = Convert.ToDouble(row["TargetFP"].ToString());
if (row["IsTargetFP"] != null && row["IsTargetFP"].ToString() != "")
{
if ((row["IsTargetFP"].ToString() == "1") || (row["IsTargetFP"].ToString().ToLower() == "true"))
{
model.IsTargetFP = true;
}
else
{
model.IsTargetFP = false;
}
}
model.Concentration = Convert.ToDouble(row["Concentration"].ToString());
model.SP_Speed = Convert.ToDouble(row["SP_Speed"].ToString());
model.SP_RapidInjectionValue = Convert.ToDouble(row["SP_RapidInjectionValue"].ToString());
model.TargetT = Convert.ToDouble(row["TargetT"].ToString());
if (row["PaccUpper"] != null && row["PaccUpper"].ToString() != "")
{
model.PaccUpper = int.Parse(row["PaccUpper"].ToString());
}
if (row["PaccLower"] != null && row["PaccLower"].ToString() != "")
{
model.PaccLower = int.Parse(row["PaccLower"].ToString());
}
if (row["PartUpper"] != null && row["PartUpper"].ToString() != "")
{
model.PartUpper = int.Parse(row["PartUpper"].ToString());
}
if (row["PartLower"] != null && row["PartLower"].ToString() != "")
{
model.PartLower = int.Parse(row["PartLower"].ToString());
}
if (row["PvenUpper"] != null && row["PvenUpper"].ToString() != "")
{
model.PvenUpper = int.Parse(row["PvenUpper"].ToString());
}
if (row["PvenLower"] != null && row["PvenLower"].ToString() != "")
{
model.PvenLower = int.Parse(row["PvenLower"].ToString());
}
if (row["P1stUpper"] != null && row["P1stUpper"].ToString() != "")
{
model.P1stUpper = int.Parse(row["P1stUpper"].ToString());
}
if (row["P1stLower"] != null && row["P1stLower"].ToString() != "")
{
model.P1stLower = int.Parse(row["P1stLower"].ToString());
}
if (row["P2ndUpper"] != null && row["P2ndUpper"].ToString() != "")
{
model.P2ndUpper = int.Parse(row["P2ndUpper"].ToString());
}
if (row["P2ndLower"] != null && row["P2ndLower"].ToString() != "")
{
model.P2ndLower = int.Parse(row["P2ndLower"].ToString());
}
if (row["TmpUpper"] != null && row["TmpUpper"].ToString() != "")
{
model.TmpUpper = int.Parse(row["TmpUpper"].ToString());
}
if (row["TmpLower"] != null && row["TmpLower"].ToString() != "")
{
model.TmpLower = int.Parse(row["TmpLower"].ToString());
}
if (row["PrePaccLower"] != null && row["PrePaccLower"].ToString() != "")
{
model.PrePaccLower = int.Parse(row["PrePaccLower"].ToString());
}
if (row["PrePvenUpper"] != null && row["PrePvenUpper"].ToString() != "")
{
model.PrePvenUpper = int.Parse(row["PrePvenUpper"].ToString());
}
if (row["BloodLeak"] != null && row["BloodLeak"].ToString() != "")
{
model.BloodLeak = int.Parse(row["BloodLeak"].ToString());
}
if (row["PrePartUpper"] != null && row["PrePartUpper"].ToString() != "")
{
model.PrePartUpper = int.Parse(row["PrePartUpper"].ToString());
}
if (row["P3rdLower"] != null && row["P3rdLower"].ToString() != "")
{
model.P3rdLower = int.Parse(row["P3rdLower"].ToString());
}
if (row["P3rdUpper"] != null && row["P3rdUpper"].ToString() != "")
{
model.P3rdUpper = int.Parse(row["P3rdUpper"].ToString());
}
if (row["LeadBloodSpeed"] != null && row["LeadBloodSpeed"].ToString() != "")
{
model.LeadBloodSpeed = int.Parse(row["LeadBloodSpeed"].ToString());
}
if (row["LeadBloodTime"] != null && row["LeadBloodTime"].ToString() != "")
{
model.LeadBloodTime = int.Parse(row["LeadBloodTime"].ToString());
}
if (row["PaccDecrement"] != null && row["PaccDecrement"].ToString() != "")
{
model.PaccDecrement = int.Parse(row["PaccDecrement"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ALS.Model.treatmentmode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_treatmentmode(");
strSql.Append("name,BPSpeed,BPDirection,BPValid,FPSpeed,FPDirection,FPValid,DPSpeed,DPDirection,DPValid,RPSpeed,RPDirection,RPValid,FP2Speed,FP2Direction,FP2Valid,CPSpeed,CPDirection,CPValid,dehydrationSpeed,dehydrationValid,TargetTimeH,TargetTimeMin,IsTargetTime,TargetBP,IsTargetBP,TargetDP,IsTargetDP,TargetSP,IsTargetSP,TargetRP,IsTargetRP,TargetFP,IsTargetFP,Concentration,SP_Speed,SP_RapidInjectionValue,TargetT,PaccUpper,PaccLower,PartUpper,PartLower,PvenUpper,PvenLower,P1stUpper,P1stLower,P2ndUpper,P2ndLower,TmpUpper,TmpLower,PrePaccLower,PrePvenUpper,BloodLeak,P3rdLower,P3rdUpper,LeadBloodSpeed,LeadBloodTime,PaccDecrement)");
strSql.Append(" values (");
strSql.Append("@name,@BPSpeed,@BPDirection,@BPValid,@FPSpeed,@FPDirection,@FPValid,@DPSpeed,@DPDirection,@DPValid,@RPSpeed,@RPDirection,@RPValid,@FP2Speed,@FP2Direction,@FP2Valid,@CPSpeed,@CPDirection,@CPValid,@dehydrationSpeed,@dehydrationValid,@TargetTimeH,@TargetTimeMin,@IsTargetTime,@TargetBP,@IsTargetBP,@TargetDP,@IsTargetDP,@TargetSP,@IsTargetSP,@TargetRP,@IsTargetRP,@TargetFP,@IsTargetFP,@Concentration,@SP_Speed,@SP_RapidInjectionValue,@TargetT,@PaccUpper,@PaccLower,@PartUpper,@PartLower,@PvenUpper,@PvenLower,@P1stUpper,@P1stLower,@P2ndUpper,@P2ndLower,@TmpUpper,@TmpLower,@PrePaccLower,@PrePvenUpper,@BloodLeak,@P3rdLower,@P3rdUpper,@LeadBloodSpeed,@LeadBloodTime,@PaccDecrement)");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar, 255),
new MySqlParameter("@BPSpeed", MySqlDbType.Double),
new MySqlParameter("@BPDirection", MySqlDbType.Bit),
new MySqlParameter("@BPValid", MySqlDbType.Bit),
new MySqlParameter("@FPSpeed", MySqlDbType.Double),
new MySqlParameter("@FPDirection", MySqlDbType.Bit),
new MySqlParameter("@FPValid", MySqlDbType.Bit),
new MySqlParameter("@DPSpeed", MySqlDbType.Double),
new MySqlParameter("@DPDirection", MySqlDbType.Bit),
new MySqlParameter("@DPValid", MySqlDbType.Bit),
new MySqlParameter("@RPSpeed", MySqlDbType.Double),
new MySqlParameter("@RPDirection", MySqlDbType.Bit),
new MySqlParameter("@RPValid", MySqlDbType.Bit),
new MySqlParameter("@FP2Speed", MySqlDbType.Double),
new MySqlParameter("@FP2Direction", MySqlDbType.Bit),
new MySqlParameter("@FP2Valid", MySqlDbType.Bit),
new MySqlParameter("@CPSpeed", MySqlDbType.Double),
new MySqlParameter("@CPDirection", MySqlDbType.Bit),
new MySqlParameter("@CPValid", MySqlDbType.Bit),
new MySqlParameter("@dehydrationSpeed", MySqlDbType.Double),
new MySqlParameter("@dehydrationValid", MySqlDbType.Bit),
new MySqlParameter("@TargetTimeH", MySqlDbType.Int32, 11),
new MySqlParameter("@TargetTimeMin", MySqlDbType.Int32, 11),
new MySqlParameter("@IsTargetTime", MySqlDbType.Bit),
new MySqlParameter("@TargetBP", MySqlDbType.Double),
new MySqlParameter("@IsTargetBP", MySqlDbType.Bit),
new MySqlParameter("@TargetDP", MySqlDbType.Double),
new MySqlParameter("@IsTargetDP", MySqlDbType.Bit),
new MySqlParameter("@TargetSP", MySqlDbType.Double),
new MySqlParameter("@IsTargetSP", MySqlDbType.Bit),
new MySqlParameter("@TargetRP", MySqlDbType.Double),
new MySqlParameter("@IsTargetRP", MySqlDbType.Bit),
new MySqlParameter("@TargetFP", MySqlDbType.Double),
new MySqlParameter("@IsTargetFP", MySqlDbType.Bit),
new MySqlParameter("@Concentration", MySqlDbType.Double),
new MySqlParameter("@SP_Speed", MySqlDbType.Double),
new MySqlParameter("@SP_RapidInjectionValue", MySqlDbType.Double),
new MySqlParameter("@TargetT", MySqlDbType.Double),
new MySqlParameter("@PaccUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@PaccLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PartUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@PartLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PvenUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@PvenLower", MySqlDbType.Int32, 11),
new MySqlParameter("@P1stUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@P1stLower", MySqlDbType.Int32, 11),
new MySqlParameter("@P2ndUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@P2ndLower", MySqlDbType.Int32, 11),
new MySqlParameter("@TmpUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@TmpLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PrePaccLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PrePvenUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@BloodLeak", MySqlDbType.Int32, 11),
new MySqlParameter("@P3rdLower", MySqlDbType.Int32, 11),
new MySqlParameter("@P3rdUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@LeadBloodSpeed", MySqlDbType.Int32, 11),
new MySqlParameter("@LeadBloodTime", MySqlDbType.Int32, 11),
new MySqlParameter("@PaccDecrement", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.name;
parameters[1].Value = model.BPSpeed;
parameters[2].Value = model.BPDirection;
parameters[3].Value = model.BPValid;
parameters[4].Value = model.FPSpeed;
parameters[5].Value = model.FPDirection;
parameters[6].Value = model.FPValid;
parameters[7].Value = model.DPSpeed;
parameters[8].Value = model.DPDirection;
parameters[9].Value = model.DPValid;
parameters[10].Value = model.RPSpeed;
parameters[11].Value = model.RPDirection;
parameters[12].Value = model.RPValid;
parameters[13].Value = model.FP2Speed;
parameters[14].Value = model.FP2Direction;
parameters[15].Value = model.FP2Valid;
parameters[16].Value = model.CPSpeed;
parameters[17].Value = model.CPDirection;
parameters[18].Value = model.CPValid;
parameters[19].Value = model.dehydrationSpeed;
parameters[20].Value = model.dehydrationValid;
parameters[21].Value = model.TargetTimeH;
parameters[22].Value = model.TargetTimeMin;
parameters[23].Value = model.IsTargetTime;
parameters[24].Value = model.TargetBP;
parameters[25].Value = model.IsTargetBP;
parameters[26].Value = model.TargetDP;
parameters[27].Value = model.IsTargetDP;
parameters[28].Value = model.TargetSP;
parameters[29].Value = model.IsTargetSP;
parameters[30].Value = model.TargetRP;
parameters[31].Value = model.IsTargetRP;
parameters[32].Value = model.TargetFP;
parameters[33].Value = model.IsTargetFP;
parameters[34].Value = model.Concentration;
parameters[35].Value = model.SP_Speed;
parameters[36].Value = model.SP_RapidInjectionValue;
parameters[37].Value = model.TargetT;
parameters[38].Value = model.PaccUpper;
parameters[39].Value = model.PaccLower;
parameters[40].Value = model.PartUpper;
parameters[41].Value = model.PartLower;
parameters[42].Value = model.PvenUpper;
parameters[43].Value = model.PvenLower;
parameters[44].Value = model.P1stUpper;
parameters[45].Value = model.P1stLower;
parameters[46].Value = model.P2ndUpper;
parameters[47].Value = model.P2ndLower;
parameters[48].Value = model.TmpUpper;
parameters[49].Value = model.TmpLower;
parameters[50].Value = model.PrePaccLower;
parameters[51].Value = model.PrePvenUpper;
parameters[52].Value = model.BloodLeak;
parameters[53].Value = model.P3rdLower;
parameters[54].Value = model.P3rdUpper;
parameters[55].Value = model.LeadBloodSpeed;
parameters[56].Value = model.LeadBloodTime;
parameters[57].Value = model.PaccDecrement;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ALS.Model.treatmentmode model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_treatmentmode set ");
strSql.Append("name=@name,");
strSql.Append("BPSpeed=@BPSpeed,");
strSql.Append("BPDirection=@BPDirection,");
strSql.Append("BPValid=@BPValid,");
strSql.Append("FPSpeed=@FPSpeed,");
strSql.Append("FPDirection=@FPDirection,");
strSql.Append("FPValid=@FPValid,");
strSql.Append("DPSpeed=@DPSpeed,");
strSql.Append("DPDirection=@DPDirection,");
strSql.Append("DPValid=@DPValid,");
strSql.Append("RPSpeed=@RPSpeed,");
strSql.Append("RPDirection=@RPDirection,");
strSql.Append("RPValid=@RPValid,");
strSql.Append("FP2Speed=@FP2Speed,");
strSql.Append("FP2Direction=@FP2Direction,");
strSql.Append("FP2Valid=@FP2Valid,");
strSql.Append("CPSpeed=@CPSpeed,");
strSql.Append("CPDirection=@CPDirection,");
strSql.Append("CPValid=@CPValid,");
strSql.Append("dehydrationSpeed=@dehydrationSpeed,");
strSql.Append("dehydrationValid=@dehydrationValid,");
strSql.Append("TargetTimeH=@TargetTimeH,");
strSql.Append("TargetTimeMin=@TargetTimeMin,");
strSql.Append("IsTargetTime=@IsTargetTime,");
strSql.Append("TargetBP=@TargetBP,");
strSql.Append("IsTargetBP=@IsTargetBP,");
strSql.Append("TargetDP=@TargetDP,");
strSql.Append("IsTargetDP=@IsTargetDP,");
strSql.Append("TargetSP=@TargetSP,");
strSql.Append("IsTargetSP=@IsTargetSP,");
strSql.Append("TargetRP=@TargetRP,");
strSql.Append("IsTargetRP=@IsTargetRP,");
strSql.Append("TargetFP=@TargetFP,");
strSql.Append("IsTargetFP=@IsTargetFP,");
strSql.Append("Concentration=@Concentration,");
strSql.Append("SP_Speed=@SP_Speed,");
strSql.Append("SP_RapidInjectionValue=@SP_RapidInjectionValue,");
strSql.Append("TargetT=@TargetT,");
strSql.Append("PaccUpper=@PaccUpper,");
strSql.Append("PaccLower=@PaccLower,");
strSql.Append("PartUpper=@PartUpper,");
strSql.Append("PartLower=@PartLower,");
strSql.Append("PvenUpper=@PvenUpper,");
strSql.Append("PvenLower=@PvenLower,");
strSql.Append("P1stUpper=@P1stUpper,");
strSql.Append("P1stLower=@P1stLower,");
strSql.Append("P2ndUpper=@P2ndUpper,");
strSql.Append("P2ndLower=@P2ndLower,");
strSql.Append("TmpUpper=@TmpUpper,");
strSql.Append("TmpLower=@TmpLower,");
strSql.Append("PrePaccLower=@PrePaccLower,");
strSql.Append("PrePvenUpper=@PrePvenUpper,");
strSql.Append("BloodLeak=@BloodLeak,");
strSql.Append("PrePartUpper=@PrePartUpper,");
strSql.Append("P3rdLower=@P3rdLower,");
strSql.Append("P3rdUpper=@P3rdUpper,");
strSql.Append("LeadBloodSpeed=@LeadBloodSpeed,");
strSql.Append("LeadBloodTime=@LeadBloodTime,");
strSql.Append("PaccDecrement=@PaccDecrement");
strSql.Append(" where ID=@ID");
MySqlParameter[] parameters =
{
new MySqlParameter("@name", MySqlDbType.VarChar, 255),
new MySqlParameter("@BPSpeed", MySqlDbType.Double),
new MySqlParameter("@BPDirection", MySqlDbType.Bit),
new MySqlParameter("@BPValid", MySqlDbType.Bit),
new MySqlParameter("@FPSpeed", MySqlDbType.Double),
new MySqlParameter("@FPDirection", MySqlDbType.Bit),
new MySqlParameter("@FPValid", MySqlDbType.Bit),
new MySqlParameter("@DPSpeed", MySqlDbType.Double),
new MySqlParameter("@DPDirection", MySqlDbType.Bit),
new MySqlParameter("@DPValid", MySqlDbType.Bit),
new MySqlParameter("@RPSpeed", MySqlDbType.Double),
new MySqlParameter("@RPDirection", MySqlDbType.Bit),
new MySqlParameter("@RPValid", MySqlDbType.Bit),
new MySqlParameter("@FP2Speed", MySqlDbType.Double),
new MySqlParameter("@FP2Direction", MySqlDbType.Bit),
new MySqlParameter("@FP2Valid", MySqlDbType.Bit),
new MySqlParameter("@CPSpeed", MySqlDbType.Double),
new MySqlParameter("@CPDirection", MySqlDbType.Bit),
new MySqlParameter("@CPValid", MySqlDbType.Bit),
new MySqlParameter("@dehydrationSpeed", MySqlDbType.Double),
new MySqlParameter("@dehydrationValid", MySqlDbType.Bit),
new MySqlParameter("@TargetTimeH", MySqlDbType.Int32, 11),
new MySqlParameter("@TargetTimeMin", MySqlDbType.Int32, 11),
new MySqlParameter("@IsTargetTime", MySqlDbType.Bit),
new MySqlParameter("@TargetBP", MySqlDbType.Double),
new MySqlParameter("@IsTargetBP", MySqlDbType.Bit),
new MySqlParameter("@TargetDP", MySqlDbType.Double),
new MySqlParameter("@IsTargetDP", MySqlDbType.Bit),
new MySqlParameter("@TargetSP", MySqlDbType.Double),
new MySqlParameter("@IsTargetSP", MySqlDbType.Bit),
new MySqlParameter("@TargetRP", MySqlDbType.Double),
new MySqlParameter("@IsTargetRP", MySqlDbType.Bit),
new MySqlParameter("@TargetFP", MySqlDbType.Double),
new MySqlParameter("@IsTargetFP", MySqlDbType.Bit),
new MySqlParameter("@Concentration", MySqlDbType.Double),
new MySqlParameter("@SP_Speed", MySqlDbType.Double),
new MySqlParameter("@SP_RapidInjectionValue", MySqlDbType.Double),
new MySqlParameter("@TargetT", MySqlDbType.Double),
new MySqlParameter("@PaccUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@PaccLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PartUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@PartLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PvenUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@PvenLower", MySqlDbType.Int32, 11),
new MySqlParameter("@P1stUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@P1stLower", MySqlDbType.Int32, 11),
new MySqlParameter("@P2ndUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@P2ndLower", MySqlDbType.Int32, 11),
new MySqlParameter("@TmpUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@TmpLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PrePaccLower", MySqlDbType.Int32, 11),
new MySqlParameter("@PrePvenUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@BloodLeak", MySqlDbType.Int32, 11),
new MySqlParameter("@PrePartUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@P3rdLower", MySqlDbType.Int32, 11),
new MySqlParameter("@P3rdUpper", MySqlDbType.Int32, 11),
new MySqlParameter("@LeadBloodSpeed", MySqlDbType.Int32, 11),
new MySqlParameter("@LeadBloodTime", MySqlDbType.Int32, 11),
new MySqlParameter("@PaccDecrement", MySqlDbType.Int32, 11),
new MySqlParameter("@ID", MySqlDbType.Int32, 20)
};
parameters[0].Value = model.name;
parameters[1].Value = model.BPSpeed;
parameters[2].Value = model.BPDirection;
parameters[3].Value = model.BPValid;
parameters[4].Value = model.FPSpeed;
parameters[5].Value = model.FPDirection;
parameters[6].Value = model.FPValid;
parameters[7].Value = model.DPSpeed;
parameters[8].Value = model.DPDirection;
parameters[9].Value = model.DPValid;
parameters[10].Value = model.RPSpeed;
parameters[11].Value = model.RPDirection;
parameters[12].Value = model.RPValid;
parameters[13].Value = model.FP2Speed;
parameters[14].Value = model.FP2Direction;
parameters[15].Value = model.FP2Valid;
parameters[16].Value = model.CPSpeed;
parameters[17].Value = model.CPDirection;
parameters[18].Value = model.CPValid;
parameters[19].Value = model.dehydrationSpeed;
parameters[20].Value = model.dehydrationValid;
parameters[21].Value = model.TargetTimeH;
parameters[22].Value = model.TargetTimeMin;
parameters[23].Value = model.IsTargetTime;
parameters[24].Value = model.TargetBP;
parameters[25].Value = model.IsTargetBP;
parameters[26].Value = model.TargetDP;
parameters[27].Value = model.IsTargetDP;
parameters[28].Value = model.TargetSP;
parameters[29].Value = model.IsTargetSP;
parameters[30].Value = model.TargetRP;
parameters[31].Value = model.IsTargetRP;
parameters[32].Value = model.TargetFP;
parameters[33].Value = model.IsTargetFP;
parameters[34].Value = model.Concentration;
parameters[35].Value = model.SP_Speed;
parameters[36].Value = model.SP_RapidInjectionValue;
parameters[37].Value = model.TargetT;
parameters[38].Value = model.PaccUpper;
parameters[39].Value = model.PaccLower;
parameters[40].Value = model.PartUpper;
parameters[41].Value = model.PartLower;
parameters[42].Value = model.PvenUpper;
parameters[43].Value = model.PvenLower;
parameters[44].Value = model.P1stUpper;
parameters[45].Value = model.P1stLower;
parameters[46].Value = model.P2ndUpper;
parameters[47].Value = model.P2ndLower;
parameters[48].Value = model.TmpUpper;
parameters[49].Value = model.TmpLower;
parameters[50].Value = model.PrePaccLower;
parameters[51].Value = model.PrePvenUpper;
parameters[52].Value = model.BloodLeak;
parameters[53].Value = model.PrePartUpper;
parameters[54].Value = model.P3rdLower;
parameters[55].Value = model.P3rdUpper;
parameters[56].Value = model.LeadBloodSpeed;
parameters[57].Value = model.LeadBloodTime;
parameters[58].Value = model.PaccDecrement;
parameters[59].Value = model.ID;
int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
