/// <summary> /// 更新一条数据 /// </summary> public bool Update(FTDataAccess.Model.LOCAL_MES_STEP_INFOModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update LOCAL_MES_STEP_INFO set "); strSql.Append("SERIAL_NUMBER=@SERIAL_NUMBER,"); strSql.Append("STEP_NUMBER=@STEP_NUMBER,"); strSql.Append("CHECK_RESULT=@CHECK_RESULT,"); strSql.Append("STEP_MARK=@STEP_MARK,"); strSql.Append("STATUS=@STATUS,"); strSql.Append("TRX_TIME=@TRX_TIME,"); strSql.Append("LAST_MODIFY_TIME=@LAST_MODIFY_TIME,"); strSql.Append("DEFECT_CODES=@DEFECT_CODES,"); strSql.Append("USER_NAME=@USER_NAME,"); strSql.Append("REASON=@REASON,"); strSql.Append("UPLOAD_FLAG=@UPLOAD_FLAG,"); strSql.Append("AutoStationName=@AutoStationName"); strSql.Append(" where RECID=@RECID "); SqlParameter[] parameters = { new SqlParameter("@SERIAL_NUMBER", SqlDbType.NVarChar, 255), new SqlParameter("@STEP_NUMBER", SqlDbType.NVarChar, 255), new SqlParameter("@CHECK_RESULT", SqlDbType.Int, 4), new SqlParameter("@STEP_MARK", SqlDbType.Int, 4), new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@TRX_TIME", SqlDbType.DateTime), new SqlParameter("@LAST_MODIFY_TIME", SqlDbType.DateTime), new SqlParameter("@DEFECT_CODES", SqlDbType.NVarChar, 255), new SqlParameter("@USER_NAME", SqlDbType.NVarChar, 255), new SqlParameter("@REASON", SqlDbType.NVarChar, 2000), new SqlParameter("@UPLOAD_FLAG", SqlDbType.Bit, 1), new SqlParameter("@AutoStationName", SqlDbType.NVarChar, 50), new SqlParameter("@RECID", SqlDbType.NVarChar, 255) }; parameters[0].Value = model.SERIAL_NUMBER; parameters[1].Value = model.STEP_NUMBER; parameters[2].Value = model.CHECK_RESULT; parameters[3].Value = model.STEP_MARK; parameters[4].Value = model.STATUS; parameters[5].Value = model.TRX_TIME; parameters[6].Value = model.LAST_MODIFY_TIME; parameters[7].Value = model.DEFECT_CODES; parameters[8].Value = model.USER_NAME; parameters[9].Value = model.REASON; parameters[10].Value = model.UPLOAD_FLAG; parameters[11].Value = model.AutoStationName; parameters[12].Value = model.RECID; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(FTDataAccess.Model.LOCAL_MES_STEP_INFOModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into LOCAL_MES_STEP_INFO("); strSql.Append("RECID,SERIAL_NUMBER,STEP_NUMBER,CHECK_RESULT,STEP_MARK,STATUS,TRX_TIME,LAST_MODIFY_TIME,DEFECT_CODES,USER_NAME,REASON,UPLOAD_FLAG,AutoStationName)"); strSql.Append(" values ("); strSql.Append("@RECID,@SERIAL_NUMBER,@STEP_NUMBER,@CHECK_RESULT,@STEP_MARK,@STATUS,@TRX_TIME,@LAST_MODIFY_TIME,@DEFECT_CODES,@USER_NAME,@REASON,@UPLOAD_FLAG,@AutoStationName)"); SqlParameter[] parameters = { new SqlParameter("@RECID", SqlDbType.NVarChar, 255), new SqlParameter("@SERIAL_NUMBER", SqlDbType.NVarChar, 255), new SqlParameter("@STEP_NUMBER", SqlDbType.NVarChar, 255), new SqlParameter("@CHECK_RESULT", SqlDbType.Int, 4), new SqlParameter("@STEP_MARK", SqlDbType.Int, 4), new SqlParameter("@STATUS", SqlDbType.Int, 4), new SqlParameter("@TRX_TIME", SqlDbType.DateTime), new SqlParameter("@LAST_MODIFY_TIME", SqlDbType.DateTime), new SqlParameter("@DEFECT_CODES", SqlDbType.NVarChar, 255), new SqlParameter("@USER_NAME", SqlDbType.NVarChar, 255), new SqlParameter("@REASON", SqlDbType.NVarChar, 2000), new SqlParameter("@UPLOAD_FLAG", SqlDbType.Bit, 1), new SqlParameter("@AutoStationName", SqlDbType.NVarChar, 50) }; parameters[0].Value = model.RECID; parameters[1].Value = model.SERIAL_NUMBER; parameters[2].Value = model.STEP_NUMBER; parameters[3].Value = model.CHECK_RESULT; parameters[4].Value = model.STEP_MARK; parameters[5].Value = model.STATUS; parameters[6].Value = model.TRX_TIME; parameters[7].Value = model.LAST_MODIFY_TIME; parameters[8].Value = model.DEFECT_CODES; parameters[9].Value = model.USER_NAME; parameters[10].Value = model.REASON; parameters[11].Value = model.UPLOAD_FLAG; parameters[12].Value = model.AutoStationName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FTDataAccess.Model.LOCAL_MES_STEP_INFOModel GetModel(string RECID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 RECID,SERIAL_NUMBER,STEP_NUMBER,CHECK_RESULT,STEP_MARK,STATUS,TRX_TIME,LAST_MODIFY_TIME,DEFECT_CODES,USER_NAME,REASON,UPLOAD_FLAG,AutoStationName from LOCAL_MES_STEP_INFO "); strSql.Append(" where RECID=@RECID "); SqlParameter[] parameters = { new SqlParameter("@RECID", SqlDbType.NVarChar, 255) }; parameters[0].Value = RECID; FTDataAccess.Model.LOCAL_MES_STEP_INFOModel model = new FTDataAccess.Model.LOCAL_MES_STEP_INFOModel(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public FTDataAccess.Model.LOCAL_MES_STEP_INFOModel DataRowToModel(DataRow row) { FTDataAccess.Model.LOCAL_MES_STEP_INFOModel model = new FTDataAccess.Model.LOCAL_MES_STEP_INFOModel(); if (row != null) { if (row["RECID"] != null) { model.RECID = row["RECID"].ToString(); } if (row["SERIAL_NUMBER"] != null) { model.SERIAL_NUMBER = row["SERIAL_NUMBER"].ToString(); } if (row["STEP_NUMBER"] != null) { model.STEP_NUMBER = row["STEP_NUMBER"].ToString(); } if (row["CHECK_RESULT"] != null && row["CHECK_RESULT"].ToString() != "") { model.CHECK_RESULT = int.Parse(row["CHECK_RESULT"].ToString()); } if (row["STEP_MARK"] != null && row["STEP_MARK"].ToString() != "") { model.STEP_MARK = int.Parse(row["STEP_MARK"].ToString()); } if (row["STATUS"] != null && row["STATUS"].ToString() != "") { model.STATUS = int.Parse(row["STATUS"].ToString()); } if (row["TRX_TIME"] != null && row["TRX_TIME"].ToString() != "") { model.TRX_TIME = DateTime.Parse(row["TRX_TIME"].ToString()); } if (row["LAST_MODIFY_TIME"] != null && row["LAST_MODIFY_TIME"].ToString() != "") { model.LAST_MODIFY_TIME = DateTime.Parse(row["LAST_MODIFY_TIME"].ToString()); } if (row["DEFECT_CODES"] != null) { model.DEFECT_CODES = row["DEFECT_CODES"].ToString(); } if (row["USER_NAME"] != null) { model.USER_NAME = row["USER_NAME"].ToString(); } if (row["REASON"] != null) { model.REASON = row["REASON"].ToString(); } if (row["UPLOAD_FLAG"] != null && row["UPLOAD_FLAG"].ToString() != "") { if ((row["UPLOAD_FLAG"].ToString() == "1") || (row["UPLOAD_FLAG"].ToString().ToLower() == "true")) { model.UPLOAD_FLAG = true; } else { model.UPLOAD_FLAG = false; } } if (row["AutoStationName"] != null) { model.AutoStationName = row["AutoStationName"].ToString(); } } return(model); }