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