public ActionResult EditVehicleSensor(VehicleSensorEditModel model) { return(Json(VehicleSensorBLL.EditVehicleSensors(model), JsonRequestBehavior.AllowGet)); }
public static OperationResult EditVehicleSensors(VehicleSensorEditModel model) { string sqlSel = "SELECT COUNT(0) FROM dbo.VehicleSensor WHERE VehicleID=@vehicleID AND SensorType=@sensorType"; List <SqlParameter> parasSel = new List <SqlParameter>() { new SqlParameter("@vehicleID", SqlDbType.BigInt), new SqlParameter("@sensorType", SqlDbType.Int), }; parasSel[0].Value = model.VehicleID; parasSel[1].Value = model.TypeID; var resultSel = MSSQLHelper.ExecuteScalar(CommandType.Text, sqlSel, parasSel.ToArray()); int count = int.Parse(resultSel.ToString()); if (count > 0) { string sqlEdit = @"UPDATE dbo.VehicleSensor SET Value1 = @value1 , Value2 = @value2 , WarrantyDate = @warrantyDate WHERE VehicleID=@vehicleID AND SensorType=@sensorType"; List <SqlParameter> parasEdit = new List <SqlParameter>() { new SqlParameter("@value1", SqlDbType.Float), new SqlParameter("@value2", SqlDbType.Float), new SqlParameter("@warrantyDate", SqlDbType.DateTime), new SqlParameter("@vehicleID", SqlDbType.BigInt), new SqlParameter("@sensorType", SqlDbType.Int), }; if (model.Value1 == null) { parasEdit[0].Value = DBNull.Value; } else { parasEdit[0].Value = double.Parse(model.Value1.ToString()); } if (model.Value2 == null) { parasEdit[1].Value = DBNull.Value; } else { parasEdit[1].Value = double.Parse(model.Value2.ToString()); } //parasEdit[0].Value = double.Parse(model.Value1.ToString()); //parasEdit[1].Value = double.Parse(model.Value2.ToString()); parasEdit[2].Value = model.WarrantyDate; parasEdit[3].Value = model.VehicleID; parasEdit[4].Value = model.TypeID; int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sqlEdit, parasEdit.ToArray()); string msg = string.Empty; switch (result) { case 1: msg = PromptInformation.OperationSuccess; break; case 0: msg = PromptInformation.NotExists; break; case -1: msg = PromptInformation.DBError; break; } return(new OperationResult() { Success = result > 0, Message = msg }); } else { string sqlAdd = @"INSERT INTO dbo.VehicleSensor ( VehicleID , SensorType , Value1 , Value2 , WarrantyDate ) VALUES ( @vehicleID , @sensorType, @value1, @value2, @warrantyDate )"; List <SqlParameter> parasAdd = new List <SqlParameter>() { new SqlParameter("@vehicleID", SqlDbType.BigInt), new SqlParameter("@sensorType", SqlDbType.Int), new SqlParameter("@value1", SqlDbType.Float), new SqlParameter("@value2", SqlDbType.Float), new SqlParameter("@warrantyDate", SqlDbType.DateTime), }; parasAdd[0].Value = model.VehicleID; parasAdd[1].Value = model.TypeID; if (model.Value1 == null) { parasAdd[2].Value = DBNull.Value; } else { parasAdd[2].Value = double.Parse(model.Value1.ToString()); } if (model.Value2 == null) { parasAdd[3].Value = DBNull.Value; } else { parasAdd[3].Value = double.Parse(model.Value2.ToString()); } parasAdd[4].Value = model.WarrantyDate; bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sqlAdd, parasAdd.ToArray()) > 0; return(new OperationResult() { Success = result, Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError }); } }