/// <summary> /// 得到一个对象实体 /// </summary> public SqliteHelper.Model.Asset GetModel(int OrderNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select OrderNo,Name,BM,Type,AssetTM,AssetModel,LabelId,RfidId,State,UseUnit,Purpose,MaintenanceState,MaintenanceUnit,MaintenanceDeadline,CabinetNo,StartLayer,UsedLayer,UsedPower,UsedWeight,UsedPowerPort,UsedNetPort from Asset "); strSql.Append(" where OrderNo=@OrderNo "); SQLiteParameter[] parameters = { new SQLiteParameter("@OrderNo", DbType.Int32, 4) }; parameters[0].Value = OrderNo; SqliteHelper.Model.Asset model = new SqliteHelper.Model.Asset(); DataTable dt = SQLiteHelper.ExecuteDataTable(strSql.ToString(), parameters); if (dt.Rows.Count > 0) { return(DataRowToModel(dt.Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(SqliteHelper.Model.Asset model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Asset set "); strSql.Append("Name=@Name,"); strSql.Append("BM=@BM,"); strSql.Append("Type=@Type,"); strSql.Append("AssetTM=@AssetTM,"); strSql.Append("AssetModel=@AssetModel,"); strSql.Append("LabelId=@LabelId,"); strSql.Append("RfidId=@RfidId,"); strSql.Append("State=@State,"); strSql.Append("UseUnit=@UseUnit,"); strSql.Append("Purpose=@Purpose,"); strSql.Append("MaintenanceState=@MaintenanceState,"); strSql.Append("MaintenanceUnit=@MaintenanceUnit,"); strSql.Append("MaintenanceDeadline=@MaintenanceDeadline,"); strSql.Append("CabinetNo=@CabinetNo,"); strSql.Append("StartLayer=@StartLayer,"); strSql.Append("UsedLayer=@UsedLayer,"); strSql.Append("UsedPower=@UsedPower,"); strSql.Append("UsedWeight=@UsedWeight,"); strSql.Append("UsedPowerPort=@UsedPowerPort,"); strSql.Append("UsedNetPort=@UsedNetPort"); strSql.Append(" where OrderNo=@OrderNo "); SQLiteParameter[] parameters = { new SQLiteParameter("@Name", DbType.String), new SQLiteParameter("@BM", DbType.String), new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@AssetTM", DbType.String), new SQLiteParameter("@AssetModel", DbType.String), new SQLiteParameter("@LabelId", DbType.String), new SQLiteParameter("@RfidId", DbType.String), new SQLiteParameter("@State", DbType.String), new SQLiteParameter("@UseUnit", DbType.String), new SQLiteParameter("@Purpose", DbType.String), new SQLiteParameter("@MaintenanceState", DbType.String), new SQLiteParameter("@MaintenanceUnit", DbType.String), new SQLiteParameter("@MaintenanceDeadline", DbType.DateTime), new SQLiteParameter("@CabinetNo", DbType.Int32, 4), new SQLiteParameter("@StartLayer", DbType.Int32, 4), new SQLiteParameter("@UsedLayer", DbType.Int32, 4), new SQLiteParameter("@UsedPower", DbType.Decimal, 8), new SQLiteParameter("@UsedWeight", DbType.Decimal, 8), new SQLiteParameter("@UsedPowerPort", DbType.Int32, 4), new SQLiteParameter("@UsedNetPort", DbType.Int32, 4), new SQLiteParameter("@OrderNo", DbType.Int32, 4) }; parameters[0].Value = model.Name; parameters[1].Value = model.BM; parameters[2].Value = model.Type; parameters[3].Value = model.AssetTM; parameters[4].Value = model.AssetModel; parameters[5].Value = model.LabelId; parameters[6].Value = model.RfidId; parameters[7].Value = model.State; parameters[8].Value = model.UseUnit; parameters[9].Value = model.Purpose; parameters[10].Value = model.MaintenanceState; parameters[11].Value = model.MaintenanceUnit; parameters[12].Value = model.MaintenanceDeadline; parameters[13].Value = model.CabinetNo; parameters[14].Value = model.StartLayer; parameters[15].Value = model.UsedLayer; parameters[16].Value = model.UsedPower; parameters[17].Value = model.UsedWeight; parameters[18].Value = model.UsedPowerPort; parameters[19].Value = model.UsedNetPort; parameters[20].Value = model.OrderNo; int rows = SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SqliteHelper.Model.Asset DataRowToModel(DataRow row) { SqliteHelper.Model.Asset model = new SqliteHelper.Model.Asset(); if (row != null) { if (row["OrderNo"] != null) { model.OrderNo = int.Parse(row["OrderNo"].ToString()); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["BM"] != null) { model.BM = row["BM"].ToString(); } if (row["Type"] != null) { model.Type = row["Type"].ToString(); } if (row["AssetTM"] != null) { model.AssetTM = row["AssetTM"].ToString(); } if (row["AssetModel"] != null) { model.AssetModel = row["AssetModel"].ToString(); } if (row["LabelId"] != null) { model.LabelId = row["LabelId"].ToString(); } if (row["RfidId"] != null) { model.RfidId = row["RfidId"].ToString(); } if (row["State"] != null) { model.State = row["State"].ToString(); } if (row["UseUnit"] != null) { model.UseUnit = row["UseUnit"].ToString(); } if (row["Purpose"] != null) { model.Purpose = row["Purpose"].ToString(); } if (row["MaintenanceState"] != null) { model.MaintenanceState = row["MaintenanceState"].ToString(); } if (row["MaintenanceUnit"] != null) { model.MaintenanceUnit = row["MaintenanceUnit"].ToString(); } if (row["MaintenanceDeadline"] != null && row["MaintenanceDeadline"].ToString() != "") { model.MaintenanceDeadline = DateTime.Parse(row["MaintenanceDeadline"].ToString()); } if (row["CabinetNo"] != null && row["CabinetNo"].ToString() != "") { model.CabinetNo = int.Parse(row["CabinetNo"].ToString()); } if (row["StartLayer"] != null && row["StartLayer"].ToString() != "") { model.StartLayer = int.Parse(row["StartLayer"].ToString()); } if (row["UsedLayer"] != null && row["UsedLayer"].ToString() != "") { model.UsedLayer = int.Parse(row["UsedLayer"].ToString()); } if (row["UsedPower"] != null && row["UsedPower"].ToString() != "") { model.UsedPower = decimal.Parse(row["UsedPower"].ToString()); } if (row["UsedWeight"] != null && row["UsedWeight"].ToString() != "") { model.UsedWeight = decimal.Parse(row["UsedWeight"].ToString()); } if (row["UsedPowerPort"] != null && row["UsedPowerPort"].ToString() != "") { model.UsedPowerPort = int.Parse(row["UsedPowerPort"].ToString()); } if (row["UsedNetPort"] != null && row["UsedNetPort"].ToString() != "") { model.UsedNetPort = int.Parse(row["UsedNetPort"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(SqliteHelper.Model.Asset model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Asset("); strSql.Append("OrderNo,Name,BM,Type,AssetTM,AssetModel,LabelId,RfidId,State,UseUnit,Purpose,MaintenanceState,MaintenanceUnit,MaintenanceDeadline,CabinetNo,StartLayer,UsedLayer,UsedPower,UsedWeight,UsedPowerPort,UsedNetPort)"); strSql.Append(" values ("); strSql.Append("@OrderNo,@Name,@BM,@Type,@AssetTM,@AssetModel,@LabelId,@RfidId,@State,@UseUnit,@Purpose,@MaintenanceState,@MaintenanceUnit,@MaintenanceDeadline,@CabinetNo,@StartLayer,@UsedLayer,@UsedPower,@UsedWeight,@UsedPowerPort,@UsedNetPort)"); SQLiteParameter[] parameters = { new SQLiteParameter("@OrderNo", DbType.Int32, 4), new SQLiteParameter("@Name", DbType.String), new SQLiteParameter("@BM", DbType.String), new SQLiteParameter("@Type", DbType.String), new SQLiteParameter("@AssetTM", DbType.String), new SQLiteParameter("@AssetModel", DbType.String), new SQLiteParameter("@LabelId", DbType.String), new SQLiteParameter("@RfidId", DbType.String), new SQLiteParameter("@State", DbType.String), new SQLiteParameter("@UseUnit", DbType.String), new SQLiteParameter("@Purpose", DbType.String), new SQLiteParameter("@MaintenanceState", DbType.String), new SQLiteParameter("@MaintenanceUnit", DbType.String), new SQLiteParameter("@MaintenanceDeadline", DbType.DateTime), new SQLiteParameter("@CabinetNo", DbType.Int32, 4), new SQLiteParameter("@StartLayer", DbType.Int32, 4), new SQLiteParameter("@UsedLayer", DbType.Int32, 4), new SQLiteParameter("@UsedPower", DbType.Decimal, 8), new SQLiteParameter("@UsedWeight", DbType.Decimal, 8), new SQLiteParameter("@UsedPowerPort", DbType.Int32, 4), new SQLiteParameter("@UsedNetPort", DbType.Int32, 4) }; parameters[0].Value = model.OrderNo; parameters[1].Value = model.Name; parameters[2].Value = model.BM; parameters[3].Value = model.Type; parameters[4].Value = model.AssetTM; parameters[5].Value = model.AssetModel; parameters[6].Value = model.LabelId; parameters[7].Value = model.RfidId; parameters[8].Value = model.State; parameters[9].Value = model.UseUnit; parameters[10].Value = model.Purpose; parameters[11].Value = model.MaintenanceState; parameters[12].Value = model.MaintenanceUnit; parameters[13].Value = model.MaintenanceDeadline; parameters[14].Value = model.CabinetNo; parameters[15].Value = model.StartLayer; parameters[16].Value = model.UsedLayer; parameters[17].Value = model.UsedPower; parameters[18].Value = model.UsedWeight; parameters[19].Value = model.UsedPowerPort; parameters[20].Value = model.UsedNetPort; int rows = SQLiteHelper.ExecuteNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }