/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Models.reflow model)
{
string strSql;
if (model.target == "1")
{
strSql = @"update reflow set target1 ='@target1',target2='@target2' where `group`='@group' and line='@line'";
strSql = strSql.Replace("@group", model.group);
strSql = strSql.Replace("@line", model.line);
strSql = strSql.Replace("@target1", model.target1);
strSql = strSql.Replace("@target2", model.target2);
}
else
{
strSql = @"update reflow set maxTemperature='@maxTemperature',elapseTime='@elapseTime' where step='@step' and `group`='@group' and line='@line'";
strSql = strSql.Replace("@step", model.step);
strSql = strSql.Replace("@group", model.group);
strSql = strSql.Replace("@line", model.line);
strSql = strSql.Replace("@maxTemperature", model.maxTemperature);
strSql = strSql.Replace("@elapseTime", model.elapseTime);
}
int rows = MySqlHelper.ExecuteNonQuery(_connStr, strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Models.reflow model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into reflow( ");
strSql.Append("step,`group`,line,maxTemperature,elapseTime,target1,target2 ) ");
strSql.Append(" values (");
strSql.Append(" '@step','@group','@line','@maxTemperature','@elapseTime','@target1','@target2') ");
strSql.Replace("@step", model.step);
strSql.Replace("@group", model.group);
strSql.Replace("@line", model.line);
strSql.Replace("@maxTemperature", model.maxTemperature);
strSql.Replace("@elapseTime", model.elapseTime);
strSql.Replace("@target1", model.target1);
strSql.Replace("@target2", model.target2);
int rows = MySqlHelper.ExecuteNonQuery(_connStr, strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public DataTable GetTarget(Models.reflow model)
{
string strSql;
strSql = "SELECT target1, target2 FROM reflow where `group`='{0}' and line='{1}' ";
strSql = string.Format(strSql, model.group, model.line);
DataTable dt = MySqlHelper.ExecuteDataset(_connStr, strSql).Tables[0];
return(dt);
}
/// <summary>
/// ajax插入数据
/// </summary>
public void insertDataja(string data, string target)
{
JArray ja = (JArray)JsonConvert.DeserializeObject(data);
//string ja1a = ja[1]["line"].ToString();
foreach (var ja1 in ja)
{
Models.reflow refmodle = new Models.reflow()
{
target = target,
step = ja1["step"].ToString(),
group = ja1["group"].ToString(),
line = ja1["line"].ToString(),
maxTemperature = ja1["maxTemperature"].ToString(),
elapseTime = ja1["elapseTime"].ToString(),
};
//if (target == "1")
//{
// refmodle.step = "";
//}
if (!Exists(refmodle.target, refmodle.step, refmodle.group, refmodle.line))
{
if (target == "1")
{
refmodle.target1 = refmodle.maxTemperature;
refmodle.target2 = refmodle.elapseTime;
refmodle.maxTemperature = "";
refmodle.elapseTime = "";
}
else
{
DataTable tb = Idal.GetTarget(refmodle);
refmodle.target1 = tb.Rows[0][0].ToString();
refmodle.target2 = tb.Rows[0][1].ToString();
}
Add(refmodle);
}
else
{
if (target == "1")
{
refmodle.target1 = refmodle.maxTemperature;
refmodle.target2 = refmodle.elapseTime;
}
else
{
DataTable tb = Idal.GetTarget(refmodle);
refmodle.target1 = tb.Rows[0][0].ToString();
refmodle.target2 = tb.Rows[0][1].ToString();
}
Update(refmodle);
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Models.reflow model)
{
return(Idal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Models.reflow model)
{
return(Idal.Add(model));
}
