/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_AbnormalData GetModel(DateTime DataTime, int PointID, int GeneID, int DataType, string AbnormalType) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 DataTime,PointID,GeneID,DataType,StateValue,DataValue,DataCouValue,ConvertValue,WriteTime,DevCode,Person,AuditTime,AbnormalLedger,AbnormalType from T_AbnormalData "); strSql.Append(" where DataTime=@DataTime and PointID=@PointID and GeneID=@GeneID and DataType=@DataType and AbnormalType=@AbnormalType "); SqlParameter[] parameters = { new SqlParameter("@DataTime", SqlDbType.DateTime), new SqlParameter("@PointID", SqlDbType.Int, 4), new SqlParameter("@GeneID", SqlDbType.Int, 4), new SqlParameter("@DataType", SqlDbType.Int, 4), new SqlParameter("@AbnormalType", SqlDbType.NVarChar, 25) }; parameters[0].Value = DataTime; parameters[1].Value = PointID; parameters[2].Value = GeneID; parameters[3].Value = DataType; parameters[4].Value = AbnormalType; Maticsoft.Model.T_AbnormalData model = new Maticsoft.Model.T_AbnormalData(); 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 bool Update(Maticsoft.Model.T_AbnormalData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_AbnormalData set "); strSql.Append("StateValue=@StateValue,"); strSql.Append("DataValue=@DataValue,"); strSql.Append("DataCouValue=@DataCouValue,"); strSql.Append("ConvertValue=@ConvertValue,"); strSql.Append("WriteTime=@WriteTime,"); strSql.Append("DevCode=@DevCode,"); strSql.Append("Person=@Person,"); strSql.Append("AuditTime=@AuditTime,"); strSql.Append("AbnormalLedger=@AbnormalLedger"); strSql.Append(" where DataTime=@DataTime and PointID=@PointID and GeneID=@GeneID and DataType=@DataType and AbnormalType=@AbnormalType "); SqlParameter[] parameters = { new SqlParameter("@StateValue", SqlDbType.NVarChar, 25), new SqlParameter("@DataValue", SqlDbType.Decimal, 9), new SqlParameter("@DataCouValue", SqlDbType.Decimal, 9), new SqlParameter("@ConvertValue", SqlDbType.Decimal, 9), new SqlParameter("@WriteTime", SqlDbType.DateTime), new SqlParameter("@DevCode", SqlDbType.NVarChar, 50), new SqlParameter("@Person", SqlDbType.NVarChar, 50), new SqlParameter("@AuditTime", SqlDbType.DateTime), new SqlParameter("@AbnormalLedger", SqlDbType.Int, 4), new SqlParameter("@DataTime", SqlDbType.DateTime), new SqlParameter("@PointID", SqlDbType.Int, 4), new SqlParameter("@GeneID", SqlDbType.Int, 4), new SqlParameter("@DataType", SqlDbType.Int, 4), new SqlParameter("@AbnormalType", SqlDbType.NVarChar, 25) }; parameters[0].Value = model.StateValue; parameters[1].Value = model.DataValue; parameters[2].Value = model.DataCouValue; parameters[3].Value = model.ConvertValue; parameters[4].Value = model.WriteTime; parameters[5].Value = model.DevCode; parameters[6].Value = model.Person; parameters[7].Value = model.AuditTime; parameters[8].Value = model.AbnormalLedger; parameters[9].Value = model.DataTime; parameters[10].Value = model.PointID; parameters[11].Value = model.GeneID; parameters[12].Value = model.DataType; parameters[13].Value = model.AbnormalType; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(Maticsoft.Model.T_AbnormalData model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into T_AbnormalData("); strSql.Append("DataTime,PointID,GeneID,DataType,StateValue,DataValue,DataCouValue,ConvertValue,WriteTime,DevCode,Person,AuditTime,AbnormalLedger,AbnormalType)"); strSql.Append(" values ("); strSql.Append("@DataTime,@PointID,@GeneID,@DataType,@StateValue,@DataValue,@DataCouValue,@ConvertValue,@WriteTime,@DevCode,@Person,@AuditTime,@AbnormalLedger,@AbnormalType)"); SqlParameter[] parameters = { new SqlParameter("@DataTime", SqlDbType.DateTime), new SqlParameter("@PointID", SqlDbType.Int, 4), new SqlParameter("@GeneID", SqlDbType.Int, 4), new SqlParameter("@DataType", SqlDbType.Int, 4), new SqlParameter("@StateValue", SqlDbType.NVarChar, 25), new SqlParameter("@DataValue", SqlDbType.Decimal, 9), new SqlParameter("@DataCouValue", SqlDbType.Decimal, 9), new SqlParameter("@ConvertValue", SqlDbType.Decimal, 9), new SqlParameter("@WriteTime", SqlDbType.DateTime), new SqlParameter("@DevCode", SqlDbType.NVarChar, 50), new SqlParameter("@Person", SqlDbType.NVarChar, 50), new SqlParameter("@AuditTime", SqlDbType.DateTime), new SqlParameter("@AbnormalLedger", SqlDbType.Int, 4), new SqlParameter("@AbnormalType", SqlDbType.NVarChar, 25) }; parameters[0].Value = model.DataTime; parameters[1].Value = model.PointID; parameters[2].Value = model.GeneID; parameters[3].Value = model.DataType; parameters[4].Value = model.StateValue; parameters[5].Value = model.DataValue; parameters[6].Value = model.DataCouValue; parameters[7].Value = model.ConvertValue; parameters[8].Value = model.WriteTime; parameters[9].Value = model.DevCode; parameters[10].Value = model.Person; parameters[11].Value = model.AuditTime; parameters[12].Value = model.AbnormalLedger; parameters[13].Value = model.AbnormalType; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.T_AbnormalData DataRowToModel(DataRow row) { Maticsoft.Model.T_AbnormalData model = new Maticsoft.Model.T_AbnormalData(); if (row != null) { if (row["DataTime"] != null && row["DataTime"].ToString() != "") { model.DataTime = DateTime.Parse(row["DataTime"].ToString()); } if (row["PointID"] != null && row["PointID"].ToString() != "") { model.PointID = int.Parse(row["PointID"].ToString()); } if (row["GeneID"] != null && row["GeneID"].ToString() != "") { model.GeneID = int.Parse(row["GeneID"].ToString()); } if (row["DataType"] != null && row["DataType"].ToString() != "") { model.DataType = int.Parse(row["DataType"].ToString()); } if (row["StateValue"] != null) { model.StateValue = row["StateValue"].ToString(); } if (row["DataValue"] != null && row["DataValue"].ToString() != "") { model.DataValue = decimal.Parse(row["DataValue"].ToString()); } if (row["DataCouValue"] != null && row["DataCouValue"].ToString() != "") { model.DataCouValue = decimal.Parse(row["DataCouValue"].ToString()); } if (row["ConvertValue"] != null && row["ConvertValue"].ToString() != "") { model.ConvertValue = decimal.Parse(row["ConvertValue"].ToString()); } if (row["WriteTime"] != null && row["WriteTime"].ToString() != "") { model.WriteTime = DateTime.Parse(row["WriteTime"].ToString()); } if (row["DevCode"] != null) { model.DevCode = row["DevCode"].ToString(); } if (row["Person"] != null) { model.Person = row["Person"].ToString(); } if (row["AuditTime"] != null && row["AuditTime"].ToString() != "") { model.AuditTime = DateTime.Parse(row["AuditTime"].ToString()); } if (row["AbnormalLedger"] != null && row["AbnormalLedger"].ToString() != "") { model.AbnormalLedger = int.Parse(row["AbnormalLedger"].ToString()); } if (row["AbnormalType"] != null) { model.AbnormalType = row["AbnormalType"].ToString(); } } return(model); }